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

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

From
Feite Brekeveld
Date:
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.brekeveld@osiris-it.nl



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

From
"Steve Wolfe"
Date:
> 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:

   You wouldn't by chance be using 6.5, would you?  7.x handles
out-of-disk-space worlds more gracefully than 6.5 did.

steve