Sync error between two nodes

michael05

New Member
Feb 21, 2023
2
0
1
I've created a new cluster with 2 nodes. After creating the cluster and joining the node i get the following error on the second node:
Code:
Feb 21 19:27:28 node2 pmgmirror[41366]: database sync 'node1' failed - DBD::Pg::st execute failed: ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification at /usr/share/perl5/PMG/Cluster.pm line 818.

This error is logged on every sync and the node is always in state "syncing".

Does anyone know how to resolve this?

Thanks in advance!

Edit: Versions on both nodes:
Code:
proxmox-mailgateway: 7.2-1
pmg-api: 7.2-4
pmg-gui: 3.2-2
pve-kernel-helper: 7.3-4
pve-kernel-5.15: 7.3-2
pve-kernel-5.13: 7.1-9
pve-kernel-5.15.85-1-pve: 5.15.85-1
pve-kernel-5.15.83-1-pve: 5.15.83-1
pve-kernel-5.13.19-6-pve: 5.13.19-15
pve-kernel-5.13.19-1-pve: 5.13.19-3
clamav-daemon: 0.103.8+dfsg-0+deb11u1
ifupdown2: 3.1.0-1+pmx3
libarchive-perl: 3.4.0-1
libjs-extjs: 7.0.0-1
libjs-framework7: 4.4.7-1
libproxmox-acme-perl: 1.4.3
libproxmox-acme-plugins: 1.4.3
libpve-apiclient-perl: 3.2-1
libpve-common-perl: 7.3-2
libpve-http-server-perl: 4.1-5
libxdgmime-perl: 1.0-1
lvm2: 2.03.11-2.1
pmg-docs: 7.2-1
pmg-i18n: 2.8-2
pmg-log-tracker: 2.3.2-1
postgresql-13: 13.9-0+deb11u1
proxmox-mini-journalreader: 1.3-1
proxmox-offline-mirror-helper: 0.5.1-1
proxmox-spamassassin: 3.4.6-5
proxmox-widget-toolkit: 3.5.5
pve-firmware: 3.6-3
pve-xtermjs: 4.16.0-1
zfsutils-linux: 2.1.9-pve1
 
Last edited:
This error is logged on every sync and the node is always in state "syncing".
haven't seen this error until now (which at least means it's not that common)...

do you have any modifications on your PMG?
* could you try running:
`apt install --reinstall pmg-api` (and rebooting afterwards)
* else - could you please share the output of:
` sha256sum /usr/share/perl5/PMG/Cluster.pm`
 
haven't seen this error until now (which at least means it's not that common)...

do you have any modifications on your PMG?
* could you try running:
`apt install --reinstall pmg-api` (and rebooting afterwards)
* else - could you please share the output of:
` sha256sum /usr/share/perl5/PMG/Cluster.pm`
I don't have any modifications, just the plain install of the PMG. I had a cluster of two nodes before, but due to my cloud provider, i had to migrate these. Therefore I setup a new PMG, joined this to the existing cluster, promoted it to master node, removed the other two nodes, installed a second PMG on new cloud provider and joined this to the cluster. Now I'm getting this error.

I tried reinstalling pmg-api on both nodes and rebooting but the error persists.

Output of file:
Node 1:
Code:
5723e36f79774d1303f5f7d697657405eca5f002c6d86b8a459443599c7f9e04
Node 2:
Code:
5723e36f79774d1303f5f7d697657405eca5f002c6d86b8a459443599c7f9e04
 
Last edited:
The files look okay

I just tried reproducing your setup with the promoting and deleting and joining - but here it seems to work without any problems.

Additionally looking at the postgres error it seems that this should not happen - the primary key of the table should provide the unique constraint...

did you get any errors while joining the new node?

what's the output of `\d localstat` on both nodes in a psql shell (as root type `psql Proxmox_ruledb` and in the resulting shell `\d localstat`)
 

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 yours easily in our online shop.

Buy now!