cannot delete issue

Question

Hello, I cannot delete an issue. I get this error:

https://confluence.atlassian.com/jirakb/cannot-reindex-jira-due-to-expected-exactly-2-rows-the-maximum-marker-row-and-the-lowest-ranked-row-for-rank-field-779158916.html?_ga=2.16072245.2050910773.1504598149-1865569992.1503431667

I ran the query as requested in that post:

SELECT
  FIELD_ID,
TYPE,
substring(RANK FROM 1 FOR 1) AS bucket
FROM AO_60DB71_LEXORANK
WHERE "TYPE" IN (0, 2);

result:

10400 0 0
10400 2 0
10400 1 0
10400 1 0
10400 1 0

Nic Brough -Adaptavist- · Answer

The doc says "If you have more than 2 rows returned per custom field, there may be a serious corruption on the LexoRank table. Please contact Support for further help. "

Get in touch with them at https://support.atlassian.com/contact