[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Postgis 3.0 Extension fails to install
From:       "Zwettler Markus (OIZ)" <Markus.Zwettler () zuerich ! ch>
Date:       2020-06-03 14:55:46
Message-ID: 18299bbf4b754b9ab2a3323aa5060a5c () zuerich ! ch
[Download RAW message or body]

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@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@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@lists.osgeo.org> Im Auftrag von Zwettler \
                Markus (OIZ)
Gesendet: Mittwoch, 3. Juni 2020 15:23
An: PostGIS Users Discussion <postgis-users@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@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


[Attachment #3 (text/html)]

<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
h1
	{mso-style-priority:9;
	mso-style-link:"\00DCberschrift 1 Zchn";
	margin-top:12.0pt;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:0cm;
	margin-bottom:.0001pt;
	page-break-after:avoid;
	font-size:16.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
h2
	{mso-style-priority:9;
	mso-style-link:"\00DCberschrift 2 Zchn";
	margin-top:12.0pt;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:0cm;
	margin-bottom:.0001pt;
	page-break-after:avoid;
	font-size:14.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
h3
	{mso-style-priority:9;
	mso-style-link:"\00DCberschrift 3 Zchn";
	margin-top:12.0pt;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:0cm;
	margin-bottom:.0001pt;
	page-break-after:avoid;
	font-size:12.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
h4
	{mso-style-priority:9;
	mso-style-link:"\00DCberschrift 4 Zchn";
	margin-top:12.0pt;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:0cm;
	margin-bottom:.0001pt;
	page-break-after:avoid;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
h5
	{mso-style-priority:9;
	mso-style-link:"\00DCberschrift 5 Zchn";
	margin-top:12.0pt;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:0cm;
	margin-bottom:.0001pt;
	page-break-after:avoid;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoHeader, li.MsoHeader, div.MsoHeader
	{mso-style-priority:99;
	mso-style-link:"Kopfzeile Zchn";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
	{mso-style-priority:99;
	mso-style-link:"Fu\00DFzeile Zchn";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListBullet, li.MsoListBullet, div.MsoListBullet
	{mso-style-priority:99;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:36.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l2 level1 lfo6;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListBulletCxSpFirst, li.MsoListBulletCxSpFirst, div.MsoListBulletCxSpFirst
	{mso-style-priority:99;
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:36.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l2 level1 lfo6;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListBulletCxSpMiddle, li.MsoListBulletCxSpMiddle, div.MsoListBulletCxSpMiddle
	{mso-style-priority:99;
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:36.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l2 level1 lfo6;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListBulletCxSpLast, li.MsoListBulletCxSpLast, div.MsoListBulletCxSpLast
	{mso-style-priority:99;
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:36.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l2 level1 lfo6;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListNumber, li.MsoListNumber, div.MsoListNumber
	{mso-style-priority:99;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:18.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l0 level1 lfo8;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListNumberCxSpFirst, li.MsoListNumberCxSpFirst, div.MsoListNumberCxSpFirst
	{mso-style-priority:99;
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:18.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l0 level1 lfo8;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListNumberCxSpMiddle, li.MsoListNumberCxSpMiddle, div.MsoListNumberCxSpMiddle
	{mso-style-priority:99;
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:18.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l0 level1 lfo8;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoListNumberCxSpLast, li.MsoListNumberCxSpLast, div.MsoListNumberCxSpLast
	{mso-style-priority:99;
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:18.0pt;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	text-indent:-18.0pt;
	mso-list:l0 level1 lfo8;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.MsoTitle, li.MsoTitle, div.MsoTitle
	{mso-style-priority:10;
	mso-style-link:"Titel Zchn";
	margin-top:24.0pt;
	margin-right:0cm;
	margin-bottom:12.0pt;
	margin-left:0cm;
	mso-add-space:auto;
	font-size:20.0pt;
	font-family:"Arial",sans-serif;
	letter-spacing:.25pt;
	mso-fareast-language:EN-US;
	font-weight:bold;}
p.MsoTitleCxSpFirst, li.MsoTitleCxSpFirst, div.MsoTitleCxSpFirst
	{mso-style-priority:10;
	mso-style-link:"Titel Zchn";
	mso-style-type:export-only;
	margin-top:24.0pt;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:0cm;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	font-size:20.0pt;
	font-family:"Arial",sans-serif;
	letter-spacing:.25pt;
	mso-fareast-language:EN-US;
	font-weight:bold;}
p.MsoTitleCxSpMiddle, li.MsoTitleCxSpMiddle, div.MsoTitleCxSpMiddle
	{mso-style-priority:10;
	mso-style-link:"Titel Zchn";
	mso-style-type:export-only;
	margin:0cm;
	margin-bottom:.0001pt;
	mso-add-space:auto;
	font-size:20.0pt;
	font-family:"Arial",sans-serif;
	letter-spacing:.25pt;
	mso-fareast-language:EN-US;
	font-weight:bold;}
p.MsoTitleCxSpLast, li.MsoTitleCxSpLast, div.MsoTitleCxSpLast
	{mso-style-priority:10;
	mso-style-link:"Titel Zchn";
	mso-style-type:export-only;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:12.0pt;
	margin-left:0cm;
	mso-add-space:auto;
	font-size:20.0pt;
	font-family:"Arial",sans-serif;
	letter-spacing:.25pt;
	mso-fareast-language:EN-US;
	font-weight:bold;}
p.MsoSubtitle, li.MsoSubtitle, div.MsoSubtitle
	{mso-style-priority:11;
	mso-style-link:"Untertitel Zchn";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	letter-spacing:.75pt;
	mso-fareast-language:EN-US;
	font-weight:bold;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing
	{mso-style-priority:1;
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
p.Standard85, li.Standard85, div.Standard85
	{mso-style-name:"Standard 8\.5";
	mso-style-link:"Standard 8\.5 Zchn";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:8.5pt;
	font-family:"Arial",sans-serif;
	mso-fareast-language:EN-US;}
span.Standard85Zchn
	{mso-style-name:"Standard 8\.5 Zchn";
	mso-style-link:"Standard 8\.5";
	font-family:"Arial",sans-serif;}
span.berschrift1Zchn
	{mso-style-name:"\00DCberschrift 1 Zchn";
	mso-style-priority:9;
	mso-style-link:"\00DCberschrift 1";
	font-family:"Arial",sans-serif;
	font-weight:bold;}
span.berschrift2Zchn
	{mso-style-name:"\00DCberschrift 2 Zchn";
	mso-style-priority:9;
	mso-style-link:"\00DCberschrift 2";
	font-family:"Arial",sans-serif;
	font-weight:bold;}
span.berschrift3Zchn
	{mso-style-name:"\00DCberschrift 3 Zchn";
	mso-style-priority:9;
	mso-style-link:"\00DCberschrift 3";
	font-family:"Arial",sans-serif;
	font-weight:bold;}
span.berschrift4Zchn
	{mso-style-name:"\00DCberschrift 4 Zchn";
	mso-style-priority:9;
	mso-style-link:"\00DCberschrift 4";
	font-family:"Arial",sans-serif;
	font-weight:bold;}
span.berschrift5Zchn
	{mso-style-name:"\00DCberschrift 5 Zchn";
	mso-style-priority:9;
	mso-style-link:"\00DCberschrift 5";
	font-family:"Arial",sans-serif;
	font-weight:bold;}
span.UntertitelZchn
	{mso-style-name:"Untertitel Zchn";
	mso-style-priority:11;
	mso-style-link:Untertitel;
	font-family:"Arial",sans-serif;
	letter-spacing:.75pt;
	font-weight:bold;}
span.TitelZchn
	{mso-style-name:"Titel Zchn";
	mso-style-priority:10;
	mso-style-link:Titel;
	font-family:"Arial",sans-serif;
	letter-spacing:.25pt;
	font-weight:bold;}
span.KopfzeileZchn
	{mso-style-name:"Kopfzeile Zchn";
	mso-style-priority:99;
	mso-style-link:Kopfzeile;
	font-family:"Arial",sans-serif;}
span.FuzeileZchn
	{mso-style-name:"Fu\00DFzeile Zchn";
	mso-style-priority:99;
	mso-style-link:Fu\00DFzeile;
	font-family:"Arial",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
	{mso-style-name:msonormal;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;}
span.E-MailFormatvorlage36
	{mso-style-type:personal;
	font-family:"Arial",sans-serif;
	font-variant:normal !important;
	color:windowtext;
	text-transform:none;
	position:relative;
	top:0pt;
	mso-text-raise:0pt;
	letter-spacing:0pt;
	mso-ligatures:none;
	mso-number-form:default;
	mso-number-spacing:default;
	mso-stylistic-set:0;
	mso-contextual-alternates:no;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;
	vertical-align:baseline;}
span.E-MailFormatvorlage37
	{mso-style-type:personal-reply;
	font-family:"Arial",sans-serif;
	font-variant:normal !important;
	color:windowtext;
	text-transform:none;
	position:relative;
	top:0pt;
	mso-text-raise:0pt;
	letter-spacing:0pt;
	mso-ligatures:none;
	mso-number-form:default;
	mso-number-spacing:default;
	mso-stylistic-set:0;
	mso-contextual-alternates:no;
	text-shadow:none;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;
	vertical-align:baseline;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
	{page:WordSection1;}
/* List Definitions */
@list l0
	{mso-list-id:-120;
	mso-list-type:simple;
	mso-list-template-ids:-2036700426;}
@list l0:level1
	{mso-level-style-link:Listennummer;
	mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;}
@list l1
	{mso-list-id:-119;
	mso-list-type:simple;
	mso-list-template-ids:1072705328;}
@list l1:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2
	{mso-list-id:99691344;
	mso-list-type:hybrid;
	mso-list-template-ids:-435887208 -755725786 134676483 134676485 134676481 134676483 \
134676485 134676481 134676483 134676485;} @list l2:level1
	{mso-level-number-format:bullet;
	mso-level-style-link:Aufz\00E4hlungszeichen;
	mso-level-text:\F0B7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2:level2
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l2:level3
	{mso-level-number-format:bullet;
	mso-level-text:\F0A7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l2:level4
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2:level5
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l2:level6
	{mso-level-number-format:bullet;
	mso-level-text:\F0A7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l2:level7
	{mso-level-number-format:bullet;
	mso-level-text:\F0B7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Symbol;}
@list l2:level8
	{mso-level-number-format:bullet;
	mso-level-text:o;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:"Courier New";}
@list l2:level9
	{mso-level-number-format:bullet;
	mso-level-text:\F0A7;
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	text-indent:-18.0pt;
	font-family:Wingdings;}
ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE-CH" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">I found that \
&quot;create extension&quot; takes all RAM available (8G) until it is killed by \
OOM:<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US">2020-06-03 16:42:35 CEST : 127.0.0.1=&gt;myuser@mydb : \
117666-5ed7b6d6.1cba2-5/4 : 00000 LOG:&nbsp; statement: create extension \
postgis;<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US">2020-06-03 \
16:44:24 CEST : =&gt;@ : 117641-5ed7b6b7.1cb89- : 00000 LOG:&nbsp; server process \
(PID 117666) was terminated by signal 9: Killed<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">2020-06-03 16:44:24 CEST : =&gt;@ : \
117641-5ed7b6b7.1cb89- : 00000 DETAIL:&nbsp; Failed process was running: create \
extension postgis;<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US">2020-06-03 16:44:24 CEST : =&gt;@ : 117641-5ed7b6b7.1cb89- : 00000 \
LOG:&nbsp; terminating any other active server processes<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">2020-06-03 16:44:24 CEST : \
127.0.0.1=&gt;[unknown]@[unknown] : 117719-5ed7b748.1cbd7- : 00000 LOG:&nbsp; \
connection received: host=127.0.0.1 port=44916<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">2020-06-03 16:44:24 CEST : \
127.0.0.1=&gt;myuser@mydb : 117719-5ed7b748.1cbd7- : 57P03 FATAL:&nbsp; the database \
system is in recovery mode<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US">2020-06-03 16:44:24 CEST : =&gt;@ : 117648-5ed7b6b7.1cb90-1/0 : 57P02 \
WARNING:&nbsp; terminating connection because of crash of another server \
process<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US">2020-06-03 \
16:44:24 CEST : =&gt;@ : 117648-5ed7b6b7.1cb90-1/0 : 57P02 DETAIL:&nbsp; 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.<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US">Jun&nbsp; 3 16:44:23 szhm49289 kernel: Out of memory: Kill process \
117666 (postmaster) score 976 or sacrifice child<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">Jun&nbsp; 3 16:44:23 szhm49289 kernel: Killed \
process 117666 (postmaster), UID 280, total-vm:33401700kB, anon-rss:7548584kB, \
file-rss:56kB, shmem-rss:1316kB<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span lang="EN-US">Any \
idea?<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt">-Markus<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US" style="font-size:10.0pt"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US" style="font-size:10.0pt"><o:p>&nbsp;</o:p></span></p> <div \
style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt"> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="DE" \
style="font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:DE-CH">Von:</span></b><span \
lang="DE" style="font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:DE-CH"> \
postgis-users &lt;postgis-users-bounces@lists.osgeo.org&gt; <b>Im Auftrag von \
</b>Zwettler Markus (OIZ)<br> <b>Gesendet:</b> Mittwoch, 3. Juni 2020 15:23<br>
<b>An:</b> PostGIS Users Discussion &lt;postgis-users@lists.osgeo.org&gt;<br>
<b>Betreff:</b> [postgis-users] Postgis 3.0 Extension fails to \
install<o:p></o:p></span></p> </div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">We have following \
RPMs installed:<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" \
style="font-size:10.0pt"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US">postgresql12-server-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="EN-US">postgresql12-llvmjit-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="EN-US">postgresql12-libs-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="EN-US">postgresql12-plpython-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="EN-US">postgresql12-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="EN-US">postgresql12-contrib-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="FR-CH">postgresql12-devel-12.2-2PGDG.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="FR-CH">postgis30_12-client-3.0.1-5.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span \
lang="FR-CH">postgis30_12-3.0.1-5.rhel7.x86_64<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">Postgis installation fails \
with:<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US">myuser@mydb # \
create extension postgis;<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-US">server closed the connection unexpectedly<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This \
probably means the server terminated abnormally<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \
before or while processing the request.<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US">The connection to the server was lost. </span> \
<span lang="FR-CH">Attempting reset: Failed.<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="FR-CH">Time: 107706.124 ms \
(01:47.706)<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span lang="FR-CH">Any \
idea?<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH">-Markus<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> <p class="MsoNormal"><span \
lang="FR-CH"><o:p>&nbsp;</o:p></span></p> </div>
</div>
</body>
</html>


[Attachment #4 (unknown)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic