vmware-archive / sre-test

Greenplum - Open Source SRE test project.
2 stars 0 forks source link

log_hostname parameter causes problem on turning "on", gpconfig fails to work. #214

Closed bala-cg closed 3 years ago

bala-cg commented 3 years ago

Page No: 1363

Issue: log_hostname parameter causes problem on turning "on", gpconfig fails to work.

Testing:

[gpadmin@mdw_ipv4 ~]$ gpconfig -s log_hostname Values on all segments are consistent GUC : log_hostname Master value: off Segment value: off [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# show log_hostname; log_hostname

off (1 row)

gpadmin=# set log_hostname = on; ERROR: parameter "log_hostname" cannot be changed now gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c log_hostname -v on 20210725:14:02:02:003101 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c log_hostname -v on' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210725:14:02:11:003181 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210725:14:02:11:003181 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210725:14:02:11:003181 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210725:14:02:11:003181 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210725:14:02:11:003181 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210725:14:02:11:003181 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s log_hostname 20210725:14:02:16:003219 gpconfig:mdw_ipv4:gpadmin-[ERROR]:-Failed to retrieve GUC information: error 'ERROR: interconnect error: Could not parse remote listener address: 'mdw_ipv4' port '31247': Name or service not known (seg0 slice1 10.0.25.114:4000 pid=24872) DETAIL: getaddrinfo() unable to parse address: 'mdw_ipv4' CONTEXT: SQL function "gp_param_setting" statement 1 ' in 'select * from gp_toolkit.gp_param_setting('log_hostname')' 'NoneType' object is not iterable [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -a 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -a 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart' 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Master segment instance directory=/data1/gpdb/master/gpseg-1 20210725:14:02:56:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Stopping master segment and waiting for user connections to finish ... server shutting down 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Terminating processes for segment /data1/gpdb/master/gpseg-1 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-No standby master host configured 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Targeting dbid [2, 8, 3, 9, 4, 10, 5, 11, 6, 12, 7, 13] for shutdown 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait... 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait... 20210725:14:02:57:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments stopped successfully = 12 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments with errors during stop = 0 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown 12 of 12 segment instances 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpmmon process 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpmmon process found 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts 20210725:14:02:58:003284 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover shared memory [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstart -a 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Starting gpstart with args: -a 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232' 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Starting Master instance in admin mode 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Setting new master era 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Master Started... 20210725:14:03:33:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Shutting down master 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait... 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Process results... 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:- Successful segment starts = 12 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:- Failed segment starts = 0 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Successfully started 12 of 12 segment instances 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210725:14:03:34:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Starting Master instance mdw_ipv4 directory /data1/gpdb/master/gpseg-1 20210725:14:03:35:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Command pg_ctl reports Master mdw_ipv4 instance active 20210725:14:03:35:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Connecting to dbname='template1' connect_timeout=15 20210725:14:03:35:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-No standby master configured. skipping... 20210725:14:03:35:003468 gpstart:mdw_ipv4:gpadmin-[INFO]:-Database successfully started [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s log_hostname 20210725:14:03:41:003571 gpconfig:mdw_ipv4:gpadmin-[ERROR]:-Failed to retrieve GUC information: error 'ERROR: interconnect error: Could not parse remote listener address: 'mdw_ipv4' port '35196': Name or service not known (seg0 slice1 10.0.25.114:4000 pid=25392) DETAIL: getaddrinfo() unable to parse address: 'mdw_ipv4' CONTEXT: SQL function "gp_param_setting" statement 1 ' in 'select * from gp_toolkit.gp_param_setting('log_hostname')' 'NoneType' object is not iterable [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -r log_hostname 20210725:14:04:09:003649 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-r log_hostname' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210725:14:04:18:003728 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210725:14:04:18:003728 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210725:14:04:18:003728 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210725:14:04:18:003728 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210725:14:04:18:003728 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210725:14:04:18:003728 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s log_hostname Values on all segments are consistent GUC : log_hostname Master value: off Segment value: off [gpadmin@mdw_ipv4 ~]$