Deleting a project does not remove the LexoRank values from the deleted issues in the database

Summary

Deleting a JIRA Software project will not delete the existing rank values in the AO_60DB71_LEXORANK table

Steps to Reproduce

1. Create a JIRA Software project and create several issues.
2. A row will be added to the AO_60DB71_LEXORANK table for each rank field for every issue created.
   For instance, creating 10 issues in an instance with 2 LexoRank fields will create 20 rows in that table.
3. Delete the project.

Expected Results

The rows with the rank values for the deleted issues are deleted from the AO_60DB71_LEXORANK table.

Actual Results

The rank values for the deleted issues remain in the AO_60DB71_LEXORANK table.

Workaround

Trigger the LexoRank rebalance operation on the LexoRank Management screen.

Warning

A rebalance operation will purge the invalid rows from the table, but may also cause performance problems and take days to complete, due to the bug below:

• JSW-11491