[Pljava-dev] Re: PL/Java example queries don't respond

Eric E wrote:
> Hi,
> Thanks for the previous help with LD_LIBRARY_PATH and LD_PRELOAD. I
> will post shortly on some tricks for making these changes when launching
> postgres from RedHat-style init scrips.
>
> I'm working with PL/JAVA on a postgres 7.4 instance on Suse 9.2 Pro.
> I've successfully installed pl-java, and when go to run the examples.jar
> file with:
> SELECT
> sqlj.install_jar('file:///usr/lib/postgresql/pljava/examples.jar',
> 'samples', true);
>
> the query runs indefinitely, and basically cannot be canceled, except
> via a SIGQUIT to postmaster.
>
> LD_LIBRARY_PATH is set to use java, and LD_PRELOAD points zlib at the
> version used by the JVM. From the log (see below), the JVM is
> initializing, but nothing further is happening.
>
> Any insight?
>
Can you please try the following:
1. Reconfigure and recompile your PostgreSQL installation:

./configure --enable-cassert --enable-debug
make

2. Recompile your PL/Java using make CFLAGS=-g (make clean first).

Start your app again. Once it hangs, attach gdb to the postgres process
that corresponds to your session, i.e.:

gdb <pid of process> <full path to postgres executable>

Once in gdb, print a stack backtrace and see where it's hung.

Regards,
Thomas Hallgren