ManifoldCF
  1. ManifoldCF
  2. CONNECTORS-320

DBCreate on HSQLDB instance operating in external mode fails second time

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Blocker 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)

        Activity

          People

          • Assignee:
            Karl Wright
            Reporter:
            Karl Wright
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development