Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance

Поиск
Список
Период
Сортировка
От Feike Steenbergen
Тема Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance
Дата
Msg-id CAK_s-G0RMp_J0iL+sVYFaAASL_vLqrmk27PqDFfAdJM0M8QHfA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance  (josef.machytka@gmail.com)
Список pgsql-bugs


On 6 October 2017 at 13:24, <josef.machytka@gmail.com> wrote:
> After that in first case postgresql crashed (which was more or less OK
> because it restarted) but in second case the whole Debian instance crashed

What causes the crash, is it the out-of-memory (OOM) killer?
How have you configured overcommit on your Debian instance?

https://www.postgresql.org/docs/current/static/kernel-resources.html#linux-memory-overcommit

If it is the OOM killer killing your process, you may want to disable overcommit. Doing that should cause the client to get a decent error message instead of the the whole cluster being restarted.

regards,

Feike

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

Предыдущее
От: josef.machytka@gmail.com
Дата:
Сообщение: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance