[Bucardo-general] could not serialize access due to read/write

Greg Sabino Mullane greg at endpoint.com
Fri Jun 1 17:10:50 UTC 2012


....
> Before upgrading master node to 9.1.3, there were no errors.

Ah...you could try lowering the isolation level in that case. 
Look inside Bucardo.pm and change all occurances of:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

to:

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

Those two are very different in 9.1, but were the 
same before then. See:

http://blog.endpoint.com/2011/09/postgresql-allows-for-different.html

Please let us know if that changes things for you, because 
if it does, we'll probably have to at least add a config 
variable in there.

-- 
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/20120601/0b979fcd/attachment.sig>


More information about the Bucardo-general mailing list