Pivotal Knowledge Base

Follow

Database Creation Error: "Out of Shared-Memory for Persistent Databases"

Environment

 Product  Version
 Pivotal Greenplum  4.3.x
 OS  All Supported OS

Symptom

When you attempt to create more than 256 databases, it is not possible to create all of them, and the following error is thrown:

PANIC:  Out of shared-memory for persistent databaseS (cdbpersistentdatabase.c:528)
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
connection to server was lost

Cause

The three parameters below limit the persistent entries for the number of directories:

  • gp_max_databases - Max # of databases : Default 16, Max value is 256
  • gp_max_filespaces - Max # of file spaces : Default 8, Max value is 256
  • gp_max_tablespaces - Max # of table spaces : Default 16, Max value is 2048

The maximum number of database directories is calculated by gp_max_databases * gp_max_tablespaces. The default is 16 * 64, or 256.

Resolution

Increasing the values of gp_max_database / gp_max_filespace / gp_max_tablespace to 64 on your $MASTER_DATA_DIRECTORY/postgresql.conf file would help you add more databases to your cluster.

Comments

Powered by Zendesk