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.

Sign up for GitHub

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

Jump to bottom

Flyway Java API is spamming log with "0 rows affected" #3132

Closed
wparuch opened this issue Apr 2, 2021 · 4 comments
Closed

Flyway Java API is spamming log with "0 rows affected" #3132

wparuch opened this issue Apr 2, 2021 · 4 comments
Labels
t: task
Milestone
Flyway 7.x

Comments

@wparuch
Copy link

wparuch commented Apr 2, 2021

Which version and edition of Flyway are you using?

7.7.2

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)

The problem was not occuring on 6.5.0

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

Java API

Which database are you using? (Type & version)

DB2 11.5.5

Which operating system are you using?

MacOs

What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)

I updated flyway recently from 6.5.0 to 7.7.2 and I run multiple migrations. One of them contains multiple ALTER TABLE and DROP PERMISSION commands.

In the current version log is spammed with rows affected logged at INFO level:

13:52:45.142 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.144 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.152 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.154 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.163 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.165 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.176 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.179 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.185 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.187 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.193 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.194 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.205 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.207 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.218 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.220 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.226 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.227 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.239 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.242 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.248 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.250 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.261 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.263 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.272 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.274 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.283 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.285 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.293 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.296 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.310 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.312 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.323 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.325 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.336 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.338 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.345 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.347 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.355 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.361 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.370 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.372 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.380 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.381 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.387 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.390 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.399 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.401 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.410 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.412 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.418 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.420 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.427 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.429 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.436 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.437 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.443 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.445 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.450 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.452 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.459 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.460 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.467 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.469 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.475 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.477 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.488 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.489 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.495 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.496 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.506 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.508 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.517 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.519 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.524 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.526 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.536 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.538 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.547 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.549 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.557 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.559 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.568 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.570 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.582 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.583 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.589 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.591 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.596 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.598 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.608 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.609 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.615 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.617 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.623 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.625 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.631 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.633 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.639 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.641 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.652 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.653 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.659 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.661 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.666 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.668 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.679 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.681 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.687 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.689 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.694 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.696 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.711 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.722 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.733 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.744 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.755 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.767 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.774 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.781 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.791 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.803 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.812 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.821 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.828 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.835 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.842 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.850 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.857 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.867 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.877 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.891 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.902 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.913 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.922 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.929 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.940 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected
13:52:45.952 [main] INFO  o.f.c.i.s.DefaultSqlScriptExecutor - 0 rows affected

This was not a case in 6.5.0.

What did you expect to see?

I would expect to see rows affected only when there would be more than 0 rows affected, rest should be logged on DEBUG level.

What did you see instead?

Every entry at INFO level.
@DoodleBobBuffPants DoodleBobBuffPants added this to the Flyway 7.x milestone Apr 8, 2021
@DoodleBobBuffPants DoodleBobBuffPants mentioned this issue Apr 12, 2021
Closed
@yaumi123
Copy link

Maybe we could add a configuration field to enable/disable it?

@esauser
Copy link

esauser commented Apr 28, 2021

This is also very spammy for us, particularly in our tests where the inserts are always greater than 0 rows. The output for the tests is essentially unreadable with this feature.

@Lucas3oo
Copy link

Lucas3oo commented May 2, 2021

Please add a config settings for those that want to see this info printed.
Now it is too spammy

@esauser
Copy link

esauser commented May 3, 2021

FWIW a poor workaround I found is to add a beforeMigration script that to SET NOCOUNT ON.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
t: task
Projects
None yet
Milestone
Flyway 7.x
Development

No branches or pull requests
5 participants
@wparuch @Lucas3oo @DoodleBobBuffPants @yaumi123 @esauser