Article - CS350599

"Connections could not be acquired from the underlying database!" is seen with PostgreSQL SSL enabled following upgrade to ThingWorx Platform 9

Modified: 14-Oct-2025   


Applies To

  • ThingWorx Platform 9.0 to 9.7
  • PostgreSQL

Description

  • Does jdbcUrl key in platform-settings.json support ssl and sslmode options in ThingWorx Platform 9?
  • No longer able to connect to known working PostgreSQL database following upgrade to ThingWorx Platform 9
  • Able to connect to PostgreSQL database with psql but ThingWorx Platform fails to do so with Connections could not be acquired from the underlying database! error
  • How to specify ssl and sslmode options on the jdbcUrl key within platform-settings.json for ThingWorx Platform 9
    • Options were previously allowed in jdbcURL connection string
  • Seeing the following error in <ThingworxStorage>\logs\ApplicationLog.log following an upgrade to ThingWorx Platform 9:
    • [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] WebApp starting...
      [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Default Persistence Provider Name = ThingworxPersistenceProvider
      [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage
      [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Reading configuration from configTableCol
      [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken-><Token>]-HelperThread-#2]
      [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken-><Token>]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@47815d04 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
      [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken-><Token>]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@67b60899 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
      ...
      [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Connections could not be acquired from the underlying database!
      [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! ***
      [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] >>>>>>> PLATFORM SHUTDOWN START <<<<<<<<<
This is a printer-friendly version of Article 350599 and may be out of date. For the latest version click CS350599