Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <473B6AF4.2080700@linagora.com>
Date: Wed, 14 Nov 2007 22:39:00 +0100
From: Lionel Crine <lcrine@linagora.com>
User-Agent: Icedove 1.5.0.14pre (X11/20071020)
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Tomcat freeze after some times
References: <12404032.post@talk.nabble.com>
 <46D6CAA4.60808@christopherschultz.net> <12421410.post@talk.nabble.com>
 <46DDC171.8010805@christopherschultz.net> <12491835.post@talk.nabble.com>
In-Reply-To: <12491835.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I had this situation once few years ago.
I was working and I discovered that the pool was exhausted to access 
Oracle and the application stucked.
It was really tricky to find the error because nothing indicates a problem.

The explanation was this one : A dynamic query (created in java) doing 
some imbricated requests froze the database access.
So the query was never ending, waiting for a new connection to continue 
requesting ... and so on.


Lionel


Ice72 wrote:
> Yes ... in theory.  But if was this case, in the jstack dump, we should view
> the incoming http-req
> which waiting for a pooled connection (I have a ConnPool.getConnection()
> class/method).
> 
> But ... on the dump there is anything ... P-(
> 
> 
> 
> Christopher Schultz-2 wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Ice,
>>
>> Ice72 wrote:
>>> Hi Cris,
>>>
>>> thanks for your reply. Yes: I checked the process via top/netstat/lsof
>>> and I
>>> haven't detect any 
>>> strange situation. The super-strange thing is that the other webapps, on
>>> the
>>> same tomcat-instance,
>>> continue to work when the single-app fail.
>> Sounds like a db connection pool exhaustion.
>>
>> - -chris
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.7 (MingW32)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>> iD8DBQFG3cFx9CaO5/Lv0PARAqwEAJ9G2/L/Id9b3igPx/F4AVWfqxfAMQCfTlBy
>> g8sHhqlF2PBWGDhx0ZSmwq4=
>> =j3zb
>> -----END PGP SIGNATURE-----
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>>
> 

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org