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

Tomcat connection pool 9.0.52 uses more then configured maxActive connections

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 fetch a connection in 15 seconds, none available

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:

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

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

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,

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

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

tomcat connection pool per database (postgres)

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.)

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

tomcat connection pool not closing properly

[ tomcat 8.5.30, mysql server 5.7.22, connector/j 5.1.46, centos 6, debian 8. ] I recently upgraded my sandboxes from 8.5.24 to 8.5.28 and now .30 and I have noticed that when a webapp is reloaded via the host manager, the associated connection pool is not getting closed down properly in the

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

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 > >

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, Михаил Ткаченко

Tomcat Connection Pool

Hi! Do you tell me what maxActive option means? Is it the amount of all connection in the pool? Or is it max number of connection which in use at the certain moment? Thanks.

Re: Tomcat Connection Pool Problems with XtraBackup

On Sun, Oct 12, 2014 at 5:56 AM, Stefan Mayr ste...@mayr-stefan.de 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

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.

Tomcat Connection Pool Problems with XtraBackup

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. Still, just as XtraBackup runs my logs start to blow

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 Ltd

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

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

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 first

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, 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 Pool

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

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 david.bull...@machaira.com.au wrote: Line 150 of

Re: Tomcat connection pool bleeding under heavy load

On 19 November 2013 14:59, Caldarale, Charles R chuck.caldar...@unisys.com 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 InterruptedException, the code

Re: Tomcat connection pool bleeding under heavy load

they will start increasing the number of clients (our application has big amount of transactions) and they will have to change connection pool. Are there any additional configuration setting I can try on Tomcat connection pool, otherwise this looks like a bug? Can you confirm that, during your

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 'exchangecountdownlatch'

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 - i

Tomcat connection pool bleeding under heavy load

this will not do once they will start increasing the number of clients (our application has big amount of transactions) and they will have to change connection pool. Are there any additional configuration setting I can try on Tomcat connection pool, otherwise this looks like a bug? regards, Marko

Re: Tomcat connection pool bleeding under heavy load

