Skip to content
GitLab
Closed
Created by Matija Obreza@mobrezaOwner

Connection pool

Something's wrong with our connection pool:

2020-05-19T03:55:56.805018466Z 03:55:56,802 qtp1305193908-2114 ERROR o.g.s.a.ApiExceptionHandler:234 - Wow! Such! Exception!
2020-05-19T03:55:56.805058028Z org.springframework.transaction.TransactionSystemException: Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking
2020-05-19T03:55:56.805064690Z 	at org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:565)
2020-05-19T03:55:56.805072136Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:835)
2020-05-19T03:55:56.805076416Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:809)
2020-05-19T03:55:56.805080845Z 	at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)
2020-05-19T03:55:56.805084913Z 	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)
2020-05-19T03:55:56.805089155Z 	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
2020-05-19T03:55:56.805100012Z 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
2020-05-19T03:55:56.805104260Z 	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
2020-05-19T03:55:56.805110260Z 	at com.sun.proxy.$Proxy345.getAccessionDetails(Unknown Source)
2020-05-19T03:55:56.805114058Z 	at org.genesys2.server.api.v1.AccessionController.getAccessionDetailsByDoi(AccessionController.java:303)
...
2020-05-19T03:55:56.805784629Z Caused by: javax.persistence.PersistenceException: unexpected error when rollbacking
2020-05-19T03:55:56.805788570Z 	at org.hibernate.jpa.internal.TransactionImpl.rollback(TransactionImpl.java:111)
2020-05-19T03:55:56.805792694Z 	at org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:561)
2020-05-19T03:55:56.805796840Z 	... 133 more
2020-05-19T03:55:56.805800637Z Caused by: org.hibernate.TransactionException: rollback failed
2020-05-19T03:55:56.805804549Z 	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)
2020-05-19T03:55:56.805808745Z 	at org.hibernate.jpa.internal.TransactionImpl.rollback(TransactionImpl.java:108)
2020-05-19T03:55:56.805812742Z 	... 134 more
2020-05-19T03:55:56.805816484Z Caused by: org.hibernate.TransactionException: unable to rollback against JDBC connection
2020-05-19T03:55:56.805820497Z 	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)
2020-05-19T03:55:56.805825537Z 	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)
2020-05-19T03:55:56.805829606Z 	... 135 more
2020-05-19T03:55:56.805833329Z Caused by: java.sql.SQLException: Connection has already been closed.
2020-05-19T03:55:56.805837327Z 	at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
2020-05-19T03:55:56.805841313Z 	at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109)
2020-05-19T03:55:56.805845389Z 	at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80)
2020-05-19T03:55:56.805853154Z 	at com.sun.proxy.$Proxy96.rollback(Unknown Source)
2020-05-19T03:55:56.805857127Z 	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)
2020-05-19T03:55:56.805861278Z 	... 136 more
020-05-19T03:56:32.439550568Z WARNING: Connection has been abandoned PooledConnection[com.mysql.cj.jdbc.ha.MultiHostMySQLConnection@5d4cb47c]:java.lang.Exception
2020-05-19T03:56:32.439633985Z 	at org.apache.tomcat.jdbc.pool.ConnectionPool.getThreadDump(ConnectionPool.java:1063)
2020-05-19T03:56:32.439649791Z 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:780)
2020-05-19T03:56:32.439665541Z 	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:619)
2020-05-19T03:56:32.439670469Z 	at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
2020-05-19T03:56:32.439675776Z 	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:128)
2020-05-19T03:56:32.439680731Z 	at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)
2020-05-19T03:56:32.439685232Z 	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
2020-05-19T03:56:32.439689936Z 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
2020-05-19T03:56:32.439693654Z 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
2020-05-19T03:56:32.439697673Z 	at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:450)
2020-05-19T03:56:32.439701791Z 	at sun.reflect.GeneratedMethodAccessor487.invoke(Unknown Source)
2020-05-19T03:56:32.439705611Z 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2020-05-19T03:56:32.439709404Z 	at java.lang.reflect.Method.invoke(Method.java:498)
2020-05-19T03:56:32.439713374Z 	at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282)
2020-05-19T03:56:32.439717617Z 	at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:266)
2020-05-19T03:56:32.439721948Z 	at org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle.doGetConnection(HibernateJpaDialect.java:430)
2020-05-19T03:56:32.439726869Z 	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:174)
2020-05-19T03:56:32.439731301Z 	at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:402)
2020-05-19T03:56:32.439736605Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
2020-05-19T03:56:32.439753450Z 	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
2020-05-19T03:56:32.439757275Z 	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:572)
2020-05-19T03:56:32.439760745Z 	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:360)
2020-05-19T03:56:32.439764164Z 	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
2020-05-19T03:56:32.439767471Z 	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
2020-05-19T03:56:32.439770722Z 	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
2020-05-19T03:56:32.439774033Z 	at com.sun.proxy.$Proxy367.getDetails(Unknown Source)
2020-05-19T03:56:32.439777086Z 	at org.genesys2.server.api.v1.GeoController.getCountryDetails(GeoController.java:72)