Errors running a SQL baseline file on LQ 2.0RC2 nightly build

General Discussion
1

I’m trying to rebaseline a Liquibase managed Postgres database.  I took a schema dump using pg_dump, and I’m running it against an empty database.  Here’s the XML:

       

           
               
                   
               
           
           

       

It appears that all of the SQL runs, however it errors out when trying to release the lock:

    liquibase-update:     [echo] About to update jdbc:postgresql://localhost:5432/analytics [updateDatabase] INFO 6/30/10 8:23 PM:liquibase: Successfully acquired change log lock [updateDatabase] INFO 6/30/10 8:23 PM:liquibase: Creating database history table with name: databasechangelog [updateDatabase] INFO 6/30/10 8:23 PM:liquibase: Reading from databasechangelog [updateDatabase] INFO 6/30/10 8:23 PM:liquibase: Reading from databasechangelog [updateDatabase] INFO 6/30/10 8:23 PM:liquibase: ChangeSet analytics_database/liquibase/baseline.xml::1::djantzen ran successfully in 567ms [updateDatabase] SEVERE 6/30/10 8:23 PM:liquibase: Could not release lock [updateDatabase] liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL UPDATE databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1 [updateDatabase] at liquibase.lockservice.LockService.releaseLock(LockService.java:147) [updateDatabase] at liquibase.Liquibase.update(Liquibase.java:107) [updateDatabase] at liquibase.integration.ant.DatabaseUpdateTask.execute(DatabaseUpdateTask.java:45) .... [updateDatabase] Caused by: liquibase.exception.DatabaseException: Error executing SQL UPDATE databasechangeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1 [updateDatabase] at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:62) [updateDatabase] at liquibase.executor.core.jdbc.JdbcExecutor.update(JdbcExecutor.java:218) [updateDatabase] at liquibase.executor.core.jdbc.JdbcExecutor.update(JdbcExecutor.java:195) [updateDatabase] at liquibase.lockservice.LockService.releaseLock(LockService.java:133) [updateDatabase] ... 32 more [updateDatabase] Caused by: org.postgresql.util.PSQLException: ERROR: relation "databasechangeloglock" does not exist [updateDatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)

The databasechangelog tables are both there after the changeset has completed.  This is using a nightly build from about 3 weeks ago.

Any ideas?
Thanks,
David

2

And the answer is … User Error.  My pg_dump SQL file sets the search path to a non-public schema at the end, so the table can’t be found.  Mystery solved.

3

Glad you found it.  Thanks for letting us know.

Nathan