Hi, when I start Jira, I get those errors (even though I didn't see any problem in Jira interface):
2013-10-16 10:48:58,120 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "GroupAttribute" 2013-10-16 10:48:58,120 localhost-startStop-1 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 indexed 2013-10-16 10:48:58,120 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "OptionConfiguration" 2013-10-16 10:48:58,120 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE INDEX fieldid_fieldconf ON optionconfiguration (FIELDID, FIELDCONFIG) Error was: java.sql.SQLException: ORA-01408: such column list already indexed
I use Oracle 11g.
Hi Pierre
There is a KB article which could possibly address your issue here:
Thanks Daryl! It worked for the first error, but I still have the second one :
2013-10-16 11:52:30,101 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "OptionConfiguration" 2013-10-16 11:52:30,101 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE INDEX fieldid_fieldconf ON optionconfiguration (FIELDID, FIELDCONFIG) Error was: java.sql.SQLException: ORA-01408: such column list already indexed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you think I can solve it by dropping the index "fieldid_fieldconfig"?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok I dropped the index FIELDID_FIELDCONFIG, which was also an index for the columns FIELDID and FIELDCONFIG of the table optionconfiguration, and on the next startup, it created the index FIELDID_FIELDCONF and there was no error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.