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: