pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brian Staszewski <brian.staszewski@farheap.com>
To: pgsql-admin@postgresql.org
Subject: Close open transactions soon to avoid wraparound problems
Date: Mon, 10 Sep 2007 11:25:01 -0700
Message-ID: <46E58BFD.80300@farheap.com> (raw)

Vacuumdb is giving me these messages:

Vacuuming public.files...
WARNING:  oldest xmin is far in the past
HINT:  Close open transactions soon to avoid wraparound problems.
WARNING:  oldest xmin is far in the past
HINT:  Close open transactions soon to avoid wraparound problems.
VACUUM

Two questions:
1. Is there a way for me to see what application/host/user has open 
transactions that need to be closed?
2. If #1 is not possible then what can I do about this?

Searching the web via normal methods only turns up indexed source code 
files for vacuum.

What's been done so far:
-Cluster-wide vacuum (these are done nightly, I ran one again just for gp)
-Ran the following query looking for old/suspicious 
connections/transactions, didn't find anything useful:

select procpid, datname, client_addr, usename, current_query, 
query_start from pg_stat_activity order by query_start asc;

Thanks in advance,
Brian

Attachments:

brian.staszewski.vcf (text/x-vcard, 249B) download begin:vcard fn:Brian Staszewski n:Staszewski;Brian org:Farheap Solutions, Inc.;Information Technologies email;internet:brian.staszewski@farheap.com title:Systems Administrator tel;work:(949) 417-1500 x948278 x-mozilla-html:TRUE version:2.1 end:vcard

view thread (3+ messages)  latest in thread

Message-ID: <46E58BFD.80300@farheap.com>
Permalink:  ../46E58BFD.80300@farheap.com/
Also on:    postgresql.org/message-id/46E58BFD.80300@farheap.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: brian.staszewski@farheap.com
  Subject: Re: Close open transactions soon to avoid wraparound problems
  In-Reply-To: <46E58BFD.80300@farheap.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox