Regression: Upgrading JIRA get index error: ORA-00972: identifier is too long when running JIRA with Oracle

XMLWordPrintable

    • 6

      When upgrading JIRA and connect database with Oracle 11g, during the startup, it will show the following error in log file:

      2013-06-22 09:56:51,094 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] Could not create missing indices for entity "ReplicatedIndexOperation"
2013-06-22 09:56:51,094 localhost-startStop-1 ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE INDEX node_id_index_operation_time_idx ON replicatedindexoperation (NODE_ID, AFFECTED_INDEX, OPERATION, INDEX_TIME)
Error was: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

      JIRA is able to start up, so far all JIRA features seems working fine. Re-index in JIRA UI can be done successfully.

      UPDATE: Also happens on a Fresh JIRA 6.0.2 installation connected to Oracle database and starting up.

      Workaround:

      Referring to the KB article and make changes in entitymodel.xml or upgrade to JIRA 6.0.4

              Assignee:
              Eric Dalgliesh
              Reporter:
              Daniel Leng (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: