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
postgres-pgpool-diff.sh
Description: Bourne shell script
signature.asc
Description: Digital signature
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
