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 ?
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
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