"Chadwick Horn" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
