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

Eric E whalesuit at bonbon.net
Thu Jun 2 17:43:17 UTC 2005 

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?

Thanks,

Eric




limsdev:~ # tail -f -n250 /var/log/postgresql
2005-06-02 13:26:17 DEBUG:      
LD_LIBRARY_PATH=/usr/lib/jvm/java/jre/lib/i386:/usr/lib/jvm/java/jre/lib/i386/client
2005-06-02 13:26:17 DEBUG:      XNLSPATH=/usr/X11R6/lib/X11/nls
2005-06-02 13:26:17 DEBUG:      HOSTTYPE=i386
2005-06-02 13:26:17 DEBUG:      PAGER=less
2005-06-02 13:26:17 DEBUG:      MINICOM=-c on
2005-06-02 13:26:17 DEBUG:      
PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin
2005-06-02 13:26:17 DEBUG:      CPU=i686
2005-06-02 13:26:17 DEBUG:      JAVA_BINDIR=/usr/lib/jvm/java/bin
2005-06-02 13:26:17 DEBUG:      PWD=/var/lib/pgsql
2005-06-02 13:26:17 DEBUG:      INPUTRC=/etc/inputrc
2005-06-02 13:26:17 DEBUG:      JAVA_HOME=/usr/lib/jvm/java
2005-06-02 13:26:17 DEBUG:      LANG=en_US.UTF-8
2005-06-02 13:26:17 DEBUG:      PYTHONSTARTUP=/etc/pythonstart
2005-06-02 13:26:17 DEBUG:      SDK_HOME=/usr/lib/jvm/java
2005-06-02 13:26:17 DEBUG:      
TEXINPUTS=:/var/lib/pgsql/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
2005-06-02 13:26:17 DEBUG:      HOME=/var/lib/pgsql
2005-06-02 13:26:17 DEBUG:      SHLVL=2
2005-06-02 13:26:17 DEBUG:      JDK_HOME=/usr/lib/jvm/java
2005-06-02 13:26:17 DEBUG:      OSTYPE=linux
2005-06-02 13:26:17 DEBUG:      LESS_ADVANCED_PREPROCESSOR=no
2005-06-02 13:26:17 DEBUG:      LS_OPTIONS=-N --color=tty -T 0
2005-06-02 13:26:17 DEBUG:      WINDOWMANAGER=/usr/X11R6/bin/kde
2005-06-02 13:26:17 DEBUG:      LOGNAME=postgres
2005-06-02 13:26:17 DEBUG:      MACHTYPE=i686-suse-linux
2005-06-02 13:26:17 DEBUG:      LESS=-M -I
2005-06-02 13:26:17 DEBUG:      ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal
2005-06-02 13:26:17 DEBUG:      
CLASSPATH=/usr/lib/postgresql/pljava/pljava.jar
2005-06-02 13:26:17 DEBUG:      LESSOPEN=lessopen.sh %s
2005-06-02 13:26:17 DEBUG:      PKG_CONFIG_PATH=/opt/gnome/lib/pkgconfig
2005-06-02 13:26:17 DEBUG:      PGDATA=/var/lib/pgsql/data
2005-06-02 13:26:17 DEBUG:      
INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
2005-06-02 13:26:17 DEBUG:      LESSCLOSE=lessclose.sh %s %s
2005-06-02 13:26:17 DEBUG:      COLORTERM=1
2005-06-02 13:26:17 DEBUG:      JAVA_ROOT=/usr/lib/jvm/java
2005-06-02 13:26:17 DEBUG:      _=/usr/bin/postmaster
2005-06-02 13:26:17 DEBUG:  -----------------------------------------
2005-06-02 13:26:17 DEBUG:  found "/usr/bin/postgres" using argv[0]
2005-06-02 13:26:17 DEBUG:  invoking IpcMemoryCreate(size=10436608)
2005-06-02 13:26:17 DEBUG:  max_safe_fds = 984, usable_fds = 1018, 
already_open = 6
2005-06-02 13:26:17 DEBUG:  found "/usr/bin/postmaster" using argv[0]
2005-06-02 13:26:17 LOG:  database system was interrupted at 2005-06-02 
13:22:18 EDT
2005-06-02 13:26:17 LOG:  checkpoint record is at 0/FC605C
2005-06-02 13:26:17 LOG:  redo record is at 0/FC605C; undo record is at 
0/0; shutdown TRUE
2005-06-02 13:26:17 LOG:  next transaction ID: 1571; next OID: 35694
2005-06-02 13:26:17 LOG:  database system was not properly shut down; 
automatic recovery in progress
2005-06-02 13:26:17 FATAL:  the database system is starting up
2005-06-02 13:26:17 DEBUG:  proc_exit(0)
2005-06-02 13:26:17 DEBUG:  shmem_exit(0)
2005-06-02 13:26:17 DEBUG:  exit(0)
2005-06-02 13:26:17 DEBUG:  forked new backend, pid=18284 socket=9
2005-06-02 13:26:17 DEBUG:  reaping dead processes
2005-06-02 13:26:17 DEBUG:  child process (PID 18284) exited with exit 
code 0
2005-06-02 13:26:17 LOG:  record with zero length at 0/FC609C
2005-06-02 13:26:17 LOG:  redo is not required
2005-06-02 13:26:18 FATAL:  the database system is starting up
2005-06-02 13:26:18 DEBUG:  proc_exit(0)
2005-06-02 13:26:18 DEBUG:  shmem_exit(0)
2005-06-02 13:26:18 DEBUG:  exit(0)
2005-06-02 13:26:18 DEBUG:  forked new backend, pid=18288 socket=9
2005-06-02 13:26:18 DEBUG:  reaping dead processes
2005-06-02 13:26:18 DEBUG:  child process (PID 18288) exited with exit 
code 0
2005-06-02 13:26:19 FATAL:  the database system is starting up
2005-06-02 13:26:19 DEBUG:  proc_exit(0)
2005-06-02 13:26:19 DEBUG:  shmem_exit(0)
2005-06-02 13:26:19 DEBUG:  exit(0)
2005-06-02 13:26:19 DEBUG:  forked new backend, pid=18292 socket=9
2005-06-02 13:26:19 DEBUG:  reaping dead processes
2005-06-02 13:26:19 DEBUG:  child process (PID 18292) exited with exit 
code 0
2005-06-02 13:26:19 LOG:  database system is ready
2005-06-02 13:26:19 DEBUG:  proc_exit(0)
2005-06-02 13:26:19 DEBUG:  shmem_exit(0)
2005-06-02 13:26:19 DEBUG:  exit(0)
2005-06-02 13:26:19 DEBUG:  reaping dead processes
2005-06-02 13:26:20 DEBUG:  forked new backend, pid=18296 socket=9
2005-06-02 13:26:20 DEBUG:  /usr/bin/postmaster child[18296]: starting 
with (
2005-06-02 13:26:20 DEBUG:      postgres
2005-06-02 13:26:20 DEBUG:      -v196608
2005-06-02 13:26:20 DEBUG:      -p
2005-06-02 13:26:20 DEBUG:      template1
2005-06-02 13:26:20 DEBUG:  )
2005-06-02 13:26:20 DEBUG:  InitPostgres
2005-06-02 13:26:20 DEBUG:  StartTransactionCommand
2005-06-02 13:26:20 DEBUG:  PortalRun
2005-06-02 13:26:20 DEBUG:  CommitTransactionCommand
2005-06-02 13:26:20 DEBUG:  proc_exit(0)
2005-06-02 13:26:20 DEBUG:  shmem_exit(0)
2005-06-02 13:26:20 DEBUG:  exit(0)
2005-06-02 13:26:20 DEBUG:  reaping dead processes
2005-06-02 13:26:20 DEBUG:  child process (PID 18296) exited with exit 
code 0
2005-06-02 13:27:00 DEBUG:  forked new backend, pid=18297 socket=9
2005-06-02 13:27:00 DEBUG:  received password packet
2005-06-02 13:27:00 DEBUG:  /usr/bin/postmaster child[18297]: starting 
with (
2005-06-02 13:27:00 DEBUG:      postgres
2005-06-02 13:27:00 DEBUG:      -v196608
2005-06-02 13:27:00 DEBUG:      -p
2005-06-02 13:27:00 DEBUG:      template1
2005-06-02 13:27:00 DEBUG:  )
2005-06-02 13:27:00 DEBUG:  InitPostgres
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  ProcessUtility
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  forked new backend, pid=18298 socket=9
2005-06-02 13:27:00 DEBUG:  received password packet
2005-06-02 13:27:00 DEBUG:  /usr/bin/postmaster child[18298]: starting 
with (
2005-06-02 13:27:00 DEBUG:      postgres
2005-06-02 13:27:00 DEBUG:      -v196608
2005-06-02 13:27:00 DEBUG:      -p
2005-06-02 13:27:00 DEBUG:      limsdev
2005-06-02 13:27:00 DEBUG:  )
2005-06-02 13:27:00 DEBUG:  InitPostgres
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  ProcessUtility
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  ProcessUtility
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:00 DEBUG:  StartTransactionCommand
2005-06-02 13:27:00 DEBUG:  PortalRun
2005-06-02 13:27:00 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:02 DEBUG:  forked new backend, pid=18299 socket=9
2005-06-02 13:27:02 DEBUG:  received password packet
2005-06-02 13:27:02 DEBUG:  /usr/bin/postmaster child[18299]: starting 
with (
2005-06-02 13:27:02 DEBUG:      postgres
2005-06-02 13:27:02 DEBUG:      -v196608
2005-06-02 13:27:02 DEBUG:      -p
2005-06-02 13:27:02 DEBUG:      limsdev
2005-06-02 13:27:02 DEBUG:  )
2005-06-02 13:27:02 DEBUG:  InitPostgres
2005-06-02 13:27:02 DEBUG:  StartTransactionCommand
2005-06-02 13:27:02 DEBUG:  PortalRun
2005-06-02 13:27:02 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:02 DEBUG:  StartTransactionCommand
2005-06-02 13:27:02 DEBUG:  ProcessUtility
2005-06-02 13:27:02 DEBUG:  CommitTransactionCommand
2005-06-02 13:27:23 DEBUG:  StartTransactionCommand
2005-06-02 13:27:23 DEBUG:  PortalRun
2005-06-02 13:27:23 DEBUG:  find_in_dynamic_libpath: trying 
"/usr/lib/postgresql/libpljava"
2005-06-02 13:27:23 DEBUG:  find_in_dynamic_libpath: trying 
"/usr/lib/postgresql/libpljava.so"
2005-06-02 13:27:23 DEBUG:  Using integer_datetimes
2005-06-02 13:27:23 DEBUG:  Added JVM option string 
"-Djava.class.path=/usr/lib/postgresql/pljava/pljava.jar"
2005-06-02 13:27:23 DEBUG:  Added JVM option string 
"-Dsqlj.defaultconnection=jdbc:default:connection"
2005-06-02 13:27:23 DEBUG:  Added JVM option string "vfprintf"
2005-06-02 13:27:23 DEBUG:  Creating JavaVM

More information about the Pljava-dev mailing list