[Bucardo-general] Bucardo 5.6.0 Sync Issue after long time

Tue Jul 11 05:29:45 UTC 2023

Hello there,

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.

Bucardo version 5.6.0
Debian 11

It was working

1329) [Mon Jul 10 21:39:39 2023] MCP Active syncs: 1
(1329) [Mon Jul 10 21:39:39 2023] MCP Entering main loop
(1333) [Mon Jul 10 21:39:39 2023] VAC New VAC daemon. PID=1333
(1333) [Mon Jul 10 21:39:39 2023] VAC Connected to database "PBX01" with backend PID of 1335
(1329) [Mon Jul 10 21:39:39 2023] MCP Created VAC 1333
(1336) [Mon Jul 10 21:39:39 2023] CTL New controller for sync "dbsync". Relgroup is "FusionPBXDB-Herd", dbs is "Cluster01". PID=1336
(1336) [Mon Jul 10 21:39:39 2023] CTL   stayalive: 1 checksecs: 0 kicked: 1
(1336) [Mon Jul 10 21:39:39 2023] CTL   kidsalive: 1 onetimecopy: 0 lifetimesecs: 0 (NULL) maxkicks: 0
(1336) [Mon Jul 10 21:39:39 2023] CTL Database "PBX01" backend PID: 1338
(1329) [Mon Jul 10 21:39:39 2023] MCP Created controller 1336 for sync "dbsync". Kick is 1
(1336) [Mon Jul 10 21:39:39 2023] CTL Database "PBX02" backend PID: 1381
(1339) [Mon Jul 10 21:39:39 2023] KID (dbsync) New kid, sync "dbsync" alive=1 Parent=1336 PID=1339 kicked=1

========================================================

Stopped working:

(1329) [Tue Jul 11 00:48:17 2023] MCP Ping failed for database PBX02, trying to reconnect
(1329) [Tue Jul 11 00:48:17 2023] MCP Warning: Killed (line 6518): DBD::Pg::db pg_notifies failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request. at /usr/local/share/perl/5.32.1/Bucardo.pm line 6518.
(1329) [Tue Jul 11 00:48:17 2023] MCP Database PBX02 failed ping check
(1329) [Tue Jul 11 00:48:17 2023] MCP Starting check_sync_health
(1329) [Tue Jul 11 00:48:17 2023] MCP Database problem, will respawn after a short sleep: 15
(1336) [Tue Jul 11 00:48:18 2023] CTL Controller for "dbsync" was killed at line 1769: MCP request
(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
(1329) [Tue Jul 11 00:48:18 2023] MCP Sleep time: 15
(1339) [Tue Jul 11 00:48:19 2023] KID (dbsync) Kid has died, error is: CTL request Line: 4997
(1339) [Tue Jul 11 00:48:19 2023] KID (dbsync) Ping failed for database PBX02
(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
(1336) [Tue Jul 11 00:48:19 2023] CTL Controller 1336 exiting at cleanup_controller. Reason: MCP request
(1329) [Tue Jul 11 00:48:33 2023] MCP Respawn attempt: /usr/local/bin/bucardo restart start 'Attempting automatic respawn after MCP death'
(1951) [Tue Jul 11 00:48:37 2023] MCP Starting Bucardo version 5.6.0
(1951) [Tue Jul 11 00:48:37 2023] MCP Log level: normal
(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Local epoch: 1689020317.53947  DB epoch: 1689020317.53958
(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
(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Local timezone: +0430 (+0430)  DB timezone: Asia/Kabul
(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Postgres version: 130011
(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Database port: 5432
(1952) [Tue Jul 11 00:48:37 2023] MCP Master DB Database host: /var/run/postgresql
(1952) [Tue Jul 11 00:48:37 2023] MCP PID: 1952
(1952) [Tue Jul 11 00:48:37 2023] MCP Postgres library version: 130000
(1952) [Tue Jul 11 00:48:37 2023] MCP bucardo: /usr/local/bin/bucardo
(1952) [Tue Jul 11 00:48:37 2023] MCP Bucardo.pm: /usr/local/share/perl/5.32.1/Bucardo.pm
(1952) [Tue Jul 11 00:48:37 2023] MCP OS: linux  Perl: /usr/bin/perl 5.32.1
(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
(1952) [Tue Jul 11 00:48:37 2023] MCP Bucardo object:

Kindly share your advices, how can fix this.

thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20230711/5b97c233/attachment.htm>