I tried upgrading my 7.0.9 installation to 7.0.10 some weeks ago but got into this problem: when starting up, after apparently upgrading without issues, the webpage just reads "Service not available".
Looking at the logs I found an error like this:
2016-02-17 17:58:13,272 JIRA-Bootstrap ERROR [c.a.jira.startup.LauncherContextListener] Unable to start JIRA.
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, TYPE, REQUEST_TIME, START_TIME, COMPLETION_TIME, STATUS, EXECUTION_NODE_ID, QUERY FROM reindex_request WHERE STATUS=? ORDER BY REQUEST_TIME (Unknown column 'QUERY' in 'field list')
I didn't make much from it, went back to 7.0.9, and keep working.
Today I tried to update to 7.1.0 but I got exactly the same error (the log message is from today's attempt). I have searched the web but can't find anything related to this, so I'm not sure how to proceed.
Checking the table, it does not include that column but I don't know why. The upgrade process did finish as far as I can see correctly.
I have been using MariaDB for a lot time without much problems. Right now I am on version 10.1.11.
Any ideas, or somebody else having this same problem?
Resolved the issue...
Everything then worked, except that I now face this issue: https://jira.atlassian.com/browse/JRA-59790 which has a workaround.
My dbconfig.xml doens't have that line. I guess in Windows there is another scheme for that XML. The only line that has the jiradb is the URL for the db connection.
In any case, I manage to upgrade by deleting the affected table. I saw in the log that the startup process tries to create them, and being that table what I think it is (just a log for what reindex are pending) I assumed it was safe to delete and let the startup re-create it.
I guess there is some incompatibility between MySQL and MariaDB when upgrading a table's definition, that causes this?
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot