Error using generateChangeLog on existing database

General Discussion
1

Hi

I’m really interested in using this product. We have an existing database in mysql, but when i run the generateChangeLog command, an error is produced. Any help would be appreciated. I’ve attached the mysqldump output without the data.

marc@betty:~/Downloads/liquibase-all$ ./liquibase --driver=com.mysql.jdbc.Driver --classpath=/home/marc/.m2/repository/mysql/mysql-connector-java/3.0.11/mysql-connector-java-3.0.11.jar --url=“jdbc:mysql://127.0.0.1:3306/oscar_eyeform” --username= --password= --logLevel=debug generateChangeLog
Liquibase Home is not set.
Liquibase Home: /home/marc/Downloads/liquibase-all
DEBUG 4/13/11 6:33 PM:liquibase: Unable to load/access Apache Derby driver class org.apache.derby.tools.sysinfo to check version: org.apache.derby.tools.sysinfo
DEBUG 4/13/11 6:33 PM:liquibase: Connected to root@localhost@jdbc:mysql://127.0.0.1:3306/oscar_eyeform
DEBUG 4/13/11 6:33 PM:liquibase: Reading tables for root@localhost @ jdbc:mysql://127.0.0.1:3306/oscar_eyeform …
INFO 4/13/11 6:33 PM:liquibase: Reading tables for root@localhost @ jdbc:mysql://127.0.0.1:3306/oscar_eyeform …
DEBUG 4/13/11 6:33 PM:liquibase: Reading views for root@localhost @ jdbc:mysql://127.0.0.1:3306/oscar_eyeform …
INFO 4/13/11 6:33 PM:liquibase: Reading views for root@localhost @ jdbc:mysql://127.0.0.1:3306/oscar_eyeform …
DEBUG 4/13/11 6:33 PM:liquibase: Executing QUERY database command: SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = ‘CdsClientForm’ AND TABLE_SCHEMA='oscar_eyeform’
Liquibase Update Failed: Empty result set, expected one row
SEVERE 4/13/11 6:33 PM:liquibase: Empty result set, expected one row
liquibase.exception.DatabaseException: Error getting jdbc:mysql://127.0.0.1:3306/oscar_eyeform view with liquibase.statement.core.GetViewDefinitionStatement@8238f4
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readView(JdbcDatabaseSnapshotGenerator.java:168)
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readViews(JdbcDatabaseSnapshotGenerator.java:304)
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:241)
    at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69)
    at liquibase.diff.Diff.compare(Diff.java:63)
    at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:145)
    at liquibase.integration.commandline.Main.doMigration(Main.java:624)
    at liquibase.integration.commandline.Main.main(Main.java:116)
Caused by: liquibase.exception.DatabaseException: Empty result set, expected one row
    at liquibase.util.JdbcUtils.requiredSingleResult(JdbcUtils.java:124)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:160)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:168)
    at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:164)
    at liquibase.database.AbstractDatabase.getViewDefinition(AbstractDatabase.java:680)
    at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readView(JdbcDatabaseSnapshotGenerator.java:166)
    … 7 more

Thanks.

2

Thanks for the reply…no the command does not return any result

mysql> SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = ‘CdsClientForm’ AND TABLE_SCHEMA=‘oscar_eyeform’;
Empty set (0.02 sec)

There’s no views associated with this table…or for that matter, with any of my tables.

3

I’ve done a bit of looking and can’t tell off hand why you are getting the error. If you run

Nathan