Article - CS273381
Error "FATAL: sorry, too many clients already" reported in PostgreSQL for ThingWorx Platform
Modified: 22-Jul-2026
Applies To
- ThingWorx Platform 8.2 to 10.1
- PostgreSQL
Description
- ThingWorx Platform is up and accessible but not usable due to the following error in Composer
Unable to execute service SpotlightSearch on SearchFunctions : Unable to get search entries: [2,006] Unknown error occurred. Contact the administrator if this re-occurs. - Error is reported in PostgreSQL periodically but not always
FATAL: sorry, too many clients already - Database connection fails with the following error in ThingworxStorage/logs/ErrorLog.log:
java.sql.SQLException: Connections could not be acquired from the underlying database!
- <tomcat_home>\logs\catalina.out shows the following:
java.lang.RuntimeException: com.thingworx.common.exceptions.DataAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs. at com.thingworx.persistence.common.DataTableEngine.lambda$findEntries$11(DataTableEngine.java:237) at com.thingworx.persistence.TransactionFactory.createDataTransactionAndReturn(TransactionFactory.java:161) ... Caused by: com.thingworx.common.exceptions.DataAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs. at com.thingworx.persistence.postgres.PostgresDataExceptionTranslator.rethrowTranslated(PostgresDataExceptionTranslator.java:27) at com.thingworx.persistence.postgres.dao.PostgresDataTableDao.searchEntries(PostgresDataTableDao.java:292) ... Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692) ... Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source. at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507) at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644) ... Caused by: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:292) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ... Caused by: java.io.EOFException at org.postgresql.core.PGStream.receiveChar(PGStream.java:308) at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:499) ...
This is a printer-friendly version of Article 273381 and may be out of date. For the latest version click CS273381