mysql - 运行 Liquibase : Unknown Reason 时出现意外错误

Question

尝试针对我的产品数据库运行时，出现 java.lang.NullPointerException 错误。适用于我的测试数据库。

我升级到3.3.5，还是一样的问题。

有什么建议吗？

调试输出如下。

---

DEBUG 3/06/15 10:18 PM: liquibase: Connected to *******@******@jdbc:mysql://**********.hostedresource.com:3306/******
DEBUG 3/06/15 10:18 PM: liquibase: Setting auto commit to false from true
DEBUG 3/06/15 10:18 PM: liquibase: Computed checksum for 1433333922425 as 4718a9188c6a346602e81ac36af75247
DEBUG 3/06/15 10:18 PM: liquibase: Executing QUERY database command: select count(*) from skidreamzprd.DATABASECHANGELOGLOCK
DEBUG 3/06/15 10:18 PM: liquibase: Executing QUERY database command: SELECT LOCKED FROM skidreamzprd.DATABASECHANGELOGLOCK WHERE ID=1
DEBUG 3/06/15 10:18 PM: liquibase: Lock Database
DEBUG 3/06/15 10:18 PM: liquibase: Executing UPDATE database command: UPDATE skidreamzprd.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'fe80:0:0:0:604c:c4ff:fe02:18f3%awdl0 (fe80:0:0:0:604c:c4ff:fe02:18f3%awdl0)', LOCKGRANTED = '2015-06-03 22:18:42.983' WHERE ID = 1 AND LOCKED = 0
INFO 3/06/15 10:18 PM: liquibase: Successfully acquired change log lock
DEBUG 3/06/15 10:18 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 3/06/15 10:18 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 3/06/15 10:18 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 3/06/15 10:18 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 3/06/15 10:18 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 3/06/15 10:18 PM: liquibase: Release Database Lock
DEBUG 3/06/15 10:18 PM: liquibase: Executing UPDATE database command: UPDATE skidreamzprd.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1
INFO 3/06/15 10:18 PM: liquibase: Successfully released change log lock
Unexpected error running Liquibase: Unknown Reason

SEVERE 3/06/15 10:18 PM: liquibase: Unknown Reason
java.lang.NullPointerException
at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:103)
    at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:786)
    at liquibase.Liquibase.update(Liquibase.java:194)
    at liquibase.integration.commandline.Main.doMigration(Main.java:1044)
    at liquibase.integration.commandline.Main.run(Main.java:175)
    at liquibase.integration.commandline.Main.main(Main.java:94)


For more information, use the --logLevel flag

Answer 1

在@Jens 的帮助下，我们追踪到此异常是由产品数据库中损坏的 VIEW 引起的。与 DATABASECHANGELOG 无关。修复 View 然后允许 liquibase 正常运行。在这种情况下，liquibase 容易受到现有应用程序数据库稳定性的影响。