Closed bala-cg closed 3 years ago
Page No : 1369
Issue: After reverting the parameter(max_prepared_transactions) change it shows a different value than the default value.
Testing:
[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 250 Segment value: 250 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c max_prepared_transactions -v 200 20210726:06:17:04:024150 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c max_prepared_transactions -v 200' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 250 Segment value: 250 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstart -arf Usage: gpstart [--help] [options]
gpstart: error: no such option: -r [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -arf 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -arf 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast' 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Master segment instance directory=/data1/gpdb/master/gpseg-1 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Terminating processes for segment /data1/gpdb/master/gpseg-1 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Stopping master standby host smdw_ipv4 mode=fast 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown standby process on smdw_ipv4 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Targeting dbid [2, 8, 3, 9, 4, 10, 5, 11, 6, 12, 7, 13] for shutdown 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait... 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait... 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments stopped successfully = 12 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments with errors during stop = 0 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown 12 of 12 segment instances 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpmmon process 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpmmon process found 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover shared memory 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Restarting System... [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 200 Segment value: 200 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -r max_prepared_transactions 20210726:06:18:02:024565 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-r max_prepared_transactions' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -arf 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -arf 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast' 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Master segment instance directory=/data1/gpdb/master/gpseg-1 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Terminating processes for segment /data1/gpdb/master/gpseg-1 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Stopping master standby host smdw_ipv4 mode=fast 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown standby process on smdw_ipv4 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Targeting dbid [2, 8, 3, 9, 4, 10, 5, 11, 6, 12, 7, 13] for shutdown 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait... 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait... 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments stopped successfully = 12 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments with errors during stop = 0 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown 12 of 12 segment instances 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpmmon process 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpmmon process found 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes 20210726:06:18:11:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts 20210726:06:18:11:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover shared memory 20210726:06:18:11:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Restarting System... [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 50 Segment value: 50 [gpadmin@mdw_ipv4 ~]$
Page No : 1369
Issue: After reverting the parameter(max_prepared_transactions) change it shows a different value than the default value.
Testing:
[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 250 Segment value: 250 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c max_prepared_transactions -v 200 20210726:06:17:04:024150 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c max_prepared_transactions -v 200' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210726:06:17:12:024231 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 250 Segment value: 250 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstart -arf Usage: gpstart [--help] [options]
gpstart: error: no such option: -r [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -arf 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -arf 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast' 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Master segment instance directory=/data1/gpdb/master/gpseg-1 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Terminating processes for segment /data1/gpdb/master/gpseg-1 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Stopping master standby host smdw_ipv4 mode=fast 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown standby process on smdw_ipv4 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Targeting dbid [2, 8, 3, 9, 4, 10, 5, 11, 6, 12, 7, 13] for shutdown 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait... 20210726:06:17:29:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait... 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments stopped successfully = 12 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments with errors during stop = 0 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown 12 of 12 segment instances 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpmmon process 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpmmon process found 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover shared memory 20210726:06:17:30:024292 gpstop:mdw_ipv4:gpadmin-[INFO]:-Restarting System... [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 200 Segment value: 200 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -r max_prepared_transactions 20210726:06:18:02:024565 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-r max_prepared_transactions' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -arf 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -arf 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast' 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Master segment instance directory=/data1/gpdb/master/gpseg-1 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Terminating processes for segment /data1/gpdb/master/gpseg-1 20210726:06:18:09:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Stopping master standby host smdw_ipv4 mode=fast 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown standby process on smdw_ipv4 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Targeting dbid [2, 8, 3, 9, 4, 10, 5, 11, 6, 12, 7, 13] for shutdown 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel primary segment instance shutdown, please wait... 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Commencing parallel mirror segment instance shutdown, please wait... 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-0.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-100.00% of jobs completed 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments stopped successfully = 12 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:- Segments with errors during stop = 0 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:----------------------------------------------------- 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Successfully shutdown 12 of 12 segment instances 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpmmon process 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpmmon process found 20210726:06:18:10:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes 20210726:06:18:11:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts 20210726:06:18:11:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Cleaning up leftover shared memory 20210726:06:18:11:024672 gpstop:mdw_ipv4:gpadmin-[INFO]:-Restarting System... [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s max_prepared_transactions Values on all segments are consistent GUC : max_prepared_transactions Master value: 50 Segment value: 50 [gpadmin@mdw_ipv4 ~]$