[jira] Resolved: (CONNECTORS-115) Restarting the example fails when db present

["Karl Wright (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CONNECTORS-115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright resolved CONNECTORS-115.
------------------------------------

       Resolution: Fixed
    Fix Version/s: LCF Release 0.5
         Assignee: Karl Wright

I found the fix that corresponds to this report.

------------------------------------------------------------------------
r1006085 | kwright | 2010-10-08 20:43:45 -0400 (Fri, 08 Oct 2010) | 1 line

Fix problem with postgreSQL implementation which causes second run of DBCreate to fail.



> 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
>            Assignee: Karl Wright
>             Fix For: LCF Release 0.5
>
>
> 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.