Fatal 2: PageAddItem: corrupted page pointers - Mailing list pgsql-general

From Bjoern Metzdorf
Subject Fatal 2: PageAddItem: corrupted page pointers
Date
Msg-id 014101c1d6ba$1dab20e0$0564a8c0@toolteam.net
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: An Invoicing db design, how would you do it
Next
From: "Bjoern Metzdorf"
Date:
Subject: Re: Fatal 2: PageAddItem: corrupted page pointers