Sync error between two nodes

[michael05]

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:

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:

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

 

[Stoiko Ivanov]

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`

 

[michael05]

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:

5723e36f79774d1303f5f7d697657405eca5f002c6d86b8a459443599c7f9e04

Node 2:

5723e36f79774d1303f5f7d697657405eca5f002c6d86b8a459443599c7f9e04

 

[Stoiko Ivanov]

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`)