I now see 4 log entries as like this: (6234) [Tue Jun 7 19:20:25 2016] MCP Table public.table1 is referenced by public.table2(fk_pri_0), which is not part of this sync!
I guess that's the first thing to fix… From: Matthew Balman <[email protected]<mailto:[email protected]>> Date: Tuesday, June 7, 2016 at 3:54 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Bucardo Crash Hi All, Running bucardo 5.4.1 Any idea why bucardo would crash? We have 2 master dbs with 1 slave. The 2 master Dbs are basically redundant log servers and usually get identical/conflicting records all the time which bucardo usually resolves just fine. Here are my log entries: (29610) [Sun Jun 5 10:47:42 2016] KID (greatsync) Conflicts for public.events: 1 (29610) [Sun Jun 5 10:47:42 2016] KID (greatsync) Conflicts have been resolved (29610) [Sun Jun 5 10:47:42 2016] KID (greatsync) Warning! Aborting due to exception for public.events:? Error was DBD::Pg::db pg_putcopyend failed: ERROR: duplicate key value violates unique constraint "events_pkey"\nDETAIL: Key ("UNIQUE-ID")=(<some long string id>) already exists.\nCONTEXT: COPY events, line 2 at Bucardo.pm line 9879. (29610) [Sun Jun 5 10:47:42 2016] KID (greatsync) Kid has died, error is: DBD::Pg::db pg_putcopyend failed: ERROR: duplicate key value violates unique constraint "events_pkey"\nDETAIL: Key ("UNIQUE-ID")=(<some long string id>) already exists.\nCONTEXT: COPY events, line 2 at Bucardo.pm line 9879. Line: 5041 Main DB state: ? Error: none DB greatdb1 state: ? Error: none DB greatdb2 state: 23505 Error: 7 DB greatdbo state: ? Error: none (29610) [Sun Jun 5 10:47:42 2016] KID (greatsync) Kid 29610 exiting at cleanup_kid. Sync "greatsync" public.events Reason: DBD::Pg::db pg_putcopyend failed: ERROR: duplicate key value violates unique constraint "events_pkey"\nDETAIL: Key ("UNIQUE-ID")=(<some long string id>) already exists.\nCONTEXT: COPY events, line 2 at Bucardo.pm line 9879. Line: 5041 Main DB state: ? Error: none DB greatdb1 state: ? Error: none DB greatdb2 state: 23505 Error: 7 DB greatdbo state: ? Error: none (25509) [Sun Jun 5 10:47:42 2016] MCP Warning: Killed (line 6353): DBD::Pg::db do failed: no connection to the server at Bucardo.pm line 6353. (25534) [Sun Jun 5 10:47:44 2016] CTL Controller for "easync" was killed at line 1755: MCP request (25519) [Sun Jun 5 10:47:44 2016] CTL Controller for "greatsync" was killed at line 1755: MCP request (25537) [Sun Jun 5 10:47:44 2016] KID (easync) Kid has died, error is: CTL request Line: 5001 (25537) [Sun Jun 5 10:47:44 2016] KID (easync) Kid 25537 exiting at cleanup_kid. Sync "easync" public.zenoss_devices Reason: CTL request Line: 5001 (25509) [Sun Jun 5 10:47:44 2016] MCP End of cleanup_mcp. Sys time: Sun Jun 5 10:47:44 2016. Database time: 2016-06-05 10:47:44.239691+00 (25534) [Sun Jun 5 10:47:44 2016] CTL Controller 25534 exiting at cleanup_controller. Reason: MCP request (25519) [Sun Jun 5 10:47:44 2016] CTL Controller 25519 exiting at cleanup_controller. Reason: MCP request /***************************** Matthew Balman Software Engineer EOS Automation Embedded Flight Systems, Inc. [email protected]<mailto:[email protected]> ******************************/
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
