VM_ARGS= . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.2.5.RELEASE) 2021-04-24 00:02:59.425 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Starting LiquibaseApplication on onap-oof-cmso-optimizer-d4db49d65-kw6wg with PID 7 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit) 2021-04-24 00:02:59.430 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : No active profile set, falling back to default profiles: default 2021-04-24 00:03:01.848 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-04-24 00:03:02.070 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-04-24 00:03:04.838 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-24 00:03:04.858 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-24 00:03:04.885 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-24 00:03:04.921 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM optimizer.DATABASECHANGELOGLOCK 2021-04-24 00:03:04.922 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO optimizer.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0) 2021-04-24 00:03:04.925 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT `LOCKED` FROM optimizer.DATABASECHANGELOGLOCK WHERE ID=1 2021-04-24 00:03:04.933 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully acquired change log lock 2021-04-24 00:03:08.234 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: optimizer.DATABASECHANGELOG 2021-04-24 00:03:08.236 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-24 00:03:08.259 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOG 2021-04-24 00:03:08.262 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Reading from optimizer.DATABASECHANGELOG 2021-04-24 00:03:08.263 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM optimizer.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-04-24 00:03:08.265 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-04-24 00:03:08.424 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-24 00:03:08.449 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-24 00:03:08.470 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-24 00:03:08.492 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-24 00:03:08.514 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-24 00:03:08.534 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file optimizer-dbchanges/onap-optimizer-v1-schema.sql executed 2021-04-24 00:03:08.535 INFO 7 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:optimizer-liquibase-changeLog.xml::optimizer-v1-schema1::ONAP ran successfully in 208ms 2021-04-24 00:03:08.536 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT MAX(ORDEREXECUTED) FROM optimizer.DATABASECHANGELOG 2021-04-24 00:03:08.538 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', '9222588265') 2021-04-24 00:03:08.542 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully released change log lock 2021-04-24 00:03:08.827 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Started LiquibaseApplication in 10.975 seconds (JVM running for 11.962) 2021-04-24 00:03:08.832 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-04-24 00:03:08.849 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.