Re: Some one deleted pg_database entry how to fix it? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Some one deleted pg_database entry how to fix it?
Date
Msg-id 251.1079475810@sss.pgh.pa.us
Whole thread Raw
In response to Re: Some one deleted pg_database entry how to fix it?  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
> Without looking at the actual data, it seems like
> PhonyHeapTupleSatisfiesNow() in GetRawDatabaseInfo() might be to blame.

That was my theory too, but having looked at the tuple, it's perfectly
valid.  However, it appears that its xmin is way in the past, which
means that snapshot-aware scans won't see it.  I think what happened is
that the DBA of this database (Dave says it ain't him!) never did any
database-wide vacuums, and thereby allowed the info in pg_database to
get old enough to slide out of the transaction window without being
frozen :-(
        regards, tom lane


pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Topic for a student research project
Next
From: Bruce Momjian
Date:
Subject: Re: calling plpgsql from c