vacuumdb: PANIC: corrupted item pointer

From: Alain Peyrat <aljeux(at)free(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuumdb: PANIC: corrupted item pointer
Date: 2007-07-10 12:10:24
Message-ID: 20070710141024.ks20ex86go8ooos8@imp4.free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

System: Red Hat Linux 4 64bits running postgres-7.4.16 (production)

Initial problem:

# pg_dump -O dbname -Ft -f /tmp/database.tar
pg_dump: query to get table columns failed: ERROR:  invalid memory
alloc request size 9000688640

After some research, it seems to be related to a corruption of the
database. Running a vacum crashes the db:

-bash-3.00$ vacuumdb -z -a
vacuumdb: vacuuming database "template1"
vacuumdb: vacuuming of database "template1" failed: PANIC:  corrupted
item pointer: offset = 3336, size = 20
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
-bash-3.00$

Can someone help me to track down the problem ?

Can I recover the datas (last backup failed) ?

Best regards,

Alain.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2007-07-10 12:14:30 Re: russian case-insensitive regexp search not working
Previous Message John DeSoi 2007-07-10 11:35:59 Re: catalog location