Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
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".