Error indexing issue XXX-703: Dropped: [customfield_11260]

[Anas Ibrahim]

After imported the Backup i can't make a rebuild Index , he repeat the Dropping 'customfield_11260' for all the Issue until he finished he provide massage that index is field.

The custom field named Rank and is locked and there is no issue used this Field .

I tried to update all the Plugin and remove the directory $JIRA_HOME\caches\indexes and let him to build new one but also same Error 

Jira Software 7.13.4

11260]
2019-10-14 16:21:48,210 IssueIndexer:thread-7 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue CAAZWEI-183: Dropping 'customfield_11260'
2019-10-14 16:21:48,217 IssueIndexer:thread-7 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue CAAZWEI-183: Dropped: [customfield_11260]
2019-10-14 16:21:48,257 IssueIndexer:thread-3 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2685: Dropping 'customfield_11260'
2019-10-14 16:21:48,259 IssueIndexer:thread-1 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ETSYS-4325: Dropping 'customfield_11260'
2019-10-14 16:21:48,265 IssueIndexer:thread-3 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2685: Dropped: [customfield_11260]
2019-10-14 16:21:48,267 IssueIndexer:thread-2 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue DTRVPOC-87: Dropping 'customfield_11260'
2019-10-14 16:21:48,268 IssueIndexer:thread-10 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SALLYEWM-165: Dropping 'customfield_11260'
2019-10-14 16:21:48,269 IssueIndexer:thread-8 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2684: Dropping 'customfield_11260'
2019-10-14 16:21:48,269 IssueIndexer:thread-9 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ETSYS-4324: Dropping 'customfield_11260'
2019-10-14 16:21:48,273 IssueIndexer:thread-4 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SALLYEWM-166: Dropping 'customfield_11260'
2019-10-14 16:21:48,281 IssueIndexer:thread-6 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue DTFD-237: Dropping 'customfield_11260'
2019-10-14 16:21:48,283 IssueIndexer:thread-7 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ZFAMS-703: Dropping 'customfield_11260'
2019-10-14 16:21:48,286 IssueIndexer:thread-1 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ETSYS-4325: Dropped: [customfield_11260]
2019-10-14 16:21:48,295 IssueIndexer:thread-9 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ETSYS-4324: Dropped: [customfield_11260]
2019-10-14 16:21:48,296 IssueIndexer:thread-5 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue PDDCAD-1871: Dropping 'customfield_11260'
2019-10-14 16:21:48,296 IssueIndexer:thread-10 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SALLYEWM-165: Dropped: [customfield_11260]
2019-10-14 16:21:48,297 IssueIndexer:thread-2 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue DTRVPOC-87: Dropped: [customfield_11260]
2019-10-14 16:21:48,298 IssueIndexer:thread-8 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2684: Dropped: [customfield_11260]
2019-10-14 16:21:48,299 IssueIndexer:thread-4 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SALLYEWM-166: Dropped: [customfield_11260]
2019-10-14 16:21:48,301 IssueIndexer:thread-3 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2683: Dropping 'customfield_11260'
2019-10-14 16:21:48,304 IssueIndexer:thread-7 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ZFAMS-703: Dropped: [customfield_11260]
2019-10-14 16:21:48,307 IssueIndexer:thread-6 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue DTFD-237: Dropped: [customfield_11260]
2019-10-14 16:21:48,310 IssueIndexer:thread-3 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2683: Dropped: [customfield_11260]
2019-10-14 16:21:48,310 IssueIndexer:thread-5 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue PDDCAD-1871: Dropped: [customfield_11260]
2019-10-14 16:21:48,352 IssueIndexer:thread-1 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2682: Dropping 'customfield_11260'
2019-10-14 16:21:48,359 IssueIndexer:thread-4 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ZFAMS-702: Dropping 'customfield_11260'
2019-10-14 16:21:48,366 IssueIndexer:thread-1 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue SIMADAS-2682: Dropped: [customfield_11260]
2019-10-14 16:21:48,376 IssueIndexer:thread-4 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue ZFAMS-702: Dropped: [customfield_11260]
2019-10-14 16:21:48,377 IssueIndexer:thread-5 WARN adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.issue.index.DefaultIssueDocumentFactory] Error indexing issue VSEDE-135: Dropping 'customfield_11260'

