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: | Raw Message | Whole Thread | 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? |