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:[email protected]] Sent: Thursday, February 28, 2013 9:34 AM To: [email protected] Cc: [email protected] 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:[email protected]] Sent: 2013-02-28 15:00:21 To: [email protected] 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/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
