# Unable to rollback **URL:** \ **Category:** General Discussion\ **Created:** [August 21, 2024, 5:03pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626 "2024-08-21T17:03:14Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![liqui](https://avatars.discourse-cdn.com/v4/letter/l/858c86/32.png) [@liqui](https://forum.liquibase.org/u/liqui)\ **Post date:** [August 21, 2024, 5:03pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/1 "2024-08-21T17:03:14Z")
I have the tag as shown below: id | author | filename | dateexecuted | orderexecuted | exectype | md5sum | description | comments | tag | liquibase | contexts | labels | deployment\_id -----±-----------±-----------------------------±---------------------------±--------------±---------±-----------------------------------±------------±---------±----------------±----------±---------±-------±-------------- raw | includeAll | postgresql-stag3-update.sql | 2024-08-19 21:19:03.959063 | 1 | EXECUTED | 9:4e4bf538de0c6606341d6d072313ba40 | sql | | audittraildb16 | 4.29.1 | | | 4102343635 raw | includeAll | postgresql-stag3-update2.sql | 2024-08-19 21:33:19.940934 | 2 | EXECUTED | 9:d0693620247e82ad389dfcedbc574e55 | sql | | audittraildb162 | 4.29.1 | | | 4103199526 raw | includeAll | postgresql-stag3-update3.sql | 2024-08-19 22:11:02.525337 | 3 | EXECUTED | 9:761275a470fb08856cab00490aae1c1b | sql | | | 4.29.1 | | | 4105462412 (3 rows) when I tried to run “liquibase rollback audittraildb162” to drop the created table. it failed, there is no error in liquibase.log as shown below. INFO: 0 changesets rolled back. Logs saved to liquibase.log Liquibase command ‘rollback’ was executed successfully. ---
**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\ **Post date:** [August 21, 2024, 5:34pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/2 "2024-08-21T17:34:50Z")
Try “liquibase rollback-count 2” to see if that works. Also set log-level=INFO and sql-log-level=INFO for more log output. ---
**Author:** ![liqui](https://avatars.discourse-cdn.com/v4/letter/l/858c86/32.png) [@liqui](https://forum.liquibase.org/u/liqui)\ **Post date:** [August 21, 2024, 5:58pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/3 "2024-08-21T17:58:57Z")
thanks. I set it up in liquibase.property with: logLevel: INFO sql-log-level:INFO after running the command, liquibase rollback-count 2, same result. see. the log below: Starting Liquibase at 17:54:24 using Java 11.0.20 (version 4.29.1 #3316 built at 2024-07-30 20:15+0000) [2024-08-21 17:54:24] INFO [liquibase.ui] Liquibase Version: 4.29.1 [2024-08-21 17:54:24] INFO [liquibase.ui] Liquibase Open Source 4.29.1 by Liquibase [2024-08-21 17:54:24] INFO [liquibase.integration] Starting command execution. [2024-08-21 17:54:24] WARNING [liquibase.configuration] Potentially ignored key(s) in file exists at path liquibase.properties - ‘sqlLogLevel’ [2024-08-21 17:54:30] INFO [liquibase.database] Set default schema name to public [2024-08-21 17:54:32] INFO [liquibase.changelog] Reading from public.databasechangelog [2024-08-21 17:54:32] INFO [liquibase.lockservice] Successfully acquired change log lock [2024-08-21 17:54:32] INFO [liquibase.changelog] Reading from public.databasechangelog [2024-08-21 17:54:32] INFO [liquibase.ui] INFO: 0 changesets rolled back. [2024-08-21 17:54:32] INFO [liquibase.command] Rollback command completed successfully. [2024-08-21 17:54:33] INFO [liquibase.lockservice] Successfully released change log lock [2024-08-21 17:54:33] INFO [liquibase.command] Command execution complete [2024-08-21 17:54:33] INFO [liquibase.ui] Logs saved to liquibase.log [2024-08-21 17:54:33] INFO [liquibase.ui] Liquibase command ‘rollback-count’ was executed successfully. ---
**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\ **Post date:** [August 21, 2024, 8:40pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/4 "2024-08-21T20:40:16Z")
Is your databasechangelog in public? public.databasechangelog ---
**Author:** ![liqui](https://avatars.discourse-cdn.com/v4/letter/l/858c86/32.png) [@liqui](https://forum.liquibase.org/u/liqui)\ **Post date:** [August 22, 2024, 3:54pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/5 "2024-08-22T15:54:26Z")
yes, =\> \dt List of relations Schema | Name | Type | Owner public | databasechangelog | table | postgres public | databasechangeloglock | table | postgres ---
**Author:** ![liqui](https://avatars.discourse-cdn.com/v4/letter/l/858c86/32.png) [@liqui](https://forum.liquibase.org/u/liqui)\ **Post date:** [August 26, 2024, 7:56pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/6 "2024-08-26T19:56:52Z")
not sure if there are any missing piece in my changelog-file, here is the content: –liquibase formatted sql –changeset author:1 CREATE TABLE myaudit ( id bigint NOT NULL, companydomainname character varying(255), ipaddress character varying(255) ); –rollback drop table myaudit; –changeset author.lastname:2 ALTER TABLE myaudit ADD COLUMN phone varchar(25); –rollback ALTER TABLE myaudit DROP COLUMN phone; ---
**Author:** ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)\ **Post date:** [August 26, 2024, 8:24pm UTC](https://forum.liquibase.org/t/unable-to-rollback/9626/7 "2024-08-26T20:24:01Z")
Something is out of sync since your databasechangelog rows in the first post have “raw:includeAll” which indicates these are not being treated as “liquibase formatted sql” files. The file you are now showing have “author:1”. Please now provide your master changelog file contents.