技术文章 - CS238699

在单独的服务器上运行 PostgreSQL 作为持久化提供程序时,ThingWorx 无法启动,并出现错误“无法从底层数据库获取连接!”

已修改: 29-Apr-2025   


注意:本文已使用机器翻译软件翻译,以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意, PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情,请单击 此处
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • ThingWorx Platform 6.0 to 9.6
  • PostgreSQL
  • Microsoft Windows
  • Red Hat Enterprise Linux (RHEL)
  • Ubuntu

说明

  • 如何在单独的服务器上设置 PostgreSQL 数据库作为 ThingWorx 持久化方案提供程序
  • 当 PostgreSQL 数据库安装在其他服务器上时,ThingWorx Tomcat 服务无法启动
  • 系统重启后,ThingWorx Tomcat 服务仍处于激活状态
  • \ThingworxStorage\logs\ApplicationLog.log中的错误
[L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Connections could not be acquired from the underlying database!
[L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
[L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing
[L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->1dy0bthb0h6cir015k8r7b|28ce8502]-HelperThread-#5] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@802eb7f -- 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->1dy0bthb0h6cir015k8r7b|28ce8502]-HelperThread-#5] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@319e552c 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 <<<<<<<<<
  • \ThingworxStorage\logs\ErrorLog.log中出现错误
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-2] Unable to get the default persistence provider. 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-2] null 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Connections could not be acquired from the underlying database! 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Unable to initialize and start system: Connections could not be acquired from the underlying database! 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! *** 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Could not load session timeout from database, using default: null 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] SCIMProvider initialization failure.  Thingworx Server is not running 
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: ] [S: ] [P: ] [T: http-nio-8080-exec-1] Could not handle request 
这是文章 238699 的 PDF 版本,可能已过期。最新版本 CS238699