PL/Java installation failed: Undefined symbol "pthread_create"

[Bahman Movaqar]

On 2007-12-16 Bahman Movaqar wrote:

> 
> Hi all,
> 
> I've ran into problems installing PL/Java on FreeBSD.  Below are the
> software configurations I use:
> $ uname -a 
> FreeBSD movaqar 6.2-RELEASE FreeBSD 6.2-RELEASE #0: Fri Jan 12
> 11:05:30 UTC 2007
> root at dessler.cse.buffalo.edu:/usr/obj/usr/src/sys/SMP  i386
> 
> $ psql --version
> psql (PostgreSQL) 8.2.5
> contains support for command-line editing
> 
> $ java -version
> java version "1.5.0_13-p7"
> Java(TM) 2 Runtime Environment, Standard Edition (build
> 1.5.0_13-p7-root_12_dec_2007_15_19) Java HotSpot(TM) Client VM (build
> 1.5.0_13-p7-root_12_dec_2007_15_19, mixed mode)
> 
> $ cat /etc/rc.conf | grep ldconfig
> ldconfig_paths="/usr/lib/compat /usr/X11R6/lib /usr/local/lib /usr/local/lib/compat/pkg /usr/local/jdk1.5.0/jre/lib/i386 /usr/local/jdk1.5.0/jre/lib/i386/client /usr/local/jdk1.5.0/jre/lib/i386/native_threads"
> 
> I have also Diablo-JDK-1.5.0_07 installed.
> 
> PL/Java sources compile fine without any warnings; then I change
> 'postgresql.conf' to add the 'pljava' section.  No problems yet.
> But when I run the deployer (JAR or SQL) program to install it into
> the database, this is what I get:
> 
> psql:/usr/local/pljava/install.sql:6: ERROR:  could not load library
> "/usr/local/pljava/lib/pljava.so": dlopen
> (/usr/local/pljava/lib/pljava.so)
> failed: /usr/local/jdk1.5.0/jre/lib/i386/client/libjvm.so: Undefined
> symbol "pthread_create" psql:/usr/local/pljava/install.sql:8: ERROR:
> function sqlj.java_call_handler() does not exist
> psql:/usr/local/pljava/install.sql:12: ERROR:  could not load library
> "/usr/local/pljava/lib/pljava.so": dlopen
> (/usr/local/pljava/lib/pljava.so)
> failed: /usr/local/jdk1.5.0/jre/lib/i386/client/libjvm.so: Undefined
> symbol "pthread_create" psql:/usr/local/pljava/install.sql:14: ERROR:
> function sqlj.javau_call_handler() does not exist
> 
> BTW, I have done PL/Java installation on PG 8.2.4 before without any
> problems.  Could the version of PG be the source of the trouble?
> 
> Any idea/hint is highly appreciated.
> 
> TIA,
> 
Solved by mapping libpthread to libthr in libmap.conf.

-- 
Bahman Movaqar
PGP KeyID: 0x0CE28F5C (keyserver2.pgp.com)

Whenever there are great virtues, it's a sure sign something's wrong.
-Bertolt Brecht
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-java/attachments/20071216/3e30a704/signature.pgp