Pivotal Knowledge Base

Follow

Queries running on Pivotal Greenplum versions below 4.3.4.0 fail with "insufficient memory reserved for statement"

Environment

Product Version
Pivotal Greenplum (GPDB) Below 4.3.4.0
OS Any

Symptom

In recent versions of Pivotal Greenplum (lower than 4.3.4.0) many queries that used to be running successfully previously are now failing and require more memory to run successfully.

Specifically, these queries are failing with the error:

"insufficient memory reserved for statement"

Cause

There were two bugs identified in the earlier 4.3 GPDB releases.

  1. There was a rounding error when allocating memory to child groups of a plan when using the eager_free memory policy. This has been fixed in 4.3.4.0.
  2. We would fail to account for some of the memory that has already been allocated in a plan, resulting in over-allocating memory when using eager_free. This has been fixed in 4.3.4.0.

In this case of shortcomings with memory, accounting has been addressed and the full cost for the query is now being enforced.

Resolution

Upgrade to a recent software release (higher than 4.3.4.0).

Internal Comments 

See MPP-23130 and MPP-23155

Comments

Powered by Zendesk