"ERROR","42704","unrecognized configuration parameter ""optimizer_analyze_enable_merge_of_leaf_stats"
Article ID: 296464
Updated On:
Products
VMware Tanzu Greenplum
Issue/Introduction
The command analyzedb reports the following error:
2021-04-18 17:33:08.815506 CEST,"gpadmin","mydb",p10453,th-987265152,"[local]",,2021-04-18 17:33:08 CEST,0,con135377,cmd1,seg-1,,dx710067,,sx1,"ERROR","42704","unrecognized configuration parameter ""optimizer_analyze_enable_merge_of_leaf_stats""",,,,,,"set optimizer_analyze_enable_merge_of_leaf_stats=off; analyze public.mytable_1_prt_20210413",0,,"guc.c",5325,
Environment
Product Version: 5.21
Resolution
The customer temporarily downgraded from 5.28.6 to a version prior to 5.23.0.
The optimizer_analyze_enable_merge_of_leaf_stats GUC was introduced in 5.23.0. The GUC is set in the analyzedb script. When running analyzedb from Greenplum version 5.23.0 or later, the GUC is set and is not recognized when running a version prior to 5.23.0.
Ensure the correct version of analyzedb is used, source the environment that matches the running server, and then run the command:
The optimizer_analyze_enable_merge_of_leaf_stats GUC was introduced in 5.23.0. The GUC is set in the analyzedb script. When running analyzedb from Greenplum version 5.23.0 or later, the GUC is set and is not recognized when running a version prior to 5.23.0.
Ensure the correct version of analyzedb is used, source the environment that matches the running server, and then run the command:
# source /usr/local/greenplum-db-5.21.3/greenplum_path.sh # analyzedb
Feedback
Yes
No
Powered by
