Re: weird pg_statistic problem

Hello Tom,

Il giorno 11/nov/2011, alle ore 22.05, Tom Lane ha scritto:

> Enrico Sirola <enrico(dot)sirola(at)gmail(dot)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

apparently, it's transient

>> 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.

while examinigs the db state, I found many other inconsistencies here and there (e.g. tables with multiple records with the same PK), at the end I restored a backup.
I'll be installing today 9.0.5 and let you know if it happens again. Thanks a lot for your help,
Enrico

P.S.
by the way, I have a streaming replica server that has been corrupted as well.