From: kkourkounis at gmail.com (Kourkounis Kostas)
Date: Sun, 05 Nov 2006 19:35:32 +0200
Subject: [Pljava-dev] pljava crashes postgre server when install_jar
	executes in freebsd
Message-ID: <1162748132.42739.4.camel@kkourkou>

Environment: 
        FREEBSD 6.1 i386, java 1.5.07, postgresql 8.1.5, pljava 1.3.0 
        
Some how i can not instanciate a JAVA VM. I donot know why.The paths are
ok and also the config file postgresql.conf and the pg_hba.conf. This is
the case because the pljava is instaled. The only difference that I can
see with other distributions is that the pljava is not instaled in a
seperate dir but the jars and the .so is copied to postgres/lib the path
that postgres is installed. In config files I have all the required
libraries and the LD_LIBRARY_PATH has everything including
JRE_HOME/lib/i386 and JRE_HOME/lib/i386/client.

Also i tried building postgres with and without zlib, the same. In the
LD_LIBRARY_PATH i have also the path /jre/lib/i386/native_threads
nothing also.

Do I have to add this paths to the PATH variable also?

One hint is that when i build the pljava it couldnt find symbol pthread
in linking I solved that by adding in makefile -lpthread.

        
Everything works ok until i come to the point where i execute 
SELECT sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);. Then the server crashes with the following:
DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR,
xid/subid/cid: 5139/1/0, nestlvl: 1, children: <>
LOCATION: ShowTransactionStateRec, xact.c:3955
DEBUG: 00000: CommitTransaction
LOCATION: ShowTransactionState, xact.c:3930
DEBUG: 00000: name: unnamed; blockState: STARTED; state: INPROGR,
xid/subid/cid: 5139/1/0, nestlvl: 1, children: <>
LOCATION: ShowTransactionStateRec, xact.c:3955
DEBUG: 00000: StartTransactionCommand
LOCATION: start_xact_command, postgres.c:1996
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: StartTransaction
LOCATION: ShowTransactionState, xact.c:3930
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR,
xid/subid/cid: 5140/1/0, nestlvl: 1, children: <>
LOCATION: ShowTransactionStateRec, xact.c:3955
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: find_in_dynamic_libpath: trying
"/usr/local/pgsql/lib/pljava"
LOCATION: find_in_dynamic_libpath, dfmgr.c:424
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: find_in_dynamic_libpath: trying
"/usr/local/pgsql/lib/pljava"
LOCATION: find_in_dynamic_libpath, dfmgr.c:424
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: find_in_dynamic_libpath: trying
"/usr/local/pgsql/lib/pljava.so"
LOCATION: find_in_dynamic_libpath, dfmgr.c:424
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Not using integer_datetimes
LOCATION:
checkIntTimeType, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:538
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Added JVM option string "-XX:+UseAltSigs"
LOCATION:
JVMOptList_add, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:436
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Added JVM option string
"-Djava.class.path=/usr/local/pgsql/lib/pljava.jar"
LOCATION:
JVMOptList_add, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:436
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Added JVM option string
"-Dsqlj.defaultconnection=jdbc:default:connection"
LOCATION:
JVMOptList_add, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:436
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Added JVM option string "vfprintf"
LOCATION:
JVMOptList_add, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:436
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Added JVM option string "-Xrs"
LOCATION:
JVMOptList_add, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:436
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: Creating JavaVM
LOCATION:
initializeJavaVM, /usr/home/kourkk/download/pljava-1.3.0/src/C/pljava/Backend.c:640
STATEMENT: SELECT
sqlj.install_jar('file:///home/kourkk/erbox/erbox/sqlj/sqlj.jar',
'sqlj', true);
DEBUG: 00000: reaping dead processes
LOCATION: reaper, postmaster.c:2025
DEBUG: 00000: server process (PID 31429) was terminated by signal 10
LOCATION: LogChildExit, postmaster.c:2432
LOG: 00000: server process (PID 31429) was terminated by signal 10
LOCATION: LogChildExit, postmaster.c:2432
LOG: 00000: terminating any other active server processes
LOCATION: HandleChildCrash, postmaster.c:2313
DEBUG: 00000: sending SIGQUIT to process 31397
LOCATION: HandleChildCrash, postmaster.c:2366
DEBUG: 00000: sending SIGQUIT to process 31398
LOCATION: HandleChildCrash, postmaster.c:2400
LOG: 00000: all server processes terminated; reinitializing
LOCATION: reaper, postmaster.c:2213
DEBUG: 00000: shmem_exit(0)
LOCATION: shmem_exit, ipc.c:126
DEBUG: 00000: invoking IpcMemoryCreate(size=9650176)
LOCATION: CreateSharedMemoryAndSemaphores, ipci.c:99
DEBUG: 00000: reaping dead processes
LOCATION: reaper, postmaster.c:2025
LOG: 00000: database system was interrupted at 2006-11-05 02:24:42 EET
LOCATION: StartupXLOG, xlog.c:4373
LOG: 00000: checkpoint record is at 0/3711508
LOCATION: StartupXLOG, xlog.c:4441
LOG: 00000: redo record is at 0/3711508; undo record is at 0/0; shutdown
TRUE
LOCATION: StartupXLOG, xlog.c:4468
LOG: 00000: next transaction ID: 5139; next OID: 32837
LOCATION: StartupXLOG, xlog.c:4471
LOG: 00000: next MultiXactId: 1; next MultiXactOffset: 0
LOCATION: StartupXLOG, xlog.c:4474
LOG: 00000: database system was not properly shut down; automatic
recovery in progress
LOCATION: StartupXLOG, xlog.c:4531
LOG: 00000: record with zero length at 0/371154C
LOCATION: ReadRecord, xlog.c:2763
LOG: 00000: redo is not required
LOCATION: StartupXLOG, xlog.c:4633
FATAL: 57P03: the database system is starting up
LOCATION: ProcessStartupPacket, postmaster.c:1593
DEBUG: 00000: proc_exit(0)
LOCATION: proc_exit, ipc.c:95
DEBUG: 00000: shmem_exit(0)
LOCATION: shmem_exit, ipc.c:126
DEBUG: 00000: exit(0)
LOCATION: proc_exit, ipc.c:113
DEBUG: 00000: forked new backend, pid=32170 socket=7
LOCATION: BackendStartup, postmaster.c:2524
DEBUG: 00000: reaping dead processes
LOCATION: reaper, postmaster.c:2025
DEBUG: 00000: server process (PID 32170) exited with exit code 0
LOCATION: LogChildExit, postmaster.c:2423
LOG: 00000: database system is ready
LOCATION: StartupXLOG, xlog.c:4820
LOG: 00000: transaction ID wrap limit is 2147484146, limited by database
"postgres"
LOCATION: SetTransactionIdLimit, varsup.c:234
DEBUG: 00000: proc_exit(0)
LOCATION: proc_exit, ipc.c:95
DEBUG: 00000: shmem_exit(0)
LOCATION: shmem_exit, ipc.c:126
DEBUG: 00000: exit(0)
LOCATION: proc_exit, ipc.c:113
DEBUG: 00000: reaping dead processes
LOCATION: reaper, postmaster.c:2025

Any Ideas Please?