Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-320

DBCreate on HSQLDB instance operating in external mode fails second time

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: ManifoldCF 0.4
    • Fix Version/s: ManifoldCF 0.4
    • Component/s: Framework core
    • Labels:
      None

      Description

      When ManifoldCF is configured to run HSQLDB, if you try to create the database twice you get an exception. This is used during upgrades. PostgreSQL works fine here. The exception is:

      C:\wip\mcf\CONNECTORS-313\dist\multiprocess-example>initialize.bat
      Configuration file successfully read
      org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: E
      xception doing query: object name already exists: DBNAME
      at org.apache.manifoldcf.core.database.Database.executeViaThread(Databas
      e.java:672)
      at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Dat
      abase.java:716)
      at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.creat
      e(Database.java:1363)
      at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndEx
      ecute(CacheManager.java:144)
      at org.apache.manifoldcf.core.database.Database.executeQuery(Database.ja
      va:179)
      at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.createUserAndDa
      tabase(DBInterfaceHSQLDB.java:621)
      at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(Man
      ifoldCF.java:683)
      at org.apache.manifoldcf.crawler.RegisterConnectors.createDatabaseAndSch
      ema(RegisterConnectors.java:71)
      at org.apache.manifoldcf.crawler.RegisterAll.doExecute(RegisterAll.java:
      33)
      at org.apache.manifoldcf.crawler.TransactionalCrawlerInitializationComma
      nd.execute(TransactionalCrawlerInitializationCommand.java:43)
      at org.apache.manifoldcf.crawler.RegisterAll.main(RegisterAll.java:55)
      Caused by: java.sql.SQLException: object name already exists: DBNAME
      at org.hsqldb.jdbc.Util.sqlException(Util.java:255)
      at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1838)
      at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636)
      at org.apache.manifoldcf.core.database.Database.execute(Database.java:77
      7)
      at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(D
      atabase.java:632)

        Attachments

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              kwright@metacarta.com Karl Wright
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: