thingworx 9.3 with external postgres docker run error
I followed the steps for thingworx 9.3 docker with external postgresdb installation process.
security container - ok
postgres-init - ok : checked that init has successfully connected to the external postgres and have made the schema,tables correctly
platform - error :
[L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->1bqu96satfv8vm3hxx67u|46919ddb, dataSourceName->PostgresPersistenceProvider]-HelperThread-#6] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@65de6078 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2022-12-22 09:36:23.264+0000 [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!
2022-12-22 09:36:23.264+0000 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! ***
What am I doing wrong??
please help..
version: '2.2'
volumes:
storage:
services:
postgresql-init:
image: thingworx/postgresql-init-twx:latest
entrypoint: bash -c -x "/usr/local/bin/db-check.sh && /usr/local/bin/db-setup.sh && sleep infinity"
healthcheck:
test: [ "CMD-SHELL", "grep 'success' tmp/status.txt || exit 1" ]
interval: 15s
retries: 5
# depends_on:
# postgresql:
# condition: service_healthy
environment:
# NOTE: Set DATABASE_ADMIN_USERNAME, DATABASE_ADMIN_PASSWORD DATABASE_ADMIN_SCHEMA for connecting
# to the postgres as super user
- "DATABASE_ADMIN_USERNAME=postgres"
- "DATABASE_ADMIN_PASSWORD=plain text password"
- "DATABASE_ADMIN_SCHEMA=postgres"
- "DATABASE_HOST=10.0.1.11"
- "DATABASE_PORT=5432"
- "TWX_DATABASE_USERNAME=thingworx3"
- "TWX_DATABASE_SCHEMA=thingworx3"
- "TWX_DATABASE_PASSWORD=plain text password"
- "TABLESPACE_LOCATION=/var/lib/postgresql/data"
security-cli:
image: thingworx/security-tool:latest
entrypoint: sh -c "/opt/docker-entrypoint.sh && sleep infinity"
healthcheck:
test: [ "CMD-SHELL", "grep 'success' status.txt || exit 1" ]
interval: 15s
retries: 5
environment:
KEYSTORE: 'true'
# NOTE: Set KEYSTORE_PASSWORD (Must match value from platform container)
KEYSTORE_PASSWORD: 'plain text password'
KEYSTORE_PASSWORD_FILE_PATH: '/opt'
KEYSTORE_FILE_PATH: '/ThingworxPlatform/sc-keystore'
CUSTOM_SECRET_LIST: 'encrypt.db.password:TWX_DATABASE_PASSWORD'
# NOTE: Set TWX_DATABASE_PASSWORD
TWX_DATABASE_PASSWORD: 'plain text password'
volumes:
- storage:/ThingworxStorage
platform:
image: thingworx/platform-postgres:latest
healthcheck:
test: curl -f localhost:8080/Thingworx/health
interval: 15s
depends_on:
security-cli:
condition: service_healthy
postgresql-init:
condition: service_healthy
ports:
- "8080:8080"
- "8443:8443"
environment:
- "CATALINA_OPTS=-Xms2g -Xmx4g"
# NOTE: Set KEYSTORE_PASSWORD (Must match value from security-cli container)
#- "KEYSTORE_PASSWORD=plain text password"
- "DATABASE_HOST=10.0.1.11"
- "DATABASE_PORT=5432"
- "TWX_DATABASE_USERNAME=thingworx3"
- "TWX_DATABASE_SCHEMA=thingworx3"
- "TWX_DATABASE_PASSWORD=plain text password"
# NOTE: The following must be set for the Platform to start. This will be
# the initial Administrator password.
- "THINGWORX_INITIAL_ADMIN_PASSWORD=plain text password"
# NOTE: The following must be set for the Platform to start. This will be
# the initial MetricsUser password.
- "THINGWORX_INITIAL_METRICS_USER_PASSWORD=plain text password"
#Uncomment the below to automatically download license
- "LS_USERNAME=xxx@xx.com"
- "LS_PASSWORD=plain text password"
- "DATABASE_ADMIN_USERNAME=postgres"
- "DATABASE_ADMIN_PASSWORD=plain text password"
- "TABLESPACE_LOCATION=/var/lib/postgresql/data"
#- "SSL_KEYSTORE_PASSWORD=plain text password"
# Use this to mount your orgs licence file, if not ThingWorx will fallback to temporary licence
volumes:
- "/ThingworxPlatform:/ThingworxPlatform"
- "/ThingworxStorage:/ThingworxStorage"
- "/ThingworxBackupStorage:/ThingworxBackupStorage"
- "/tomcat-logs:/app/opt/apache-tomcat/logs"
"PlatformSettingsConfig": {
"BasicSettings": {
"BackupStorage": "/ThingworxBackupStorage",
"DatabaseLogRetentionPolicy": 7,
"EnableBackup": true,
"EnableClusteredMode": false,
"EnableSystemLogging": false,
"HTTPRequestHeaderMaxLength": 2000,
"HTTPRequestParameterMaxLength": 2000,
"ScriptTimeout": 30,
"Storage": "/ThingworxStorage",
"InternalAesCryptographicKeyLength": 128
},
"AdministratorUserSettings": {
"InitialPassword": "plain text password"
},
"MetricsUserSettings": {
"InitialPassword": "plain text password"
},
"ClusteredModeSettings": {
"CoordinatorConnectionTimeout": 10000,
"CoordinatorHosts": "127.0.0.1:2181",
"CoordinatorMaxRetries": 3,
"CoordinatorRetryTimeout": 3000,
"CoordinatorSessionTimeout": 90000,
"LoadBalancerBase64EncodedCredentials": "QWRtaW5pc3RyYXRvcjp0clVmNnl1ejI/X0d1Yg==",
"PlatformId": "platform1"
},
"SolutionCentralSettings": {
"SolutionCentralHost": "sc-twxci.a.cirrus.msai.devops.ptc.io",
"KeyStorePath": "/ThingworxPlatform/sc-keystore",
"KeyStorePass": "plain text password"
},
"ExtensionPackageImportPolicy": {
"importEnabled": true,
"allowJarResources": true,
"allowJavascriptResources": true,
"allowCSSResources": true,
"allowJSONResources": true,
"allowWebAppResources": true,
"allowEntities": true,
"allowExtensibleEntities": true,
"haCompatibilityImportLevel": "WARN"
},
"ContentTypeSettings": {
"supportedMediaEntityContentTypes": [
"image/svg+xml",
"image/png",
"image/gif",
"image/bmp",
"image/jpeg",
"application/pdf",
"image/vnd.microsoft.icon"
]
}
},
"PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"acquireIncrement": 15,
"acquireRetryAttempts": 3,
"acquireRetryDelay": 5000,
"checkoutTimeout": 1000000,
"driverClass": "org.postgresql.Driver",
"fetchSize": 5000,
"idleConnectionTestPeriod": 60,
"initialPoolSize": 15,
"jdbcUrl": "jdbc:postgresql://10.0.1.11:5432/thingworx3",
"maxConnectionAge": 0,
"maxIdleTime": 0,
"maxIdleTimeExcessConnections": 300,
"maxPoolSize": 100,
"maxStatements": 100,
"minPoolSize": 5,
"numHelperThreads": 8,
"password": "plain text password",
"testConnectionOnCheckout": false,
"unreturnedConnectionTimeout": 0,
"username": "thingworx3"
},
"StreamProcessorSettings": {
"maximumBlockSize": 2500,
"maximumQueueSize": 250000,
"maximumWaitTime": 10000,
"numberOfProcessingThreads": 5,
"scanRate": 5,
"sizeThreshold": 1000
},
"DataTableProcessorSettings": {
"maximumBlockSize": 2500,
"maximumQueueSize": 250000,
"maximumWaitTime": 10000,
"numberOfProcessingThreads": 1,
"scanRate": 5,
"sizeThreshold": 1
},
"ValueStreamProcessorSettings": {
"maximumBlockSize": 2500,
"maximumWaitTime": 10000,
"maximumQueueSize": 500000,
"numberOfProcessingThreads": 5,
"scanRate": 5,
"sizeThreshold": 1000
},
"PersistentPropertyProcessorSettings": {
"maximumBlockSize": 2500,
"maximumWaitTime": 1000,
"maximumQueueSize": 100000,
"numberOfProcessingThreads": 20,
"scanRate": 25,
"sizeThreshold": 1000
}
}
}
}