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

Поиск
Список
Период
Сортировка
От Feite Brekeveld
Тема FATAL 2 : after a vacuum, can't start postmaster anymore
Дата
Msg-id 3AE9CFC0.7D8FEC20@osiris-it.nl
обсуждение исходный текст
Список 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.brekeveld@osiris-it.nl



В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Maxwell
Дата:
Сообщение: Regex select ~ with ^ not using index on char field or text; Locale bug?
Следующее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: FATAL 2 : after a vacuum, can't start postmaster an ymore