Re: getting status transaction error - Mailing list pgsql-general

From Merlin Moncure
Subject Re: getting status transaction error
Date
Msg-id b42b73150702061134s9df2a7fj589226b0f675cba0@mail.gmail.com
Whole thread Raw
In response to getting status transaction error  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: [HACKERS] getting status transaction error  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: getting status transaction error  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On 2/6/07, Merlin Moncure <mmoncure@gmail.com> wrote:
> around 6:30 this morning, I started getting the following messages in my log:
>
> Feb  6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR:  could not access
> status of transaction 544441911
> Feb  6 06:34:35 mojo postgres[1128]: [2-1] :: ERROR:  could not access
> status of transaction 544441911
> [...]
>
> repeated roughly once a minute.  I've never seen this before. this is
> on postgres 8.1.1 running on fedora core 4 smp.  I don't have any
> contextual information yet but I'm getting ready to turn statement
> logging on.
>
> Anybody know what this is?
[x-posting to -hackers]

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

repeated ad-naseum

merlin

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: getting status transaction error
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: [HACKERS] getting status transaction error