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