or@debian-s-2vcpu-4gb-amd-nyc1-01-or-V6:~/openremote$ l total 5776 -rw-r--r-- 1 or or 5903714 Apr 19 01:24 db_v5.bak drwxr-xr-x 6 or or 4096 Apr 20 21:15 deployment -rw-r--r-- 1 or or 2943 Apr 20 16:47 docker-compose.yml or@debian-s-2vcpu-4gb-amd-nyc1-01-or-V6:~/openremote$ cd deployment or@debian-s-2vcpu-4gb-amd-nyc1-01-or-V6:~/openremote/deployment$ l total 24 drwxr-xr-x 4 or or 4096 Apr 19 00:08 console drwxr-xr-x 3 or or 4096 Apr 19 00:08 keycloak drwxr-xr-x 4 or or 4096 Apr 19 00:09 manager drwxr-xr-x 2 or or 4096 Apr 19 00:09 map -rw-r--r-- 1 root root 6110 Apr 20 21:16 openremote.log.0 -rw-r--r-- 1 root root 0 Apr 20 21:15 openremote.log.0.lck or@debian-s-2vcpu-4gb-amd-nyc1-01-or-V6:~/openremote/deployment$ cat *.0 2023-04-20 15:15:54.160 INFO [main ] org.openremote.container.Container : >>> Starting runtime container... 2023-04-20 15:15:54.166 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.syslog.SyslogService 2023-04-20 15:15:54.167 INFO [main ] .openremote.manager.syslog.SyslogService : Syslog service enabled 2023-04-20 15:15:54.172 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.persistence.ManagerPersistenceService 2023-04-20 15:15:54.178 INFO [main ] container.persistence.PersistenceService : Preparing persistence service for database: POSTGRES 2023-04-20 15:15:54.352 INFO [main ] container.persistence.PersistenceService : Setting storage directory to '/storage' 2023-04-20 15:15:54.359 INFO [main ] container.persistence.PersistenceService : Opening database connection: jdbc:postgresql://postgresql:5432/openremote?currentSchema=openremote 2023-04-20 15:15:56.111 INFO [main ] ydb.core.internal.license.VersionPrinter : Flyway Community Edition 9.15.1 by Redgate 2023-04-20 15:15:56.111 INFO [main ] ydb.core.internal.license.VersionPrinter : See release notes here: https://rd.gt/416ObMi 2023-04-20 15:15:56.112 INFO [main ] ydb.core.internal.license.VersionPrinter : 2023-04-20 15:15:56.371 INFO [main ] .internal.database.base.BaseDatabaseType : Database: jdbc:postgresql://postgresql:5432/openremote (PostgreSQL 14.6) 2023-04-20 15:15:56.514 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:56.556 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:56.847 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:56.854 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:56.933 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:56.934 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.035 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.048 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.141 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.148 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.254 INFO [main ] lywaydb.core.internal.command.DbValidate : Successfully validated 7 migrations (execution time 00:00.058s) 2023-04-20 15:15:57.341 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.350 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.378 INFO [main ] flywaydb.core.internal.command.DbMigrate : Current version of schema "openremote": 20230120.01 2023-04-20 15:15:57.387 INFO [main ] flywaydb.core.internal.command.DbMigrate : Schema "openremote" is up to date. No migration necessary. 2023-04-20 15:15:57.405 INFO [main ] container.persistence.PersistenceService : Applied database schema migrations: 0 2023-04-20 15:15:57.458 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.466 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.510 INFO [main ] lywaydb.core.internal.command.DbValidate : Successfully validated 7 migrations (execution time 00:00.028s) 2023-04-20 15:15:57.557 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:57.559 WARNING [main ] ernal.sqlscript.DefaultSqlScriptExecutor : DB: extension "timescaledb_toolkit" already exists, skipping (SQL State: 42710 - Error Code: 0) 2023-04-20 15:15:58.407 INFO [main ] te.model.util.ValueUtil.MODEL_AND_VALUES : Initialising asset model... 2023-04-20 15:16:03.507 INFO [main ] SQL dialect : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect 2023-04-20 15:16:08.878 ERROR [main ] org.hibernate.AssertionFailure : HHH000099: an assertion failure occurred (this may indicate a bug in Hibernate, but is more likely due to unsa fe use of the session): org.hibernate.AssertionFailure: value involves formulas 2023-04-20 15:16:15.353 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.security.ManagerIdentityService 2023-04-20 15:16:15.354 INFO [main ] .manager.security.ManagerIdentityService : Enabling Keycloak identity provider 2023-04-20 15:16:15.437 INFO [main ] curity.keycloak.KeycloakIdentityProvider : Keycloak service URL: http://keycloak:8080/auth 2023-04-20 15:16:16.453 INFO [main ] curity.keycloak.KeycloakIdentityProvider : Connecting to Keycloak server: http://keycloak:8080/auth 2023-04-20 15:16:17.203 INFO [main ] curity.keycloak.KeycloakIdentityProvider : Keycloak identity provider available: http://keycloak:8080/auth 2023-04-20 15:16:17.224 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.setup.SetupService 2023-04-20 15:16:17.226 INFO [main ] rg.openremote.manager.setup.SetupService : Setup service disabled, clean install = false 2023-04-20 15:16:17.228 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.gateway.GatewayService 2023-04-20 15:16:17.313 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.container.timer.TimerService 2023-04-20 15:16:17.314 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.asset.AssetStorageService 2023-04-20 15:16:17.326 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.mqtt.MQTTBrokerService 2023-04-20 15:16:17.342 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.provisioning.ProvisioningService 2023-04-20 15:16:17.344 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.datapoint.AssetDatapointService 2023-04-20 15:16:17.352 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.datapoint.AssetPredictedDatapointService 2023-04-20 15:16:17.354 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.rules.RulesetStorageService 2023-04-20 15:16:17.358 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.asset.AttributeLinkingService 2023-04-20 15:16:17.358 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.asset.AssetProcessingService 2023-04-20 15:16:17.366 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.system.HealthStatusService 2023-04-20 15:16:17.379 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.simulator.SimulatorService 2023-04-20 15:16:17.381 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.map.MapService 2023-04-20 15:16:17.382 WARNING [main ] org.openremote.manager.map.MapService : Map tiles data file not found '/deployment.local/mapdata/mapdata.mbtiles', falling back to built in map 2023-04-20 15:16:17.385 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.notification.NotificationService 2023-04-20 15:16:17.389 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.webhook.WebhookService 2023-04-20 15:16:17.390 INFO [main ] org.openremote.container.Container : Initializing service: org.openremote.manager.apps.ConsoleAppService 2023-04-20 15:16:17.424 INFO [main ] org.openremote.container.web.WebService : Deploying insecure web context: / or@debian-s-2vcpu-4gb-amd-nyc1-01-or-V6:~/openremote/deployment$