Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: [jdbc-pool] Validation query leaves transaction open
To: Tomcat Users List <users@tomcat.apache.org>
References: <CAOUwSGsxFd70dSMR9mBExAxSYeSAZ-0GGBmyn5ALZX8GydntVw@mail.gmail.com>
From: Christopher Schultz <chris@christopherschultz.net>
Message-id: <b3c9baf7-65d0-7566-d744-eb3d350a9705@christopherschultz.net>
Date: Mon, 15 Aug 2016 17:44:16 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0)
 Gecko/20100101 Thunderbird/45.2.0
MIME-version: 1.0
In-reply-to: 
 <CAOUwSGsxFd70dSMR9mBExAxSYeSAZ-0GGBmyn5ALZX8GydntVw@mail.gmail.com>
Content-type: text/plain; charset=utf-8
Content-transfer-encoding: 7bit
archived-at: Mon, 15 Aug 2016 21:44:51 -0000

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

John,

On 8/11/16 3:33 PM, John Huss wrote:
> I have verified that in version 8.0.36 of tomcat jdbc the
> validation query functionality does not commit the transaction it
> starts in order to run the validation query, which can cause an
> open transaction for a very long time (possibly until the database
> crashes).  This seems to be especially problematic if you have a
> large pool where the connections are idle for a large period of
> time.
> 
> I also tested against version 9.0.0M9, and in that version the
> problem is fixed.  However, nothing about this appears in the
> release notes for any version (9.0, 8.5, or 8.0).  If this bug has
> indeed been fixed it should be documented in the release notes.
> Also, back-porting the fix to the 8.0 branch would be very
> helpful.
> 
> For the time being I am working around the problem by changing my 
> validation query from "SELECT 1" to be "SELECT 1; COMMIT" (using 
> postgresql).  This prevents the issue.
> 
> This was reported previously (three years ago) here: 
> https://mail-archives.apache.org/mod_mbox/tomcat-users/201301.mbox/%3C
CAPw873vy%2B9kWMQiFPbnTX6g1FSQ8oTVhDJ3Zagp9UkUZ3d5qjw%40mail.gmail.com%3
E

Can
> 
you post your whole (sanitized) <Resource> definition?

Thanks,
- -chris
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBCAAGBQJXsjewAAoJEBzwKT+lPKRYqacP/j/IUunibNUhUMx+FzyfBVZo
wK2WcQdM/gdjo6VvhT30A5ndf0HgD8PxHt+7ZaQ8LPQ3cqcLem2KhZvaMD0Kaepw
k2+HCCayv89KhDXBlvLdKBKJ9mNT1s7cgmNLsF0xdvEioTi8KAbJtG0JOndYwQFb
MUuYBifOoW4ir47tQmETnu0z6rGvezTRu7eycbiaUZw0jNoQgy0WojJQqm2mmQou
uLkQghDHivqeauCLf/SbnHnJR1RuXTxef6v25M3a0rbC1XpLE9mrv/CExI92Vm9R
94iR7olGErxJbjZywSBM4sbdlhT91IFbSeIAh/Q6FlnC2MbJxEH5naUHVIX9q36R
p94412emJ2tBWxLB8VY5E9hJVeTNzOe2+bhjBypj9z9aewuCi9oDfVs5pTTmKedu
LypcLCWsXPg4/VQ4DQ6VL81igAnLnNZbcWNueBTQiqEg2F5c3pjEwfc/G4YqTfQ0
byTRBraKBR3FLU8n9kkwpNpO4MMVX/keUTD1NEhP/NL8ldh+nGroekFx1JBmzIk4
5ID8gvtelcS9Mwp+nxz4uUuXYy0iDe4pMX50QRG2AY+Hxye4rfX9NmCG/BYhwNAQ
x0X/16fZ4usyKOyj75Lya6IfbMTq2ufv8rVciKaIJJXybQNAhgWvO2F1VZHTgdIG
HT8rSho2EhsqjyNlR2s4
=28er
-----END PGP SIGNATURE-----

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