When I try and start up JIRA, it stops while starting up on the "Loading JIRA Apps" screen. I don't know how to further diagnose the problem to resolve the reason it won't start up.
I only see the ability to attach images or links to files. Is there a file upload that I am missing? Sorry for my ignorance on this.
This appears to be the culprit:
JIRA_DATA/logs/atlassian-jira.log2023-03-10 05:08:16,361-0700 Caesium-1-1 ERROR ServiceRunner [c.a.s.caesium.impl.SchedulerQueueWorker] Unhandled exception thrown by job QueuedJob[jobId=class com.atlassian.scheduler.core.util.JobRunnerRegistry:com.atlassian.cluster.monitoring.cluster-monitoring-plugin:system-information,deadline=1678450096350]com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: Reading from cache:nio:C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db failed; file length -1 read length 512 at 3174662384 [1.4.185/1]"; SQL statement:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185])at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:408)at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:283)at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:227)at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.asList(SelectQueryImpl.java:164)at com.atlassian.jira.scheduler.OfBizRunDetailsDao.getAllIdsForJob(OfBizRunDetailsDao.java:139)at com.atlassian.jira.scheduler.OfBizRunDetailsDao.addRunDetails(OfBizRunDetailsDao.java:111)at com.atlassian.scheduler.core.AbstractSchedulerService.addRunDetails(AbstractSchedulerService.java:136)at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:91)at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:435)at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeLocalJob(CaesiumSchedulerService.java:402)at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:380)at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:66)at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:60)at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:35)at java.lang.Thread.run(Thread.java:748)Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: Reading from cache:nio:C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db failed; file length -1 read length 512 at 3174662384 [1.4.185/1]"; SQL statement:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185])at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:216)at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:405)... 14 moreCaused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Reading from cache:nio:C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db failed; file length -1 read length 512 at 3174662384 [1.4.185/1]"; SQL statement:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [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.executeQuery(Command.java:209)at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:42)at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeQuery$5(DiagnosticPreparedStatement.java:59)at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:69)at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55)at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeQuery(DiagnosticPreparedStatement.java:59)at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:527)... 19 more
This appears to be the offender. Not sure what it's telling me is wrong:2023-03-10 05:08:16,361-0700 Caesium-1-1 ERROR ServiceRunner [c.a.s.caesium.impl.SchedulerQueueWorker] Unhandled exception thrown by job QueuedJob[jobId=class com.atlassian.scheduler.core.util.JobRunnerRegistry:com.atlassian.cluster.monitoring.cluster-monitoring-plugin:system-information,deadline=1678450096350]com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: Reading from cache:nio:C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db failed; file length -1 read length 512 at 3174662384 [1.4.185/1]"; SQL statement:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185])at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:408)at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:283)at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:227)at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.asList(SelectQueryImpl.java:164)at com.atlassian.jira.scheduler.OfBizRunDetailsDao.getAllIdsForJob(OfBizRunDetailsDao.java:139)at com.atlassian.jira.scheduler.OfBizRunDetailsDao.addRunDetails(OfBizRunDetailsDao.java:111)at com.atlassian.scheduler.core.AbstractSchedulerService.addRunDetails(AbstractSchedulerService.java:136)at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:91)at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:435)at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeLocalJob(CaesiumSchedulerService.java:402)at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:380)at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:66)at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:60)at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:35)at java.lang.Thread.run(Thread.java:748)Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: Reading from cache:nio:C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db failed; file length -1 read length 512 at 3174662384 [1.4.185/1]"; SQL statement:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185])at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:533)at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:877)at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:857)at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:216)at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:405)... 14 more
This appears to be the culprit. I am not sure what to do to rectify the situation though:
2023-03-10 05:08:16,361-0700 Caesium-1-1 ERROR ServiceRunner [c.a.s.caesium.impl.SchedulerQueueWorker] Unhandled exception thrown by job QueuedJob[jobId=class com.atlassian.scheduler.core.util.JobRunnerRegistry:com.atlassian.cluster.monitoring.cluster-monitoring-plugin:system-information,deadline=1678450096350]com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? (General error: "java.lang.IllegalStateException: Reading from cache:nio:C:/Program Files/Atlassian/Application Data/JIRA/database/h2db.mv.db failed; file length -1 read length 512 at 3174662384 [1.4.185/1]"; SQL statement:SELECT DISTINCT ID FROM PUBLIC.rundetails WHERE JOB_ID=? [50000-185])
It looks like you're new here. Sign in or register to get started.
