search

vmware-archive / sre-test

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

log_min_error_statement parameter issue #215

Closed bala-cg closed 2 years ago

bala-cg commented 3 years ago

Page No : 1364

Issue: log_min_error_statement change don't work on reload. 1) changed log_min_error_statement to panic using gpconfig. 2) reload (gpstop -u) done 3) gpconfig -s show the change is effective. 4) errors still log to the pglogs.

Testing:

[gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ gpconfig -c log_min_error_statement -v panic 20210725:14:24:05:005728 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c log_min_error_statement -v panic' [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ gpstop -u 20210725:14:24:12:005807 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210725:14:24:12:005807 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210725:14:24:12:005807 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210725:14:24:12:005807 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210725:14:24:12:005807 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210725:14:24:12:005807 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ gpconfig -s log_min_error_statement Values on all segments are consistent GUC : log_min_error_statement Master value: panic Segment value: panic [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# gpadmin=# select 1/0; ERROR: division by zero gpadmin=# \q [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ grep division gpdb-2021-07-25_140334.csv 2021-07-25 14:23:21.962921 GMT,"gpadmin","gpadmin",p5644,th1728829568,"[local]",,2021-07-25 14:23:02 GMT,0,con53,cmd5,seg-1,,,,sx1,"ERROR","22012","division by zero",,,,,,"select 1/0;",0,,"int.c",719, 2021-07-25 14:24:21.533635 GMT,"gpadmin","gpadmin",p5853,th1728829568,"[local]",,2021-07-25 14:24:19 GMT,0,con61,cmd1,seg-1,,,,sx1,"ERROR","22012","division by zero",,,,,,"select 1/0;",0,,"int.c",719, [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# gpadmin=# gpadmin=# select 1/0; ERROR: division by zero gpadmin=# \q [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ grep division gpdb-2021-07-25_140334.csv 2021-07-25 14:23:21.962921 GMT,"gpadmin","gpadmin",p5644,th1728829568,"[local]",,2021-07-25 14:23:02 GMT,0,con53,cmd5,seg-1,,,,sx1,"ERROR","22012","division by zero",,,,,,"select 1/0;",0,,"int.c",719, 2021-07-25 14:24:21.533635 GMT,"gpadmin","gpadmin",p5853,th1728829568,"[local]",,2021-07-25 14:24:19 GMT,0,con61,cmd1,seg-1,,,,sx1,"ERROR","22012","division by zero",,,,,,"select 1/0;",0,,"int.c",719, 2021-07-25 14:25:08.314935 GMT,"gpadmin","gpadmin",p5921,th1728829568,"[local]",,2021-07-25 14:25:05 GMT,0,con62,cmd1,seg-1,,,,sx1,"ERROR","22012","division by zero",,,,,,"select 1/0;",0,,"int.c",719, [gpadmin@mdw_ipv4 pg_log]$

[gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ gpconfig -s log_min_error_statement Values on all segments are consistent GUC : log_min_error_statement Master value: panic Segment value: panic [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$

fifthposition commented 3 years ago

@bala-cg Is this a product issue / bug?

bala-cg commented 3 years ago

@fifthposition, yes this is bug updated the label.