Forums
Home Product Q&A Discussion groups Articles Ask a question Search
Learning
Events
Champions

Forums

Articles
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

JIRA Software - OOPS an error has occurred

Sako Kassabian
Sako Kassabian March 15, 2019

Hi all, 

We just started getting this error about a week ago and have no idea why. Any help would be appreciated. We have the 10 person version on our server.

here is the log:

Technical details

Log's referral number: 12a7e2cf-8734-497c-91e4-e4ddefee6661

Cause

Referer URL: Unknown

com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (General error: "java.lang.IllegalStateException: Chunk 3949429 not found [1.4.185/6]" [50000-185])
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (General error: "java.lang.IllegalStateException: Chunk 3949429 not found [1.4.185/6]" [50000-185])
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:341) [classes/:?]
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:333) [classes/:?]
	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findByPrimaryKey(WrappingOfBizDelegator.java:197) [classes/:?]
	at com.atlassian.jira.security.auth.rememberme.JiraRememberMeTokenDao.findById(JiraRememberMeTokenDao.java:57) [classes/:?]
	at com.atlassian.seraph.service.rememberme.DefaultRememberMeService.getRememberMeCookieAuthenticatedUsername(DefaultRememberMeService.java:49) [atlassian-seraph-3.0.3.jar:?]
	at com.atlassian.seraph.auth.DefaultAuthenticator.getUserFromCookie(DefaultAuthenticator.java:430) [atlassian-seraph-3.0.3.jar:?]
	at com.atlassian.seraph.auth.DefaultAuthenticator.getUser(DefaultAuthenticator.java:330) [atlassian-seraph-3.0.3.jar:?]
	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:139) [atlassian-seraph-3.0.3.jar:?]
	at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:103) [atlassian-trusted-apps-core-4.1.0.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:148) [atlassian-seraph-3.0.3.jar:?]
	at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:77) [classes/:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:39) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:67) [?:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:56) [?:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) [urlrewritefilter-4.0.3.jar:4.0.3]
	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) [urlrewritefilter-4.0.3.jar:4.0.3]
	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.3.jar:4.0.3]
	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394) [urlrewritefilter-4.0.3.jar:4.0.3]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30) [classes/:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:39) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.analytics.client.filter.JiraAnalyticsFilter.doFilter(JiraAnalyticsFilter.java:42) [?:?]
	at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:39) [?:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21) [?:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36) [?:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:56) [?:?]
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) [atlassian-plugins-servlet-4.5.0.jar:?]
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) [atlassian-plugins-servlet-4.5.0.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:31) [atlassian-core-5.0.8.jar:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39) [atlassian-core-5.0.8.jar:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:41) [classes/:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:36) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25) [classes/:?]
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32) [atlassian-core-5.0.8.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:74) [classes/:?]
	at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:55) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:115) [atlassian-gzipfilter-3.0.0.jar:?]
	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92) [atlassian-gzipfilter-3.0.0.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) [catalina.jar:8.5.6]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) [catalina.jar:8.5.6]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) [catalina.jar:8.5.6]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) [catalina.jar:8.5.6]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.6]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.5.6]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.6]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) [catalina.jar:8.5.6]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) [catalina.jar:8.5.6]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) [tomcat-coyote.jar:8.5.6]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.6]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) [tomcat-coyote.jar:8.5.6]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) [tomcat-coyote.jar:8.5.6]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.6]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_102]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_102]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.6]
	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_102]
