Re: Tomcat connection pool 9.0.52 uses more then configured maxActive connections

On 22/05/2023 09:45, Stefan López Romero wrote: Hello, I have the problem that the Tomcat connection pool uses more than the maxActive connections. In my Dropwizard application I have configured a maxSize of 30, but I found the following message in the logs. Timeout: Pool empty. Unable to fe

Re: tomcat connection pool per database (postgres)

For those scoring at home, I'm going to try managing pool-per-user myself for the potential jmx gain and as I said, two will be amazing success. On 11/25/20 9:40 AM, Christopher Schultz wrote: Phil and Rob, On 11/24/20 11:26, Phil Steitz wrote: On 11/24/20 8:52 AM, Rob Sargent wrote: Perhap

Re: tomcat connection pool per database (postgres)

Phil and Rob, On 11/24/20 11:26, Phil Steitz wrote: On 11/24/20 8:52 AM, Rob Sargent wrote: Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApache Commons DBCP

Re: tomcat connection pool per database (postgres)

On 24/11/2020 16:26, Phil Steitz wrote: > > > On 11/24/20 8:52 AM, Rob Sargent wrote: >> Perhaps I read too much into the description of "The tomcat JDBC >> Connection Pool" page? >> >> TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement >> or an alternative to theApache Commons

Re: tomcat connection pool per database (postgres)

On 11/24/20 8:52 AM, Rob Sargent wrote: Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApache Commons DBCP connection pool

Re: tomcat connection pool per database (postgres)

Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApache Commons DBCP connection pool. I reacted to the "replacement" bit. Are

Re: tomcat connection pool per database (postgres)

On 11/24/20 8:14 AM, Rob Sargent wrote: Thanks. I get it. But... - seems this solution raises the footprint of the pooler, with number-of-users * minimum-connection-count etc - would it be beyond the pale for the pooler to maintain username-connectionList maps? Per response elsethread, se

Re: tomcat connection pool per database (postgres)

Thanks.  I get it. But... - seems this solution raises the footprint of the pooler, with number-of-users * minimum-connection-count etc - would it be beyond the pale for the pooler to maintain username-connectionList maps? Thankfully, I'll be wildly successful if I have two concurrent users

Re: tomcat connection pool per database (postgres)

Rob, On 11/19/20 12:38, Rob Sargent wrote: Since the connection URL names a specific postgres database is it standard practice to have a pool per target database?  (Switching databases in postgres amounts to closing/opening a connection.) I generally consider a database connection pool to be

Re: tomcat connection pool not closing properly

On Thu, Apr 26, 2018 at 10:23 AM, Chris Cheshire wrote: [snip] I've done some more testing with older and newer versions of tomcat, and also swapping to use commons dbcp. All of them exhibit the same behaviour. So the question becomes is this expected behaviour (previous connection pool instance

Re: Tomcat Connection Pool

On 08/12/2016 07:59, Михаил Ткаченко wrote: > Yes but it description is ambiguous for me. What does it means "active > connection"? In use for request to DB? It is the maximum number of connections the pool will keep open to the database at any point in time. Those connections may be actively proc

Re: Tomcat Connection Pool

Yes but it description is ambiguous for me. What does it means "active connection"? In use for request to DB? 08 дек. 2016 г. 10:53 пользователь "Kaloyan Spiridonov" < k.i.spirido...@gmail.com> написал: > Hello, > > As it is described in jdbc connection pool documentation: > > maxActive > > (int)

Re: Tomcat Connection Pool

Hello, As it is described in jdbc connection pool documentation: maxActive (int) The maximum number of active connections that can be allocated from this pool at the same time. The default value is 100 Best Regards, Kaloyan On Thu, Dec 8, 2016 at 9:47 AM, Михаил Ткаченко wrote: > Hi! Do you

Re: Tomcat Connection Pool Problems with XtraBackup

On Sun, Oct 12, 2014 at 5:56 AM, Stefan Mayr wrote: > Hi John, > > Am 11.10.2014 23:30, schrieb John Smith: > >> I'm trying to workout a managed backup scheme on a MySQL production >> database with XtraBackup. According to our DBA, XtraBackup doesn't lock >> the >> database, but issues a series o

Re: Tomcat Connection Pool Problems with XtraBackup

Hi John, Am 11.10.2014 23:30, schrieb John Smith: I'm trying to workout a managed backup scheme on a MySQL production database with XtraBackup. According to our DBA, XtraBackup doesn't lock the database, but issues a series of SHOW TABLE STATUS commands and then works on the file system level.

Re: Tomcat connection pool "bleeding" under heavy load

