<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hello there,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have installed bucardo for creating postgresql 13 Multi-Master cluster. It’s was working fine, just after almost 3 hours, Its not able to sync. The below logs and let me know if you need any further details.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Bucardo version 5.6.0<o:p></o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in">Debian 11<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in">
<p class="MsoNormal" style="border:none;padding:0in">It was working<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">1329) [Mon Jul 10 21:39:39 2023] MCP Active syncs: 1<o:p></o:p></p>
<p class="MsoNormal">(1329) [Mon Jul 10 21:39:39 2023] MCP Entering main loop<o:p></o:p></p>
<p class="MsoNormal">(1333) [Mon Jul 10 21:39:39 2023] VAC New VAC daemon. PID=1333<o:p></o:p></p>
<p class="MsoNormal">(1333) [Mon Jul 10 21:39:39 2023] VAC Connected to database "PBX01" with backend PID of 1335<o:p></o:p></p>
<p class="MsoNormal">(1329) [Mon Jul 10 21:39:39 2023] MCP Created VAC 1333<o:p></o:p></p>
<p class="MsoNormal">(1336) [Mon Jul 10 21:39:39 2023] CTL New controller for sync "dbsync". Relgroup is "FusionPBXDB-Herd", dbs is "Cluster01". PID=1336<o:p></o:p></p>
<p class="MsoNormal">(1336) [Mon Jul 10 21:39:39 2023] CTL stayalive: 1 checksecs: 0 kicked: 1<o:p></o:p></p>
<p class="MsoNormal">(1336) [Mon Jul 10 21:39:39 2023] CTL kidsalive: 1 onetimecopy: 0 lifetimesecs: 0 (NULL) maxkicks: 0<o:p></o:p></p>
<p class="MsoNormal">(1336) [Mon Jul 10 21:39:39 2023] CTL Database "PBX01" backend PID: 1338<o:p></o:p></p>
<p class="MsoNormal">(1329) [Mon Jul 10 21:39:39 2023] MCP Created controller 1336 for sync "dbsync". Kick is 1<o:p></o:p></p>
<p class="MsoNormal">(1336) [Mon Jul 10 21:39:39 2023] CTL Database "PBX02" backend PID: 1381<o:p></o:p></p>
<p class="MsoNormal">(1339) [Mon Jul 10 21:39:39 2023] KID (dbsync) New kid, sync "dbsync" alive=1 Parent=1336 PID=1339 kicked=1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">========================================================<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Stopped working:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:17 2023] MCP Ping failed for database PBX02, trying to reconnect<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:17 2023] MCP Warning: Killed (line 6518): DBD::Pg::db pg_notifies failed: server closed the connection unexpectedly<o:p></o:p></p>
<p class="MsoNormal"> This probably means the server terminated abnormally<o:p></o:p></p>
<p class="MsoNormal"> before or while processing the request. at /usr/local/share/perl/5.32.1/Bucardo.pm line 6518.<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:17 2023] MCP Database PBX02 failed ping check<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:17 2023] MCP Starting check_sync_health<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:17 2023] MCP Database problem, will respawn after a short sleep: 15<o:p></o:p></p>
<p class="MsoNormal">(1336) [Tue Jul 11 00:48:18 2023] CTL Controller for "dbsync" was killed at line 1769: MCP request<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:18 2023] MCP End of cleanup_mcp. Sys time: Tue Jul 11 00:48:18 2023. Database time: 2023-07-11 00:48:18.925492+04:30<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:18 2023] MCP Sleep time: 15<o:p></o:p></p>
<p class="MsoNormal">(1339) [Tue Jul 11 00:48:19 2023] KID (dbsync) Kid has died, error is: CTL request Line: 4997<o:p></o:p></p>
<p class="MsoNormal">(1339) [Tue Jul 11 00:48:19 2023] KID (dbsync) Ping failed for database PBX02<o:p></o:p></p>
<p class="MsoNormal">(1339) [Tue Jul 11 00:48:19 2023] KID (dbsync) Kid 1339 exiting at cleanup_kid. Sync "dbsync" public.v_user_groups Reason: CTL request Line: 4997<o:p></o:p></p>
<p class="MsoNormal">(1336) [Tue Jul 11 00:48:19 2023] CTL Controller 1336 exiting at cleanup_controller. Reason: MCP request<o:p></o:p></p>
<p class="MsoNormal">(1329) [Tue Jul 11 00:48:33 2023] MCP Respawn attempt: /usr/local/bin/bucardo restart start 'Attempting automatic respawn after MCP death'<o:p></o:p></p>
<p class="MsoNormal">(1951) [Tue Jul 11 00:48:37 2023] MCP Starting Bucardo version 5.6.0<o:p></o:p></p>
<p class="MsoNormal">(1951) [Tue Jul 11 00:48:37 2023] MCP Log level: normal<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Local epoch: 1689020317.53947 DB epoch: 1689020317.53958<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Local time: Tue Jul 11 00:48:37 2023 DB time: 2023-07-11 00:48:37.539575+04:30<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Local timezone: +0430 (+0430) DB timezone: Asia/Kabul<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Postgres version: 130011<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Database port: 5432<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Database host: /var/run/postgresql<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP PID: 1952<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Postgres library version: 130000<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP bucardo: /usr/local/bin/bucardo<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Bucardo.pm: /usr/local/share/perl/5.32.1/Bucardo.pm<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP OS: linux Perl: /usr/bin/perl 5.32.1<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP DBI version: 1.643 DBD::Pg version: 3.14.2 (31402) DBIx::Safe version: 1.2.5<o:p></o:p></p>
<p class="MsoNormal">(1952) [Tue Jul 11 00:48:37 2023] MCP Bucardo object:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Kindly share your advices, how can fix this.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">thanks<o:p></o:p></p>
</div>
</body>
</html>