From: list at jaztek.co.uk (Michael Judd)
Date: Wed, 08 Jun 2005 11:12:31 +0100
Subject: [Pljava-dev] Re: VM initialization failure
In-Reply-To: <thhal-0blCCA399zjYpuyrjBtxjEl6vv1+tFZ@mailblocks.com>
References: <1118185878.5061.457.camel@laptop01.jaztek.co.uk>
	<42A62AE9.8060309@globalera.com>
	<1118190465.5061.497.camel@laptop01.jaztek.co.uk>
	<42A6452A.3000503@globalera.com>
	<1118214525.5061.575.camel@laptop01.jaztek.co.uk>
	<42A6A435.9090307@mailblocks.com>
	<thhal-0uDyCA199zjY+QBlYM2omB4NFqe2doG@mailblocks.com>
	<1118221036.5061.628.camel@laptop01.jaztek.co.uk>
	<42A6B7EB.1010804@mailblocks.com>
	<thhal-0blCCA399zjYpuyrjBtxjEl6vv1+tFZ@mailblocks.com>
Message-ID: <1118225551.5061.654.camel@laptop01.jaztek.co.uk>

Done - I'm back to SUN.

I am getting the same "Backend" problem now I've reverted to jdk1.5.0_03

I've compiled pljava again with:
make clean
make "CFLAGS-g"
make install

java -version reports jdk1.5.0_03-b07

gdb 
attach 28330 (the process reported by psql)
Symbols are loaded for libpljava.so 

What now?  psql tells me to set pljavaDebug to false.  How would I go
about that?

Mike

On Wed, 2005-06-08 at 11:18 +0200, Thomas Hallgren wrote:
> Revert to the Sun 1.5 JVM. Reproduce the error you had earlier with the 
> settings that you have now. If you still fail, then you might need to 
> debug (using gdb) what's actually going on. You can do that by 
> rebuilding pljava using make "CFLAGS=-g" and then add the setting 
> "pljava.debug = true" in your postgresql.conf file. That will make the 
> PL/Java stop immediately before it initializes the JVM, print the pid of 
> its process and wait for a debugger to attach.
> 
> Regards,
> Thomas Hallgren
> >On Wed, 2005-06-08 at 09:54 +0200, Thomas Hallgren wrote:
> >  
> >
> >>I seriously doubt that this has anything to do with Suns Java 1.5 since:
> >>
> >>1. I've been using Suns Java 1.5 on all platforms (including amd64) 
> >>without problems.
> >>2. The problem you encounter comes *after* the fact that the VM has 
> >>loaded successfully.
> >>
> >>I'd check the CLASSPATH setting again. If you are using PostgreSQL 8.0.x 
> >>(or later) then I suggest you remove the CLASSPATH altogether and assert 
> >>that the following lines is in your postgresql.conf:
> >>
> >>custom_variable_classes = 'pljava'
> >>pljava.classpath = '<your absolute path to pljava.jar>'
> >>
> >>If you still have problems, then verify that the pljava.jar is 
> >>accessible (check permissions on files and directories, the user who 
> >>owns your postmaster must be able to read) and verify that it isn't 
> >>corrupted.
> >>
> >>Regards,
> >>Thomas Hallgren
> >>>       
> >>>>>>
> >>>>>>            
> >>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>Subject:  Unable to load class org/postgresql/plsql/internal/Backend
> >>>>>>>From:  Michael Judd <michael.judd at jaztek.co.uk>
> >>>>>>>Date:  Tue, 07 Jun 2005 23:46:25 +0100
> >>>>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>>>To:  pljava-dev at gborg.postgresql.org
> >>>>>>>
> >>>>>>>Hi,
> >>>>>>>
> >>>>>>>I'm having trouble installing plsql and I'm getting the following:
> >>>>>>>
> >>>>>>>Unable to load class org/postgresql/plsql/internal/Backend using
> >>>>>>>CLASSPATH '-Djava.class.path=/opt/pgsql/pljava/build.pljava.jar'
> >>>>>>>
> >>>>>>>when issuing the command to pgsql:
> >>>>>>>
> >>>>>>>SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj',true);
> >>>>>>>
> >>>>>>>I have checked that:
> >>>>>>>- pljava.jar is in /opt/pgsql/pljava/build
> >>>>>>>- sqlj.jar is in  /opt/pgsql/lib
> >>>>>>>
> >>>>>>>in my postgres.conf I have dynamic_library_path = '/opt/pgsql/lib:
> >>>>>>>$libdir' where libpljava.so, plpgsql.so resides.
> >>>>>>>
> >>>>>>>my paths are:
> >>>>>>>- postgres /opt/pgsql
> >>>>>>>- pljava /opt/pgsql/pljava
> >>>>>>>- data /opt/pgsql/pg_data
> >>>>>>>
> >>>>>>>Fedora Core 3 x86_64smp
> >>>>>>>
> >>>>>>>I've double checked that Backend is located in the jar exactly where it
> >>>>>>>is supposed to be - so the error being displayed doesn't seem to point
> >>>>>>>in the 'right' direction.
> >>>>>>>
> >>>>>>>Any ideas ?
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> 
> >>>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>_______________________________________________
> >>>>>>>Pljava-dev mailing list
> >>>>>>>Pljava-dev at gborg.postgresql.org
> >>>>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>>>>> 
> >>>>>>>     
> >>>>>>>         
> >>>>>>>
> >>>>>>>              
> >>>>>>>
> >>>>>>-- 
> >>>>>>Vince Clark 
> >>>>>>Global Era 
> >>>>>>The freedom of open source. 
> >>>>>>(303) 493-6723 
> >>>>>>(303) 455-2409 fax 
> >>>>>>vclark at globalera.com 
> >>>>>>www.globalera.com
> >>>>>>   
> >>>>>>       
> >>>>>>
> >>>>>>            
> >>>>>>
> >>>>> 
> >>>>>     
> >>>>>
> >>>>>          
> >>>>>
> >>>>-- 
> >>>>Vince Clark 
> >>>>Global Era 
> >>>>The freedom of open source. 
> >>>>(303) 493-6723 
> >>>>(303) 455-2409 fax 
> >>>>vclark at globalera.com 
> >>>>www.globalera.com
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>_______________________________________________
> >>>Pljava-dev mailing list
> >>>Pljava-dev at gborg.postgresql.org
> >>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>> 
> >>>
> >>>      
> >>>
> >>    
> >>
> >
> >
> >  
> >
> 
>