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?
We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...
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