Database is not accepting commands to avoid wraparound data loss in database XXX

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

GPDB stops accepting connections and the following error is displayed when a connection is attempted:

Database is not accepting commands to avoid wraparound data loss in database "XXXX"

Environment

Greenplum

Cause

This error means that the database age has gotten too close (over the xid_stop_limit) to the wraparound limit. As a result, all connections to this or any other database in the cluster are refused to protect it from a potential xid wraparound scenario. This article explains in detail why and when can error message is encountered.

Resolution

In order to regain access to the database and run VACUUM FREEZE, the xid_stop_limit will have to be momentarily lowered. This process is described in the section "Recovering from a Transaction ID Limit Error" on the following page from our official documentation.

To find the tables or databases that need to be vacuumed, refer to this following article.