Re: Out of memory with "create extension postgis"
От | Daniel Westermann (DWE) |
---|---|
Тема | Re: Out of memory with "create extension postgis" |
Дата | |
Msg-id | ZR0P278MB0122C24D9DEE78F10A336287D2730@ZR0P278MB0122.CHEP278.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: Out of memory with "create extension postgis" (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Out of memory with "create extension postgis"
|
Список | pgsql-general |
>>> "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
>>>> The process eats all the available memory and finally dies:
>>>> # create extension postgis;
>>>> ERROR: out of memory
>>>> DETAIL: Failed on request of size 8265691 in memory context "PortalContext".
>>>> Time: 773569.877 ms (12:53.570)
>> There is nothing in the log file except these (not from today, but the messages are always the same):
>> 2020-07-03 16:52:16 CEST 53617 LOG: server process (PID 54070) was terminated by signal 9: Killed
>A process that was killed by the OOM killer would not have managed to
>produce an "out of memory" ERROR report, so these two are different
>symptoms. You need to reproduce the first case, or you won't have
>any luck setting an error breakpoint either.
>>>> # create extension postgis;
>>>> ERROR: out of memory
>>>> DETAIL: Failed on request of size 8265691 in memory context "PortalContext".
>>>> Time: 773569.877 ms (12:53.570)
>> There is nothing in the log file except these (not from today, but the messages are always the same):
>> 2020-07-03 16:52:16 CEST 53617 LOG: server process (PID 54070) was terminated by signal 9: Killed
>A process that was killed by the OOM killer would not have managed to
>produce an "out of memory" ERROR report, so these two are different
>symptoms. You need to reproduce the first case, or you won't have
>any luck setting an error breakpoint either.
You're right, that was before we adjusted the oom behavior. Will get back once I have more information.
Regards
Daniel
В списке pgsql-general по дате отправления: