From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com> |
Cc: | "PostgreSQL General (list)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: weird pg_statistic problem |
Date: | 2011-11-11 21:05:04 |
Message-ID: | 11214.1321045504@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Levan | 2011-11-11 22:27:49 | dblink build problem…must be a lesson here... |
Previous Message | David Kerr | 2011-11-11 17:35:02 | Re: : postgres: archiver process failed on 0000000100000F72000000F0 |