You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Farzad (JIRA)" <ji...@apache.org> on 2010/10/12 17:58:36 UTC
[jira] Created: (CONNECTORS-115) Restarting the example fails when
db present
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
Reporter: Farzad
When you restart the example you get the following:
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (CONNECTORS-115) Restarting the example fails when
db present
Posted by "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.
[jira] Updated: (CONNECTORS-115) Restarting the example fails when
db present
Posted by "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.
[jira] Commented: (CONNECTORS-115) Restarting the example fails
when db present
Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
[ 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.