Connections on the coordinator are consuming a large amount of memory

Products

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

Issue/Introduction

Long running connections can consume a large amount of memory on the coordinator in Greenplum 7.5.0 and 7.5.1.

Each of the below examples are for connections that will run a very large number of queries in the database:

• gprestore of metadata can run a very large number of DDL queries to create the relations in the DB and set the permissions.
• Greenplum Command Center(GPCC) will have a connection to the database and continually run many queries.
• Greenplum Streaming Server(GPSS) jobs can run a large number of queries within one connection to the database

Environment

Greenplum Database(GPDB) v 7.5.0

Greenplum Database(GPDB) v 7.5.1

 

Cause

Code changes to 7.5.0 and 7.5.1 introduced a memory leak in the connection process on the coordinator.

Resolution

Fix

Code fix has been released in 7.5.1