oldest xmin is far in the past

Products

• VMware Tanzu Greenplum

Issue/Introduction

The following warning is received when performing VACUUM on a table:

WARNING: oldest xmin is far in the past (segxxx <ip>:<port> pid=<>)
HINT: Close open transaction soon to avoid wraparound problems.

Environment

Product Version: 6.22

Resolution

Resolution

Check for any queries that have been running for a very long time:

SELECT * FROM pg_stat_activity ORDER BY state_change;

There may be a query that has been running for many days.
If possible cancel the longest running query and retry the VACUUM.