Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group