[Bucardo-general] could not serialize Error in new PG9.2 install
Jonathan Brinkman
jb at blackskytech.com
Thu Feb 28 17:12:50 UTC 2013
Thank you so much!! that was it.
(Plus restart postgresql of course)
psql bucardo
UPDATE bucardo.sync SET txnmode='REPEATABLE READ';
\q
sudo /etc/init.d/postgresql restart
From: Adam Kozłowski [mailto:tronix.ak at gmail.com]
Sent: Thursday, February 28, 2013 9:34 AM
To: jb at blackskytech.com
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] could not serialize Error in new PG9.2 install
Hi
You have to change transaction isolation level for each sync.
Default for bucardo is "SERIALIZABLE".
For PG versions prior 9.1, serializable was treated as repeatable read... so in fact there was no difference.
UPDATE bucardo.sync SET txnmode='REPEATABLE READ';
/Adam Kozlowski
-----Original Message-----
From: Jonathan Brinkman [mailto:jb at blackskytech.com]
Sent: 2013-02-28 15:00:21
To: bucardo-general at bucardo.org
Subject: [Bucardo-general] could not serialize Error in new PG9.2 install
I upgraded Ubuntu to 12.04LTS and Postgresql from 8.4 to 9.2.
I reinstalled bucardo 4.5.0.
Install went ok.
When I start my push delta I get this error:
[Thu Feb 28 08:47:41 2013] KID Kid exiting at cleanup_kid. Reason: DBD::Pg::st execute failed: ERROR: could not serialize access due to read/write dependencies among transactions
DETAIL: Reason code: Canceled on identification as a pivot, during write.
HINT: The transaction might succeed if retried. at /usr/local/share/perl/5.14.2/Bucardo.pm line 5976.
main error: none source error: 7 target error: none States:/40001/
More information about the Bucardo-general
mailing list