2019-10-14 16:49:10,961 JiraTaskExectionThread-1 INFO adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.j.w.a.admin.index.IndexAdminImpl] Re-indexing finished
2019-10-14 16:49:10,961 JiraTaskExectionThread-1 ERROR adm.user 948x339x1 1ijnto4 Server IP /secure/admin/jira/IndexReIndex.jspa [c.a.jira.task.TaskManagerImpl] Task 'Jira Indexing' failed.
com.atlassian.jira.index.IndexingFailureException: Indexing completed with 1 errors
at com.atlassian.jira.util.index.CompositeIndexLifecycleManager.reIndexAll(CompositeIndexLifecycleManager.java:83)
at com.atlassian.jira.util.index.CompositeIndexLifecycleManager.reIndexAll(CompositeIndexLifecycleManager.java:49)
at com.atlassian.jira.web.action.admin.index.ReIndexAsyncIndexerCommand.doReindex(ReIndexAsyncIndexerCommand.java:27)
at com.atlassian.jira.web.action.admin.index.AbstractAsyncIndexerCommand.call(AbstractAsyncIndexerCommand.java:63)
at com.atlassian.jira.web.action.admin.index.ReIndexAsyncIndexerCommand.call(ReIndexAsyncIndexerCommand.java:18)
at com.atlassian.jira.web.action.admin.index.AbstractAsyncIndexerCommand.call(AbstractAsyncIndexerCommand.java:26)
at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:460)
at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:428)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
at java.lang.Thread.run(Thread.java:745)

[Anas Ibrahim · Accepted solution]

Hi Nic ,

It's solved , i found the solution here  : 

Reindexing fails with expected exactly 2 rows error in Jira server

Root Cause #4

The LexoRank table does not have any rows in it.

1. Stop JIRA.

2. Get the ID of the "Rank" field by running the query below and ensure to ignore the "Rank Obsolete" (In case you're facing the Root Cause #3 as well):

   SELECT id from CUSTOMFIELD WHERE customfieldtypekey = 'com.pyxis.greenhopper.jira:gh-lexo-rank';

3. Run the following query to insert the values into the database, and ensure to replace the "FIELD_ID" according to the step above, which in our case (10900) will be the following:

   INSERT INTO "AO_60DB71_LEXORANK" ("FIELD_ID", "ISSUE_ID", "LOCK_HASH", "LOCK_TIME", "RANK", "TYPE") VALUES (10900, -9223372036854775808, null, null, '0|000000:', 0);
   INSERT INTO "AO_60DB71_LEXORANK" ("FIELD_ID", "ISSUE_ID", "LOCK_HASH", "LOCK_TIME", "RANK", "TYPE") VALUES (10900, 9223372036854775807, null, null, '0|zzzzzz:', 2);

4. Start JIRA
5. Perform a Lexorank balance again

[Ahmet Kilic _catworkx]

Any update here?

The same here for Rank field.

[Nic Brough -Adaptavist-]

This is not really the whole re-index failing, it is reporting a single error in one place (although it is happening to many issues).

The rest of your issues are absolutely fine, and in fact the index for the failed issues is also correct.  It has only failed for that one field on the issues.

Are you sure field 11260 is the Rank field?  Can you check by going to the list of custom fields and hovering the cursor over any of the configuration links in the cog menu and checking the fieldid in the url that appears in the tooltip?

Also, while there, can you check the type of the field (is it "global rank"?)  Do you have more than one global rank type field? 

[Anas Ibrahim]

Hi Nic ,

Thanks for your replay .

The Field 11260  is Rank and i have two Global Rank Field . 

1-Rank 

2-Rank (Obsolete)

and also when he finish the re index he give  :

'Jira Indexing' failed.

and i can't see all the Issues ,

[Nic Brough -Adaptavist-]

When you say you "can't see all the issues", could you be more precise?  Is it all issues, or a subset?  Where are you looking?

Could you try editing one of the issues mentioned in the indexing log and see if that throws a similar error?