-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org