[ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12988665#comment-12988665 ]
Karl Wright commented on CONNECTORS-148: ---------------------------------------- All of this is a downstream result of the change that removed quoteSQLString() from the database abstraction; it turns out there are at least a couple of cases where you MUST use quoting or the query does not reliably work under PostgreSQL. It's not clear exactly what other conditions contribute to the intermittent nature of the problem, but if your PostgreSQL is in the proper "state", you simply cannot create the ManifoldCF database, no matter how many times you retry. > Creating database in PostgreSQL does not work > --------------------------------------------- > > Key: CONNECTORS-148 > URL: https://issues.apache.org/jira/browse/CONNECTORS-148 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Affects Versions: ManifoldCF 0.1 > Reporter: Karl Wright > Assignee: Karl Wright > Priority: Blocker > Fix For: ManifoldCF 0.1 > > > When you try to create a PostgreSQL database, you get back the following > error: > Exception: Database exception: Exception doing query: ERROR: syntax error at > or near "$1" > org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database > exception: Exception doing query: ERROR: syntax error at or near "$1" > at > org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:461) > at > org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:505) > at > org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1131) > at > org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) > at > org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:168) > at > org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:536) > at > org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:656) > at > org.apache.manifoldcf.jettyrunner.ManifoldCFJettyRunner.main(ManifoldCFJettyRunner.java:202) > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near > "$1" > 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:351) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) > at > org.apache.manifoldcf.core.database.Database.execute(Database.java:606) > at > org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:421) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira