[postgres-xl-general] [External] oldest xmin is far in the past

McClendon, Craig craig.mcclendon at accenture.com
Thu Jan 11 06:46:25 PST 2018


My bulk experience is from other RDBMS flavors, not Postgres.
So beyond googling and trying all suggestions you come up with, which I'm guessing you have..

My thoughts would be to try to find:
- connections you can identify as from your developers/testers/admins, etc. Kill them if possible
- Any developers/admins running tests in debug mode, perhaps stepping though code that could have a transaction open
- Or a query tool (or any connection) that has AUTO COMMIT turned off that is just sitting idle

Other thoughts would be to examine the size and count of the transaction logs. Possibly make sure there is enough disk space to hold them.
Is there any replication or HA or log forwarding going on? i.e. the transactions can't be freed because something is still waiting to consume them?

-----Original Message-----
From: postgres-xl-general [mailto:postgres-xl-general-bounces at lists.postgres-xl.org] On Behalf Of Christophe Pettus
Sent: Wednesday, January 10, 2018 11:43 PM
To: postgres-xl-general at lists.postgres-xl.org
Subject: [External] [postgres-xl-general] oldest xmin is far in the past

We're getting this warning out of the Postgres-XL cluster, on all data notes:

WARNING,01000,"oldest xmin is far in the past",,"Close open transactions soon to avoid wraparound problems.",,,,,,,""

Connected to the coordinator, no prepared transactions are open, and a VACUUM does not seem to cure it.  The tables in the primary database are not "old" in terms of XID age, so I'm not quite sure what the source of this is.  Thoughts?

--
-- Christophe Pettus
   xof at thebuild.com

_______________________________________________
postgres-xl-general mailing list
postgres-xl-general at lists.postgres-xl.org
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.postgres-2Dxl.org_listinfo.cgi_postgres-2Dxl-2Dgeneral-2Dpostgres-2Dxl.org&d=DwICAg&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8IrwNKOtkVU&r=VnYhy7Qh2TPWQTwfje6NAvmntWXxxwhN_1pvCFqkOwE&m=GqzOdSdsLK8eqkkc326y0iSjzuXRxcWrk7_M5D08_fY&s=5IiHIjQdZVJ5Zz8ZVpkxzuKHfPxy3lWdnMG9CDVT_qk&e=

________________________________

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com



More information about the postgres-xl-general mailing list