Running "flyway check -code" got "ERROR: Flyway SqlFluff code analysis requires ... and SqlFluff"

Jose_Goncalves

I'm using the docker image redgate/flyway:10.20.0 (community edition).
And I'm trying execute the command check but I got an error:

<div>[xxx flyway]$ flyway&nbsp;check -code</div><div>Flyway Community Edition 10.20.0 by Redgate</div><div><br></div><div>See release notes here: https://rd.gt/416ObMi</div><div>A Flyway report has been generated here: /flyway/report.html</div><div>ERROR: Flyway SqlFluff code analysis requires Python 3, pip and SqlFluff version 1.2.1 or greater, preferably version 3.0.7</div><div>Run 'pip install sqlfluff==3.0.7' to install SqlFluff if you would like to access this function</div><div>[padmin@dap-el8-utils flyway]$ ./run.sh sh</div><div># flyway check -code</div><div>Flyway Community Edition 10.20.0 by Redgate</div><div><br></div><div>See release notes here: https://rd.gt/416ObMi</div><div>A Flyway report has been generated here: /flyway/report.html</div><div>ERROR: Flyway SqlFluff code analysis requires Python 3, pip and SqlFluff version 1.2.1 or greater, preferably version 3.0.7</div><div>Run 'pip install sqlfluff==3.0.7' to install SqlFluff if you would like to access this function</div>

Why the official docker image do not have all the required sw to run check command ?

AlistairW

Hmm - it is in there but we updated the version a couple of weeks ago and I wonder if something has changed in SQLFluff to break the integration.
If it is possible, I'd use an older Flyway version while we investigate - redgate/flyway:10.19.0 worked for me

AlistairW

We've fixed it up now, we changed how we put together the docker image and accidentally skipped a test but that has all been sorted out now.
It's fixed in 10.20.0 (we can update existing versions) so you can pull it again and it should work.
Thanks for letting us know !