Version support missing and gpcheck issue
search cancel

Version support missing and gpcheck issue

book

Article ID: 296251

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

We have changed the OS parameters of our UNIX GP servers as per the recommended values in the Installation Guide provided (https://gpdb.docs.pivotal.io/43303/pdf/GPDB43InstallGuide.pdf).

Set the following parameters in the /etc/sysctl.conf file and reboot:
kernel.shmmax = 500000000
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 500 1024000 200 4096
kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.msgmni = 2048
net.ipv4.tcp_syncookies = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.conf.all.arp_filter = 1
net.ipv4.ip_local_port_range = 10000 65535
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.overcommit_memory = 2


But the DB is throwing the following error after the parameter change.
 

20191016:14:39:19:168489 gpcheck:CTSINPUNV1CPGPM:gpadmin-[ERROR]:-GPCHECK_ERROR host(CTS######CPGP1): /etc/sysctl.conf value for key 'kernel.sem' has value '500 1024000 200 4096' and expects '250 512000 100 

2048' 20191016:14:39:19:168489 gpcheck:CTSINPUNV1CPGPM:gpadmin-[ERROR]:-GPCHECK_ERROR host(CTS######CPGP1): /etc/sysctl.conf value for key 'net.ipv4.ip_local_port_range' has value '10000 65535' and expects '1025 65535' DB version : 4.3.30.4



Environment

Product Version: 4.3

Resolution

Given that the issue is in 4.x and 5.x and that we’ve removed gpcheck from GPDB 6 onwards, this issue will not be fixed and instead the the Document has been updated to reflect this. This error can be ignored its due to a problem with the current GPCHECK.