Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGcsb-00025S-2n for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Apr 2019 05:13:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hGcsZ-0001K4-05 for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Apr 2019 05:13:03 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGcsY-0001Jw-ND for pgsql-bugs@lists.postgresql.org; Wed, 17 Apr 2019 05:13:02 +0000 Received: from mail-oln040092255058.outbound.protection.outlook.com ([40.92.255.58] helo=APC01-HK2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGcsU-0002cF-TB for pgsql-bugs@lists.postgresql.org; Wed, 17 Apr 2019 05:13:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=2iENPMclQj4tvChP53b+uWLB9WIA3OL3f+JfDFIgiyo=; b=gFcXfajhl7t78rrPQIKAFFHf3H4vksBD/0Sxd23+/Fvoz0P+TlctGnJCQMH4ye8vJdOLwDl1qKSQm+CahgTWmto5ANOtg26TGSxJGMV0uNk11BiwXrDPmevBzCwgEfY/oqBzXK0D6iZiH2SXAp6lFUmPVzvLvHc1TRd7k3o1qQCq4g+llsMzREQrFqstSEPFRK1JxkRNOHEzxSV/dS2gGV8v07QNDzPe4tV7o9vLmsSpJbO6ooTv9aDdtUrMF3wP5sgOeUd+Cgk0+wVRv7JYUWiriSujRmqEwV5o99r/bRPV11jFstJT07rvC7hgcMsZQ8JrZJWjL0Kyvi0i6vg24g== Received: from PU1APC01FT010.eop-APC01.prod.protection.outlook.com (10.152.252.57) by PU1APC01HT040.eop-APC01.prod.protection.outlook.com (10.152.253.247) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1771.16; Wed, 17 Apr 2019 05:12:54 +0000 Received: from MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM (10.152.252.58) by PU1APC01FT010.mail.protection.outlook.com (10.152.252.83) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1771.16 via Frontend Transport; Wed, 17 Apr 2019 05:12:54 +0000 Received: from MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM ([fe80::c1f8:460e:124a:283]) by MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM ([fe80::c1f8:460e:124a:283%2]) with mapi id 15.20.1792.021; Wed, 17 Apr 2019 05:12:53 +0000 From: soumitra bhandary To: "pgsql-bugs@lists.postgresql.org" Subject: Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication Thread-Topic: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication Thread-Index: AQHU9NngdNRP/s+uPECvZO+AElnPHaY/zqOU Date: Wed, 17 Apr 2019 05:12:53 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:B8F6B8092F590F08B2DB0150D1E5D488D6EBE3B7FDFA2689AC83630BF328C2E2;UpperCasedChecksum:08A651864A409A511D36FFE3B709C360F2229C22775D2043FCC7AEC76FB1AF0B;SizeAsReceived:6956;Count:43 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [Ldic/v25dV1ZOuqex6WeoWjSCmgUDZLK] x-ms-publictraffictype: Email x-incomingheadercount: 43 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(20181119110)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031323274)(2017031324274)(2017031322404)(1601125500)(1603101475)(1701031045);SRVR:PU1APC01HT040; x-ms-traffictypediagnostic: PU1APC01HT040: x-ms-exchange-purlcount: 1 x-microsoft-antispam-message-info: vvSBoYGfTiHTR19PyP8fEf345iAuJS0lTsr7fjpPFYzrvcKuEazuko0qncHgkaagXGSBFRVv3jx+7jD2BZfGmyuc1Wbx+uPM/1vHjXsM2/7fD2qB2SpiHImQzzxVgzePhczYif27vnaUVPqa0nwgonVbA96z8D+A1ogU54M6jZrMEEmPjSW66HUFexeW3+g7 Content-Type: multipart/alternative; boundary="_000_MA1PR01MB354840F4AA7B39EEB5B5AD7EE0250MA1PR01MB3548INDP_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 1f4a0dc8-614b-4e7b-4d54-08d6c2f35850 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Apr 2019 05:12:53.2812 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: PU1APC01HT040 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_MA1PR01MB354840F4AA7B39EEB5B5AD7EE0250MA1PR01MB3548INDP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi , When use yum installed PostgreSQL 11.2 , missing X509_get_signature_nid sym= bol causes the standby to fail to start stream replication, the logs in the standby are as follows . Is this a bug with PostgreSQL 11.2 for streaming replication ? Is there an= y way out or any different release is there ? Please suggest . Postgres version : PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 201506= 23 (Red Hat 4.8.5-36), 64-bit Os version : Red Hat Enterprise Linux Server release 7.2 (Maipo) 2019-04-17 10:15:48.752 IST [15386] LOG: database system is ready to accep= t read only connections 2019-04-17 10:15:48.755 IST [15393] FATAL: could not load library "/usr/pg= sql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_= get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so= .10 with link time reference 2019-04-17 10:15:48.758 IST [15394] FATAL: could not load library "/usr/pg= sql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_= get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so= .10 with link time reference 2019-04-17 10:15:53.764 IST [15398] FATAL: could not load library "/usr/pg= sql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_= get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so= .10 with link time reference 2019-04-17 10:15:58.772 IST [15403] FATAL: could not load library "/usr/pg= sql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_= get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so= .10 with link time reference 2019-04-17 10:16:03.776 IST [15408] FATAL: could not load library "/usr/pg= sql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libpq.so.5: symbol X509_= get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so= .10 with link time reference Same issue reported in below mail chain as well . https://www.postgresql-archive.org/BUG-15576-Missing-X509-get-signature-nid= -symbol-causes-the-standby-to-fail-to-start-stream-replicatin-td6065301.htm= l#a6065751 Thanks, Soumitra --_000_MA1PR01MB354840F4AA7B39EEB5B5AD7EE0250MA1PR01MB3548INDP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi , 
= When use yum installed PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication, the logs in&= nbsp;
= the standby are as follows . 
=
Is this a bug with = ; PostgreSQL 11.2 for streaming replication ? Is there any way out or any different rel= ease is there ? Please suggest .  

Postgres version : = ;
 PostgreSQL = 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat = 4.8.5-36), 64-bit

Os version : 
Red Hat Enterprise Linu= x Server release 7.2 (Maipo)
=
= 2019-04-17 10:15:48.752 IST [15386] LOG:  database system = is ready to accept read only connections
2019-04-17 10:15:48.755 IST [15393] FATAL:  could not load librar= y "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libp= q.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined = in file libcrypto.so.10 with link time reference
2019-04-17 10:15:48.758 IST [15394] FATAL:  could not load librar= y "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libp= q.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined = in file libcrypto.so.10 with link time reference
2019-04-17 10:15:53.764 IST [15398] FATAL:  could not load librar= y "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libp= q.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined = in file libcrypto.so.10 with link time reference
2019-04-17 10:15:58.772 IST [15403] FATAL:  could not load librar= y "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libp= q.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined = in file libcrypto.so.10 with link time reference
2019-04-17 10:16:03.776 IST [15408] FATAL:  could not load librar= y "/usr/pgsql-11/lib/libpqwalreceiver.so": /usr/pgsql-11/lib/libp= q.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined = in file libcrypto.so.10 with link time reference

=
= Same issue reported in below mail chain as well . =
=
=
= Thanks, 
= Soumitra 
--_000_MA1PR01MB354840F4AA7B39EEB5B5AD7EE0250MA1PR01MB3548INDP_--