8.2.3 PANIC with "corrupted item pointer"

From: "Henka" <henka(at)cityweb(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.2.3 PANIC with "corrupted item pointer"
Date: 2007-06-21 10:44:30
Message-ID: 63160.196.23.181.69.1182422670.squirrel@support.metroweb.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I'm using PG 8.2.3:

PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.6

I happened to notice this error in the log when my application was refused
a db connection (quite unexpectedly):

PANIC: corrupted item pointer: offset = 3308, size = 28
LOG: autovacuum process (PID 18165) was terminated by signal 6
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2007-06-21 12:27:13 SAST
LOG: checkpoint record is at D6/F00F418C
LOG: redo record is at D6/F00C24B8; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 0/2090506603; next OID: 101300203
LOG: next MultiXactId: 35676; next MultiXactOffset: 85365
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at D6/F00C24B8
FATAL: the database system is starting up
LOG: record with zero length at D6/F138DDA4
LOG: redo done at D6/F138DD7C
LOG: database system is ready

Just prior to the panic, an INSERT was executed three times and rejected
as expected because of a unique constraint index.

Database size is about 180GB and growing.

Any comments would be appreciated.

Regards
Henry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Naz Gassiep 2007-06-21 11:01:42 Aggregates
Previous Message Albe Laurenz 2007-06-21 10:41:07 Re: Recovery/Restore and Roll Forward Question.