Problems upgrading from v4.4 to v5.2.1

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

2 answers

1 accepted

This widget could not be displayed.

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

This widget could not be displayed.

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Thursday in United States

Local Atlassian Research Workshop opportunity on Sep. 28th

We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...

70 views 0 0
View post

Atlassian User Groups

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!

Find my local user group

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

Groups near you