Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3HpI-00BQcw-ON for pgsql-hackers@arkaria.postgresql.org; Sat, 04 May 2024 16:01:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s3HpF-000j3E-Ve for pgsql-hackers@arkaria.postgresql.org; Sat, 04 May 2024 16:01:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3HpF-000j2B-0H for pgsql-hackers@lists.postgresql.org; Sat, 04 May 2024 16:01:26 +0000 Received: from mail-dm6nam10olkn2025.outbound.protection.outlook.com ([40.92.41.25] helo=NAM10-DM6-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s3HpC-001QUA-D1 for pgsql-hackers@postgresql.org; Sat, 04 May 2024 16:01:24 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=QTwM8cBtXiQq46cHPUomhcLE44Ek8tMR3+MKSA/ToYlVuzCqfKPUzeRYQG7nC8hSzlAzP3xeimdMnIZf3t+AkAlynCXaYjTvyOjKWk0amH35dINT7sXQV6ew5jhKLG0M3BG1743srFs1VQOchPBci6PbzW9gPZuLdK26Pq6tuSfzYWp4bMiuA/I1CzA+7h1qlp3VgtxWEQNOs6PwJesgq+9UXVGJItNcS2ljdyuXIzWIXRBgFVR5P5zHrN1Ji39HCW05rAz8dz9LiShUHuRBgnsCBWpS3QNxegrAUdQpIjHvj0sWOEOKLGq3hjzVEm5OnPSsVJQsoDTSoNhvkGJZ4Q== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=QEDgBTq4WaecQXIWlyhiZVJlz3JqIrAxLzV7DnIoOAk=; b=PMgyCW08sRLzlDr1r0lMVYfwy1ktbhImBvCLBP2Ak3PDz39uSwhVJOoCVNsyq67x6gjOfDitTXfjiMC+KnCqtxVPI5047CY44do5RKtEXPsYOO7MGIGJ9khRTT5UxDO+fda1iV3xFPlQUA4jNyO6ukpi3QCpYljO27f/b0VoHTGk5O3K06hEchqS6zzwNNHYFaUOrlumM/cOql24ZmqJy1d1uYEVK5Fz7FxqiupRSodXl9VRPeDUrOQCmP2/4PfEbiOVZ7hHfJzX4JRmhy5H1WLRC4jGu/SYratVQ1fVxoGe2bSWVeqH7baohq995hRcp1bGYjFTzYuwEsbeHu/T8w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=QEDgBTq4WaecQXIWlyhiZVJlz3JqIrAxLzV7DnIoOAk=; b=Yj+6pc+O4orJjuXg1S981Aa5DZrbnK6qJChDih0+4QxylGUkymfQtFVAHUroWs5FbQiTZUFrkiSAQoNRk9qBKEpLLoXuPGCUmp/cRnBBV+lV3onb/mkt2QuKR5aJ1MwUm72qcQHMw1TCg2CcaMDvbl7UhpmsfRVSy7Y7t4CsFcMJJRRZIAVEE27auOU4c0k7svrc43o09b4Fg6wFk1L/YWCHTaCVmISPCa7Ax1CuVW4ot0tblGVpmkiTukDPiApXya5pLvTYjstw9tO+xhPRnHnZvxMeD4l6ZeLKQt2AT5ziYhOLLqGM+f4xheoSHjIkg0c1wo+D+QcVZGWcm6Qjjg== Received: from CY5PR11MB6392.namprd11.prod.outlook.com (2603:10b6:930:37::15) by MW6PR11MB8339.namprd11.prod.outlook.com (2603:10b6:303:24b::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7544.25; Sat, 4 May 2024 16:01:18 +0000 Received: from CY5PR11MB6392.namprd11.prod.outlook.com ([fe80::9cd9:1cf0:dc54:3790]) by CY5PR11MB6392.namprd11.prod.outlook.com ([fe80::9cd9:1cf0:dc54:3790%3]) with mapi id 15.20.7544.036; Sat, 4 May 2024 16:01:18 +0000 From: Sriram RK To: Michael Paquier , Tom Lane , Noah Misch CC: Bruce Momjian , Peter Eisentraut , Andres Freund , Thomas Munro , Alvaro Herrera , "pgsql-hackers@postgresql.org" , "tvk1271@gmail.com" , Heikki Linnakangas Subject: Re: AIX support Thread-Topic: AIX support Thread-Index: AQHae4rr5/ageaPz8EuxaB+VNKiBu7FCOGKAgAArgSaACn9l2IABLM4AgAADTgCAAAP8gIAABU6AgAvJNWiAAB/ogIATySEqgACu3ACAARripYAB4tSAgAAMOICABwWYgIAAB3wAgAAD0oCAAAcGgIACYnHWgAxC+/4= Date: Sat, 4 May 2024 16:01:06 +0000 Message-ID: References: <20240405172649.d1@rfd.leadboat.com> <20240418180128.uzzgx4r6ujgrz2eo@awork3.anarazel.de> <6cc5001e-3001-438a-85fd-3bd2d9c2d8e4@eisentraut.org> <2476719.1713630347@sss.pgh.pa.us> <3829420.1714018805@sss.pgh.pa.us> In-Reply-To: Accept-Language: en-US Content-Language: en-IN X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [ehDAquRODt3iP2kaEXSSVNIUuxYJshAyg16OTEApiYaY9sVCDHXInPniTrBt3fAl] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CY5PR11MB6392:EE_|MW6PR11MB8339:EE_ x-ms-office365-filtering-correlation-id: d21473a3-d732-4c5d-38bc-08dc6c536f24 x-microsoft-antispam: BCL:0;ARA:14566002|461199019|9400799015|1602099003|102099023|440099019|3412199016; x-microsoft-antispam-message-info: b7JfYww7Vx7GUhzKpe2f8g49RREQPwUwf8mM/sLr3esmFiijlERxGugnM0j1OQicOASxJMxHDCvqSSQKX4EkwdlSdMtd3UfXbjIFyKuB1AHGEtp/TsfWOrQ+xBloUU3TCdzPgbxFOP0W+x93FAs6evsBuc5ACkiEOyC9+Zj12KwhYi+nezJKE45+NFYyCfrMaTBvFWGJYSn1cCHx63DDS+i2iZSJgrVLqlRPLVHYlwB4TEKEveMYElSteXbJqCgHNiHLP2OlOEUSyOAg3dKO7ZWCTKP4xDNWWQ8FIeO6coXenwx1zLTE+bH7yBDUxHFDIaAv4OET+pplA6I35mFAS1YclKELhzaMHVV0lhYV8/Sz5W99L9OJjyveaZGlSnS9xjik88x8WLFZVbIgPDxqdHDnTkC9tZQQE6abnY//tUO2C3lWUhONpcSI231vN720OMgDU8bo/+/h7azFJmV/r/C6dAUKqFSKIL6A/68j54Hc5cCxXU/TYPUMEV6aHuKQPUTRpGQvlGViu6BqfO0mYsRJ2fvkAk+LGXMPKob69C9wm5tySL+wa/1mOGCMd7ht/0KQl+ISzV6NP7FpUi24WN3mcIgQa3PhIVrC2Zc0gAh0DGhwyLUIJ/HRggRznYYii3EhDpyZAlCQ5ceNcPPdJDJeoB/ogL1qdHKfGKpYOe6lDeObBKPH5YcZ6PBROyWZ x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?twzhOjmL5cmQZG3UztXDui6yfLazS3bJqpMEAdJGJEaYJlHzalahteiY?= =?Windows-1252?Q?gXO6y2pVBsprsBCypFdt8AxajrhM+1WvXA0Up6YvSVM/siIgSki6M4xv?= =?Windows-1252?Q?iy6tIdAsI8gFdQ33isFcscY/jDj05VY34lQ1QZo8adUIkF8bDM8P3dtp?= =?Windows-1252?Q?qwwTOWmSnS8jE6KsfH2mL3xo2SpdHLBMywKrI3qVwRTNW3ElzHcjRcF6?= =?Windows-1252?Q?0DolHOaQDlkJgyoeuZs9UkcHOyedd7FByHP+2DjeLek2GftOBMaSxP6H?= =?Windows-1252?Q?FAo+lfXqOQDMeUtj9YKtP31A2JpbV++7Vfaf5nAyqtTY16YJQKYo99Jc?= =?Windows-1252?Q?92jlscKcpJUbp+Edm8cnM2FeZruxRY5XmGoAjhEoq5CL+EpSwsV23iUK?= =?Windows-1252?Q?g2N7fxDOeHKuBEgHVKV6JdYKv0T1BmXEQ1K1RSUP3g/GKtSPQqsb/j4K?= =?Windows-1252?Q?4Y/Dm3ASXnVB+NR4dzq6Q9lUih/lkD9V8gb/G5/IYid3n1/W4vRK+g15?= =?Windows-1252?Q?90BWZY7GGIhIx4SfKKxX0b1KkeAb3vfTv59MncKRj5QDVNdVrCmAAkf/?= =?Windows-1252?Q?Khn6wqd7/Oh1nxi1S1txXVV+JKqWnhjunHMlXdd3Vg9Wp1PlHx9Hysuo?= =?Windows-1252?Q?MKLLdMb4Rcbs302ECkkQBqnHeYJCyIfsncfJ1gpHw5HgiFCa7hHcrkZf?= =?Windows-1252?Q?SvOwUobT1l5OXtljWztZWq5jXt5Acp9zTUq4EqHQAEqY71D5OZO3IyRT?= =?Windows-1252?Q?ACWM2y0kX/wkrMY4o93n7cAeTB4p9ui9YinNWylzHU59bbLdrKKPkXnB?= =?Windows-1252?Q?I4UZKZEwp+3x9Bpsqt7hiLBMdoUx0z6Gh2zvyppMrG4araapg21Wfamu?= =?Windows-1252?Q?QvwYRgThpu85SSI6zG4DKKYTrgT9CVZd3YzfhRwByde0rEULfl2+ZJ3r?= =?Windows-1252?Q?Z28Fe6ByKU2KVTnjIPF9Ra9yChdAGVDt7ahXsjxUivyz2pdPQsTv17D1?= =?Windows-1252?Q?CeDb0QIE6pXV2AJHNF1IzASrWO8ubTowUIjk77O8SaNfPBy9Kz5VpBd4?= =?Windows-1252?Q?oG8fKtcV0QxQmpY4OlDbDSoiQ6vNPQIU41MSZTqdc0+NtyeyLKRuhmeJ?= =?Windows-1252?Q?q/FcR9a6oOPawclaf7yGg7wrme8u4K+C5d2C6uS9lmJoxoENd7OAxy9N?= =?Windows-1252?Q?2J/OFMLFYzGDkFsUsn4Lj2i2MeWXRdLgp3GHU2zsSpRZEaEkJF/zWZDv?= =?Windows-1252?Q?u+RZ3/eYgiNZ++mE1cCWnodTdBffgr79QQIzGc0P4U7nqyKYazf7ito9?= =?Windows-1252?Q?qDkd5EKCFSau36liku9jaR1D3fVfIWmj8LKJ5Q025vrU0ZwuWNGR5EvH?= =?Windows-1252?Q?/BBGLAL94yhBkerR1P2Ln2g9G3C3wYuTNLo=3D?= Content-Type: multipart/alternative; boundary="_000_CY5PR11MB63922C5C46FA708A39C4DC9AFD1E2CY5PR11MB6392namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CY5PR11MB6392.namprd11.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: d21473a3-d732-4c5d-38bc-08dc6c536f24 X-MS-Exchange-CrossTenant-originalarrivaltime: 04 May 2024 16:01:18.1906 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW6PR11MB8339 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_CY5PR11MB63922C5C46FA708A39C4DC9AFD1E2CY5PR11MB6392namp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi Team, There are couple of updates, firstly we got an AIX node on the OSU lab. Please feel free to reach me, so that we can provide access to the node. We have started working on setting up the buildfarm on that node. Secondly, as part of the buildfarm setup on our local nodes, we are hitting an issue with the plperl extension. In the logs we noticed that when the plperl extension is being created, it is failing to load the perl library. - CREATE EXTENSION plperlu; + server closed the connection unexpectedly + This probably means the server terminated abnormally + before or while processing the request. + connection to server was lost In the logfile we could see these 2024-05-04 05:05:17.537 CDT [3997786:17] pg_regress/plperl_setup LOG: = statement: CREATE EXTENSION plperl; Util.c: loadable library and perl binaries are mismatched (got first ha= ndshake key 9b80080, needed 9a80080) We tried to resolve some of the suggestions mentioned here, but things coul= dn=92t resolve. https://www.postgresql.org/message-id/CALDaNm15qaRFb3WiPFAdFqoB9pj1E5SCPPUG= B%2BnJ4iF4gXO6Rw%40mail.gmail.com Any inputs here would be greatly appreciated. Regards, Sriram. --_000_CY5PR11MB63922C5C46FA708A39C4DC9AFD1E2CY5PR11MB6392namp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Hi T= eam,

 

Ther= e are couple of updates, firstly we got an AIX node on the OSU lab.

Plea= se feel free to reach me, so that we can provide access to the node.

We h= ave started working on setting up the buildfarm on that node.

 

Seco= ndly, as part of the buildfarm setup on our local nodes, we are hitting

an i= ssue with the plperl extension. In the logs we noticed that when the

plpe= rl extension is being created, it is failing to load the perl library.=

 

 

    - CREATE EXTENSION plper= lu;

    + server closed the conn= ection unexpectedly

    +    = ;   This probably means the server terminated abnormally

    +    = ;   before or while processing the request.

    + connection to server w= as lost

 

In t= he logfile we could see these

 

    2024-05-04 05:05:17.537 = CDT [3997786:17] pg_regress/plperl_setup LOG:  statement: CREATE EXTEN= SION plperl;

    Util.c: loadable library= and perl binaries are mismatched (got first handshake key 9b80080, needed = 9a80080)

 

We t= ried to resolve some of the suggestions mentioned here, but things couldn= =92t resolve.

 

https://www.postgresql.org/messag= e-id/CALDaNm15qaRFb3WiPFAdFqoB9pj1E5SCPPUGB%2BnJ4iF4gXO6Rw%40mail.gmail.com=

 

Any = inputs here would be greatly appreciated.

 

Rega= rds,

Srir= am.

--_000_CY5PR11MB63922C5C46FA708A39C4DC9AFD1E2CY5PR11MB6392namp_--