search

MDeLuise / plant-it

🪴 Self-hosted, open source gardening companion app
https://plant-it.org
GNU General Public License v3.0
686 stars 25 forks source link

Backend always starts tomcat as https #132

Closed Samurai1201 closed 8 months ago

Samurai1201 commented 8 months ago

Avoid duplicated bug reports

Description

The backend server always starts up tomcat in an https mode. When using http mode, the client always reports that the backend can not be reached. I can reach both the frontend and backend when browsing to them individually, but when using http to connect to the backend server it displays a warning, that this connection is tls only. I also tried the ssl_enabled=true mode, but it causes some issues in browsers that i cant tolerate.

Expected behaviour

The tomcat server is expected to run in an not https mode when setting the env varibale to ssl_enabled=false

Steps to reproduce

I just used the default example from the documentation and modified the paths and ports according to documentation.

Local environment

  1. Docker
  2. Compose.yaml: 
    version: "3"
name: plant-it
services:
backend:
image: msdeluise/plant-it-backend:latest
env_file: backend.env
depends_on:
  - db
  - cache
restart: unless-stopped
volumes:
  - "/pool/config/plantit/upload-dir:/upload-dir"
  - "/pool/config/plantit/certs:/certificates"
ports:
  - "8089:8080"
db:
image: mysql:8.0
restart: always
env_file: backend.env
volumes:
  - "/pool/config/plantit/db:/var/lib/mysql"
cache:
image: redis:7.2.1
restart: always
frontend:
image: msdeluise/plant-it-frontend:latest
env_file: frontend.env
links:
  - backend
ports:
  - "3009:3000"
volumes:
  - "/pool/config/plantit/certs:/certificates"
  3. Backend.env 
    
#
# DB
#
MYSQL_HOST=db
MYSQL_PORT=3306
MYSQL_USERNAME=root
MYSQL_PSW=root
MYSQL_ROOT_PASSWORD=root
MYSQL_DATABASE=bootdb

#

JWT

# JWT_SECRET=mfijekdkmvsfeqlkmqko51421551 JWT_EXP=1

#

Server config

# USERS_LIMIT=2 UPLOAD_DIR=/upload-dir API_PORT=8080 TRAFLE_KEY= ALLOWED_ORIGINS=*

#

Cache

# CACHE_TTL=86400 CACHE_HOST=cache CACHE_PORT=6379

#

SSL

# SSL_ENABLED=false CERTIFICATE_PATH=/certificates/

4. Frontend.env

PORT=3000 API_URL=http://192.168.1.103:8089/api WAIT_TIMEOUT=5000 PAGE_SIZE=25 BROWSER=none SSL_ENABLED=false CERTIFICATE_PATH=/certificates/



### Additional info

Thanks for your work on this cool project.
Hope you can help, would be amazing to use your app!
MDeLuise commented 8 months ago

Hi @Samurai1201, thanks for opening the issue!

Could you please provide the docker compose logs? Since I attempted to replicate your setup on my machine, and it appeared to start with HTTP correctly.

Samurai1201 commented 8 months ago

Backend Logs:

