[postgis-users] Postgis 3.0 Extension fails to install

[Zwettler Markus (OIZ)]

I found that "create extension" takes all RAM available (8G) until it is killed by OOM:


2020-06-03 16:42:35 CEST : 127.0.0.1=>myuser at mydb : 117666-5ed7b6d6.1cba2-5/4 : 00000 LOG:  statement: create extension postgis;
2020-06-03 16:44:24 CEST : =>@ : 117641-5ed7b6b7.1cb89- : 00000 LOG:  server process (PID 117666) was terminated by signal 9: Killed
2020-06-03 16:44:24 CEST : =>@ : 117641-5ed7b6b7.1cb89- : 00000 DETAIL:  Failed process was running: create extension postgis;
2020-06-03 16:44:24 CEST : =>@ : 117641-5ed7b6b7.1cb89- : 00000 LOG:  terminating any other active server processes
2020-06-03 16:44:24 CEST : 127.0.0.1=>[unknown]@[unknown] : 117719-5ed7b748.1cbd7- : 00000 LOG:  connection received: host=127.0.0.1 port=44916
2020-06-03 16:44:24 CEST : 127.0.0.1=>myuser at mydb : 117719-5ed7b748.1cbd7- : 57P03 FATAL:  the database system is in recovery mode
2020-06-03 16:44:24 CEST : =>@ : 117648-5ed7b6b7.1cb90-1/0 : 57P02 WARNING:  terminating connection because of crash of another server process
2020-06-03 16:44:24 CEST : =>@ : 117648-5ed7b6b7.1cb90-1/0 : 57P02 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.


Jun  3 16:44:23 szhm49289 kernel: Out of memory: Kill process 117666 (postmaster) score 976 or sacrifice child
Jun  3 16:44:23 szhm49289 kernel: Killed process 117666 (postmaster), UID 280, total-vm:33401700kB, anon-rss:7548584kB, file-rss:56kB, shmem-rss:1316kB


Any idea?


-Markus



Von: postgis-users <postgis-users-bounces at lists.osgeo.org> Im Auftrag von Zwettler Markus (OIZ)
Gesendet: Mittwoch, 3. Juni 2020 15:23
An: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Betreff: [postgis-users] Postgis 3.0 Extension fails to install

We have following RPMs installed:

postgresql12-server-12.2-2PGDG.rhel7.x86_64
postgresql12-llvmjit-12.2-2PGDG.rhel7.x86_64
postgresql12-libs-12.2-2PGDG.rhel7.x86_64
postgresql12-plpython-12.2-2PGDG.rhel7.x86_64
postgresql12-12.2-2PGDG.rhel7.x86_64
postgresql12-contrib-12.2-2PGDG.rhel7.x86_64
postgresql12-devel-12.2-2PGDG.rhel7.x86_64
postgis30_12-client-3.0.1-5.rhel7.x86_64
postgis30_12-3.0.1-5.rhel7.x86_64



Postgis installation fails with:
myuser at mydb # create extension postgis;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Time: 107706.124 ms (01:47.706)



Any idea?



-Markus


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200603/86da6c54/attachment.html>