Hello,
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?
Thanks!
Resolved the issue...
Everything then worked, except that I now face this issue: https://jira.atlassian.com/browse/JRA-59790 which has a workaround.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't have a <schema-name> node in any of the .xml files in the Atlassian folders... :/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Anthony,
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do youi use MySQL or MariaDB as the db backend? That's the only thing I could think of a cause for this, although everything else works fine, and the support tools don't show any error in my database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.