From: Michael Monnerie <michael.monnerie@is.it-management.at>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: 8.3.5 broken after power fail
Date: Tue, 17 Feb 2009 21:10:55 +0100
Message-ID: <de3f3b06f55e4f88b0ced132435bcd96@webmail.zmi.at> (raw)
In-Reply-To: <bb6b51d03ec44eb00c06921b104b8059@webmail.zmi.at>
"Michael Monnerie" <michael.monnerie@is.it-management.at> 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
>
> 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
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: michael.monnerie@is.it-management.at, achill@matrix.gatewaynet.com
Subject: Re: 8.3.5 broken after power fail
In-Reply-To: <de3f3b06f55e4f88b0ced132435bcd96@webmail.zmi.at>
* 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