Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A86CB633070 for ; Tue, 17 Feb 2009 16:11:18 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73023-09 for ; Tue, 17 Feb 2009 16:11:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by mail.postgresql.org (Postfix) with ESMTP id BDAA863242F for ; Tue, 17 Feb 2009 16:10:57 -0400 (AST) Received: from webmail.zmi.at (websrv1.zmi.at [212.69.162.199]) by mailsrv1.zmi.at (Postfix) with ESMTP id F2B8B4059; Tue, 17 Feb 2009 21:10:54 +0100 (CET) Received: from phpmailer ([195.202.170.131]) by webmail.zmi.at with HTTP (PHPMailer); Tue, 17 Feb 2009 21:10:55 +0100 Date: Tue, 17 Feb 2009 21:10:55 +0100 To: Achilleas Mantzios , pgsql-admin@postgresql.org From: Michael Monnerie Subject: Re: 8.3.5 broken after power fail Message-ID: X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/125 X-Sequence-Number: 31346 "Michael Monnerie" schrieb: > Now I already have > select * from dbmail_messageblks where messageblk_idnr not in > (3904492,3904495,3904496,3904499,3904500,3904501,3904503); > ERROR: unexpected chunk number 1 (expected 0) for toast value 1460210 = in > pg_toast_1281127 >=20 > Is there a way to find out what "toast value 1460210" stands for? I'd = like > to find the connection between messageblk_idnr and that toast value, as it's > not easy to find that. My problem is that there seems to be a jump in messageblk_idnr, and I = cannot find the relation to the missing toast value. Is there a way to find this? Or, I'd need to use something like COPY .. WHERE .. to exclude the broken toasts and see where it stops next. SELECT only shows the error with the toast value number, I'd like to see what it the last row that is processed then I could find the next and know it's messageblk_idnr. Is that = possible? mfg zmi