From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 15:48:22 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id C6B4541A for ; Mon, 4 Feb 2013 15:48:22 +0000 (UTC) (envelope-from achill@smadev.internal.net) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id E41B933C for ; Mon, 4 Feb 2013 15:48:21 +0000 (UTC) X-Bogosity: No, tests=bogofilter Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.5/8.14.5) with ESMTP id r14FmK9I007537 for ; Mon, 4 Feb 2013 17:48:20 +0200 (EET) (envelope-from achill@smadev.internal.net) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r14FmKR5007536 for freebsd-java@freebsd.org; Mon, 4 Feb 2013 17:48:20 +0200 (EET) (envelope-from achill@smadev.internal.net) From: Achilleas Mantzios To: freebsd-java@freebsd.org Subject: Re: Re: Re: Re: FreeBSD pl/java problem : backend hangs Date: Mon, 04 Feb 2013 17:48:20 +0200 Message-ID: <3454957.mdnJNsQM6V@smadev.internal.net> Organization: Dynacom Tankers Mgmt User-Agent: KMail/4.8.4 (FreeBSD/8.3-RELEASE; KDE/4.8.4; amd64; ; ) In-Reply-To: <1794514.P32sUeWV4B@smadev.internal.net> References: <5933829.WYzpjKtO0p@smadev.internal.net> <2555655.RMjoVHmAxh@smadev.internal.net> <1794514.P32sUeWV4B@smadev.internal.net> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: Achilleas Mantzios List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 15:48:22 -0000 It seems that it gets hung in JNI_CreateJavaVM. I can write and run standalone JNI programs outside postgrsesql (even a= s postgres user), but when i try to run it from within postgres, then it gets hang. Any ideas? On =CE=94=CE=B5=CF=85 04 =CE=A6=CE=B5=CE=B2 2013 17:16:27 Achilleas Man= tzios wrote: > I am thinking of trying to address this problem twofold : >=20 > 1) establish a connection with the pl/java people > 2) trying to go back and forth from there and here to try to debug th= e problem >=20 > Lets wait for some recommendation/help from there, and then i'll get = back > to this list for more. >=20 > On =CE=94=CE=B5=CF=85 04 =CE=A6=CE=B5=CE=B2 2013 16:09:56 Achilleas M= antzios wrote: > > Thanx Ronald, > >=20 > > postgres@smadev:~> jstack 384 > > 384: Unable to open socket file: target process not responding or H= otSpot VM not loaded > > The -F option can be used when the target process is not responding= > >=20 > > Also jstack -F fails as well > > postgres@smadev:~> jstack -F 384 > > Attaching to process ID 384, please wait... > > Exception in thread "main" java.lang.reflect.InvocationTargetExcept= ion > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Meth= od) > > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethod= AccessorImpl.java:57) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegati= ngMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:616) > > at sun.tools.jstack.JStack.runJStackTool(JStack.java:136) > > at sun.tools.jstack.JStack.main(JStack.java:102) > > Caused by: sun.jvm.hotspot.debugger.UnalignedAddressException: Tryi= ng to read at address: 0x746f705c6c4f4867 with alignment: 4 > > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal$1.checkAli= gnment(BsdDebuggerLocal.java:181) > > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readCInteg= er(BsdDebuggerLocal.java:478) > > at sun.jvm.hotspot.debugger.DebuggerBase.readAddressValue(D= ebuggerBase.java:454) > > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readAddres= s(BsdDebuggerLocal.java:423) > > at sun.jvm.hotspot.debugger.bsd.BsdAddress.getAddressAt(Bsd= Address.java:74) > > at sun.jvm.hotspot.HotSpotTypeDataBase.readVMTypes(HotSpotT= ypeDataBase.java:108) > > at sun.jvm.hotspot.HotSpotTypeDataBase.(HotSpotTypeDa= taBase.java:85) > > at sun.jvm.hotspot.bugspot.BugSpotAgent.setupVM(BugSpotAgen= t.java:574) > > at sun.jvm.hotspot.bugspot.BugSpotAgent.go(BugSpotAgent.jav= a:495) > > at sun.jvm.hotspot.bugspot.BugSpotAgent.attach(BugSpotAgent= .java:333) > > at sun.jvm.hotspot.tools.Tool.start(Tool.java:163) > > at sun.jvm.hotspot.tools.JStack.main(JStack.java:86) > >=20 > >=20 > > On =C3=8E=C2=94=C3=8E=C2=B5=C3=8F=C2=85 04 =C3=8E=C2=A6=C3=8E=C2=B5= =C3=8E=C2=B2 2013 14:47:13 you wrote: > > > I have no experience running java as a backend of pgsql. > > > Can you run jstack on the backend? > > >=20 > > > Ronald. > > >=20 > > > On Mon, 04 Feb 2013 14:17:22 +0100, Achilleas Mantzios =20 > > > wrote: > > >=20 > > > > Hello community, > > > > > > > > I am running postgresql 9.2.2 with > > > > openjdk version "1.6.0_32" > > > > OpenJDK Runtime Environment (build 1.6.0_32-b25) > > > > OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode) > > > > On FreeBSD 8.3-RELEASE > > > > > > > > I am having trouble even running simple tests like : > > > > CREATE FUNCTION getsysprop(VARCHAR) > > > > RETURNS VARCHAR > > > > AS 'java.lang.System.getProperty' > > > > LANGUAGE java; > > > > > > > > SELECT getsysprop('user.home'); > > > > > > > > When i do that, the session hangs, and have to kill -9 the back= end. > > > > > > > > Searching with truss got : > > > > > > > > gettimeofday({1359983241.596250 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596275 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596300 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596327 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596352 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596378 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596403 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596431 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596458 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596482 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596507 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596532 },0x0) =3D 0 (0x0) > > > > gettimeofday({1359983241.596556 },0x0) =3D 0 (0x0) > > > > _umtx_op(0x7fffffffc7e8,0x3,0x1,0x0,0x0,0x1) =3D 0 (0x0) > > > > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SIGK= ILL|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCH= LD|SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIG= INFO|SIGUSR1|SIGUSR2,0x0) =20 > > > > =3D 0 (0x0) > > > > sigprocmask(SIG_SETMASK,0x0,0x0) =3D 0 (0x0) > > > > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SIGK= ILL|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCH= LD|SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIG= INFO|SIGUSR1|SIGUSR2,0x0) =20 > > > > =3D 0 (0x0) > > > > sigprocmask(SIG_SETMASK,0x0,0x0) =3D 0 (0x0) > > > > > > > > while ktrace gave : > > > > > > > > 98910 initial thread CALL gettimeofday(0x7fffffffc900,0) > > > > 98910 initial thread RET gettimeofday 0 > > > > 98910 initial thread CALL gettimeofday(0x7fffffffc900,0) > > > > 98910 initial thread RET gettimeofday 0 > > > > 98910 initial thread CALL gettimeofday(0x7fffffffc900,0) > > > > 98910 initial thread RET gettimeofday 0 > > > > 98910 initial thread CALL gettimeofday(0x7fffffffc900,0) > > > > 98910 initial thread RET gettimeofday 0 > > > > 98910 initial thread CALL gettimeofday(0x7fffffffc940,0) > > > > 98910 initial thread RET gettimeofday 0 > > > > 98910 initial thread CALL _umtx_op(0x7fffffffc7e8,0x3,0x1,0,0= ) > > > > 98910 initial thread RET _umtx_op 0 > > > > 98910 initial thread CALL =20 > > > > sigprocmask(SIG_BLOCK,0x7fffffffc780,0x8016167d8) > > > > 98910 initial thread RET sigprocmask 0 > > > > 98910 initial thread CALL sigprocmask(SIG_SETMASK,0x8016167d8= ,0) > > > > 98910 initial thread RET sigprocmask 0 > > > > 98910 initial thread CALL =20 > > > > sigprocmask(SIG_BLOCK,0x7fffffffc6e0,0x8016167d8) > > > > 98910 initial thread RET sigprocmask 0 > > > > 98910 initial thread CALL sigprocmask(SIG_SETMASK,0x8016167d8= ,0) > > > > 98910 initial thread RET sigprocmask 0 > > > > 98910 initial thread CALL _umtx_op(0x8f8dc4280,0x11,0,0,0) > > > > > > > > I found some relevant problems with FreeBSD systems hanging aft= er an =20 > > > > _umtx_op but all those point > > > > to threading problems that now are solved. I found nothing mode= rn about =20 > > > > _umtx_op. > > > > > > > > I know FreeBSD is not a "Tier-1" platform for postgresql (nor j= ava), but =20 > > > > this is my main platform and i'd like > > > > to stick with this. > > > > > > > > Is there anything i could do to get closer to make pl/java work= with =20 > > > > FreeBSD? > > > > > > > > Also read this =20 > > > > http://postgresql.1045698.n5.nabble.com/Java-VM-stalls-during-q= uot-install-jar-quot-td3290754.html =20 > > > > thread. > > > > Very close to my situation. JNI standalone also worked for me. > > > > > > > > Any hints/pointers ? > > > > > > > > - > > > > Achilleas Mantzios > > > > IT DEV > > > > IT DEPT > > > > Dynacom Tankers Mgmt > > > > _______________________________________________ > > > > freebsd-java@freebsd.org mailing list > > > > http://lists.freebsd.org/mailman/listinfo/freebsd-java > > > > To unsubscribe, send any mail to "freebsd-java-unsubscribe@free= bsd.org" > > - > > Achilleas Mantzios > > IT DEV > > IT DEPT > > Dynacom Tankers Mgmt > > _______________________________________________ > > freebsd-java@freebsd.org mailing list > > http://lists.freebsd.org/mailman/listinfo/freebsd-java > > To unsubscribe, send any mail to "freebsd-java-unsubscribe@freebsd.= org" > - > Achilleas Mantzios > IT DEV > IT DEPT > Dynacom Tankers Mgmt - Achilleas Mantzios IT DEV IT DEPT