[Pljava-dev] Re: VM initialization failure

Just to clear up this thread - my problem - once I used gdm to get some
extra info - was the zlib version conflict - which I solved by
recompiling postgresql using the --without-zlib flag.

Thanks for all who helped.

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
>
> Michael Judd wrote:
>
> >I've gone for the blackdown 1.4.2-rc1 (AMD64) version and it has got me
> >to a new place - perhaps a step back!
> >
> >When I try:
> >
> > SELECT sqlj.install_jar('file://opt/pgsql/lib/sqlj.jar','sqlj','true');
> >
> >my /var/log/pgsql.log is showing:
> >
> >Error occurred during initialization of VM
> >
> >I've recompiled pljava and reinstalled it (with the -reinstall switch).
> >I've restarted the pgsql instance
> >
> >I originally removed the LD_LIBRARY_PATH but this took me back to the
> >system not finding libjvm.so so I added it back in.
> >
> >I'm on Postgres 8x
> >
> >My postgresql.conf custom_variable_classes and pljava.classpath are set:
> >
> >custom_variable_classes = 'pljava'
> >pljava.classpath = '/opt/pgsql/pljava/build/pljava.jar'
> >
> >I've checked permissions on the postgres user and from su - postgres I
> >can see pljava.jar and I've opened it in file roller the it appears to
> >be intact.
> >
> >Any other ideas ?
> >
> >
> >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
> >>
> >>Michael Judd wrote:
> >>
> >>
> >>
> >>>pljava placed my pljava.so.1.1 in /opt/pgsql/lib so I've used that
> >>>instead of your /usr/lib64
> >>>
> >>>I still have the same issue. I have restarted - I'm running it in a
> >>>shell at the moment and I've closed the shell to ensure that the
> >>>environment is reset and the started up postgres again with:
> >>>
> >>>pg_ctl start -D /opt/pgsql/pg_data -l /var/log/pgsql.log -o "-i"
> >>>
> >>>The log file confirms this.
> >>>
> >>>The problem may well be as you suggest java 1.5
> >>>
> >>>I'll try blackdown as I'm on dual opterons (amd64 too) which is the
> >>>reason I didn't go with java1.4 to start.
> >>>
> >>>Thanks again for you help.
> >>>
> >>>Mike
> >>>
> >>>On Tue, 2005-06-07 at 19:08 -0600, Vince Clark wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>Here is my dynamic_library_path in postgresql.conf
> >>>>dynamic_library_path =
> >>>>'/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/'
> >>>>
> >>>>Note that I am running an AMD64 so things will look slightly
> >>>>different. The key in this line is that this path points to a
> >>>>directory that contains a file called libjvm.so. In some JVM's I have
> >>>>seen that file under jre/lib/client (rather than /server)
> >>>>
> >>>>Here is what my LD_LIBRARY_PATH looks like:
> >>>>LD_LIBRARY_PATH=/usr/lib64/:/home/java/j2sdk1.4.2/jre/lib/amd64/server/ export LD_LIBRARY_PATH
> >>>>
> >>>>In my case the pljava build placed pljava.so.1.1 in /usr/lib64 and
> >>>>created soft links with the proper file name of pljava.so
> >>>>
> >>>>Also, you may run into another problem once you get past the library
> >>>>path issue. I was unable to install pljava using a 1.5.x JDK. I ended
> >>>>up using Blackdown 1.4.2. It has something to do with being able to
> >>>>spawn a VM from within Postgres. I don't remember exactly.
> >>>>
> >>>>Finally, I'm serious about restarting postgres. I did two
> >>>>installations where the path settings were right but I had to restart
> >>>>postgres before I could successfully add pljava as a language in the
> >>>>database.
> >>>>
> >>>>Michael Judd wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Hi,
> >>>>>
> >>>>>At your recommendation I changed my LD_LIBRARY_PATH (via /etc/profile)
> >>>>>to /usr/java/jdk1.5.0_03/jre/lib:/usr/java/jdk1.5.0_03/jre/lib/server:/usr/java/jdk1.5.0_03/jre/lib/native_threads:/opt/pgsql/lib
> >>>>>This now matches my dynamic_library_path in postgresql.conf
> >>>>>in /opt/pgsql/pg_data (or should I use this in my pljava.classpath ?
> >>>>>
> >>>>>I'm still getting exactly the same problem.
> >>>>>
> >>>>>Thanks for your help.
> >>>>>
> >>>>>
> >>>>>
> >>>>>On Tue, 2005-06-07 at 17:16 -0600, Vince Clark wrote:
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>Michael
> >>>>>>
> >>>>>>You said you were having trouble installing plsql. Do you mean pljava?
> >>>>>>
> >>>>>>Be sure you also have LD_LIBRARY_PATH set with the same values.
> >>>>>>
> >>>>>>Once the library path is established in both places (LD_LIBRARY_PATH)
> >>>>>>and postgresql.conf) I found that restarting postgres before trying to
> >>>>>>install pljava solved the problem.
> >>>>>>
> >>>>>>Michael Judd wrote:
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>____________________________________________________________________
> >>>>>>>
> >>>>>>>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
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >
> >
> >
> >
>
>