"Henka" <henka@cityweb.co.za> writes:
> Hello all,
>
> I'm using PG 8.2.3:
You should update to 8.2.4, it includes a security fix and several bug fixes.
However afaik none of them look like this.
> PANIC: corrupted item pointer: offset = 3308, size = 28
> LOG: autovacuum process (PID 18165) was terminated by signal 6
Huh, that's pretty strange.
My first thought is bad memory. It's always good to rule that out since it's
quite common and can cause a lot of hair-pulling. If you can schedule some
downtime download memtest86 and run it overnight.
Other than that it might be interesting to know the values of some server
parameters: "fsync" and "full_page_writes". Have you ever had this machine
crash or had a power failure? And what kind of i/o controller is this?
Ideally it would be good to get a dump of this block, it looks like it's
probably a block of an index (unless you have a table with extremely narrow
rows?). But there doesn't seem to be enough information in this error to tell
which block it happened on.
If you manually "vacuum verbose" each table does it cause a crash? If so send
that along and at least we'll know which table or index has the corrupted
data. You probably don't want to do this during peak production time though...
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
