By type
VM_ARGS= . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.2.5.RELEASE) 2021-06-09 22:45:05.092 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Starting LiquibaseApplication on dev-oof-cmso-service-68f7d4659d-qm2kf with PID 7 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit) 2021-06-09 22:45:05.098 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : No active profile set, falling back to default profiles: default 2021-06-09 22:45:06.078 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2021-06-09 22:45:06.280 INFO 7 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2021-06-09 22:45:07.414 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM cmso.DATABASECHANGELOGLOCK 2021-06-09 22:45:08.268 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE cmso.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-09 22:45:08.291 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM cmso.DATABASECHANGELOGLOCK 2021-06-09 22:45:08.301 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM cmso.DATABASECHANGELOGLOCK 2021-06-09 22:45:08.302 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO cmso.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0) 2021-06-09 22:45:08.306 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT `LOCKED` FROM cmso.DATABASECHANGELOGLOCK WHERE ID=1 2021-06-09 22:45:08.314 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully acquired change log lock 2021-06-09 22:45:10.251 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Creating database history table with name: cmso.DATABASECHANGELOG 2021-06-09 22:45:10.253 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE cmso.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-09 22:45:10.298 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM cmso.DATABASECHANGELOG 2021-06-09 22:45:10.301 INFO 7 --- [ main] l.c.StandardChangeLogHistoryService : Reading from cmso.DATABASECHANGELOG 2021-06-09 22:45:10.302 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT * FROM cmso.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC 2021-06-09 22:45:10.303 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT COUNT(*) FROM cmso.DATABASECHANGELOGLOCK 2021-06-09 22:45:10.408 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE TABLE IF NOT EXISTS DOMAINS ( domain VARCHAR(256) NOT NULL, CONSTRAINT PK_DOMAINS PRIMARY KEY (domain) ) ENGINE=INNODB 2021-06-09 22:45:10.468 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX DOMAIN_UNIQUE ON DOMAINS (domain ASC) 2021-06-09 22:45:10.503 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table SCHEDULES -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS SCHEDULES ( id INT NOT NULL AUTO_INCREMENT, domain VARCHAR(256) NOT NULL, schedule_id VARCHAR(256) NULL, schedule_name VARCHAR(256) NULL, user_id VARCHAR(45) NULL, status VARCHAR(45) NOT NULL, create_date_time BIGINT NULL, schedule_info MEDIUMTEXT NOT NULL, schedule MEDIUMTEXT NULL, optimizer_status VARCHAR(45) NULL, optimizer_message MEDIUMTEXT NULL, optimizer_date_time BIGINT NULL, optimizer_return_date_time BIGINT NULL, optimizer_attempts_to_schedule INT NOT NULL DEFAULT 0, optimizer_transaction_id VARCHAR(128) NULL, delete_date_time BIGINT NULL, CONSTRAINT PK_SCHEDULES PRIMARY KEY (id), CONSTRAINT FK_SCHEDULES_DOMAIN FOREIGN KEY (domain) REFERENCES DOMAINS (domain) ON DELETE NO ACTION ON UPDATE CASCADE ) ENGINE=INNODB 2021-06-09 22:45:10.529 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX SCHEDULE_KEY ON SCHEDULES (domain ASC, schedule_id ASC) 2021-06-09 22:45:10.548 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX OPTIMIZER_TRANSACTION_ID_UNIQUE ON SCHEDULES (optimizer_transaction_id ASC) 2021-06-09 22:45:10.567 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table SCHEDULE_EVENTS -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS SCHEDULE_EVENTS ( id INT(11) NOT NULL AUTO_INCREMENT, schedules_id INT(11) NOT NULL, event_time BIGINT(20) NOT NULL, reminder_time BIGINT(20) NOT NULL, domain VARCHAR(45) NULL DEFAULT NULL, event_text MEDIUMTEXT NULL DEFAULT NULL, status VARCHAR(45) NULL DEFAULT NULL, CONSTRAINT PK_SCHEDULE_EVENTS PRIMARY KEY (id), CONSTRAINT FK_SCHEDULE_EVENTS_SCHEDULES FOREIGN KEY (schedules_id) REFERENCES SCHEDULES (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:10.604 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_SCHEDULE_EVENTS_SCHEDULES_IDX ON SCHEDULE_EVENTS (schedules_id ASC) 2021-06-09 22:45:10.621 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX SEQ_SVENTS ON SCHEDULE_EVENTS (reminder_time ASC) 2021-06-09 22:45:10.636 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table DOMAIN_DATA -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS DOMAIN_DATA ( id INT NOT NULL AUTO_INCREMENT, schedules_id INT NOT NULL, name VARCHAR(128) NULL, value MEDIUMTEXT NULL, CONSTRAINT PK_DOMAIN_DATA PRIMARY KEY (id), CONSTRAINT FK_DOMAIN_DATA_SCHEDULES FOREIGN KEY (schedules_id) REFERENCES SCHEDULES (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:10.753 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX ID_UNIQUE ON DOMAIN_DATA (id ASC) 2021-06-09 22:45:10.781 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_DOMAIN_DATA_SCHEDULES_IDX ON DOMAIN_DATA (schedules_id ASC) 2021-06-09 22:45:10.801 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table APPROVAL_TYPES -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS APPROVAL_TYPES ( id INT NOT NULL AUTO_INCREMENT, domain VARCHAR(256) NOT NULL, approval_type VARCHAR(45) NOT NULL, approval_count INT NOT NULL DEFAULT 1, CONSTRAINT PK_APPROVAL_TYPES PRIMARY KEY (id), CONSTRAINT FK_APPROVAL_TYPES_DOMAIN FOREIGN KEY (domain) REFERENCES DOMAINS (domain) ON DELETE NO ACTION ON UPDATE CASCADE ) ENGINE=INNODB 2021-06-09 22:45:10.830 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_DOMAIN_IDX ON APPROVAL_TYPES (domain ASC) 2021-06-09 22:45:10.871 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table SCHEDULE_APPROVALS -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS SCHEDULE_APPROVALS ( id INT NOT NULL AUTO_INCREMENT, schedules_id INT NOT NULL, user_id VARCHAR(45) NOT NULL, approval_type_id INT NOT NULL, status VARCHAR(45) NOT NULL DEFAULT 'Pending Approval', approval_date_time BIGINT NULL, CONSTRAINT PK_SCHEDULE_APPROVALS PRIMARY KEY (id), CONSTRAINT FK_SCHEDULE_APPROVALS_SCHEDULES FOREIGN KEY (schedules_id) REFERENCES SCHEDULES (id) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT FK_SCHEDULE_APPROVALS_APPROVAL_TYPES FOREIGN KEY (approval_type_id) REFERENCES APPROVAL_TYPES (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:10.995 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_SCHEDULE_APPROVALS_SCHEDULES_IDX ON SCHEDULE_APPROVALS (schedules_id ASC) 2021-06-09 22:45:11.065 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_APPROVAL_TYPES_IDX ON SCHEDULE_APPROVALS (approval_type_id ASC) 2021-06-09 22:45:11.116 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table CHANGE_MANAGEMENT_GROUPS -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS CHANGE_MANAGEMENT_GROUPS ( id INT NOT NULL AUTO_INCREMENT, group_id VARCHAR(45) NULL, schedules_id INT NULL, start_time BIGINT NULL, finish_time BIGINT NULL, last_instance_start_time BIGINT NULL, normal_duration_in_secs INT NULL, additional_duration_in_secs INT NULL, concurrency_limit INT NULL, policy_id VARCHAR(256) NULL, CONSTRAINT PK_CHANGE_MANAGEMENT_GROUPS PRIMARY KEY (id), CONSTRAINT FK_CHANGE_MANAGEMENT_GROUPS_SCHEDULES FOREIGN KEY (schedules_id) REFERENCES SCHEDULES (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:11.157 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_SCHEDULES_IDX ON CHANGE_MANAGEMENT_GROUPS (schedules_id ASC) 2021-06-09 22:45:11.175 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX CHANGE_MANAGEMENT_GROUP_ID_UNIQUE ON CHANGE_MANAGEMENT_GROUPS (schedules_id ASC, group_id ASC) 2021-06-09 22:45:11.194 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table CHANGE_MANAGEMENT_SCHEDULES -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS CHANGE_MANAGEMENT_SCHEDULES ( id INT NOT NULL AUTO_INCREMENT, change_management_groups_id INT NULL, vnf_name VARCHAR(256) NOT NULL, vnf_id VARCHAR(256) NULL, status VARCHAR(45) NOT NULL, start_time BIGINT NULL, finish_time BIGINT NULL, mso_request_id VARCHAR(45) NULL, mso_status VARCHAR(45) NULL, mso_message MEDIUMTEXT NULL, mso_time BIGINT NULL, dispatcher_instance VARCHAR(128) NULL, dispatch_time BIGINT NULL, execution_completed_time BIGINT NULL, status_message MEDIUMTEXT NULL, tm_change_id VARCHAR(15) NULL, tm_approval_status VARCHAR(45) NULL, tm_status VARCHAR(45) NULL, CONSTRAINT PK_CHANGE_MANAGEMENT_SCHEDULES PRIMARY KEY (id), CONSTRAINT FK_CHANGE_MANAGEMENT_SCHEDULES_CHANGE_MANAGEMENT_GROUP FOREIGN KEY (change_management_groups_id) REFERENCES CHANGE_MANAGEMENT_GROUPS (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:11.216 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_CHANGE_MANAGEMENT_GROUP_CHANGE_MANAGEMENT_SCHEDULES_IDX ON CHANGE_MANAGEMENT_SCHEDULES (change_management_groups_id ASC) 2021-06-09 22:45:11.235 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX CHANGE_MANAGEMENT_SCHEDULES_VNF_NAME_UNIQUE ON CHANGE_MANAGEMENT_SCHEDULES (change_management_groups_id ASC, vnf_name ASC) 2021-06-09 22:45:11.259 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table CHANGE_MANAGEMENT_CHANGE_WINDOWS -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS CHANGE_MANAGEMENT_CHANGE_WINDOWS ( id INT NOT NULL AUTO_INCREMENT, change_management_groups_id INT NOT NULL, start_time BIGINT NULL, finish_time BIGINT NULL, CONSTRAINT PK_CHANGE_MANAGEMENT_CHANGE_WINDOWS PRIMARY KEY (id), CONSTRAINT FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1 FOREIGN KEY (change_management_groups_id) REFERENCES CHANGE_MANAGEMENT_GROUPS (id) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:11.282 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1_IDX on CHANGE_MANAGEMENT_CHANGE_WINDOWS (change_management_groups_id ASC) 2021-06-09 22:45:11.298 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- comment SQL_SAFE_UPDATES code in dev setup (testing) -- uncomment in IT, IST, E2E Env's SET SQL_SAFE_UPDATES = 0 2021-06-09 22:45:11.299 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM DOMAINS 2021-06-09 22:45:12.248 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO DOMAINS (`domain`) VALUES ('ChangeManagement') 2021-06-09 22:45:12.249 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DELETE FROM APPROVAL_TYPES 2021-06-09 22:45:12.255 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO APPROVAL_TYPES (`domain`, `approval_type`, `approval_count`) VALUES ('ChangeManagement', 'Tier 2', '1') 2021-06-09 22:45:12.256 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file cmso-dbchangelog/onap-cmso-v1-schema.sql executed 2021-06-09 22:45:12.257 INFO 7 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:cmso-liquibase-changeLog.xml::cmsched-v1-schema1::ATT ran successfully in 1922ms 2021-06-09 22:45:12.258 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SELECT MAX(ORDEREXECUTED) FROM cmso.DATABASECHANGELOG 2021-06-09 22:45:12.260 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO cmso.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('cmsched-v1-schema1', 'ATT', 'classpath:cmso-liquibase-changeLog.xml', NOW(), 1, '8:0044fd024f96ae2ad4572ca51c5d8904', 'sqlFile', '', 'EXECUTED', NULL, NULL, '3.8.7', '3278710304') 2021-06-09 22:45:12.267 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- DROP THE FOREIGN KEYS THAT USE INT IDs -- ----------------------------------------------------- ALTER TABLE DOMAIN_DATA DROP FOREIGN KEY FK_DOMAIN_DATA_SCHEDULES 2021-06-09 22:45:12.281 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS DROP FOREIGN KEY FK_SCHEDULE_APPROVALS_SCHEDULES 2021-06-09 22:45:12.295 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP FOREIGN KEY FK_CHANGE_MANAGEMENT_GROUPS_SCHEDULES 2021-06-09 22:45:12.326 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP FOREIGN KEY FK_CHANGE_MANAGEMENT_SCHEDULES_CHANGE_MANAGEMENT_GROUP 2021-06-09 22:45:12.342 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP FOREIGN KEY FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1 2021-06-09 22:45:12.356 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS DROP FOREIGN KEY FK_SCHEDULE_APPROVALS_APPROVAL_TYPES 2021-06-09 22:45:12.372 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- DROP THE INDEXES THAT USE INT IDs -- ----------------------------------------------------- DROP INDEX ID_UNIQUE ON DOMAIN_DATA 2021-06-09 22:45:12.389 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- THIS iS NOT NECESSARY PK DROP INDEX CHANGE_MANAGEMENT_GROUP_ID_UNIQUE ON CHANGE_MANAGEMENT_GROUPS 2021-06-09 22:45:12.406 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX CHANGE_MANAGEMENT_SCHEDULES_VNF_NAME_UNIQUE ON CHANGE_MANAGEMENT_SCHEDULES 2021-06-09 22:45:12.423 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX FK_DOMAIN_DATA_SCHEDULES_IDX ON DOMAIN_DATA 2021-06-09 22:45:12.440 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX FK_SCHEDULE_APPROVALS_SCHEDULES_IDX ON SCHEDULE_APPROVALS 2021-06-09 22:45:12.457 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX FK_APPROVAL_TYPES_IDX ON SCHEDULE_APPROVALS 2021-06-09 22:45:12.473 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX FK_SCHEDULES_IDX ON CHANGE_MANAGEMENT_GROUPS 2021-06-09 22:45:12.489 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX FK_CHANGE_MANAGEMENT_GROUP_CHANGE_MANAGEMENT_SCHEDULES_IDX ON CHANGE_MANAGEMENT_SCHEDULES 2021-06-09 22:45:12.502 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : DROP INDEX FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1_IDX on CHANGE_MANAGEMENT_CHANGE_WINDOWS 2021-06-09 22:45:12.518 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql executed 2021-06-09 22:45:12.527 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Schedules Add UUID column ALTER TABLE SCHEDULES ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.542 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Add foreign keys ALTER TABLE DOMAIN_DATA ADD COLUMN schedules_uuid BINARY(16) NOT NULL 2021-06-09 22:45:12.561 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS ADD COLUMN schedules_uuid BINARY(16) NOT NULL 2021-06-09 22:45:12.576 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_GROUPS ADD COLUMN schedules_uuid BINARY(16) NOT NULL 2021-06-09 22:45:12.593 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS ADD COLUMN schedules_uuid BINARY(16) 2021-06-09 22:45:12.607 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- CHANGE_MANAGEMENT_GROUPS Add UUID column ALTER TABLE CHANGE_MANAGEMENT_GROUPS ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.623 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Foreign keys ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES ADD COLUMN change_management_group_uuid BINARY(16) NOT NULL 2021-06-09 22:45:12.637 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS ADD COLUMN change_management_group_uuid BINARY(16) 2021-06-09 22:45:12.653 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- CHANGE_MANAGEMENT_SCHEDULES Add UUID column ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.668 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Foreign keys -- DOMAIN_DATA Add UUID column ALTER TABLE DOMAIN_DATA ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.682 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Foreign keys -- SCHEDULE_APPROVALS Add UUID column ALTER TABLE SCHEDULE_APPROVALS ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.698 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Foreign keys -- CHANGE_MANAGEMENT_CHANGE_WINDOWS Add UUID column -- Note that change window will be related to either a schedule or a group. ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.716 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Foreign keys -- APPROVAL_TYPES Add UUID column ALTER TABLE APPROVAL_TYPES ADD COLUMN uuid BINARY(16) NOT NULL FIRST 2021-06-09 22:45:12.739 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- Foreign keys ALTER TABLE SCHEDULE_APPROVALS ADD COLUMN approval_types_uuid BINARY(16) NOT NULL 2021-06-09 22:45:12.757 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- SCHEDULE_EVENTS not used DROP TABLE IF EXISTS SCHEDULE_EVENTS 2021-06-09 22:45:12.774 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SET SQL_SAFE_UPDATES = 0 2021-06-09 22:45:12.774 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ---------------------------------------------------- -- Populate UUID in all existing uuid fields -- ---------------------------------------------------- UPDATE SCHEDULES SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null 2021-06-09 22:45:13.248 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : UPDATE CHANGE_MANAGEMENT_GROUPS SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null 2021-06-09 22:45:13.251 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : UPDATE CHANGE_MANAGEMENT_SCHEDULES SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null 2021-06-09 22:45:13.253 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : UPDATE DOMAIN_DATA SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null 2021-06-09 22:45:13.257 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : UPDATE SCHEDULE_APPROVALS SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null 2021-06-09 22:45:13.260 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : UPDATE CHANGE_MANAGEMENT_CHANGE_WINDOWS SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null 2021-06-09 22:45:13.264 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : UPDATE APPROVAL_TYPES SET uuid = unhex(replace(uuid(), '-', '')) 2021-06-09 22:45:13.268 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ---------------------------------------------------- -- SCHEDULES Update all of the foreign key columns -- ---------------------------------------------------- update DOMAIN_DATA set schedules_uuid = (select distinct s.uuid from SCHEDULES s where schedules_id = s.id) 2021-06-09 22:45:13.269 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : update SCHEDULE_APPROVALS set schedules_uuid = (select distinct s.uuid from SCHEDULES s where schedules_id = s.id) 2021-06-09 22:45:13.270 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : update CHANGE_MANAGEMENT_GROUPS set schedules_uuid = (select distinct s.uuid from SCHEDULES s where schedules_id = s.id) 2021-06-09 22:45:13.271 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ---------------------------------------------------- -- CHANGE_MANAGEMENT_GROUPS Update all of the foreign key columns -- ---------------------------------------------------- update CHANGE_MANAGEMENT_SCHEDULES set change_management_group_uuid = (select distinct s.uuid from CHANGE_MANAGEMENT_GROUPS s where change_management_groups_id = s.id) 2021-06-09 22:45:13.272 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : update CHANGE_MANAGEMENT_CHANGE_WINDOWS set change_management_group_uuid = (select distinct s.uuid from CHANGE_MANAGEMENT_GROUPS s where change_management_groups_id = s.id) 2021-06-09 22:45:13.273 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ---------------------------------------------------- -- APPROVAL_TYPES Update all of the foreign key columns -- ---------------------------------------------------- update SCHEDULE_APPROVALS set approval_types_uuid = (select distinct s.uuid from APPROVAL_TYPES s where approval_type_id = s.id) 2021-06-09 22:45:13.273 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : SET SQL_SAFE_UPDATES = 1 2021-06-09 22:45:13.274 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES ADD COLUMN request LONGTEXT NULL DEFAULT NULL 2021-06-09 22:45:13.288 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql executed 2021-06-09 22:45:13.294 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- UPDATE THE PRIMARY KEYS -- ----------------------------------------------------- ALTER TABLE SCHEDULES DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.331 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE DOMAIN_DATA DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.368 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE APPROVAL_TYPES DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.412 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.451 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.484 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.516 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid) 2021-06-09 22:45:13.548 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- Table CHANGE_MANAGEMENT_DATA (DO this after we update the PK) -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS ELEMENT_DATA ( uuid BINARY(16) NOT NULL, change_management_schedules_uuid BINARY(16) NOT NULL, name VARCHAR(128) NULL, value LONGTEXT NULL, CONSTRAINT PK_ELEMENT_DATA PRIMARY KEY (uuid), CONSTRAINT FK_ELEMENT_DATA_CHANGE_MANAGEMENT_SCHEDULES FOREIGN KEY (change_management_schedules_uuid) REFERENCES CHANGE_MANAGEMENT_SCHEDULES (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=INNODB 2021-06-09 22:45:13.565 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_ELEMENT_DATA_CHANGE_MANAGEMENT_SCHEDULES_IDX ON ELEMENT_DATA (change_management_schedules_uuid ASC) 2021-06-09 22:45:13.579 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- -- RE_CREATE INDEXES WITH UPDATED KEYES -- ----------------------------------------------------- ALTER TABLE DOMAIN_DATA ADD CONSTRAINT FK_DOMAIN_DATA_SCHEDULES FOREIGN KEY (schedules_uuid) REFERENCES SCHEDULES (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION 2021-06-09 22:45:13.634 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_DOMAIN_DATA_SCHEDULES_IDX ON DOMAIN_DATA (schedules_uuid ASC) 2021-06-09 22:45:13.648 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- ALTER TABLE SCHEDULE_APPROVALS ADD CONSTRAINT FK_SCHEDULE_APPROVALS_SCHEDULES FOREIGN KEY (schedules_uuid) REFERENCES SCHEDULES (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION 2021-06-09 22:45:13.697 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS ADD CONSTRAINT FK_SCHEDULE_APPROVALS_APPROVAL_TYPES FOREIGN KEY (approval_types_uuid) REFERENCES APPROVAL_TYPES (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION 2021-06-09 22:45:13.749 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_SCHEDULE_APPROVALS_SCHEDULES_IDX ON SCHEDULE_APPROVALS (schedules_uuid ASC) 2021-06-09 22:45:13.763 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_APPROVAL_TYPES_IDX ON SCHEDULE_APPROVALS (approval_types_uuid ASC) 2021-06-09 22:45:13.776 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- ALTER TABLE CHANGE_MANAGEMENT_GROUPS ADD CONSTRAINT FK_CHANGE_MANAGEMENT_GROUPS_SCHEDULES FOREIGN KEY (schedules_uuid) REFERENCES SCHEDULES (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION 2021-06-09 22:45:13.828 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_SCHEDULES_IDX ON CHANGE_MANAGEMENT_GROUPS (schedules_uuid ASC) 2021-06-09 22:45:13.844 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX CHANGE_MANAGEMENT_GROUP_ID_UNIQUE ON CHANGE_MANAGEMENT_GROUPS (schedules_uuid ASC, group_id ASC) 2021-06-09 22:45:13.857 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES ADD CONSTRAINT FK_CHANGE_MANAGEMENT_SCHEDULES_CHANGE_MANAGEMENT_GROUP FOREIGN KEY (change_management_group_uuid) REFERENCES CHANGE_MANAGEMENT_GROUPS (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION 2021-06-09 22:45:13.901 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_CHANGE_MANAGEMENT_GROUP_CHANGE_MANAGEMENT_SCHEDULES_IDX ON CHANGE_MANAGEMENT_SCHEDULES (change_management_group_uuid ASC) 2021-06-09 22:45:13.917 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE UNIQUE INDEX CHANGE_MANAGEMENT_SCHEDULES_VNF_NAME_UNIQUE ON CHANGE_MANAGEMENT_SCHEDULES (change_management_group_uuid ASC, vnf_name ASC) 2021-06-09 22:45:13.931 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- ----------------------------------------------------- ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS ADD CONSTRAINT FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1 FOREIGN KEY (change_management_group_uuid) REFERENCES CHANGE_MANAGEMENT_GROUPS (uuid) ON DELETE NO ACTION ON UPDATE NO ACTION 2021-06-09 22:45:13.990 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : CREATE INDEX FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1_IDX on CHANGE_MANAGEMENT_CHANGE_WINDOWS (change_management_group_uuid ASC) 2021-06-09 22:45:14.004 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql executed 2021-06-09 22:45:14.007 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : -- -------------------------------------------------------------- -- DROP ALL OF THE INTENGER IDs -- -------------------------------------------------------------- ALTER TABLE SCHEDULES DROP COLUMN id 2021-06-09 22:45:14.023 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE DOMAIN_DATA DROP COLUMN id 2021-06-09 22:45:14.036 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE DOMAIN_DATA DROP COLUMN schedules_id 2021-06-09 22:45:14.049 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE APPROVAL_TYPES DROP COLUMN id 2021-06-09 22:45:14.061 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN id 2021-06-09 22:45:14.079 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN schedules_id 2021-06-09 22:45:14.095 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN approval_type_id 2021-06-09 22:45:14.111 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP COLUMN id 2021-06-09 22:45:14.123 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP COLUMN schedules_id 2021-06-09 22:45:14.137 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP COLUMN id 2021-06-09 22:45:14.151 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP COLUMN change_management_groups_id 2021-06-09 22:45:14.171 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP COLUMN id 2021-06-09 22:45:14.185 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP COLUMN change_management_groups_id 2021-06-09 22:45:14.199 INFO 7 --- [ main] liquibase.changelog.ChangeSet : SQL in file cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql executed 2021-06-09 22:45:14.199 INFO 7 --- [ main] liquibase.changelog.ChangeSet : ChangeSet classpath:cmso-liquibase-changeLog.xml::cmso-v1.1-schema1::ONAP ran successfully in 1936ms 2021-06-09 22:45:14.200 INFO 7 --- [ main] liquibase.executor.jvm.JdbcExecutor : INSERT INTO cmso.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, `DESCRIPTION`, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('cmso-v1.1-schema1', 'ONAP', 'classpath:cmso-liquibase-changeLog.xml', NOW(), 2, '8:87dd3b36d67a105639264996762fe714', 'sqlFile; sqlFile; sqlFile; sqlFile', '', 'EXECUTED', NULL, NULL, '3.8.7', '3278710304') 2021-06-09 22:45:14.250 INFO 7 --- [ main] l.lockservice.StandardLockService : Successfully released change log lock 2021-06-09 22:45:14.347 INFO 7 --- [ main] o.o.o.c.liquibase.LiquibaseApplication : Started LiquibaseApplication in 9.832 seconds (JVM running for 10.348) 2021-06-09 22:45:14.353 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2021-06-09 22:45:14.362 INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.