ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Seven Stars

ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Hi, 

the technical.log (the log configured in TAC-->Settings-->Configuration-->Log4j-->"Technical file appender") logs the following error every second:

 

------

2017-09-21 15:34:02 ERROR SocketAppenderWithEmergencyLocalAppender - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@30678b73 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2sitqm9q18b1t7l1lsm94d|69682fa9, idleConnectionTestPeriod -> 250, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 32, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@ebbb719d [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2sitqm9q18b1t7l1lsm94d|43f5c1f1, jdbcUrl -> jdbcSmiley Tongueostgresql://bitldmgr_app01-db:5432/bitldmgr_app01_migration, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 2sitqm9q18b1t7l1lsm94d|6befa8cc, numHelperThreads -> 3 ] has been closed() -- you can no longer use it.


2017-09-21 15:34:02 ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@30678b73 [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2sitqm9q18b1t7l1lsm94d|69682fa9, idleConnectionTestPeriod -> 250, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 300, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 32, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@ebbb719d [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2sitqm9q18b1t7l1lsm94d|43f5c1f1, jdbcUrl -> jdbcSmiley Tongueostgresql://bitldmgr_app01-db:5432/bitldmgr_app01_migration, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 2sitqm9q18b1t7l1lsm94d|6befa8cc, numHelperThreads -> 3 ] has been closed() -- you can no longer use it.


2017-09-21 15:34:02 WARN SocketAppenderWithEmergencyLocalAppender - !!!Cannot create session or transaction.!!!


2017-09-21 15:34:02 WARN RemoteTaskExecution - !!!Cannot create session or transaction.!!!
------

 

Any idea what has been causing it?

If not, I will open a case to the support team.

 

Regards,

Lorenzo


Accepted Solutions
Moderator

Re: ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Hello,

When did this problem occurs?  From the error message, it seems that your Database connection is not released correctly. More information will be needed to address your issue.

It's strongly recommended that you should create a case on talend support portal. In this way, we can schedule a webex and give you a remoted assistance.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Hello,

When did this problem occurs?  From the error message, it seems that your Database connection is not released correctly. More information will be needed to address your issue.

It's strongly recommended that you should create a case on talend support portal. In this way, we can schedule a webex and give you a remoted assistance.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Thanks, 

we found the reason, it is a DB fail, indeed.

 

Regards,

Lorenzo

Moderator

Re: ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Hello,

Thanks for letting us know the reason.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: ERROR JDBCExceptionReporter - com.mchange.v2.c3p0.PoolBackedDataSource@64b75e80

Hello Lorenzo,

 

I am seeing this error in my TAC log but the database seems fine. Do you mind sharing what was causing the DB issue?

 

Thanks,

James

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download