of transactions) and they will have to change connection pool. Are there any additional configuration setting I can try on Tomcat connection pool, otherwise this looks like a bug? Can you confirm that, during your load tests, you never got any abandoned messages on the console (stdout, catalina.out, etc

Re: Tomcat connection pool bleeding under heavy load

connection pool, otherwise this looks like a bug? regards, Marko - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org

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();//clear the flag, and bail out

Re: Changing tomcat connection pool size through jmx

dmik...@vmware.com wrote: On Mar 7, 2013, at 9:59 AM, amit shah wrote: Hello, I use tomcat connection pool in my web application by using two jars - tomcat-jdbc-7.0.34.jar and tomcat-juli-7.0.34.jar. I want to change the connection pool size through jmx but I could not find any

Re: Changing tomcat connection pool size through jmx

a new value. I believe that's how you would adjust the connection pool properties. Does that work for you? Dan On Thu, Mar 7, 2013 at 9:50 PM, Daniel Mikusa dmik...@vmware.com wrote: On Mar 7, 2013, at 9:59 AM, amit shah wrote: Hello, I use tomcat connection pool in my

Re: Changing tomcat connection pool size through jmx

and setting a new value. I believe that's how you would adjust the connection pool properties. Does that work for you? Dan On Thu, Mar 7, 2013 at 9:50 PM, Daniel Mikusa dmik...@vmware.com wrote: On Mar 7, 2013, at 9:59 AM, amit shah wrote: Hello, I use tomcat connection pool

Re: Changing tomcat connection pool size through jmx

On Mar 7, 2013, at 9:59 AM, amit shah wrote: Hello, I use tomcat connection pool in my web application by using two jars - tomcat-jdbc-7.0.34.jar and tomcat-juli-7.0.34.jar. I want to change the connection pool size through jmx but I could not find any defined jmx operation for doing

Re: Changing tomcat connection pool size through jmx

, I use tomcat connection pool in my web application by using two jars - tomcat-jdbc-7.0.34.jar and tomcat-juli-7.0.34.jar. I want to change the connection pool size through jmx but I could not find any defined jmx operation for doing that. Are you strictly looking at JMX

Re: Changing tomcat connection pool size through jmx

. I believe that's how you would adjust the connection pool properties. Does that work for you? Dan On Thu, Mar 7, 2013 at 9:50 PM, Daniel Mikusa dmik...@vmware.com wrote: On Mar 7, 2013, at 9:59 AM, amit shah wrote: Hello, I use tomcat connection pool in my web application

Re: Changing tomcat connection pool size through jmx

:59 AM, amit shah wrote: Hello, I use tomcat connection pool in my web application by using two jars - tomcat-jdbc-7.0.34.jar and tomcat-juli-7.0.34.jar. I want to change the connection pool size through jmx but I could not find any defined jmx operation for doing that. Are you

Tomcat Connection Pool

Hi, Can anyone help me regarding issue with connection pool for Tomcat? Tomcat version: 6.0 OS: Linux Database: Oracle 10g . Problem Statement: When server is idle for long period of time thread hangs for waiting the DBMS to return with response. I have tried all the possible combination

Re: [OT] Tomcat Connection Pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rahul, (Marking off-topic as this a JDBC driver/database issue unrelated to Tomcat). On 2/23/2011 9:13 AM, Rahul Kumar wrote: Tomcat version: 6.0 Not that it matters, but what version of 6.0? There are 32 or so of them. Problem Statement:

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?

been over 3 years since their last release, and it's clearly labeled beta). It looks like they might be thinking about another point release. What's wrong with LGPL? I'm not trying to start a holy war... just curious about your objections. The feature page of the tomcat connection pool (http

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 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 been

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 issues.

RE: tomcat connection pool - status and future?

. The feature page of the tomcat connection pool (http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html) seems quite promising, but to be honest, it concerns me that the module is only readily available from a commiter's pages or from source. That is a shame. Which part is a shame? That I

Re: tomcat connection pool - status and future?

it as See Three Pee Oh. At any rate, it looks like the LGPL will be a blocker for you. Bummer. I don't necessarily agree with the rules, I just have to follow them. I understand. The feature page of the tomcat connection pool (http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html) seems quite

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 National Guard duty

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: tomcat-dbcp has stagnated due

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 THIS COMMUNICATION MAY

tomcat connection pool - status and future?

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, I'd like to gather a bit of data on it. As a bit

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, I'd

Problem with Beta candidate for Tomcat connection pool

I installed the new Tomcat connection pool and it worked ok yesterday. First thing this morning it threw this exception below. (I snipped out a bunch of stuff but can send the whole thing if it would help) My resource definition from context.xml is Resource name=jdbc/prot auth=Container

Re: Problem with Beta candidate for Tomcat connection pool

Thanks Mark for the report, no not at all. I will push out a fix today. Filip Mark Shifman wrote: I installed the new Tomcat connection pool and it worked ok yesterday. First thing this morning it threw this exception below. (I snipped out a bunch of stuff but can send the whole thing

Re: Problem with Beta candidate for Tomcat connection pool

Mark, this was fixed in 1.0.3-beta, thanks for helping us out! http://tomcat.apache.org/dev/dist/jdbc-pool/1.0-beta/ Filip Mark Shifman wrote: I installed the new Tomcat connection pool and it worked ok yesterday. First thing this morning it threw this exception below. (I snipped out

Re: [ANNOUNCE] Beta candidate for Tomcat connection pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Filip, Filip Hanik - Dev Lists wrote: The Apache Tomcat team announces the immediate availability of Apache Tomcat JDBC Connection Pool The download page for this component says Tomcat 6. Is this component compatible with Tomcat 5.5 as well? If

Re: [ANNOUNCE] Beta candidate for Tomcat connection pool

Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Filip, Filip Hanik - Dev Lists wrote: The Apache Tomcat team announces the immediate availability of Apache Tomcat JDBC Connection Pool The download page for this component says Tomcat 6. Is this component

Re: [ANNOUNCE] Beta candidate for Tomcat connection pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Filip, Filip Hanik - Dev Lists wrote: The Apache Tomcat team announces the immediate availability of Apache Tomcat JDBC Connection Pool I'm sure this is documented somewhere, but why is Tomcat creating its own connection pool instead of

Re: [ANNOUNCE] Beta candidate for Tomcat connection pool

http://tomcat.markmail.org/message/4acbkimgilfkcdru?q=+list:org%2Eapache%2Etomcat%2Edev+ -Tim Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Filip, Filip Hanik - Dev Lists wrote: The Apache Tomcat team announces the immediate availability of Apache Tomcat JDBC

RE: [ANNOUNCE] Beta candidate for Tomcat connection pool

From: Christopher Schultz [mailto:[EMAIL PROTECTED] Subject: Re: [ANNOUNCE] Beta candidate for Tomcat connection pool I'm sure this is documented somewhere, but why is Tomcat creating its own connection pool instead of continuing to use commons-dbcp? https://issues.apache.org/bugzilla

Re: [ANNOUNCE] Beta candidate for Tomcat connection pool

A brief list of reasons is given in the link from Filip's post: https://issues.apache.org/bugzilla/show_bug.cgi?id=46038 The most important reason IMO is that you can't build Tomcat with a recent JDK. See: https://issues.apache.org/bugzilla/show_bug.cgi?id=43147 -- Len On Thu, Nov 13, 2008 at

Re: [ANNOUNCE] Beta candidate for Tomcat connection pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Len, Len Popp wrote: A brief list of reasons is given in the link from Filip's post: https://issues.apache.org/bugzilla/show_bug.cgi?id=46038 Whoops! Sorry. I should have read that before I opened my big mouth. The most important reason IMO is

[ANNOUNCE] Beta candidate for Tomcat connection pool

The Apache Tomcat team announces the immediate availability of Apache Tomcat JDBC Connection Pool Apache Tomcat Connectors version 1.0.1-beta is a new module within the Tomcat development realm, aimed to provide a high performance, concurrent and extensible connection pool to the Tomcat

Tomcat Connection pool

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 any application. When I modify server.xml in conf directory to add my connection, listed below: Server port=8010 shutdown=SHUTDOWN Listener

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

Re: Tomcat Connection pool

Yes post your web.xml where with your resource-ref 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

RE: Tomcat Connection pool

(where server.xml is) resolved my problems :-) thanks Shailesh -Original Message- From: Daniel 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 resource-ref tags. Looks

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