VM_ARGS= . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.2.5.RELEASE) 2021-04-21 12:30:32.812 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Starting LiquibaseApplication on onap-oof-cmso-optimizer-d4db49d65-vnfjh with PID 7 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit) 2021-04-21 12:30:32.819 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : No active profile set, falling back to default profiles: default 2021-04-21 12:30:36.231 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-04-21 12:30:36.542 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-04-21 12:30:40.120 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-21 12:30:40.148 INFO 7 --- [ 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-04-21 12:30:40.211 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-21 12:30:40.224 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM optimizer.DATABASECHANGELOGLOCK 2021-04-21 12:30:40.226 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO optimizer.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0) 2021-04-21 12:30:40.233 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT `LOCKED` FROM optimizer.DATABASECHANGELOGLOCK WHERE ID=1 2021-04-21 12:30:40.245 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully acquired change log lock 2021-04-21 12:30:44.931 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: optimizer.DATABASECHANGELOG 2021-04-21 12:30:44.934 INFO 7 --- [ 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-04-21 12:30:44.997 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOG 2021-04-21 12:30:45.000 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Reading from optimizer.DATABASECHANGELOG 2021-04-21 12:30:45.001 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM optimizer.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-04-21 12:30:45.004 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-21 12:30:45.114 INFO 7 --- [ 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-04-21 12:30:45.188 INFO 7 --- [ 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-04-21 12:30:45.228 INFO 7 --- [ 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-04-21 12:30:45.285 INFO 7 --- [ 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-04-21 12:30:45.329 INFO 7 --- [ 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-04-21 12:30:45.386 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file optimizer-dbchanges/onap-optimizer-v1-schema.sql executed 2021-04-21 12:30:45.387 INFO 7 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:optimizer-liquibase-changeLog.xml::optimizer-v1-schema1::ONAP ran successfully in 366ms 2021-04-21 12:30:45.389 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT MAX(ORDEREXECUTED) FROM optimizer.DATABASECHANGELOG 2021-04-21 12:30:45.392 INFO 7 --- [ 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', '9008245005') 2021-04-21 12:30:45.397 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully released change log lock 2021-04-21 12:30:45.711 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Started LiquibaseApplication in 14.792 seconds (JVM running for 16.184) 2021-04-21 12:30:45.718 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-04-21 12:30:45.734 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.