Issue: gp_dbid (read only) parameter, while setting at session level gives a misleading error message.
gpadmin=#
gpadmin=# show gp_dbid;
gp_dbid
1
(1 row)
gpadmin=# set gp_dbid = 2;
ERROR: parameter "gp_dbid" cannot be changed without restarting the server
gpadmin=# \q
[gpadmin@mdw_ipv4 pg_log]$
[gpadmin@mdw_ipv4 pg_log]$ gpconfig -c gp_dbid -v 2
20210718:18:48:53:021107 gpconfig:mdw_ipv4:gpadmin-[CRITICAL]:-not a modifiable GUC: 'gp_dbid'
not a modifiable GUC: 'gp_dbid'
[gpadmin@mdw_ipv4 pg_log]$
Meaningful Error message would be "parameter "parameter_name" cannot be changed".
gpadmin=# show gp_command_count;
gp_command_count
2
(1 row)
gpadmin=# set gp_command_count =4;
ERROR: parameter "gp_command_count" cannot be changed
gpadmin=#
Page No: 1332
Issue: gp_dbid (read only) parameter, while setting at session level gives a misleading error message.
gpadmin=# gpadmin=# show gp_dbid; gp_dbid
1 (1 row)
gpadmin=# set gp_dbid = 2; ERROR: parameter "gp_dbid" cannot be changed without restarting the server gpadmin=# \q [gpadmin@mdw_ipv4 pg_log]$ [gpadmin@mdw_ipv4 pg_log]$ gpconfig -c gp_dbid -v 2 20210718:18:48:53:021107 gpconfig:mdw_ipv4:gpadmin-[CRITICAL]:-not a modifiable GUC: 'gp_dbid' not a modifiable GUC: 'gp_dbid' [gpadmin@mdw_ipv4 pg_log]$
gpadmin=# show gp_command_count; gp_command_count
2 (1 row)
gpadmin=# set gp_command_count =4; ERROR: parameter "gp_command_count" cannot be changed gpadmin=#