Stuck on syncing

[koby]

Hello Guys,
I created a cluster according to the doc , but I forgot to open port 8006 open to both of the cluster node.
(I thought that I need only port 22...).
After that , I did open the needed port and try to sync ,
I do see the two node , but they are always on "syncing" position and not on active as it should be.
I also did some sync test and I manage to see the rule header name does sync.
In farther testing it seems that the attachment quarantine is not the same on both nodes as well as the virus quarantine is not the same .
Please advice.

I am working on PMG ver 6.3-5 on both nodes.

Best Regards ,
Koby Peleg Hen

 

[dcsapak]

what do the logs say (syslog/journal)?

 

[koby]

what do the logs say (syslog/journal)?

Sorry can't find that.
Can you please be more precise.

Best Regards ,
Koby Peleg Hen

 

[koby]

Sorry can't find that.
Can you please be more precise.

Best Regards ,
Koby Peleg Hen

I manage to find this ..

failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections at /usr/share/perl5/PMG/DBTools.pm line 68.cluster syncronization finished  (1 errors, 0.08 seconds (files 0.00, database 0.07, config 0.00))
Feb 02 19:17:19 smg01 pmgmirror[1637]: starting cluster syncronization
Feb 02 19:17:19 smg01 pmgmirror[1637]: database sync 'smg02' failed - DBI connect('dbname=Proxmox_ruledb;host=/run/pmgtunnel;port=2;','root',...) failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections at /usr/share/perl5/PMG/DBTools.pm line 68.
Feb 02 19:17:19 smg01 pmgmirror[1637]: cluster syncronization finished  (1 errors, 0.09 seconds (files 0.00, database 0.09, config 0.00))
Feb 02 19:19:19 smg01 pmgmirror[1637]: starting cluster syncronization
Feb 02 19:19:19 smg01 pmgmirror[1637]: database sync 'smg02' failed - DBI connect('dbname=Proxmox_ruledb;host=/run/pmgtunnel;port=2;','root',...) failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections at /usr/share/perl5/PMG/DBTools.pm line 68.
Feb 02 19:19:19 smg01 pmgmirror[1637]: cluster syncronization finished  (1 errors, 0.07 seconds (files 0.00, database 0.07, config 0.00))
Feb 02 19:21:19 smg01 pmgmirror[1637]: starting cluster syncronization
Feb 02 19:21:19 smg01 pmgmirror[1637]: database sync 'smg02' failed - DBI connect('dbname=Proxmox_ruledb;host=/run/pmgtunnel;port=2;','root',...) failed: FATAL:  remaining connection slots are reserved for non-replication superuser connections at /usr/share/perl5/PMG/DBTools.pm line 68.
Feb 02 19:21:19 smg01 pmgmirror[1637]: cluster syncronization finished  (1 errors, 0.08 seconds (files 0.00, database 0.08, config 0.00))
~

Please advice

 

[dcsapak]

mhmm.. did you some customization of the postgres?
can you post a bit more of your syslog?

 

[William Edwards]

Take a look at this: https://forum.proxmox.com/threads/master-stuck-in-syncing-state.63450/#post-290439

 

[koby]

Hello guys ,
I would like to info you that my issue was resolved by updating the systems.
I could see that was some update to postgesql , and immediate after it , the cluster become sync.
I am not really understand what truly happened.
But what important that it is fine now.
I hope it would help someone.

Best Regards
Koby Peleg Hen.