Hi all,
hope someone can help. We used Jira for more than 2 years. From days now we are not able to open it due to the following error:
Setup: Your memory allocation pool settings need attention
JIRA runs in a Java virtual machine (JVM), and this JVM is allocated an amount of memory to enable JIRA to run. These amounts can be manually configured.
- The initial memory allocation pool (-Xms) is recommended to be at least 384m.
Maggiori informazioniDescrizioneTempoLivelloEccezione
Unexpected exception during JIRA startup. This JIRA instance will not be able to recover. Please check the logs for details
| 2020-07-15 11:54:35 | fatal | com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? (General error: "java.lang.NullPointerException"; SQL statement: DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? [50000-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:71) at com.atlassian.jira.scheduler.JiraCaesiumSchedulerService.startImpl(JiraCaesiumSchedulerService.java:35) 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:745) Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? (General error: "java.lang.NullPointerException"; SQL statement: DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? [50000-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: General error: "java.lang.NullPointerException"; SQL statement: DELETE FROM PUBLIC.rundetails WHERE START_TIME < ? [50000-185] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeUpdate(Command.java:262) 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: java.lang.NullPointerException at org.h2.mvstore.db.MVPrimaryIndex.getRow(MVPrimaryIndex.java:215) at org.h2.mvstore.db.MVTable.getRow(MVTable.java:394) at org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.get(MVSecondaryIndex.java:490) at org.h2.index.IndexCursor.get(IndexCursor.java:260) at org.h2.table.TableFilter.get(TableFilter.java:449) at org.h2.command.dml.Delete.update(Delete.java:74) at org.h2.command.CommandContainer.update(CommandContainer.java:78) at org.h2.command.Command.executeUpdate(Command.java:254) ... 31 more |
Jira server is in a Virtual Machine (VmWare); we tried to increase the memory but the error remains the same. I found a post from the community that seems to be very similar and the answer was to drop "rundetails" and create it againg. We have Embedded H2 Database but I'm not an expert with this kind of DB so, assuming this could be the solution, I know how to drop the table but I don't know how to re-create it.
Can someone Help me?
Thanks in Advance
