postgresql_cluster
postgresql_cluster copied to clipboard
Error while deploying
Hi, I'm getting this error while deploying the cluster no matter what I try. Can you assist, please? Those it affects the cluster efficiency in any way?

Hi @RoyGRad !
please show what you have specified in vars/system.yml
sysctl_conf variable
Yes, you can ignore it, but I would like to understand the reason for the error
In my case it works (ubuntu 22.04)
TASK [sysctl : Setting kernel parameters] ********************************************************************************************************************************************************************
ok: [172.31.17.229] => (item={'name': 'vm.overcommit_memory', 'value': '2'})
ok: [172.31.17.229] => (item={'name': 'vm.swappiness', 'value': '1'})
ok: [172.31.17.229] => (item={'name': 'vm.min_free_kbytes', 'value': '102400'})
ok: [172.31.17.229] => (item={'name': 'vm.dirty_expire_centisecs', 'value': '1000'})
ok: [172.31.17.229] => (item={'name': 'vm.dirty_background_bytes', 'value': '67108864'})
ok: [172.31.17.229] => (item={'name': 'vm.dirty_bytes', 'value': '536870912'})
ok: [172.31.17.229] => (item={'name': 'vm.zone_reclaim_mode', 'value': '0'})
ok: [172.31.17.229] => (item={'name': 'kernel.numa_balancing', 'value': '0'})
ok: [172.31.17.229] => (item={'name': 'kernel.sched_autogroup_enabled', 'value': '0'})
ok: [172.31.17.229] => (item={'name': 'net.ipv4.ip_nonlocal_bind', 'value': '1'})
ok: [172.31.17.229] => (item={'name': 'net.ipv4.ip_forward', 'value': '1'})
ok: [172.31.17.229] => (item={'name': 'net.ipv4.ip_local_port_range', 'value': '10000 65535'})
ok: [172.31.17.229] => (item={'name': 'net.core.netdev_max_backlog', 'value': '10000'})
ok: [172.31.17.229] => (item={'name': 'net.ipv4.tcp_max_syn_backlog', 'value': '8192'})
ok: [172.31.17.229] => (item={'name': 'net.core.somaxconn', 'value': '65535'})
ok: [172.31.17.229] => (item={'name': 'net.ipv4.tcp_tw_reuse', 'value': '1'})
at first glance, the variables are specified correctly
if you don't use iptables, I recommend commenting out the "net.netfilter.nf_conntrack_max" parameter
See commit a911cb56c6680c25b7b0cc2c08033ccacb4b6a07
please provide information for debugging
ansible-playbook deploy_pgcluster.yml --tag sysctl -vvv >> ansible_sysctl.log