Re: Fatal 2: PageAddItem: corrupted page pointers

Hi,

I started up with debug_print_query and located the corresponding table.
Dropping and creating the table solved the problem.

Greetings,
Bjoern

----- Original Message -----
From: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, March 29, 2002 1:27 AM
Subject: [GENERAL] Fatal 2: PageAddItem: corrupted page pointers

> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>