HsqlException: Object name already exists

lewis.smith · June 5, 2023, 8:33pm

I’ve migrated my code (via Git), to a new PC, and upon trying to run my project, the changelog generation causes the project to file with the above error. If I “Discard and run” in the Changelog Preview, it will run, however. Is there a way I can wipe the database completely clean and regenerate the changelog?


[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/uidata/liquibase/changelog/001-ui-data.xml::4::ui-data ran successfully in 2ms
Running Changeset: io/jmix/uidata/liquibase/changelog/001-ui-data.xml::5::ui-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table UI_TABLE_PRESENTATION created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/uidata/liquibase/changelog/001-ui-data.xml::5::ui-data ran successfully in 1ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/001-security-data.xml::1::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SEC_RESOURCE_ROLE created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SEC_ROW_LEVEL_ROLE created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SEC_RESOURCE_POLICY created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SEC_ROW_LEVEL_POLICY created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SEC_ROLE_ASSIGNMENT created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/001-security-data.xml::1::security-data ran successfully in 7ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/001-security-data.xml::2-another-db::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_RESOURCE_ROLE_UN_C created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/001-security-data.xml::2-another-db::security-data ran successfully in 1ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/001-security-data.xml::3-another-db::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_ROW_LEVEL_ROLE_UN_C created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/001-security-data.xml::3-another-db::security-data ran successfully in 0ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/001-security-data.xml::4::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table persistent_logins created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/001-security-data.xml::4::security-data ran successfully in 1ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/002-security-data.xml::1::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns DESCRIPTION(text) added to SEC_RESOURCE_ROLE
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns DESCRIPTION(text) added to SEC_ROW_LEVEL_ROLE
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/002-security-data.xml::1::security-data ran successfully in 2ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/002-security-data.xml::2::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns SCOPES(varchar(1000)) added to SEC_RESOURCE_ROLE
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/002-security-data.xml::2::security-data ran successfully in 1ms
Running Changeset: io/jmix/securitydata/liquibase/changelog/003-security-data.xml::1::security-data
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SEC_USER_SUBSTITUTION created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/securitydata/liquibase/changelog/003-security-data.xml::1::security-data ran successfully in 2ms
Running Changeset: io/jmix/reports/liquibase/changelog/001-reports.xml::1::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table REPORT_GROUP created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table REPORT_REPORT created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table REPORT_TEMPLATE created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to REPORT_REPORT (DEFAULT_TEMPLATE_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to REPORT_TEMPLATE (REPORT_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table REPORT_EXECUTION created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_REPORT_EXEC_REPORT_ID created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_REPORT_EXEC_START_TIME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] New row inserted into REPORT_GROUP
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/001-reports.xml::1::reports ran successfully in 15ms
Running Changeset: io/jmix/reports/liquibase/changelog/001-reports.xml::2::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column REPORT_EXECUTION.SERVER_ID dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/001-reports.xml::2::reports ran successfully in 1ms
Running Changeset: io/jmix/reports/liquibase/changelog/001-reports.xml::3::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column REPORT_EXECUTION.PRINCIPAL renamed to USERNAME
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/001-reports.xml::3::reports ran successfully in 1ms
Running Changeset: io/jmix/reports/liquibase/changelog/001-reports.xml::4-another-db::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_REPORT_GROUP_UNIQ_TITLE created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/001-reports.xml::4-another-db::reports ran successfully in 1ms
Running Changeset: io/jmix/reports/liquibase/changelog/001-reports.xml::5-another-db::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_REPORT_REPORT_UNIQ_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/001-reports.xml::5-another-db::reports ran successfully in 0ms
Running Changeset: io/jmix/reports/liquibase/changelog/002-reports.xml::1::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] REPORT_EXECUTION.OUTPUT_DOCUMENT datatype was changed to varchar(4000)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/002-reports.xml::1::reports ran successfully in 1ms
Running Changeset: io/jmix/reports/liquibase/changelog/003-reports.xml::1-another-db::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] REPORT_GROUP.LOCALE_NAMES datatype was changed to varchar(4000)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/003-reports.xml::1-another-db::reports ran successfully in 1ms
Running Changeset: io/jmix/reports/liquibase/changelog/004-reports.xml::1-other::reports
[2023-06-05 21:29:04] INFO [liquibase.changelog] Null constraint dropped from REPORT_REPORT.GROUP_ID
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet io/jmix/reports/liquibase/changelog/004-reports.xml::1-other::reports ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::1::SystemCenter
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_USER created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::1::SystemCenter ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::2::SystemCenter
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_USER_ON_USERNAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::2::SystemCenter ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::3::SystemCenter
[2023-06-05 21:29:04] INFO [liquibase.changelog] New row inserted into SYSC_USER
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::3::SystemCenter ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::4::SystemCenter
[2023-06-05 21:29:04] INFO [liquibase.changelog] New row inserted into SEC_ROLE_ASSIGNMENT
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/010-init-user.xml::4::SystemCenter ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-111510-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_CLIENTS created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-111510-b4b58a50.xml::1::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-111510-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_WEBCAMS created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-111510-b4b58a50.xml::2::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-111510-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_WEBCAMS_CLIENT_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_WEBCAMS (CLIENT_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-111510-b4b58a50.xml::3::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-113428-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns clientName_ID(UUID) added to SYSC_WEBCAMS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-113428-b4b58a50.xml::1::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-113428-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_WEBCAMS (clientName_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-113428-b4b58a50.xml::2::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-113428-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column SYSC_WEBCAMS.CLIENT_NAME_ID dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-113428-b4b58a50.xml::3::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-114020-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns CLIENT_NAME_ID(UUID) added to SYSC_WEBCAMS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-114020-b4b58a50.xml::1::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-114020-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_WEBCAMS (CLIENT_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-114020-b4b58a50.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-114020-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column SYSC_WEBCAMS.CLIENTNAME_ID dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-114020-b4b58a50.xml::3::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-115206-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns CLIENTS_ID(UUID) added to SYSC_WEBCAMS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-115206-b4b58a50.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-115206-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_WEBCAMS (CLIENTS_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-115206-b4b58a50.xml::2::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-115206-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column SYSC_WEBCAMS.CLIENT_NAME_ID dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/20-115206-b4b58a50.xml::3::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-094130-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_SCREENS created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-094130-b4b58a50.xml::1::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-094130-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_SCREENS_CLIENT_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SCREENS (CLIENT_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-094130-b4b58a50.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-122726-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns SCREEN_NAME_ID(UUID) added to SYSC_WEBCAMS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-122726-b4b58a50.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-122726-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_WEBCAMS (SCREEN_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-122726-b4b58a50.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-122726-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column SYSC_WEBCAMS.SCREEN_NAME dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/02/21-122726-b4b58a50.xml::3::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-093640-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_SIM_CARDS created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-093640-b4b58a50.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-093640-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_SIM_CARDS_SITE_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SIM_CARDS (SITE_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-093640-b4b58a50.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-124157-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns ROUTER_IP_ID(UUID) added to SYSC_SCREENS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-124157-b4b58a50.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-124157-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_SCREENS_ROUTER_IP created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SCREENS (ROUTER_IP_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-124157-b4b58a50.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns SCREEN_NAME_ID(UUID) added to SYSC_SIM_CARDS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::1::sysc ran successfully in 2ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_SIM_CARDS_SCREEN_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SIM_CARDS (SCREEN_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::2::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column SYSC_SCREENS.ROUTER_IP_ID dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::3::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::4::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Column SYSC_SIM_CARDS.SITE_NAME_ID dropped
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-145556-b4b58a50.xml::4::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_EQUIPMENT created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Table SYSC_SUPPLIERS created
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::2::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_EQUIPMENT_SCREEN_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_EQUIPMENT (SCREEN_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::3::sysc ran successfully in 2ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::4::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_EQUIPMENT_SUPPLIER created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_EQUIPMENT (SUPPLIER_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-232828-b4b58a50.xml::4::sysc ran successfully in 2ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-233647-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns OFFICE_WAREHOUSE(BOOLEAN) added to SYSC_EQUIPMENT
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/02-233647-b4b58a50.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns CONTRACT_END(DATE),CONTRACT_START(DATE),MODEL_TYPE_ID(UUID),SCREEN_STATUS(BOOLEAN),SUPPLIER_NAME_ID(UUID),UNILED_LIVE(DATE) added to SYSC_SCREENS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::1::sysc ran successfully in 3ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns MODEL_TYPE(VARCHAR(255)) added to SYSC_EQUIPMENT
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_SCREENS_MODEL_TYPE created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SCREENS (MODEL_TYPE_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::3::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::4::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSC_SCREENS_SUPPLIER_NAME created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SCREENS (SUPPLIER_NAME_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/03/03-164529-b4b58a50.xml::4::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::1::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns CLIENT_ADDRESS(VARCHAR(255)) added to SYSC_CLIENTS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::1::sysc ran successfully in 0ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::2::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Columns CLIENT_ADDRESS_ID(UUID),HIGH_PRIORITY(BOOLEAN) added to SYSC_SCREENS
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::2::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::3::sysc
[2023-06-05 21:29:04] INFO [liquibase.changelog] Index IDX_SYSCSCREENS_CLIENTADDRESS created
[2023-06-05 21:29:04] INFO [liquibase.changelog] Foreign key constraint added to SYSC_SCREENS (CLIENT_ADDRESS_ID)
[2023-06-05 21:29:04] INFO [liquibase.changelog] ChangeSet com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::3::sysc ran successfully in 1ms
Running Changeset: com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::4::sysc
[2023-06-05 21:29:04] INFO [liquibase.lockservice] Successfully released change log lock
21:29:04.815 [main] INFO hsqldb.db.HSQLDB888D3FB00F.ENGINE - Database closed
Unexpected error running Liquibase: Migration failed for change set com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::4::sysc:
     Reason: liquibase.exception.DatabaseException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE in statement [ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL] [Failed SQL: (-5504) ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL]
For more information, please use the --logLevel flag
[2023-06-05 21:29:04] SEVERE [liquibase.integration] Unexpected error running Liquibase: Migration failed for change set com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::4::sysc:
     Reason: liquibase.exception.DatabaseException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE in statement [ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL] [Failed SQL: (-5504) ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL]
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::4::sysc:
     Reason: liquibase.exception.DatabaseException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE in statement [ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL] [Failed SQL: (-5504) ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
	at liquibase.Liquibase.lambda$null$0(Liquibase.java:265)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.Liquibase.lambda$update$1(Liquibase.java:264)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Liquibase.runInScope(Liquibase.java:2405)
	at liquibase.Liquibase.update(Liquibase.java:211)
	at liquibase.Liquibase.update(Liquibase.java:197)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1869)
	at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:398)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.integration.commandline.Main$1.run(Main.java:397)
	at liquibase.integration.commandline.Main$1.run(Main.java:221)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:165)
	at liquibase.integration.commandline.Main.run(Main.java:221)
	at liquibase.integration.commandline.Main.main(Main.java:164)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set com/triwonderdigital/systemcenter/liquibase/changelog/2023/06/05-212727-0b3a244e.xml::4::sysc:
     Reason: liquibase.exception.DatabaseException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE in statement [ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL] [Failed SQL: (-5504) ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:696)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
	at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
	at liquibase.Scope.lambda$child$0(Scope.java:180)
	at liquibase.Scope.child(Scope.java:189)
	at liquibase.Scope.child(Scope.java:179)
	at liquibase.Scope.child(Scope.java:158)
	at liquibase.Scope.child(Scope.java:243)
	at liquibase.Scope.child(Scope.java:247)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
	... 26 more
Caused by: liquibase.exception.DatabaseException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE in statement [ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL] [Failed SQL: (-5504) ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:397)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:83)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:151)
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:661)
	... 46 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE in statement [ALTER TABLE PUBLIC.SYSC_SCREENS ADD CONSTRAINT FK_SYSC_SCREENS_ON_MODEL_TYPE FOREIGN KEY (MODEL_TYPE_ID) REFERENCES PUBLIC.SYSC_EQUIPMENT (ID) ON DELETE SET NULL]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:393)
	... 51 more
Caused by: org.hsqldb.HsqlException: object name already exists: FK_SYSC_SCREENS_ON_MODEL_TYPE
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
	at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
	at org.hsqldb.TableWorks.checkCreateForeignKey(Unknown Source)
	at org.hsqldb.TableWorks.addForeignKey(Unknown Source)
	at org.hsqldb.StatementSchema.getResult(Unknown Source)
	at org.hsqldb.StatementSchema.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 54 more

lewis.smith · June 5, 2023, 10:05pm

I created a new branch on git whereby I removed the .gitignore files and pushed EVERYTHING. That seems to allow the project to run, so there’s something not right when the default .gitignore is used.

These were the old contents:

ROOT

.jmix

.gradle
build/
!gradle/wrapper/gradle-wrapper.jar
!**/src/main/**
!**/src/test/**

### IntelliJ IDEA ###
*.iws
*.iml
*.ipr
out/

### VS Code ###
.vscode/
/log

.IDEA

# Default ignored files
/shelf/
/workspace.xml

pinyazhin · June 6, 2023, 7:33am

Hello!

To completely regenerate Changelogs and recreate database you can do the following:

Remove all Liquibase Changelog files from the project.
Recreate database. You can perform this using Studio: right click on Main Data Store, select Recreate. After that database will contain tables only from add-ons.
Right click on Main Data Store again and select Generate Liquibase Changelog. It generates Changelogs according to existing JPA entities and Database state.
Start project or recreate database again.

The default .gitignore in project excludes files and folders that can be recreated/generated. There is no need to store them, because when project will be created from Git repository they will be generated again.