Liquibase in Grails: “Empty result set, expected one row”

Question

I made a change to a Grails domain class and ran

grails db-gorm-diff 2012-11-20-domain-class-change.groovy --add (obviously with another name there)

and was getting a “change lock” error from Liquibase:

Error executing bootstraps: liquibase.exception.LockException: Could not acquire change log lock. Currently locked by computer-name.local […]

So (stupidly, it seems) following the advice in an aged thread dealing with a similar problem with the Autobase plugin, I deleted the rows in the change log lock table:

mysql> delete from DATABASECHANGELOGLOCK;

and now get this beautiful Liquibase error:

Error executing bootstraps: liquibase.exception.DatabaseException: Empty result set, expected one row

which clearly tells me, too late to change this, that I shouldn’t have deleted that row from the table.

What can I do about this now?

Answer 1

There is a script for this in the plugin - use http://grails-plugins.github.com/grails-database-migration/docs/manual/ref/Maintenance%20Scripts/dbm-release-locks.html