FreeBSD pl/java problem : backend hangs : Solved

[Achilleas Mantzios]

Thank you Konstantin.

After much playing around finally i experimented putting in /usr/local/src/postgresql-9.2.2/src/backend/Makefile :
postgres: $(OBJS)
        $(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_EX) $(export_dynamic) $(call expand_subsys,$^) $(LIBS) -lpthread -o $@
i.e. explicitly linking the postgres backend to /usr/lib/libpthread.so which is a symlink to /usr/lib/libthr.so which is a symlink to /lib/libthr.so.3 ,
did the trick.
root at smadev:/usr/local/src/postgresql-9.2.2# ldd /usr/local/pgsql/bin/postgres
/usr/local/pgsql/bin/postgres:
        libm.so.5 => /lib/libm.so.5 (0x800ae5000)
        libldap-2.4.so.8 => /usr/local/lib/libldap-2.4.so.8 (0x800c05000)
        libthr.so.3 => /lib/libthr.so.3 (0x800d47000)
        libc.so.7 => /lib/libc.so.7 (0x800e60000)
        liblber-2.4.so.8 => /usr/local/lib/liblber-2.4.so.8 (0x8010a2000)
        libssl.so.6 => /usr/lib/libssl.so.6 (0x8011af000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x801302000)

I had the first good results from pl/java :)

On Τρι 05 Φεβ 2013 10:38:18 Achilleas Mantzios wrote:
> On ΔεÏÂ
 04 Φεβ 2013 19:18:59 you wrote:
> 
> > Try to start the postgres daemon with 'LD_PRELOAD=/lib/libthr.so.3'
> > env variable set.
> 
> Thanx, i tried with this, inside postgresql startup script with no luck.
> I also saw this thread here : http://www.postgresql.org/message-id/68c429ede4cde3874b37460b5b1d4aaf@cs.helsinki.fi
> (but could not find its continuation over the FreeBSD camp)
> The author claims that postgres backend executable must be linked with -lpthread.
> Inside postgres's Makefile.global i can see 
> PTHREAD_CFLAGS         =  -pthread  -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS
> THREAD_LIBS           =  -lpthread
> however when i do 
> 
> root at smadev:/usr/local/src/postgresql-9.2.2# ldd /usr/local/pgsql/bin/postgres
> /usr/local/pgsql/bin/postgres:
>         libm.so.5 => /lib/libm.so.5 (0x800ae5000)
>         libldap-2.4.so.8 => /usr/local/lib/libldap-2.4.so.8 (0x800c05000)
>         libc.so.7 => /lib/libc.so.7 (0x800d47000)
>         liblber-2.4.so.8 => /usr/local/lib/liblber-2.4.so.8 (0x800f89000)
>         libssl.so.6 => /usr/lib/libssl.so.6 (0x801096000)
>         libcrypto.so.6 => /lib/libcrypto.so.6 (0x8011e9000)
> 
> i see nothing thread (libpthread or libtrh) related.
> 
> Any help to overcome this much appreciated.
> 
> > 
> > > 
> 
> -
> Achilleas Mantzios
> IT DEV
> IT DEPT
> Dynacom Tankers Mgmt
> _______________________________________________
> freebsd-java at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-java
> To unsubscribe, send any mail to "freebsd-java-unsubscribe at freebsd.org"
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt