Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Database has been closed

baranovskiy May 25, 2019

Hi 
Just faced with Jira error, it works perfect but today's morning I got 503 erorr, trying to restart jira and getting an error.


here is my log:
2019-05-25 11:44:47,274 JIRA-Bootstrap INFO      [o.o.c.entity.jdbc.DatabaseUtil] Created function based indices for entity "Group"

2019-05-25 11:44:47,274 JIRA-Bootstrap INFO      [o.o.c.entity.jdbc.DatabaseUtil] Created function based indices for entity "IssueSecurityScheme"

2019-05-25 11:44:47,275 JIRA-Bootstrap INFO      [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is configured. Now running Database Checklist Launcher

2019-05-25 11:44:47,278 JIRA-Bootstrap INFO      [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.

2019-05-25 11:44:47,279 JIRA-Bootstrap INFO      [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is configured. Now running Post database-configuration launchers

2019-05-25 11:44:48,628 JIRA-Bootstrap INFO      [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml

2019-05-25 11:44:49,553 JIRA-Bootstrap INFO      [c.a.j.c.embedded.ofbiz.OfBizUserDao] Using full user cache

2019-05-25 11:44:51,235 JIRA-Bootstrap ERROR      [c.a.jira.startup.ComponentContainerLauncher] A fatal error occurred during initialisation. JIRA has been locked.

com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, FEATURE_NAME, FEATURE_TYPE, USER_KEY FROM PUBLIC.feature WHERE FEATURE_TYPE=? (The database has been closed [90098-185])

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 25, 2019

What type of database do you have here?  I've seen this error occur with damaged H2 databases, and when there's a MySQL connection without a "keepalive" set up in the driver.

baranovskiy May 25, 2019

this is h2 database

baranovskiy May 25, 2019

yeah h2 database is damaged, so I've just recovered database 

java -cp h2*.jar org.h2.tools.Recover
java -cp h2-*.jar org.h2.gools.RunScript -url jdbc:h2:./h2db -user sa -script *.sql



Thank you.

Suggest an answer

Log in or Sign up to answer