Nothing changed in the code or with drivers from 3.7.0 to 3.7.1. I confirmed this in the changelog, but also consulting the lead engineer over the database frameworks. The current database nodes are in maintenance mode essentially, and the new DB nodes are the only ones being actively developed on. Once they are GA (later this year) we will provide a migration utility to convert workflows over.
That doesn’t help today, but wanted to get that info out there because I believe either this is an environment issue or perhaps a corrupted install.
Few things to try
- Add the “-clean” flag to your knime.ini file to clean up the eclipse environment. Just add it right before the “-vmargs” argument.
- When you mentioned using another client/tool to connect, was this a JDBC tool or the mysql client tools?
- Check the OS’s firewall or Antivirus to see if the connection is getting blocked. The is fairly common on Windows.
- Download and install a fresh 3.7.1 instance when you have time, and see if that works.
The fact that one instance works and another doesn’t makes me think it’s that instance. Although rare, I have run into cases where an upgrade seemed to finish successfully, but was corrupted for some reason. In those case I suggest backing your workflow repository up, saving your knime.ini file, and setting up a new instance. I would suggest running through a few of the steps above first, reinstall is always my last suggestion.