問題

When the customer upgrades their JIRA instance that is connected to Oracle DB, they would get an error letting them know JIRA failed and looking at their log, they should see the following errors in atlassian-jira.log

(SQL Exception while executing the following:INSERT INTO propertytext (ID, propertyvalue) VALUES (?, ?) (ORA-01502: index 'JIRA.PK_PROPERTYTEXT' or partition of such index is in unusable state
))

Cause: An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation

Action: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition

The error seems not to be related to the KB I sent to you earlier as it seems that this is related to a corrupted index within your oracle database as explained here

原因

An index partition is corrupted in his JIRA Database, affected indexes would be mentioned in error thrown in the log.

回避策

オプション 1

• Create a new Oracle Database(this fixes the corrupted index)

• Install new JIRA you want to migrate to.

• Connect it to JIRA.

• When JIRA is Started, proceed to restore your old backup you had before you perform the upgrade.

オプション 2

• Follow the steps mentioned in this document to recreate the affected indexes(note that the affected ones are listed in atlassian-jira.log) in this case

• • ORA-01502: index 'JIRA.PK_PROPERTYTEXT'

• • ORA-01502: index 'JIRA.PK_JIRAWORKFLOWS'

• Once done, restart JIRA with the corrected database and reattempt the upload.