Fatal 2: PageAddItem: corrupted page pointers

From: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Fatal 2: PageAddItem: corrupted page pointers
Date: 2002-03-29 00:27:29
Message-ID: 014101c1d6ba$1dab20e0$0564a8c0@toolteam.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

after a power failure we are getting these errors now:

2002-03-29 01:10:01 DEBUG: checkpoint record is at 16/FC033344
2002-03-29 01:10:01 DEBUG: redo record is at 16/FC033344; undo record is at
0/0; shutdown TRUE
2002-03-29 01:10:01 DEBUG: next transaction id: 73731718; next oid: 6745356
2002-03-29 01:10:01 DEBUG: database system was not properly shut down;
automatic recovery in progress
2002-03-29 01:10:01 DEBUG: redo starts at 16/FC033384
2002-03-29 01:10:01 DEBUG: ReadRecord: invalid magic number 0000 in log
file 22, segment 252, offset 1597440
2002-03-29 01:10:01 DEBUG: redo done at 16/FC185054
2002-03-29 01:10:02 FATAL 1: The database system is starting up
2002-03-29 01:10:02 FATAL 1: The database system is starting up
2002-03-29 01:10:04 DEBUG: recycled transaction log file 00000016000000FA
2002-03-29 01:10:04 DEBUG: recycled transaction log file 00000016000000FB
2002-03-29 01:10:04 DEBUG: database system is ready
2002-03-29 01:10:10 FATAL 2: PageAddItem: corrupted page pointers: lower =
8226, upper = 27747, special = 3183
2002-03-29 01:10:10 DEBUG: server process (pid 2742) exited with exit code
2
2002-03-29 01:10:10 DEBUG: terminating any other active server processes

What exactly does PageAddItem talk about here and how do I fix it?

Thanks,

Bjoern

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjoern Metzdorf 2002-03-29 00:48:47 Re: Fatal 2: PageAddItem: corrupted page pointers
Previous Message Rich Shepard 2002-03-28 23:48:09 Re: An Invoicing db design, how would you do it