[HACKERS] pl/perl extension fails on Windows - Mailing list pgsql-hackers

From Sandeep Thakkar
Subject [HACKERS] pl/perl extension fails on Windows
Date
Msg-id CANFyU97OVQ3+Mzfmt3MhuUm5NwPU=-FtbNH5Eb7nZL9ua8=rcA@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] pl/perl extension fails on Windows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

I compiled PG 10 beta1/beta2 with "--with-perl" option on Windows and the extension crashes the database.
--
postgres=# create extension plperl;
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: Succeeded.
postgres=#

It doesn't produce crashdump (in $DATA/crashdumps) but the log contains the following error:

src/pl/plperl/Util.c: loadable library and perl binaries are mismatched (got handshake key 0A900080, needed 0AC80080)
--

This is seen with Perl 5.24 but not with 5.20, 5.16. What I found is that the handshake function is added in Perl 5.21.x and probably that is why we don't see this issue in earlier versions.

The Perl that is used during compilation and on the target machine is same. So probably plperl is not able to load the perl library. It works fine on Linux and MacOS.

--
Sandeep Thakkar
EDB


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors
Next
From: Mark Rofail
Date:
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays