I've just upgraded my test server from V 4.4.4 to V 5.2.5 and trying to access myserver:8080, I encountered this error :
Error occurred during export before upgrade: Erreur d'exportation de données : org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, MIMETYPE, FILENAME, CREATED, FILESIZE, AUTHOR, zip, thumbnailable FROM jiratest.fileattachment (Unknown column 'zip' in 'field list')
If necessary, auto-export can be disabled; see http://www.atlassian.com/software/jira/docs/latest/upgrade/autoexport.html
com.atlassian.core.AtlassianCoreException: Erreur d'exportation de données : org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, MIMETYPE, FILENAME, CREATED, FILESIZE, AUTHOR, zip, thumbnailable FROM jiratest.fileattachment (Unknown column 'zip' in 'field list')
Columns "zip" and "thumbnailable" don't exist in "fileattachment" table. They don't exist in the production database too, that is still in 4.4.4 version.
Are they new columns added in version 5.x ? Is the error due to a malfunction process during database upgrade ?
Finally, I've found the source of my problem !
In dbconfig.xml, I had the name of the database in the tag <schema-name> and with MySQL RDBMS, it MUST be empty.
After set it to null and restart, it ALTERs tables instead of CREATE them and now my test server is OK.
Problem solved !
I have downgraded to 4.4.4 version and tried to upgrade again to 5.2.5 and I encountered the same problem. Upgrade seems to success but when jira restarts after upgrade, it tries to CREATE tables instead of ALTER them then it fails because tables already exists in database. I can see this kind of messages in catalina.out log :
2013-01-25 10:45:29,919 localhost-startStop-1 WARN [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
2013-01-25 10:45:30,033 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] Could not create table "jiratest.jiraaction"
2013-01-25 10:45:30,034 localhost-startStop-1 ERROR [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE jiratest.jiraaction (ID DECIMAL(18,0) NOT NULL, issueid DECIMAL(18,0), AUTHOR VARCHAR(255), actiontype VARCHAR(255), actionlevel VARCHAR(255), rolelevel DECIMAL(18,0), actionbody LONGTEXT, CREATED DATETIME, UPDATEAUTHOR VARCHAR(255), UPDATED DATETIME, actionnum DECIMAL(18,0), CONSTRAINT PK_jiraaction PRIMARY KEY (ID))
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jiraaction' already exists
Then when trying to access new version of Jira, I encounter the problem described in my first message.
I will now try to do a new install (instead of an upgrade) with an empty database and restore datas from production server in XML format. Do you think it can be done like that ?
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs