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

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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Hipchat

Moving from Hipchat to Stride? Here’s what you’ll love

Heya, Hipchat friends! We’re so happy you’re checking out   Stride. Whether you know it or not, you have been instrumental in making Stride come to life. Every feature, design, and functionality...

81 views 3 6
Read article

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