hello, pgpool-II-2.3.2.1 is buggy from jdbc postgresql point of views. After sende a bad request from jdbc driver, select * from noexisttable , for example, pgpools sends a STATE 26000 and nothing after, JDBC drivers then do nothing and is blocking in infinite loop. If disconnect JDBC connection and reconnect , JDBC receive error from pgpool about sql bad resquest.
This issues does not exist with pgpool-II-2.3.1. Any suggestion. bad sql requetet trace du driver jdbc postgresql-8.4-701.jdbc4.jar 11:00:44.040 (1) simple execute, handler=org.postgresql.jdbc2.abstractjdbc2statement$statementresulthand...@4f1ada, maxRows=0, fetchSize=0, flags=17 11:00:44.040 (1) FE=> Parse(stmt=null,query="select * from toto",oids={}) 11:00:44.040 (1) FE=> Bind(stmt=null,portal=null) 11:00:44.040 (1) FE=> Describe(portal=null) 11:00:44.040 (1) FE=> Execute(portal=null,limit=0) 11:00:44.040 (1) FE=> Sync 11:00:44.040 (1) <=BE ErrorMessage(ERROR: relation "toto" does not exist) org.postgresql.util.PSQLException: ERROR: relation "toto" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at com.neocoretech.console.debug.SqlDebugEngine.eval(SqlDebugEngine.java:16) at com.neocoretech.console.debug.ui.ScriptDebugPanel$1$1.doInBackground(ScriptDebugPanel.java:45) at javax.swing.SwingWorker$1.call(SwingWorker.java:277) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at javax.swing.SwingWorker.run(SwingWorker.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) SQLException: SQLState(42P01) 11:00:44.240 (1) <=BE ErrorMessage(ERROR: unnamed prepared statement does not exist) org.postgresql.util.PSQLException: ERROR: unnamed prepared statement does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at com.neocoretech.console.debug.SqlDebugEngine.eval(SqlDebugEngine.java:16) at com.neocoretech.console.debug.ui.ScriptDebugPanel$1$1.doInBackground(ScriptDebugPanel.java:45) at javax.swing.SwingWorker$1.call(SwingWorker.java:277) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at javax.swing.SwingWorker.run(SwingWorker.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) SQLException: SQLState(26000) => Connection block in org.postgresql.core.v3.QueryExecutorImpl.processResults(ResultHandler handler, int flags) while (!endQuery) { c = pgStream.ReceiveChar(); <= block } regards, Nicolas Prochazka _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general