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
