liquibase.exception.DatabaseException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • After updating from 3.3.5 to 3.4.0 I'm getting this with a mysql database ./liquibase status Migrating DEVELOPMENT schema... Unexpected error running Liquibase: Unknown column 'LABELS' in 'field list' failed. [fsousa@nostradamus liquibase]$ (feature/liquibase-3.4) ./liquibase --logLevel=DEBUG status Migrating DEVELOPMENT schema... DEBUG 25-06-2015 9:37: liquibase: Connected to root@localhost@jdbc:mysql://localhost:3306/push DEBUG 25-06-2015 9:37: liquibase: Setting auto commit to false from true DEBUG 25-06-2015 9:37: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 25-06-2015 9:37: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Opening jar:file:/Users/fsousa/Projects/egoi/push/liquibase/liquibase.jar!/liquibase/parser/core/xml/dbchangelog-3.3.xsd as liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 25-06-2015 9:37: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Opening jar:file:/Users/fsousa/Projects/egoi/push/liquibase/liquibase.jar!/liquibase/parser/core/xml/dbchangelog-3.3.xsd as liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 25-06-2015 9:37: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Opening jar:file:/Users/fsousa/Projects/egoi/push/liquibase/liquibase.jar!/liquibase/parser/core/xml/dbchangelog-3.3.xsd as liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Executing QUERY database command: select count(*) from push.DATABASECHANGELOG INFO 25-06-2015 9:37: liquibase: Reading from push.DATABASECHANGELOG DEBUG 25-06-2015 9:37: liquibase: Executing QUERY database command: SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE,LABELS,CONTEXTS FROM push.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC Unexpected error running Liquibase: Unknown column 'LABELS' in 'field list' SEVERE 25-06-2015 9:37: liquibase: Unknown column 'LABELS' in 'field list' liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE,LABELS,CONTEXTS FROM push.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Unknown column 'LABELS' in 'field list' at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:135) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:143) at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:209) at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:203) at liquibase.changelog.StandardChangeLogHistoryService.queryDatabaseChangeLogTable(StandardChangeLogHistoryService.java:267) at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:226) at liquibase.database.AbstractJdbcDatabase.getRanChangeSetList(AbstractJdbcDatabase.java:1091) at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:197) at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1134) at liquibase.Liquibase.reportStatus(Liquibase.java:1188) at liquibase.integration.commandline.Main.doMigration(Main.java:1056) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'LABELS' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446) at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:352) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 13 more For more information, use the --logLevel flag failed. With Oracle complains about a missing CONTEXTS.
    via by Filipe Sousa,
  • After updating from 3.3.5 to 3.4.0 I'm getting this with a mysql database ./liquibase status Migrating DEVELOPMENT schema... Unexpected error running Liquibase: Unknown column 'LABELS' in 'field list' failed. [fsousa@nostradamus liquibase]$ (feature/liquibase-3.4) ./liquibase --logLevel=DEBUG status Migrating DEVELOPMENT schema... DEBUG 25-06-2015 9:37: liquibase: Connected to root@localhost@jdbc:mysql://localhost:3306/push DEBUG 25-06-2015 9:37: liquibase: Setting auto commit to false from true DEBUG 25-06-2015 9:37: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 25-06-2015 9:37: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Opening jar:file:/Users/fsousa/Projects/egoi/push/liquibase/liquibase.jar!/liquibase/parser/core/xml/dbchangelog-3.3.xsd as liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 25-06-2015 9:37: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Opening jar:file:/Users/fsousa/Projects/egoi/push/liquibase/liquibase.jar!/liquibase/parser/core/xml/dbchangelog-3.3.xsd as liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 25-06-2015 9:37: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Opening jar:file:/Users/fsousa/Projects/egoi/push/liquibase/liquibase.jar!/liquibase/parser/core/xml/dbchangelog-3.3.xsd as liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 25-06-2015 9:37: liquibase: Executing QUERY database command: select count(*) from push.DATABASECHANGELOG INFO 25-06-2015 9:37: liquibase: Reading from push.DATABASECHANGELOG DEBUG 25-06-2015 9:37: liquibase: Executing QUERY database command: SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE,LABELS,CONTEXTS FROM push.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC Unexpected error running Liquibase: Unknown column 'LABELS' in 'field list' SEVERE 25-06-2015 9:37: liquibase: Unknown column 'LABELS' in 'field list' liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE,LABELS,CONTEXTS FROM push.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Unknown column 'LABELS' in 'field list' at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:135) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:143) at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:209) at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:203) at liquibase.changelog.StandardChangeLogHistoryService.queryDatabaseChangeLogTable(StandardChangeLogHistoryService.java:267) at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:226) at liquibase.database.AbstractJdbcDatabase.getRanChangeSetList(AbstractJdbcDatabase.java:1091) at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:197) at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1134) at liquibase.Liquibase.reportStatus(Liquibase.java:1188) at liquibase.integration.commandline.Main.doMigration(Main.java:1056) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'LABELS' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446) at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:352) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 13 more For more information, use the --logLevel flag failed. With Oracle complains about a missing CONTEXTS.
    via by Filipe Sousa,
  • 运行时出现异常
    via GitHub by gewanbo
    ,
  • LogBlock Updater Error
    via GitHub by liquidox
    ,
  • SQL Query throws exception
    via Stack Overflow by TacoVox
    ,
    • liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE,LABELS,CONTEXTS FROM push.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: Unknown column 'LABELS' in 'field list' at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:135) at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:143) at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:209) at liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:203) at liquibase.changelog.StandardChangeLogHistoryService.queryDatabaseChangeLogTable(StandardChangeLogHistoryService.java:267) at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:226) at liquibase.database.AbstractJdbcDatabase.getRanChangeSetList(AbstractJdbcDatabase.java:1091) at liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:197) at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1134) at liquibase.Liquibase.reportStatus(Liquibase.java:1188) at liquibase.integration.commandline.Main.doMigration(Main.java:1056) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'LABELS' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446) at liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:352) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 13 more

    Users with the same issue

    Kialandei
    40 times, last one,
    jstrayer
    4 times, last one,
    linxiaolong
    51 times, last one,
    mortalman7
    4 times, last one,
    Unknown visitor1 times, last one,
    115 more bugmates