PANIC during VACUUM

From: German Becker <german(dot)becker(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: PANIC during VACUUM
Date: 2013-04-29 19:58:56
Message-ID: CALyjCLs0iswbroQtucQWeL+CcGGac0t8iq1yx1Sa8Xti=O3yeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am testing version 9.1.9 before putting it in production. One of my tests
involved deleting a the contents of a big table ( ~ 13 GB size) and then
VACUUMing it. During VACUUM PANICS. Here is the message:

PANIC: corrupted item pointer: offset = 8128, size = 80

I found the error a couple of times, allways during VACUUM after deleting
the context of the same big table (after re-polpulating it of course).

The error message is always *exactly* the same i.e. the same offset and
size.

When this happens the backend gets restarted and if I issue the same VACUUM
command, I get the same error.

I also tried triggering the backup server (hot-standby with streaming
replication, and trying the VACUUM there (to see if it may be a hardware
problem in the primary) and got the same issue.

What might be causing this? Should I reported as a bug? Thanks!

--
Germán

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Isabella Ghiurea 2013-04-29 20:12:32 Re: Postgresql Courses
Previous Message David F. Skoll 2013-04-27 20:51:17 Re: archive falling behind