Mysterious server crashes

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

Responses

Browse pgsql-hackers by date

  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?