Unable to start JIRA as a service on Windows

Question

Hi there

I have installed JIRA software 7.13.0 on my local and ended up with this kind of error message

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT JOB_ID, NEXT_RUN FROM PUBLIC.clusteredjob WHERE (NEXT_RUN IS NOT NULL ) (General error: "java.lang.IllegalStateException: File corrupted in chunk 31386, expected page length =< 512, got 1848534392 [1.4.185/6]"; SQL statement: SELECT JOB_ID, NEXT_RUN FROM PUBLIC.clusteredjob WHERE (NEXT_RUN IS NOT NULL ) [50000-185]) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:401) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:278) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:227) at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.visitWith(SelectQueryImpl.java:185) at com.atlassian.jira.scheduler.OfBizClusteredJobDao.refresh(OfBizClusteredJobDao.java:110) at

I did some research on JVM Memory space and everything looks perfect on my system. Don't know if it has to do with database issue.

Please help me to resolve this issue.

Bastian Stehmann · Answer

Hi,

I would suggest to clear the database and start setup again.

Please follow this to connect to the database

https://confluence.atlassian.com/doc/embedded-h2-database-145098285.html

Then clear the database and delete the dbconfig.xml from your JIRA-HOME and start Jira again. Then the setup wizard should come up.

bipin23 · Answer

Hi @Bastian Stehmann

I did restart JIRA manually following this link https://confluence.atlassian.com/jirakb/startup-check-starting-jira-872266333.html?utm_source=Install&utm_medium=in-product&utm_campaign=csseng_fy18_q4_server_jira-software_errorstate

But I don't know what I have to do with database set up. I am just using the in-built database provided by H2 I guess. Is there any specific workaround for this issue ?

Bastian Stehmann · Answer

Hi @bipin23,

Did you try to to start Jira manually? Did that work?

I think, this is a database issue, Did you set that up correct?