From owner-freebsd-java@freebsd.org Fri Nov 16 07:14:27 2018 Return-Path: Delivered-To: freebsd-java@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 8311611298D2 for ; Fri, 16 Nov 2018 07:14:27 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from hermes.gatewaynet.com (hermes.gatewaynet.com [193.92.121.98]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 870AD744D1; Fri, 16 Nov 2018 07:14:26 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (pc131.internal.net [10.9.200.131]) by hermes.gatewaynet.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id wAG7EFim021609; Fri, 16 Nov 2018 09:14:20 +0200 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id wAG7EFiM050743; Fri, 16 Nov 2018 09:14:15 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: FreeBSD failed: /usr/local/openjdk8/jre/lib/amd64/server/libjvm.so: Undefined symbol "pthread_set_name_np" To: Jung-uk Kim , "freebsd-java@freebsd.org" References: <9af9d1eb-02fa-722c-1c59-64378f3827af@matrix.gatewaynet.com> <14d72ae2-0928-0361-bda8-498ea11bc059@FreeBSD.org> From: Achilleas Mantzios Message-ID: <381f456b-5c5e-1683-6832-2971afa892a0@matrix.gatewaynet.com> Date: Fri, 16 Nov 2018 09:14:15 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:60.0) Gecko/20100101 Thunderbird/60.0.1 MIME-Version: 1.0 In-Reply-To: <14d72ae2-0928-0361-bda8-498ea11bc059@FreeBSD.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-Virus-Scanned: clamav-milter 0.98.7 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=-28.5 required=5.0 tests=ALL_TRUSTED,DYN_HAM_COORD, DYN_HAM_IT,DYN_HAM_NAUTICAL,DYN_SPAM_SYMBOL autolearn=unavailable version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on hermes.gatewaynet.com X-Rspamd-Queue-Id: 870AD744D1 X-Spamd-Result: default: False [-3.05 / 40.00]; ARC_NA(0.00)[]; TO_DN_EQ_ADDR_SOME(0.00)[]; NEURAL_HAM_MEDIUM(-0.99)[-0.993,0]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; NEURAL_HAM_LONG(-0.99)[-0.995,0]; MIME_GOOD(-0.10)[text/plain]; DMARC_NA(0.00)[gatewaynet.com]; AUTH_NA(1.00)[]; RCVD_COUNT_THREE(0.00)[3]; IP_SCORE(-1.26)[ipnet: 193.92.0.0/17(-4.08), asn: 1241(-2.22), country: EU(-0.00)]; MX_GOOD(-0.01)[cached: hermes.gatewaynet.com]; RCPT_COUNT_TWO(0.00)[2]; RCVD_IN_DNSWL_NONE(0.00)[98.121.92.193.list.dnswl.org : 127.0.10.0]; NEURAL_HAM_SHORT(-0.70)[-0.695,0]; R_SPF_NA(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:1241, ipnet:193.92.0.0/17, country:EU]; MID_RHS_MATCH_FROM(0.00)[] X-Rspamd-Server: mx1.freebsd.org X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Nov 2018 07:14:27 -0000 On 16/11/18 1:07 π.μ., Jung-uk Kim wrote: > On 18. 11. 15., Achilleas Mantzios wrote: >> Dear members, >> >> I run FreeBSD 11.2-RELEASE-p3 with openjdk8-8.181.13 and I am trying to >> install pljava (java PL support for PostgreSQL,triggers), I have >> successfully built pljava, and installed it, but when I try to create >> the extension I get : >> >> [local] [448] 5bed6f0c.1c0 2018-11-15 15:10:36.784 EET psql >> postgres@dynacom line:15 WARNING: Java virtual machine not yet loaded >> >> [local] [448] 5bed6f0c.1c0 2018-11-15 15:10:36.784 EET psql >> postgres@dynacom line:16 DETAIL: dlopen >> (/usr/local/openjdk8/jre/lib/amd64/server/libjvm.so) failed: >> /usr/local/openjdk8/jre/lib/amd64/server/libjvm.so: Undefined symbol >> "pthread_set_name_np" >> >> [local] [448] 5bed6f0c.1c0 2018-11-15 15:10:36.784 EET psql >> postgres@dynacom line:17 HINT: SET pljava.libjvm_location TO the correct >> path to the jvm library (libjvm.so or jvm.dll, etc.) >> >> [local] [448] 5bed6f0c.1c0 2018-11-15 15:10:36.784 EET psql >> postgres@dynacom line:18 CONTEXT: PL/pgSQL function >> call_weeklycheck_before() line 6 at assignment >> >> [local] [448] 5bed6f0c.1c0 2018-11-15 15:10:36.784 EET psql >> postgres@dynacom line:19 ERROR: cannot use PL/Java before successfully >> completing its setup >> >> It used to work with openjdk7, by doing : >> >> postgres@smadev:~% ldd /usr/local/openjdk8/jre/lib/amd64/server/libjvm.so >> /usr/local/openjdk8/jre/lib/amd64/server/libjvm.so: >> libm.so.5 => /lib/libm.so.5 (0x801dd8000) >> libc++.so.1 => /usr/lib/libc++.so.1 (0x802005000) >> libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x8022d3000) >> libc.so.7 => /lib/libc.so.7 (0x800823000) >> libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x8024f2000) >> >> postgres@smadev:~% >> >> I see no linking to libthr, whereas if I ldd jdk7 I get : >> >> postgres@smadev:~% ldd >> /pgsqlbig/SMADEV_BACKUP/usr/local/openjdk7/jre/lib/amd64/server/libjvm.so >> /pgsqlbig/SMADEV_BACKUP/usr/local/openjdk7/jre/lib/amd64/server/libjvm.so: >> libm.so.5 => /lib/libm.so.5 (0x801d42000) >> libc++.so.1 => /usr/lib/libc++.so.1 (0x801f6f000) >> libcxxrt.so.1 => /lib/libcxxrt.so.1 (0x80223d000) >> libthr.so.3 => /lib/libthr.so.3 (0x80245c000) >> libc.so.7 => /lib/libc.so.7 (0x800823000) >> libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x802684000) >> postgres@smadev:~% >> And it indeed runs with jd7. >> However, jdk7 is no more on this machine, and also pljava was compiled >> with jdk8. Any ideas? > Please try the attached patch. Worked like a charm thanks, please commit this! > > Jung-uk Kim -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt