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

Restarting the example fails when db present

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • ManifoldCF 0.1
    • None
    • None
    • Windows XP, Example running with PostgreSQL instead of embedded derby. Use defaults for dbname, user, and password.

    Description

      When you restart the example you get the following:

      C:\Program Files\Apache\apache-acf\example>java -jar start.jar
      Configuration file successfully read
      org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: ERROR: database "d
      bname" already exists
      at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:421)
      at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:465)
      at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1072)
      at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
      at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:167)
      at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:50
      8)
      at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:638)
      at org.apache.manifoldcf.jettyrunner.ManifoldCFJettyRunner.main(ManifoldCFJettyRunner.java:202)
      Caused by: org.postgresql.util.PSQLException: ERROR: database "dbname" already exists
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329)
      at org.apache.manifoldcf.core.database.Database.execute(Database.java:526)
      at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:381)

      C:\Program Files\Apache\apache-acf\example>

      The only way to get it started is dropping the table it created the first time, in this case "dbname".

      Attachments

        Activity

          People

            kwright@metacarta.com Karl Wright
            farside Farzad
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: