[
https://issues.apache.org/jira/browse/CONNECTORS-115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Farzad updated CONNECTORS-115:
------------------------------
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".
was:
When you restart the example you get the following:
Environment: Windows XP, Example running with PostgreSQL instead of
embedded derby. Use defaults for dbname, user, and password. (was: Windows
XP, Example running with PostgreSQL instead of embedded derby)
> Restarting the example fails when db present
> --------------------------------------------
>
> Key: CONNECTORS-115
> URL: https://issues.apache.org/jira/browse/CONNECTORS-115
> Project: ManifoldCF
> Issue Type: Bug
> Environment: Windows XP, Example running with PostgreSQL instead of
> embedded derby. Use defaults for dbname, user, and password.
> Reporter: Farzad
>
> 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".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
