From: whalesuit at bonbon.net (Eric E) Date: Thu, 02 Jun 2005 13:43:17 -0400 Subject: [Pljava-dev] PL/Java example queries don't respond Message-ID: <429F4535.90803@bonbon.net> 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