HTTP Status 500 - com.egoz.hibernate.TransactionException: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection


type Exception report

message com.egoz.hibernate.TransactionException: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection

description The server encountered an internal error that prevented it from fulfilling this request.

exception

com.egoz.market.logic.email.NotifyException: com.egoz.hibernate.TransactionException: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:166)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

com.egoz.hibernate.TransactionException: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
	com.egoz.hibernate.TransactionManager.getConnection(TransactionManager.java:168)
	com.egoz.market.security.blocked.BlockedEmailLogic.getBlockedEmail(BlockedEmailLogic.java:141)
	com.egoz.market.security.blocked.BlockedEmailLogic.isEmailBlocked(BlockedEmailLogic.java:85)
	com.egoz.market.logic.email.MailEnqueueLogic.removeBlocked(MailEnqueueLogic.java:48)
	com.egoz.market.logic.email.MailEnqueueLogic.cleanFromBlocked(MailEnqueueLogic.java:37)
	com.egoz.market.logic.email.MailEnqueueLogic.enqueueMessage(MailEnqueueLogic.java:22)
	com.egoz.market.logic.email.NotifyLogicUtils.queueMail(NotifyLogicUtils.java:40)
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:164)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
	org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:254)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:262)
	org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:236)
	org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:86)
	org.hibernate.internal.AbstractSharedSessionContract.beginTransaction(AbstractSharedSessionContract.java:452)
	com.egoz.hibernate.TransactionManager.getConnection(TransactionManager.java:146)
	com.egoz.market.security.blocked.BlockedEmailLogic.getBlockedEmail(BlockedEmailLogic.java:141)
	com.egoz.market.security.blocked.BlockedEmailLogic.isEmailBlocked(BlockedEmailLogic.java:85)
	com.egoz.market.logic.email.MailEnqueueLogic.removeBlocked(MailEnqueueLogic.java:48)
	com.egoz.market.logic.email.MailEnqueueLogic.cleanFromBlocked(MailEnqueueLogic.java:37)
	com.egoz.market.logic.email.MailEnqueueLogic.enqueueMessage(MailEnqueueLogic.java:22)
	com.egoz.market.logic.email.NotifyLogicUtils.queueMail(NotifyLogicUtils.java:40)
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:164)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

java.sql.SQLTransientConnectionException: springHikariCP - Connection is not available, request timed out after 5000ms.
	com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:548)
	com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
	com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:145)
	com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83)
	org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
	org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:254)
	org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:262)
	org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:236)
	org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:86)
	org.hibernate.internal.AbstractSharedSessionContract.beginTransaction(AbstractSharedSessionContract.java:452)
	com.egoz.hibernate.TransactionManager.getConnection(TransactionManager.java:146)
	com.egoz.market.security.blocked.BlockedEmailLogic.getBlockedEmail(BlockedEmailLogic.java:141)
	com.egoz.market.security.blocked.BlockedEmailLogic.isEmailBlocked(BlockedEmailLogic.java:85)
	com.egoz.market.logic.email.MailEnqueueLogic.removeBlocked(MailEnqueueLogic.java:48)
	com.egoz.market.logic.email.MailEnqueueLogic.cleanFromBlocked(MailEnqueueLogic.java:37)
	com.egoz.market.logic.email.MailEnqueueLogic.enqueueMessage(MailEnqueueLogic.java:22)
	com.egoz.market.logic.email.NotifyLogicUtils.queueMail(NotifyLogicUtils.java:40)
	com.egoz.market.logic.email.NotifyAdminLogic.sendDeveloperNotification(NotifyAdminLogic.java:164)
	com.egoz.market.MarketExceptionResolver.logCriticalException(MarketExceptionResolver.java:93)
	com.egoz.market.marketplace.CustomCharacterEncodingFilter.doFilterInternal(CustomCharacterEncodingFilter.java:31)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	sun.reflect.GeneratedConstructorAccessor647.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.Util.getInstance(Util.java:408)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
	com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2163)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2088)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
	com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:430)
	com.zaxxer.hikari.pool.HikariPool.access$500(HikariPool.java:64)
	com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:570)
	com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:563)
	java.util.concurrent.FutureTask.run(FutureTask.java:266)
	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	java.lang.Thread.run(Thread.java:748)

root cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	sun.reflect.GeneratedConstructorAccessor646.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
	com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
	com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
	com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2088)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
	com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:430)
	com.zaxxer.hikari.pool.HikariPool.access$500(HikariPool.java:64)
	com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:570)
	com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:563)
	java.util.concurrent.FutureTask.run(FutureTask.java:266)
	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	java.lang.Thread.run(Thread.java:748)

root cause

java.net.SocketTimeoutException: connect timed out
	java.net.PlainSocketImpl.socketConnect(Native Method)
	java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	java.net.Socket.connect(Socket.java:589)
	com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
	com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
	com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
	com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2104)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2088)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
	com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:430)
	com.zaxxer.hikari.pool.HikariPool.access$500(HikariPool.java:64)
	com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:570)
	com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:563)
	java.util.concurrent.FutureTask.run(FutureTask.java:266)
	java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	java.lang.Thread.run(Thread.java:748)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.69 logs.


Apache Tomcat/7.0.69