Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7T0mRC78597 for ; Mon, 28 Aug 2000 20:48:27 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id UAA19692; Mon, 28 Aug 2000 20:48:18 -0400 (EDT) To: Palle Girgensohn cc: pgsql-sql@postgresql.org Subject: Re: pg_attribute_relid_attnam_index problem after log disk filled up In-reply-to: <39AA8BC3.3047D8CF@partitur.se> References: <39AA8BC3.3047D8CF@partitur.se> Comments: In-reply-to Palle Girgensohn message dated "Mon, 28 Aug 2000 17:56:51 +0200" Date: Mon, 28 Aug 2000 20:48:18 -0400 Message-ID: <19689.967510098@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/313 Palle Girgensohn 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