From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 11:06:47 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 F327195B for ; Mon, 4 Feb 2013 11:06:46 +0000 (UTC) (envelope-from owner-bugmaster@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:1900:2254:206c::16:87]) by mx1.freebsd.org (Postfix) with ESMTP id CCB59D07 for ; Mon, 4 Feb 2013 11:06:46 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.6/8.14.6) with ESMTP id r14B6kjJ028806 for ; Mon, 4 Feb 2013 11:06:46 GMT (envelope-from owner-bugmaster@FreeBSD.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.6/8.14.6/Submit) id r14B6kZR028804 for freebsd-java@FreeBSD.org; Mon, 4 Feb 2013 11:06:46 GMT (envelope-from owner-bugmaster@FreeBSD.org) Date: Mon, 4 Feb 2013 11:06:46 GMT Message-Id: <201302041106.r14B6kZR028804@freefall.freebsd.org> X-Authentication-Warning: freefall.freebsd.org: gnats set sender to owner-bugmaster@FreeBSD.org using -f From: FreeBSD bugmaster To: freebsd-java@FreeBSD.org Subject: Current problem reports assigned to freebsd-java@FreeBSD.org X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 11:06:47 -0000 Note: to view an individual PR, use: http://www.freebsd.org/cgi/query-pr.cgi?pr=(number). The following is a listing of current problems submitted by FreeBSD users. These represent problem reports covering all versions including experimental development code and obsolete releases. S Tracker Resp. Description -------------------------------------------------------------------------------- o ports/175300 java java/jamvm fails to compile on ARM6 (raspberry-pi) o ports/174826 java java/openjdk6: gmake[5]: *** [/usr/ports/java/openjdk6 o ports/174825 java java/openjdk6: fails to build on i386 (64-bit mode not o java/173981 java Vuze and Java Errors o ports/173603 java java/icedtea-web starts javaws incorrectly o java/173592 java java/openjdk6 fails on FreeBSD_9_1_RC2 o ports/173210 java java/openjdk6 - use better src placement o java/172962 java Sig11 while compiling OpenJDK6-b26 using clang o ports/171014 java [patch] Correct java/openjdk6 Dependency Declaration o ports/167903 java [PATCH] java/openjdk6: Fix build failure in 8.3 jail r o ports/164941 java [UPDATE] [NEW PORTS] java/classpath-initial, including o ports/162991 java java/openjdk6 fails to build o java/162522 java OpenJDK 6 is not setting close on exec o java/160553 java Jaikoz java based audio tagger core dumps o ports/159787 java java/openjdk6 nio muti-thread bug o ports/154884 java java/openjdk6: Every NetBeans version on FreeBSD 8.1 c f java/147512 java Crash of RXTX-2.1-7 on AMD64 system o java/140002 java java/openjdk6: jconsole dumps tomcat when contacting j o java/128809 java JVM aborted when GNU RXTX write to serial port. o java/123555 java linux-sun-jdk15, linux-sun-jdk16 produce a coredump o java/122513 java native JDKs unbuildable with Linux ones o ports/119732 java java/linux-sun-jre16: linux-sun-jre16 plugin doesn't w o java/119063 java An unexpected error has been detected by Java Runtime o ports/116082 java java/linux-sun-jdk16 jconsole is unable to connect to 24 problems total. From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 13:17:28 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 2D9F978 for ; Mon, 4 Feb 2013 13:17:28 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id 86B2D1B23 for ; Mon, 4 Feb 2013 13:17:26 +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 r14DHMFp098969 for ; Mon, 4 Feb 2013 15:17:22 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r14DHMtX098968 for freebsd-java@freebsd.org; Mon, 4 Feb 2013 15:17:22 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios To: freebsd-java@freebsd.org Subject: FreeBSD pl/java problem : backend hangs Date: Mon, 04 Feb 2013 15:17:22 +0200 Message-ID: <5933829.WYzpjKtO0p@smadev.internal.net> Organization: Dynacom Tankers Mgmt X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_; f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO` a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct} ^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 13:17:28 -0000 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 From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 13:44:46 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 1C6539FB for ; Mon, 4 Feb 2013 13:44:46 +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 7A92D1CDF for ; Mon, 4 Feb 2013 13:44:44 +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 r14DGc6E098958 for ; Mon, 4 Feb 2013 15:16:38 +0200 (EET) (envelope-from achill@smadev.internal.net) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r14DGc0B098957 for freebsd-java@freebsd.org; Mon, 4 Feb 2013 15:16:38 +0200 (EET) (envelope-from achill@smadev.internal.net) From: Achilleas Mantzios To: freebsd-java@freebsd.org Subject: FreeBSD pl/java problem : backend hangs Date: Mon, 04 Feb 2013 15:16:38 +0200 Message-ID: <1624161.qcCm5cgsyy@smadev.internal.net> Organization: Dynacom Tankers Mgmt User-Agent: KMail/4.8.4 (FreeBSD/8.3-RELEASE; KDE/4.8.4; amd64; ; ) MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="utf-8" X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: itdev@smadev.internal.net List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 13:44:46 -0000 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 From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 13:47: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 C89C1A6A for ; Mon, 4 Feb 2013 13:47:22 +0000 (UTC) (envelope-from ronald-freebsd8@klop.yi.org) Received: from smarthost1.greenhost.nl (smarthost1.greenhost.nl [195.190.28.78]) by mx1.freebsd.org (Postfix) with ESMTP id 60A081D05 for ; Mon, 4 Feb 2013 13:47:22 +0000 (UTC) Received: from smtp.greenhost.nl ([213.108.104.138]) by smarthost1.greenhost.nl with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1U2MOA-00062A-LM; Mon, 04 Feb 2013 14:47:15 +0100 Received: from [81.21.138.17] (helo=ronaldradial.versatec.local) by smtp.greenhost.nl with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.72) (envelope-from ) id 1U2MOA-000207-8s; Mon, 04 Feb 2013 14:47:14 +0100 Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes To: freebsd-java@freebsd.org, "Achilleas Mantzios" Subject: Re: FreeBSD pl/java problem : backend hangs References: <5933829.WYzpjKtO0p@smadev.internal.net> Date: Mon, 04 Feb 2013 14:47:13 +0100 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: "Ronald Klop" Message-ID: In-Reply-To: <5933829.WYzpjKtO0p@smadev.internal.net> User-Agent: Opera Mail/12.13 (Win32) X-Virus-Scanned: by clamav at smarthost1.samage.net X-Spam-Level: + X-Spam-Score: 1.9 X-Spam-Status: No, score=1.9 required=5.0 tests=BAYES_50, URI_HEX autolearn=disabled version=3.3.1 X-Scan-Signature: 01ccc3eb840dc35651f50b798cb06ae8 X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 13:47:22 -0000 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 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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-java > To unsubscribe, send any mail to "freebsd-java-unsubscribe@freebsd.org" From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 14:09:59 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 58041C20 for ; Mon, 4 Feb 2013 14:09:59 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id 8E40F1DB1 for ; Mon, 4 Feb 2013 14:09:57 +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 r14E9uXQ001405; Mon, 4 Feb 2013 16:09:56 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r14E9utA001404; Mon, 4 Feb 2013 16:09:56 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios To: Ronald Klop , freebsd-java@freebsd.org Subject: Re: Re: FreeBSD pl/java problem : backend hangs Date: Mon, 04 Feb 2013 16:09:56 +0200 Message-ID: <2555655.RMjoVHmAxh@smadev.internal.net> Organization: Dynacom Tankers Mgmt X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_; f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO` a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct} ^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR References: <5933829.WYzpjKtO0p@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 List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 14:09:59 -0000 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.(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 > 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 From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 15:16:30 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 846AD864 for ; Mon, 4 Feb 2013 15:16:30 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id A0C4617F for ; Mon, 4 Feb 2013 15:16:28 +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 r14FGRva005427 for ; Mon, 4 Feb 2013 17:16:27 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r14FGRcb005426 for freebsd-java@freebsd.org; Mon, 4 Feb 2013 17:16:27 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios To: freebsd-java@freebsd.org Subject: Re: Re: Re: FreeBSD pl/java problem : backend hangs Date: Mon, 04 Feb 2013 17:16:27 +0200 Message-ID: <1794514.P32sUeWV4B@smadev.internal.net> Organization: Dynacom Tankers Mgmt X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_; f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO` a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct} ^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR References: <5933829.WYzpjKtO0p@smadev.internal.net> <2555655.RMjoVHmAxh@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 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:16:30 -0000 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 ba= ck to this list for more. On =CE=94=CE=B5=CF=85 04 =CE=A6=CE=B5=CE=B2 2013 16:09:56 Achilleas Man= tzios wrote: > Thanx Ronald, >=20 > postgres@smadev:~> jstack 384 > 384: Unable to open socket file: target process not responding or Hot= Spot 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.InvocationTargetExceptio= n > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method= ) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc= cessorImpl.java:57) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating= MethodAccessorImpl.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.checkAlign= ment(BsdDebuggerLocal.java:181) > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readCInteger= (BsdDebuggerLocal.java:478) > at sun.jvm.hotspot.debugger.DebuggerBase.readAddressValue(Deb= uggerBase.java:454) > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readAddress(= BsdDebuggerLocal.java:423) > at sun.jvm.hotspot.debugger.bsd.BsdAddress.getAddressAt(BsdAd= dress.java:74) > at sun.jvm.hotspot.HotSpotTypeDataBase.readVMTypes(HotSpotTyp= eDataBase.java:108) > at sun.jvm.hotspot.HotSpotTypeDataBase.(HotSpotTypeData= Base.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.j= ava: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 backen= d. > > > > > > 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|SIGKIL= L|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCHLD= |SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGIN= FO|SIGUSR1|SIGUSR2,0x0) =20 > > > =3D 0 (0x0) > > > sigprocmask(SIG_SETMASK,0x0,0x0) =3D 0 (0x0) > > > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SIGKIL= L|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIGCHLD= |SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGIN= FO|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= an =20 > > > _umtx_op but all those point > > > to threading problems that now are solved. I found nothing modern= about =20 > > > _umtx_op. > > > > > > I know FreeBSD is not a "Tier-1" platform for postgresql (nor jav= a), 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 w= ith =20 > > > FreeBSD? > > > > > > Also read this =20 > > > http://postgresql.1045698.n5.nabble.com/Java-VM-stalls-during-quo= t-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@freebs= d.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.or= g" - Achilleas Mantzios IT DEV IT DEPT Dynacom Tankers Mgmt 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 From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 17:00:21 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 E3AE1487 for ; Mon, 4 Feb 2013 17:00:21 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id EC9ABA72 for ; Mon, 4 Feb 2013 17:00:20 +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 r14H0JvE008151 for ; Mon, 4 Feb 2013 19:00:19 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r14H0I66008150 for freebsd-java@freebsd.org; Mon, 4 Feb 2013 19:00:18 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios To: freebsd-java@freebsd.org Subject: Re: Re: Re: Re: Re: FreeBSD pl/java problem : backend hangs Date: Mon, 04 Feb 2013 19:00:18 +0200 Message-ID: <1917151.YiRb4P31Ma@smadev.internal.net> Organization: Dynacom Tankers Mgmt X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_; f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO` a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct} ^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR References: <5933829.WYzpjKtO0p@smadev.internal.net> <1794514.P32sUeWV4B@smadev.internal.net> <3454957.mdnJNsQM6V@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 List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 17:00:22 -0000 It surely is a problem with running JNI from within postgresql in FreeB= SD : Wrote a very small C postgresql function which simply calls JNI and it hangs as well. #include "postgres.h" =20 #include "utils/elog.h" #include "utils/palloc.h" #include "utils/array.h" #include "utils/builtins.h" #include "storage/bufpage.h" #include "catalog/pg_type.h" #include PG_MODULE_MAGIC; PG_FUNCTION_INFO_V1(jnitest); Datum jnitest(PG_FUNCTION_ARGS); Datum jnitest(PG_FUNCTION_ARGS) { int res; JNIEnv *env; JavaVM *jvm; JavaVMInitArgs vm_args; JavaVMOption *options=3DNULL; vm_args.version =3D 0x00010002; vm_args.options =3D options; vm_args.nOptions =3D 0; vm_args.ignoreUnrecognized =3D JNI_TRUE; /* Create the Java VM */ res =3D JNI_CreateJavaVM(&jvm, (void**)&env, &vm_args); PG_RETURN_POINTER(res); } create function jnitest() RETURNS integer LANGUAGE c AS '$libdir/jnites= t', 'jnitest'; dynacom=3D# select jnitest(); ^^^ hangs, it seems the call to res =3D JNI_CreateJavaVM(&jvm, (void**)= &env, &vm_args); just never completes So, this must be a FreeBSD/PostgreSQL/JNI thing. Any help/where to go from here would be very welcome. On =CE=94=CE=B5=CF=85 04 =CE=A6=CE=B5=CE=B2 2013 17:48:20 Achilleas Man= tzios wrote: > It seems that it gets hung in JNI_CreateJavaVM. >=20 > I can write and run standalone JNI programs outside postgrsesql (even= as postgres user), > but when i try to run it from within postgres, then it gets hang. >=20 > Any ideas? >=20 > On =CE=94=CE=B5=CF=85 04 =CE=A6=CE=B5=CE=B2 2013 17:16:27 Achilleas M= antzios 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 = the problem > >=20 > > Lets wait for some recommendation/help from there, and then i'll ge= t 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= Mantzios wrote: > > > Thanx Ronald, > > >=20 > > > postgres@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 respondi= ng > > >=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.InvocationTargetExce= ption > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Me= thod) > > > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMeth= odAccessorImpl.java:57) > > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega= tingMethodAccessorImpl.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: Tr= ying to read at address: 0x746f705c6c4f4867 with alignment: 4 > > > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal$1.checkA= lignment(BsdDebuggerLocal.java:181) > > > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readCInt= eger(BsdDebuggerLocal.java:478) > > > at sun.jvm.hotspot.debugger.DebuggerBase.readAddressValue= (DebuggerBase.java:454) > > > at sun.jvm.hotspot.debugger.bsd.BsdDebuggerLocal.readAddr= ess(BsdDebuggerLocal.java:423) > > > at sun.jvm.hotspot.debugger.bsd.BsdAddress.getAddressAt(B= sdAddress.java:74) > > > at sun.jvm.hotspot.HotSpotTypeDataBase.readVMTypes(HotSpo= tTypeDataBase.java:108) > > > at sun.jvm.hotspot.HotSpotTypeDataBase.(HotSpotType= DataBase.java:85) > > > at sun.jvm.hotspot.bugspot.BugSpotAgent.setupVM(BugSpotAg= ent.java:574) > > > at sun.jvm.hotspot.bugspot.BugSpotAgent.go(BugSpotAgent.j= ava:495) > > > at sun.jvm.hotspot.bugspot.BugSpotAgent.attach(BugSpotAge= nt.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 ba= ckend. > > > > > > > > > > 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|SI= GKILL|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIG= CHLD|SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|S= IGINFO|SIGUSR1|SIGUSR2,0x0) =20 > > > > > =3D 0 (0x0) > > > > > sigprocmask(SIG_SETMASK,0x0,0x0) =3D 0 (0x0) > > > > > sigprocmask(SIG_BLOCK,SIGHUP|SIGINT|SIGQUIT|SIGABRT|SIGEMT|SI= GKILL|SIGSYS|SIGPIPE|SIGALRM|SIGTERM|SIGURG|SIGSTOP|SIGTSTP|SIGCONT|SIG= CHLD|SIGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|S= IGINFO|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,0x8016167= d8,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,0x8016167= d8,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 a= fter an =20 > > > > > _umtx_op but all those point > > > > > to threading problems that now are solved. I found nothing mo= dern about =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 wo= rk with =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@fr= eebsd.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@freebs= d.org" > > - > > Achilleas Mantzios > > IT DEV > > IT DEPT > > Dynacom Tankers Mgmt > - > Achilleas Mantzios > IT DEV > IT DEPT > _______________________________________________ > freebsd-java@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-java > To unsubscribe, send any mail to "freebsd-java-unsubscribe@freebsd.or= g" - Achilleas Mantzios IT DEV IT DEPT Dynacom Tankers Mgmt From owner-freebsd-java@FreeBSD.ORG Mon Feb 4 17:19:05 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 5F3FC9E2 for ; Mon, 4 Feb 2013 17:19:05 +0000 (UTC) (envelope-from kostikbel@gmail.com) Received: from kib.kiev.ua (kib.kiev.ua [IPv6:2001:470:d5e7:1::1]) by mx1.freebsd.org (Postfix) with ESMTP id 9D437B8B for ; Mon, 4 Feb 2013 17:19:04 +0000 (UTC) Received: from tom.home (kostik@localhost [127.0.0.1]) by kib.kiev.ua (8.14.6/8.14.6) with ESMTP id r14HIxwu016113; Mon, 4 Feb 2013 19:18:59 +0200 (EET) (envelope-from kostikbel@gmail.com) DKIM-Filter: OpenDKIM Filter v2.7.4 kib.kiev.ua r14HIxwu016113 Received: (from kostik@localhost) by tom.home (8.14.6/8.14.6/Submit) id r14HIxch016112; Mon, 4 Feb 2013 19:18:59 +0200 (EET) (envelope-from kostikbel@gmail.com) X-Authentication-Warning: tom.home: kostik set sender to kostikbel@gmail.com using -f Date: Mon, 4 Feb 2013 19:18:59 +0200 From: Konstantin Belousov To: Achilleas Mantzios Subject: Re: Re: Re: Re: Re: FreeBSD pl/java problem : backend hangs Message-ID: <20130204171859.GB2522@kib.kiev.ua> References: <5933829.WYzpjKtO0p@smadev.internal.net> <1794514.P32sUeWV4B@smadev.internal.net> <3454957.mdnJNsQM6V@smadev.internal.net> <1917151.YiRb4P31Ma@smadev.internal.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="g7RZQ2HC70+y+NLc" Content-Disposition: inline In-Reply-To: <1917151.YiRb4P31Ma@smadev.internal.net> User-Agent: Mutt/1.5.21 (2010-09-15) X-Spam-Status: No, score=-0.9 required=5.0 tests=ALL_TRUSTED,BAYES_00, DKIM_ADSP_CUSTOM_MED,FREEMAIL_FROM,NML_ADSP_CUSTOM_MED,URI_HEX autolearn=no version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on tom.home Cc: freebsd-java@freebsd.org X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Feb 2013 17:19:05 -0000 --g7RZQ2HC70+y+NLc Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Feb 04, 2013 at 07:00:18PM +0200, Achilleas Mantzios wrote: > It surely is a problem with running JNI from within postgresql in FreeBSD= : >=20 > Wrote a very small C postgresql function which simply calls JNI > and it hangs as well. >=20 > #include "postgres.h" > =20 > #include "utils/elog.h" > #include "utils/palloc.h" > #include "utils/array.h" > #include "utils/builtins.h" > #include "storage/bufpage.h" > #include "catalog/pg_type.h" >=20 > #include >=20 > PG_MODULE_MAGIC; >=20 > PG_FUNCTION_INFO_V1(jnitest); > Datum jnitest(PG_FUNCTION_ARGS); >=20 > Datum > jnitest(PG_FUNCTION_ARGS) > { > int res; > JNIEnv *env; > JavaVM *jvm; > JavaVMInitArgs vm_args; > JavaVMOption *options=3DNULL; > vm_args.version =3D 0x00010002; > vm_args.options =3D options; > vm_args.nOptions =3D 0; > vm_args.ignoreUnrecognized =3D JNI_TRUE; > /* Create the Java VM */ > res =3D JNI_CreateJavaVM(&jvm, (void**)&env, &vm_args); >=20 > PG_RETURN_POINTER(res); > } >=20 > create function jnitest() RETURNS integer LANGUAGE c AS '$libdir/jnitest'= , 'jnitest'; >=20 > dynacom=3D# select jnitest(); >=20 > ^^^ hangs, it seems the call to res =3D JNI_CreateJavaVM(&jvm, (void**)&e= nv, &vm_args); > just never completes >=20 > So, this must be a FreeBSD/PostgreSQL/JNI thing. >=20 > Any help/where to go from here would be very welcome. Try to start the postgres daemon with 'LD_PRELOAD=3D/lib/libthr.so.3' env variable set. >=20 > On ?????? 04 ?????? 2013 17:48:20 Achilleas Mantzios wrote: > > It seems that it gets hung in JNI_CreateJavaVM. > >=20 > > 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. > >=20 > > Any ideas? > >=20 > > On ?????? 04 ?????? 2013 17:16:27 Achilleas Mantzios 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 ?????? 04 ?????? 2013 16:09:56 Achilleas Mantzios 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= =2Ejava:333) > > > > at sun.jvm.hotspot.tools.Tool.start(Tool.java:163) > > > > at sun.jvm.hotspot.tools.JStack.main(JStack.java:86) > > > >=20 > > > >=20 > > > > On ???????????? 04 ??????????=9D 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|SIGCHLD|S= IGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGINFO|SIG= USR1|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|SIGCHLD|S= IGTTIN|SIGTTOU|SIGIO|SIGXCPU|SIGXFSZ|SIGVTALRM|SIGPROF|SIGWINCH|SIGINFO|SIG= USR1|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 > > _______________________________________________ > > 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 > _______________________________________________ > 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" --g7RZQ2HC70+y+NLc Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iQIcBAEBAgAGBQJRD+2CAAoJEJDCuSvBvK1BltQP/2VRLGT7KVfdWb1Dq+/deY8k 5YyYfUAjvyhfHrgu5IXat46IXDqRDUEA8ebpD1cCAVryw0FiP+r+tyPXcUBNLyOA O3YXQI4ribe9AK9Eygl/zeEuQ3jVFxuZMi2KHNYOSNDo5pHbLu7wYtlZYt9dsZ1I du0fVssLfQZ22soUOsjO7mUS55IFqPjYIVE9gJSM7J+t7n/+PdwH8i1s5hL/rADB 1u69LYUGf9vWaZvbcroB7qpeDOAuQ2qoVlmvKDMWpCQ+zYdgv+xIuEODbUTbhb/l Sm52nM5nhdwXCNuE8AS91JvX7Sz8v/zlQXobVLBUpvWPjitUk+HPpghHgACxKlbC zhw/my4vHZmZIC0bfPhjpDcw1wUQ+SFGNDpsVropLLgsZqDEBUe7ZtMuVqR+B8RV 6Jf+rY21RT6xdbLvmffrbxOjNcFXS5y71S1C+BCqg+RQEbFyOnThOwFq+6xlgJfy ZZXhWN0PjLceeB809BkTzGeShCpy22Si5LGY3nWe2nevVXOsRMkIjrrDxo8jbm7m DrV+i44Dk+MN3ETCbafyqRmC94f1ootWurXfhHpAdfEhG1anql6Ondo975nXwVN6 9vJlknOqw6AAMP2SLB/hyE3gY5Pw1MUGEBlTof+BYdl63c/obD3O0gK0CMk/m66W AxrSBiU0nzvpFwAbowrE =CBaQ -----END PGP SIGNATURE----- --g7RZQ2HC70+y+NLc-- From owner-freebsd-java@FreeBSD.ORG Tue Feb 5 08:38:22 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 1051C47C for ; Tue, 5 Feb 2013 08:38:22 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id 5A6BCEC3 for ; Tue, 5 Feb 2013 08:38:20 +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 r158cI3C002021; Tue, 5 Feb 2013 10:38:18 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r158cIvt002020; Tue, 5 Feb 2013 10:38:18 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios To: Konstantin Belousov , freebsd-java@freebsd.org Subject: Re: Re: Re: Re: Re: Re: FreeBSD pl/java problem : backend hangs Date: Tue, 05 Feb 2013 10:38:18 +0200 Message-ID: <1779006.4dHUJtq5BK@smadev.internal.net> Organization: Dynacom Tankers Mgmt X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_; f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO` a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct} ^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR References: <5933829.WYzpjKtO0p@smadev.internal.net> <1917151.YiRb4P31Ma@smadev.internal.net> <20130204171859.GB2522@kib.kiev.ua> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="ISO-8859-1" X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 05 Feb 2013 08:38:22 -0000 On =CE=94=CE=B5=CF=85 04 =CE=A6=CE=B5=CE=B2 2013 19:18:59 you wrote: > Try to start the postgres daemon with 'LD_PRELOAD=3D/lib/libthr.so.3'= > env variable set. Thanx, i tried with this, inside postgresql startup script with no luck= . I also saw this thread here : http://www.postgresql.org/message-id/68c4= 29ede4cde3874b37460b5b1d4aaf@cs.helsinki.fi (but could not find its continuation over the FreeBSD camp) The author claims that postgres backend executable must be linked with = -lpthread. Inside postgres's Makefile.global i can see=20 PTHREAD_CFLAGS =3D -pthread -D_REENTRANT -D_THREAD_SAFE -D_PO= SIX_PTHREAD_SEMANTICS THREAD_LIBS =3D -lpthread however when i do=20 root@smadev:/usr/local/src/postgresql-9.2.2# ldd /usr/local/pgsql/bin/p= ostgres /usr/local/pgsql/bin/postgres: libm.so.5 =3D> /lib/libm.so.5 (0x800ae5000) libldap-2.4.so.8 =3D> /usr/local/lib/libldap-2.4.so.8 (0x800c05= 000) libc.so.7 =3D> /lib/libc.so.7 (0x800d47000) liblber-2.4.so.8 =3D> /usr/local/lib/liblber-2.4.so.8 (0x800f89= 000) libssl.so.6 =3D> /usr/lib/libssl.so.6 (0x801096000) libcrypto.so.6 =3D> /lib/libcrypto.so.6 (0x8011e9000) i see nothing thread (libpthread or libtrh) related. Any help to overcome this much appreciated. >=20 > >=20 - Achilleas Mantzios IT DEV IT DEPT Dynacom Tankers Mgmt From owner-freebsd-java@FreeBSD.ORG Tue Feb 5 10:33:42 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 0BB6617C for ; Tue, 5 Feb 2013 10:33:42 +0000 (UTC) (envelope-from achill@matrix.gatewaynet.com) Received: from smadev.internal.net (adsltrust.ath.forthnet.gr [194.219.204.174]) by mx1.freebsd.org (Postfix) with ESMTP id F2A94C32 for ; Tue, 5 Feb 2013 10:33:40 +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 r15AXcA1037145; Tue, 5 Feb 2013 12:33:38 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: (from achill@localhost) by smadev.internal.net (8.14.5/8.14.5/Submit) id r15AXcqK037144; Tue, 5 Feb 2013 12:33:38 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) X-Authentication-Warning: smadev.internal.net: achill set sender to achill@matrix.gatewaynet.com using -f From: Achilleas Mantzios To: freebsd-java@freebsd.org Subject: Re: Re: Re: Re: Re: Re: Re: FreeBSD pl/java problem : backend hangs : Solved Date: Tue, 05 Feb 2013 12:33:37 +0200 Message-ID: <1671376.BVdjYkz6LH@smadev.internal.net> Organization: Dynacom Tankers Mgmt X-Face: "g.Z.Lx$T1ZMcQ%hC!e^E&tD,cT:"bTs45WM(,vUj@8QBz6}T'sn+EnZTzy`UVQ:&A=`_; f)V+K4z}rG5:(uu[b:WY'*`6F"ou-Or(q; u{#Gxx|MkO4E.vh@E}[#7Ytt"shtU>A&@CO` a|Wx]m_wRD,?4!'Ir1$4iis{/.WU<`#dhKI]g2w^!B[CvRJr+W|; -VS~QcL!s1"'??rct} ^=5Fa!W!{a}Jd:W%6,E[N\r-<)T'_N[~3fy9pF"b>-Yj^p}/2tPudP>I"$%w]"W4CIja6J Tajm}"8t`-hJlf2kRQ_V,eT_kN6KLG+~2mZ+cPX,p,xQN9QVR References: <5933829.WYzpjKtO0p@smadev.internal.net> <20130204171859.GB2522@kib.kiev.ua> <1779006.4dHUJtq5BK@smadev.internal.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: Konstantin Belousov X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 05 Feb 2013 10:33:42 -0000 Thank you Konstantin. After much playing around finally i experimented putting in /usr/local/= src/postgresql-9.2.2/src/backend/Makefile : postgres: $(OBJS) $(CC) $(CFLAGS) $(LDFLAGS) $(LDFLAGS_EX) $(export_dynamic) $(ca= ll expand_subsys,$^) $(LIBS) -lpthread -o $@ i.e. explicitly linking the postgres backend to /usr/lib/libpthread.so = which is a symlink to /usr/lib/libthr.so which is a symlink to /lib/lib= thr.so.3 , did the trick. root@smadev:/usr/local/src/postgresql-9.2.2# ldd /usr/local/pgsql/bin/p= ostgres /usr/local/pgsql/bin/postgres: libm.so.5 =3D> /lib/libm.so.5 (0x800ae5000) libldap-2.4.so.8 =3D> /usr/local/lib/libldap-2.4.so.8 (0x800c05= 000) libthr.so.3 =3D> /lib/libthr.so.3 (0x800d47000) libc.so.7 =3D> /lib/libc.so.7 (0x800e60000) liblber-2.4.so.8 =3D> /usr/local/lib/liblber-2.4.so.8 (0x8010a2= 000) libssl.so.6 =3D> /usr/lib/libssl.so.6 (0x8011af000) libcrypto.so.6 =3D> /lib/libcrypto.so.6 (0x801302000) I had the first good results from pl/java :) On =CE=A4=CF=81=CE=B9 05 =CE=A6=CE=B5=CE=B2 2013 10:38:18 Achilleas Man= tzios wrote: > 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 19:18:59 you wrote: >=20 > > Try to start the postgres daemon with 'LD_PRELOAD=3D/lib/libthr.so.= 3' > > env variable set. >=20 > Thanx, i tried with this, inside postgresql startup script with no lu= ck. > I also saw this thread here : http://www.postgresql.org/message-id/68= c429ede4cde3874b37460b5b1d4aaf@cs.helsinki.fi > (but could not find its continuation over the FreeBSD camp) > The author claims that postgres backend executable must be linked wit= h -lpthread. > Inside postgres's Makefile.global i can see=20 > PTHREAD_CFLAGS =3D -pthread -D_REENTRANT -D_THREAD_SAFE -D_= POSIX_PTHREAD_SEMANTICS > THREAD_LIBS =3D -lpthread > however when i do=20 >=20 > root@smadev:/usr/local/src/postgresql-9.2.2# ldd /usr/local/pgsql/bin= /postgres > /usr/local/pgsql/bin/postgres: > libm.so.5 =3D> /lib/libm.so.5 (0x800ae5000) > libldap-2.4.so.8 =3D> /usr/local/lib/libldap-2.4.so.8 (0x800c= 05000) > libc.so.7 =3D> /lib/libc.so.7 (0x800d47000) > liblber-2.4.so.8 =3D> /usr/local/lib/liblber-2.4.so.8 (0x800f= 89000) > libssl.so.6 =3D> /usr/lib/libssl.so.6 (0x801096000) > libcrypto.so.6 =3D> /lib/libcrypto.so.6 (0x8011e9000) >=20 > i see nothing thread (libpthread or libtrh) related. >=20 > Any help to overcome this much appreciated. >=20 > >=20 > > >=20 >=20 > - > 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.or= g" - Achilleas Mantzios IT DEV IT DEPT Dynacom Tankers Mgmt From owner-freebsd-java@FreeBSD.ORG Wed Feb 6 18:49:04 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id D923A8F9 for ; Wed, 6 Feb 2013 18:49:04 +0000 (UTC) (envelope-from dmyshkin@gmail.com) Received: from mail-ob0-f182.google.com (mail-ob0-f182.google.com [209.85.214.182]) by mx1.freebsd.org (Postfix) with ESMTP id AD10217B for ; Wed, 6 Feb 2013 18:49:04 +0000 (UTC) Received: by mail-ob0-f182.google.com with SMTP id va7so1807477obc.13 for ; Wed, 06 Feb 2013 10:48:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:date:message-id:subject:from:to :content-type; bh=5p2ofLJC+U/dMLxyGd3SeH4uCfmmW8yvBXD63kYBf2w=; b=eDrGIRBoTvVWCYMPM1eoJ67il1p/hgCarA2LVz4wdRqJyja71tQ2QPU1xgQsV7tZEj 8OvA8wteZ69k/PvW77GwjGCPmImFKqngITFxl9TDduwIga2u/LyxlNjJKvqhVWxeCspA oBa8PhvBSIzSpVaIlWHVacPPsPHhtN+5Dejrip9qnUjDPEVJ51riMrmY13VPeXxUzXlg ZTnuJtuchURfGa6dUbavyQljwoOEOg2GLZoDalBZHl8VOXrDUwm8V6/9MoIDnqKYQzFt 5xgLZZck085PQYfZ8/YWYzaewNhMZHapIpgv64YIBdtF20+mt9SG6bsSgFCZMPUzzwjH 4WTA== MIME-Version: 1.0 X-Received: by 10.182.17.70 with SMTP id m6mr21652462obd.39.1360176538047; Wed, 06 Feb 2013 10:48:58 -0800 (PST) Received: by 10.76.171.195 with HTTP; Wed, 6 Feb 2013 10:48:57 -0800 (PST) Date: Wed, 6 Feb 2013 19:48:57 +0100 Message-ID: Subject: compiling JDK From: Dmitriy Myshkin To: freebsd-java@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.14 X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 Feb 2013 18:49:04 -0000 has anyone gotten the Java port SDK to compile? If so do you have anywhere documented the steps? I want to bash my head into a wall... From owner-freebsd-java@FreeBSD.ORG Wed Feb 6 18:56:38 2013 Return-Path: Delivered-To: freebsd-java@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id DBBA39EB for ; Wed, 6 Feb 2013 18:56:38 +0000 (UTC) (envelope-from ronald-freebsd8@klop.yi.org) Received: from cpsmtpb-ews07.kpnxchange.com (cpsmtpb-ews07.kpnxchange.com [213.75.39.10]) by mx1.freebsd.org (Postfix) with ESMTP id 531411C1 for ; Wed, 6 Feb 2013 18:56:37 +0000 (UTC) Received: from cpsps-ews04.kpnxchange.com ([10.94.84.171]) by cpsmtpb-ews07.kpnxchange.com with Microsoft SMTPSVC(7.5.7601.17514); Wed, 6 Feb 2013 19:54:14 +0100 Received: from CPSMTPM-TLF101.kpnxchange.com ([195.121.3.4]) by cpsps-ews04.kpnxchange.com with Microsoft SMTPSVC(7.5.7601.17514); Wed, 6 Feb 2013 19:54:14 +0100 Received: from sjakie.klop.ws ([212.182.167.131]) by CPSMTPM-TLF101.kpnxchange.com with Microsoft SMTPSVC(7.5.7601.17514); Wed, 6 Feb 2013 19:55:29 +0100 Received: from 212-182-167-131.ip.telfort.nl (localhost [127.0.0.1]) by sjakie.klop.ws (Postfix) with ESMTP id ED1BC6087 for ; Wed, 6 Feb 2013 19:55:29 +0100 (CET) Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes To: freebsd-java@freebsd.org Subject: Re: compiling JDK References: Date: Wed, 06 Feb 2013 19:55:29 +0100 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: "Ronald Klop" Message-ID: In-Reply-To: User-Agent: Opera Mail/12.13 (FreeBSD) X-OriginalArrivalTime: 06 Feb 2013 18:55:29.0849 (UTC) FILETIME=[8898F290:01CE049B] X-RcptDomain: freebsd.org X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 Feb 2013 18:56:38 -0000 On Wed, 06 Feb 2013 19:48:57 +0100, Dmitriy Myshkin wrote: > has anyone gotten the Java port SDK to compile? If so do you have > anywhere > documented the steps? What is the Java port SDK? Can you give a specific port name like /usr/ports/java/openjdk6? Ronald. > > I want to bash my head into a wall... > _______________________________________________ > 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" From owner-freebsd-java@FreeBSD.ORG Thu Feb 7 08:33:10 2013 Return-Path: Delivered-To: java@FreeBSD.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 9AF3490E for ; Thu, 7 Feb 2013 08:33:10 +0000 (UTC) (envelope-from linimon@FreeBSD.org) Received: from portsmonj.FreeBSD.org (portsmonj.freebsd.org [69.147.83.46]) by mx1.freebsd.org (Postfix) with ESMTP id 77ABCCD7 for ; Thu, 7 Feb 2013 08:33:10 +0000 (UTC) Received: from portsmonj.freebsd.org (portsmonj.freebsd.org [69.147.83.46]) by portsmonj.FreeBSD.org (8.14.5/8.14.4) with ESMTP id r178SKxJ033894 for ; Thu, 7 Feb 2013 08:28:20 GMT (envelope-from linimon@FreeBSD.org) Date: Thu, 7 Feb 2013 08:28:20 GMT Message-Id: <201302070828.r178SKxJ033894@portsmonj.FreeBSD.org> From: linimon@FreeBSD.org To: java@FreeBSD.org Subject: FreeBSD ports that you maintain which are currently marked broken X-BeenThere: freebsd-java@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: portmgr-feedback@FreeBSD.org List-Id: Porting Java to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 07 Feb 2013 08:33:10 -0000 Dear FreeBSD port maintainer: As part of an ongoing effort to reduce the number of problems in the FreeBSD ports system, we periodically notify users of ports that are marked as "broken" in their Makefiles. In many cases these ports are failing to compile on some subset of the FreeBSD build environments. The most common problem is that recent versions of -CURRENT include gcc4.2, which is much stricter than older versions. The next most common problem is that compiles succeed on the i386 architecture (e.g. the common Intel PC), but fail on one or more of the other architectures due to assumptions about things such as size of various types, byte-alignment issues, and so forth. In occasional cases we see that the same port may have different errors in different build environments. The script that runs on the build cluster uses heuristics to try to 'guess' the error type to help you isolate problems, but it is only a rough guide. One more note: on occasion, there are transient build errors seen on the build farm. Unfortunately, there is not yet any way for this algorithm to tell the difference (humans are much, much better at this kind of thing.) The errors are listed below. In the case where the same problem exists on more than one build environment, the URL points to the latest errorlog for that type. (By 'build environment' here we mean 'combination of 7.x/8.x/9.x/-current with target architecture'.) (Note: the dates are included to help you to gauge whether or not the error still applies to the latest version. The program that generates this report is not yet able to determine this automatically.) portname: java/jai-imageio broken because: relies on linuxpluginwrapper build errors: none. overview: http://portsmon.FreeBSD.org/portoverview.py?category=java&portname=jai-imageio If these errors are ones that you are already aware of, please accept our apologies and ignore this message. On the other hand, if you no longer wish to maintain this port (or ports), please reply with a message stating that, and accept our thanks for your efforts in the past. Every effort has been made to make sure that these error reports really do correspond to a port that you maintain. However, due to the fact that this is an automated process, it may indeed generate false matches. If one of these errors fits that description, please forward this email to the author of this software, Mark Linimon , so that he can attempt to fix the problem in the future. Thanks for your efforts to help improve FreeBSD.