Обсуждение: error

On Tue, Sep 23, 2008 at 2:48 PM, Carol Walter <walterc@indiana.edu> wrote:
> Hi, Folks,
> What would cause this error?
> SQL error:
> ERROR:  could not access status of transaction 10274530
> DETAIL:  Could not open file "pg_clog/0009": No such file or directory.

Often it's a problem caused by a virus checker.

There really is not pg_clog/0009 file.


On Sep 23, 2008, at 4:50 PM, Scott Marlowe wrote:

> On Tue, Sep 23, 2008 at 2:48 PM, Carol Walter <walterc@indiana.edu>
> wrote:
>> Hi, Folks,
>> What would cause this error?
>> SQL error:
>> ERROR:  could not access status of transaction 10274530
>> DETAIL:  Could not open file "pg_clog/0009": No such file or
>> directory.
>
> Often it's a problem caused by a virus checker.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

Carol Walter <walterc@indiana.edu> writes:
> What would cause this error?

> ERROR:  could not access status of transaction 10274530
> DETAIL:  Could not open file "pg_clog/0009": No such file or directory.

We've seen that caused by bugs that made Postgres throw away clog files
too soon; but as far as I know those bugs were all squashed in recent
releases.  What PG version is this?  What files *are* present in
pg_clog, and what are their mod times?  Have you had any system crashes
recently?

            regards, tom lane

I've had no system crashes.  I'm embarrassed to say that I may have
inadvertently caused this problem when I was do "house cleaning" a
couple of weeks ago.

When I upgrade, how to I get my data when pg_dumpall won't run?

Carol

On Sep 23, 2008, at 10:42 PM, Tom Lane wrote:

> Carol Walter <walterc@indiana.edu> writes:
>> What would cause this error?
>
>> ERROR:  could not access status of transaction 10274530
>> DETAIL:  Could not open file "pg_clog/0009": No such file or
>> directory.
>
> We've seen that caused by bugs that made Postgres throw away clog
> files
> too soon; but as far as I know those bugs were all squashed in recent
> releases.  What PG version is this?  What files *are* present in
> pg_clog, and what are their mod times?  Have you had any system
> crashes
> recently?
>
>             regards, tom lane