OSCARMcMaster / Bugs / #3912 DBCP Errors

SBek - 2015-05-19

Downgrading the priority to 8 (high) as the system is still available for the use.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SBek - 2015-05-19

Priority: 9 --> 8
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Daniel Sin - 2015-05-26

assigned_to: Marc Dumontier
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2015-05-26

I don't think this is a bug, it's just because you don't have the fix I did to closing the connection in the security check code (don't have the bug id on hand)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Randy Jonasz - 2015-05-26

The patch that Marc alludes to has been applied since 10 days ago

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- DWarren - 2015-05-27
  
  and it works. very well!
  
  Dennis Warren
  Consultant
  Colcamex Resources
  dwarren@colcamex.com
  778.386.9264
  
  On May 26, 2015, at 11:34 AM, Randy Jonasz rjonasz@users.sf.net wrote:
  
  The patch that Marc alludes to has been applied since 10 days ago
  
  ** [bugs:#3912] DBCP Errors**
  
  Status: open
  Group: OSCAR 15 BETA
  Created: Tue May 19, 2015 07:42 PM UTC by Randy Jonasz
  Last Updated: Tue May 26, 2015 06:07 PM UTC
  Owner: Marc Dumontier
  
  Sporadically the logs at sfhc and mfp fill up with DBCP errors. The JDBC connection is closed. OSCAR then slows to a halt before recovering.
  
  org.apache.commons.dbcp.AbandonedTrace$AbandonedObjectException: DBCP object created 2015-05-19 10:00:00 by the following code was never closed:
  at org.apache.commons.dbcp.AbandonedTrace.setStackTrace(AbandonedTrace.java:139)
  at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:81)
  at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
  at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  at org.oscarehr.util.TrackingBasicDataSource.getConnection(TrackingBasicDataSource.java:114)
  at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46)
  at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
  at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
  at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
  at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
  at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
  at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)
  at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
  at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:59)
  at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
  at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
  at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
  at org.oscarehr.common.dao.BillingONCHeader1Dao$$EnhancerByCGLIB$$12e24a08.findByMagic2(<generated>)
  at oscar.oscarBilling.ca.on.data.JdbcBillingReviewImpl.getBillWithSorting(JdbcBillingReviewImpl.java:228)</generated>
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/oscarmcmaster/bugs/3912/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  Related
  
  Bugs: ~~#3912~~
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2015-05-28

you are running fix for bug #3901 ?

https://source.oscartools.org:8080/#/c/11987/

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sarah Allen - 2015-06-16

Hi Randy, has this issue been resolved?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Randy Jonasz - 2015-06-17
  
  Hi Sarah,
  
  I think this might be resolved. I've made some changes to mysql and
  sfhc has been running well ever since. Keep our fingers crossed.
  
  Randy Jonasz
  Title: Java Developer
  Department of Family Medicine
  McMaster University
  David Braley Health Centre
  100 Main Street West, 5th Floor
  Hamilton, ON L8P 1H6
  T - 905.525.9140 x27735
  F - 905.521.5594
  http://fammed.mcmaster.ca
  Follow us on Twitter: @McMasterFammed
  
  Criticism is the only respectable form of autobiography -- Oscar Wilde
  
  On 15/06/15 11:56 PM, Sarah Allen wrote:
  
  Hi Randy, has this issue been resolved?
  
  [bugs:#3912] http://sourceforge.net/p/oscarmcmaster/bugs/3912 DBCP
  Errors
  
  Status: open
  Group: OSCAR 15 BETA
  Created: Tue May 19, 2015 07:42 PM UTC by Randy Jonasz
  Last Updated: Thu May 28, 2015 03:28 PM UTC
  Owner: Marc Dumontier
  
  Sporadically the logs at sfhc and mfp fill up with DBCP errors. The
  JDBC connection is closed. OSCAR then slows to a halt before recovering.
  
  org.apache.commons.dbcp.AbandonedTrace$AbandonedObjectException: DBCP
  object created 2015-05-19 10:00:00 by the following code was never closed:
  at
  org.apache.commons.dbcp.AbandonedTrace.setStackTrace(AbandonedTrace.java:139)
  at
  org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:81)
  at
  org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
  at
  org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  at
  org.oscarehr.util.TrackingBasicDataSource.getConnection(TrackingBasicDataSource.java:114)
  at
  org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46)
  at
  org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
  at
  org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
  at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
  at
  org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
  at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
  at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)
  at
  org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
  at
  org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:59)
  at
  org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
  at
  org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
  at
  org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
  at
  org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
  at
  org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  at
  org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
  at
  org.oscarehr.common.dao.BillingONCHeader1Dao$$EnhancerByCGLIB$$12e24a08.findByMagic2(<generated>)
  at
  oscar.oscarBilling.ca.on.data.JdbcBillingReviewImpl.getBillWithSorting(JdbcBillingReviewImpl.java:228)</generated>
  
  Sent from sourceforge.net because you indicated interest in
  https://sourceforge.net/p/oscarmcmaster/bugs/3912/
  https://sourceforge.net/p/oscarmcmaster/bugs/3912
  
  To unsubscribe from further messages, please visit
  https://sourceforge.net/auth/subscriptions/
  https://sourceforge.net/auth/subscriptions
  
  Related
  
  Bugs: ~~#3912~~
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2015-10-05

should this be closed now?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Randy Jonasz - 2015-10-05

<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
Sure

On 10/05/2015 01:19 PM, Marc Dumontier wrote:

should this be closed now?

[bugs:#3912] DBCP Errors

Status: open
Group: OSCAR 15 BETA
Created: Tue May 19, 2015 07:42 PM UTC by Randy Jonasz
Last Updated: Tue Jun 16, 2015 03:56 AM UTC
Owner: Marc Dumontier

Sporadically the logs at sfhc and mfp fill up with DBCP errors. The JDBC connection is closed. OSCAR then slows to a halt before recovering.

org.apache.commons.dbcp.AbandonedTrace$AbandonedObjectException: DBCP object created 2015-05-19 10:00:00 by the following code was never closed:
at org.apache.commons.dbcp.AbandonedTrace.setStackTrace(AbandonedTrace.java:139)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:81)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.oscarehr.util.TrackingBasicDataSource.getConnection(TrackingBasicDataSource.java:114)
at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)
at org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:70)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:59)
at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:377)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at org.oscarehr.common.dao.BillingONCHeader1Dao$$EnhancerByCGLIB$$12e24a08.findByMagic2(<generated>)
at oscar.oscarBilling.ca.on.data.JdbcBillingReviewImpl.getBillWithSorting(JdbcBillingReviewImpl.java:228)

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/oscarmcmaster/bugs/3912/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

-- Randy Jonasz Java Developer Department of Family Medicine McMaster University David Braley Health Sciences Centre 100 Main Street West, 5th Floor Hamilton, ON L8P 1H6 T: 905.525.9140 ext. 27735 W: fhs.mcmaster.ca/fammed Twitter: @McMasterFammed

Related

Bugs: ~~#3912~~
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2015-11-09

status: open --> closed-out-of-date
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

DBCP Errors

open source web-based Electronic Medical Record (EMR) system

Group

Searches

Help

#3912 DBCP Errors

Related

Discussion

Related

Related

Related