пропозиції роботи
Marcin Adamowicz Programista, T3 s.c.
Temat: Baza ustawia się na "recovery mode" po autovacuum
WitamMam problem z bazą w wersji 9.2 na linuxie
Po odpaleniu autovacuum przełącza się w tryb recovery.
Problemy z pamięcią i dyskiem wykluczone miało to miejsce na kilku serwerach.
Podejrzewał bym konfigurację bazy danych ale wolał bym nie zgadywać.
Dokładnie ma to następujący przebieg:
DETAIL: Failed process was running: autovacuum: ANALYZE public.tabela1
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
.........
HINT: In a moment you should be able to reconnect to the database and repeat your command.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2015-06-19 14:24:38 GMT
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 0/8CA0F2D8
LOG: record with zero length at 0/8E51904C
LOG: redo done at 0/8E519024
LOG: last completed transaction was at log time 2015-06-19 14:27:32.077918+00
FATAL: the database system is in recovery mode
FATAL: the database system is in recovery mode
FATAL: the database system is in recovery mode
FATAL: the database system is in recovery mode
FATAL: the database system is in recovery mode
FATAL: the database system is in recovery mode
