[Bucardo-general] Sync stopped due to ERROR: could not serialize access due to concurrent update

[jbk]

Hi,

Bucardo-4.4.0, master-master, table  dev_conf_option:


device_id integer NOT NULL,
   name character varying(100) NOT NULL,
   value character varying(500),
   mtime timestamp with time zone NOT NULL DEFAULT now(),
   CONSTRAINT dev_conf_option_pkey PRIMARY KEY (device_id, name)


Bucardo stopped sync

cdelta| S   |WAIT:51s|9634|16h4m35s |2m33s|127/53/0|59s     |2m24s

due to

May  8 09:23:27 Debian-60-squeeze-64-minimal Bucardo[9782]: KID [4/158] 
public.dev_conf_option UPDATE source to target pk 11266|PNAOff.LogOut
May  8 09:23:27 Debian-60-squeeze-64-minimal Bucardo[9782]: KID Warning! 
Aborting due to exception for public.dev_conf_option.device_id|name: 
11266|PNAOff.Log
Out Error was DBD::Pg::st execute failed: ERROR:  could not serialize 
access due to concurrent update at 
/usr/local/share/perl/5.10.1/Bucardo.pm line 5713.
May  8 09:23:27 Debian-60-squeeze-64-minimal Bucardo[9782]: KID Final 
database backend PID is 9809
May  8 09:23:27 Debian-60-squeeze-64-minimal Bucardo[9782]: KID Kid 
exiting at cleanup_kid. Reason: Died at 
/usr/local/share/perl/5.10.1/Bucardo.pm line 5778.




Any idea?

[Wed May  8 01:28:58 2013]  CTL Warning! Kid 5078 seems to have died. 
Sync "presentecdelta"
[Wed May  8 01:31:29 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:33:43 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:35:53 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:35:58 2013]  CTL Warning! Kid 5137 seems to have died. 
Sync "presentecdelta"
[Wed May  8 01:38:05 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:40:09 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:42:15 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:44:18 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm
  line 5713.
[Wed May  8 01:46:21 2013]  KID Warning! Aborting due to exception for 
public.dev_conf_option.device_id|name: 11266|PNAOff.LogOut Error was 
DBD::Pg::st execute failed: ERROR: could not serialize access due to 
concurrent update at /usr/local/share/perl/5.10.1/Bucardo.pm

[...]


Regards,
Jost Bökemeier

-- 
Presentec GmbH
Grosse Elbstr. 117
22767 Hamburg
Tel: +49 40 300 66 83-0
Fax: +49 40 300 66 83-29
  
HRB 81418 Hamburg
Ust.-ID No: DE 2208 48 639
Geschäftsf.: Heiko Thölmann