You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by David Kirtland <dk...@epitiro.com> on 2011/11/02 16:30:29 UTC
Tomcat 5.5.26 running 'select_user' for every transaction
Hi,
Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny - apt
versions) we are seeing a 'select_user' query to the database for every
single transaction. This is in addition to a 'select 1' (the configured
validationQuery). Obviously this is a big overhead which I don't see that
we need.
If anyone can shed some light on what this is doing and why it's there
(and ideally if we can turn it off) that would be very helpful! I've
searched through the docs and can't really find any reference to it.
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 5.5.26 running 'select_user' for every transaction
Posted by Konstantin Kolinko <kn...@gmail.com>.
2011/11/2 David Kirtland <dk...@epitiro.com>:
> Hi,
>
> Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny - apt
> versions)
Haven't you considered upgrading to 5.5.34?
5.5.26 is better than 5.5.20 but any way it is more than 3 years old.
Though any 5.5.x version will reach its end of life in less than a
year from now.
Best regards,
Konstantin Kolinko
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 5.5.26 running 'select_user' for every transaction
Posted by Pid <pi...@pidster.com>.
On 02/11/2011 16:23, David Kirtland wrote:
> It isn't something obvious built into our webapp, but it would seem to be a
> method we are calling in the jdbc driver. There is no record of a
> 'select_user' anywhere when doing a grep, but our Java developers have found
> the issue now. The code wasn't changed between versions which is odd seeing
> as the issue only arose on the newer version - and I have replicated this.
>
> Anyway, they are now going to work around the issue, not calling that method
> any more. If I find the exact method it is off them I will re-post.
Not calling which method? On which driver?
How much other old code/libraries are you using, if you're using a 3
year old Tomcat?
p
> Thanks
>
>
> Dave Kirtland
> Systems Administrator
> dkirtland@epitiro.com
>
> www.epitiro.com
>
> T. +44 (0)2920 433 693
> F. +44 (0)2920 433 699
>
>
> -----Original Message-----
> From: Christopher Schultz [mailto:chris@christopherschultz.net]
> Sent: 02 November 2011 16:01
> To: Tomcat Users List
> Subject: Re: Tomcat 5.5.26 running 'select_user' for every transaction
>
> David,
>
> On 11/2/11 11:30 AM, David Kirtland wrote:
>> Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny
>> - apt versions) we are seeing a 'select_user' query to the database
>> for every single transaction. This is in addition to a 'select 1'
>> (the configured validationQuery). Obviously this is a big overhead
>> which I don't see that we need.
>
>> If anyone can shed some light on what this is doing and why it's
>> there (and ideally if we can turn it off) that would be very
>> helpful! I've searched through the docs and can't really find any
>> reference to it.
>
> Have you tried:
>
> $ grep -i "select_user" `find src -type f`
>
> ??
>
> Tomcat itself is definitely not doing this to you.
>
> -chris
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
--
--
[key:62590808]
RE: Tomcat 5.5.26 running 'select_user' for every transaction
Posted by David Kirtland <dk...@epitiro.com>.
It isn't something obvious built into our webapp, but it would seem to be a
method we are calling in the jdbc driver. There is no record of a
'select_user' anywhere when doing a grep, but our Java developers have found
the issue now. The code wasn't changed between versions which is odd seeing
as the issue only arose on the newer version - and I have replicated this.
Anyway, they are now going to work around the issue, not calling that method
any more. If I find the exact method it is off them I will re-post.
Thanks
Dave Kirtland
Systems Administrator
dkirtland@epitiro.com
www.epitiro.com
T. +44 (0)2920 433 693
F. +44 (0)2920 433 699
-----Original Message-----
From: Christopher Schultz [mailto:chris@christopherschultz.net]
Sent: 02 November 2011 16:01
To: Tomcat Users List
Subject: Re: Tomcat 5.5.26 running 'select_user' for every transaction
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
David,
On 11/2/11 11:30 AM, David Kirtland wrote:
> Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny
> - apt versions) we are seeing a 'select_user' query to the database
> for every single transaction. This is in addition to a 'select 1'
> (the configured validationQuery). Obviously this is a big overhead
> which I don't see that we need.
>
> If anyone can shed some light on what this is doing and why it's
> there (and ideally if we can turn it off) that would be very
> helpful! I've searched through the docs and can't really find any
> reference to it.
Have you tried:
$ grep -i "select_user" `find src -type f`
??
Tomcat itself is definitely not doing this to you.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk6xaR8ACgkQ9CaO5/Lv0PBiuwCghQSFbfaAC19+1Pbd4GB5v0u9
5m8AoLsSM2qS7R54Ebx7scZGZGyqoWrv
=oFoL
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 5.5.26 running 'select_user' for every transaction
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
David,
On 11/2/11 11:30 AM, David Kirtland wrote:
> Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny
> - apt versions) we are seeing a 'select_user' query to the database
> for every single transaction. This is in addition to a 'select 1'
> (the configured validationQuery). Obviously this is a big overhead
> which I don't see that we need.
>
> If anyone can shed some light on what this is doing and why it's
> there (and ideally if we can turn it off) that would be very
> helpful! I've searched through the docs and can't really find any
> reference to it.
Have you tried:
$ grep -i "select_user" `find src -type f`
??
Tomcat itself is definitely not doing this to you.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk6xaR8ACgkQ9CaO5/Lv0PBiuwCghQSFbfaAC19+1Pbd4GB5v0u9
5m8AoLsSM2qS7R54Ebx7scZGZGyqoWrv
=oFoL
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org