[SOLVED] Issues with syncing

maenda

New Member
Jul 10, 2020
23
0
1
46
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:

Code:
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
 
Last edited:

Stoiko Ivanov

Proxmox Staff Member
Staff member
May 2, 2018
5,988
828
148
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

New Member
Jul 10, 2020
23
0
1
46
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:

Code:
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

Proxmox Staff Member
Staff member
May 2, 2018
5,988
828
148
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)
 

Stoiko Ivanov

Proxmox Staff Member
Staff member
May 2, 2018
5,988
828
148
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

New Member
Jul 10, 2020
23
0
1
46
@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.
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get your own in 60 seconds.

Buy now!