Geek Answers Handbook

No return to Liquibase.change.core.RawSQLChange created

The task is this: When you play in the maven team, it seems that the problem is found at https://liquibase.jira.com/browse/CORE-465 , but in 2009, "Can not reproduce" can be marked, I use one the .xml file is a linibase type with one changeSet, but many createTable, addPrimaryKey, rollback, addForeignKeyConstraint, this file always creates tables and your corresponding restrictions, but I roll back that this happened, I'm tired of searching for the Internet, I can’t find a solution problems, can you solve this problem? share with the community!

The plugin and command are used for maven in this case:

liquibase:rollback -Dliquibase.rollbackTag=payScript -PproductionPostgreSql

plugin on this

<plugin>
    <groupId>org.liquibase</groupId>
    <artifactId>liquibase-maven-plugin</artifactId>
    <version>3.4.1</version>
    <configuration>
        <changeLogFile>${basedir}/src/main/resources/changelogs/db.changelog-master.xml</changeLogFile>
        <driver>${driver}</driver>
        <url> ${host.db}</url>
        <username>${user.db}</username>
        <password>${password.db}</password>
    </configuration>
    <dependencies>
        <dependency>
            <groupId>org.liquibase</groupId>
            <artifactId>liquibase-core</artifactId>
            <version>3.4.1</version>
        </dependency>
    </dependencies>
</plugin>

this created a stack trace below

[ERROR] org.liquibase: Liquibase-maven-plugin: 3.4.1: rollback (default-cli) : Liquibase: liquidibase.exception.RollbackImpossibleException: Liquibase.change.core.RawSQLChange created → [ 1] org.apache.maven.lifecycle.LifecycleExecutionException: org.liquibase: Liquibase-maven-plugin: 3.4.1: rollback (default-cli) : Liquibase: liquidibase.exception.RollbackImpossibleException: Liquibase.change.core.RawSQLChange created     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:216)     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)      org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)      org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)      org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)      org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)     at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)     at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)     at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)      org.apache.maven.cli.MavenCli.execute(MavenCli.java:862)      org.apache.maven.cli.MavenCli.doMain(MavenCli.java:286)      org.apache.maven.cli.MavenCli.main(MavenCli.java:197)     at sun.reflect.NativeMethodAccessorImpl.invoke0 ( )     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)      java.lang.reflect.Method.invoke(Method.java:497)      org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)      org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)      org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)      org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356) : org.apache.maven.plugin.MojoExecutionException: Liquibase: liquidibase.exception.RollbackImpossibleException: Liquibase.change.core.RawSQLChange created     at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:398)     at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)     at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:208)     ... 20 : liquidibase.exception.RollbackFailedException: liquidibase.exception.RollbackImpossibleException: Liquibase.change.core.RawSQLChange created      linibase.changelog.ChangeSet.rollback(ChangeSet.java:648)      Liquibase.changelog.visitor.RollbackVisitor.visit(RollbackVisitor.java:39)      Liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)      . Liquibase.rollback(Liquibase.java:656)      org.liquibase.maven.plugins.LiquibaseRollback.performLiquibaseTask(LiquibaseRollback.java:121)     at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:394)     ... 22 : liquidibase.exception.RollbackImpossibleException: Liquibase.change.core.RawSQLChange created      Liquibase.change.AbstractChange.generateRollbackStatementsFromInverse(AbstractChange.java:424)      Liquibase.change.AbstractChange.generateRollbackStatements(AbstractChange.java:397)      Liquibase.database.AbstractJdbcDatabase.executeRollbackStatements(AbstractJdbcDatabase.java:1269)      Liquibase.changelog.ChangeSet.rollback(ChangeSet.java:634)     ... 27 [] [] [] . : [] [ 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

+4
1

. - , raw SQL. , - SQL, Liquibase , "" . - , , .

http://www.liquibase.org/documentation/changes/sql.html SQL. : http://www.liquibase.org/documentation/rollback.html

, :

, " " " ", , . , , changeSet. , , .

, SQL .

<changeSet author="liquibase-docs" id="sql-example">
    <sql dbms="h2, oracle"
            endDelimiter="\nGO"
            splitStatements="true"
            stripComments="true">insert into person (name) values ('Bob')
        <comment>What about Bob?</comment>
    </sql>
    <rollback>
        delete from person where name='Bob';
    </rollback>
</changeSet>

, - , , , , , liquibase update, , , , "", "".

+9

More articles:


All Articles