[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