Summary

When upgrading JIRA to 7.4.x, where the Kanban backlog feature was introduced, there are cases where multiple backlog columns are created, needing to be deleted directly in the database.

Steps to Reproduce

1. Upgrade a JIRA instance containing a Kanban board to 7.4.x
2. Access the board in the affected instance

Expected Results

JIRA will display just one backlog column

Actual Results

JIRA will display multiple backlog columns.

Workaround

1. Stop JIRA
2. Run the following query to identify the affected entries:

   SELECT * FROM "AO_60DB71_COLUMN" where "RAPID_VIEW_ID" = (select "ID" from "AO_60DB71_RAPIDVIEW" where "NAME" = 'YOUR_BOARD_NAME');

3. Multiple columns with the gh.kanplan.column@name=gh.workflow.preset.backlog name will show up. Proceed keeping the one with the lowest id, then delete the other ones.
4. Start JIRA