get "Failed to parse the response from the flyway CLI as json." after upgrade to 7.3.5

nutmix2

I just "upgraded" flyway desktop from 7.2.4 to 7.3.5 and it has bricked my installation.

If I open any existing project I get "Failed to parse the response from the flyway CLI as json."

If I try to create a new project, I get "Failed to parse the response from the flyway CLI as json."

There is nothing useful in the log files (it doesnt say more about the problem json).

I cant even find any json files in the entire project structure.

I also tried repairing, uninstalling and reinstalling, same error.

If just rebooted the PC, and now I get a slightly different error when I try to open project or create a new project:

Failed to parse the response from the flyway CLI as json.: Failed to parse result 'Error occurred during initialization of VMFailed setting boot class path.' as json: Unexpected token 'E', "Error occu"... is not valid JSON
Any ideas how to fix?

Windows 10.

nutmix2

This has highlighted a significant risk to using flyway - there is no way to download previous working versions, you can ohly get the latest.  If the latest is broken, you cant revert.

AlistairW

Well you can't downgrade through the Flyway Desktop UI but the installers are all available - for Windows they are here: https://download.red-gate.com/installers/Flyway_Desktop/
I've tried creating a project with the latest version (7.3.5) and it works for me so there is something else going on in your setup. How far did you get creating a new project before it failed ? We could use some reproduction steps.
JSON is used to communicate between the CLI and Desktop so it won't appear as a file anywhere.

nutmix2

Hi, the error occurs right after you click on new project, or after you try to load an existing project.

The issue looks java related. I havent changed anything on my pc other than to install the new version of FW.  My java version is:

openjdk version "1.8.0_362"

OpenJDK Runtime Environment (Zulu 8.68.0.21-CA-win64) (build 1.8.0_362-b09)

OpenJDK 64-Bit Server VM (Zulu 8.68.0.21-CA-win64) (build 25.362-b09, mixed mode)

nutmix2

Thanks for the link to old versions.  Unfortunately, there is no version information in that link.  Any idea how I would find out which of the prev. versions are 472.4?

AlistairW

The release notes are here - https://documentation.red-gate.com/fd/flyway-desktop-7-release-notes-229116743.html which will let you match date with version.
I'm curious about the java version - we ship a JRE with Flyway so Flyway should use that. It's also Java 17 and not the Java 8 that you are reporting.

<div>java --version</div><div>openjdk 11.0.17 2022-10-18</div><div>OpenJDK Runtime Environment Temurin-11.0.17+8 (build 11.0.17+8)</div><div>OpenJDK 64-Bit Server VM Temurin-11.0.17+8 (build 11.0.17+8, mixed mode)</div>

One thing to try is to drop to the cli within desktop (there is a button labelled 'open in console') and run

flyway info

and see what it does

 

nutmix

FYI, we solved the issue by uninstalling 7.3.6 and installing 7.2.0. Now we can open existing projects and new projects without java errors.

Interestingly, if I run the command  console and type "flyway info" I just get:

Flyway community edition 10.11.1