On 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
