New Topic: rollback fails for unknown reason

View: New views
1 Messages — Rating Filter:   Alert me  

New Topic: rollback fails for unknown reason

by LiquiBase Community Forum :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

A new topic, 'rollback fails for unknown reason', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=198.new#new

The text of the topic is shown below:

I tried this once with 1.9.5, and once with 2.0rc1. 2.0rc1 gives a lot more information, but the result is the same.

I created a new, empty database; I wanted all logs to be done through liquibase, back to the first creation. (It's an early phase, for at least a couple of databases I could do that.)

If you look below, you see that it fails generating the SQL for the rollback script. I'm fairly new to this - am I missing something basic?

My script creates a table with two columns (for 2.0rc1):
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
         http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
 
    <changeSet id="baseline" author="me">
        <createTable tableName="baseline">
           <column name="member_id" type="int">
              <constraints primaryKey="true" nullable="false"/>
           </column>
            <column name="email" type="varchar(250)">
                <constraints unique="true" nullable="false"/>
            </column>
        </createTable>
    </changeSet>
</databaseChangeLog>


With that, I run it and here's what I see:
F:Documents and SettingsmeMy Documentsprojectsliquibase-2.0-rc1>liquibase --driver=com.mysql.jdbc.Driver --changeLogFile=test.xml --url="jdbc:mysql://192.168.3.101/test" --username=utest --password="test" --logLevel="debug" update
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
DEBUG 10/17/09 12:15 AM:liquibase: Create Database Lock Table
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
DEBUG 10/17/09 12:15 AM:liquibase: Created database lock table with name: `DATABASECHANGELOGLOCK`
DEBUG 10/17/09 12:15 AM:liquibase: Lock Database
INFO 10/17/09 12:15 AM:liquibase: Successfully acquired change log lock
DEBUG 10/17/09 12:15 AM:liquibase: Create Database Change Log Table
INFO 10/17/09 12:15 AM:liquibase: Creating database history table with name: `DATABASECHANGELOG`
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
INFO 10/17/09 12:15 AM:liquibase: Reading from `DATABASECHANGELOG`
DEBUG 10/17/09 12:15 AM:liquibase: Running Changeset:test.xml::baseline::me::(Checksum: 2:2a3d7bbf13eca539f5a409469c2cf5b2)
DEBUG 10/17/09 12:15 AM:liquibase: Changeset test.xml::baseline::me::(Checksum: 2:2a3d7bbf13eca539f5a409469c2cf5b2)
DEBUG 10/17/09 12:15 AM:liquibase: Reading ChangeSet: test.xml::baseline::me::(Checksum: 2:2a3d7bbf13eca539f5a409469c2cf5b2)
DEBUG 10/17/09 12:15 AM:liquibase: Executing Statement: liquibase.statement.core.CreateTableStatement@19b04e2
DEBUG 10/17/09 12:15 AM:liquibase: Table baseline created
INFO 10/17/09 12:15 AM:liquibase: ChangeSet test.xml::baseline::me ran successfully in 0ms
DEBUG 10/17/09 12:15 AM:liquibase: Release Database Lock
INFO 10/17/09 12:15 AM:liquibase: Successfully released change log lock
LiquiBase Update Successful

F:Documents and SettingsmeMy Documentsprojectsliquibase-2.0-rc1>liquibase --driver=com.mysql.jdbc.Driver --changeLogFile=test.xml --url="jdbc:mysql://192.168.3.101/test" --username=utest --password="test" --logLevel="debug" rollbacksql
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateDatabase: Missing dependency org/hibernate/cfg/Configuration
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.database.core.HibernateGenericDialect: Missing dependency org/hibernate/dialect/Dialect
WARNING 10/17/09 12:15 AM:liquibase: Could not configure extension class liquibase.snapshot.core.HibernateDatabaseSnapshotGenerator: Missing dependency org/hibernate/dialect/Dialect
LiquiBase Update Failed: Unknown Reason
SEVERE 10/17/09 12:15 AM:liquibase: Unknown Reason
java.util.NoSuchElementException
        at java.util.HashMap$HashIterator.nextEntry(Unknown Source)
        at java.util.HashMap$KeyIterator.next(Unknown Source)
        at liquibase.integration.commandline.Main.doMigration(Main.java:696)
        at liquibase.integration.commandline.Main.main(Main.java:105)

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.
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user