6:38 p.m.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6891
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:22 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Joseph Carneiro commented on HHH-6891:
--------------------------------------
I'm experiencing a similar issue.
Environment:
Spring 3.1.1
Web Flow 2.3.0
Hibernate 4.1.0
c3p0 0.9.1.2
Problem:
When I make any calls to the EntityManager in a Spring Web Flow the connections are never
closed. I've turned on c3p0 logging and it shows that the pool grows every time I
start a flow. This is a real problem as the pool is exhausted and the application hangs.
Reaching the end-state doesn't release the connections. I have service calls within
the flow that use the EntityManager and c3p0's debug traces indicate these are the
culprits. I've tried calling close on the EntityManager after completing the queries,
but this has no effect. I have several standard Spring Controllers in my application as
well; they make use of the EntityManager through the same service calls and the
connections are closed. Only the flows are keeping the connections open. I'm using
<persistence-context/> in the flows and my EntityManager is annotated with
@PersistenceContext.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:53 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Steve Ebersole commented on HHH-6891:
-------------------------------------
Going to need a simplified test case reproducing this.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:14 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Joseph Carneiro updated HHH-6891:
---------------------------------
Attachment: test_case.zip
I have attached a test case. I'm not an expert on JUnit and I don't have the time
to devote to creating a proper test case, but this should suffice. There are instructions
on how to set up the test case and how to reproduce the issue.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:32 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Steve Ebersole commented on HHH-6891:
-------------------------------------
Oh well, guess its not super high priority then.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:57 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Joseph Carneiro commented on HHH-6891:
--------------------------------------
I'd say it's an issue worth looking into. The test case I've provided is easy
to set up and the issue is straightforwardly reproduced. I'm sorry I can't
deliver it as a JUnit test, but I do have other responsibilities that take my time. If it
must be in the form of a JUnit test, I'll try to find the time to learn JUnit and how
to use Spring and Hibernate with JUnit.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:19 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Shawn Clowater commented on HHH-6891:
-------------------------------------
That's similar behaviour as HHH-7120, i.e. it may already be fixed. I'm using
C3P0 and I'm no longer exhausting my connection pool, Joseph, you may want to try
rolling up to 4.1.2 when it becomes available or even grab the snapshot and run with
that.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:44 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
partyboy commented on HHH-6891:
-------------------------------
Hi,
I've similar problem,
Environment:
Spring 3.1.1
Web Flow 2.3.1
Hibernate 4.1.2
c3p0 0.9.1.2
EntityManager never returns the connection to c3p0 pool.
I downgrade to hibernate 3.6.10 and now the problem is gone. My application is working
fine (I instantly see the connection release in debug mode).
hope this help.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:06 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Joseph Carneiro commented on HHH-6891:
--------------------------------------
Shawn, I tried Hibernate 4.1.2 and the problem persists. partyboy brings up a good point:
c3p0 was working fine with Hibernate 3, I only started experiencing the problem when I
upgraded to 4.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:55 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
Shawn Clowater commented on HHH-6891:
-------------------------------------
Strange I've been running 4 for a few weeks now and it's hung together. Could be
a different configuration.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:11 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-6891) Hibernate is not reusing connections from the pool
[
https://hibernate.onjira.com/browse/HHH-6891?page=com.atlassian.jira.plug...
]
partyboy commented on HHH-6891:
-------------------------------
I've made more tests,
Initial environment :
Spring 3.1.1
Web Flow 2.3.1
Hibernate 4.1.2
c3p0 0.9.1.2
-> Connections do not return
I change from c3p0 to dbcp connections -> problem persists
I remove web flow to basic servlet (with annotations @controller and @service) -> no
problem
So, I'm thinking if it might be between webflow and hibernate.
Hibernate is not reusing connections from the pool
--------------------------------------------------
Key: HHH-6891
URL: https://hibernate.onjira.com/browse/HHH-6891
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.0.CR7
Environment: Hibernate 4, MySQL 5.6
Reporter: Mat Banik
Labels: c3p0, dbcp, hibernate
Attachments: test_case.zip
I have tried two connection pool providers C3P0 and Commons DBCP. Both are the most
current versions.
Everything starts fine. And data is loading from database as expected.
But with C3P0 when left to defaults everything stops when maximum of 15 connections are
reached. Nothing is freed up and the application behaves like it has memory leak.
Here is bottom of log output
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG begin
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG Obtaining JDBC connection
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG acquire test -- pool is already
maxed out. [managed: 15; max: 15]
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG awaitAvailable():
com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc
2011-12-13/17:21:55.167/EST [http-bio-80-exec-2] DEBUG trace
com.mchange.v2.resourcepool.BasicResourcePool@9671641 [managed: 15, unused: 0, excluded:
0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@46f0decc)
With Commons DBCP everything work as well until when maximum connections are reached and
than it throws exception:
org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate
data access: SQLException for SQL [n/a]; SQL state [null]; error code [0]; Could not open
connection; nested exception is org.hibernate.exception.GenericJDBCException: Could not
open connection
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:165)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.convertHibernateAccessException(HibernateExceptionTranslator.java:50)
org.springframework.orm.hibernate4.HibernateExceptionTranslator.translateExceptionIfPossible(HibernateExceptionTranslator.java:37)
org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4 a.m.
New subject: [Hibernate-JIRA] (HHH-6891) Hibernate is not reusing connections from the pool
9:38 a.m.
New subject: [Hibernate-JIRA] (HHH-6891) Hibernate is not reusing connections from the pool
9:40 a.m.
New subject: [Hibernate-JIRA] (HHH-6891) Hibernate is not reusing connections from the pool
9:51 a.m.
New subject: [Hibernate-JIRA] (HHH-6891) Hibernate is not reusing connections from the pool
5:50 a.m.
New subject: [Hibernate-JIRA] (HHH-6891) Hibernate is not reusing connections from the pool
4361
days inactive
4590
days old
hibernate-issues@lists.jboss.org
15 comments
6 participants
participants (6)
-
Joseph Carneiro (JIRA) -
Mat Banik (JIRA)
-
partyboy (JIRA)
-
Peter Salhofer (JIRA)
-
Shawn Clowater (JIRA)
-
Steve Ebersole (JIRA)