Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-11 Thread Bruce Milner
On 9/9/2018 12:16 AM, Mark Thomas wrote: On 08/09/18 19:36, Mark Thomas wrote: For the "- parking to wait for  <0x0006471cd7d8> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)" there are 155. Though I see no other messages with that object in the thread dump. Has anyone run into

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-09 Thread Phil Steitz
On 9/9/18 12:16 AM, Mark Thomas wrote: On 08/09/18 19:36, Mark Thomas wrote: For the "- parking to wait for  <0x0006471cd7d8> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)" there are 155. Though I see no other messages with that object in the thread dump. Has anyone run into t

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-09 Thread Mark Thomas
On 08/09/18 19:36, Mark Thomas wrote: >> For the "- parking to wait for  <0x0006471cd7d8> (a >> java.util.concurrent.locks.ReentrantLock$NonfairSync)" there are 155. >> Though I see no other messages with that object in the thread dump. >> >> Has anyone run into this? It seems like some sort

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-08 Thread Bruce Milner
Hello Mark, I sent the thread dump directly to you. On 9/8/2018 11:36 AM, Mark Thomas wrote: On 07/09/18 22:56, Bruce Milner wrote: Hello, I am using commons-pool2-2.5.0 for a MySQL connection pooler. The reason for not using out-of-the-box is that the existing code relies on changing catalog

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-08 Thread Bernd Eckenfels
Von: Bruce Milner Gesendet: Samstag, September 8, 2018 8:19 PM An: user@commons.apache.org Betreff: Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0 Hello, I did a while back, but my understanding of DBCP is that it has one pool per database and we have thousands. With

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-08 Thread Mark Thomas
On 07/09/18 22:56, Bruce Milner wrote: > Hello, > > I am using commons-pool2-2.5.0 for a MySQL connection pooler. The reason > for not using out-of-the-box is that the existing code relies on > changing catalogs at runtime reusing an existing connection. The > original design was to use multiple d

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-08 Thread Bruce Milner
Hello, I did a while back, but my understanding of DBCP is that it has one pool per database and we have thousands. With the number of nodes serving the application multiplied by the number of databases, it could easily exceed maximum number of connections to existing SQL database server. Th

Re: [pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-07 Thread Gary Gregory
Hi, A side question: Have you tried Apache Commons DBCP (which is based on Commons Pool)? https://commons.apache.org/proper/commons-dbcp/ Gary On Fri, Sep 7, 2018 at 5:24 PM Bruce Milner wrote: > Hello, > > I am using commons-pool2-2.5.0 for a MySQL connection pooler. The reason > for not usi

[pool] Possible deadlock or user error (me) commons-pool 2.5.0

2018-09-07 Thread Bruce Milner
Hello, I am using commons-pool2-2.5.0 for a MySQL connection pooler. The reason for not using out-of-the-box is that the existing code relies on changing catalogs at runtime reusing an existing connection. The original design was to use multiple databases using the same connection and this ca