1. Home
  2. Support
Article - CS330634

Error "An attempt by a client to checkout a Connection has timed out" is seen in Catalina.out

Modified: 20-Oct-2022   


Applies To

  • ThingWorx Platform 8.5 to 9.3

Description

  • ThingWorx Platform is unavailable
  • Following error are seen in catalina.out:
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
    at com.thingworx.persistence.postgres.PostgresDatasource.getConnection(PostgresDatasource.java:78)
..
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@67161fa3 -- timeout at awaitAvailable()
    at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1505)
    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
  • ApplicationLog.log has following type of error:
ERROR] [O: c.t.p.p.DataTableDataProcessor] [I: ] [U: SuperUser] [S: ] [P: ] [T: pool-4-thread-1] Unable to add data table entry because Could not create a transaction for ThingworxPersistenceProvider

ERROR] [O: c.t.s.s.a.AuditSubsystem] [I: ] [U: SuperUser] [S: ] [P: ] [T: https-jsse-nio-8443-exec-798] Unable to write audit entry for ...

ERROR] [O: c.t.p.p.PostgresDataExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: https-jsse-nio-8443-exec-797] [2,006] Unknown error occurred. Contact the administrator if this re-occurs.
 
  • Above errors follow a frequency equal to the value of checkoutTimeout  of ThingWorxPersistenceProvider
This is a printer-friendly version of Article 330634 and may be out of date. For the latest version click CS330634