Caused by: org.ofbiz.core.entity.GenericDataSourceException: Unable to establish a connection with the database. (General error: "java.lang.IllegalStateException: Chunk 3949429 not found [1.4.185/6]" [50000-185])
	at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:343) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:591) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:105) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:617) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:655) [entityengine-1.3.4.jar:?]
	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:339) [classes/:?]
	... 108 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Chunk 3949429 not found [1.4.185/6]" [50000-185]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) [h2-1.4.185.jar:1.4.185]
	at org.h2.message.DbException.get(DbException.java:168) [h2-1.4.185.jar:1.4.185]
	at org.h2.message.DbException.convert(DbException.java:295) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Database.openDatabase(Database.java:297) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Database.<init>(Database.java:260) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Engine.openSession(Engine.java:60) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Engine.openSession(Engine.java:167) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Engine.createSession(Engine.java:128) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Engine.createSession(Engine.java:26) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347) [h2-1.4.185.jar:1.4.185]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108) [h2-1.4.185.jar:1.4.185]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92) [h2-1.4.185.jar:1.4.185]
	at org.h2.Driver.connect(Driver.java:72) [h2-1.4.185.jar:1.4.185]
	at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_102]
	at java.sql.DriverManager.getConnection(DriverManager.java:247) [?:1.8.0_102]
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:173) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:114) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59) [entityengine-1.3.4.jar:?]
	at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:340) [entityengine-1.3.4.jar:?]
	... 113 more
Caused by: java.lang.IllegalStateException: Chunk 3949429 not found [1.4.185/6]
	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.MVStore.getChunk(MVStore.java:874) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.MVStore.readPage(MVStore.java:1821) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.MVMap.readPage(MVMap.java:736) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.MVMap.setRootPos(MVMap.java:746) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.MVStore.openMap(MVStore.java:475) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.db.TransactionStore.openMap(TransactionStore.java:373) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.db.TransactionStore$Transaction.openMap(TransactionStore.java:726) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.db.MVPrimaryIndex.<init>(MVPrimaryIndex.java:74) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.db.MVTable.init(MVTable.java:90) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.db.MVTableEngine.createTable(MVTableEngine.java:130) [h2-1.4.185.jar:1.4.185]
	at org.h2.mvstore.db.MVTableEngine.createTable(MVTableEngine.java:41) [h2-1.4.185.jar:1.4.185]
	at org.h2.schema.Schema.createTable(Schema.java:582) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Database.open(Database.java:715) [h2-1.4.185.jar:1.4.185]
	at org.h2.engine.Database.openDatabase(Database.java:266) [h2-1.4.185.jar:1.4.185]
	... 130 more

 

Answer
Watch
Like Be the first to like this
1006 views

1 answer

0 votes
Sako Kassabian
Sako Kassabian March 18, 2019

bump

View More Comments
Michał Rybiński
Michał Rybiński March 18, 2019

Have u tried to migrate embedded database into e.g. PSQL?

Is your hard drive ok?

Like
Sako Kassabian
Sako Kassabian March 18, 2019

Our network guy just gave us more space and we still have that problem.

We use SQL server, but haven't migrated anything. Is this something we should do? Any documentation on how to do it?

Like
Michał Rybiński
Michał Rybiński March 19, 2019

It seems you use Jira Server with shipped in H2 database, meant for evaluation purposes only. It's not the safest solution in terms of database, even for 10 license version .

Check: https://confluence.atlassian.com/adminjiraserver071/supported-platforms-802592168.html

 

The error seems related to H2 DB and your exact DB structure - I'd suggest to find a contact with H2DB team and query for any workarounds or how to recover the DB:

http://www.h2database.com/html/main.html - they're on Google Group https://groups.google.com/forum/#!forum/h2-database.

 

You may want to migrate from H2 to other DB engine, so you need it working to create initial DB export.

How to switch Jira DB: https://confluence.atlassian.com/adminjiraserver071/switching-databases-802592192.html#Switchingdatabases-differenttype

(we used locally latest PSQL 11.2 for Jira 7.1.13 and 8.0, as we use it also for bitbucket server DB - works fine by us)

 

P.S. Oh, and check if your JIRA_HOME folder on Jira server doesn't contain any corrupted files... just in case. :-)

 

Hope it helps.

Like
Sako Kassabian
Sako Kassabian March 19, 2019

thank you. will look into this

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events
    Community
    Forums
    FAQs Forums guidelines
    Learning
    About learning Resources
    Events
    Champions
    Copyright © 2025 Atlassian
    Privacy Policy Terms Security
    Welcome illustration

    Welcome to the new Atlassian Community

    Online forums and learning are now in one easy-to-use experience.

    By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.