Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g5Vab-0006xa-Ia for pgsql-admin@arkaria.postgresql.org; Thu, 27 Sep 2018 12:40:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g5VaY-0005rK-UM for pgsql-admin@arkaria.postgresql.org; Thu, 27 Sep 2018 12:40:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g5VaY-0005r3-MT for pgsql-admin@lists.postgresql.org; Thu, 27 Sep 2018 12:40:14 +0000 Received: from sdcsmtp.sdc-world.com ([24.153.34.136]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g5VaP-0005XV-Ru for pgsql-admin@postgresql.org; Thu, 27 Sep 2018 12:40:13 +0000 X-ASG-Debug-ID: 1538051975-1075dd169dd1550001-ysJW5H Received: from sdcsrvex01.sdc-world.com (sdcsrvex01.sdc-world.com [192.168.11.133]) by sdcsmtp.sdc-world.com with ESMTP id on3A1Y4Z4BX5f7Qg (version=TLSv1 cipher=AES128-SHA bits=128 verify=NO) for ; Thu, 27 Sep 2018 08:39:35 -0400 (EDT) X-Barracuda-Envelope-From: denise.ferrell@sdc-world.com X-ASG-Whitelist: Client Received: from SDCX.sdc-world.com (192.168.11.131) by SDCSRVEX01.sdc-world.com (192.168.11.133) with Microsoft SMTP Server (TLS) id 8.3.485.1; Thu, 27 Sep 2018 08:39:34 -0400 Received: from SDCX.sdc-world.com (192.168.11.131) by SDCX.sdc-world.com (192.168.11.131) with Microsoft SMTP Server (TLS) id 15.0.1347.2; Thu, 27 Sep 2018 08:39:33 -0400 Received: from SDCX.sdc-world.com ([::1]) by SDCX.sdc-world.com ([::1]) with mapi id 15.00.1347.000; Thu, 27 Sep 2018 08:39:33 -0400 From: "Ferrell, Denise SDC" To: "pgsql-admin@postgresql.org" Subject: Data Corruption Errors Thread-Topic: Data Corruption Errors X-ASG-Orig-Subj: Data Corruption Errors Thread-Index: AQHUVl3LwNXdBIgBL02J/AxJCGwLxw== Date: Thu, 27 Sep 2018 12:39:33 +0000 Message-ID: <1538051973729.67553@sdc-world.com> References: ,<64b2d16e-6c7c-002a-1e16-209a3ae43bef@2ndquadrant.com> In-Reply-To: <64b2d16e-6c7c-002a-1e16-209a3ae43bef@2ndquadrant.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [138.162.0.43] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Barracuda-Connect: sdcsrvex01.sdc-world.com[192.168.11.133] X-Barracuda-Start-Time: 1538051975 X-Barracuda-Encrypted: AES128-SHA X-Barracuda-URL: https://192.168.11.136:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at sdc-world.com X-Barracuda-Scan-Msg-Size: 1056 X-Barracuda-BRTS-Status: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Using Linux/PostgreSQL 9.5 & setup on a VM.=0A= =0A= I'm receiving the following errors during an insert using a function but th= is does not happen every time. When this does occur the database/system is= unavailable until the processes are killed or the service is restarted.=0A= =0A= "LOG: server process (PID xxxxx) was terminated by signal 9: Killed=0A= DETAIL: Failed process was running=0A= select insert_data ($1, $2,....)=0A= WARNING: terminating connection because of crash of another server process= =0A= DETAIL: The postmaster has commanded this server process to roll back the = current transaction and exit, because another server process exited abnorma= lly and possibly corrupted shared memory.=0A= HINT: In a moment you should be able to reconnect ....=0A= LOG: connection received = =0A= FATAL: the database system is in recovery mode"=0A= =0A= The last 2 lines are repeated and logging is not available.=0A= =0A= How can I determine data/table/shared memory corruption? =0A= =0A= Thank you in advance for your responses.=0A= =0A= D. Ferrell=