Re: getting status transaction error

On 2/6/07, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> > actually, here is some more relevant bits from the log.
> > Feb 6 06:31:33 mojo postgres[1088]: [1-1] :: LOG: autovacuum:
> > processing database "template0"
> > Feb 6 06:31:33 mojo postgres[1088]: [2-1] :: ERROR: could not access
> > status of transaction 544441911
> > Feb 6 06:31:33 mojo postgres[1088]: [2-2] :: DETAIL: could not open
> > file "pg_clog/0207": No such file or directory
>
> I guess the problem here is that autovacuum believes that template0
> needs a database-wide vacuum due to Xid wraparound getting closer. And
> that database seems to have Xid 544441911 somewhere, the clog bit for
> which was in the 0207 file which was deleted some time ago.

Latest checkpoint's NextXID: 2162841139
2^31: 2147483648

is this related?
merlin