Hi, From: Nico -telmich- Schottelius <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
