Skip to content

Instantly share code, notes, and snippets.

@albert-hg

albert-hg/liquibase.log Secret

Created January 14, 2021 10:27
Show Gist options
  • Save albert-hg/bf2e1d76da40c6f3ac658983cfbd4277 to your computer and use it in GitHub Desktop.
Save albert-hg/bf2e1d76da40c6f3ac658983cfbd4277 to your computer and use it in GitHub Desktop.
Download ZIP
completely log for the management system build process by liquibase
Raw
liquibase.log
2021-01-14 17:06:11,401 INFO [restartedMain] JdbcExecutor: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2021-01-14 17:06:11,409 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2021-01-14 17:06:11,413 INFO [restartedMain] JdbcExecutor: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2021-01-14 17:06:11,416 INFO [restartedMain] JdbcExecutor: DELETE FROM PUBLIC.DATABASECHANGELOGLOCK
2021-01-14 17:06:11,417 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2021-01-14 17:06:11,419 INFO [restartedMain] JdbcExecutor: SELECT LOCKED FROM PUBLIC.DATABASECHANGELOGLOCK WHERE ID=1
2021-01-14 17:06:11,426 INFO [restartedMain] StandardLockService: Successfully acquired change log lock
2021-01-14 17:06:12,673 INFO [restartedMain] StandardChangeLogHistoryService: Creating database history table with name: PUBLIC.DATABASECHANGELOG
2021-01-14 17:06:12,674 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2021-01-14 17:06:12,674 INFO [restartedMain] JdbcExecutor: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOG
2021-01-14 17:06:12,675 INFO [restartedMain] StandardChangeLogHistoryService: Reading from PUBLIC.DATABASECHANGELOG
2021-01-14 17:06:12,675 INFO [restartedMain] JdbcExecutor: SELECT * FROM PUBLIC.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2021-01-14 17:06:12,676 INFO [restartedMain] JdbcExecutor: SELECT COUNT(*) FROM PUBLIC.DATABASECHANGELOGLOCK
2021-01-14 17:06:12,689 INFO [restartedMain] JdbcExecutor: CREATE SEQUENCE PUBLIC.sequence_generator START WITH 10 INCREMENT BY 1
2021-01-14 17:06:12,691 INFO [restartedMain] ChangeSet: Sequence sequence_generator created
2021-01-14 17:06:12,691 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/000000000000000_init.xml::000000000000000_init::albert ran successfully in 2ms
2021-01-14 17:06:12,692 INFO [restartedMain] JdbcExecutor: SELECT MAX(ORDEREXECUTED) FROM PUBLIC.DATABASECHANGELOG
2021-01-14 17:06:12,696 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('000000000000000_init', 'albert', 'liquibase/changelog/000000000000000_init.xml', NOW(), 1, '8:6221296804d843adc35538a3616e8f8a', 'createSequence sequenceName=sequence_generator', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,703 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.member (id BIGINT NOT NULL, name VARCHAR(50) NOT NULL, CONSTRAINT PK_MEMBER PRIMARY KEY (id))
2021-01-14 17:06:12,704 INFO [restartedMain] ChangeSet: Table member created
2021-01-14 17:06:12,705 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611000_addEntity_Member.xml::202101081611000::albert ran successfully in 2ms
2021-01-14 17:06:12,705 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611000', 'albert', 'liquibase/changelog/202101081611000_addEntity_Member.xml', NOW(), 2, '8:a8e1d71ca2e25d86ae42eb744fd7ed9a', 'createTable tableName=member', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,706 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.card (member_id BIGINT NOT NULL, level INT NOT NULL, CONSTRAINT PK_CARD PRIMARY KEY (member_id))
2021-01-14 17:06:12,707 INFO [restartedMain] ChangeSet: Table card created
2021-01-14 17:06:12,707 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611001_addEntity_Card.xml::202101081611001::albert ran successfully in 1ms
2021-01-14 17:06:12,708 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611001', 'albert', 'liquibase/changelog/202101081611001_addEntity_Card.xml', NOW(), 3, '8:46ecee821a01e3b7c43e2b285aca3541', 'createTable tableName=card', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,709 INFO [restartedMain] JdbcExecutor: ALTER TABLE PUBLIC.card ADD CONSTRAINT fk_card_member_id FOREIGN KEY (member_id) REFERENCES PUBLIC.member (id)
2021-01-14 17:06:12,715 INFO [restartedMain] ChangeSet: Foreign key constraint added to card (member_id)
2021-01-14 17:06:12,715 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611001_addEntity_Card.xml::202101081611001-1::albert ran successfully in 7ms
2021-01-14 17:06:12,716 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611001-1', 'albert', 'liquibase/changelog/202101081611001_addEntity_Card.xml', NOW(), 4, '8:dacade33a24354ce0fb006a4eead6588', 'addForeignKeyConstraint baseTableName=card, constraintName=fk_card_member_id, referencedTableName=member', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,717 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.gym (id BIGINT NOT NULL, name VARCHAR(50) NOT NULL, CONSTRAINT PK_GYM PRIMARY KEY (id))
2021-01-14 17:06:12,717 INFO [restartedMain] ChangeSet: Table gym created
2021-01-14 17:06:12,718 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611002_addEntity_Gym.xml::202101081611002::albert ran successfully in 2ms
2021-01-14 17:06:12,718 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611002', 'albert', 'liquibase/changelog/202101081611002_addEntity_Gym.xml', NOW(), 5, '8:f5099610dc0080b27ef2bf2e0ec9d855', 'createTable tableName=gym', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,719 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.card_gym (card_id BIGINT NOT NULL, gym_id BIGINT NOT NULL)
2021-01-14 17:06:12,720 INFO [restartedMain] ChangeSet: Table card_gym created
2021-01-14 17:06:12,721 INFO [restartedMain] JdbcExecutor: ALTER TABLE PUBLIC.card_gym ADD PRIMARY KEY (card_id, gym_id)
2021-01-14 17:06:12,723 INFO [restartedMain] ChangeSet: Primary key added to card_gym (card_id, gym_id)
2021-01-14 17:06:12,723 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611003_addJunction_Card_Gym.xml::202101081611003::albert ran successfully in 4ms
2021-01-14 17:06:12,724 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611003', 'albert', 'liquibase/changelog/202101081611003_addJunction_Card_Gym.xml', NOW(), 6, '8:813d48a5e5d23162a7a4620a865dd8db', 'createTable tableName=card_gym; addPrimaryKey tableName=card_gym', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,725 INFO [restartedMain] JdbcExecutor: ALTER TABLE PUBLIC.card_gym ADD CONSTRAINT fk_card_gym_card_id FOREIGN KEY (card_id) REFERENCES PUBLIC.card (member_id)
2021-01-14 17:06:12,728 INFO [restartedMain] ChangeSet: Foreign key constraint added to card_gym (card_id)
2021-01-14 17:06:12,728 INFO [restartedMain] JdbcExecutor: ALTER TABLE PUBLIC.card_gym ADD CONSTRAINT fk_card_gym_gym_id FOREIGN KEY (gym_id) REFERENCES PUBLIC.gym (id)
2021-01-14 17:06:12,729 INFO [restartedMain] ChangeSet: Foreign key constraint added to card_gym (gym_id)
2021-01-14 17:06:12,729 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611003_addJunction_Card_Gym.xml::202101081611003-1::albert ran successfully in 4ms
2021-01-14 17:06:12,730 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611003-1', 'albert', 'liquibase/changelog/202101081611003_addJunction_Card_Gym.xml', NOW(), 7, '8:f48979d05b09f5a4de8b1935a4b29dec', 'addForeignKeyConstraint baseTableName=card_gym, constraintName=fk_card_gym_card_id, referencedTableName=card; addForeignKeyConstraint baseTableName=card_gym, constraintName=fk_card_gym_gym_id, referencedTableName=gym', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,731 INFO [restartedMain] JdbcExecutor: CREATE TABLE PUBLIC.logging (id BIGINT NOT NULL, enter_datetime TIMESTAMP NOT NULL, member_id BIGINT NOT NULL, gym_id BIGINT NOT NULL, CONSTRAINT PK_LOGGING PRIMARY KEY (id))
2021-01-14 17:06:12,732 INFO [restartedMain] ChangeSet: Table logging created
2021-01-14 17:06:12,732 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611004_addEntity_Logging.xml::202101081611004::albert ran successfully in 1ms
2021-01-14 17:06:12,733 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611004', 'albert', 'liquibase/changelog/202101081611004_addEntity_Logging.xml', NOW(), 8, '8:9aafe3b0373e33b6287fe8c74a2f9a20', 'createTable tableName=logging', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,733 INFO [restartedMain] JdbcExecutor: ALTER TABLE PUBLIC.logging ADD CONSTRAINT fk_logging_member_id FOREIGN KEY (member_id) REFERENCES PUBLIC.member (id)
2021-01-14 17:06:12,735 INFO [restartedMain] ChangeSet: Foreign key constraint added to logging (member_id)
2021-01-14 17:06:12,735 INFO [restartedMain] JdbcExecutor: ALTER TABLE PUBLIC.logging ADD CONSTRAINT fk_logging_gym_id FOREIGN KEY (gym_id) REFERENCES PUBLIC.gym (id)
2021-01-14 17:06:12,748 INFO [restartedMain] ChangeSet: Foreign key constraint added to logging (gym_id)
2021-01-14 17:06:12,748 INFO [restartedMain] ChangeSet: ChangeSet liquibase/changelog/202101081611004_addEntity_Logging.xml::202101081611004-1::albert ran successfully in 15ms
2021-01-14 17:06:12,748 INFO [restartedMain] JdbcExecutor: INSERT INTO PUBLIC.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('202101081611004-1', 'albert', 'liquibase/changelog/202101081611004_addEntity_Logging.xml', NOW(), 9, '8:5a7cd00ae71c6676cf9bf510db3109be', 'addForeignKeyConstraint baseTableName=logging, constraintName=fk_logging_member_id, referencedTableName=member; addForeignKeyConstraint baseTableName=logging, constraintName=fk_logging_gym_id, referencedTableName=gym', '', 'EXECUTED', NULL, NULL, '3.8.9', '0615172676')
2021-01-14 17:06:12,750 INFO [restartedMain] StandardLockService: Successfully released change log lock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment