Indexing problem - greenhopper

[TothJ]

Hi, we started to use Jira Agile (greenhopper) recently on Jira 6.1.6 - when we try to reindex Jira there is this in the logfile:

2014-08-26 23:27:59,734 JiraTaskExectionThread-1 WARN akos 1406x74891x1 k6ksrr 172.20.2.17 /secure/admin/jira/IndexReIndex.jspa [atlassian.jira.index.AccumulatingResultBuilder] java.util.concurrent.ExecutionException: com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly one rank row for issue[id=396365] for rank field[id=12941], but found 2 rows

The indexing continues, but it is considered failed:

2014-08-27 07:40:36,269 IssueIndexer:thread-3 INFO akos 1406x74891x1 k6ksrr 172.20.2.17 /secure/admin/jira/IndexReIndex.jspa [action.admin.index.IndexAdminImpl] Re-indexing is 98% complete. Current index: Issue

2014-08-27 07:45:01,741 IssueIndexer:thread-3 INFO akos 1406x74891x1 k6ksrr 172.20.2.17 /secure/admin/jira/IndexReIndex.jspa [action.admin.index.IndexAdminImpl] Re-indexing is 99% complete. Current index: Issue

2014-08-27 07:46:46,696 JiraTaskExectionThread-1 ERROR akos 1406x74891x1 k6ksrr 172.20.2.17 /secure/admin/jira/IndexReIndex.jspa [jira.util.index.CompositeIndexLifecycleManager] Reindex All FAILED. Indexer: DefaultIndexManager: paths: [/home/jira/atlassian/application-data/jira/caches/indexes/comments, /home/jira/atlassian/application-data/jira/caches/indexes/issues, /home/jira/atlassian/application-data/jira/caches/indexes/changes]

com.atlassian.jira.index.IndexingFailureException: Indexing completed with 1 errors

at com.atlassian.jira.index.AccumulatingResultBuilder$CompositeResult. await(AccumulatingResultBuilder.java:147)

at com.atlassian.jira.issue.index.DefaultIndexManager. doIndexIssuesInBatchMode(DefaultIndexManager.java:877)

at com.atlassian.jira.issue.index.DefaultIndexManager. doStopTheWorldReindex(DefaultIndexManager.java:844)

at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexAll(DefaultIndexManager.java:307)

...

2014-08-27 07:46:46,704 JiraTaskExectionThread-1 INFO akos 1406x74891x1 k6ksrr 172.20.2.17 /secure/admin/jira/IndexReIndex.jspa [action.admin.index.IndexAdminImpl] Re-indexing finished

Any idea how to solve the problem?

[TothJ · Accepted solution]

Actially, I had to delete a row from the database:

https://confluence.atlassian.com/display/AGILEKB/Indexing+Failed+with+RuntimeException+Expected+exactly+one+rank

[Diego Zarpelon]

Hey Toth.

Which JIRA and JAVA versions are you running? There is a know bug when you are using JAVA 7 with JIRA 6.1.7,6.2,6.2.1

If you can take a look on it as it have some workarounds that can help you.

[TothJ]

we run 6.1.5 with the bundled Java 7_25 VM. This is a diffferent exception, but maybe its the same thing. We'll try...