VM_ARGS= . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.2.5.RELEASE) 2021-06-06 23:04:48.313 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Starting LiquibaseApplication on onap-oof-cmso-optimizer-d4db49d65-b86sx with PID 7 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit) 2021-06-06 23:04:48.318 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : No active profile set, falling back to default profiles: default 2021-06-06 23:04:50.832 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-06-06 23:04:51.740 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-06-06 23:04:54.415 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-06-06 23:04:54.723 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-06-06 23:04:54.752 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-06-06 23:04:54.763 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM optimizer.DATABASECHANGELOGLOCK 2021-06-06 23:04:54.764 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO optimizer.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0) 2021-06-06 23:04:54.768 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT `LOCKED` FROM optimizer.DATABASECHANGELOGLOCK WHERE ID=1 2021-06-06 23:04:54.799 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully acquired change log lock 2021-06-06 23:04:58.706 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: optimizer.DATABASECHANGELOG 2021-06-06 23:04:58.710 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-06-06 23:04:58.734 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOG 2021-06-06 23:04:58.739 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Reading from optimizer.DATABASECHANGELOG 2021-06-06 23:04:58.740 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM optimizer.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-06-06 23:04:58.742 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM optimizer.DATABASECHANGELOGLOCK 2021-06-06 23:04:58.834 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-06-06 23:04:58.858 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-06-06 23:04:58.884 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-06-06 23:04:58.918 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-06-06 23:04:58.946 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-06-06 23:04:58.969 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file optimizer-dbchanges/onap-optimizer-v1-schema.sql executed 2021-06-06 23:04:58.970 INFO 7 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:optimizer-liquibase-changeLog.xml::optimizer-v1-schema1::ONAP ran successfully in 173ms 2021-06-06 23:04:58.971 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT MAX(ORDEREXECUTED) FROM optimizer.DATABASECHANGELOG 2021-06-06 23:04:58.974 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', '3020698743') 2021-06-06 23:04:58.981 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully released change log lock 2021-06-06 23:04:59.295 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Started LiquibaseApplication in 12.416 seconds (JVM running for 13.54) 2021-06-06 23:04:59.301 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-06-06 23:04:59.322 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.