症状

If using the Alternative method of upgrading JIRA rather than the recommended method from a version prior to JIRA 3.9, the upgrade may fail with the following error message:

org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, trigger_id, cronExperssion FROM qrtz_cron_triggers (Invalid column name 'cronExperssion'.)

原因

This occurs due to database schema changes in JIRA 3.9.

ソリューション

There are two solutions to this problem:

1. Use the recommended method to upgrade.
2. If unable to use the XML backup, modify the database schema directly:

   
   mysql> alter table qrtz_cron_triggers drop column CRON_EXPERSSION;
   mysql> ALTER TABLE qrtz_cron_triggers ADD cronExperssion varchar(255);