Hi all,
I have had the drains up and solved this problem, so I just wanted to
document it here in case anybody else hits the same problem so that
hopefully you wont have to waste the same amount of time figuring out
what is going on and fixing it.
To recap, the main symptom was that I was unable to load csv records
into MySQL and got an error "table not found in information_schema" when
using PutDatabaseRecord, from NiFi 1.7.1, to load records into an
existing table in MySQL 5.7.23. This is the root cause message at the
end of a long Java (exception) stack trace, most of which just adds
verbiage to the error.
Checking from within MySQL, the table did exist, and was in
information_schema.tables in the normal way, so all was fine there, and
I could load data from a bit of noddy Java code that I wrote, so MySQL
and Connector/J were both working as expected.
Anyway, to cut a long story short, I found that there were two problems
interacting - a major incompatibility between NiFi 1.7.1 and the current
version (v8.0.12) of MySQL Connector/J, and compounding this, another
problem with NiFi and the default OpenJDK that is installed on the Linux
platform that I am using (Ubuntu 18.04).
If you get this problem, you need to replace both of them at the same
time and the solution is to make sure that you use both the Oracle Java
8 JDK and mysql-connector-java-5.1.x.jar when you need to access MySQL
from NiFi 1.71
Thanks to all who sent me helpful messages.
Rick
