The ReindexRequest entity introduced in JIRA 6.3.8 originally contained a query column that is no longer included, but no upgrade task has been defined to remove the column from the table in the database.
- Install JIRA 6.3.8, using a database such as PostgreSQL.
- Upgrade it to 6.3.13 or higher.
- Start JIRA and watch the logs.
The ReindexRequest entity was introduced in JIRA 6.3.8, and then modified in JIRA 6.3.13 to remove the query field. Therefore, this problem will only affect JIRA installations that were upgraded to one of JIRA 6.3.8 - 6.3.12, and then upgraded again to JIRA 6.3.13 or higher. In our case, we upgraded to JIRA 6.3.9 and then 6.3.15.
There are no warnings on startup, as the column no longer exists as it was removed in an upgrade task.
As a result, when we start our instance, we see the following warnings in our log:
- Create an XML backup of the instance.
- Restore that backup onto the instance.
This will overwrite the existing database with the new one, and recreate the schema from scratch. Either that or drop the query column from the table (not recommended as it's not known what other problems this could cause).
Here are the relevant snippets from jira-project/jira-components/jira-core/src/main/ofbiz/entitydefs/entitymodel.xml to show the difference: