Unable to Rank issues: Error: "Other users may be ranking the issues that you are trying to rank."

When trying to rearrange issues in the backlog or in Work mode, an error is displayed and it is impossible to reorder issues.

Error message: "JIRA Agile cannot execute the rank operation at this time. Other users may be ranking the issues that you are trying to rank. Please try again later."

How to verify:
When running the following query on the Jira database:

SELECT "FIELD_ID", COUNT(1), "RANK" FROM "AO_60DB71_LEXORANK" GROUP BY "FIELD_ID", "RANK" HAVING COUNT(1) > 1;

1 or more lines are returned with duplicate ranks.