FATAL 2 : after a vacuum, can't start postmaster anymore

From: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: FATAL 2 : after a vacuum, can't start postmaster anymore
Date: 2001-04-27 20:00:00
Message-ID: 3AE9CFC0.7D8FEC20@osiris-it.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

After doing a vacuumdb my postmaster went down due to diskspace
problems. At first I gained 650 Mb then all of it was retaken.

Messages from the serverlog:

DEBUG: starting up
DEBUG: database system was interrupted being in recovery at 2001-04-27
21:43:53 This propably means that some data blocks are corrupted
and you will have to use last backup for recovery.
DEBUG: CheckPoint record at (1, 2148175408)
DEBUG: Redo record at (1, 2146413588); Undo record at (1, 1692823116);
Shutdown FALSE
DEBUG: NextTransactionId: 2358581; NextOid: 4569236
DEBUG: database system was not properly shut down; automatic recovery
in progress...
DEBUG: redo starts at (1, 2146413588)
NOTICE: PageAddItem: tried overwrite of used ItemId
FATAL 2: heap_update_redo: failed to add tuple
Startup failed - abort

How to get things in the air again ?

--
Feite Brekeveld
feite(dot)brekeveld(at)osiris-it(dot)nl

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sterling 2001-04-27 20:07:55 Re: SQL Where Like - Range it?!
Previous Message Brook Milligan 2001-04-27 19:56:50 Re: [HACKERS] While we're on the subject of searches...