That error usually appears when there's a difference between backends. You should compare the number of affected rows on each backend. If the query you are running is:
UPDATE table SET field1=’something’ WHERE field2=’something_else’; then you should run: SELECT COUNT(*) FROM table WHERE field2=’something_else’; connecting directly to each backend. Once you have discovered what the difference is, you can synchronize backends using pcp_recovery_node. But you have to decide which backends are corrupt and which backends have valid data before you run pcp_recovery_node. Cheers On Mon, 2009-09-28 at 13:31 -0400, [email protected] wrote: > When connecting through pgpool, the query: > > > > UPDATE table SET field1=’something’ WHERE field2=’something_else’; > > > > throws the following error: > > > > ERROR: pgpool detected difference of the number of INSERTS, DELETES, > or UPDATES …(etc. I can’t recall the rest of the error message, but I > know it has something like “type ‘E’ ” > > > > If I connect directly to postgresql, the query is executed > successfully. > > > > I have not been able to test updating other tables because the system > is not available for me for a while. > > > > I’m using pgpool-II 2.2.1 > > > > Any ideas? > > > > Thanks, > > Daniel > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
