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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: Tomcat 5.5.26 running 'select_user' for every transaction
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 dkirtl...@epitiro.com www.epitiro.com T. +44 (0)2920 433 693 F. +44 (0)2920 433 699 -Original Message- From: Christopher Schultz [mailto:ch...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat 5.5.26 running 'select_user' for every transaction
2011/11/2 David Kirtland dkirtl...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat 5.5.26 running 'select_user' for every transaction
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 dkirtl...@epitiro.com www.epitiro.com T. +44 (0)2920 433 693 F. +44 (0)2920 433 699 -Original Message- From: Christopher Schultz [mailto:ch...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org -- -- [key:62590808] signature.asc Description: OpenPGP digital signature