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])
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.