agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

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

view thread (3+ messages)  latest in thread

Message-ID: <42A693E8.7080409@mailblocks.com>
Permalink:  ../42A693E8.7080409@mailblocks.com/
Also on:    postgresql.org/message-id/42A693E8.7080409@mailblocks.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Re: PL/Java example queries don't respond
  In-Reply-To: <42A693E8.7080409@mailblocks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox