>>>> "Daniel Westermann (DWE)" <daniel.westermann@xxxxxxxxxxxxxxxx> 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. >You're right, that was before we adjusted the oom behavior. Will get back once I have more information. So this is what we got today. In the log file there is this: 2020-07-29 16:33:23 CEST 101995 ERROR: out of memory 2020-07-29 16:33:23 CEST 101995 DETAIL: Failed on request of size 8265691 in memory context "PortalContext". 2020-07-29 16:33:23 CEST 101995 STATEMENT: create extension postgis; 2020-07-29 16:35:00 CEST 106695 LOG: disconnection: session time: 0:04:45.200 user=monitor database=pcl_l800 host=127.0.0.1 port=52160 2020-07-29 16:35:00 CEST 107063 LOG: connection received: host=127.0.0.1 port=52212 2020-07-29 16:35:00 CEST 107063 LOG: connection authorized: user=monitor database=pdb_l80_oiz application_name=pg_statsinfod 2020-07-29 16:35:00 CEST 53630 ALERT: pg_statsinfo: memory swap size exceeds threshold in snapshot '2020-07-29 16:35:00' --- 17383584 KiB (threshold = 1000000 KiB) 2020-07-29 16:35:15 CEST 107063 LOG: disconnection: session time: 0:00:14.770 user=monitor database=pdb_l80_oiz host=127.0.0.1 port=52212 2020-07-29 16:35:15 CEST 107269 LOG: connection received: host=127.0.0.1 port=52220 The GDB session shows this: (gdb) set pagination off (gdb) set logging file postgis.log (gdb) (gdb) set logging on Copying output to postgis.log. (gdb) b errfinish Breakpoint 1 at 0x87e210: file elog.c, line 411. (gdb) cont Continuing. Breakpoint 1, errfinish (dummy=dummy@entry=0) at elog.c:411 411 elog.c: No such file or directory. (gdb) cont Continuing. Breakpoint 1, errfinish (dummy=dummy@entry=0) at elog.c:411 411 in elog.c Missing separate debuginfos, use: debuginfo-install CGAL-4.7-1.rhel7.1.x86_64 boost-date-time-1.53.0-27.el7.x86_64 boost-serialization-1.53.0-27.el7.x86_64 boost-system-1.53.0-27.el7.x86_64 boost-thread-1.53.0-27.el7.x86_64 gmp-6.0.0-15.el7.x86_64 jbigkit-libs-2.0-11.el7.x86_64 json-c-0.11-4.el7_0.x86_64 libcurl-7.29.0-54.el7_7.2.x86_64 libidn-1.28-4.el7.x86_64 libjpeg-turbo-1.2.90-8.el7.x86_64 libssh2-1.8.0-3.el7.x86_64 libtiff-4.0.3-32.el7.x86_64 mpfr-3.1.1-4.el7.x86_64 postgis30_12-3.0.1-5.rhel7.x86_64 protobuf-c-1.0.2-3.el7.x86_64 sqlite33-libs-3.30.1-1.rhel7.x86_64 (gdb) Continuing. The GDB logfile shows this: [root@tstm49012 ~]# cat postgis.log Breakpoint 1 at 0x87e210: file elog.c, line 411. Continuing. Breakpoint 1, errfinish (dummy=dummy@entry=0) at elog.c:411 411 elog.c: No such file or directory. Continuing. Breakpoint 1, errfinish (dummy=dummy@entry=0) at elog.c:411 411 in elog.c Missing separate debuginfos, use: debuginfo-install CGAL-4.7-1.rhel7.1.x86_64 boost-date-time-1.53.0-27.el7.x86_64 boost-serialization-1.53.0-27.el7.x86_64 boost-system-1.53.0-27.el7.x86_64 boost-thread-1.53.0-27.el7.x86_64 gmp-6.0.0-15.el7.x86_64 jbigkit-libs-2.0-11.el7.x86_64 json-c-0.11-4.el7_0.x86_64 libcurl-7.29.0-54.el7_7.2.x86_64 libidn-1.28-4.el7.x86_64 libjpeg-turbo-1.2.90-8.el7.x86_64 libssh2-1.8.0-3.el7.x86_64 libtiff-4.0.3-32.el7.x86_64 mpfr-3.1.1-4.el7.x86_64 postgis30_12-3.0.1-5.rhel7.x86_64 protobuf-c-1.0.2-3.el7.x86_64 sqlite33-libs-3.30.1-1.rhel7.x86_64 Continuing. Program received signal SIGINT, Interrupt. 0x00007f94f4af2e93 in __epoll_wait_nocancel () from /lib64/libc.so.6 Detaching from program: /usr/pgsql-12/bin/postgres, process 101995 [root@tstm49012 ~]# Is that of any help? Regards Daniel
