From: thhal at mailblocks.com (Thomas Hallgren)
Date: Wed, 08 Jun 2005 08:44:56 +0200
Subject: [Pljava-dev] Re: PL/Java example queries don't respond
In-Reply-To: <429F4535.90803@bonbon.net>
References: <429F4535.90803@bonbon.net>
Message-ID: <42A693E8.7080409@mailblocks.com>

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