JIRA failed to start after restart

[Alexey Vishnyakov]

Hello!

We have jira instance running on windows server. Today we restarted it without any modifications, and it's unable to start now with error.

The question is - how could we solve that error and start jira?

Error details:

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? (Timeout trying to lock table ; SQL statement: DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? [50200-185]) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByCondition(DefaultOfBizDelegator.java:144) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.removeByCondition(WrappingOfBizDelegator.java:136) at com.atlassian.jira.entity.Delete$DeleteWhereContext.execute(Delete.java:154) at com.atlassian.jira.entity.EntityEngineImpl.delete(EntityEngineImpl.java:55) at com.atlassian.jira.entity.Delete$DeleteWhereContext.execute(Delete.java:136) at com.atlassian.jira.scheduler.OfBizRunDetailsDao.purgeHistory(OfBizRunDetailsDao.java:130) at com.atlassian.jira.scheduler.OfBizRunDetailsDao.start(OfBizRunDetailsDao.java:70) at com.atlassian.jira.scheduler.JiraCaesiumSchedulerService.startRunDetailsDao(JiraCaesiumSchedulerService.java:67) at com.atlassian.jira.scheduler.JiraCaesiumSchedulerService.startImpl(JiraCaesiumSchedulerService.java:32) at com.atlassian.scheduler.core.AbstractSchedulerService.start(AbstractSchedulerService.java:180) at com.atlassian.jira.scheduler.JiraSchedulerLauncher.proceedIfAllClear(JiraSchedulerLauncher.java:36) at com.atlassian.jira.scheduler.JiraSchedulerLauncher.start(JiraSchedulerLauncher.java:22) at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:56) at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:170) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:144) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:304) at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:199) at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:135) at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:102) at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31) at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:100) at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:154) at java.lang.Thread.run(Thread.java:748) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? (Время ожидания блокировки таблицы истекло Timeout trying to lock table ; SQL statement: DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? [50200-185]) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:570) at org.ofbiz.core.entity.GenericDAO.deleteByCondition(GenericDAO.java:1238) at org.ofbiz.core.entity.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:244) at org.ofbiz.core.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1370) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeByCondition(DefaultOfBizDelegator.java:142) ... 22 more Caused by: org.h2.jdbc.JdbcSQLException: Время ожидания блокировки таблицы истекло Timeout trying to lock table ; SQL statement: DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? [50200-185] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.command.Command.filterConcurrentUpdate(Command.java:301) at org.h2.command.Command.executeUpdate(Command.java:256) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:157) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:143) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:562) ... 26 more Caused by: org.h2.jdbc.JdbcSQLException: Конкурентное изменение таблицы "RUNDETAILS": другая транзакция обновила или удалила ту же строку Concurrent update in table "RUNDETAILS": another transaction has updated or deleted the same row [90131-185] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.mvstore.db.MVSecondaryIndex.remove(MVSecondaryIndex.java:249) at org.h2.mvstore.db.MVTable.removeRow(MVTable.java:610) at org.h2.command.dml.Delete.update(Delete.java:94) at org.h2.command.CommandContainer.update(CommandContainer.java:78) at org.h2.command.Command.executeUpdate(Command.java:254) ... 31 more Caused by: java.lang.IllegalStateException: The transaction log might be corrupt for key ('24ea0094-a885-4d25-b16f-67e3819f0810', 377526) [1.4.185/100] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773) at org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1224) at org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1184) at org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1161) at org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1129) at org.h2.mvstore.db.TransactionStore$TransactionMap.set(TransactionStore.java:1007) at org.h2.mvstore.db.TransactionStore$TransactionMap.remove(TransactionStore.java:970) at org.h2.mvstore.db.MVSecondaryIndex.remove(MVSecondaryIndex.java:243) ... 35 more

[Diego Baeza · Accepted solution]

Hello,

What DB are you using? embedded H2? 

This is probably the main issue:

Caused by: org.h2.jdbc.JdbcSQLException: Конкурентное изменение таблицы "RUNDETAILS": другая транзакция обновила или удалила ту же строку Concurrent update in table "RUNDETAILS": another transaction has updated or deleted the same row [90131-185] ......

...

Caused by: java.lang.IllegalStateException: The transaction log might be corrupt for key ('24ea0094-a885-4d25-b16f-67e3819f0810', 377526) [1.4.185/100] 

[Alexey Vishnyakov]

Hello,

Yes, we're using embedded H2 database.

The problem was solved by dropping 'rundetails' table and creating a new one.

[Alexey Vishnyakov]

The problem was solved by dropping 'rundetails' table and creating a new one.

[Julian C_]

Can you explain how did you that? Had you copied the database folder to another machine did this fix on it?