Thread: Erro in vaccum
My vacuum was follow error below:
WARNING: oldest xmin is far in the past
HINT: Close open transactions soon to avoid wraparound problems.
No have transactions in locked ,
what's could be happen?
Paulo Moraes
Paulo Moraes
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes
On Mon, Dec 22, 2008 at 10:22 AM, paulo matadr <saddoness@yahoo.com.br> wrote: > > My vacuum was follow error below: > WARNING: oldest xmin is far in the past > HINT: Close open transactions soon to avoid wraparound problems. > No have transactions in locked , Transactions don't have to hold locks to cause problems. Generally speaking you've got an old transaction being held open. what does: select min(xact_start) from pg_stat_activity; say?