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

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

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