> >>> Alvaro Herrera <alvherre@alvh.no-ip.org> 08/10/05 9:03 AM >>>
> On Mon, Aug 01, 2005 at 06:02:30AM +0100, Aaron Harsh wrote:
> > pg_dump: ERROR: unexpected chunk number 0 (expected 1) for toast value
> > ...
> Looks very much like the table was corrupted. Maybe you should try to
> test your RAM and disks. Not sure how to do that on x86-64 though,
> unless the test utility at www.memtest86.com has been ported to it.
The server is running off of ECC RAM on a RAID-10 set, so a one-off disk/RA=
M failure seems unlikely. The server had been running beautifully for 6 mo=
nths prior to this error, and hasn't been evidencing the problem since, so =
it seems unlikely that this is due to a bad DIMM or RAID controller.
The timing might be a coincidence, but this error happened within a day of =
our OID counter wrapping around back to 0. (Although Tom Lane mentioned in=
pgsql-general that he was inclined to consider the timing a coincidence).
--=20
Aaron Harsh
ajh@rentrak.com
503-284-7581 x347
