"Invalid input for statement_mem, must be less than max_statement_mem" When upgrading.

Products

• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite

Issue/Introduction

When upgrading to a version of Greenplum v6.24.0 or above, the upgrade fails with the below error message.

"Invalid input for statement_mem, must be less than max_statement_mem (###### kB)"

This is because in GP version 6.24.0, the below error reporting was introduced:

15087 : Includes an error message when setting statement_mem to a value greater than max_statement_mem.

Environment

Product Version: 6.24

Resolution

This error is due to the fact that statement_mem is listed before max_statement_mem in the postgresql.conf file. When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. Switching the order these values are set will resolve this error. 

The default value for max_statement_mem is 2000MB. When setting statement_mem to a value lower than 2000MB, it will not surpass the default max_statement_mem value and will not result in this error.