2024-02-25T19:17:53.089200428Z ........+.+...........................+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*....+.............+.....+.+.....+.+.....+....+.....+......+......+.......+...........+....+...+.....+...+....+..+....+..+...............+....+........+.+..+.......+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*..+...............+...+.......+..+.+..+....+.....+.+...+...............+.....+......+......+...+...............+....+..+..................+.......+...+............+...+...........+.+...........+............+..........+...............+..+.+.........+...+......+....................+..........+.....+.......+.....+.........+.+..+.............+.......................................+........+..........+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2024-02-25T19:17:54.345635190Z ...+.........+......+....+.....+.............+..+...+.......+...+..+......+...............+.........+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*.....+....+.........+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*...+........................+.+.....+...+....+........+....+.....+....+.....+..........+..............+...+...+.+......+..+............+...+...............+.+...........+...+...+.........+......+.............+...............+..+........................+....+...........+.+..+.+............+.....+...+.+.........+............+.........+...+.....+.+...............+..............+.......+..............+.......+.....+..........+...+.....+.......+............+..+.............+...+...+.....+......+.....................+....+..............+....+......+..+............+...............+.+.........+...+...+......+...+...+..................+.....+.......+........+...............+.......+..+.+.................+....+.........+.........+..+...............................+..............+.........+....+......+..+............+..........+...+........+.+...+..+....+......+........+.......+........+..........+......+..+.......+..+......+.........+..........+......+...+..+.........+....+............+.........+...+.....+............+.........+....+..+....+.....................+........+...+....+..............+.+..............+.+...+........+....+.....................+...+...............+..+....+.............................+...............+............+.............+...........+...+.......+.....+...+......+....+...+.........+.........+.....+......+...+.......+.....+.........+......+.+............+..+..........+...+..+......+..........+..+...+....+......+...+.....................+..............+....+..+.+.....+...............+............+.......+...........+....+...+...+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2024-02-25T19:17:54.359844289Z -----
2024-02-25T19:17:54.366748010Z Generating self-signed certificate...DONE
2024-02-25T19:17:54.388911659Z Creating the PKCS12 keystore...DONE
2024-02-25T19:17:54.394882583Z Certificate files are not up-to-date. Copying them...DONE
2024-02-25T19:17:54.394930843Z SSL enabled: false
2024-02-25T19:17:54.407586048Z wait-for-it.sh: waiting 120 seconds for db:3306
2024-02-25T19:18:03.452259294Z wait-for-it.sh: db:3306 is available after 9 seconds
2024-02-25T19:18:04.416626252Z 
2024-02-25T19:18:04.416673883Z   .   ____          _            __ _ _
2024-02-25T19:18:04.416684359Z  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
2024-02-25T19:18:04.416694486Z ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
2024-02-25T19:18:04.416704334Z  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
2024-02-25T19:18:04.416739604Z   '  |____| .__|_| |_|_| |_\__, | / / / /
2024-02-25T19:18:04.416749521Z  =========|_|==============|___/=/_/_/_/
2024-02-25T19:18:04.420811967Z  :: Spring Boot ::                (v3.0.1)
2024-02-25T19:18:04.420873497Z 
2024-02-25T19:18:04.521622475Z 2024-02-25T19:18:04.519Z  INFO 14 --- [           main] com.github.mdeluise.ytsms.Application    : Starting Application v0.0.1-SNAPSHOT using Java 21.0.2 with PID 14 (/opt/app/app.jar started by root in /)
2024-02-25T19:18:04.523342940Z 2024-02-25T19:18:04.523Z  INFO 14 --- [           main] com.github.mdeluise.ytsms.Application    : No active profile set, falling back to 1 default profile: "default"
2024-02-25T19:18:05.588492050Z 2024-02-25T19:18:05.588Z  INFO 14 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-02-25T19:18:05.660828487Z 2024-02-25T19:18:05.660Z  INFO 14 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 65 ms. Found 6 JPA repository interfaces.
2024-02-25T19:18:06.610643565Z 2024-02-25T19:18:06.610Z  INFO 14 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (https)
2024-02-25T19:18:06.690717975Z 2024-02-25T19:18:06.690Z  INFO 14 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2115 ms
2024-02-25T19:18:06.803625727Z 2024-02-25T19:18:06.803Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.AutoloadedConfigurations instance liquibase.GlobalConfiguration
2024-02-25T19:18:06.806264044Z 2024-02-25T19:18:06.806Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.AutoloadedConfigurations instance liquibase.integration.commandline.LiquibaseCommandLineConfiguration
2024-02-25T19:18:06.809025351Z 2024-02-25T19:18:06.808Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.AutoloadedConfigurations instance liquibase.hub.HubConfiguration
2024-02-25T19:18:06.810002288Z 2024-02-25T19:18:06.809Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.AutoloadedConfigurations instance liquibase.logging.core.DefaultLoggerConfiguration
2024-02-25T19:18:06.811146005Z 2024-02-25T19:18:06.810Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.AutoloadedConfigurations instance liquibase.sql.SqlConfiguration
2024-02-25T19:18:06.813029200Z 2024-02-25T19:18:06.812Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.AutoloadedConfigurations instance liquibase.parser.ChangeLogParserConfiguration
2024-02-25T19:18:06.813468431Z 2024-02-25T19:18:06.813Z DEBUG 14 --- [           main] liquibase.configuration                  : Found ConfigurationDefinitions in liquibase.GlobalConfiguration
2024-02-25T19:18:06.813506005Z 2024-02-25T19:18:06.813Z DEBUG 14 --- [           main] liquibase.configuration                  : Found ConfigurationDefinitions in liquibase.integration.commandline.LiquibaseCommandLineConfiguration
2024-02-25T19:18:06.813517110Z 2024-02-25T19:18:06.813Z DEBUG 14 --- [           main] liquibase.configuration                  : Found ConfigurationDefinitions in liquibase.hub.HubConfiguration
2024-02-25T19:18:06.813554754Z 2024-02-25T19:18:06.813Z DEBUG 14 --- [           main] liquibase.configuration                  : Found ConfigurationDefinitions in liquibase.logging.core.DefaultLoggerConfiguration
2024-02-25T19:18:06.813583878Z 2024-02-25T19:18:06.813Z DEBUG 14 --- [           main] liquibase.configuration                  : Found ConfigurationDefinitions in liquibase.sql.SqlConfiguration
2024-02-25T19:18:06.813620335Z 2024-02-25T19:18:06.813Z DEBUG 14 --- [           main] liquibase.configuration                  : Found ConfigurationDefinitions in liquibase.parser.ChangeLogParserConfiguration
2024-02-25T19:18:06.815765574Z 2024-02-25T19:18:06.815Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.ConfigurationValueProvider instance liquibase.configuration.core.DeprecatedConfigurationValueProvider
2024-02-25T19:18:06.816526981Z 2024-02-25T19:18:06.816Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.ConfigurationValueProvider instance liquibase.configuration.core.SystemPropertyValueProvider
2024-02-25T19:18:06.817378414Z 2024-02-25T19:18:06.817Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.ConfigurationValueProvider instance liquibase.configuration.core.ScopeValueProvider
2024-02-25T19:18:06.818407732Z 2024-02-25T19:18:06.818Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.configuration.ConfigurationValueProvider instance liquibase.configuration.core.EnvironmentValueProvider
2024-02-25T19:18:06.821611552Z 2024-02-25T19:18:06.821Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.logging.LogService instance liquibase.logging.core.BufferedLogService
2024-02-25T19:18:06.822402921Z 2024-02-25T19:18:06.822Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.logging.LogService instance liquibase.logging.core.CompositeLogService
2024-02-25T19:18:06.822507543Z 2024-02-25T19:18:06.822Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.logging.LogService instance liquibase.logging.core.JavaLogService
2024-02-25T19:18:06.823449979Z 2024-02-25T19:18:06.823Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.servicelocator.ServiceLocator instance liquibase.servicelocator.StandardServiceLocator
2024-02-25T19:18:06.833457508Z 2024-02-25T19:18:06.833Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.shouldRun aka should.run found
2024-02-25T19:18:06.833543762Z 2024-02-25T19:18:06.833Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.shouldRun is using the default value of true
2024-02-25T19:18:06.835888187Z 2024-02-25T19:18:06.834Z  INFO 14 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2024-02-25T19:18:07.130055694Z 2024-02-25T19:18:07.129Z  INFO 14 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@53bc1328
2024-02-25T19:18:07.132413878Z 2024-02-25T19:18:07.132Z  INFO 14 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2024-02-25T19:18:07.148021056Z 2024-02-25T19:18:07.147Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.CockroachDatabase
2024-02-25T19:18:07.148996876Z 2024-02-25T19:18:07.148Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.DB2Database
2024-02-25T19:18:07.149613852Z 2024-02-25T19:18:07.149Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.Db2zDatabase
2024-02-25T19:18:07.150818052Z 2024-02-25T19:18:07.150Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.DerbyDatabase
2024-02-25T19:18:07.151494812Z 2024-02-25T19:18:07.151Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.EnterpriseDBDatabase
2024-02-25T19:18:07.152052563Z 2024-02-25T19:18:07.151Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.FirebirdDatabase
2024-02-25T19:18:07.153033690Z 2024-02-25T19:18:07.152Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.H2Database
2024-02-25T19:18:07.154155548Z 2024-02-25T19:18:07.153Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.HsqlDatabase
2024-02-25T19:18:07.155157558Z 2024-02-25T19:18:07.154Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.InformixDatabase
2024-02-25T19:18:07.155820978Z 2024-02-25T19:18:07.155Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.Ingres9Database
2024-02-25T19:18:07.157221781Z 2024-02-25T19:18:07.157Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.MSSQLDatabase
2024-02-25T19:18:07.158818069Z 2024-02-25T19:18:07.158Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.MariaDBDatabase
2024-02-25T19:18:07.160407931Z 2024-02-25T19:18:07.160Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.MockDatabase
2024-02-25T19:18:07.160547962Z 2024-02-25T19:18:07.160Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.MySQLDatabase
2024-02-25T19:18:07.161937521Z 2024-02-25T19:18:07.161Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.OracleDatabase
2024-02-25T19:18:07.162103603Z 2024-02-25T19:18:07.161Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.PostgresDatabase
2024-02-25T19:18:07.163381764Z 2024-02-25T19:18:07.163Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.SQLiteDatabase
2024-02-25T19:18:07.164292702Z 2024-02-25T19:18:07.164Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.SybaseASADatabase
2024-02-25T19:18:07.165108795Z 2024-02-25T19:18:07.164Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.SybaseDatabase
2024-02-25T19:18:07.165652647Z 2024-02-25T19:18:07.165Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.UnsupportedDatabase
2024-02-25T19:18:07.166633775Z 2024-02-25T19:18:07.166Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.database.Database instance liquibase.database.core.SnowflakeDatabase
2024-02-25T19:18:07.183132195Z 2024-02-25T19:18:07.182Z DEBUG 14 --- [           main] liquibase.database                       : Connected to root@172.138.0.4@jdbc:mysql://db:3306/bootdb?createDatabaseIfNotExist=true&autoReconnect=true&allowPublicKeyRetrieval=true&useSSL=false
2024-02-25T19:18:07.183189045Z 2024-02-25T19:18:07.182Z DEBUG 14 --- [           main] liquibase.database                       : Setting auto commit to false from true
2024-02-25T19:18:07.197815165Z 2024-02-25T19:18:07.197Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.liquibaseSchemaName aka liquibase.schemaName found
2024-02-25T19:18:07.199227981Z 2024-02-25T19:18:07.198Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.supportPropertyEscaping aka enableEscaping found
2024-02-25T19:18:07.199261225Z 2024-02-25T19:18:07.199Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.supportPropertyEscaping is using the default value of false
2024-02-25T19:18:07.204070692Z 2024-02-25T19:18:07.203Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.lockservice.LockService instance liquibase.lockservice.LockServiceImpl
2024-02-25T19:18:07.204590798Z 2024-02-25T19:18:07.204Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.lockservice.LockService instance liquibase.lockservice.MockLockService
2024-02-25T19:18:07.205029121Z 2024-02-25T19:18:07.204Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.lockservice.LockService instance liquibase.lockservice.OfflineLockService
2024-02-25T19:18:07.205242485Z 2024-02-25T19:18:07.205Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.lockservice.LockService instance liquibase.lockservice.StandardLockService
2024-02-25T19:18:07.210918610Z 2024-02-25T19:18:07.210Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.changelogLockWaitTimeInMinutes aka liquibase.changeLogLockWaitTimeInMinutes found
2024-02-25T19:18:07.210962330Z 2024-02-25T19:18:07.210Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.changelogLockWaitTimeInMinutes is using the default value of 5
2024-02-25T19:18:07.214101338Z 2024-02-25T19:18:07.213Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.executor.Executor instance liquibase.executor.jvm.JdbcExecutor
2024-02-25T19:18:07.217839512Z 2024-02-25T19:18:07.217Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.CatalogSnapshotGenerator
2024-02-25T19:18:07.220423563Z 2024-02-25T19:18:07.220Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGenerator
2024-02-25T19:18:07.220948279Z 2024-02-25T19:18:07.220Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGeneratorH2
2024-02-25T19:18:07.221619591Z 2024-02-25T19:18:07.221Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGeneratorInformix
2024-02-25T19:18:07.222264224Z 2024-02-25T19:18:07.222Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ColumnSnapshotGeneratorOracle
2024-02-25T19:18:07.223007753Z 2024-02-25T19:18:07.222Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.DataSnapshotGenerator
2024-02-25T19:18:07.224176962Z 2024-02-25T19:18:07.223Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ForeignKeySnapshotGenerator
2024-02-25T19:18:07.225827237Z 2024-02-25T19:18:07.225Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.IndexSnapshotGenerator
2024-02-25T19:18:07.226840422Z 2024-02-25T19:18:07.226Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.PrimaryKeySnapshotGenerator
2024-02-25T19:18:07.227705962Z 2024-02-25T19:18:07.227Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SchemaSnapshotGenerator
2024-02-25T19:18:07.228659084Z 2024-02-25T19:18:07.228Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SequenceSnapshotGenerator
2024-02-25T19:18:07.229281298Z 2024-02-25T19:18:07.229Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.TableSnapshotGenerator
2024-02-25T19:18:07.230353149Z 2024-02-25T19:18:07.230Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.UniqueConstraintSnapshotGenerator
2024-02-25T19:18:07.231004766Z 2024-02-25T19:18:07.230Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.ViewSnapshotGenerator
2024-02-25T19:18:07.231509228Z 2024-02-25T19:18:07.231Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SchemaSnapshotGeneratorSnowflake
2024-02-25T19:18:07.231947272Z 2024-02-25T19:18:07.231Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.SequenceSnapshotGeneratorSnowflake
2024-02-25T19:18:07.232473105Z 2024-02-25T19:18:07.232Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.snapshot.SnapshotGenerator instance liquibase.snapshot.jvm.UniqueConstraintSnapshotGeneratorSnowflake
2024-02-25T19:18:07.233462893Z 2024-02-25T19:18:07.233Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.liquibaseCatalogName aka liquibase.catalogName found
2024-02-25T19:18:07.235223168Z 2024-02-25T19:18:07.234Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.preserveSchemaCase found
2024-02-25T19:18:07.235273104Z 2024-02-25T19:18:07.235Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.preserveSchemaCase is using the default value of false
2024-02-25T19:18:07.237399416Z 2024-02-25T19:18:07.237Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.241023051Z 2024-02-25T19:18:07.240Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGenerator
2024-02-25T19:18:07.241417304Z 2024-02-25T19:18:07.241Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorDB2
2024-02-25T19:18:07.241876998Z 2024-02-25T19:18:07.241Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorHsqlH2
2024-02-25T19:18:07.242324889Z 2024-02-25T19:18:07.242Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorInformix
2024-02-25T19:18:07.242748056Z 2024-02-25T19:18:07.242Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorMySQL
2024-02-25T19:18:07.243357419Z 2024-02-25T19:18:07.243Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddAutoIncrementGeneratorSQLite
2024-02-25T19:18:07.244047240Z 2024-02-25T19:18:07.243Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGenerator
2024-02-25T19:18:07.244508959Z 2024-02-25T19:18:07.244Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGeneratorDefaultClauseBeforeNotNull
2024-02-25T19:18:07.244896298Z 2024-02-25T19:18:07.244Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddColumnGeneratorSQLite
2024-02-25T19:18:07.245388049Z 2024-02-25T19:18:07.245Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGenerator
2024-02-25T19:18:07.245787330Z 2024-02-25T19:18:07.245Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorDerby
2024-02-25T19:18:07.246269723Z 2024-02-25T19:18:07.246Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorInformix
2024-02-25T19:18:07.246666769Z 2024-02-25T19:18:07.246Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorMSSQL
2024-02-25T19:18:07.247023657Z 2024-02-25T19:18:07.246Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorMySQL
2024-02-25T19:18:07.247417002Z 2024-02-25T19:18:07.247Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorOracle
2024-02-25T19:18:07.247826271Z 2024-02-25T19:18:07.247Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorPostgres
2024-02-25T19:18:07.248191959Z 2024-02-25T19:18:07.248Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSQLite
2024-02-25T19:18:07.248556948Z 2024-02-25T19:18:07.248Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSybase
2024-02-25T19:18:07.248867392Z 2024-02-25T19:18:07.248Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddDefaultValueGeneratorSybaseASA
2024-02-25T19:18:07.249319473Z 2024-02-25T19:18:07.249Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddForeignKeyConstraintGenerator
2024-02-25T19:18:07.249880507Z 2024-02-25T19:18:07.249Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddPrimaryKeyGenerator
2024-02-25T19:18:07.250301090Z 2024-02-25T19:18:07.250Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddPrimaryKeyGeneratorInformix
2024-02-25T19:18:07.250901723Z 2024-02-25T19:18:07.250Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGenerator
2024-02-25T19:18:07.251459614Z 2024-02-25T19:18:07.251Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGeneratorInformix
2024-02-25T19:18:07.251991523Z 2024-02-25T19:18:07.251Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AddUniqueConstraintGeneratorTDS
2024-02-25T19:18:07.252705928Z 2024-02-25T19:18:07.252Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.AlterSequenceGenerator
2024-02-25T19:18:07.253311799Z 2024-02-25T19:18:07.253Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.BatchDmlExecutablePreparedStatementGenerator
2024-02-25T19:18:07.253970750Z 2024-02-25T19:18:07.253Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ClearDatabaseChangeLogTableGenerator
2024-02-25T19:18:07.254533110Z 2024-02-25T19:18:07.254Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CommentGenerator
2024-02-25T19:18:07.255082341Z 2024-02-25T19:18:07.254Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CopyRowsGenerator
2024-02-25T19:18:07.255737939Z 2024-02-25T19:18:07.255Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogLockTableGenerator
2024-02-25T19:18:07.256404083Z 2024-02-25T19:18:07.256Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGenerator
2024-02-25T19:18:07.256973498Z 2024-02-25T19:18:07.256Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateDatabaseChangeLogTableGeneratorSybase
2024-02-25T19:18:07.257765984Z 2024-02-25T19:18:07.257Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGenerator
2024-02-25T19:18:07.259765185Z 2024-02-25T19:18:07.259Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGeneratorFirebird
2024-02-25T19:18:07.260476726Z 2024-02-25T19:18:07.260Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateIndexGeneratorPostgres
2024-02-25T19:18:07.261370622Z 2024-02-25T19:18:07.261Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateProcedureGenerator
2024-02-25T19:18:07.262114919Z 2024-02-25T19:18:07.261Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateSequenceGenerator
2024-02-25T19:18:07.263006440Z 2024-02-25T19:18:07.262Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateTableGenerator
2024-02-25T19:18:07.263684737Z 2024-02-25T19:18:07.263Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateTableGeneratorInformix
2024-02-25T19:18:07.264307230Z 2024-02-25T19:18:07.264Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateViewGenerator
2024-02-25T19:18:07.264764550Z 2024-02-25T19:18:07.264Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateViewGeneratorInformix
2024-02-25T19:18:07.265242333Z 2024-02-25T19:18:07.265Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DeleteGenerator
2024-02-25T19:18:07.265881309Z 2024-02-25T19:18:07.265Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropColumnGenerator
2024-02-25T19:18:07.266633148Z 2024-02-25T19:18:07.266Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropDefaultValueGenerator
2024-02-25T19:18:07.267746555Z 2024-02-25T19:18:07.267Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropForeignKeyConstraintGenerator
2024-02-25T19:18:07.268406553Z 2024-02-25T19:18:07.268Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropIndexGenerator
2024-02-25T19:18:07.268837892Z 2024-02-25T19:18:07.268Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropPrimaryKeyGenerator
2024-02-25T19:18:07.269171383Z 2024-02-25T19:18:07.269Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropProcedureGenerator
2024-02-25T19:18:07.269543007Z 2024-02-25T19:18:07.269Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropSequenceGenerator
2024-02-25T19:18:07.270090002Z 2024-02-25T19:18:07.269Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropTableGenerator
2024-02-25T19:18:07.270703347Z 2024-02-25T19:18:07.270Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropUniqueConstraintGenerator
2024-02-25T19:18:07.271103327Z 2024-02-25T19:18:07.270Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropViewGenerator
2024-02-25T19:18:07.271465872Z 2024-02-25T19:18:07.271Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetNextChangeSetSequenceValueGenerator
2024-02-25T19:18:07.271850417Z 2024-02-25T19:18:07.271Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGenerator
2024-02-25T19:18:07.272219178Z 2024-02-25T19:18:07.272Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorDB2
2024-02-25T19:18:07.272653589Z 2024-02-25T19:18:07.272Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorDerby
2024-02-25T19:18:07.273013830Z 2024-02-25T19:18:07.272Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorFirebird
2024-02-25T19:18:07.273348089Z 2024-02-25T19:18:07.273Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorHsql
2024-02-25T19:18:07.273660349Z 2024-02-25T19:18:07.273Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorInformix
2024-02-25T19:18:07.274064519Z 2024-02-25T19:18:07.273Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorMSSQL
2024-02-25T19:18:07.274591889Z 2024-02-25T19:18:07.274Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorOracle
2024-02-25T19:18:07.274931107Z 2024-02-25T19:18:07.274Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorPostgres
2024-02-25T19:18:07.275289741Z 2024-02-25T19:18:07.275Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSybase
2024-02-25T19:18:07.275602350Z 2024-02-25T19:18:07.275Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.GetViewDefinitionGeneratorSybaseASA
2024-02-25T19:18:07.276109745Z 2024-02-25T19:18:07.275Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InitializeDatabaseChangeLogLockTableGenerator
2024-02-25T19:18:07.276422144Z 2024-02-25T19:18:07.276Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertDataChangeGenerator
2024-02-25T19:18:07.276959153Z 2024-02-25T19:18:07.276Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertGenerator
2024-02-25T19:18:07.278194991Z 2024-02-25T19:18:07.278Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorDB2
2024-02-25T19:18:07.278723478Z 2024-02-25T19:18:07.278Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorH2
2024-02-25T19:18:07.279229407Z 2024-02-25T19:18:07.279Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorHsql
2024-02-25T19:18:07.279857139Z 2024-02-25T19:18:07.279Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorInformix
2024-02-25T19:18:07.280330382Z 2024-02-25T19:18:07.280Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorMSSQL
2024-02-25T19:18:07.280866971Z 2024-02-25T19:18:07.280Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorMySQL
2024-02-25T19:18:07.281312347Z 2024-02-25T19:18:07.281Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorOracle
2024-02-25T19:18:07.281824213Z 2024-02-25T19:18:07.281Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorPostgres
2024-02-25T19:18:07.282274338Z 2024-02-25T19:18:07.282Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSQLite
2024-02-25T19:18:07.282641772Z 2024-02-25T19:18:07.282Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSybaseASA
2024-02-25T19:18:07.283307987Z 2024-02-25T19:18:07.283Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertSetGenerator
2024-02-25T19:18:07.284325082Z 2024-02-25T19:18:07.284Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.LockDatabaseChangeLogGenerator
2024-02-25T19:18:07.284925506Z 2024-02-25T19:18:07.284Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.MarkChangeSetRanGenerator
2024-02-25T19:18:07.285451479Z 2024-02-25T19:18:07.285Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ModifyDataTypeGenerator
2024-02-25T19:18:07.285938132Z 2024-02-25T19:18:07.285Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RawParameterizedSqlGenerator
2024-02-25T19:18:07.286311363Z 2024-02-25T19:18:07.286Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RawSqlGenerator
2024-02-25T19:18:07.286718327Z 2024-02-25T19:18:07.286Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ReindexGeneratorSQLite
2024-02-25T19:18:07.287056637Z 2024-02-25T19:18:07.286Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RemoveChangeSetRanStatusGenerator
2024-02-25T19:18:07.287568782Z 2024-02-25T19:18:07.287Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameColumnGenerator
2024-02-25T19:18:07.288077295Z 2024-02-25T19:18:07.287Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameSequenceGenerator
2024-02-25T19:18:07.288532589Z 2024-02-25T19:18:07.288Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameTableGenerator
2024-02-25T19:18:07.289028670Z 2024-02-25T19:18:07.288Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameViewGenerator
2024-02-25T19:18:07.289554783Z 2024-02-25T19:18:07.289Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.ReorganizeTableGeneratorDB2
2024-02-25T19:18:07.290023696Z 2024-02-25T19:18:07.289Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RuntimeGenerator
2024-02-25T19:18:07.290673008Z 2024-02-25T19:18:07.290Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogGenerator
2024-02-25T19:18:07.291322041Z 2024-02-25T19:18:07.291Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SelectFromDatabaseChangeLogLockGenerator
2024-02-25T19:18:07.291897532Z 2024-02-25T19:18:07.291Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetColumnRemarksGenerator
2024-02-25T19:18:07.292532457Z 2024-02-25T19:18:07.292Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetNullableGenerator
2024-02-25T19:18:07.292960723Z 2024-02-25T19:18:07.292Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetTableRemarksGenerator
2024-02-25T19:18:07.293414899Z 2024-02-25T19:18:07.293Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetViewRemarksGenerator
2024-02-25T19:18:07.293913774Z 2024-02-25T19:18:07.293Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.StoredProcedureGenerator
2024-02-25T19:18:07.294389462Z 2024-02-25T19:18:07.294Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TableRowCountGenerator
2024-02-25T19:18:07.294968864Z 2024-02-25T19:18:07.294Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.TagDatabaseGenerator
2024-02-25T19:18:07.295461104Z 2024-02-25T19:18:07.295Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UnlockDatabaseChangeLogGenerator
2024-02-25T19:18:07.295881687Z 2024-02-25T19:18:07.295Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateChangeSetChecksumGenerator
2024-02-25T19:18:07.296290466Z 2024-02-25T19:18:07.296Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateDataChangeGenerator
2024-02-25T19:18:07.296713215Z 2024-02-25T19:18:07.296Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.UpdateGenerator
2024-02-25T19:18:07.297105163Z 2024-02-25T19:18:07.297Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.CreateSequenceGeneratorSnowflake
2024-02-25T19:18:07.297592234Z 2024-02-25T19:18:07.297Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropDefaultValueGeneratorSnowflake
2024-02-25T19:18:07.298064570Z 2024-02-25T19:18:07.297Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.DropProcedureGeneratorSnowflake
2024-02-25T19:18:07.298562118Z 2024-02-25T19:18:07.298Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSnowflake
2024-02-25T19:18:07.298969989Z 2024-02-25T19:18:07.298Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameTableGeneratorSnowflake
2024-02-25T19:18:07.299374858Z 2024-02-25T19:18:07.299Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.RenameViewGeneratorSnowflake
2024-02-25T19:18:07.299720432Z 2024-02-25T19:18:07.299Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetColumnRemarksGeneratorSnowflake
2024-02-25T19:18:07.300044145Z 2024-02-25T19:18:07.299Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.sqlgenerator.SqlGenerator instance liquibase.sqlgenerator.core.SetTableRemarksGeneratorSnowflake
2024-02-25T19:18:07.331667281Z 2024-02-25T19:18:07.331Z DEBUG 14 --- [           main] liquibase.executor                       : Create Database Lock Table
2024-02-25T19:18:07.332145343Z 2024-02-25T19:18:07.332Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.333301422Z 2024-02-25T19:18:07.333Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.liquibaseTablespaceName aka liquibase.databaseChangeLogTablespaceName aka liquibase.liquibaseTableSpaceName found
2024-02-25T19:18:07.336705547Z 2024-02-25T19:18:07.336Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BigIntType
2024-02-25T19:18:07.337296472Z 2024-02-25T19:18:07.337Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BlobType
2024-02-25T19:18:07.337924483Z 2024-02-25T19:18:07.337Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.BooleanType
2024-02-25T19:18:07.338525605Z 2024-02-25T19:18:07.338Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.CharType
2024-02-25T19:18:07.339276816Z 2024-02-25T19:18:07.339Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.ClobType
2024-02-25T19:18:07.340008122Z 2024-02-25T19:18:07.339Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.CurrencyType
2024-02-25T19:18:07.340838952Z 2024-02-25T19:18:07.340Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DatabaseFunctionType
2024-02-25T19:18:07.342121094Z 2024-02-25T19:18:07.341Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DateTimeType
2024-02-25T19:18:07.343198323Z 2024-02-25T19:18:07.342Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DateType
2024-02-25T19:18:07.344166251Z 2024-02-25T19:18:07.343Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DecimalType
2024-02-25T19:18:07.345145493Z 2024-02-25T19:18:07.344Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.DoubleType
2024-02-25T19:18:07.346051122Z 2024-02-25T19:18:07.345Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.FloatType
2024-02-25T19:18:07.347021424Z 2024-02-25T19:18:07.346Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.IntType
2024-02-25T19:18:07.347828717Z 2024-02-25T19:18:07.347Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.MediumIntType
2024-02-25T19:18:07.348627629Z 2024-02-25T19:18:07.348Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.NCharType
2024-02-25T19:18:07.349461462Z 2024-02-25T19:18:07.349Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.NVarcharType
2024-02-25T19:18:07.350487917Z 2024-02-25T19:18:07.350Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.NumberType
2024-02-25T19:18:07.351488041Z 2024-02-25T19:18:07.351Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.SmallIntType
2024-02-25T19:18:07.352524622Z 2024-02-25T19:18:07.352Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TimeType
2024-02-25T19:18:07.354597366Z 2024-02-25T19:18:07.354Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TimestampType
2024-02-25T19:18:07.355541757Z 2024-02-25T19:18:07.355Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TinyIntType
2024-02-25T19:18:07.356455628Z 2024-02-25T19:18:07.356Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.UUIDType
2024-02-25T19:18:07.356758598Z 2024-02-25T19:18:07.356Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.UnknownType
2024-02-25T19:18:07.357805586Z 2024-02-25T19:18:07.357Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.VarcharType
2024-02-25T19:18:07.358841958Z 2024-02-25T19:18:07.358Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.XMLType
2024-02-25T19:18:07.359683194Z 2024-02-25T19:18:07.359Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TextDataTypeSnowflake
2024-02-25T19:18:07.360637223Z 2024-02-25T19:18:07.360Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.datatype.LiquibaseDataType instance liquibase.datatype.core.TimestampNTZTypeSnowflake
2024-02-25T19:18:07.367358100Z 2024-02-25T19:18:07.367Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.includeCatalogInSpecification found
2024-02-25T19:18:07.367427732Z 2024-02-25T19:18:07.367Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.includeCatalogInSpecification is using the default value of false
2024-02-25T19:18:07.367743204Z 2024-02-25T19:18:07.367Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.sql.logLevel found
2024-02-25T19:18:07.367773934Z 2024-02-25T19:18:07.367Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.sql.logLevel is using the default value of FINE
2024-02-25T19:18:07.367787344Z 2024-02-25T19:18:07.367Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2024-02-25T19:18:07.392167260Z 2024-02-25T19:18:07.391Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:07.393442698Z 2024-02-25T19:18:07.393Z DEBUG 14 --- [           main] liquibase.lockservice                    : Created database lock table with name: bootdb.DATABASECHANGELOGLOCK
2024-02-25T19:18:07.393858672Z 2024-02-25T19:18:07.393Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.402924813Z 2024-02-25T19:18:07.402Z DEBUG 14 --- [           main] liquibase.executor                       : Initialize Database Lock Table
2024-02-25T19:18:07.402964832Z 2024-02-25T19:18:07.402Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.406126677Z 2024-02-25T19:18:07.405Z DEBUG 14 --- [           main] liquibase.executor                       : DELETE FROM bootdb.DATABASECHANGELOGLOCK
2024-02-25T19:18:07.407167309Z 2024-02-25T19:18:07.407Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:07.407310972Z 2024-02-25T19:18:07.407Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0)
2024-02-25T19:18:07.408294894Z 2024-02-25T19:18:07.408Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:07.411363641Z 2024-02-25T19:18:07.411Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.413631591Z 2024-02-25T19:18:07.413Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.415605369Z 2024-02-25T19:18:07.415Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.417365155Z 2024-02-25T19:18:07.417Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.419248280Z 2024-02-25T19:18:07.419Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.421160110Z 2024-02-25T19:18:07.420Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.423409971Z 2024-02-25T19:18:07.423Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.425010589Z 2024-02-25T19:18:07.424Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.426805226Z 2024-02-25T19:18:07.426Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.428323501Z 2024-02-25T19:18:07.428Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.430056538Z 2024-02-25T19:18:07.429Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.431700597Z 2024-02-25T19:18:07.431Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.433360789Z 2024-02-25T19:18:07.433Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.435049826Z 2024-02-25T19:18:07.434Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.436924710Z 2024-02-25T19:18:07.436Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.438455976Z 2024-02-25T19:18:07.438Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.440249565Z 2024-02-25T19:18:07.440Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.442095953Z 2024-02-25T19:18:07.441Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.445452865Z 2024-02-25T19:18:07.445Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.448700895Z 2024-02-25T19:18:07.448Z DEBUG 14 --- [           main] liquibase.executor                       : Lock Database
2024-02-25T19:18:07.449418232Z 2024-02-25T19:18:07.449Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.458520342Z 2024-02-25T19:18:07.458Z  INFO 14 --- [           main] liquibase.lockservice                    : Successfully acquired change log lock
2024-02-25T19:18:07.465764538Z 2024-02-25T19:18:07.465Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.MockChangeLogHistoryService
2024-02-25T19:18:07.469110415Z 2024-02-25T19:18:07.468Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.StandardChangeLogHistoryService
2024-02-25T19:18:07.477492183Z 2024-02-25T19:18:07.477Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.formattedsql.FormattedSqlChangeLogParser
2024-02-25T19:18:07.481813670Z 2024-02-25T19:18:07.481Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.json.JsonChangeLogParser
2024-02-25T19:18:07.482775941Z 2024-02-25T19:18:07.482Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.sql.SqlChangeLogParser
2024-02-25T19:18:07.491293410Z 2024-02-25T19:18:07.491Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.secureParsing found
2024-02-25T19:18:07.491337061Z 2024-02-25T19:18:07.491Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.secureParsing is using the default value of true
2024-02-25T19:18:07.491404388Z 2024-02-25T19:18:07.491Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.xml.XMLChangeLogSAXParser
2024-02-25T19:18:07.491719650Z 2024-02-25T19:18:07.491Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.parser.ChangeLogParser instance liquibase.parser.core.yaml.YamlChangeLogParser
2024-02-25T19:18:07.540211154Z 2024-02-25T19:18:07.539Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.CustomPreconditionWrapper
2024-02-25T19:18:07.540404474Z 2024-02-25T19:18:07.540Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.AndPrecondition
2024-02-25T19:18:07.541330567Z 2024-02-25T19:18:07.541Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ChangeLogPropertyDefinedPrecondition
2024-02-25T19:18:07.542237034Z 2024-02-25T19:18:07.542Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ChangeSetExecutedPrecondition
2024-02-25T19:18:07.543506885Z 2024-02-25T19:18:07.543Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ColumnExistsPrecondition
2024-02-25T19:18:07.544312781Z 2024-02-25T19:18:07.544Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.DBMSPrecondition
2024-02-25T19:18:07.545254379Z 2024-02-25T19:18:07.545Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ForeignKeyExistsPrecondition
2024-02-25T19:18:07.546185011Z 2024-02-25T19:18:07.546Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.IndexExistsPrecondition
2024-02-25T19:18:07.546876647Z 2024-02-25T19:18:07.546Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.NotPrecondition
2024-02-25T19:18:07.547620175Z 2024-02-25T19:18:07.547Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ObjectQuotingStrategyPrecondition
2024-02-25T19:18:07.548312580Z 2024-02-25T19:18:07.548Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.OrPrecondition
2024-02-25T19:18:07.548411475Z 2024-02-25T19:18:07.548Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.PreconditionContainer
2024-02-25T19:18:07.549284209Z 2024-02-25T19:18:07.549Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.PrimaryKeyExistsPrecondition
2024-02-25T19:18:07.550213794Z 2024-02-25T19:18:07.550Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.RowCountPrecondition
2024-02-25T19:18:07.551042947Z 2024-02-25T19:18:07.550Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.RunningAsPrecondition
2024-02-25T19:18:07.557650263Z 2024-02-25T19:18:07.557Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.SequenceExistsPrecondition
2024-02-25T19:18:07.558827435Z 2024-02-25T19:18:07.558Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.SqlPrecondition
2024-02-25T19:18:07.559740677Z 2024-02-25T19:18:07.559Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.TableExistsPrecondition
2024-02-25T19:18:07.560474497Z 2024-02-25T19:18:07.560Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.TableIsEmptyPrecondition
2024-02-25T19:18:07.561635814Z 2024-02-25T19:18:07.561Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.UniqueConstraintExistsPrecondition
2024-02-25T19:18:07.562677564Z 2024-02-25T19:18:07.562Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.precondition.Precondition instance liquibase.precondition.core.ViewExistsPrecondition
2024-02-25T19:18:07.614063422Z 2024-02-25T19:18:07.613Z DEBUG 14 --- [           main] liquibase.parser                         : Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
2024-02-25T19:18:07.684893596Z 2024-02-25T19:18:07.684Z DEBUG 14 --- [           main] liquibase.parser                         : Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.1.xsd'
2024-02-25T19:18:07.733067881Z 2024-02-25T19:18:07.732Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddAutoIncrementChange
2024-02-25T19:18:07.734443750Z 2024-02-25T19:18:07.734Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddColumnChange
2024-02-25T19:18:07.735261450Z 2024-02-25T19:18:07.735Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddDefaultValueChange
2024-02-25T19:18:07.736227631Z 2024-02-25T19:18:07.736Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddForeignKeyConstraintChange
2024-02-25T19:18:07.737201705Z 2024-02-25T19:18:07.737Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddLookupTableChange
2024-02-25T19:18:07.738000338Z 2024-02-25T19:18:07.737Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddNotNullConstraintChange
2024-02-25T19:18:07.738766774Z 2024-02-25T19:18:07.738Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddPrimaryKeyChange
2024-02-25T19:18:07.739645165Z 2024-02-25T19:18:07.739Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AddUniqueConstraintChange
2024-02-25T19:18:07.740482630Z 2024-02-25T19:18:07.740Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.AlterSequenceChange
2024-02-25T19:18:07.741394684Z 2024-02-25T19:18:07.741Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.CreateIndexChange
2024-02-25T19:18:07.743004033Z 2024-02-25T19:18:07.742Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.CreateProcedureChange
2024-02-25T19:18:07.743803364Z 2024-02-25T19:18:07.743Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.CreateSequenceChange
2024-02-25T19:18:07.744828771Z 2024-02-25T19:18:07.744Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.CreateTableChange
2024-02-25T19:18:07.745864793Z 2024-02-25T19:18:07.745Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.CreateViewChange
2024-02-25T19:18:07.746886429Z 2024-02-25T19:18:07.746Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DeleteDataChange
2024-02-25T19:18:07.748224863Z 2024-02-25T19:18:07.747Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropAllForeignKeyConstraintsChange
2024-02-25T19:18:07.749873672Z 2024-02-25T19:18:07.749Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropColumnChange
2024-02-25T19:18:07.751131440Z 2024-02-25T19:18:07.750Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropDefaultValueChange
2024-02-25T19:18:07.751747228Z 2024-02-25T19:18:07.751Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropForeignKeyConstraintChange
2024-02-25T19:18:07.752323767Z 2024-02-25T19:18:07.752Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropIndexChange
2024-02-25T19:18:07.752884381Z 2024-02-25T19:18:07.752Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropNotNullConstraintChange
2024-02-25T19:18:07.753609890Z 2024-02-25T19:18:07.753Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropPrimaryKeyChange
2024-02-25T19:18:07.754283717Z 2024-02-25T19:18:07.754Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropProcedureChange
2024-02-25T19:18:07.754897201Z 2024-02-25T19:18:07.754Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropSequenceChange
2024-02-25T19:18:07.755609301Z 2024-02-25T19:18:07.755Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropTableChange
2024-02-25T19:18:07.756515349Z 2024-02-25T19:18:07.756Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropUniqueConstraintChange
2024-02-25T19:18:07.757195043Z 2024-02-25T19:18:07.757Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.DropViewChange
2024-02-25T19:18:07.757651524Z 2024-02-25T19:18:07.757Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.EmptyChange
2024-02-25T19:18:07.758994987Z 2024-02-25T19:18:07.758Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.ExecuteShellCommandChange
2024-02-25T19:18:07.759753601Z 2024-02-25T19:18:07.759Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.InsertDataChange
2024-02-25T19:18:07.764565652Z 2024-02-25T19:18:07.764Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.LoadDataChange
2024-02-25T19:18:07.765392849Z 2024-02-25T19:18:07.765Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.LoadUpdateDataChange
2024-02-25T19:18:07.766129394Z 2024-02-25T19:18:07.765Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.MergeColumnChange
2024-02-25T19:18:07.766789112Z 2024-02-25T19:18:07.766Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.ModifyDataTypeChange
2024-02-25T19:18:07.767429625Z 2024-02-25T19:18:07.767Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.OutputChange
2024-02-25T19:18:07.768561330Z 2024-02-25T19:18:07.768Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.RawSQLChange
2024-02-25T19:18:07.769150579Z 2024-02-25T19:18:07.768Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.RenameColumnChange
2024-02-25T19:18:07.769757917Z 2024-02-25T19:18:07.769Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.RenameSequenceChange
2024-02-25T19:18:07.770415681Z 2024-02-25T19:18:07.770Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.RenameTableChange
2024-02-25T19:18:07.770997876Z 2024-02-25T19:18:07.770Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.RenameViewChange
2024-02-25T19:18:07.771709207Z 2024-02-25T19:18:07.771Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.SQLFileChange
2024-02-25T19:18:07.772329676Z 2024-02-25T19:18:07.772Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.SetColumnRemarksChange
2024-02-25T19:18:07.772854322Z 2024-02-25T19:18:07.772Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.SetTableRemarksChange
2024-02-25T19:18:07.773364651Z 2024-02-25T19:18:07.773Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.StopChange
2024-02-25T19:18:07.773835519Z 2024-02-25T19:18:07.773Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.TagDatabaseChange
2024-02-25T19:18:07.774587149Z 2024-02-25T19:18:07.774Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.core.UpdateDataChange
2024-02-25T19:18:07.775808600Z 2024-02-25T19:18:07.775Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.change.Change instance liquibase.change.custom.CustomChangeWrapper
2024-02-25T19:18:07.883732212Z 2024-02-25T19:18:07.883Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.MockChangeLogHistoryService
2024-02-25T19:18:07.883778866Z 2024-02-25T19:18:07.883Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.changelog.ChangeLogHistoryService instance liquibase.changelog.StandardChangeLogHistoryService
2024-02-25T19:18:07.887029829Z 2024-02-25T19:18:07.886Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.outputFileEncoding found
2024-02-25T19:18:07.887069778Z 2024-02-25T19:18:07.886Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.outputFileEncoding is using the default value of UTF-8
2024-02-25T19:18:07.887488056Z 2024-02-25T19:18:07.887Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 1708888687886 as f661b4a3e85af5f73f9eefc40877d8eb
2024-02-25T19:18:07.902970777Z 2024-02-25T19:18:07.902Z DEBUG 14 --- [           main] liquibase.executor                       : Create Database Change Log Table
2024-02-25T19:18:07.903297075Z 2024-02-25T19:18:07.903Z  INFO 14 --- [           main] liquibase.changelog                      : Creating database history table with name: bootdb.DATABASECHANGELOG
2024-02-25T19:18:07.903492211Z 2024-02-25T19:18:07.903Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.904699344Z 2024-02-25T19:18:07.904Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, `DESCRIPTION` VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL)
2024-02-25T19:18:07.919780409Z 2024-02-25T19:18:07.919Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:07.920527080Z 2024-02-25T19:18:07.920Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.922303558Z 2024-02-25T19:18:07.922Z  INFO 14 --- [           main] liquibase.changelog                      : Reading from bootdb.DATABASECHANGELOG
2024-02-25T19:18:07.922479278Z 2024-02-25T19:18:07.922Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.926154106Z 2024-02-25T19:18:07.925Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.927977727Z 2024-02-25T19:18:07.927Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.929984191Z 2024-02-25T19:18:07.929Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.931777990Z 2024-02-25T19:18:07.931Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.933872873Z 2024-02-25T19:18:07.933Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.935761097Z 2024-02-25T19:18:07.935Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.937378546Z 2024-02-25T19:18:07.937Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.939029171Z 2024-02-25T19:18:07.938Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.940720791Z 2024-02-25T19:18:07.940Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.942404241Z 2024-02-25T19:18:07.942Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.943802879Z 2024-02-25T19:18:07.943Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.945323319Z 2024-02-25T19:18:07.945Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.946705334Z 2024-02-25T19:18:07.946Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.948066886Z 2024-02-25T19:18:07.947Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.949450508Z 2024-02-25T19:18:07.949Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.950828473Z 2024-02-25T19:18:07.950Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.952263707Z 2024-02-25T19:18:07.952Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.953483412Z 2024-02-25T19:18:07.953Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.955530035Z 2024-02-25T19:18:07.955Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.957546137Z 2024-02-25T19:18:07.957Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:07.999766051Z 2024-02-25T19:18:07.999Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for createTable:[
2024-02-25T19:18:07.999791753Z     columns=[
2024-02-25T19:18:07.999796083Z         [
2024-02-25T19:18:07.999800762Z             [
2024-02-25T19:18:07.999803625Z                 primaryKey="true"
2024-02-25T19:18:07.999808375Z             ]
2024-02-25T19:18:07.999813124Z             name="id"
2024-02-25T19:18:07.999817524Z             type="bigint"
2024-02-25T19:18:07.999821854Z         ],
2024-02-25T19:18:07.999825625Z         [
2024-02-25T19:18:07.999830375Z             [
2024-02-25T19:18:07.999834146Z                 nullable="false"
2024-02-25T19:18:07.999840781Z             ]
2024-02-25T19:18:07.999844622Z             name="username"
2024-02-25T19:18:07.999863759Z             type="varchar(255)"
2024-02-25T19:18:07.999868019Z         ],
2024-02-25T19:18:07.999872279Z         [
2024-02-25T19:18:07.999876609Z             [
2024-02-25T19:18:07.999880940Z                 nullable="false"
2024-02-25T19:18:07.999884292Z             ]
2024-02-25T19:18:07.999889041Z             name="password"
2024-02-25T19:18:07.999892813Z             type="varchar(255)"
2024-02-25T19:18:07.999897632Z         ]
2024-02-25T19:18:07.999901822Z     ]
2024-02-25T19:18:07.999905663Z     tableName="application_users"
2024-02-25T19:18:07.999909016Z ] as 327c6dfc94039fac007a3f862beb4791
2024-02-25T19:18:07.999962863Z 2024-02-25T19:18:07.999Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 8:327c6dfc94039fac007a3f862beb4791: as 682efcbf4c41d174dee4958c88dc85d8
2024-02-25T19:18:08.028340413Z 2024-02-25T19:18:08.028Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for createTable:[
2024-02-25T19:18:08.028375683Z     columns=[
2024-02-25T19:18:08.028385601Z         [
2024-02-25T19:18:08.028403340Z             [
2024-02-25T19:18:08.028412350Z                 nullable="false"
2024-02-25T19:18:08.028421918Z                 primaryKey="true"
2024-02-25T19:18:08.028431067Z             ]
2024-02-25T19:18:08.028440496Z             name="id"
2024-02-25T19:18:08.028449994Z             type="varchar(255)"
2024-02-25T19:18:08.028459213Z         ],
2024-02-25T19:18:08.028468642Z         [
2024-02-25T19:18:08.028477232Z             name="name"
2024-02-25T19:18:08.028486311Z             type="varchar(100)"
2024-02-25T19:18:08.028495461Z         ],
2024-02-25T19:18:08.028503353Z         [
2024-02-25T19:18:08.028512502Z             name="thumbnail_link"
2024-02-25T19:18:08.028521721Z             type="varchar(255)"
2024-02-25T19:18:08.028531149Z         ]
2024-02-25T19:18:08.028540019Z     ]
2024-02-25T19:18:08.028548540Z     tableName="channels"
2024-02-25T19:18:08.028557689Z ] as 03485cd689346205384786a646dfbdee
2024-02-25T19:18:08.028572006Z 2024-02-25T19:18:08.028Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 8:03485cd689346205384786a646dfbdee: as c9a620572d01ff2ac6d078efcc33d12a
2024-02-25T19:18:08.034631978Z 2024-02-25T19:18:08.034Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for createTable:[
2024-02-25T19:18:08.034658657Z     columns=[
2024-02-25T19:18:08.034663476Z         [
2024-02-25T19:18:08.034667317Z             [
2024-02-25T19:18:08.034681146Z                 nullable="false"
2024-02-25T19:18:08.034685825Z                 primaryKey="true"
2024-02-25T19:18:08.034689666Z             ]
2024-02-25T19:18:08.034694485Z             name="id"
2024-02-25T19:18:08.034698327Z             type="bigint"
2024-02-25T19:18:08.034702657Z         ],
2024-02-25T19:18:08.034706428Z         [
2024-02-25T19:18:08.034710689Z             [
2024-02-25T19:18:08.034715438Z                 foreignKeyName="fk_subscription_channel"
2024-02-25T19:18:08.034720606Z                 nullable="false"
2024-02-25T19:18:08.034724936Z                 references="channels(id)"
2024-02-25T19:18:08.034729336Z             ]
2024-02-25T19:18:08.034733666Z             name="channel_id"
2024-02-25T19:18:08.034737857Z             type="varchar(255)"
2024-02-25T19:18:08.034742117Z         ],
2024-02-25T19:18:08.034746936Z         [
2024-02-25T19:18:08.034750219Z             [
2024-02-25T19:18:08.034754968Z                 foreignKeyName="fk_subscr... [truncated in log] as f6292cc69b4862f26408c33fcd0ac572
2024-02-25T19:18:08.035491372Z 2024-02-25T19:18:08.035Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for addUniqueConstraint:[
2024-02-25T19:18:08.035511486Z     columnNames="channel_id, user_id"
2024-02-25T19:18:08.035517144Z     constraintName="subscription_unique"
2024-02-25T19:18:08.035521404Z     tableName="subscriptions"
2024-02-25T19:18:08.035526712Z ] as 8e80b27154734f55fdb78117843cbe6a
2024-02-25T19:18:08.035652426Z 2024-02-25T19:18:08.035Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 8:f6292cc69b4862f26408c33fcd0ac572:8:8e80b27154734f55fdb78117843cbe6a: as 38bd7b425522ad131451fb20919b13aa
2024-02-25T19:18:08.061872306Z 2024-02-25T19:18:08.061Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for createTable:[
2024-02-25T19:18:08.061925664Z     columns=[
2024-02-25T19:18:08.061939074Z         [
2024-02-25T19:18:08.061951366Z             [
2024-02-25T19:18:08.061962959Z                 primaryKey="true"
2024-02-25T19:18:08.061975251Z             ]
2024-02-25T19:18:08.061986705Z             name="id"
2024-02-25T19:18:08.061998299Z             type="varchar(255)"
2024-02-25T19:18:08.062010451Z         ],
2024-02-25T19:18:08.062021556Z         [
2024-02-25T19:18:08.062033010Z             [
2024-02-25T19:18:08.062047607Z                 foreignKeyName="fk_video_channel"
2024-02-25T19:18:08.062059061Z                 nullable="false"
2024-02-25T19:18:08.062106972Z                 references="channels(id)"
2024-02-25T19:18:08.062120870Z             ]
2024-02-25T19:18:08.062130927Z             name="channel_id"
2024-02-25T19:18:08.062145594Z             type="varchar(255)"
2024-02-25T19:18:08.062155232Z         ],
2024-02-25T19:18:08.062166127Z         [
2024-02-25T19:18:08.062176533Z             [
2024-02-25T19:18:08.062187638Z                 nullable="false"
2024-02-25T19:18:08.062199022Z             ]
2024-02-25T19:18:08.062209498Z             name="title"
2024-02-25T19:18:08.062220603Z    ... [truncated in log] as 6fe95a4540b15d0192188cd50c25291f
2024-02-25T19:18:08.062237644Z 2024-02-25T19:18:08.061Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 8:6fe95a4540b15d0192188cd50c25291f: as 595e27efb7e5cf5dd4172ceb0554e41e
2024-02-25T19:18:08.067448557Z 2024-02-25T19:18:08.067Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for createTable:[
2024-02-25T19:18:08.067496748Z     columns=[
2024-02-25T19:18:08.067509529Z         [
2024-02-25T19:18:08.067520005Z             [
2024-02-25T19:18:08.067528735Z                 primaryKey="true"
2024-02-25T19:18:08.067540049Z             ]
2024-02-25T19:18:08.067550037Z             name="id"
2024-02-25T19:18:08.067560164Z             type="bigint"
2024-02-25T19:18:08.067570640Z         ],
2024-02-25T19:18:08.067581046Z         [
2024-02-25T19:18:08.067590684Z             [
2024-02-25T19:18:08.067601649Z                 nullable="false"
2024-02-25T19:18:08.067611916Z             ]
2024-02-25T19:18:08.067621903Z             name="quota_day"
2024-02-25T19:18:08.067632519Z             type="datetime"
2024-02-25T19:18:08.067642436Z         ],
2024-02-25T19:18:08.067651935Z         [
2024-02-25T19:18:08.067662062Z             [
2024-02-25T19:18:08.067672049Z                 nullable="false"
2024-02-25T19:18:08.067681477Z             ]
2024-02-25T19:18:08.067691674Z             name="quota_value"
2024-02-25T19:18:08.067701592Z             type="int"
2024-02-25T19:18:08.067711579Z         ]
2024-02-25T19:18:08.067721706Z     ]
2024-02-25T19:18:08.067731623Z     tableName="quotas"
2024-02-25T19:18:08.067742100Z ] as 55eb0ac396a989ba3b17cc9c6f5e4014
2024-02-25T19:18:08.067758931Z 2024-02-25T19:18:08.067Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 8:55eb0ac396a989ba3b17cc9c6f5e4014: as a7319259267e218a7445039c5ba66816
2024-02-25T19:18:08.072661356Z 2024-02-25T19:18:08.072Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for createTable:[
2024-02-25T19:18:08.072744258Z     columns=[
2024-02-25T19:18:08.072757108Z         [
2024-02-25T19:18:08.072767585Z             [
2024-02-25T19:18:08.072778689Z                 primaryKey="true"
2024-02-25T19:18:08.072793356Z             ]
2024-02-25T19:18:08.072808232Z             name="id"
2024-02-25T19:18:08.072822410Z             type="bigint"
2024-02-25T19:18:08.072836727Z         ],
2024-02-25T19:18:08.072850137Z         [
2024-02-25T19:18:08.072863896Z             [
2024-02-25T19:18:08.072877375Z                 foreignKeyName="fk_apiKey_user"
2024-02-25T19:18:08.072891902Z                 nullable="false"
2024-02-25T19:18:08.072905800Z                 references="application_users(id)"
2024-02-25T19:18:08.072919629Z             ]
2024-02-25T19:18:08.072933387Z             name="user_id"
2024-02-25T19:18:08.072947286Z             type="bigint"
2024-02-25T19:18:08.072961463Z         ],
2024-02-25T19:18:08.072974524Z         [
2024-02-25T19:18:08.072987305Z             [
2024-02-25T19:18:08.073001203Z                 unique="true"
2024-02-25T19:18:08.073014962Z             ]
2024-02-25T19:18:08.073025857Z             name="api_key_value"
2024-02-25T19:18:08.073036962Z       ... [truncated in log] as d972ca5b3643a50b7354274106828976
2024-02-25T19:18:08.073052606Z 2024-02-25T19:18:08.072Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for addUniqueConstraint:[
2024-02-25T19:18:08.073064619Z     columnNames="user_id, name"
2024-02-25T19:18:08.073076422Z     constraintName="api_key_name_unique"
2024-02-25T19:18:08.073089831Z     tableName="api_keys"
2024-02-25T19:18:08.073103730Z ] as f5dd49f3c428fd91afad641fe05a60b4
2024-02-25T19:18:08.073116022Z 2024-02-25T19:18:08.072Z DEBUG 14 --- [           main] liquibase.util                           : Computed checksum for 8:d972ca5b3643a50b7354274106828976:8:f5dd49f3c428fd91afad641fe05a60b4: as a3c4d8c1ad67bf1793ff05b73c3458fe
2024-02-25T19:18:08.083521016Z 2024-02-25T19:18:08.083Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.hub.HubService instance liquibase.hub.core.MockHubService
2024-02-25T19:18:08.105323238Z 2024-02-25T19:18:08.105Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.hub.HubService instance liquibase.hub.core.StandardHubService
2024-02-25T19:18:08.105513625Z 2024-02-25T19:18:08.105Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.hub.mode found
2024-02-25T19:18:08.105548476Z 2024-02-25T19:18:08.105Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.hub.mode is using the default value of ALL
2024-02-25T19:18:08.105755624Z 2024-02-25T19:18:08.105Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.headless found
2024-02-25T19:18:08.105792291Z 2024-02-25T19:18:08.105Z DEBUG 14 --- [           main] liquibase.configuration                  : Configuration liquibase.headless is using the default value of false
2024-02-25T19:18:08.106319591Z 2024-02-25T19:18:08.106Z DEBUG 14 --- [           main] liquibase.ui                             : No system console detected for user input
2024-02-25T19:18:08.106346340Z 2024-02-25T19:18:08.106Z DEBUG 14 --- [           main] liquibase.ui                             : To override or validate the auto-detected environment for user input, set the liquibase.headless property in liquibase.properties file.
2024-02-25T19:18:08.107021634Z 2024-02-25T19:18:08.106Z DEBUG 14 --- [           main] liquibase.configuration                  : No configuration value for liquibase.hub.apiKey found
2024-02-25T19:18:08.109203190Z Running Changeset: dblogs/changelog/changes/changelog-0.xml::createUserTable::MDeLuise
2024-02-25T19:18:08.109878134Z 2024-02-25T19:18:08.109Z DEBUG 14 --- [           main] liquibase.changelog                      : Running Changeset: dblogs/changelog/changes/changelog-0.xml::createUserTable::MDeLuise
2024-02-25T19:18:08.110435186Z 2024-02-25T19:18:08.110Z DEBUG 14 --- [           main] liquibase.executor                       : Changeset dblogs/changelog/changes/changelog-0.xml::createUserTable::MDeLuise
2024-02-25T19:18:08.118380937Z 2024-02-25T19:18:08.118Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.CatalogComparator
2024-02-25T19:18:08.118691380Z 2024-02-25T19:18:08.118Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.ColumnComparator
2024-02-25T19:18:08.119066776Z 2024-02-25T19:18:08.118Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.DefaultDatabaseObjectComparator
2024-02-25T19:18:08.119448318Z 2024-02-25T19:18:08.119Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.ForeignKeyComparator
2024-02-25T19:18:08.119808419Z 2024-02-25T19:18:08.119Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.IndexComparator
2024-02-25T19:18:08.120133669Z 2024-02-25T19:18:08.120Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.PrimaryKeyComparator
2024-02-25T19:18:08.120694772Z 2024-02-25T19:18:08.120Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.SchemaComparator
2024-02-25T19:18:08.121073520Z 2024-02-25T19:18:08.120Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.TableComparator
2024-02-25T19:18:08.121419862Z 2024-02-25T19:18:08.121Z DEBUG 14 --- [           main] liquibase.servicelocator                 : Loaded liquibase.diff.compare.DatabaseObjectComparator instance liquibase.diff.compare.core.UniqueConstraintComparator
2024-02-25T19:18:08.132186075Z 2024-02-25T19:18:08.131Z DEBUG 14 --- [           main] liquibase.changelog                      : Reading ChangeSet: dblogs/changelog/changes/changelog-0.xml::createUserTable::MDeLuise
2024-02-25T19:18:08.132791388Z 2024-02-25T19:18:08.132Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.CreateTableStatement@108bdbd8
2024-02-25T19:18:08.132814226Z 2024-02-25T19:18:08.132Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.133323297Z 2024-02-25T19:18:08.133Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.application_users (id BIGINT NOT NULL, username VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, CONSTRAINT PK_APPLICATION_USERS PRIMARY KEY (id))
2024-02-25T19:18:08.148495575Z 2024-02-25T19:18:08.148Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.148535524Z 2024-02-25T19:18:08.148Z  INFO 14 --- [           main] liquibase.changelog                      : Table application_users created
2024-02-25T19:18:08.148956177Z 2024-02-25T19:18:08.148Z  INFO 14 --- [           main] liquibase.changelog                      : ChangeSet dblogs/changelog/changes/changelog-0.xml::createUserTable::MDeLuise ran successfully in 39ms
2024-02-25T19:18:08.149134620Z 2024-02-25T19:18:08.149Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.149551083Z 2024-02-25T19:18:08.149Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.151485960Z 2024-02-25T19:18:08.151Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('createUserTable', 'MDeLuise', 'dblogs/changelog/changes/changelog-0.xml', NOW(), 1, '8:682efcbf4c41d174dee4958c88dc85d8', 'createTable tableName=application_users', '', 'EXECUTED', NULL, NULL, '4.18.0', '8888687959')
2024-02-25T19:18:08.152530085Z 2024-02-25T19:18:08.152Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:08.155329734Z Running Changeset: dblogs/changelog/changes/changelog-0.xml::createChannelTable::MDeLuise
2024-02-25T19:18:08.155485270Z 2024-02-25T19:18:08.155Z DEBUG 14 --- [           main] liquibase.changelog                      : Running Changeset: dblogs/changelog/changes/changelog-0.xml::createChannelTable::MDeLuise
2024-02-25T19:18:08.155829866Z 2024-02-25T19:18:08.155Z DEBUG 14 --- [           main] liquibase.executor                       : Changeset dblogs/changelog/changes/changelog-0.xml::createChannelTable::MDeLuise
2024-02-25T19:18:08.163393446Z 2024-02-25T19:18:08.163Z DEBUG 14 --- [           main] liquibase.changelog                      : Reading ChangeSet: dblogs/changelog/changes/changelog-0.xml::createChannelTable::MDeLuise
2024-02-25T19:18:08.163797826Z 2024-02-25T19:18:08.163Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.CreateTableStatement@27d57a2c
2024-02-25T19:18:08.163833585Z 2024-02-25T19:18:08.163Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.164103171Z 2024-02-25T19:18:08.164Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.channels (id VARCHAR(255) NOT NULL, name VARCHAR(100) NULL, thumbnail_link VARCHAR(255) NULL, CONSTRAINT PK_CHANNELS PRIMARY KEY (id))
2024-02-25T19:18:08.177833091Z 2024-02-25T19:18:08.177Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.177899370Z 2024-02-25T19:18:08.177Z  INFO 14 --- [           main] liquibase.changelog                      : Table channels created
2024-02-25T19:18:08.178267642Z 2024-02-25T19:18:08.178Z  INFO 14 --- [           main] liquibase.changelog                      : ChangeSet dblogs/changelog/changes/changelog-0.xml::createChannelTable::MDeLuise ran successfully in 23ms
2024-02-25T19:18:08.178333851Z 2024-02-25T19:18:08.178Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.179226141Z 2024-02-25T19:18:08.179Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('createChannelTable', 'MDeLuise', 'dblogs/changelog/changes/changelog-0.xml', NOW(), 2, '8:c9a620572d01ff2ac6d078efcc33d12a', 'createTable tableName=channels', '', 'EXECUTED', NULL, NULL, '4.18.0', '8888687959')
2024-02-25T19:18:08.180385782Z 2024-02-25T19:18:08.180Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:08.182747109Z Running Changeset: dblogs/changelog/changes/changelog-0.xml::createSubscriptionTable::MDeLuise
2024-02-25T19:18:08.182882531Z 2024-02-25T19:18:08.182Z DEBUG 14 --- [           main] liquibase.changelog                      : Running Changeset: dblogs/changelog/changes/changelog-0.xml::createSubscriptionTable::MDeLuise
2024-02-25T19:18:08.183229222Z 2024-02-25T19:18:08.183Z DEBUG 14 --- [           main] liquibase.executor                       : Changeset dblogs/changelog/changes/changelog-0.xml::createSubscriptionTable::MDeLuise
2024-02-25T19:18:08.190503590Z 2024-02-25T19:18:08.190Z DEBUG 14 --- [           main] liquibase.changelog                      : Reading ChangeSet: dblogs/changelog/changes/changelog-0.xml::createSubscriptionTable::MDeLuise
2024-02-25T19:18:08.190841202Z 2024-02-25T19:18:08.190Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.CreateTableStatement@dca2615
2024-02-25T19:18:08.190884992Z 2024-02-25T19:18:08.190Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.191342033Z 2024-02-25T19:18:08.191Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.subscriptions (id BIGINT NOT NULL, channel_id VARCHAR(255) NOT NULL, user_id BIGINT NOT NULL, CONSTRAINT PK_SUBSCRIPTIONS PRIMARY KEY (id), CONSTRAINT fk_subscription_channel FOREIGN KEY (channel_id) REFERENCES bootdb.channels(id), CONSTRAINT fk_subscription_user FOREIGN KEY (user_id) REFERENCES bootdb.application_users(id))
2024-02-25T19:18:08.213426831Z 2024-02-25T19:18:08.213Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.213469225Z 2024-02-25T19:18:08.213Z  INFO 14 --- [           main] liquibase.changelog                      : Table subscriptions created
2024-02-25T19:18:08.213581878Z 2024-02-25T19:18:08.213Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.AddUniqueConstraintStatement@421a4ee1
2024-02-25T19:18:08.213618824Z 2024-02-25T19:18:08.213Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.214850123Z 2024-02-25T19:18:08.214Z DEBUG 14 --- [           main] liquibase.executor                       : ALTER TABLE bootdb.subscriptions ADD CONSTRAINT subscription_unique UNIQUE (channel_id, user_id)
2024-02-25T19:18:08.230134006Z 2024-02-25T19:18:08.229Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.230219561Z 2024-02-25T19:18:08.230Z  INFO 14 --- [           main] liquibase.changelog                      : Unique constraint added to subscriptions(channel_id, user_id)
2024-02-25T19:18:08.230444031Z 2024-02-25T19:18:08.230Z  INFO 14 --- [           main] liquibase.changelog                      : ChangeSet dblogs/changelog/changes/changelog-0.xml::createSubscriptionTable::MDeLuise ran successfully in 48ms
2024-02-25T19:18:08.230482094Z 2024-02-25T19:18:08.230Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.231225762Z 2024-02-25T19:18:08.231Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('createSubscriptionTable', 'MDeLuise', 'dblogs/changelog/changes/changelog-0.xml', NOW(), 3, '8:38bd7b425522ad131451fb20919b13aa', 'createTable tableName=subscriptions; addUniqueConstraint constraintName=subscription_unique, tableName=subscriptions', '', 'EXECUTED', NULL, NULL, '4.18.0', '8888687959')
2024-02-25T19:18:08.232397625Z 2024-02-25T19:18:08.232Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:08.235423071Z Running Changeset: dblogs/changelog/changes/changelog-0.xml::createVideoTable::MDeLuise
2024-02-25T19:18:08.235669471Z 2024-02-25T19:18:08.235Z DEBUG 14 --- [           main] liquibase.changelog                      : Running Changeset: dblogs/changelog/changes/changelog-0.xml::createVideoTable::MDeLuise
2024-02-25T19:18:08.236221425Z 2024-02-25T19:18:08.236Z DEBUG 14 --- [           main] liquibase.executor                       : Changeset dblogs/changelog/changes/changelog-0.xml::createVideoTable::MDeLuise
2024-02-25T19:18:08.246748991Z 2024-02-25T19:18:08.246Z DEBUG 14 --- [           main] liquibase.changelog                      : Reading ChangeSet: dblogs/changelog/changes/changelog-0.xml::createVideoTable::MDeLuise
2024-02-25T19:18:08.247626195Z 2024-02-25T19:18:08.247Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.CreateTableStatement@5b4d25e7
2024-02-25T19:18:08.247663629Z 2024-02-25T19:18:08.247Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.248486567Z 2024-02-25T19:18:08.248Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.video (id VARCHAR(255) NOT NULL, channel_id VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, published_at datetime NOT NULL, CONSTRAINT PK_VIDEO PRIMARY KEY (id), CONSTRAINT fk_video_channel FOREIGN KEY (channel_id) REFERENCES bootdb.channels(id))
2024-02-25T19:18:08.278226647Z 2024-02-25T19:18:08.277Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.278339231Z 2024-02-25T19:18:08.278Z  INFO 14 --- [           main] liquibase.changelog                      : Table video created
2024-02-25T19:18:08.278900543Z 2024-02-25T19:18:08.278Z  INFO 14 --- [           main] liquibase.changelog                      : ChangeSet dblogs/changelog/changes/changelog-0.xml::createVideoTable::MDeLuise ran successfully in 43ms
2024-02-25T19:18:08.279176835Z 2024-02-25T19:18:08.279Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.281512530Z 2024-02-25T19:18:08.281Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('createVideoTable', 'MDeLuise', 'dblogs/changelog/changes/changelog-0.xml', NOW(), 4, '8:595e27efb7e5cf5dd4172ceb0554e41e', 'createTable tableName=video', '', 'EXECUTED', NULL, NULL, '4.18.0', '8888687959')
2024-02-25T19:18:08.283388811Z 2024-02-25T19:18:08.283Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:08.287417664Z Running Changeset: dblogs/changelog/changes/changelog-0.xml::createQuotaCounterTable::MDeLuise
2024-02-25T19:18:08.288051891Z 2024-02-25T19:18:08.287Z DEBUG 14 --- [           main] liquibase.changelog                      : Running Changeset: dblogs/changelog/changes/changelog-0.xml::createQuotaCounterTable::MDeLuise
2024-02-25T19:18:08.288923996Z 2024-02-25T19:18:08.288Z DEBUG 14 --- [           main] liquibase.executor                       : Changeset dblogs/changelog/changes/changelog-0.xml::createQuotaCounterTable::MDeLuise
2024-02-25T19:18:08.308002555Z 2024-02-25T19:18:08.307Z DEBUG 14 --- [           main] liquibase.changelog                      : Reading ChangeSet: dblogs/changelog/changes/changelog-0.xml::createQuotaCounterTable::MDeLuise
2024-02-25T19:18:08.308571970Z 2024-02-25T19:18:08.308Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.CreateTableStatement@46866946
2024-02-25T19:18:08.308624979Z 2024-02-25T19:18:08.308Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.309762481Z 2024-02-25T19:18:08.309Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.quotas (id BIGINT NOT NULL, quota_day datetime NOT NULL, quota_value INT NOT NULL, CONSTRAINT PK_QUOTAS PRIMARY KEY (id))
2024-02-25T19:18:08.330106071Z 2024-02-25T19:18:08.329Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.330209506Z 2024-02-25T19:18:08.330Z  INFO 14 --- [           main] liquibase.changelog                      : Table quotas created
2024-02-25T19:18:08.330731289Z 2024-02-25T19:18:08.330Z  INFO 14 --- [           main] liquibase.changelog                      : ChangeSet dblogs/changelog/changes/changelog-0.xml::createQuotaCounterTable::MDeLuise ran successfully in 42ms
2024-02-25T19:18:08.330799035Z 2024-02-25T19:18:08.330Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.331922359Z 2024-02-25T19:18:08.331Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('createQuotaCounterTable', 'MDeLuise', 'dblogs/changelog/changes/changelog-0.xml', NOW(), 5, '8:a7319259267e218a7445039c5ba66816', 'createTable tableName=quotas', '', 'EXECUTED', NULL, NULL, '4.18.0', '8888687959')
2024-02-25T19:18:08.333317434Z 2024-02-25T19:18:08.333Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:08.337420109Z Running Changeset: dblogs/changelog/changes/changelog-0.xml::createApiKeyTable::MDeLuise
2024-02-25T19:18:08.337766661Z 2024-02-25T19:18:08.337Z DEBUG 14 --- [           main] liquibase.changelog                      : Running Changeset: dblogs/changelog/changes/changelog-0.xml::createApiKeyTable::MDeLuise
2024-02-25T19:18:08.338414716Z 2024-02-25T19:18:08.338Z DEBUG 14 --- [           main] liquibase.executor                       : Changeset dblogs/changelog/changes/changelog-0.xml::createApiKeyTable::MDeLuise
2024-02-25T19:18:08.357929363Z 2024-02-25T19:18:08.357Z DEBUG 14 --- [           main] liquibase.changelog                      : Reading ChangeSet: dblogs/changelog/changes/changelog-0.xml::createApiKeyTable::MDeLuise
2024-02-25T19:18:08.358867957Z 2024-02-25T19:18:08.358Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.CreateTableStatement@3162743f
2024-02-25T19:18:08.358950509Z 2024-02-25T19:18:08.358Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.359848875Z 2024-02-25T19:18:08.359Z DEBUG 14 --- [           main] liquibase.executor                       : CREATE TABLE bootdb.api_keys (id BIGINT NOT NULL, user_id BIGINT NOT NULL, api_key_value VARCHAR(255) NULL, name VARCHAR(255) NULL, created_on datetime NOT NULL, CONSTRAINT PK_API_KEYS PRIMARY KEY (id), CONSTRAINT fk_apiKey_user FOREIGN KEY (user_id) REFERENCES bootdb.application_users(id), UNIQUE (api_key_value))
2024-02-25T19:18:08.388170692Z 2024-02-25T19:18:08.387Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.388206940Z 2024-02-25T19:18:08.388Z  INFO 14 --- [           main] liquibase.changelog                      : Table api_keys created
2024-02-25T19:18:08.388422050Z 2024-02-25T19:18:08.388Z DEBUG 14 --- [           main] liquibase.database                       : Executing Statement: liquibase.statement.core.AddUniqueConstraintStatement@2c708440
2024-02-25T19:18:08.388483091Z 2024-02-25T19:18:08.388Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.388883071Z 2024-02-25T19:18:08.388Z DEBUG 14 --- [           main] liquibase.executor                       : ALTER TABLE bootdb.api_keys ADD CONSTRAINT api_key_name_unique UNIQUE (user_id, name)
2024-02-25T19:18:08.410702055Z 2024-02-25T19:18:08.410Z DEBUG 14 --- [           main] liquibase.executor                       : 0 row(s) affected
2024-02-25T19:18:08.410730690Z 2024-02-25T19:18:08.410Z  INFO 14 --- [           main] liquibase.changelog                      : Unique constraint added to api_keys(user_id, name)
2024-02-25T19:18:08.410990429Z 2024-02-25T19:18:08.410Z  INFO 14 --- [           main] liquibase.changelog                      : ChangeSet dblogs/changelog/changes/changelog-0.xml::createApiKeyTable::MDeLuise ran successfully in 73ms
2024-02-25T19:18:08.411041343Z 2024-02-25T19:18:08.410Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.411914286Z 2024-02-25T19:18:08.411Z DEBUG 14 --- [           main] liquibase.executor                       : INSERT INTO bootdb.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('createApiKeyTable', 'MDeLuise', 'dblogs/changelog/changes/changelog-0.xml', NOW(), 6, '8:a3c4d8c1ad67bf1793ff05b73c3458fe', 'createTable tableName=api_keys; addUniqueConstraint constraintName=api_key_name_unique, tableName=api_keys', '', 'EXECUTED', NULL, NULL, '4.18.0', '8888687959')
2024-02-25T19:18:08.413109477Z 2024-02-25T19:18:08.412Z DEBUG 14 --- [           main] liquibase.executor                       : 1 row(s) affected
2024-02-25T19:18:08.415791654Z 2024-02-25T19:18:08.415Z DEBUG 14 --- [           main] liquibase.executor                       : Release Database Lock
2024-02-25T19:18:08.416010187Z 2024-02-25T19:18:08.415Z DEBUG 14 --- [           main] liquibase.executor                       : Executing with the 'jdbc' executor
2024-02-25T19:18:08.419030255Z 2024-02-25T19:18:08.418Z  INFO 14 --- [           main] liquibase.lockservice                    : Successfully released change log lock
2024-02-25T19:18:08.826376148Z 2024-02-25T19:18:08.826Z  INFO 14 --- [           main] SQL dialect                              : HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
2024-02-25T19:18:10.027664807Z 2024-02-25T19:18:10.027Z  INFO 14 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2024-02-25T19:18:11.049376184Z 2024-02-25T19:18:11.049Z  WARN 14 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
2024-02-25T19:18:12.501494421Z 2024-02-25T19:18:12.501Z  INFO 14 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (https) with context path '/api'
2024-02-25T19:18:12.533414730Z 2024-02-25T19:18:12.533Z  INFO 14 --- [           main] com.github.mdeluise.ytsms.Application    : Started Application in 8.435 seconds (process running for 9.072)

Frontend:

2024-02-25T19:17:53.084767894Z config PORT value...
2024-02-25T19:17:53.085827244Z found value of PORT in global vars (3000)
2024-02-25T19:17:53.091425286Z config API_URL value...
2024-02-25T19:17:53.092091709Z found value of API_URL in global vars (http://192.168.178.109:8089/api)
2024-02-25T19:17:53.096474307Z config WAIT_TIMEOUT value...
2024-02-25T19:17:53.097352559Z found value of WAIT_TIMEOUT in global vars (5000)
2024-02-25T19:17:53.102042039Z config CACHE_TTL_DAYS value...
2024-02-25T19:17:53.102731789Z value for CACHE_TTL_DAYS not found in global vars, using default provided in .env (7)
2024-02-25T19:17:53.104022103Z config CACHE_TTL_DAYS value...
2024-02-25T19:17:53.104762209Z value for CACHE_TTL_DAYS not found in global vars, using default provided in .env (7)
2024-02-25T19:17:53.109984507Z config PAGE_SIZE value...
2024-02-25T19:17:53.110693114Z found value of PAGE_SIZE in global vars (25)
2024-02-25T19:17:53.112392697Z Certificates not found. Sleeping for 5 seconds...
2024-02-25T19:17:58.117685276Z Certificates found. Copying...DONE
2024-02-25T19:17:58.117785079Z SSL enabled: false
2024-02-25T19:18:09.948551480Z 192.168.178.86 - - [25/Feb/2024:19:18:09 +0000] "GET / HTTP/1.1" 200 634 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"
2024-02-25T19:18:10.030265340Z 192.168.178.86 - - [25/Feb/2024:19:18:10 +0000] "GET /env-config.js HTTP/1.1" 200 170 "http://192.168.178.109:3009/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"
2024-02-25T19:18:10.112243688Z 192.168.178.86 - - [25/Feb/2024:19:18:10 +0000] "GET /static/css/main.70a9c5f6.css HTTP/1.1" 200 37677 "http://192.168.178.109:3009/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"
2024-02-25T19:18:10.112479472Z 192.168.178.86 - - [25/Feb/2024:19:18:10 +0000] "GET /static/js/main.75aba290.js HTTP/1.1" 200 329444 "http://192.168.178.109:3009/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"
2024-02-25T19:18:10.451318174Z 192.168.178.86 - - [25/Feb/2024:19:18:10 +0000] "GET /apple-touch-icon.png HTTP/1.1" 200 25859 "http://192.168.178.109:3009/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"
2024-02-25T19:18:10.483048236Z 192.168.178.86 - - [25/Feb/2024:19:18:10 +0000] "GET /favicon-32x32.png HTTP/1.1" 200 1896 "http://192.168.178.109:3009/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"
2024-02-25T19:18:10.776885884Z 192.168.178.86 - - [25/Feb/2024:19:18:10 +0000] "GET /login-background.jpg HTTP/1.1" 200 1370392 "http://192.168.178.109:3009/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0" "-"

DB:

2024-02-25T19:17:52.306958557Z 2024-02-25 19:17:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.36-1.el8 started.
2024-02-25T19:17:52.561322931Z 2024-02-25 19:17:52+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-02-25T19:17:52.573227065Z 2024-02-25 19:17:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.36-1.el8 started.
2024-02-25T19:17:52.777527673Z 2024-02-25 19:17:52+00:00 [Note] [Entrypoint]: Initializing database files
2024-02-25T19:17:52.787306752Z 2024-02-25T19:17:52.784702Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-02-25T19:17:52.787333361Z 2024-02-25T19:17:52.784794Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.36) initializing of server in progress as process 81
2024-02-25T19:17:52.792721182Z 2024-02-25T19:17:52.792646Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-25T19:17:53.360834756Z 2024-02-25T19:17:53.360763Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-25T19:17:54.651198945Z 2024-02-25T19:17:54.651061Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2024-02-25T19:17:57.682993177Z 2024-02-25 19:17:57+00:00 [Note] [Entrypoint]: Database files initialized
2024-02-25T19:17:57.687827716Z 2024-02-25 19:17:57+00:00 [Note] [Entrypoint]: Starting temporary server
2024-02-25T19:17:57.906745924Z 2024-02-25T19:17:57.899647Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-02-25T19:17:57.906816323Z 2024-02-25T19:17:57.900294Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36) starting as process 125
2024-02-25T19:17:57.914951204Z 2024-02-25T19:17:57.914778Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-25T19:17:58.105947714Z 2024-02-25T19:17:58.105683Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-25T19:17:58.441007036Z 2024-02-25T19:17:58.440875Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-02-25T19:17:58.441066261Z 2024-02-25T19:17:58.440938Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-02-25T19:17:58.443437017Z 2024-02-25T19:17:58.443321Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-02-25T19:17:58.482400171Z 2024-02-25T19:17:58.482264Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server - GPL.
2024-02-25T19:17:58.482447383Z 2024-02-25T19:17:58.482241Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock
2024-02-25T19:17:58.499328602Z 2024-02-25 19:17:58+00:00 [Note] [Entrypoint]: Temporary server started.
2024-02-25T19:17:58.533550035Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-02-25T19:17:59.300781381Z Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
2024-02-25T19:17:59.300815254Z Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
2024-02-25T19:17:59.300827546Z Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
2024-02-25T19:18:00.981246511Z Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
2024-02-25T19:18:00.981285064Z Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
2024-02-25T19:18:00.981295470Z Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2024-02-25T19:18:01.103300093Z 2024-02-25 19:18:01+00:00 [Note] [Entrypoint]: Creating database bootdb
2024-02-25T19:18:01.127247833Z 
2024-02-25T19:18:01.130983702Z 2024-02-25 19:18:01+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-02-25T19:18:01.141405529Z 2024-02-25T19:18:01.141208Z 11 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.36).
2024-02-25T19:18:02.014347852Z 2024-02-25T19:18:02.014221Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36)  MySQL Community Server - GPL.
2024-02-25T19:18:02.148875400Z 2024-02-25 19:18:02+00:00 [Note] [Entrypoint]: Temporary server stopped
2024-02-25T19:18:02.148920308Z 
2024-02-25T19:18:02.153966676Z 2024-02-25 19:18:02+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2024-02-25T19:18:02.154017799Z 
2024-02-25T19:18:02.354945851Z 2024-02-25T19:18:02.352210Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-02-25T19:18:02.355006334Z 2024-02-25T19:18:02.353168Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36) starting as process 1
2024-02-25T19:18:02.357562657Z 2024-02-25T19:18:02.357370Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-25T19:18:02.517083396Z 2024-02-25T19:18:02.516898Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-25T19:18:02.790744094Z 2024-02-25T19:18:02.790611Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-02-25T19:18:02.790803878Z 2024-02-25T19:18:02.790661Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-02-25T19:18:02.792995561Z 2024-02-25T19:18:02.792833Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2024-02-25T19:18:02.823154059Z 2024-02-25T19:18:02.822996Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2024-02-25T19:18:02.823196592Z 2024-02-25T19:18:02.822920Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
MDeLuise commented 8 months ago

You're right, I was testing a local version of plant-it-backend:latest and not the DockerHub one. I don't know exactly why this is happening, but I just pushed a 0.4.0 version of the system. From the test I made this new version seems to not be affected to the problem, but let me know if the problem persists.

Samurai1201 commented 8 months ago

This problem is now fixed :) Thanks for the help

But somehow im not able to get the trefle api integration to work properly... I have created an account yesterday for testing, but plant-it always reports the access key as invalid. grafik

I have tried the TRAFLE_API and TREFLE_API variable both, have deleted the persistent files in between deployments, just to be sure, ... Hope you know where the problem lies :)

MDeLuise commented 8 months ago

Great to know that the problem is fixed!

Regard the Trefle integration:

Samurai1201 commented 8 months ago

Sorry, was my bad. It wasnt the Trefle api, my browser had cached the login data and didnt redirect to the login page. Therefore i was trying to use an account that didnt exist to autheticate...

All my problems are solved now :D

Thanks a lot for your work. PS: It would be really cool to have a german translation :) If you are up for that i would be more than happy to help!

MDeLuise commented 8 months ago

Thank you so much for your interest in the project!

As I've reached an "initial stable version" for the backend feature, my focus will now primarily shift to enhancing the frontend for the next release.

Considering the current state of the frontend and the need for significant restructuring to incorporate useful features like transactions, logging, and responsive design, I'm contemplating the removal of the frontend as it is now in favor of a native app. This shift would greatly simplify deployment and could potentially offer a more seamless user experience.

I'll be initiating a GitHub discussion in the coming days/weeks to elaborate further on this plan. Expect some changes in the deployment and design of the project in the near future. If everything goes according to plan, I may require assistance with translations into other languages, and I'll definitely keep you updated on that front. Thanks again! 🪴

Samurai1201 commented 8 months ago

Thank you very much!

Just one small question, I dont know if whether im doing something wrong or not, but i cant save trefle provided plants as my plants, but custom created ones seem to work fine… Sorry to bother you again.

Really looking forward to the future development of this project, as of now, its the best self hosted Plant Managment app out there :)

MDeLuise commented 8 months ago

You're, again, correct! It seems that the last release introduced a bug affecting this particular functionality. I've promptly addressed this issue by pushing a hotfix in version 0.4.1 of the backend service. Please try using this updated version of the image. Alternatively, you can continue using the plant-it-backend:latest image, but you'll need to re-download it to ensure the fix is applied.

To prevent similar issues in the future, I'll be implementing additional tests.

Please don't hesitate to reach me if you encounter any further issues or have any questions.

Thank you for your kind words about the project, really appresciated!

Samurai1201 commented 8 months ago

Thanks a lot!

Now it works as expected :)

MDeLuise commented 8 months ago

Thank you for using the project! :)