Enrico Sirola <enrico.sirola@xxxxxxxxx> writes: > this morning I experienced a weird problem with our pgsql database (9.0.3): > while performing a simple query, I receive the following error: > Nov 11 10:24:09 <host> postgres[23395]: [7-1] ERROR: missing chunk number 0 for toast value 550556127 in pg_toast_2619 Was this a transient error, or repeatable? If it was transient, it's probably a recently-fixed issue: http://archives.postgresql.org/pgsql-hackers/2011-10/msg01366.php http://archives.postgresql.org/pgsql-committers/2011-11/msg00014.php > ERROR: duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" > DETAIL: Key (starelid, staattnum, stainherit)=(531526103, 7, f) already exists. This seems unrelated. Can you repeat this one? If so, try REINDEX'ing that index and see if the problem goes away. It'd be worth your while to update to 9.0.5 --- we fixed a fair number of potential data-corruption issues since January. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
