[Pgpool-general] Reason for "pgpool detected difference of the number of update tuples"

[Nico -telmich- Schottelius]

Hello!

I am currently getting this error in our application:

2008-05-14 11:08:41,655 FATAL [main] tv.nello.ssp.server.HelloEncoderController: While loop crashed
org.postgresql.util.PSQLException: ERROR: pgpool detected difference of the number of update tuples
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1559)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:193)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)

which is caused by this query:

   DELETE FROM yaeps_monitor

The strange thing is that the count on all backends is the same.

Switching postgres protocol from 3 to 2 makes it work.

Can we not just decline connections that have protocol version 3, until
pgpool2-2 is capable of it?

Nico

p.s.: attached a script to check count(*)s on all backends

-- 
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/

PGP: BFE4 C736 ABE5 406F 8F42  F7CF B8BE F92A 9885 188C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgres-pgpool-diff.sh
Type: application/x-sh
Size: 1450 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080514/11770582/attachment-0001.sh 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080514/11770582/attachment-0001.bin