[SOLVED] Issues with syncing

[maenda]

Hi all,

The status of one of the nodes keeps pending on SYNCING and is not going forward.
Checking the logs, gives me the following:

Jul 23 09:55:51 mx-2 pmgmirror[675]: starting cluster syncronization
Jul 23 09:55:51 mx-2 pmgmirror[675]: syncing deleted node 2 from master 'IP'
Jul 23 09:55:51 mx-2 pmgmirror[675]: database sync 'mx-1' failed - DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique constraint "cmailstore_pkey"#012DETAIL:  Key (cid, rid)=(2, 8) already exists. at /usr/share/perl5/PMG/DBTools.pm line 1086.
Jul 23 09:55:52 mx-2 pmgmirror[675]: cluster syncronization finished  (1 errors, 1.60 seconds (files 0.14, database 1.30, config 0.16))

Any idea how to fix this?

Thanks

 

[Stoiko Ivanov]

What were the steps you did to get there? - I assume you have a clustered environment and deleted nodes?!
what's the output of:
`pmgcm status`

 

[maenda]

Hi Stoiko,

The node has been replaced indeed because of the sync problems. The master was not touched. I removed the node by the PMGM DELETE id command.
Also, a letsencrypt certificate has been installed. But I guess this should be no problem?

Output:

pmgcm status
NAME(CID)--------------IPADDRESS----ROLE-STATE---------UPTIME---LOAD----MEM---DISK
mx-1(1)              ip_of_master  master A           22:57   0.18    31%     7%
mx-2(6)              ip_of_node    node   S           22:55   0.18    26%    11%
root@mx-1:~#

 

[Stoiko Ivanov]

I removed the node by the PMGM DELETE id command

did you setup the new node freshly, before adding it to the cluster?
if not - try that.
(keep a backup of the current node and one of the master just in case)

 

[maenda]

did you setup the new node freshly, before adding it to the cluster?
if not - try that.

Yes, it was a fresh install indeed, but I can try again. Will do it right away.
Do I need to delete it from the master first?

 

[Stoiko Ivanov]

delete it - check that it is indeed gone from the cluster configuration (/etc/pmg/cluster.conf) then use a fresh install and add that to the cluster

 

[maenda]

delete it - check that it is indeed gone from the cluster configuration (/etc/pmg/cluster.conf) then use a fresh install and add that to the cluster

Ok, will try it right away,

 

[William Edwards]

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

 

[NICK_k]

@maenda
Have you solved this problem?
If it has been resolved, how did you resolve it?

 

[maenda]

@maenda
Have you solved this problem?
If it has been resolved, how did you resolve it?

Sorry for the terribly late response.
I could not fix it, I reinstalled everything and now it is ok.

Not sure what caused the problem.