VM_ARGS= . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.2.5.RELEASE) 2021-06-15 10:10:09.001 INFO 8 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Starting LiquibaseApplication on onap-oof-cmso-optimizer-bf76fc75c-p9kbg with PID 8 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit) 2021-06-15 10:10:09.008 INFO 8 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : No active profile set, falling back to default profiles: default 2021-06-15 10:10:11.625 INFO 8 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-06-15 10:10:13.656 INFO 8 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-06-15 10:10:16.351 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-06-15 10:10:16.416 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE optimizer.DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) 2021-06-15 10:10:16.479 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-06-15 10:10:16.510 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM optimizer.DATABASECHANGELOGLOCK 2021-06-15 10:10:16.512 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO optimizer.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0) 2021-06-15 10:10:16.521 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT `LOCKED` FROM optimizer.DATABASECHANGELOGLOCK WHERE ID=1 2021-06-15 10:10:16.540 INFO 8 --- [ main] l.lockservice.StandardLockService : Successfully acquired change log lock 2021-06-15 10:10:20.657 INFO 8 --- [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: optimizer.DATABASECHANGELOG 2021-06-15 10:10:20.660 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE optimizer.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) 2021-06-15 10:10:20.690 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOG 2021-06-15 10:10:20.696 INFO 8 --- [ main] l.c.StandardChangeLogHistoryService : Reading from optimizer.DATABASECHANGELOG 2021-06-15 10:10:20.697 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM optimizer.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-06-15 10:10:20.699 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-06-15 10:10:20.812 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE IF NOT EXISTS `request` ( uuid BINARY(16) NOT NULL, request LONGTEXT NOT NULL, created_time BIGINT(20) NULL DEFAULT NULL, request_start BIGINT(20) NULL DEFAULT NULL, request_end BIGINT(20) NULL DEFAULT NULL, status VARCHAR(45) NULL DEFAULT NULL, message MEDIUMTEXT NULL DEFAULT NULL, PRIMARY KEY (`uuid`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 2021-06-15 10:10:20.838 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE IF NOT EXISTS `response` ( uuid BINARY(16) NOT NULL, response LONGTEXT NULL DEFAULT NULL, delivered_time BIGINT(20) NULL DEFAULT NULL, PRIMARY KEY (`uuid`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 2021-06-15 10:10:20.867 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE IF NOT EXISTS `topology` ( uuid BINARY(16) NOT NULL, topology LONGTEXT NULL DEFAULT NULL, topology_start BIGINT(20) NULL DEFAULT NULL, topology_end BIGINT(20) NULL DEFAULT NULL, topology_retries INT NULL DEFAULT NULL, topology_polling_interval INT NULL DEFAULT NULL, PRIMARY KEY (`uuid`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 2021-06-15 10:10:20.896 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE IF NOT EXISTS `tickets` ( uuid BINARY(16) NOT NULL, tickets LONGTEXT NULL DEFAULT NULL, tickets_start BIGINT(20) NULL DEFAULT NULL, tickets_end BIGINT(20) NULL DEFAULT NULL, tickets_retries INT NULL DEFAULT NULL, topology_polling_interval INT NULL DEFAULT NULL, PRIMARY KEY (`uuid`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 2021-06-15 10:10:20.922 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE IF NOT EXISTS `optimizer` ( uuid BINARY(16) NOT NULL, optimize_response LONGTEXT NULL DEFAULT NULL, optimize_start BIGINT(20) NULL DEFAULT NULL, optimize_end BIGINT(20) NULL DEFAULT NULL, optimize_retries INT NULL DEFAULT NULL, optimize_polling_interval INT NULL DEFAULT NULL, PRIMARY KEY (`uuid`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 2021-06-15 10:10:20.952 INFO 8 --- [ main] liquibase.changelog.ChangeSet : SQL in file optimizer-dbchanges/onap-optimizer-v1-schema.sql executed 2021-06-15 10:10:20.952 INFO 8 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:optimizer-liquibase-changeLog.xml::optimizer-v1-schema1::ONAP ran successfully in 238ms 2021-06-15 10:10:20.954 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT MAX(ORDEREXECUTED) FROM optimizer.DATABASECHANGELOG 2021-06-15 10:10:20.957 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO optimizer.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('optimizer-v1-schema1', 'ONAP', 'classpath:optimizer-liquibase-changeLog.xml', NOW(), 1, '8:a6a9c99dffac1760ae963af73843f286', 'sqlFile', '', 'EXECUTED', NULL, NULL, '3.8.7', '3751820700') 2021-06-15 10:10:20.962 INFO 8 --- [ main] l.lockservice.StandardLockService : Successfully released change log lock 2021-06-15 10:10:21.216 INFO 8 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Started LiquibaseApplication in 14.018 seconds (JVM running for 15.209) 2021-06-15 10:10:21.223 INFO 8 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-06-15 10:10:21.295 INFO 8 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.