ORA-01408: such column list already indexed
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When upgrading JIRA using In-place database (Oracle) you will see the following appears in the atlassian-jira.log:
1
2
3
main ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX idx_group_attr_dir_name_lval ON cwd_group_attributes (directory_id, attribute_name, lower_attribute_value)
Error was: java.sql.SQLException: ORA-01408: such column list already indexedCause
The indexes in JIRA 4.3.x (atlassian-jira\WEB-INF\classes\entitydefs\entitymodel.xml) contains a spelling mistake in "cwd_group_attributes" index.
The word group in "idx_goup_attr_dir_name_lval" is missing the letter 'r'. It should be "idx_group_attr_dir_name_lval".
When upgrading using In-place database the tables still contain the misspelled index. this leads oracle database to throw the error show above.
This mistake is been fixed in later versions JIRA 4.4.x and above.
Resolution
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Stop JIRA.
Drop the index in your database:
1DROP INDEX IDX_GOUP_ATTR_DIR_NAME_LVALStart JIRA. Upon restarting, JIRA will re-build the missing index.
Was this helpful?