Enrico Sirola <enrico.sir...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
