Cannot delete/move et actions with issues due to the proble with

Dear Support,

I have a problem of Lexo Rank Integrity almost with all actions with an issues. I tried to follow the instructions from  https://confluence.atlassian.com/jirakb/several-actions-such-as-issue-ranking-move-export-are-failin...

But every time when I add manually rows in AO_60DB71_LEXORANK for one rank id reported in the exception, then re-index JIRA, the next attempt to move the issue throws the same exception but with a new rank id. So I have to maually import once again the ranking rows for this id, etc.... 

com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10100]
com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=10100]

Very urgent! 

 

JIRA is running on CentOS 7.3 with MySQL database (the latest stable release)

1 answer

0 votes

Hi Arkady,

Sorry to hear that you are having problems with the lexoranking in Jira.  The fix in that KB should be a one time use.  If you are having to reapply this right away after moving/changing an issue in Jira then I fear there is some other underlying problem that is causing this.

However it is too difficult to tell exactly what this is without digging into your logs a bit.  In order to do that, I create a support request on your behalf.  Please gather a support zip and reply to that support case.

Regards,

Andy Heinzer
Atlassian Support

I just wanted to update this issue with some more information about this specific problem.  In Arkady's case it appears that when the mysql database was created, the SQL user account was not created the REFERENCES permission.  In turn this caused Jira Software to be unable to correctly create the Rank field in that instance.    This particular problem is known to effect any instance that is potentially using Mysql 5.7.6 or higher.  This is due to a change in MySQL that now requires this permission in those versions or higher.

To help combat this problem we do have an updated KB on this problem: JIRA throws "Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again" when creating a new project

And in addition to that, we have updated the Connecting Jira to Mysql documentation for appropriate Jira versions that could be using this kind of database version.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

461 views 1 15
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot