Date: Mon, 04 Feb 2013 16:09:56 +0200 From: Achilleas Mantzios <achill@matrix.gatewaynet.com> To: Ronald Klop <ronald-freebsd8@klop.yi.org>, freebsd-java@freebsd.org Subject: Re: Re: FreeBSD pl/java problem : backend hangs Message-ID: <2555655.RMjoVHmAxh@smadev.internal.net> In-Reply-To: <op.wrzhwzxh8527sy@ronaldradial.versatec.local> References: <5933829.WYzpjKtO0p@smadev.internal.net> <op.wrzhwzxh8527sy@ronaldradial.versatec.local>
next in thread | previous in thread | raw e-mail | index | archive | help
Thanx Ronald,
postgres@smadev:~> jstack 384
384: Unable to open socket file: target process not responding or HotSp=
ot VM not loaded
The -F option can be used when the target process is not responding
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.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce=
ssorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe=
thodAccessorImpl.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: Trying t=
o read at address: 0x746f705c6c4f4867 with alignment: 4
at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal$1.checkAlignme=
nt(BsdDebuggerLocal.java:181)
at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readCInteger(B=
sdDebuggerLocal.java:478)
at sun.jvm.hotspot.debugger.DebuggerBase.readAddressValue(Debug=
gerBase.java:454)
at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readAddress(Bs=
dDebuggerLocal.java:423)
at sun.jvm.hotspot.debugger.bsd.BsdAddress.getAddressAt(BsdAddr=
ess.java:74)
at sun.jvm.hotspot.HotSpotTypeDataBase.readVMTypes(HotSpotTypeD=
ataBase.java:108)
at sun.jvm.hotspot.HotSpotTypeDataBase.<init>(HotSpotTypeDataBa=
se.java:85)
at sun.jvm.hotspot.bugspot.BugSpotAgent.setupVM(BugSpotAgent.ja=
va:574)
at sun.jvm.hotspot.bugspot.BugSpotAgent.go(BugSpotAgent.java:49=
5)
at sun.jvm.hotspot.bugspot.BugSpotAgent.attach(BugSpotAgent.jav=
a:333)
at sun.jvm.hotspot.tools.Tool.start(Tool.java:163)
at sun.jvm.hotspot.tools.JStack.main(JStack.java:86)
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
> <achill@matrix.gatewaynet.com> 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 backend.=
> >
> > 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|SIGKILL|=
SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCHLD|S=
IGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGINFO=
|SIGUSR1|SIGUSR2,0x0) =20
> > =3D 0 (0x0)
> > sigprocmask(SIG_SETMASK,0x0,0x0) =3D 0 (0x0)
> > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SIGKILL|=
SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCHLD|S=
IGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGINFO=
|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 after a=
n =20
> > _umtx_op but all those point
> > to threading problems that now are solved. I found nothing modern a=
bout =20
> > _umtx_op.
> >
> > I know FreeBSD is not a "Tier-1" platform for postgresql (nor java)=
, 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 wit=
h =20
> > FreeBSD?
> >
> > Also read this =20
> > http://postgresql.1045698.n5.nabble.com/Java-VM-stalls-during-quot-=
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@freebsd.=
org"
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2555655.RMjoVHmAxh>