FreeBSD pl/java problem : backend hangs
Achilleas Mantzios
achill at matrix.gatewaynet.com
Mon Feb 4 15:16:30 UTC 2013
I am thinking of trying to address this problem twofold :
1) establish a connection with the pl/java people
2) trying to go back and forth from there and here to try to debug the problem
Lets wait for some recommendation/help from there, and then i'll get back
to this list for more.
On Δευ 04 Φεβ 2013 16:09:56 Achilleas Mantzios wrote:
> Thanx Ronald,
>
> postgres at smadev:~> jstack 384
> 384: Unable to open socket file: target process not responding or HotSpot VM not loaded
> The -F option can be used when the target process is not responding
>
> Also jstack -F fails as well
> postgres at 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(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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 to read at address: 0x746f705c6c4f4867 with alignment: 4
> at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal$1.checkAlignment(BsdDebuggerLocal.java:181)
> at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readCInteger(BsdDebuggerLocal.java:478)
> at sun.jvm.hotspot.debugger.DebuggerBase.readAddressValue(DebuggerBase.java:454)
> at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readAddress(BsdDebuggerLocal.java:423)
> at sun.jvm.hotspot.debugger.bsd.BsdAddress.getAddressAt(BsdAddress.java:74)
> at sun.jvm.hotspot.HotSpotTypeDataBase.readVMTypes(HotSpotTypeDataBase.java:108)
> at sun.jvm.hotspot.HotSpotTypeDataBase.<init>(HotSpotTypeDataBase.java:85)
> at sun.jvm.hotspot.bugspot.BugSpotAgent.setupVM(BugSpotAgent.java:574)
> at sun.jvm.hotspot.bugspot.BugSpotAgent.go(BugSpotAgent.java: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)
>
>
> On ΔεÏ
04 Φεβ 2013 14:47:13 you wrote:
> > I have no experience running java as a backend of pgsql.
> > Can you run jstack on the backend?
> >
> > Ronald.
> >
> > On Mon, 04 Feb 2013 14:17:22 +0100, Achilleas Mantzios
> > <achill at matrix.gatewaynet.com> wrote:
> >
> > > 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) = 0 (0x0)
> > > gettimeofday({1359983241.596275 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596300 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596327 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596352 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596378 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596403 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596431 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596458 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596482 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596507 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596532 },0x0) = 0 (0x0)
> > > gettimeofday({1359983241.596556 },0x0) = 0 (0x0)
> > > _umtx_op(0x7fffffffc7e8,0x3,0x1,0x0,0x0,0x1) = 0 (0x0)
> > > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SIGKILL|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCHLD|SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGINFO|SIGUSR1|SIGUSR2,0x0)
> > > = 0 (0x0)
> > > sigprocmask(SIG_SETMASK,0x0,0x0) = 0 (0x0)
> > > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SIGKILL|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCHLD|SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGINFO|SIGUSR1|SIGUSR2,0x0)
> > > = 0 (0x0)
> > > sigprocmask(SIG_SETMASK,0x0,0x0) = 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
> > > 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
> > > 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 an
> > > _umtx_op but all those point
> > > to threading problems that now are solved. I found nothing modern about
> > > _umtx_op.
> > >
> > > I know FreeBSD is not a "Tier-1" platform for postgresql (nor java), but
> > > 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
> > > FreeBSD?
> > >
> > > Also read this
> > > http://postgresql.1045698.n5.nabble.com/Java-VM-stalls-during-quot-install-jar-quot-td3290754.html
> > > 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 at freebsd.org mailing list
> > > http://lists.freebsd.org/mailman/listinfo/freebsd-java
> > > To unsubscribe, send any mail to "freebsd-java-unsubscribe at freebsd.org"
> -
> Achilleas Mantzios
> IT DEV
> IT DEPT
> Dynacom Tankers Mgmt
> _______________________________________________
> freebsd-java at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-java
> To unsubscribe, send any mail to "freebsd-java-unsubscribe at freebsd.org"
-
Achilleas Mantzios
IT DEV
IT DEPT
Dynacom Tankers Mgmt
More information about the freebsd-java
mailing list