[Pgpool-general] Error: pgpool detected difference of the number of...

[Xavier Noguer]

 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, Daniel.Crespo at l-3com.com 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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general