It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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)




 

2 answers

1 accepted

0 votes
Answer accepted

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
0 votes

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? 

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 ,

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?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

880 views 7 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you