Re: missing chunk number 0 for toast value ...

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

 



MIlos Prudek <prudek@xxxxxx> writes:
> select * from info;
> ERROR:  missing chunk number 0 for toast value 190937

I was going to suggest the REINDEX, but no luck :-(

> What should I do to salvage the table?

Find the row containing the busted toast reference, and delete that row
(or just UPDATE it with some new value for the toasted column).  You can
home in on it with the usual sorts of search methods --- look in the PG
list archives for previous discussions of locating corrupted rows.

			regards, tom lane


[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