アーティクル - CS238699

別のサーバーで PostgreSQL を永続化プロバイダとして実行している場合、ThingWorx が「基盤となるデータベースから接続を取得できませんでした」というエラーで起動に失敗します。

修正日: 29-Apr-2025   


注記:ここに記載されている情報は、お客様の利便性向上のため機械翻訳ソフトを使用しています。PTCは、ここに記載されている情報の翻訳の正確性について、一切の責任を負いませんので、ご了承ください。英語の原文を参照するには、こちら。この機械翻訳に関する詳細は、こちら。
お知らせいただき、ありがとうございます。この機械翻訳をレビューします。

適用対象

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

説明

  • ThingWorx 永続化プロバイダとして別のサーバーに PostgreSQL データベースを設定する方法
  • 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 
最新バージョンはこちらを参照ください CS238699