[Bucardo-general] UPDATE's from JDBC connection on '_right' reverting 50% of the time

Greg Sabino Mullane greg at endpoint.com
Mon Nov 1 16:31:22 UTC 2010


On Sun, Oct 31, 2010 at 09:53:31AM -0400, Bill McGonigle wrote:
...
> We have a multi-master (swap) _left _right setup.  From psql, INSERT, 
> DELETE, and UPDATE work in both directions, reliably.
> 
>  From a tomcat app, using JDBC, all work reliably against _left, where 
> the bucardo process is running, and INSERT and DELETE work reliably 
> against _right.
> 
> What we're seeing is when an UPDATE is written to _right, we see the 
> data land in _right, and then about half the time, it replicates to 
> _left, half the time, _right reverts to the _left value within a second 
> or to (our typical replication latency).

Yep, that's pretty odd. I'd see if I can duplicate the exact update 
jdbc is doing from the command line psql. (You might also check the log.bucardo 
file to see if can give a clue as to what is going on). Flipping 
log_statement to 'all' for a minute in postgresql.conf should show you 
exactly what statements tomcat is issuing.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20101101/b1bc5e02/attachment.bin 


More information about the Bucardo-general mailing list