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 vote

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 21, 2018 in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

1,242 views 10 18
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