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 1fY6nN-0006Tr-VH for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Jun 2018 09:31:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fY6nL-0005vr-No for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Jun 2018 09:31:23 +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 1fY6nL-0005vk-Ey for pgsql-bugs@lists.postgresql.org; Wed, 27 Jun 2018 09:31:23 +0000 Received: from forward4o.cmail.yandex.net ([37.9.109.248]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fY6nI-0005Dy-5d for pgsql-bugs@lists.postgresql.org; Wed, 27 Jun 2018 09:31:22 +0000 Received: from mxback6o.mail.yandex.net (mxback6o.mail.yandex.net [IPv6:2a02:6b8:0:1a2d::20]) by forward4o.cmail.yandex.net (Yandex) with ESMTP id E562D20E8A; Wed, 27 Jun 2018 12:31:16 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback6o.mail.yandex.net (nwsmtp/Yandex) with ESMTP id 114jRPujiA-VFtiVHAF; Wed, 27 Jun 2018 12:31:15 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail; t=1530091875; bh=Gg5w8+swLz2ixgBCtBoECkhLPCBAZh4/aCDc2xgMS8Y=; h=From:To:In-Reply-To:References:Subject:Date:Message-Id; b=cDVgUCUXlNFmyVso7+LfOQjROdK2/tc4dnZc8faI1zjpA4TSolSpMeI7QptBdVoux Z4YQezEDXjAHWt8BjVoHIaPukxv5igQkYOrit8LpTYxFY5qlLtxCyqz+WeL06+JZWu SMePDxvAHqlPIJUI2+v02mbpIhCa9+ce/AG4l8hA= Authentication-Results: mxback6o.mail.yandex.net; dkim=pass header.i=@zsrv.org Received: by web12g.yandex.ru with HTTP; Wed, 27 Jun 2018 12:31:15 +0300 From: Sergei Kornilov To: Anjul Tyagi , "pgsql-bugs@lists.postgresql.org" In-Reply-To: References: Subject: Re: Server Crash MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 27 Jun 2018 12:31:15 +0300 Message-Id: <6514671530091875@web12g.yandex.ru> Content-Transfer-Encoding: 7bit Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello > 2018-06-21 13:43:29 EDT [22212]: [4-1] user=cmsuser,db=forte ,host=10.10.1.3,port=10.10.1.3(56601),id=5b2bdea5.56c4,line=4DETAIL: 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. This is just consequence of error. Similar message is reported by every client connect process. Real error was before all of these messages. > Postgres - Postgres 9.1.13 You are using unsupported major version and even very old minor. Last released 9.1 was 9.1.24 (Release Date: 2016-10-27). You missed bug fixes for 2.5 years. According versioning policy [1] bug fixing ceases for EOL versions. I suggest upgrade to one of supported version. Postgresql 10 is good choice. If error still occurs on supported version - we need exact error message from failed backend. regards, Sergei [1] https://www.postgresql.org/support/versioning/