Unable to clone, delete or link issues. (LexoRankIntegrityException)

Yiannis Koukouras

We are getting the following error whenever we are trying to clone, delete or link issues.

Error Title:

Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10005]

 

We searched in KB and we run the following mysql query:

"SELECT * FROM "AO_60DB71_LEXORANKBALANCER" WHERE "FIELD_ID" = 10005;" 

and returns empty rows, no results.

 

Yiannis Koukouras

Fixed:

INSERT INTO AO_60DB71_LEXORANK (ID, FIELD_ID, ISSUE_ID, RANK, TYPE) VALUES (DEFAULT, 10005, -9223372036854775808, '0|000000:', 0);
INSERT INTO AO_60DB71_LEXORANK (ID, FIELD_ID, ISSUE_ID, RANK, TYPE) VALUES (DEFAULT, 10100, -9223372036854775808, '0|000000:', 0);
INSERT INTO AO_60DB71_LEXORANK (ID, FIELD_ID, ISSUE_ID, RANK, TYPE) VALUES (DEFAULT, 10005, 9223372036854775807, '0|zzzzzz:', 2);
INSERT INTO AO_60DB71_LEXORANK (ID, FIELD_ID, ISSUE_ID, RANK, TYPE) VALUES (DEFAULT, 10100, 9223372036854775807, '0|zzzzzz:', 2);