pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Palle Girgensohn <girgen@partitur.se>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_attribute_relid_attnam_index problem after log disk filled up
Date: Mon, 28 Aug 2000 20:48:18 -0400
Message-ID: <19689.967510098@sss.pgh.pa.us> (raw)
In-Reply-To: <39AA8BC3.3047D8CF@partitur.se>
References: <39AA8BC3.3047D8CF@partitur.se>

Palle Girgensohn <girgen@partitur.se> writes:
> What's this? What to do? Shall I bother?

> pp=> vacuum;
> NOTICE:  Index pg_attribute_relid_attnam_index: NUMBER OF
> INDEX' TUPLES (3094) IS NOT THE SAME AS HEAP' (3093)

Under 6.5, if vacuum doesn't get rid of the message then I think the
only way to do so is to dump and reload the database.  (I'd strongly
recommend updating to 7.0.2 while you do that.)

The message in itself is not catastrophic, but it does raise the
question of what other damage there might be.  Updating would be
a good idea anyway, considering all the bugs that got fixed between
6.5 and 7.0.

> The problem started when the log partition (where
> postmaster logging output is written) was full, and some
> backends crashed.

Did they actually crash, or just hang up waiting for space to become
available for the log file?  That really shouldn't have been much of
a problem, AFAICS.

			regards, tom lane



view thread (3+ messages)  latest in thread

Message-ID: <19689.967510098@sss.pgh.pa.us>
Permalink:  ../19689.967510098@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/19689.967510098@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, girgen@partitur.se
  Subject: Re: pg_attribute_relid_attnam_index problem after log disk filled up
  In-Reply-To: <19689.967510098@sss.pgh.pa.us>
  References: <39AA8BC3.3047D8CF@partitur.se> <19689.967510098@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox