From: Tom Lane <tgl@sss.pgh.pa.us>
To: Chadwick Horn <chadhorn@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: postgres server crashes unexpectedly
Date: Mon, 17 Mar 2008 22:32:31 -0400
Message-ID: <7206.1205807551@sss.pgh.pa.us> (raw)
In-Reply-To: <71EB10BF787341C28A47F33667D0D8FC@ToshibaLaptop>
References: <71EB10BF787341C28A47F33667D0D8FC@ToshibaLaptop>
"Chadwick Horn" <chadhorn@gmail.com> writes:
> PANIC: corrupted item pointer: offset = 0, size = 0
> LOG: autovacuum process (PID 3037) was terminated by signal 6
Hmm ... the only instances of that error text are in PageIndexTupleDelete
and PageIndexMultiDelete, so we can fairly safely say that you have a
partially zeroed-out page in some index somewhere. If that's the only
damage then you're in luck: you can recover by reindexing.
What I'd do is turn off autovacuum and instead do a manual VACUUM
VERBOSE to see where it crashes; then you could just reindex the one
problem table instead of the whole database.
You ought to look into why this happened, too. Since you've provided
precisely 0 context about PG version or platform, it's hard to speculate
about that ...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, chadhorn@gmail.com
Subject: Re: postgres server crashes unexpectedly
In-Reply-To: <7206.1205807551@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox