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'

JIRA | Filipe Sousa | 1 year ago
  1. 0

    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.

    JIRA | 1 year ago | Filipe Sousa
    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'
  2. 0

    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.

    JIRA | 1 year ago | Filipe Sousa
    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'
  3. 0

    Java JDBC - PreparedStatement syntax error

    Stack Overflow | 1 year ago | user3767784
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? ORDER BY RAND() LIMIT 1' at line 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while editing some fields in Squirrel

    squirrel-sql | 6 years ago | *anonymous
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&test='&test'' at line 1
  6. 0

    运行时出现异常

    GitHub | 3 years ago | gewanbo
    java.lang.ExceptionInInitializerError

  1. jstrayer 4 times, last 2 months ago
  2. linxiaolong 1 times, last 4 months ago
  3. mortalman7 4 times, last 5 months ago
  4. bpbhat77 22 times, last 7 months ago
  5. Kialandei 1 times, last 1 week ago
27 more registered users
65 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown column 'LABELS' in 'field list'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
    4 frames
  3. MySQL jdbc
    StatementImpl.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
    2. com.mysql.jdbc.Util.getInstance(Util.java:372)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)
    10. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
    10 frames
  4. Liquibase Core
    Main.main
    1. liquibase.executor.jvm.JdbcExecutor$QueryStatementCallback.doInStatement(JdbcExecutor.java:352)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:135)
    4. liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:143)
    5. liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:209)
    6. liquibase.executor.jvm.JdbcExecutor.queryForList(JdbcExecutor.java:203)
    7. liquibase.changelog.StandardChangeLogHistoryService.queryDatabaseChangeLogTable(StandardChangeLogHistoryService.java:267)
    8. liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:226)
    9. liquibase.database.AbstractJdbcDatabase.getRanChangeSetList(AbstractJdbcDatabase.java:1091)
    10. liquibase.changelog.DatabaseChangeLog.validate(DatabaseChangeLog.java:197)
    11. liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1134)
    12. liquibase.Liquibase.reportStatus(Liquibase.java:1188)
    13. liquibase.integration.commandline.Main.doMigration(Main.java:1056)
    14. liquibase.integration.commandline.Main.run(Main.java:180)
    15. liquibase.integration.commandline.Main.main(Main.java:99)
    15 frames