- When ranking an issue, the following error shown on the browser
- The rank re-balance job is running very slow ie 4 days and no sign of completion.
There is a rank value for an issue which is 0|zzzzzr: When this is the last rank value, any new issues created will be assigned a rank which is after the last ranked issue. We generate a new rank value based on the last rank, and in this case the generated rank value equals a special marker rank. This special rank value is not allowed to be inserted, thus preventing the assigning of a rank for new issues.
Run the following SQL to identify the special rank marker, if this returns value, then you are affected
Update the invalid rank value 0|zzzzzr: to 0|zzzzzr:i using the following SQL