On Mon, Jun 14, 2010 at 11:28 AM, Shinji Nakajima <sina...@jops.co.jp> wrote: > PostgreSQL version: 8.3.8 > Description: missing chunk number 0 for toast value XXXXX in > pg_toast_XXXXX > > I delete a record, and the system restores, but prime cause is unknown. > Will this be a bug of the databases?
Probably. Or possibly bad hardware. Assuming you didn't manually go in and delete that record from the toast table, which would be a strange thing to do. The problem is it could have happened a long time ago and you just discovered it now. Have you had any other significant events on this machine? Any system crashes or power failures? Any drive crashes or signs of bad memory? In the postgres logs are there any instances of unusual error messages or warnings? -- greg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
