BUG #15397: perl error

=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:

Hi Team we upgrade the perl version but still not able to create the perl
extension please find the below details.

[root@sydcosausd001 ~]# perl -v

This is perl 5, version 26, subversion 1 (v5.26.1) built for
x86_64-linux-thread-multi
(with 30 registered patches, see perl -V for more detail)

postgres=# CREATE EXTENSION plperl;
ERROR: could not load library
"/opt/app/PostgreSQL/10/lib/postgresql/plperl.so":
/opt/app/PostgreSQL/10/lib/postgresql/plperl.so: undefined symbol:
Perl_xs_handshake
postgres=#

Well, you've still got some kind of library version mismatch problem.

One thing that might help you figure out what's wrong is to try

ldd /opt/app/PostgreSQL/10/lib/postgresql/plperl.so

which will show you just which copy of libperl.so plperl is trying
to bind to. My guess is that it isn't the one you upgraded :-(.

If all else fails, you'll have to build your own copy of Postgres
to get one that matches the libraries you have installed. Or use
some other binary distribution of Postgres; the one you are trying
to use is evidently not a good match to your platform.

regards, tom lane

From nobody Wed Mar 25 10:26:39 2026
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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
id 1g4j1o-0007I0-Qi
for pgsql-bugs@arkaria.postgresql.org; Tue, 25 Sep 2018 08:49:08 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
by malur.postgresql.org with esmtp (Exim 4.89)
(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
id 1g4j1n-0001eS-7P
for pgsql-bugs@arkaria.postgresql.org; Tue, 25 Sep 2018 08:49:07 +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 <noreply@postgresql.org>)
id 1g4j1n-0001eL-1S
for pgsql-bugs@lists.postgresql.org; Tue, 25 Sep 2018 08:49:07 +0000
Received: from wrigleys.postgresql.org ([2620:122:b000:7::246])
by magus.postgresql.org with esmtp (Exim 4.89)
(envelope-from <noreply@postgresql.org>)
id 1g4j1k-0005c0-Vl
for pgsql-bugs@lists.postgresql.org; Tue, 25 Sep 2018 08:49:06 +0000
Content-Type: multipart/mixed; boundary="===============5987612192170932963=="
MIME-Version: 1.0
Subject: BUG #15398: invalid contrecord length 861 at 159E/A6FFFC40
To: pgsql-bugs@lists.postgresql.org
From: =?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org>
Cc: timur.luchkin@gmail.com
Reply-To: timur.luchkin@gmail.com, pgsql-bugs@lists.postgresql.org
Date: Tue, 25 Sep 2018 08:48:14 +0000
Message-ID: <15398-b4896eebf0bed218@postgresql.org>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/&gt;
List-Subscribe: <https://lists.postgresql.org/manage/&gt;
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs&gt;
Precedence: bulk

--===============5987612192170932963==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl
ZmVyZW5jZTogICAgICAxNTM5OApMb2dnZWQgYnk6ICAgICAgICAgIFRpbXVyIEx1Y2hraW4KRW1h
aWwgYWRkcmVzczogICAgICB0aW11ci5sdWNoa2luQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp
b246IDEwLjQKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTYuMDQuNCBMVFMKRGVzY3JpcHRp
b246ICAgICAgICAKCkhpLiANCldlIGFyZSBnZXR0aW5nIHRoaXMga2luZCBvZiBlcnJvciBpbiBX
QUwgYmFzZWQgcmVwbGljYSdzIGxvZyBhZnRlciB0aGUKbWFzdGVyIERCIHdhcyBkb3duIGR1ZSB0
byBubyBzcGFjZSBsZWZ0IGlzc3VlLiANCkRpc2sgc3BhY2Ugd2FzIGFscmVhZHkgYWRkZWQgYW5k
IG1hc3RlciB1cCduJ3J1bm5pbmcgKGluY2x1ZGluZyBpdHMKc3luY2hyb25vdXMgc3RyZWFtaW5n
IGJhc2VkIHJlcGxpY2EpLCBidXQgb2Zmc2l0ZSBXQUwgcmVwbGljYSBjYW4ndCBzdGFydApkdWUg
dG8gbWVudGlvbiBlcnJvci4gDQpXZSBjYW4ndCByZWNyZWF0ZSBpdCB1c2luZyBwZ19iYXNlYmFj
a3VwIGR1ZSB0byBzbG93IG5ldHdvcmsgYW5kIGh1Z2UgREIKc2l6ZS4gQ2FuIHdlIGZpeCB0aGlz
IHByb2JsZW0gdG8gY29udGludWUgdXNlIFdBTCBsb2dzPw0KDQpNb3JlIGRldGFpbHM6DQo8MjAx
OC0wOS0yNSAwODowNzoxOSBVVEMtLS0gW2FwcDoscGlkOjE5NTE3LDAwMDAwXT5MT0c6ICByZXN0
b3JlZCBsb2cgZmlsZQoiMDAwMDAwMDEwMDAwMTU5RTAwMDAwMEE2IiBmcm9tIGFyY2hpdmUNCjwy
MDE4LTA5LTI1IDA4OjA3OjIzIFVUQy0tLSBbYXBwOixwaWQ6MTk1MTcsMDAwMDBdPkxPRzogIHJl
c3RvcmVkIGxvZyBmaWxlCiIwMDAwMDAwMTAwMDAxNTlFMDAwMDAwQTciIGZyb20gYXJjaGl2ZQ0K
PDIwMTgtMDktMjUgMDg6MDc6MjMgVVRDLS0tIFthcHA6LHBpZDoxOTUxNywwMDAwMF0+TE9HOiAg
aW52YWxpZCBjb250cmVjb3JkCmxlbmd0aCA4NjEgYXQgMTU5RS9BNkZGRkM0MAoK

--===============5987612192170932963==--