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

[Yoshiyuki Asaba]

Hi,

From: Nico -telmich- Schottelius <nico-pgpool at schottelius.org>
Subject: [Pgpool-general] Reason for "pgpool detected difference of the number of update tuples"
Date: Wed, 14 May 2008 13:09:36 +0200

> 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.

Can you rewrite the query to the following query?

  BEGIN;
  LOCK TABLE yaeps_monitor;
  DELETE FROM yaeps_monitor;
  COMMIT;

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp