Re: 8.3.5 broken after power fail

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Michael Monnerie" <michael.monnerie@xxxxxxxxxxxxxxxxxxx> 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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux