I am very new to liquibase. When trying to do any commands I get stack trace errors. I am connecting to a postgres database. An example command is below, but the same failure happens on others as well. I just don’t know how to track down what is causing this. Any help to diagnose is appreciated. I had to hide many of the settings though due to confidentiality
jar is lib/postgresql-9.1-902.jdbc4.jar
./liquibase --driver=org.postgresql.Driver <br> --url=jdbc:postgresql://serverhidden/dbhidden <br> --username=userhidden <br> --password=passwdhidden <br> --logLevel=debug <br> --changeLogFile=db_changelog.xml <br> generateChangeLog
output is
…
DEBUG 7/19/12 11:37 AM:liquibase: Could not find table or view Ivies_total for column total
DEBUG 7/19/12 11:37 AM:liquibase: Could not find table or view Ivies_zipCode for column zipCode
Liquibase Update Failed: ERROR: column “id_member” does not exist
Position: 8
SEVERE 7/19/12 11:37 AM:liquibase: ERROR: column “id_member” does not exist
Position: 8
liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: column “id_member” does not exist
Position: 8
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251)
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:760)
at liquibase.integration.commandline.Main.main(Main.java:134)
Caused by: org.postgresql.util.PSQLException: ERROR: column “id_member” does not exist
Position: 8
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369)
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244)
… 5 more