Return-Path: Delivered-To: apmail-ibatis-dev-archive@www.apache.org Received: (qmail 23570 invoked from network); 17 May 2007 19:04:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 May 2007 19:04:38 -0000 Received: (qmail 1467 invoked by uid 500); 17 May 2007 19:04:44 -0000 Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org Received: (qmail 1232 invoked by uid 500); 17 May 2007 19:04:43 -0000 Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ibatis.apache.org Delivered-To: mailing list dev@ibatis.apache.org Received: (qmail 1158 invoked by uid 99); 17 May 2007 19:04:43 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2007 12:04:43 -0700 X-ASF-Spam-Status: No, hits=2.3 required=10.0 tests=HTML_MESSAGE,MAILTO_TO_SPAM_ADDR,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of clinton.begin@gmail.com designates 64.233.184.227 as permitted sender) Received: from [64.233.184.227] (HELO wr-out-0506.google.com) (64.233.184.227) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2007 12:04:36 -0700 Received: by wr-out-0506.google.com with SMTP id i23so687667wra for ; Thu, 17 May 2007 12:04:15 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=VO6z7pnj5S4p57i60Tr1+jI9EIPvG/PVeXbOnoAHp+WEUkAFTHwgF3cizN4HTxE1XXyyotg7OD/Ntfd3U7UQTUZLBoj3/QaH3NIu/qbFXm3m25+FjcT4Nz3o3GqI0J+GkuL8vJdhfMlEt+/gl/WaWyMmekeoTD6LoTmWNdLU7kg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=ozfd0IIljFvUcnYdcO13guricdB7YT99I7hfLZxbx7sHQlD/fioIQRs69wpnwOxnlWc2wkKuH6C/JkTytA8PkK7gf+hPxfz9Xo1mG85xsh4Qsnb1RRACNAoGCiPbMymBu6fNYvxtMNMUfJzKdh5LUq7VTwDMDtAFfw44Wx3zso0= Received: by 10.114.56.1 with SMTP id e1mr348039waa.1179428654026; Thu, 17 May 2007 12:04:14 -0700 (PDT) Received: by 10.114.136.14 with HTTP; Thu, 17 May 2007 12:04:13 -0700 (PDT) Message-ID: <16178eb10705171204r60ff1e14x66610c32cac1b7ec@mail.gmail.com> Date: Thu, 17 May 2007 13:04:13 -0600 From: "Clinton Begin" To: dev@ibatis.apache.org Subject: Re: [IBATIS-249]Race conditions in Throttle lead to thread blockage... In-Reply-To: <20070517143443.M82729@uni.edu.pe> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_43714_19098984.1179428653706" References: <20070425160155.M20728@uni.edu.pe> <16178eb10705020704p530abeedw3736438cf5482ba0@mail.gmail.com> <20070517143443.M82729@uni.edu.pe> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_43714_19098984.1179428653706 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline DELETE the configuration lines for maximum sessions, transactions and requests from your SQL Map config and try again. Let me know how if it helps. Clinton On 5/17/07, OROSCO-PACORA-CESAR ALONSO wrote: > > This look like the problem, we are change this but the problem continue. > I was see the Throttle.java and how this are working and this have manage= d > two components Transactions and sessions both with a pool of synchronized > List the transactions count are negative (-170) and the sessions count ar= e > in growing until reach 128 (the max transaction parameter in sql-map-conf= ig) > at this moment the thread are in a wait state and the server hung when re= ach > the 50 threads > > Any Idea?? > > C=E9sar > > *On Wed, 2 May 2007 08:04:48 -0600, Clinton Begin wrote* > > > It sounds more like transactions aren't being ended properly. Make sur= e > you have matching startTransaction/endtransaction pairs and make sure the > endTransaction is in a finally{} block. > > > > Though it's likely not the problem, I'd like to get rid of Throttle in > an upcoming version...even if only to forward the error onto the database= so > that it doesn't look like an ibatis race condition. ;-) > > > > Clinton > > > > On 4/25/07, OROSCO-PACORA-CESAR ALONSO wrote: > > > > > Hi, we have a enviroment in websphere, Ibatis and DB2 we are currentl= y > > work with ibatis 2.2.0 but we have a thread problem like this reported > > previously : "The application works fine for several thousand database = calls > > through iBatis. After a while, suddenly it hangs whenever it is tries t= o > > access the database through iBatis." ( > > http://issues.apache.org/jira/browse/IBATIS-249) > > > > > > Initally we have Ibatis 2.1 but we are update to 2.2.0 and the issue > > continue. > > > > > > =BFif we setting the maxWait parameter in Throttle.java "public > > Throttle(int limit, long maxWait)" this could to solve the problem? > > > > > > Any Idea? > > > > > > Thanks > > > > > > P.D. I apologize for my language! ;) > > > > > > _________________________________________________ > > > Universidad Nacional de Ingenieria (http://www.uni.edu.pe) > > > > > > > > > > > _________________________________________________ > Universidad Nacional de Ingenieria (http://www.uni.edu.pe) > > ------=_Part_43714_19098984.1179428653706 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline DELETE the configuration lines for  maximum sessions, transactions and= requests from your SQL Map config and try again.

Let me know how if= it helps.

Clinton

On 5/17/0= 7, OROSCO-PACORA-CESAR ALONSO <= a20001019@uni.edu.pe> wrote:

This look like the problem, we are change this but the = problem continue. I was see the Throttle.java and how this are working and = this have managed two components Transactions and sessions both with a= pool of synchronized List the transactions count are negative (-170) and t= he sessions count are in growing until reach 128 (the max transaction param= eter in sql-map-config) at this moment the thread are in a wait state and t= he server hung when reach the 50 threads

Any Idea??

C=E9sar

On Wed, 2 May 2007 08:04:48 -0600, Clinton Begin wro= te


> It sounds more like transactions aren't being ended proper= ly.  Make sure you have matching startTransaction/endtransaction pairs= and make sure the endTransaction is in a finally{} block. =20
>=20
> Though it's likely not the problem, I'd like to get rid of= Throttle in an upcoming version...even if only to forward the error onto t= he database so that it doesn't look like an ibatis race condition. = ; ;-)=20
>=20
> Clinton
>=20
> On 4/25/07, OROSCO-PACORA-CESAR ALONSO <a20001019@uni.edu.pe > wrote:


> Hi, we have a enviroment in websphere, Ibatis and= DB2 we are currently work with ibatis 2.2.0 but we have a thread problem l= ike this reported previously : "The application works fine for several= thousand database calls through iBatis. After a while, suddenly it hangs w= henever it is tries to access the database through iBatis." (=20 http://issues.a= pache.org/jira/browse/IBATIS-249)=20
>=20
> Initally we have Ibatis 2.1 but we are update to 2.2.0 and the iss= ue continue.=20
>=20
> =BFif we setting the maxWait parameter in Throttle.java  &quo= t;public Throttle(int limit, long maxWait)" this could to solve the pr= oblem?=20
>=20
> Any Idea?=20
>=20
> Thanks=20
>=20
> P.D. I apologize for my language! ;)=20
>=20
> _________________________________________________=20
> Universidad Nacional de Ingenieria (http://www.uni.edu.pe)=20
>=20
>



_________________________________________________=20
Universidad Nacional de Ingenieria (= http://www.uni.edu.pe)=20


------=_Part_43714_19098984.1179428653706--