[CONFSERVER-20739] Confluence startup fails if using an HSQL database from JNDI, or with a manually defined connection string

Type: Bug
Resolution: Fixed
Priority: Low
Fix Version/s: 4.2
Affects Version/s: None
Component/s: None
Labels:
- bf_triage
- devspeed

Bug Fix Policy:
View Atlassian Server bug fix policy

NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

Confluence seems to assume that if you're using an HSQL database, it must be a file based database located at CONFLUENCE_HOME/database/confluencedb. So, if you're using a JNDI supplied HSQL database, or using an in memory database (eg jdbc:hsqldb:mem:confluence), or using HSQL as a server (eg jdbc:hsqldb:hsql://localhost/confluence, very useful if you actually want to connect to the database externally and browse it while Confluence is still running), or simply pointing it at some other file location, then Confluence fails to startup with the following error:

2010-09-03 13:39:06,978 ERROR [main] [atlassian.confluence.setup.ConfluenceConfigurationListener] contextInitialized An error was encountered while bootstrapping Confluence (see below): 
java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
java.lang.RuntimeException: java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
	at com.atlassian.confluence.setup.DefaultBootstrapManager.upgradeHSQL(DefaultBootstrapManager.java:226)
	at com.atlassian.confluence.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:176)
	at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:76)
	at com.atlassian.config.util.BootstrapUtils.init(BootstrapUtils.java:35)
	at com.atlassian.confluence.setup.ConfluenceConfigurationListener.initialiseBootstrapContext(ConfluenceConfigurationListener.java:76)
	at com.atlassian.confluence.setup.ConfluenceConfigurationListener.contextInitialized(ConfluenceConfigurationListener.java:40)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
	at org.apache.catalina.core.StandardService.start(StandardService.java:516)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(FileInputStream.java:106)
	at com.atlassian.confluence.setup.DefaultBootstrapManager.upgradeHSQL(DefaultBootstrapManager.java:223)
	... 20 more

relates to

CONFCLOUD-20739 Confluence startup fails if using an HSQL database from JNDI, or with a manually defined connection string

Closed

mentioned in: Page Failed to load

Katherine Yabut made changes - 13/Nov/2018 4:45 AM

Workflow

Original: JAC Bug Workflow v3 [ 2900287 ]

New: CONFSERVER Bug Workflow v4 [ 2994962 ]

Owen made changes - 11/Oct/2018 9:07 AM

Workflow	Original: JAC Bug Workflow v2 [ 2795301 ]	New: JAC Bug Workflow v3 [ 2900287 ]
Status	Original: Resolved [ 5 ]	New: Closed [ 6 ]

Owen made changes - 29/Aug/2018 11:17 PM

Workflow

Original: JAC Bug Workflow [ 2725415 ]

New: JAC Bug Workflow v2 [ 2795301 ]

Owen made changes - 02/Jul/2018 7:02 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389017 ]

New: JAC Bug Workflow [ 2725415 ]

Katherine Yabut made changes - 22/Jun/2017 6:49 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 [ 2266231 ]

New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2389017 ]

Katherine Yabut made changes - 31/May/2017 5:31 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2209893 ]

New: Confluence Workflow - Public Facing - Restricted v5 [ 2266231 ]

Katherine Yabut made changes - 31/May/2017 4:53 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195466 ]

New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2209893 ]

Katherine Yabut made changes - 31/May/2017 2:05 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 [ 1923546 ]

New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195466 ]

Katherine Yabut made changes - 03/Apr/2017 3:57 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v3 [ 1726601 ]

New: Confluence Workflow - Public Facing - Restricted v5 [ 1923546 ]

jonah (Inactive) made changes - 02/Apr/2017 7:46 AM

Description

Original: Confluence seems to assume that if you're using an HSQL database, it *must* be a file based database located at CONFLUENCE_HOME/database/confluencedb. So, if you're using a JNDI supplied HSQL database, or using an in memory database (eg {{jdbc:hsqldb:mem:confluence}}), or using HSQL as a server (eg {{jdbc:hsqldb:hsql://localhost/confluence}}, very useful if you actually want to connect to the database externally and browse it while Confluence is still running), or simply pointing it at some other file location, then Confluence fails to startup with the following error:

{noformat}
2010-09-03 13:39:06,978 ERROR [main] [atlassian.confluence.setup.ConfluenceConfigurationListener] contextInitialized An error was encountered while bootstrapping Confluence (see below):
java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
java.lang.RuntimeException: java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
at com.atlassian.confluence.setup.DefaultBootstrapManager.upgradeHSQL(DefaultBootstrapManager.java:226)
at com.atlassian.confluence.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:176)
at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:76)
at com.atlassian.config.util.BootstrapUtils.init(BootstrapUtils.java:35)
at com.atlassian.confluence.setup.ConfluenceConfigurationListener.initialiseBootstrapContext(ConfluenceConfigurationListener.java:76)
at com.atlassian.confluence.setup.ConfluenceConfigurationListener.contextInitialized(ConfluenceConfigurationListener.java:40)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at com.atlassian.confluence.setup.DefaultBootstrapManager.upgradeHSQL(DefaultBootstrapManager.java:223)
... 20 more
{noformat}

New: {panel:bgColor=#e7f4fa}
*NOTE:* This bug report is for *Confluence Server*. Using *Confluence Cloud*? [See the corresponding bug report|http://jira.atlassian.com/browse/CONFCLOUD-20739].
{panel}

Confluence seems to assume that if you're using an HSQL database, it *must* be a file based database located at CONFLUENCE_HOME/database/confluencedb. So, if you're using a JNDI supplied HSQL database, or using an in memory database (eg {{jdbc:hsqldb:mem:confluence}}), or using HSQL as a server (eg {{jdbc:hsqldb:hsql://localhost/confluence}}, very useful if you actually want to connect to the database externally and browse it while Confluence is still running), or simply pointing it at some other file location, then Confluence fails to startup with the following error:

{noformat}
2010-09-03 13:39:06,978 ERROR [main] [atlassian.confluence.setup.ConfluenceConfigurationListener] contextInitialized An error was encountered while bootstrapping Confluence (see below):
java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
java.lang.RuntimeException: java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
at com.atlassian.confluence.setup.DefaultBootstrapManager.upgradeHSQL(DefaultBootstrapManager.java:226)
at com.atlassian.confluence.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:176)
at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:76)
at com.atlassian.config.util.BootstrapUtils.init(BootstrapUtils.java:35)
at com.atlassian.confluence.setup.ConfluenceConfigurationListener.initialiseBootstrapContext(ConfluenceConfigurationListener.java:76)
at com.atlassian.confluence.setup.ConfluenceConfigurationListener.contextInitialized(ConfluenceConfigurationListener.java:40)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.io.FileNotFoundException: /home/jroper/src/atlassian/studio/branches/initialdata/studio-fireball/target/home/confluence-home/database/confluencedb.properties (No such file or directory)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at com.atlassian.confluence.setup.DefaultBootstrapManager.upgradeHSQL(DefaultBootstrapManager.java:223)
... 20 more
{noformat}

Assignee:: Unassigned

Reporter:: James Roper [Atlassian]

Affected customers:: 0 This affects my team

Watchers:: 3 Start watching this issue

Created:: 03/Sep/2010 3:50 AM

Updated:: 11/Oct/2018 9:07 AM

Resolved:: 05/Apr/2013 3:37 AM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates