• Community
  • Products
  • Jira
  • Questions
  • Unexpected exception during JIRA startup. This JIRA instance will not be able to recover. Please check the logs for details

Unexpected exception during JIRA startup. This JIRA instance will not be able to recover. Please check the logs for details

i have installed JIRA 6.4.12 and upgraded 7.0.4 after upgraded iam facing this error,Please help to  how can i fix this issue ?

2 answers

This widget could not be displayed.

Did you check license ?

This widget could not be displayed.

The error message tells you what to do.  Read the log file.   There's so many things it could be, and you have not even started to look at what might be wrong.  Please, read the log to see what is wrong.

Please restart JIRA to complete the HSQL to H2 database migration

2015-12-17 12:54:13,093 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PARAMETERS" of table "PUBLIC.clusteredjob" of entity "ClusteredJob" is of type "OTHER" in the database, but is defined as type "BLOB" in the entity definition.
2015-12-17 12:54:13,126 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "BLOB_DATA" of table "PUBLIC.JQUARTZ_BLOB_TRIGGERS" of entity "JQRTZBlobTriggers" is of type "VARBINARY(16000)" in the database, but is defined as type "BLOB" in the entity definition.
2015-12-17 12:54:13,126 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "CALENDAR" of table "PUBLIC.JQUARTZ_CALENDARS" of entity "JQRTZCalendars" is of type "VARBINARY(16000)" in the database, but is defined as type "BLOB" in the entity definition.
2015-12-17 12:54:13,128 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "FIRED_TIME" of table "PUBLIC.JQUARTZ_FIRED_TRIGGERS" of entity "JQRTZFiredTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,128 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "SCHED_TIME" of table "PUBLIC.JQUARTZ_FIRED_TRIGGERS" of entity "JQRTZFiredTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,128 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PRIORITY" of table "PUBLIC.JQUARTZ_FIRED_TRIGGERS" of entity "JQRTZFiredTriggers" is of type "NUMERIC(9)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,130 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "JOB_DATA" of table "PUBLIC.JQUARTZ_JOB_DETAILS" of entity "JQRTZJobDetails" is of type "VARBINARY(16000)" in the database, but is defined as type "BLOB" in the entity definition.
2015-12-17 12:54:13,132 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "LAST_CHECKIN_TIME" of table "PUBLIC.JQUARTZ_SCHEDULER_STATE" of entity "JQRTZSchedulerState" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,132 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "CHECKIN_INTERVAL" of table "PUBLIC.JQUARTZ_SCHEDULER_STATE" of entity "JQRTZSchedulerState" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,133 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "INT_PROP_1" of table "PUBLIC.JQUARTZ_SIMPROP_TRIGGERS" of entity "JQRTZSimplePropTriggers" is of type "NUMERIC(9)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,133 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "INT_PROP_2" of table "PUBLIC.JQUARTZ_SIMPROP_TRIGGERS" of entity "JQRTZSimplePropTriggers" is of type "NUMERIC(9)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,133 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "LONG_PROP_1" of table "PUBLIC.JQUARTZ_SIMPROP_TRIGGERS" of entity "JQRTZSimplePropTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,134 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "LONG_PROP_2" of table "PUBLIC.JQUARTZ_SIMPROP_TRIGGERS" of entity "JQRTZSimplePropTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,134 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "DEC_PROP_1" of table "PUBLIC.JQUARTZ_SIMPROP_TRIGGERS" of entity "JQRTZSimplePropTriggers" is of type "NUMERIC(13,4)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,134 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "DEC_PROP_2" of table "PUBLIC.JQUARTZ_SIMPROP_TRIGGERS" of entity "JQRTZSimplePropTriggers" is of type "NUMERIC(13,4)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,135 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "REPEAT_COUNT" of table "PUBLIC.JQUARTZ_SIMPLE_TRIGGERS" of entity "JQRTZSimpleTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,135 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "REPEAT_INTERVAL" of table "PUBLIC.JQUARTZ_SIMPLE_TRIGGERS" of entity "JQRTZSimpleTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,135 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "TIMES_TRIGGERED" of table "PUBLIC.JQUARTZ_SIMPLE_TRIGGERS" of entity "JQRTZSimpleTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,137 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "NEXT_FIRE_TIME" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,137 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PREV_FIRE_TIME" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,137 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PRIORITY" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "NUMERIC(9)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,137 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "START_TIME" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,138 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "END_TIME" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "NUMERIC(13)" in the database, but is defined as type "BIGINT" in the entity definition.
2015-12-17 12:54:13,138 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "MISFIRE_INSTR" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "NUMERIC(2)" in the database, but is defined as type "INTEGER" in the entity definition.
2015-12-17 12:54:13,138 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "JOB_DATA" of table "PUBLIC.JQUARTZ_TRIGGERS" of entity "JQRTZTriggers" is of type "VARBINARY(16000)" in the database, but is defined as type "BLOB" in the entity definition.
2015-12-17 12:54:13,141 localhost-startStop-1 WARN [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PRIMARY_GROUP" of table "PUBLIC.licenserolesgroup" of entity "LicenseRoleGroup" has a column size of "CHAR(2147483647)" in the database, but is defined to have a column size of "CHAR(1)" in the entity definition.
2015-12-17 12:54:13,163 localhost-startStop-1 ERROR [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "PROPERTYVALUE" of table "PUBLIC.propertydata" of entity "OSPropertyData" is of type "OTHER" in the database, but is defined as type "BLOB" in the entity definition.
2015-12-17 12:54:13,239 localhost-startStop-1 WARN [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "RESOLVED" of table "PUBLIC.remotelink" of entity "RemoteIssueLink" has a column size of "CHAR(2147483647)" in the database, but is defined to have a column size of "CHAR(1)" in the entity definition.
2015-12-17 12:54:13,242 localhost-startStop-1 WARN [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "RUN_OUTCOME" of table "PUBLIC.rundetails" of entity "RunDetails" has a column size of "CHAR(2147483647)" in the database, but is defined to have a column size of "CHAR(1)" in the entity definition.
2015-12-17 12:54:13,249 localhost-startStop-1 WARN [o.o.c.entity.jdbc.DatabaseUtil] WARNING: Column "DOWNGRADETASKREQUIRED" of table "PUBLIC.upgradehistory" of entity "UpgradeHistory" has a column size of "CHAR(2147483647)" in the database, but is defined to have a column size of "CHAR(1)" in the entity definition.
2015-12-17 12:54:13,286 localhost-startStop-1 WARN [c.a.jira.startup.EmbeddedDatabaseMigrator]

*****************************************************
JIRA must be restarted to complete the import process
*****************************************************

2015-12-17 12:54:14,211 localhost-startStop-1 INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 371 MiB. Committed: 614 MiB. Max: 741 MiB
Non-heap memory : Used: 220 MiB. Committed: 238 MiB. Max: 1264 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 591 MiB. Committed: 852 MiB. Max: 2005 MiB
---------------------------------------------------------------------------------
2015-12-17 12:54:17,237 Modification Check:thread-1 INFO [c.a.jira.startup.JiraStartupLogger]

___ Modifications ___________________________

Modified Files : jira-application.properties
Removed Files

And again, it explicitly tells you what to do next.

Hi, did you resolve this? I'm having the same problem but after the restart to complete the db migration I have an error " Upgrade Error: There was a problem adding Upgrade Task Deleting invalid version associations. to the Upgrade History".

I got the same error as Chris. JIRA log said I should import from XML instead of upgrading the JIRA, so I setup a fresh JIRA 7 and imported the old Backup.zip, which worked.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

175 views 2 0
Join discussion

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