Analyzedb 'ERROR: insufficient memory reserved for statement (execHHashagg.c:768)

Products

• VMware Tanzu Greenplum

Issue/Introduction

In 5.26 when using the -s tag for analyzedb you may get an out of memory error. That looks like:

Traceback (most recent call last): File "/usr/local/greenplum-db/bin/analyzedb",
line 291, in execute heap_partitions = get_heap_tables_set(self.conn,input_tables_set) # 
set((schema1,table1), ...]) File "/usr/local/greenplum-db/bin/analyzedb",
line 888, in get_heap_tables_set qresult = run_sql(conn,GET_REQUESTED_NON_AO_TABLES_SQL % oid_str) 
File "/usr/local/greenplum-db/bin/analyzedb", 
line 840, in run_sql raise ExceptionNoStackTraceNeeded("%s" %db_err.__str__()) # .split('\n')[0]) 
ExceptionNoStackTraceNeeded: error 
'ERROR: insufficient memory reserved for statement (execHHashagg.c:768)

Environment

Product Version: 5.26

Resolution

There are 2 resolutions: 1 raise the statement_mem parameter 2 upgrade to 5.27.0