收集统计信息报错 5001，message="syntax error, unexpected SNAPSHOT" 的原因和解决方法

observer.log:[2025-03-14 11:10:03.373760] WDIAG [SQL] stmt_query (ob_sql.cpp:227) [92531][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=43][errcode=-5001] fail to handle text query(stmt=SELECT /*+ NO_REWRITE USE_PLAN_CACHE(NONE) DBMS_STATS FULL(order_main) OPT_PARAM('ROWSETS_MAX_ROWS', 8) USE_PX, PARALLEL(128)*/  COUNT(1),  MAX(`id`),  MIN(`id`),  COUNT(`id`),  APPROX_COUNT_DISTINCT(`id`),  AVG(SYS_OP_OPNSIZE(`id`)),  APPROX_COUNT_DISTINCT_SYNOPSIS(`id`),  1 FROM `retail_fas`.`order_main` PARTITION (`p0`) SAMPLE (50.000000) as of snapshot 1741921803371932001  , ret=-5001)
observer.log:[2025-03-14 11:10:03.373791] WDIAG [SERVER] do_query (ob_inner_sql_connection.cpp:784) [92531][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=24][errcode=-5001] executor execute failed(ret=-5001)
observer.log:[2025-03-14 11:10:03.373818] WDIAG [SERVER] query (ob_inner_sql_connection.cpp:943) [92531][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=61][errcode=-5001] execute failed(ret=-5001, tenant_id=1002, executor={ObIExecutor:, sql:"SELECT /*+ NO_REWRITE USE_PLAN_CACHE(NONE) DBMS_STATS FULL(order_main) OPT_PARAM('ROWSETS_MAX_ROWS', 8) USE_PX, PARALLEL(128)*/  COUNT(1),  MAX(`id`),  MIN(`id`),  COUNT(`id`),  APPROX_COUNT_DISTINCT(`id`),  AVG(SYS_OP_OPNSIZE(`id`)),  APPROX_COUNT_DISTINCT_SYNOPSIS(`id`),  1 FROM `retail_fas`.`order_main` PARTITION (`p0`) SAMPLE (50.000000) as of snapshot 1741921803371932001  "}, retry_cnt=0, local_sys_schema_version=1740366885882512, local_tenant_schema_version=1741916496788000)
observer.log:[2025-03-14 11:10:03.373849] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:1045) [92531][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=69][errcode=-5001] [RETRY] check if need retry(v={force_local_retry:true, stmt_retry_times:0, local_retry_times:0, err_:-5001, err_:"OB_ERR_PARSE_SQL", retry_type:0, client_ret:-5001}, need_retry=false) 

call DBMS_STATS.GATHER_TABLE_STATS('xxxx','order_main',granularity=>'GLOBAL',degree=>64);