A new topic, 'Errors running a SQL baseline file on LQ 2.0RC2 nightly build',
has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=563.new#new
The text of the topic is shown below:
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:
Code:
<changeSet id="1" author="djantzen">
<preConditions onFail="MARK_RAN">
<not>
<tableExists schemaName="public"
tableName="dates"></tableExists>
</not>
</preConditions>
<sqlFile path="analytics_database/liquibase/baseline.sql"
splitStatements="false"/>
</changeSet>
It appears that all of the SQL runs, however it errors out when trying to
release the lock:
Code:
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
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user
