vmware-archive / sre-test

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

read only parameters are allowed to set using --skipvalidation #195

Closed bala-cg closed 2 years ago

bala-cg commented 3 years ago

Page No 1330

Issue: gp_command_count read only parameters are allowed to set using --skipvalidation

Page No : 1353

Issue: gp_server_version read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No : 1354

Issue: gp_server_version_num read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No : 1354

Issue: gp_session_id read only parameters are allowed to set using --skipvalidation, after restart DB just hangs, until we revert this parameter change.

Page No : 1358

Issue: integer_datetimes read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No : 1359

Issue: lc_collate read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No : 1360

Issue: lc_ctype read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No: 1368

Issue: max_function_args read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No: 1369

Issue: max_identifier_length read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No : 1369

Issue: max_index_keys read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Page No : 1387

Issue: server_encoding, server_version, server_version_num these read only parameters are allowed to set using --skipvalidation, after restart DB does not start, until we revert this parameter change.

Note Almost all read only parameters can be set using --skipvalidation, though this seems expected behavior it may corrupt the GP DB and not restart and lead to an outage.

It's better if this can be restricted to edit, even with skipvalidation.