HsqlException in Confluence evaluation

Hi,

We've been running the Confluence evaluation for a week or so but this morning cannot get Confluence to start up. We've tried rebooting the test server as well but the log shows multiple items that look like the below. There appears to be something wrong with the HSQLDB that comes with the evaluation version but we're not sure what the problem is or how to fix it.

Does anyone have any ideas we can try?

[09:44:53] WARN Script processing failure
org.hsqldb.HsqlException: error in script file line: 2016 integrity constraint violation: unique constraint or index violation; SYS_PK_10184 table: OS_PROPERTYENTRY
at org.hsqldb.error.Error.error(Error.java:131)
at org.hsqldb.scriptio.ScriptReaderText.readExistingData(ScriptReaderText.java:200)
at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:66)
at org.hsqldb.persist.Log.processScript(Log.java:779)
at org.hsqldb.persist.Log.open(Log.java:150)
at org.hsqldb.persist.Logger.openPersistence(Logger.java:310)
at org.hsqldb.Database.reopen(Database.java:220)
at org.hsqldb.Database.open(Database.java:186)
at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:240)
at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3297)
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:321)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:259)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10184 table: OS_PROPERTYENTRY
at org.hsqldb.error.Error.error(Error.java:131)
at org.hsqldb.Constraint.getException(Constraint.java:913)
at org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:236)
at org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:171)
at org.hsqldb.Table.insertData(Table.java:2589)
at org.hsqldb.Table.insertFromScript(Table.java:2578)
at org.hsqldb.scriptio.ScriptReaderText.readExistingData(ScriptReaderText.java:189)

3 answers

Thanks David.

Yes, given we're only evaluating Confluence we decided to cut our losses and just reinstall.

0 vote
David Simpson Community Champion Jan 12, 2012

It looks like the HSQL script has corrupted for some reason -- that's why it's not recommended for production.

Try out Troubleshooting the Embedded Database (HSQL DB).

David Simpson Community Champion Jan 12, 2012

That would have been my 2nd suggestion ;-)

We ran into the same problem, but have the exceptions at random points. We discovered that we had a RAM problem. (We run JIRA, Crowd and Confluence on the same machine of 4GB). After stopping JIRA and having enough memory left - it installed smooth.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,939 views 27 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you