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@turtle-entertainment.de>
To: <pgsql-general@postgresql.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
>
>