ORA-01408: such column list already indexed
Symptoms
When upgrading JIRA using In-place database (Oracle) you will see the following appears in the atlassian-jira.log:
2011-11-08 09:42:09,255 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 performing any modification to the database. If possible, try your modifications on a test server.
- Stop JIRA.
Drop the index in your database:
DROP INDEX IDX_GOUP_ATTR_DIR_NAME_LVAL- Start JIRA. Upon restarting, JIRA will re-build the missing index.