Quartz tables dropped after 1.4.4 upgrade

Support
#1

I had Quartz installed and after the 1.4.4 upgrade (from 1.4.2) all my Quartz tables are missing. I see the LiquidBase change log dropped them. I tried uninstalling and reinstalling Quartz. No help. What’s up?

<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.11.xsd"
        objectQuotingStrategy="QUOTE_ONLY_RESERVED_WORDS">
    <changeSet id="1" author="semi">
        <dropForeignKeyConstraint baseTableName="qrtz_blob_triggers"
                                  constraintName="qrtz_blob_triggers_sched_name_fkey"/>
    </changeSet>
    <changeSet id="2" author="semi">
        <dropForeignKeyConstraint baseTableName="qrtz_cron_triggers"
                                  constraintName="qrtz_cron_triggers_sched_name_fkey"/>
    </changeSet>
    <changeSet id="3" author="semi">
        <dropForeignKeyConstraint baseTableName="qrtz_simple_triggers"
                                  constraintName="qrtz_simple_triggers_sched_name_fkey"/>
    </changeSet>
    <changeSet id="4" author="semi">
        <dropForeignKeyConstraint baseTableName="qrtz_simprop_triggers"
                                  constraintName="qrtz_simprop_triggers_sched_name_fkey"/>
    </changeSet>
    <changeSet id="5" author="semi">
        <dropForeignKeyConstraint baseTableName="qrtz_triggers" constraintName="qrtz_triggers_sched_name_fkey"/>
    </changeSet>
    <changeSet id="6" author="semi">
        <dropTable cascadeConstraints="true" tableName="persistent_logins"/>
    </changeSet>
    <changeSet id="7" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_blob_triggers"/>
    </changeSet>
    <changeSet id="8" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_calendars"/>
    </changeSet>
    <changeSet id="9" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_cron_triggers"/>
    </changeSet>
    <changeSet id="10" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_fired_triggers"/>
    </changeSet>
    <changeSet id="11" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_job_details"/>
    </changeSet>
    <changeSet id="12" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_locks"/>
    </changeSet>
    <changeSet id="13" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_paused_trigger_grps"/>
    </changeSet>
    <changeSet id="14" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_scheduler_state"/>
    </changeSet>
    <changeSet id="15" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_simple_triggers"/>
    </changeSet>
    <changeSet id="16" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_simprop_triggers"/>
    </changeSet>
    <changeSet id="17" author="semi">
        <dropTable cascadeConstraints="true" tableName="qrtz_triggers"/>
    </changeSet>
</databaseChangeLog>
#2

Looks like 1.4.2 to 1.4.4 upgrade process has some bug!
Successfully upgrade project with Quartz addon but got problem on upgrading another project (without Quartz):

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.11.xsd"
        objectQuotingStrategy="QUOTE_ONLY_RESERVED_WORDS">
    <changeSet id="1" author="portal">
        <dropTable cascadeConstraints="true" tableName="oauth_access_token"/>
    </changeSet>
    <changeSet id="2" author="portal">
        <dropTable cascadeConstraints="true" tableName="oauth_refresh_token"/>
    </changeSet>
    <changeSet id="3" author="portal">
        <dropTable cascadeConstraints="true" tableName="persistent_logins"/>
    </changeSet>
</databaseChangeLog>
#3

Problem when updating another project from 1.4.2 to 1.4.4:

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.11.xsd"
        objectQuotingStrategy="QUOTE_ONLY_RESERVED_WORDS">
    <changeSet id="1" author="syncer">
        <dropTable cascadeConstraints="true" tableName="persistent_logins"/>
    </changeSet>
</databaseChangeLog>
#4

I had to script out the quartz tables and dependencies from another database and re-create them. Then I discarded the changelog that dropped the tables in the first place. I made the mistake of not checking in code before I upgraded but I finally got my project up to 1.4.4 with Quartz working. Day in my life lost.

#5

BTW When I went to my client site and pulled from git the code on a different computer. I saw the changelog was once again trying to drop Quarts tables. So I clicked “discard and run” and then it failed for not have the Quartz library. I saw Gradle had lost the quartz-starter dependency. So on that computer I could go back to Marketplace and simply re-add Quartz without an issue.

#6

Remove liquibase chagelog file that drop quartz table.
It located somewhere in [project_home]/src/main/rosources/…/liquibase/changelog/2023/02/