This page last changed on Feb 21, 2007 by rosie@atlassian.com.

If you have received an error message while upgrading Confluence which said "HSQL Database needs to be cleaned. Please run HSQL17To18PreUpgradeCleaner.", and referred you to this page, you need to do the following:

  1. Shut down Confluence
  2. Open a command window.
  3. Change your directory to the directory you set as your confluence.home directory.
  4. Execute the following command: java -jar <confluence install directory>/hsqlcleaner/hsqlcleaner.jar
  5. Start Confluence -- the upgrade will now work.

    Don't run this unless asked to by Confluence - it won't work

I remember reading that 1.8 was much more reliable than 1.7.1.. does that mean it can now be used as a production-worthy database for Confluence? Or is still only recommended for evaluation purposes?

Posted by oalaoui at Dec 03, 2005 18:38

Hi Othman,

Yes, 1.8 is reportedly much more reliable than 1.7.x. However, we still recommend that you use it only for evaluation purposes.

Regards,
-Daniel

Posted by daniel@atlassian.com at Dec 04, 2005 20:08

C:\Daten\gz\confluence>java -jar "c:\Program Files\confluence-2.0.1\hsqlcleaner\
hsqlcleaner.jar"
Exception in thread "main" java.lang.RuntimeException: Error
        at com.atlassian.confluence.upgrade.HSQL17To18PreUpgradeCleaner.main(HSQ
L17To18PreUpgradeCleaner.java:39)
Caused by: java.sql.SQLException: Column already exists: Column already exists i
n statement [CREATE TABLE ANCESTORS(DESCENDENTID BIGINT NOT NULL,ANCESTORID BIGI
NT NOT NULL,ANCESTORPOSITION INTEGER NOT NULL,ANCESTORPOSITION INTEGER,CONSTRAIN
T SYS_PK_ANCESTORS PRIMARY KEY(DESCENDENTID,ANCESTORPOSITION),CONSTRAINT FK9EB4C
0E0C45E94DC FOREIGN KEY(DESCENDENTID) REFERENCES CONTENT(CONTENTID),CONSTRAINT F
K9EB4C0E037E35A2E FOREIGN KEY(ANCESTORID) REFERENCES CONTENT(CONTENTID))]
        at org.hsqldb.Trace.getError(Unknown Source)
        at org.hsqldb.Log.runScript(Unknown Source)
        at org.hsqldb.Log.open(Unknown Source)
        at org.hsqldb.Database$Logger.openLog(Unknown Source)
        at org.hsqldb.Database.open(Unknown Source)
        at org.hsqldb.Database.<init>(Unknown Source)
        at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
        at org.hsqldb.jdbcConnection.<init>(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.atlassian.confluence.upgrade.HSQL17To18PreUpgradeCleaner.main(HSQ
L17To18PreUpgradeCleaner.java:26)

Posted by zoechi at Dec 05, 2005 08:34

Günter,

If you are having problems with the software, please create a support request at http://support.atlassian.com/ and we can work through it.

Jeremy

Posted by jeremy@atlassian.com at Dec 05, 2005 18:00

The clean reports: "Cleaning complete" but the initial error remains, and I am still referred by the error to this page.

Posted by mathew.delong at Jan 16, 2006 13:16

Hi Mathew,
If you are having problems using the cleaner, please create a new support request at http://support.atlassian.com/ . If you attach the error messages, we can work through the problem.

Jeremy 

Posted by jeremy@atlassian.com at Jan 16, 2006 19:26
Document generated by Confluence on Mar 22, 2007 20:58