It should unlock the database at the end. We'll have to track down the
problem.
Nathan
From: August Gresens [mailto:[email protected]]
Sent: Thursday, February 26, 2009 4:34 PM
To: [email protected]
Subject: [Liquibase-user] future rollback script does not unlock
Hello
My future rollback scripts seem to lock the database, but does not
unlock at the end.
This is a pain, because if I want to roll forward, I have to manually
unlock the database.
Is this by design? Is there a way to configure the future rollback to
include an unlock command at the end?
Thanks,
August
-- *********************************************************************
-- SQL to roll back currently unexecuted changes
-- *********************************************************************
-- Change Log: lb_dvr_users.xml
-- Ran at: 2/26/09 5:17 PM
-- Against:
r...@jdbc:mysql://127.0.0.1:3306/dvr_web_users?useJvmCharsetConverters=t
rue
-- LiquiBase version: 1.8.1
-- *********************************************************************
-- Lock Database
UPDATE `DATABASECHANGELOGLOCK` SET `LOCKED` = 1, `LOCKEDBY` =
'192.168.137.1 (192.168.137.1)', `LOCKGRANTED` = '2009-02-26
17:19:29.728' WHERE ID = 1;
-- Rolling Back ChangeSet: lb_dvr_users.xml::41::august::(MD5Sum:
9504e1971f133d44a9ced8b2a7942e)
ALTER TABLE `test_table` ALTER `session_id` DROP DEFAULT;
ALTER TABLE `test_table` DROP COLUMN `session_id`;
DELETE FROM `DATABASECHANGELOG` WHERE ID='41' AND AUTHOR='august' AND
FILENAME='lb_dvr_users.xml';
-- Rolling Back ChangeSet: lb_dvr_users.xml::40::august::(MD5Sum:
2581fd31a9bac54f9c385743cda784)
DROP TABLE test_table;
DELETE FROM `DATABASECHANGELOG` WHERE ID='40' AND AUTHOR='august' AND
FILENAME='lb_dvr_users.xml';
--
August Gresens
Technical Director
Massiverse, LLC.
[email protected]
http://www.massiverse.com
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
