Clustering Problem

stevenseven77

New Member
May 29, 2024
11
0
1
Dear Proxmox Community,

I need help with my configuration, I do clustering and it was successful, but the state of the cluster was stuck at syncing only. the log says error:
2024-07-15T14:51:40.443368+07:00 pmg1 pmgmirror[776]: starting cluster synchronization
2024-07-15T14:51:40.466133+07:00 pmg1 pmgmirror[776]: database sync 'pmg2' failed - DBI connect('dbname=Proxmox_ruledb;host=/run/pmgtunnel;port=2;','root',...) failed: connection to server on socket "/run/pmgtunnel/.s.PGSQL.2" failed: No such file or directory#012#011Is the server running locally and accepting connections on that socket? at /usr/share/perl5/PMG/DBTools.pm line 66.
2024-07-15T14:51:40.467020+07:00 pmg1 pmgmirror[776]: cluster synchronization finished (1 errors, 0.03 seconds (files 0.00, database 0.02, config 0.00))

While i run pg_lslusters:
root@pmg1:~# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
15 main 5432 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log

My PMG hardware configuration:
2 vCPU
2gb Ram
30gb Storage

What's wrong? Thank you!
 

Attachments

  • 1721030113470.png
    1721030113470.png
    4.6 KB · Views: 12
any messages from pmgtunnel? - and some more logs of pmgmirror might help to see where the issue is rooted
 
here you go, the log from pmg2:

2024-07-22T16:11:32.024456+07:00 pmg2 pmgpolicy[3544]: system memory size of 1.9 GiB is below the recommended 4+ GiB limit!
2024-07-22T16:11:32.248313+07:00 pmg2 pmgpolicy[3548]: Process Backgrounded
2024-07-22T16:11:32.254186+07:00 pmg2 pmgpolicy[3548]: 2024/07/22-16:11:32 main (type Net::Server: PreForkSimple) starting! pid(3548)
2024-07-22T16:11:32.261249+07:00 pmg2 pmgpolicy[3548]: Binding to TCP port 10022 on host 127.0.0.1 with IPv4
2024-07-22T16:11:32.263737+07:00 pmg2 pmgpolicy[3548]: Group Not Defined. Defaulting to EGID '0'
2024-07-22T16:11:32.265786+07:00 pmg2 pmgpolicy[3548]: User Not Defined. Defaulting to EUID '0'
2024-07-22T16:11:32.269883+07:00 pmg2 systemd[1]: Started pmgpolicy.service - Proxmox Mail Gateway Policy Daemon.
2024-07-22T16:11:32.271519+07:00 pmg2 pmgpolicy[3548]: Setting up serialization via flock
2024-07-22T16:11:32.273856+07:00 pmg2 pmgpolicy[3548]: Policy daemon (re)started
2024-07-22T16:11:32.275602+07:00 pmg2 pmgpolicy[3548]: Beginning prefork (5 processes)
2024-07-22T16:11:32.275731+07:00 pmg2 pmgpolicy[3548]: Starting "5" children
2024-07-22T16:11:32.316662+07:00 pmg2 pmgdaemon[3462]: syncing master configuration from 'pmg1ip' failed: rsync error: unexplained error (code 255) at io.c(231) [Receiver=3.2.7]
2024-07-22T16:11:32.400874+07:00 pmg2 pmgdaemon[739]: end task UPID: Pmg22:00000D86:00252754:669E2190:clusterjoin::root@pam: syncing master configuration from 'pmg1ip' failed: rsync error: unexplained error (code 255) at io.c(231) [Receiver=3.2.7]
 
anything from pmgtunnel on either of the nodes?

else - make sure you can connect between both nodes via ssh as root (and are not asked for a password)