From: sotelojavier at hotmail.com (Javier Sotelo) Date: Wed, 4 Jun 2008 19:18:04 -0700 Subject: [Pljava-dev] =?windows-1256?q?_RE=3A___RE=3A__PLJava_=2864-bit=29?= =?windows-1256?q?_Build_Error=3A_JNI=5FCreateJavaVM=FE?= In-Reply-To: References: Message-ID: postmaster is started in init.d but I've tried running the postmaster directly then running the deployer, I've included the output when postmaster starts and when i try to run the deployer, see output. Let me know if you need any more info. I would love for this to work cause my alternative solution is not as pretty... :( Again Thanks for the Time, Javier ************Postmaster Startup Output:**************** postgres at lb-bft23:~> DEBUG: postmaster: PostmasterMain: initial environ dump: DEBUG: ----------------------------------------- DEBUG: LESSKEY=/etc/lesskey.bin DEBUG: NNTPSERVER=news DEBUG: INFODIR=/usr/local/info:/usr/share/info:/usr/info DEBUG: MANPATH=/usr/local/man:/usr/share/man:/usr/X11R6 /man:/opt/gnome/ share/man DEBUG: KDE_MULTIHEAD=false DEBUG: SSH_AGENT_PID=5328 DEBUG: HOSTNAME=lb-bft23 DEBUG: GNOME2_PATH=/usr/local:/opt/gnome:/usr DEBUG: XKEYSYMDB=/usr/share/X11/XKeysymDB DEBUG: HOST=LB-BFT23 DEBUG: SHELL=/bin/bash DEBUG: TERM=xterm DEBUG: PROFILEREAD=true DEBUG: HISTSIZE=1000 DEBUG: GTK2_RC_FILES=/etc/opt/gnome/gtk-2.0/gtkrc:/opt/g nome/share/them es//QtCurve/gtk-2.0/gtkrc:/home/arclight/.gtkrc-2.0-qtengine:/home /arclight/.gtk rc-2.0:/home/arclight/.kde/share/config/gtkrc-2.0 DEBUG: GTK_RC_FILES=/etc/opt/gnome/gtk/gtkrc:/home/arc light/.gtkrc:/hom e/arclight/.kde/share/config/gtkrc DEBUG: GS_LIB=/home/arclight/.fonts DEBUG: WINDOWID=106954760 DEBUG: MORE=-sl DEBUG: QTDIR=/usr/lib/qt3 DEBUG: XSESSION_IS_UP=yes DEBUG: KDE_FULL_SESSION=true DEBUG: GROFF_NO_SGR=yes DEBUG: USER=postgres DEBUG: JRE_HOME=/usr/java/jdk1.5.0_15/jre DEBUG: LS_COLORS=no=00:fi=00:di=01;34:ln=00;36: pi=40;33:so=01;35:do=01; 35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00; 32:*.exe=01;32:*.com=01 ;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00; 31:*.tgz=00;31:*.rp m=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00; 31:*.zip=00;31:*.zoo=00;31: *.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00; 31:*.tz2=00;31:*.tbz2=00;31: *.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01; 35:*.jpeg=01;35:*.mng=0 1;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01; 35:*.pgm=01;35:*.png=01;35:*.p pm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01; 35:*.dl=01;35:*.gl=01;35:* .wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00; 32:*.ogg=00;32:*.voc=00; 32:*.wav=00;32: DEBUG: DESKTOP_LAUNCH=kde-open DEBUG: LD_LIBRARY_PATH=/usr/local/pgsql/lib:/usr/ java/jdk1.5.0_15/jre/l ib/amd64:/usr/java/jdk1.5.0_15/jre/lib/amd64/server:/usr/jav a/jdk1.5.0_15/jre/li b/amd64/native_threads DEBUG: XNLSPATH=/usr/share/X11/nls DEBUG: ENV=/etc/bash.bashrc DEBUG: SSH_AUTH_SOCK=/tmp/ssh-oNvid5282/ag ent.5282 DEBUG: HOSTTYPE=x86_64 DEBUG: SESSION_MANAGER=local/lb-bft23:/tmp/.IC E-unix/5382 DEBUG: FROM_HEADER= DEBUG: USERNAME=arclight DEBUG: PAGER=less DEBUG: CSHEDIT=emacs DEBUG: PGSQLDIR=/usr/local/pgsql DEBUG: XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/ xdg/:/etc/opt/gnome/xdg / DEBUG: KONSOLE_DCOP=DCOPRef(konsole-5457,k onsole) DEBUG: MINICOM=-c on DEBUG: MAIL=/var/spool/mail/arclight DEBUG: PATH=/opt/kde3/bin:/home/arclight/bin:/usr/lo cal/bin:/usr/bin:/u sr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/usr/lib/mit/bin :/usr/lib/mit/sbin:/ usr/lib/qt3/bin:/usr/local/pgsql/bin:/usr/java/jdk1.5.0_15/bin DEBUG: DESKTOP_SESSION=kde DEBUG: CPU=x86_64 DEBUG: _=/usr/local/pgsql/bin/postmaster DEBUG: GDM_XSERVER_LOCATION=local DEBUG: KONSOLE_DCOP_SESSION=DCOPRef(kons ole-5457,session-1) DEBUG: INPUTRC=/home/arclight/.inputrc DEBUG: PWD=/home/postgres DEBUG: XMODIFIERS=@im=local DEBUG: JAVA_HOME=/usr/java/jdk1.5.0_15 DEBUG: LANG=en_US.UTF-8 DEBUG: KDE_SESSION_UID=1000 DEBUG: PYTHONSTARTUP=/etc/pythonstart DEBUG: GDMSESSION=kde DEBUG: SSH_ASKPASS=/usr/lib64/ssh/x11-ssh -askpass DEBUG: TEXINPUTS=::/home/arclight/.TeX:/usr/share /doc/.TeX:/usr/doc/.Te X:/home/arclight/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX DEBUG: QT_SYSTEM_DIR=/usr/share/desktop-data DEBUG: SHLVL=4 DEBUG: HOME=/home/postgres DEBUG: LESS_ADVANCED_PREPROCESSOR=no DEBUG: OSTYPE=linux DEBUG: LS_OPTIONS=-N --color=tty -T 0 DEBUG: XCURSOR_THEME=crystalwhite DEBUG: WINDOWMANAGER=/usr/bin/dbus-launch -- sh-syntax --exit-with-sessi on /opt/kde3/bin/ startkde DEBUG: GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/li b/gtk-2.0:/usr/lib/ gtk-2.0 DEBUG: G_FILENAME_ENCODING=@locale,UTF-8,ISO -8859-15,CP1252 DEBUG: LESS=-M -I DEBUG: MACHTYPE=x86_64-suse-linux DEBUG: LOGNAME=postgres DEBUG: GTK_PATH64=/usr/local/lib64/gtk-2.0:/opt/gn ome/lib64/gtk-2.0:/us r/lib64/gtk-2.0 DEBUG: CVS_RSH=ssh DEBUG: XDG_DATA_DIRS=/usr/local/share/:/usr/share /:/etc/opt/kde3/share/ :/opt/kde3/share/:/opt/gn ome/share/ DEBUG: ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal DEBUG: DBUS_SESSION_BUS_ADDRESS=unix:abstract =/tmp/dbus-D9rvYZnmNH,guid =4546474863cb 0466ebc8580079002800 DEBUG: PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/us r/local/share/pkgcon fig:/usr/lib64/pkgconfig:/us r/share/pkgconfig:/opt/kde3/lib64/pkgconfig:/opt/gno me/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/ share/pkgconfig DEBUG: LESSOPEN=lessopen.sh %s DEBUG: USE_FAM= DEBUG: INFOPATH=/usr/local/info:/usr/share/info:/usr/inf o:/opt/gnome/sh are/info DEBUG: DISPLAY=:0 DEBUG: XAUTHLOCALHOSTNAME=lb-bft23 DEBUG: LESSCLOSE=lessclose.sh %s %s DEBUG: G_BROKEN_FILENAMES=1 DEBUG: COLORTERM= DEBUG: XAUTHORITY=/home/postgres/.xauthBwUkab DEBUG: mc=() { . /usr/share/mc/bin/mc-wrapper.sh } DEBUG: PGSYSCONFDIR=/usr/local/pgsql/etc DEBUG: LC_COLLATE=en_US.UTF-8 DEBUG: LC_CTYPE=en_US.UTF-8 DEBUG: LC_MESSAGES=en_US.UTF-8 DEBUG: LC_MONETARY=C DEBUG: LC_NUMERIC=C DEBUG: LC_TIME=C DEBUG: ----------------------------------------- LOG: could not create IPv6 socket: Address family not supported by protocol DEBUG: invoking IpcMemoryCreate(size=11083776) DEBUG: max_safe_fds = 985, usable_fds = 1000, alre ady_open = 5 LOG: database system was shut down at 2008-06-04 18:53:18 PDT LOG: checkpoint record is at 0/515F68 LOG: redo record is at 0/515F68; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 726; next OID: 16520 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited by database "postgres" DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) *****************Deployer & Postmaster Output:******************** postgres at lb-bft23:/usr/share/pljava> /usr/java/default/jre/bin /java -server -cp deploy.jar:postgresql-8.1-412.jdbc3.jar org.postgresql.plj ava.deploy .Deployer -install -user postgres -database pljava DEBUG: forked new backend, pid=6111 socket=6 DEBUG: postmaster child[6111]: starting with ( DEBUG: postgres DEBUG: -v196608 DEBUG: -p DEBUG: pljava DEBUG: ) DEBUG: InitPostgres DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 726/1/0, nestlvl: 1, children: <> DEBUG: CommitTransaction DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 726/1/0, nestlvl: 1, children: <> DEBUG: StartTransactionCommand DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 727/1/0, nestlvl: 1, children: <> DEBUG: ProcessUtility DEBUG: CommitTransactionCommand DEBUG: CommitTransaction DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 727/1/2, nestlvl: 1, children: <> DEBUG: StartTransactionCommand DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 728/1/0, nestlvl: 1, children: <> DEBUG: ProcessUtility DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: ProcessUtility DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: ProcessUtility DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: ProcessUtility DEBUG: find_in_dynamic_libpath: trying "/usr/local/pgsql/lib/pljava" DEBUG: find_in_dynamic_libpath: trying "/usr/share/pljava/pljava" DEBUG: find_in_dynamic_libpath: trying "/usr/local/pgsql/lib/pljava.so" DEBUG: find_in_dynamic_libpath: trying "/usr/share/pljava/pljava.so" ERROR: could not load library "/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so: undefined symbol: JNI_CreateJavaVM org.postgresql.util.PSQLException: ERROR: could not load library "/usr/share/pljava/pljava.so": /usr/share/pljava/pljava.so: undefined symbol: JNI_CreateJavaVM at org.postgresql.core.v3.QueryExecutorImpl.receiveError Response(QueryExecutorImpl.java:1575) at org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java:1324) at org.postgresql.core.v3.QueryExecutorImpl.execute(Query ExecutorImpl.java:190) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Ab stractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWit hFlags(AbstractJdbc2Statement.java:340) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(A bstractJdbc2Statement.java:332) at org.postgresql.pljava.deploy.Deployer.initJavaHandlers(D eployer.java:474) at org.postgresql.pljava.deploy.Deployer.main(Deployer.jav a:269) LOG: unexpected EOF on client connection DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) DEBUG: server process (PID 6111) exited with exit code 0 postgres at lb-bft23:/usr/share/pljava> ---------------------------------------- > Date: Wed, 4 Jun 2008 11:20:17 -0400 > From: books at ejurka.com > To: sotelojavier at hotmail.com > CC: pljava-dev at pgfoundry.org > Subject: Re: [Pljava-dev] RE: PLJava (64-bit) Build Error: JNI_CreateJavaVM? > > > > On Mon, 2 Jun 2008, Javier Sotelo wrote: > >> The LD_LIBRARY_PATH environment setting is being set with the .bashrc >> file which is the start up script that SuSe uses, this should be the script >> you were referring to. > > I was actually referring to something like /etc/init.d/postgresql, but now > that I see you're installed into /usr/local/pgsql that may not be the > case. How are you starting postgres? an init.d script, pg_ctl, running > postmaster directly, ...? > > Kris Jurka _________________________________________________________________ Now you can invite friends from Facebook and other groups to join you on Windows Live? Messenger. Add now. https://www.invite2messenger.net/im/?source=TXT_EML_WLH_AddNow_Now