Liquibase忽略已经执行的更改集

Question

我试图从现有数据库（MySQL）中使用liquibase（3.5.5）。

>

C： /液化酶-3.5.5/liquibase。bat—驱动程序=com.mysql。jdbc。驱动程序^--classpath=C:/Libraries/mysql-connector-java-5.1.37-bin。jar^--changeLogFile=db。变更日志。xml^--url=“jdbc：mysql://vbalder/izalerting“^--用户名=*^--密码=*^generateChangeLog”

结果：Liquibase“generateChangeLog”成功

生成的db。变更日志。xml文件包含带有作者BGADEYNE（生成的）和id的变更集，其前缀为1533645947580-。e、 g.1533645947580-1

我使用了changelogSync命令来创建和填充DATABASECHANGELOG和DATABASECHANGELOGLOCK表。它们确实包含每个变更集的行。

C：/liquibase-3.5.5/liquibase-驱动程序=com.mysql.jdbc.驱动程序^-类路径=C：/库/mysql-connector-java-5.1.37-bin.jar^-更改日志文件=db.changelog.xml^-url="jdbc： mysql：//vbalder/izalerting"^-用户名=izalerting^-密码=alfa^ChangelogSync

结果：Liquibase“changelogSync”成功

添加了maven依赖项：

<dependency>
    <groupId>org.liquibase</groupId>
    <artifactId>liquibase-cdi</artifactId>
    <version>3.5.5</version>
</dependency>

添加了CLI组件：

@Dependent
public class LiquibaseProducer {
    @Resource(name="java:/izalerting")
    private DataSource dbConnection;

    @Produces @LiquibaseType
    public CDILiquibaseConfig createConfig() {
        CDILiquibaseConfig config = new CDILiquibaseConfig();
        config.setChangeLog("be/uzgent/iz/alerting/liquibase/db.changelog.xml");
        config.setContexts("non-legacy");
        return config;
    }

    @Produces @LiquibaseType
    public DataSource createDataSource() throws SQLException {
        return dbConnection;
    }

    @Produces @LiquibaseType
    public ResourceAccessor create() {
        return new ClassLoaderResourceAccessor(getClass().getClassLoader());
    }
}

将应用程序部署到WildFly时，我可以看到这一点

2018-08-07 15:07:09234错误[stderr]（MSC服务线程1-4）信息2018年7月8日下午3:07:liquibase。整合。cdi。CDILiquibase:Booting Liquibase 3.5.4 2018-08-07 15:07:09285 ERROR[stderr]（MSC服务线程1-4）INFO 8/7/18 3:07 PM:Liquibase:Successfully acquired change log lock 2018-08-07 15:07:09781 ERROR[stderr]（MSC服务线程1-4）INFO 8/7/18 3:07 PM:Liquibase:Reading from PUBLIC。DATABASECHANGELOG 2018-08-07 15:07:09814错误[stderr]（MSC服务线程1-4）严重2018年8月7日下午3:07：liquibase:db。变更日志。xml:db。变更日志。xml：：1533645947580-1：：BGADEYNE（生成）：更改集db。变更日志。xml：：1533645947580-1：：BGADEYNE（生成）失败。错误：表“ALERTRESULT”已存在；SQL语句：2018-08-07 15:07:09815 ERROR[stderr]（MSC service thread 1-4）CREATE TABLE PUBLIC。alertresult（triggerid VARCHAR（255）不为NULL，application VARCHAR（40）不为NULL，resultid INT不为NULL，subject VARCHAR（255），content CLOB，contenturl CLOB，executetime TIMESTAMP，html BOOLEAN DEFAULT TRUE不为NULL，alertlevel VARCHAR（20）DEFAULT‘INFO’不为NULL，closable BOOLEAN DEFAULT TRUE不为NULL，screenwidth INT，screenheight INT）[42101-173][失败的SQL:创建表PUBLIC.alertresult（triggerid VARCHAR（255）不为NULL，应用程序VARCHAR（40）不为NULL，resultid INT不为NULL，subject VARCHAR（255），content CLOB，contenturl CLOB，executetime TIMESTAMP，html BOOLEAN DEFAULT TRUE不为NULL，alertlevel VARCHAR（20）默认值“INFO”不为NULL，可关闭布尔值默认值TRUE不为NULL，screenwidth INT，screenheight INT）]2018-08-07 15:07:09816错误[stderr]（MSC服务线程1-4）信息8/7/18 3:07 PM:liquibase:db。变更日志。xml：：1533645947580-1：：BGADEYNE（已生成）：已成功释放更改日志锁

DATABASE CHANGELOG表包含每个change eSet的一行。

+------------------+-----------------------+-------------------+-----------+
|       # ID       |         AUTHOR        |      FILENAME     |  EXECTYPE |
+------------------+-----------------------+-------------------+-----------+
| 1533645947580-1  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-2  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-3  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-4  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-5  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-6  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-7  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-8  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-9  |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-10 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-11 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-12 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-13 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-14 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-15 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-16 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-17 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-18 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-19 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
| 1533645947580-20 |  BGADEYNE (generated) |  db.changelog.xml |  EXECUTED |
+------------------+-----------------------+-------------------+-----------+

有人知道我做错了什么吗？




Answer 1

而不是

@Resource(name="java:/izalerting")

我需要使用

@Resource(lookup="java:/izalerting")

狂野9