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

[srikanth]

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 ?

[Nic Brough -Adaptavist-]

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.

[srikanth]

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

[Nic Brough -Adaptavist-]

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

[Chris Dunne]

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".

[Ulrich Hobelmann [catworkx]]

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.

[Chander Inguva]

Did you check license ?