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

This widget could not be displayed.

Thanks David.

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

This widget could not be displayed.
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 ;-)

This widget could not be displayed.

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
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

235 views 2 4
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