Re: strange behavior (corruption?) of large production database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: strange behavior (corruption?) of large production database
Date: 2005-12-03 00:11:28
Message-ID: 9955.1133568688@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joe Conway <mail(at)joeconway(dot)com> writes:
> So they agree in template1 and cyspec databases.

OK, in that case I'd wonder about whether you've suffered XID wraparound
in pg_database and/or pg_shadow. The typical symptom of this is that
entries are valid from the system's point of view but not visible to
queries, and that seems to be what you have. If so, a restart will NOT
fix it. You could try a VACUUM FREEZE on pg_database though. Before
doing that, I'd suggest looking at the rows' xmin values (use
pg_filedump or grovel through the bits by hand) to confirm the
wraparound theory.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2005-12-03 00:17:23 Re: strange behavior (corruption?) of large production
Previous Message Joe Conway 2005-12-03 00:06:33 Re: strange behavior (corruption?) of large production