Re: [Bucardo-general] could not serialize Error in new PG9.2 install

Thu, 28 Feb 2013 06:34:27 -0800

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

Reply via email to