[ 
https://issues.apache.org/jira/browse/CONNECTORS-115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12920250#action_12920250
 ] 

Karl Wright commented on CONNECTORS-115:
----------------------------------------

I believe I stumbled over this on Friday and fixed it.  Can you synch up and 
try again?   Bear in mind that you will need to drop the database anyway once, 
because the username has change from "lcf" to "manifoldcf".


> 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.

Reply via email to