Intemittendly get "server process (PID 5884) exited with exit code 3"

Поиск
Список
Период
Сортировка
От Wetzel, Juergen (Juergen)
Тема Intemittendly get "server process (PID 5884) exited with exit code 3"
Дата
Msg-id B21CD5EA385190469D02AC8D9D60E61A5AECCE60@AZ-FFEXMB03.global.avaya.com
обсуждение исходный текст
Ответы Re: Intemittendly get "server process (PID 5884) exited with exit code 3"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Hi,

 

I’m working with postgres version 9.3.10 on Windows. From time to time a postgres process terminates with following messages:

 

LOG:  server process (PID 5884) exited with exit code 3

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.

 

This ends up in an endless loop of these messages. Only possibility to recover is to restart postgres service.

 

Has anybody an idea what can cause this? Or is there a possibility to get more (useful) log messages? Every time when I change log_min_messages to a value providing more information than “warning” the bug does not occur anymore.

 

Regards

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Calculating Minkowski distance between two rows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Intemittendly get "server process (PID 5884) exited with exit code 3"