Results

By type

          VM_ARGS=

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.2.5.RELEASE)

2021-04-24 00:02:49.788  INFO 7 --- [           main] o.o.o.c.liquibase.LiquibaseApplication   : Starting LiquibaseApplication on onap-oof-cmso-service-7bd44d7c6d-jj6g8 with PID 7 (/opt/app/cmso-dbinit/app.jar started by onap in /opt/app/cmso-dbinit)
2021-04-24 00:02:49.792  INFO 7 --- [           main] o.o.o.c.liquibase.LiquibaseApplication   : No active profile set, falling back to default profiles: default
2021-04-24 00:02:50.653  INFO 7 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2021-04-24 00:02:50.746  INFO 7 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2021-04-24 00:02:51.887  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM cmso.DATABASECHANGELOGLOCK
2021-04-24 00:02:51.905  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-04-24 00:02:51.924  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM cmso.DATABASECHANGELOGLOCK
2021-04-24 00:02:51.944  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DELETE FROM cmso.DATABASECHANGELOGLOCK
2021-04-24 00:02:51.945  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO cmso.DATABASECHANGELOGLOCK (ID, `LOCKED`) VALUES (1, 0)
2021-04-24 00:02:51.948  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT `LOCKED` FROM cmso.DATABASECHANGELOGLOCK WHERE ID=1
2021-04-24 00:02:51.956  INFO 7 --- [           main] l.lockservice.StandardLockService        : Successfully acquired change log lock
2021-04-24 00:02:53.255  INFO 7 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: cmso.DATABASECHANGELOG
2021-04-24 00:02:53.258  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-04-24 00:02:53.284  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM cmso.DATABASECHANGELOG
2021-04-24 00:02:53.289  INFO 7 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from cmso.DATABASECHANGELOG
2021-04-24 00:02:53.290  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT * FROM cmso.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2021-04-24 00:02:53.291  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM cmso.DATABASECHANGELOGLOCK
2021-04-24 00:02:53.373  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-04-24 00:02:53.395  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE UNIQUE INDEX DOMAIN_UNIQUE ON DOMAINS (domain ASC)
2021-04-24 00:02:53.408  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-04-24 00:02:53.435  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE UNIQUE INDEX SCHEDULE_KEY ON SCHEDULES (domain ASC, schedule_id ASC)
2021-04-24 00:02:53.451  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE UNIQUE INDEX OPTIMIZER_TRANSACTION_ID_UNIQUE ON SCHEDULES (optimizer_transaction_id ASC)
2021-04-24 00:02:53.461  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-04-24 00:02:53.488  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_SCHEDULE_EVENTS_SCHEDULES_IDX ON SCHEDULE_EVENTS (schedules_id ASC)
2021-04-24 00:02:53.502  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX SEQ_SVENTS ON SCHEDULE_EVENTS (reminder_time ASC)
2021-04-24 00:02:53.513  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-04-24 00:02:53.541  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE UNIQUE INDEX ID_UNIQUE ON DOMAIN_DATA (id ASC)
2021-04-24 00:02:53.557  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_DOMAIN_DATA_SCHEDULES_IDX ON DOMAIN_DATA (schedules_id ASC)
2021-04-24 00:02:53.574  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-04-24 00:02:53.606  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_DOMAIN_IDX ON APPROVAL_TYPES (domain ASC)
2021-04-24 00:02:53.623  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-04-24 00:02:53.663  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_SCHEDULE_APPROVALS_SCHEDULES_IDX ON SCHEDULE_APPROVALS (schedules_id ASC)
2021-04-24 00:02:53.676  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_APPROVAL_TYPES_IDX ON SCHEDULE_APPROVALS (approval_type_id ASC)
2021-04-24 00:02:53.686  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-04-24 00:02:53.709  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_SCHEDULES_IDX ON CHANGE_MANAGEMENT_GROUPS (schedules_id ASC)
2021-04-24 00:02:53.722  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-04-24 00:02:53.731  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-04-24 00:02:53.757  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-04-24 00:02:53.768  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-04-24 00:02:53.783  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-04-24 00:02:53.806  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-04-24 00:02:53.817  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-04-24 00:02:53.817  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DELETE FROM DOMAINS
2021-04-24 00:02:53.821  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO DOMAINS (`domain`) VALUES ('ChangeManagement')
2021-04-24 00:02:53.822  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DELETE FROM APPROVAL_TYPES
2021-04-24 00:02:53.824  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : INSERT INTO APPROVAL_TYPES (`domain`, `approval_type`, `approval_count`) VALUES ('ChangeManagement', 'Tier 2', '1')
2021-04-24 00:02:53.825  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : SQL in file cmso-dbchangelog/onap-cmso-v1-schema.sql executed
2021-04-24 00:02:53.826  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet classpath:cmso-liquibase-changeLog.xml::cmsched-v1-schema1::ATT ran successfully in 514ms
2021-04-24 00:02:53.827  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT MAX(ORDEREXECUTED) FROM cmso.DATABASECHANGELOG
2021-04-24 00:02:53.829  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', '9222573292')
2021-04-24 00:02:53.834  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-04-24 00:02:53.842  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS DROP FOREIGN KEY FK_SCHEDULE_APPROVALS_SCHEDULES
2021-04-24 00:02:53.850  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP FOREIGN KEY FK_CHANGE_MANAGEMENT_GROUPS_SCHEDULES
2021-04-24 00:02:53.860  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP FOREIGN KEY FK_CHANGE_MANAGEMENT_SCHEDULES_CHANGE_MANAGEMENT_GROUP
2021-04-24 00:02:53.869  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP FOREIGN KEY FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1
2021-04-24 00:02:53.878  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS DROP FOREIGN KEY FK_SCHEDULE_APPROVALS_APPROVAL_TYPES
2021-04-24 00:02:53.886  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : -- -----------------------------------------------------
-- DROP THE INDEXES THAT USE INT IDs
-- -----------------------------------------------------
DROP INDEX ID_UNIQUE ON DOMAIN_DATA
2021-04-24 00:02:53.894  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : -- THIS iS NOT NECESSARY PK
DROP INDEX CHANGE_MANAGEMENT_GROUP_ID_UNIQUE ON CHANGE_MANAGEMENT_GROUPS
2021-04-24 00:02:53.903  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX CHANGE_MANAGEMENT_SCHEDULES_VNF_NAME_UNIQUE ON CHANGE_MANAGEMENT_SCHEDULES
2021-04-24 00:02:53.912  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX FK_DOMAIN_DATA_SCHEDULES_IDX ON DOMAIN_DATA
2021-04-24 00:02:53.923  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX FK_SCHEDULE_APPROVALS_SCHEDULES_IDX ON SCHEDULE_APPROVALS
2021-04-24 00:02:53.932  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX FK_APPROVAL_TYPES_IDX ON SCHEDULE_APPROVALS
2021-04-24 00:02:53.943  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX FK_SCHEDULES_IDX ON CHANGE_MANAGEMENT_GROUPS
2021-04-24 00:02:53.953  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX FK_CHANGE_MANAGEMENT_GROUP_CHANGE_MANAGEMENT_SCHEDULES_IDX ON CHANGE_MANAGEMENT_SCHEDULES
2021-04-24 00:02:53.961  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : DROP INDEX FK_CHANGE_WINDOWS_CHANGE_MANAGEMENT_GROUPS1_IDX on CHANGE_MANAGEMENT_CHANGE_WINDOWS
2021-04-24 00:02:53.970  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : SQL in file cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql executed
2021-04-24 00:02:53.984  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : -- Schedules Add UUID column 
ALTER TABLE SCHEDULES ADD COLUMN uuid BINARY(16) NOT NULL FIRST
2021-04-24 00:02:53.994  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : -- Add foreign keys
ALTER TABLE DOMAIN_DATA ADD COLUMN schedules_uuid BINARY(16) NOT NULL
2021-04-24 00:02:54.007  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS ADD COLUMN schedules_uuid BINARY(16) NOT NULL
2021-04-24 00:02:54.016  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_GROUPS ADD COLUMN schedules_uuid BINARY(16) NOT NULL
2021-04-24 00:02:54.036  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS ADD COLUMN schedules_uuid BINARY(16)
2021-04-24 00:02:54.047  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-04-24 00:02:54.056  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-04-24 00:02:54.066  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS ADD COLUMN change_management_group_uuid BINARY(16)
2021-04-24 00:02:54.077  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-04-24 00:02:54.085  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-04-24 00:02:54.093  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-04-24 00:02:54.101  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-04-24 00:02:54.112  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-04-24 00:02:54.120  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : -- Foreign keys
ALTER TABLE SCHEDULE_APPROVALS ADD COLUMN approval_types_uuid BINARY(16) NOT NULL
2021-04-24 00:02:54.129  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : --  SCHEDULE_EVENTS not used
DROP TABLE IF EXISTS SCHEDULE_EVENTS
2021-04-24 00:02:54.137  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SET SQL_SAFE_UPDATES = 0
2021-04-24 00:02:54.138  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-04-24 00:02:54.141  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : UPDATE CHANGE_MANAGEMENT_GROUPS SET uuid = unhex(replace(uuid(), '-', ''))  where uuid is null
2021-04-24 00:02:54.144  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : UPDATE CHANGE_MANAGEMENT_SCHEDULES SET uuid = unhex(replace(uuid(), '-', ''))  where uuid is null
2021-04-24 00:02:54.147  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : UPDATE DOMAIN_DATA SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null
2021-04-24 00:02:54.149  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : UPDATE SCHEDULE_APPROVALS SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null
2021-04-24 00:02:54.152  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : UPDATE CHANGE_MANAGEMENT_CHANGE_WINDOWS SET uuid = unhex(replace(uuid(), '-', '')) where uuid is null
2021-04-24 00:02:54.155  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : UPDATE APPROVAL_TYPES SET uuid = unhex(replace(uuid(), '-', ''))
2021-04-24 00:02:54.158  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-04-24 00:02:54.159  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-04-24 00:02:54.160  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-04-24 00:02:54.161  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-04-24 00:02:54.162  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-04-24 00:02:54.163  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-04-24 00:02:54.163  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SET SQL_SAFE_UPDATES = 1
2021-04-24 00:02:54.164  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES ADD COLUMN request LONGTEXT NULL DEFAULT NULL
2021-04-24 00:02:54.178  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : SQL in file cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql executed
2021-04-24 00:02:54.188  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-04-24 00:02:54.234  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE DOMAIN_DATA DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid)
2021-04-24 00:02:54.268  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE APPROVAL_TYPES DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid)
2021-04-24 00:02:54.312  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid)
2021-04-24 00:02:54.348  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid)
2021-04-24 00:02:54.389  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP PRIMARY KEY, CHANGE id id INT, ADD PRIMARY KEY (uuid)
2021-04-24 00:02:54.424  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-04-24 00:02:54.455  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-04-24 00:02:54.476  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-04-24 00:02:54.487  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-04-24 00:02:54.531  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_DOMAIN_DATA_SCHEDULES_IDX ON DOMAIN_DATA (schedules_uuid ASC)
2021-04-24 00:02:54.546  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-04-24 00:02:54.584  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-04-24 00:02:54.625  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_SCHEDULE_APPROVALS_SCHEDULES_IDX ON SCHEDULE_APPROVALS (schedules_uuid ASC)
2021-04-24 00:02:54.638  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_APPROVAL_TYPES_IDX ON SCHEDULE_APPROVALS (approval_types_uuid ASC)
2021-04-24 00:02:54.647  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-04-24 00:02:54.686  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : CREATE INDEX FK_SCHEDULES_IDX ON CHANGE_MANAGEMENT_GROUPS (schedules_uuid ASC)
2021-04-24 00:02:54.699  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-04-24 00:02:54.708  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-04-24 00:02:54.752  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-04-24 00:02:54.763  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-04-24 00:02:54.772  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-04-24 00:02:54.816  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-04-24 00:02:54.828  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : SQL in file cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql executed
2021-04-24 00:02:54.830  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : -- --------------------------------------------------------------
-- DROP ALL OF THE INTENGER IDs
-- --------------------------------------------------------------
ALTER TABLE SCHEDULES DROP COLUMN id
2021-04-24 00:02:54.839  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE DOMAIN_DATA DROP COLUMN id
2021-04-24 00:02:54.847  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE DOMAIN_DATA DROP COLUMN schedules_id
2021-04-24 00:02:54.858  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE APPROVAL_TYPES DROP COLUMN id
2021-04-24 00:02:54.867  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN id
2021-04-24 00:02:54.876  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN schedules_id
2021-04-24 00:02:54.886  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE SCHEDULE_APPROVALS DROP COLUMN approval_type_id
2021-04-24 00:02:54.894  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP COLUMN id
2021-04-24 00:02:54.911  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_GROUPS DROP COLUMN schedules_id
2021-04-24 00:02:54.926  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP COLUMN id
2021-04-24 00:02:54.935  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_SCHEDULES DROP COLUMN change_management_groups_id
2021-04-24 00:02:54.944  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP COLUMN id
2021-04-24 00:02:54.953  INFO 7 --- [           main] liquibase.executor.jvm.JdbcExecutor      : ALTER TABLE CHANGE_MANAGEMENT_CHANGE_WINDOWS DROP COLUMN change_management_groups_id
2021-04-24 00:02:54.961  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : SQL in file cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql executed
2021-04-24 00:02:54.961  INFO 7 --- [           main] liquibase.changelog.ChangeSet            : ChangeSet classpath:cmso-liquibase-changeLog.xml::cmso-v1.1-schema1::ONAP ran successfully in 1131ms
2021-04-24 00:02:54.962  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', '9222573292')
2021-04-24 00:02:54.966  INFO 7 --- [           main] l.lockservice.StandardLockService        : Successfully released change log lock
2021-04-24 00:02:55.064  INFO 7 --- [           main] o.o.o.c.liquibase.LiquibaseApplication   : Started LiquibaseApplication in 5.823 seconds (JVM running for 6.254)
2021-04-24 00:02:55.069  INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2021-04-24 00:02:55.080  INFO 7 --- [extShutdownHook] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.