gp_array_agg Serialization/Deserialization Failure Due to Incorrect proisstrict Configuration

Products

• VMware Tanzu Data

Issue/Introduction

In Greenplum Database version 6.33.2 queries utilitzing the parallel aggregate module gp_array_agg encountered execution errors:

"[XX000] ERROR: invalid memory alloc request size 1073741824 (context 'accumArrayResult') (mcxt.c:1428) (mcxt.c:636)"
"Logging memory usage for memory context error" 

Resolution

There is a catalog fix available for a workaround, please contact support to help with this change in the catalog.

The issue will be fixed in GPDB version 6.33.5.