postgresql_cluster icon indicating copy to clipboard operation
postgresql_cluster copied to clipboard

Error while deploying

Open RoyGRad opened this issue 3 years ago • 6 comments

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?

image

RoyGRad avatar Aug 31 '22 10:08 RoyGRad

Hi @RoyGRad !

please show what you have specified in vars/system.yml

sysctl_conf variable

vitabaks avatar Aug 31 '22 17:08 vitabaks

Yes, you can ignore it, but I would like to understand the reason for the error

vitabaks avatar Aug 31 '22 17:08 vitabaks

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'})

vitabaks avatar Aug 31 '22 17:08 vitabaks

Hi Vitaly,

I'm running it on Ubuntu 20.04. Here is the system.yml

system.txt

RoyGRad avatar Aug 31 '22 17:08 RoyGRad

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

vitabaks avatar Aug 31 '22 17:08 vitabaks

please provide information for debugging

ansible-playbook deploy_pgcluster.yml --tag sysctl -vvv >> ansible_sysctl.log

vitabaks avatar Aug 31 '22 17:08 vitabaks