Cannot delete issue. LexoRank Related....

[earnestware]

cannot delete issue.

com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10005]
com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10005]
at com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.getMaximumMarkerRowAndPreviousRow(LexoRankDaoImpl.java:399) [?:?]

the db is wrong but cant find the proper documentation to fix it...

mysql> SELECT
-> FIELD_ID,
-> TYPE,
-> SUBSTR(RANK, 1, 1) AS bucket
-> FROM AO_60DB71_LEXORANK
-> WHERE TYPE IN (0, 2);
+----------+------+--------+
| FIELD_ID | TYPE | bucket |
+----------+------+--------+
| 10005 | 0 | 0 |
| 10100 | 2 | 0 |
+----------+------+--------+
2 rows in set (0.00 sec)

Thanks!!!

Robert 

[earnestware · Accepted solution]

It was a semi fresh install so I ultimately uninstalled and re-installed. 

[Bastian Stehmann · Accepted solution]

Hi,

just try this one: https://confluence.atlassian.com/jirakb/how-to-remove-duplicate-lexorank-fields-779159223.html