Problems upgrading from v4.4 to v5.2.1

[Jim Talbut]

Hi,

I'm trying to upgrade from atlassian-jira-4.4-standalone to atlassian-jira-5.2.1-x64.bin.

After completing the upgrade, whether working as an upgrade or doing the upgrade manually I get the error:

Error occurred during export before upgrade: Error exporting data: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, MIMETYPE, FILENAME, CREATED, FILESIZE, AUTHOR, zip, thumbnailable FROM 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: Error exporting data: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, MIMETYPE, FILENAME, CREATED, FILESIZE, AUTHOR, zip, thumbnailable FROM fileattachment (Unknown column 'zip' in 'field list')

at com.atlassian.jira.bean.export.AutoExportImpl.exportData(AutoExportImpl.java:109)

When I disable autoexport I get:

Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, filtername, authorname, DESCRIPTION, username, groupname, projectid, reqcontent, FAV_COUNT, filtername_lower FROM searchrequest (Unknown column 'filtername_lower' in 'field list')

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, filtername, authorname, DESCRIPTION, username, groupname, projectid, reqcontent, FAV_COUNT, filtername_lower FROM searchrequest (Unknown column 'filtername_lower' in 'field list')

at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:333)

at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build754.doUpgrade(UpgradeTask_Build754.java:51)

at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:651)

...

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, filtername, authorname, DESCRIPTION, username, groupname, projectid, reqcontent, FAV_COUNT, filtername_lower FROM searchrequest (Unknown column 'filtername_lower' in 'field list')

at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:605)

at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1061)

...

at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findAll(DefaultOfBizDelegator.java:329)

... 36 more

It seems my database is considerably different from that expected, so how do I move to v5.2.1?

Thanks

[Jim Talbut · Accepted solution]

The problem was database permissions.

I always tie down the permissions for service accounts to the minimum possible, and usually avoid giving them any DDL permissions.

The new upgrade process for Jira doesn't work without, at least, ALTER permission.

Jim

[LucasA]

Hi Jim,

Do you have any plugin in your JIRA 4.4 instance or customization in the SQL scheme? It might be causing this problem.

Best regards,
Lucas Timm