cannot delete issue

Jinxi Cheng September 5, 2017

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

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 5, 2017

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

Suggest an answer

Log in or Sign up to answer