VM_ARGS= . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.2.5.RELEASE) 2021-04-12 00:21:57.072 INFO 8 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Starting LiquibaseApplication on onap-oof-cmso-optimizer-d4db49d65-fdf2f with PID 8 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit) 2021-04-12 00:21:57.132 INFO 8 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : No active profile set, falling back to default profiles: default 2021-04-12 00:21:59.334 INFO 8 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-04-12 00:21:59.549 INFO 8 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-04-12 00:22:02.171 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-12 00:22:02.251 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-04-12 00:22:02.278 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-12 00:22:02.338 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM optimizer.DATABASECHANGELOGLOCK 2021-04-12 00:22:02.340 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO optimizer.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0) 2021-04-12 00:22:02.344 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT `LOCKED` FROM optimizer.DATABASECHANGELOGLOCK WHERE ID=1 2021-04-12 00:22:02.352 INFO 8 --- [ main] l.lockservice.StandardLockService : Successfully acquired change log lock 2021-04-12 00:22:05.769 INFO 8 --- [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: optimizer.DATABASECHANGELOG 2021-04-12 00:22:05.771 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-04-12 00:22:05.800 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOG 2021-04-12 00:22:05.804 INFO 8 --- [ main] l.c.StandardChangeLogHistoryService : Reading from optimizer.DATABASECHANGELOG 2021-04-12 00:22:05.805 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM optimizer.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-04-12 00:22:05.832 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-12 00:22:05.937 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-04-12 00:22:05.974 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-04-12 00:22:06.000 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-04-12 00:22:06.031 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-04-12 00:22:06.059 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-04-12 00:22:06.088 INFO 8 --- [ main] liquibase.changelog.ChangeSet : SQL in file optimizer-dbchanges/onap-optimizer-v1-schema.sql executed 2021-04-12 00:22:06.088 INFO 8 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:optimizer-liquibase-changeLog.xml::optimizer-v1-schema1::ONAP ran successfully in 244ms 2021-04-12 00:22:06.089 INFO 8 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT MAX(ORDEREXECUTED) FROM optimizer.DATABASECHANGELOG 2021-04-12 00:22:06.092 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', '8186925833') 2021-04-12 00:22:06.096 INFO 8 --- [ main] l.lockservice.StandardLockService : Successfully released change log lock 2021-04-12 00:22:06.268 INFO 8 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Started LiquibaseApplication in 10.428 seconds (JVM running for 11.341) 2021-04-12 00:22:06.334 INFO 8 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-04-12 00:22:06.346 INFO 8 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.