| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
| Cc: | pg(at)fastcrypt(dot)com, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Some one deleted pg_database entry how to fix it? |
| Date: | 2004-03-16 22:23:30 |
| Message-ID: | 251.1079475810@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gavin Sherry <swm(at)linuxworld(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-03-17 01:05:39 | Re: calling plpgsql from c |
| Previous Message | Gavin Sherry | 2004-03-16 22:22:21 | Re: Topic for a student research project |