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 17:08:15 +0100
Message-ID: <bb6b51d03ec44eb00c06921b104b8059@webmail.zmi.at> (raw)
In-Reply-To: <c9c73fb22b048fc7012bc916beec27df@webmail.zmi.at>
"Michael Monnerie" <michael.monnerie@is.it-management.at> schrieb:
> select * from dbmail_messageblks where messageblk_idnr not in (3904492);
>
> That helps. Slowly I may be able to find all broken entries. Is there a
more
> automated way?
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.
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: <bb6b51d03ec44eb00c06921b104b8059@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