This documentation relates to the latest version of Confluence.
If you are using an earlier version, please go to the documentation home page and select the relevant previous version.

Upgrading From HSQL 1.7.1 to 1.8

Added by Tom Davies, last edited by Rosie Jameson on Feb 21, 2007  (view change)
Confluence 2.8 Documentation

Index

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

Labels:

database database Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

Comments (6)

 

  1. Dec 03, 2005

    Othman Alaoui says:

    I remember reading that 1.8 was much more reliable than 1.7.1.. does that mean i...

    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?

    1. Dec 04, 2005

      Daniel Ostermeier says:

      Hi Othman, Yes, 1.8 is reportedly much more reliable than 1.7.x. However, we st...

      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

  2. Dec 05, 2005

    Günter Zöchbauer says:

    C:\Daten\gz\confluence>java \jar "c:\Program Files\confluence2.0.1\hsqlcleaner\ ...

    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)

    1. Dec 05, 2005

      Jeremy Higgs says:

      Günter, If you are having problems with the software, please create a support r...

      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

  3. Jan 16, 2006

    Mathew DeLong says:

    The clean reports: "Cleaning complete" but the initial error remains, and I am s...

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

    1. Jan 16, 2006

      Jeremy Higgs says:

      Hi Mathew, If you are having problems using the cleaner, please create a new sup...

      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 

Add Comment