Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Undo + ErrorOverride: Throws exception but fails to record in schema_history table #2567

Closed
KiruthikaSS opened this issue Nov 15, 2019 · 0 comments

Comments

@KiruthikaSS
Copy link

@KiruthikaSS KiruthikaSS commented Nov 15, 2019

Which version and edition of Flyway are you using?

Flyway pro 6.0.8

If this is not the latest version, can you reproduce the issue with the latest one as well?

(Many bugs are fixed in newer releases and upgrading will often resolve the issue)

yes

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Java API

Which database are you using (type & version)?

Oracle 12C

Which operating system are you using?

Windows 10

What did you do?

(Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)
Error override configuration,
flyway.errorOverrides=99999:17110:E

Say, U4__REL.sql includes a package, which has compilation failure

#1) Undo command
a) Throws flyway exception as expected, since we override warning as error
b) Does not record undo and success = 0 in flyway_schema_history table. ie., I could see only until V4__REL in flyway_schema_history

What did you expect to see?

Since its a undo failure, a record in flyway_schema_history table with success = 0

What did you see instead?

No undo record is found in flyway_schema_history , in case of errorOverride failure
PS: The behaviour is working as expected for 'migrate' command

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants