Close open transactions soon to avoid wraparound problems

Поиск
Список
Период
Сортировка
Искать
От
Brian Staszewski
Тема
Close open transactions soon to avoid wraparound problems
Дата
Msg-id
46E58BFD.80300@farheap.com
Список
Дерево обсуждения
Close open transactions soon to avoid wraparound problems Brian Staszewski <brian.staszewski@farheap.com>
Re: Close open transactions soon to avoid wraparound problems Tom Lane <tgl@sss.pgh.pa.us>
Re: Close open transactions soon to avoid wraparound problems Brian Staszewski <brian.staszewski@farheap.com>
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
В списке pgsql-admin по дате отправления
От: Tom Lane
Дата:
От: Alvaro Herrera
Дата:
Сообщение: Re: reindexdb hangs
FAQ