Database: JIRA couldn't connect to your database after update

[Howden]

Hi,

after updating Jira I get the following message: "Database: JIRA couldn't connect to your database" . Atlassian Jira service is running. Think we use the H2 database.  I know its for evaluation. Bevor the update the H2 worked fine. The OS is Windows Server 2012. If you need any logs, please let me know. 

[Nic Brough -Adaptavist- · Accepted solution]

A quick look at the logs would be needed to establish exactly why the database is not reachable.  Start with <Jira home>/logs/atlassian-Jira.log - that should give us a pile of text that contains a detailed reason for the disconnect.

However, this is likely to tell us that your database is broken.  H2 is not reliable, there's a good reason it tells you it is for dev/demo/test only - it can fail catastrophically without warning.  It's more likely to fail as it grows in size or when it comes under heavy load (processes that write a lot, such as an upgrade)

But let's check the log first before we start worrying about broken databases.

[Howden]

Thanks for your support. 

I ve done the following things: create a VM snapshot, done 1st update run -> get the above mentioned error. revert to snapshot, done a 2nd update run -> get the above mentioned error. 

Here are some lines from the atlassian-jira log, which is huge:

2021-10-05 10:10:16,637+0200 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running Jira startup checks.
2021-10-05 10:10:16,637+0200 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. Jira will be locked.
2021-10-05 10:10:16,699+0200 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Startup is complete. Jira is ready to serve.
2021-10-05 10:10:16,699+0200 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 68 MiB. Committed: 384 MiB. Max: 2048 MiB
Non-heap memory : Used: 65 MiB. Committed: 116 MiB. Max: 1536 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 133 MiB. Committed: 500 MiB. Max: 3584 MiB
---------------------------------------------------------------------------------
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-13 WARN anonymous 610x3x1 ogowom 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-13 WARN anonymous 610x3x1 ogowom 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-13 WARN anonymous 610x3x1 ogowom 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-13 WARN anonymous 610x3x1 ogowom 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-14 WARN anonymous 610x4x1 ogowom 0:0:0:0:0:0:0:1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-14 WARN anonymous 610x4x1 ogowom 0:0:0:0:0:0:0:1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-14 WARN anonymous 610x4x1 ogowom 0:0:0:0:0:0:0:1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:10:16,981+0200 http-nio-8080-exec-14 WARN anonymous 610x4x1 ogowom 0:0:0:0:0:0:0:1 /secure/errors.jsp [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:10:18,387+0200 http-nio-8080-exec-15 WARN anonymous 610x5x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:10:18,387+0200 http-nio-8080-exec-15 WARN anonymous 610x5x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:10:18,387+0200 http-nio-8080-exec-15 WARN anonymous 610x5x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:10:18,387+0200 http-nio-8080-exec-15 WARN anonymous 610x5x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/data [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:10:18,450+0200 http-nio-8080-exec-16 WARN anonymous 610x6x1 ogowom 0:0:0:0:0:0:0:1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:10:18,450+0200 http-nio-8080-exec-16 WARN anonymous 610x6x1 ogowom 0:0:0:0:0:0:0:1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:10:18,450+0200 http-nio-8080-exec-16 WARN anonymous 610x6x1 ogowom 0:0:0:0:0:0:0:1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:10:18,450+0200 http-nio-8080-exec-16 WARN anonymous 610x6x1 ogowom 0:0:0:0:0:0:0:1 /favicon.ico [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:10:18,496+0200 http-nio-8080-exec-17 WARN anonymous 610x7x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/245aafb31aa91d3a4eeaa36892d8ac05.eot [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:10:18,512+0200 http-nio-8080-exec-17 WARN anonymous 610x7x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/245aafb31aa91d3a4eeaa36892d8ac05.eot [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:10:18,512+0200 http-nio-8080-exec-17 WARN anonymous 610x7x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/245aafb31aa91d3a4eeaa36892d8ac05.eot [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:10:18,512+0200 http-nio-8080-exec-17 WARN anonymous 610x7x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/245aafb31aa91d3a4eeaa36892d8ac05.eot [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:10:38,635+0200 http-nio-8080-exec-20 WARN anonymous 610x8x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/54b49526bd4d993ab5c11f67dad2082a.woff [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:10:38,635+0200 http-nio-8080-exec-20 WARN anonymous 610x8x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/54b49526bd4d993ab5c11f67dad2082a.woff [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:10:38,635+0200 http-nio-8080-exec-20 WARN anonymous 610x8x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/54b49526bd4d993ab5c11f67dad2082a.woff [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:10:38,635+0200 http-nio-8080-exec-20 WARN anonymous 610x8x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson-page/54b49526bd4d993ab5c11f67dad2082a.woff [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:13:41,062+0200 http-nio-8080-exec-23 WARN anonymous 613x9x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/event [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:13:41,062+0200 http-nio-8080-exec-23 WARN anonymous 613x9x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/event [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:13:41,062+0200 http-nio-8080-exec-23 WARN anonymous 613x9x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/event [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:13:41,062+0200 http-nio-8080-exec-23 WARN anonymous 613x9x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/event [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:15:51,438+0200 http-nio-8080-exec-1 WARN anonymous 615x10x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/KBArticleLinkClicked [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:15:51,438+0200 http-nio-8080-exec-1 WARN anonymous 615x10x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/KBArticleLinkClicked [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:15:51,438+0200 http-nio-8080-exec-1 WARN anonymous 615x10x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/KBArticleLinkClicked [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:15:51,438+0200 http-nio-8080-exec-1 WARN anonymous 615x10x1 ogowom 0:0:0:0:0:0:0:1 /secure/johnson/analytics/KBArticleLinkClicked [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default
2021-10-05 10:16:06,792+0200 localhost-startStop-2 INFO [c.a.jira.startup.DefaultJiraLauncher] Stopping launchers
2021-10-05 10:16:06,792+0200 localhost-startStop-2 ERROR [o.a.c.c.C.[Catalina].[localhost].[/]] Exception sending context destroyed event to listener instance of class [com.atlassian.jira.startup.LauncherContextListener]
java.lang.NullPointerException
at com.atlassian.jira.startup.ClusteringLauncher.stop(ClusteringLauncher.java:49)
at com.atlassian.jira.startup.DefaultJiraLauncher.stop(DefaultJiraLauncher.java:198)
at com.atlassian.jira.startup.LauncherContextListener.contextDestroyed(LauncherContextListener.java:212)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4751)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5402)
... 3 filtered
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
2021-10-05 10:16:44,023+0200 localhost-startStop-1 INFO [c.a.jira.startup.JiraHomeStartupCheck] The jira.home directory 'C:\Program Files\Atlassian\Application Data\JIRA' is validated and locked for exclusive use by this instance.
2021-10-05 10:16:44,211+0200 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger]

****************
Jira starting...
****************

2021-10-05 10:16:44,382+0200 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger]

___ Environment _____________________________

JIRA Build : 8.19.1#819001-sha1:fef46de7bd561e13e968b7e37d7435d5ca44131b
Build Date : Wed Sep 15 00:00:00 CEST 2021
JIRA Installation Type : Standalone
Application Server : Apache Tomcat/8.5.65 - Servlet API 3.1
Java Version : 11.0.11 - AdoptOpenJDK
Current Working Directory : C:\Program Files\Atlassian\JIRA
Maximum Allowable Memory : 2048MB
Total Memory : 384MB
Free Memory : 313MB
Used Memory : 71MB
Memory Pool: CodeHeap 'non-nmethods' : CodeHeap 'non-nmethods': init = 5832704(5696K) used = 1196032(1168K) committed = 5832704(5696K) max = 5832704(5696K)
Memory Pool: Metaspace : Metaspace: init = 0(0K) used = 28645112(27973K) committed = 29671424(28976K) max = -1(-1K)
Memory Pool: CodeHeap 'profiled nmethods' : CodeHeap 'profiled nmethods': init = 33554432(32768K) used = 10197376(9958K) committed = 33554432(32768K) max = 265486336(259264K)
Memory Pool: Compressed Class Space : Compressed Class Space: init = 0(0K) used = 3109000(3036K) committed = 3538944(3456K) max = 1073741824(1048576K)
Memory Pool: G1 Eden Space : G1 Eden Space: init = 20971520(20480K) used = 45088768(44032K) committed = 246415360(240640K) max = -1(-1K)
Memory Pool: G1 Old Gen : G1 Old Gen: init = 381681664(372736K) used = 23649792(23095K) committed = 148897792(145408K) max = 2147483648(2097152K)
Memory Pool: G1 Survivor Space : G1 Survivor Space: init = 0(0K) used = 7340032(7168K) committed = 7340032(7168K) max = -1(-1K)
Memory Pool: CodeHeap 'non-profiled nmethods' : CodeHeap 'non-profiled nmethods': init = 33554432(32768K) used = 3522304(3439K) committed = 33554432(32768K) max = 265551872(259328K)
JVM Input Arguments : -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Dmail.mime.decodeparameters=true -Dorg.dom4j.factory=com.atlassian.core.xml.InterningDocumentFactory -XX:-OmitStackTraceInFastThrow -XX:+ExplicitGCInvokesConcurrent -Xlog:gc*:file=.\logs\atlassian-jira-gc-%t.log:tags,time,uptime,level:filecount=5,filesize=20M -XX:InitialCodeCacheSize=32m -XX:ReservedCodeCacheSize=512m -Dcatalina.home=C:\Program Files\Atlassian\JIRA -Dcatalina.base=C:\Program Files\Atlassian\JIRA -Dignore.endorsed.dirs=C:\Program Files\Atlassian\JIRA\endorsed -Djava.io.tmpdir=C:\Program Files\Atlassian\JIRA\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Atlassian\JIRA\conf\logging.properties --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED exit abort -Xms384m -Xmx2048m
Java Compatibility Information : JIRA version = 8.19.1, Java Version = 11.0.11

___ Java System Properties ________________

atlassian.standalone : JIRA
awt.toolkit : sun.awt.windows.WToolkit
catalina.base : C:\Program Files\Atlassian\JIRA
catalina.home : C:\Program Files\Atlassian\JIRA
catalina.useNaming : true
common.loader : "${catalina.base}/lib",
"${catalina.base}/lib/*.jar",
"${catalina.home}/lib",
"${catalina.home}/lib/*.jar"
file.encoding : Cp1252
ignore.endorsed.dirs : C:\Program Files\Atlassian\JIRA\endorsed
java.awt.graphicsenv : sun.awt.Win32GraphicsEnvironment
java.awt.headless : true
java.awt.printerjob : sun.awt.windows.WPrinterJob
java.class.version : 55.0
java.home : C:\PROGRA~1\ATLASS~1\JIRA\jre
java.io.tmpdir : C:\Program Files\Atlassian\JIRA\temp
java.naming.factory.initial : org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs : org.apache.naming
java.runtime.name : OpenJDK Runtime Environment
java.runtime.version : 11.0.11+9
java.specification.name : Java Platform API Specification
java.specification.vendor : Oracle Corporation
java.specification.version : 11
java.util.logging.config.file : C:\Program Files\Atlassian\JIRA\conf\logging.properties
java.util.logging.manager : org.apache.juli.ClassLoaderLogManager
java.vendor : AdoptOpenJDK
java.vendor.url : https://adoptopenjdk.net/
java.vendor.url.bug : https://github.com/AdoptOpenJDK/openjdk-support/issues
java.vendor.version : AdoptOpenJDK-11.0.11+9
java.version : 11.0.11
java.version.date : 2021-04-20
java.vm.compressedOopsMode : 32-bit
java.vm.info : mixed mode
java.vm.name : OpenJDK 64-Bit Server VM
java.vm.specification.name : Java Virtual Machine Specification
java.vm.specification.vendor : Oracle Corporation
java.vm.specification.version : 11
java.vm.vendor : AdoptOpenJDK
java.vm.version : 11.0.11+9
jdk.debug : release
mail.mime.decodeparameters : true
org.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER : true
org.dom4j.factory : com.atlassian.core.xml.InterningDocumentFactory
os.arch : amd64
os.name : Windows Server 2012 R2
os.version : 6.3
package.access : sun.,
org.apache.catalina.,
org.apache.coyote.,
org.apache.jasper.,
org.apache.tomcat.
package.definition : sun.,
java.,
org.apache.catalina.,
org.apache.coyote.,
org.apache.jasper.,
org.apache.naming.,
org.apache.tomcat.
server.loader :
shared.loader :
sun.arch.data.model : 64
sun.boot.library.path : C:\PROGRA~1\ATLASS~1\JIRA\jre\bin
sun.cpu.endian : little
sun.cpu.isalist : amd64
sun.desktop : windows
sun.io.unicode.encoding : UnicodeLittle
sun.jnu.encoding : Cp1252
sun.management.compiler : HotSpot 64-Bit Tiered Compilers
sun.os.patch.level :
tomcat.util.buf.StringCache.byte.enabled : true
tomcat.util.scan.StandardJarScanFilter.jarsToScan : log4j-taglib*.jar,
log4j-web*.jar,
log4javascript*.jar,
slf4j-taglib*.jar
tomcat.util.scan.StandardJarScanFilter.jarsToSkip : annotations-api.jar,
ant-junit*.jar,
ant-launcher.jar,
ant.jar,
asm-*.jar,
aspectj*.jar,
bootstrap.jar,
catalina-ant.jar,
catalina-ha.jar,
catalina-jmx-remote.jar,
catalina-storeconfig.jar,
catalina-tribes.jar,
catalina-ws.jar,
catalina.jar,
cglib-*.jar,
cobertura-*.jar,
commons-beanutils*.jar,
commons-codec*.jar,
commons-collections*.jar,
commons-daemon.jar,
commons-dbcp*.jar,
commons-digester*.jar,
commons-fileupload*.jar,
commons-httpclient*.jar,
commons-io*.jar,
commons-lang*.jar,
commons-logging*.jar,
commons-math*.jar,
commons-pool*.jar,
dom4j-*.jar,
easymock-*.jar,
ecj-*.jar,
el-api.jar,
geronimo-spec-jaxrpc*.jar,
h2*.jar,
hamcrest-*.jar,
hibernate*.jar,
httpclient*.jar,
icu4j-*.jar,
jasper-el.jar,
jasper.jar,
jaspic-api.jar,
jaxb-*.jar,
jaxen-*.jar,
jdom-*.jar,
jetty-*.jar,
jmx-tools.jar,
jmx.jar,
jsp-api.jar,
jstl.jar,
jta*.jar,
junit-*.jar,
junit.jar,
log4j*.jar,
mail*.jar,
objenesis-*.jar,
oraclepki.jar,
oro-*.jar,
servlet-api-*.jar,
servlet-api.jar,
slf4j*.jar,
taglibs-standard-spec-*.jar,
tagsoup-*.jar,
tomcat-api.jar,
tomcat-coyote.jar,
tomcat-dbcp.jar,
tomcat-i18n-*.jar,
tomcat-jdbc.jar,
tomcat-jni.jar,
tomcat-juli-adapters.jar,
tomcat-juli.jar,
tomcat-util-scan.jar,
tomcat-util.jar,
tomcat-websocket.jar,
tools.jar,
websocket-api.jar,
wsdl4j*.jar,
xercesImpl.jar,
xml-apis.jar,
xmlParserAPIs-*.jar,
xmlParserAPIs.jar,
xom-*.jar
user.country : DE
user.dir : C:\Program Files\Atlassian\JIRA
user.home : C:\Windows\ServiceProfiles\NetworkService
user.language : de
user.name : OurServerName$
user.script :
user.timezone : Europe/Berlin
user.variant :

2021-10-05 10:16:44,867+0200 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Program Files\Atlassian\Application Data\JIRA\dbconfig.xml
2021-10-05 10:16:44,914+0200 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it
2021-10-05 10:16:44,929+0200 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.
2021-10-05 10:16:55,507+0200 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "java.lang.IllegalStateException: Unable to read the page at position 3496476938019700617 [1.4.200/6]"
General error: "java.lang.IllegalStateException: Unable to read the page at position 3496476938019700617 [1.4.200/6]" [50000-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:194)
at org.h2.message.DbException.convert(DbException.java:347)
at org.h2.engine.Database.openDatabase(Database.java:333)
at org.h2.engine.Database.<init>(Database.java:301)
at org.h2.engine.Engine.openSession(Engine.java:74)
at org.h2.engine.Engine.openSession(Engine.java:192)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171)
at org.h2.engine.Engine.createSession(Engine.java:166)
at org.h2.engine.Engine.createSession(Engine.java:29)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:340)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:173)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:152)
at org.h2.Driver.connect(Driver.java:69)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:347)
at com.atlassian.jira.config.database.JdbcDatasource.getConnection(JdbcDatasource.java:224)
at com.atlassian.jira.config.database.DatabaseConfig.testConnection(DatabaseConfig.java:89)
at com.atlassian.jira.health.checks.DbConfigurationAndConnectionCheck.doPerform(DbConfigurationAndConnectionCheck.java:60)
at com.atlassian.jira.health.HealthCheckTemplate.perform(HealthCheckTemplate.java:23)
at com.atlassian.jira.health.DefaultHealthCheckExecutor.runCheck(DefaultHealthCheckExecutor.java:76)
at com.atlassian.jira.health.DefaultHealthCheckExecutor.lambda$applyAndCollectExceptions$1(DefaultHealthCheckExecutor.java:55)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(Unknown Source)
at java.base/java.util.stream.ReferencePipeline$2$1.accept(Unknown Source)
at java.base/java.util.Iterator.forEachRemaining(Unknown Source)
at java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(Unknown Source)
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(Unknown Source)
at java.base/java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.base/java.util.stream.ReferencePipeline.forEach(Unknown Source)
at com.atlassian.jira.health.DefaultHealthCheckExecutor.applyAndCollectExceptions(DefaultHealthCheckExecutor.java:55)
at com.atlassian.jira.health.DefaultHealthCheckExecutor.performHealthChecks(DefaultHealthCheckExecutor.java:44)
at com.atlassian.jira.health.HealthChecks.executeChecksAndRecordResults(HealthChecks.java:164)
at com.atlassian.jira.health.HealthChecks.runHealthChecks(HealthChecks.java:154)
at com.atlassian.jira.health.HealthChecks.runHealthChecks(HealthChecks.java:66)
at com.atlassian.jira.startup.BootstrapContainerLauncher.start(BootstrapContainerLauncher.java:48)
at com.atlassian.jira.startup.DefaultJiraLauncher.preDbLaunch(DefaultJiraLauncher.java:115)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:101)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:100)
at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:154)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Unable to read the page at position 3496476938019700617 [1.4.200/6]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2213)
at org.h2.mvstore.MVMap.readPage(MVMap.java:672)
at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:688)
at org.h2.mvstore.MVMap.setRootPos(MVMap.java:682)
at org.h2.mvstore.MVStore.openMap(MVStore.java:535)
at org.h2.mvstore.MVStore.openMap(MVStore.java:516)
at org.h2.mvstore.MVStore.removeMap(MVStore.java:2742)
at org.h2.engine.Database.handleUpgradeIssues(Database.java:866)
at org.h2.engine.Database.open(Database.java:742)
at org.h2.engine.Database.openDatabase(Database.java:307)
... 41 more
Caused by: java.lang.IllegalStateException: Unsupported type 17 [1.4.200/3]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950)
at org.h2.mvstore.type.ObjectDataType.newType(ObjectDataType.java:165)
at org.h2.mvstore.type.ObjectDataType.read(ObjectDataType.java:229)
at org.h2.mvstore.type.ObjectDataType.read(ObjectDataType.java:114)
at org.h2.mvstore.Page.read(Page.java:605)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2211)
... 51 more
2021-10-05 10:16:55,570+0200 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA couldn't connect to your database
2021-10-05 10:16:55,570+0200 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA failed to establish a connection to your database.
This could be because:
- Your database isn't running
- The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
- There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

There are several other solutions you can try, review our documentation and see what works for you.

2021-10-05 10:16:55,570+0200 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running Jira startup checks.
2021-10-05 10:16:55,570+0200 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. Jira will be locked.
2021-10-05 10:16:55,710+0200 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Startup is complete. Jira is ready to serve.
2021-10-05 10:16:55,710+0200 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 142 MiB. Committed: 384 MiB. Max: 2048 MiB
Non-heap memory : Used: 58 MiB. Committed: 111 MiB. Max: 1536 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 200 MiB. Committed: 495 MiB. Max: 3584 MiB
---------------------------------------------------------------------------------
2021-10-05 10:18:03,221+0200 http-nio-8080-exec-1 WARN anonymous 618x1x1 - 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.excluded.content.type' from database. Using default
2021-10-05 10:18:03,268+0200 http-nio-8080-exec-1 WARN anonymous 618x1x1 - 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.included.content.disposition' from database. Using default
2021-10-05 10:18:03,268+0200 http-nio-8080-exec-1 WARN anonymous 618x1x1 - 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.paths' from database. Using default
2021-10-05 10:18:03,268+0200 http-nio-8080-exec-1 WARN anonymous 618x1x1 - 0:0:0:0:0:0:0:1 / [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.security.csp.sandbox.browser.differentiated.clauses' from database. Using default

[Howden]

double post...

[Nic Brough -Adaptavist-]

Ok, that is almost certainly a damaged H2 database.

You'll need to install a clean Jira and restore from a backup.