Hi I guess i should code something like start i.e. 50 (configurable parameter to increase the load) threads and issues queries non stop over jdbc to i.e. 2 database test tables - we should generate enough trasactions to take all pool connections. And I should probably use jdbc connections as defin

Re: Tomcat connection pool "bleeding" under heavy load

Hello I guess you are suggesting to compile this class with the changes you propose and test it? regards, marko On Thu, Nov 21, 2013 at 1:58 AM, David Bullock < david.bull...@machaira.com.au> wrote: > Oh, and 'throw e;' at the end of the handler :-) > David Bullock > Machaira Enterprises Pty L

Re: Tomcat connection pool "bleeding" under heavy load

Oh, and 'throw e;' at the end of the handler :-) David Bullock Machaira Enterprises Pty Ltd PO Box 31 Canowindra NSW 2804 02 6344 1100 http://machaira.com.au/ On 21 November 2013 11:48, David Bullock wrote: > Line 150 of org.apache.tomcat.jdbc.pool.FairBlockingQueue can throw > InterruptedExce

Re: Tomcat connection pool "bleeding" under heavy load

Line 150 of org.apache.tomcat.jdbc.pool.FairBlockingQueue can throw InterruptedException, which should be handled by: catch (InterruptedException e) { lock.lock(); waiters.remove(c); // prevent future threads from offering to this thread, since we are about to die lock.unlock(); if (c.

Re: Tomcat connection pool "bleeding" under heavy load

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Marko, On 11/20/13, 12:07 PM, marko lugarič wrote: > I have repeated the test with logAbandoned set to "true" and left > it half hour after pool is empty. There are a lot of exceptions > (Pool empty. Unable to fetch a connection in 15 seconds and Po

Re: Tomcat connection pool "bleeding" under heavy load

Hello I have repeated the test with logAbandoned set to "true" and left it half hour after pool is empty. There are a lot of exceptions (Pool empty. Unable to fetch a connection in 15 seconds and Pool wait interrupted) but i don't know what exactly to search (search with Abandoned did not produce

Re: Tomcat connection pool "bleeding" under heavy load

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Marko, On 11/20/13, 8:14 AM, marko lugarič wrote: > Hello > > The tests are run in the following manner: around 5 min to start > the server and connect all clients. Then I can apply load from > clients: on the graph I applied only half load for fir

Re: Tomcat connection pool "bleeding" under heavy load

Hello The tests are run in the following manner: around 5 min to start the server and connect all clients. Then I can apply load from clients: on the graph I applied only half load for first seven minutes an then full load but this is not required - I can go with full load after all clients connec

Re: Tomcat connection pool "bleeding" under heavy load

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Marko, On 11/19/13, 10:16 AM, marko lugarič wrote: > About using useEquals="false" property I guess we defined when we > started using this pool. After reading the documentation i guess it > is better to leave it out (it has no effect on the test -

Re: Tomcat connection pool "bleeding" under heavy load

Marko wrote: > In that case debugging looks like the only option? Nobody yet disputed: > The 'leakiness' of the pool is actually in > org.apache.tomcat.jdbc.pool.FairBlockingQueue#poll() > If the line (!c.await(timeout, unit)) exits via an > InterruptedException, the the 'exchangecountdownlatc

Re: Tomcat connection pool "bleeding" under heavy load

Hello About using useEquals="false" property I guess we defined when we started using this pool. After reading the documentation i guess it is better to leave it out (it has no effect on the test - i tested it). We dont have long running queries because there is not much data and all operations a

Re: Tomcat connection pool "bleeding" under heavy load

On 19 November 2013 14:59, Caldarale, Charles R wrote: >> From: David Bullock [mailto:david.bull...@machaira.com.au] >> Subject: Re: Tomcat connection pool "bleeding" under heavy load > >> In PooledConnection#borrow(int,String,String) when handling >> Inte

RE: Tomcat connection pool "bleeding" under heavy load

> From: David Bullock [mailto:david.bull...@machaira.com.au] > Subject: Re: Tomcat connection pool "bleeding" under heavy load > In PooledConnection#borrow(int,String,String) when handling > InterruptedException, the code there does: >Thread.interrupted();//cle

Re: Tomcat connection pool "bleeding" under heavy load

In PooledConnection#borrow(int,String,String) when handling InterruptedException, the code there does: Thread.interrupted();//clear the flag, and bail out but if the comment is correct, then the code is wrong (should be Thread.isInterrupted()). However, the entire line is probably not necessa

Re: Tomcat connection pool "bleeding" under heavy load

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Marko, On 11/18/13, 3:48 AM, marko lugarič wrote: > We have received an issue from our customer that after some time in > production they get empty connection pool. After some time we > managed to reproduce their problem in our test environment wit

Re: tomcat connection pool - status and future?

On 24/09/2010 18:11, Jason Pringle wrote: > > On 09/23/2010 2:27 PM, Mark Thomas wrote: > >> Several release attempts have failed due to a lack of interest. > > Lack of interest by whom? The development team or the tomcat community? Anyone apart from the original developer. You'll see a little

RE: tomcat connection pool - status and future?

> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: tomcat connection pool - status and future? > Is he in the /US/ National Guard? Yes. > He lives in Colorado, right? Last I heard. (Haven't actually seen him in about two years.) - Chuck T

Re: tomcat connection pool - status and future?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chuck, On 9/24/2010 2:04 PM, Caldarale, Charles R wrote: >> From: Christopher Schultz [mailto:ch...@christopherschultz.net] >> Subject: Re: tomcat connection pool - status and future? > >> To answer your question of markt: tomc

RE: tomcat connection pool - status and future?

> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: tomcat connection pool - status and future? > To answer your question of markt: tomcat-dbcp has stagnated due > to lack of interest from the Tomcat dev team itself. Also note that Filip is off on Na

Re: tomcat connection pool - status and future?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jason, On 9/24/2010 1:26 PM, Jason Pringle wrote: > On 9/24/2010 7:24 AM, Christopher Schultz wrote: >> What's wrong with LGPL? I'm not trying to start a holy war... just >> curious about your objections. > > Our legal department detests LGPL (lack o

RE: tomcat connection pool - status and future?

Chris, On 9/24/2010 7:24 AM, Christopher Schultz wrote: > What issues are you thinking of, specifically. These? > http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html Googling around shows many complaints about multithreaded behavior and connection dropping. Which (to me) suggests at leas

RE: tomcat connection pool - status and future?

On 09/23/2010 2:27 PM, Mark Thomas wrote: > Several release attempts have failed due to a lack of interest. Lack of interest by whom? The development team or the tomcat community? > That said, $work is using this as the default pool in a commercial > product based on Tomcat with minimal issue

Re: tomcat connection pool - status and future?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeff, On 9/24/2010 11:14 AM, Jeff Hubbs wrote: > On 9/24/10 10:24 AM, Christopher Schultz wrote: >> >> The biggest problem with C3P0 is that it's unsupported (I heard... I >> can't find anywhere that it says the project is actually dead, but it's >>

Re: tomcat connection pool - status and future?

On 9/24/10 10:24 AM, Christopher Schultz wrote: The biggest problem with C3P0 is that it's unsupported (I heard... I can't find anywhere that it says the project is actually dead, but it's been over 3 years since their last release, and it's clearly labeled "beta"). It looks like they might be

Re: tomcat connection pool - status and future?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jason, On 9/23/2010 4:26 PM, Jason Pringle wrote: > I started by researching available connection pools for tomcat, and > it seems most folks either use DBCP (which has a host of issues) What issues are you thinking of, specifically. These? http://pe

Re: tomcat connection pool - status and future?

On 23/09/2010 13:26, Jason Pringle wrote: > > I've recently become aware of the new-ish tomcat connection pool > (http://people.apache.org/~fhanik/jdbc-pool/) which appears to be at version > 1.0.8.5 (a January 2010 release?). > > Before I recommend we begin using this in a production situation

RE: Tomcat Connection pool

In your code where you reference the JNDI name "jdbc", reference "jdbc/orcl" instead. -Original Message- From: Ligade, Shailesh (Contr) (Mission Systems) [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:16 AM To: Tomcat Users List Subject: Tomcat Connection pool Greetings, I am

RE: Tomcat Connection pool

Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 10:00 AM To: Tomcat Users List Subject: Re: Tomcat Connection pool Yes post your web.xml where with your tags. Looks like a typo in there. On 5/29/07, Ligade, Shailesh (Contr) (Mission Systems) < [EMAIL PROTECTED]>

Re: Tomcat Connection pool

Yes post your web.xml where with your tags. Looks like a typo in there. On 5/29/07, Ligade, Shailesh (Contr) (Mission Systems) < [EMAIL PROTECTED]> wrote: Greetings, I am running Tomcat 5.x, and I have many webapps deployed and working under tomcat. I want my connection pool to be used from

Re: Tomcat Connection pool

maybe you need some settings at the web.xml as weel? (just guess) regards, Szabi 2007/5/29, Ligade, Shailesh (Contr) (Mission Systems) <[EMAIL PROTECTED]>: Greetings, I am running Tomcat 5.x, and I have many webapps deployed and working under tomcat. I want my connection pool to be used from