| From: | Žiga Kranjec <ziga(at)ljudmila(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Mysterious server crashes |
| Date: | 2011-07-15 21:37:54 |
| Message-ID: | 4E20B332.5070107@ljudmila.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello!
Recently we have upgraded our debian system (sid),
which has since started crashing mysteriously.
We are still looking into that. It runs on 3ware RAID.
Postgres package is 8.4.8-2.
The database came back up apparently ok, except
for indexes. Running reindex produces this error on
one of the tables:
ERROR: unexpected chunk number 1 (expected 0) for toast value 17539760
in pg_toast_16992
Same with select.
I tried running reindex on toast table didn't help. Running:
select * from pg_toast.pg_toast_16992 where chunk_id = 17539760;
crashed postgres backend (and apparently the whole server).
Is there anything we can/should do to fix the problem, besides
restoring the whole database from backup?
Thanks!
Ziga
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-07-15 21:46:49 | Re: libpq SSL with non-blocking sockets |
| Previous Message | Bruce Momjian | 2011-07-15 21:37:51 | Re: Is there a committer in the house? |