{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"Liquibase recommends using the standard rollback functionality which “rewinds” a database to a specified point. All changesets deployed after that point are rolled back. These rollbacks are documented here:","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://datical-cs.atlassian.net/wiki/spaces/DDOC/pages/896570504#CLICommands-rollback"}},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"However, there is a newly supported command ","type":"text"},{"text":"hammer precise","type":"text","marks":[{"type":"code"}]},{"text":" command which allows the user to selectively rollback specific changesets. ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"WARNING! With this command ","type":"text"},{"text":"Liquibase cannot guarantee that database dependencies will not be impacted by the rollback","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"Take care not to remove changesets that later deployments built on.","type":"text"}]},{"type":"paragraph","content":[{"text":"For example:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Deploy a create table","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Deploy a view on that table","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If you now attempt to roll back only the changeset that created the table, then the view becomes invalid. It is up to the user to ensure that precise rollbacks include all the necessary database dependencies.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Syntax for Precise Rollback","type":"text"}]},{"type":"paragraph","content":[{"text":"Syntax for Precise Rollback is as follows:","type":"text"}]},{"type":"codeBlock","content":[{"text":"hammer rollback precise [--preview] [--=, ...]","type":"text"}]},{"type":"paragraph","content":[{"text":"The search options determine ","type":"text"},{"text":"which changesets to rollback","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"Searches are not case-sensitive. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Multiple values in one statement are OR'ed together. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Multiple search option statements are AND'ed together.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Search option statements take one or a comma-separated list of values. They are provided for changeset attributes as follows: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchIds","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"id","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchLabels","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"label","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchContexts","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"context","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchIgnore","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"ignore","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" | ","type":"text"},{"text":"false - ","type":"text","marks":[{"type":"code"}]},{"text":"Searches for false also return changesets where the ignore attribute is not set. ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" | ","type":"text"},{"text":"false","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchOrigFilePaths","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"origFilePath","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchOrigFileNames","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"origFileName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"searchVersion","type":"text","marks":[{"type":"code"}]},{"text":" - ","type":"text"},{"text":"version","type":"text","marks":[{"type":"code"}]},{"text":", an integer","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Conditions for Precise Rollback","type":"text"}]},{"type":"paragraph","content":[{"text":"Changesets must meet the following criteria when evaluated for a precise rollback:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Changesets must be deployed on the specified databases","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"A rollback script is provided with the original SQL script for:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DDL","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DATA_DML","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SQL_DIRECT","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For","type":"text"},{"text":" stored logic:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Must be using DaticalDB 7.18+ ","type":"text"},{"text":"(There was an engineering ticket to support precise rollback with Stored Logic: ","type":"text","marks":[{"type":"em"}]},{"type":"inlineCard","attrs":{"url":"https://datical.atlassian.net/browse/DAT-10150"}},{"text":".)","type":"text","marks":[{"type":"em"}]},{"text":" ","type":"text"}]}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"How Precise Rollback Works","type":"text"}]},{"type":"paragraph","content":[{"text":"When using precise rollback, the associated -rollback script is run on the database. The corresponding row in the DATABASECHANGELOG table is removed.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Upon the next deployment the rollback changesets would be eligible for deployment again. To permanently rollback changes, the changesets must be marked with ignore status.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example Scenarios","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"DDL and DIRECT and DATA_DML","type":"text"}]},{"type":"paragraph","content":[{"text":"A developer checks in a script along with a -rollback script. When packaging the file, the developer includes a work item/JIRA, eg. ","type":"text"},{"text":"JIRA-7126","type":"text","marks":[{"type":"code"}]},{"text":". The changeset looks like:","type":"text"}]},{"type":"codeBlock","content":[{"text":" \n \n \n \n \n [JIRA-7126] add constraint\n ","type":"text"}]},{"type":"paragraph","content":[{"text":"The following commands could be used to rollback:","type":"text"}]},{"type":"paragraph","content":[{"text":"hammer rollback DEV precise --searchLabels=JIRA-7126","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"To use multiple labels use:","type":"text"}]},{"type":"paragraph","content":[{"text":"hammer rollback DEV precise --searchLabels=\"rules_test_005.sql\" --searchLabels=\"dev\"","type":"text","marks":[{"type":"code"}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":742,"id":"f6ef40ff-6f8d-4b62-9549-6deccfad1c36","collection":"contentId-3270705153","type":"file","height":262}}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"STORED LOGIC (functions, pkg, pkg body, procedures, triggers, and views)","type":"text"}]},{"type":"paragraph","content":[{"text":"On DaticalDB 7.18+","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Stored logic script has been added but not modified (changelog only has version 0 and version 1)","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Using a rollback will ","type":"text"},{"text":"drop","type":"text","marks":[{"type":"strong"}]},{"text":" the object","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Stored logic script has been modified with a label JIRA-6544 (version 2)","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Using a rollback with --searchLabel=JIRA-6544 will ","type":"text"},{"text":"return the object to its earlier version","type":"text","marks":[{"type":"strong"}]},{"text":" (version 1)","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you try to rollback to a stored logic version that is not the latest version, you will get an ","type":"text"},{"text":"error","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"codeBlock","content":[{"text":"Rollback of 1 change set to LiquibaseChangesetKey [changesetId='20220628221529316_test_new_proc_001', author='Amy Smith'] was not successful. The ChangeSet with id '20220628221529316_test_new_proc_001', author 'Amy Smith' and version '1' can not be rolled back. The ChangeLog contains the ChangeSet that has a higher version\n\nFailed on:changeSet: Id='20220628221529316_test_new_proc_001' author='Amy Smith'\n\nDid not attempt to rollback:changeSet: Id='20220628221529316_test_new_proc_001' author='Amy Smith'","type":"text"}]},{"type":"paragraph"}]}]}]}]}],"version":1}

Browser not supported