Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance - Mailing list pgsql-bugs

From Feike Steenbergen
Subject Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance
Date
Msg-id CAK_s-G0RMp_J0iL+sVYFaAASL_vLqrmk27PqDFfAdJM0M8QHfA@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance  (josef.machytka@gmail.com)
List 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 by date:

Previous
From: josef.machytka@gmail.com
Date:
Subject: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: [BUGS] BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance