Re: session#getId changes during doGet invocation under heavy load

[Peter Coppens <pc...@gmail.com>]

Thanks, I was aware of the difference between the 2 types of getSession call.

I am using "normal" JDBC calls (prepareStatement, executeQuery or
executeUpdate, commit/rollback, ...).

I have some asynchronous processing going on through a HttpSessionListener,
which does dome final cleanup and does interact with the database. Perhaps I
messed up something in that part.

Anyway, I have done more testing and by reducing the size of the tomcat
threadpool I am getting far better results. Every now and then the client
app (jmeter) gets a 503, but that is not so bad. The server no longer locks
up and overall response times are very acceptable.

Thanks to everyone for all suggestions! It has greatly improved my knowledge
on the problems one has to deal with in this type of environments.

Peter



Martin Gainty wrote:
> 
> Also be aware of the distinction between Request.getSession(true) and
> Request.getSession(false) where
> Request.getSession(true) will attempt to create a new session (if none
> exists)
> Request.getSession(false) will NOT create a new session
> (perhaps you should use option 2)
> 
> Also which mechanism are you are using to create,prepare,execute and
> commit your DB statement?
> It appears you *may* have some asynchronous operations executing which may
> not be synchronsing to the invoking call 
> 
> M-
> --------------------------------------------------------------------------- 
> This e-mail message (including attachments, if any) is intended for the
> use of the individual or entity to which it is addressed and may contain
> information that is privileged, proprietary , confidential and exempt from
> disclosure. If you are not the intended recipient, you are notified that
> any dissemination, distribution or copying of this communication is
> strictly prohibited.
> --------------------------------------------------------------------------- 
> Le présent message électronique (y compris les pièces qui y sont annexées,
> le cas échéant) s'adresse au destinataire indiqué et peut contenir des
> renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le
> destinataire de ce document, nous vous signalons qu'il est strictement
> interdit de le diffuser, de le distribuer ou de le reproduire.
> ----- Original Message ----- 
> From: "Hassan Schroeder" <ha...@gmail.com>
> To: "Tomcat Users List" <us...@tomcat.apache.org>
> Sent: Saturday, December 30, 2006 2:39 PM
> Subject: Re: session#getId changes during doGet invocation under heavy
> load
> 
> 
>> On 12/30/06, Peter Coppens <pc...@gmail.com> wrote:
>> 
>>> That said, I am baffled by the fact that some connections take
>>> >15minutes.
>> 
>> Are you referring to MySQL connection setup time? Or query time?
>> Either way, it certainly doesn't sound like a Tomcat problem... :-)
>> 
>> -- 
>> Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
>> 
>> ---------------------------------------------------------------------
>> 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
>> 
>>
> 

-- 
View this message in context: http://www.nabble.com/session-getId-changes-during-doGet-invocation-under-heavy-load-tf2892448.html#a8121253
Sent from the Tomcat - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
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