nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

jira 6.1 : "Could not create missing indices for entity "OptionConfiguration" "

Pierre Cattin

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.

Accepted answers

darylchuah

Hi Pierre

There is a KB article which could possibly address your issue here:

ORA-01408: such column list already indexed

All comments

darylchuah

Hi Pierre

There is a KB article which could possibly address your issue here:

ORA-01408: such column list already indexed

Pierre Cattin

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

Pierre Cattin

Do you think I can solve it by dropping the index "fieldid_fieldconfig"?

Pierre Cattin

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

database

error