Re: BUG #6291: Xid epoch is not updated properly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Farina" <daniel(at)heroku(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6291: Xid epoch is not updated properly
Date: 2011-11-13 23:27:11
Message-ID: 28793.1321226831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Daniel Farina" <daniel(at)heroku(dot)com> writes:
> We have on hand a database that makes heavy use of the txid_snapshot family
> of functions, and recently it just passed its 4^32 transaction mark.
> Unfortunately, upon wraparound the xid epoch appears to not have been
> incremented, remaining at 0.

I failed to reproduce this here, and a look at the code responsible for
xid epoch maintenance reveals no obvious way that it could have been
bypassed. So there's some fairly critical piece of context that you're
not telling us ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2011-11-14 02:35:58 Re: BUG #4335: Error w/ PostgreSQL & EnterpriseDB Stack Builder
Previous Message Daniel Farina 2011-11-13 22:15:42 BUG #6291: Xid epoch is not updated properly