When running a SQL or database job against a MySQL database, the job remains Active for a while and then fails with Error 102, Status Distant=Waiting for Database.
The firewall does not show any request being sent across the network, but using a DBService agent to check connection object throws the error below:
U02022064 Communications link failure. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Setting the job report to "Add agent log" checked also returns the above U02022064in the PLOG
Release : 12.3
MySQL version in this case was 5.6.13
The last supported version of the MySQL Connector for this MySQL version is "mysql-connector-java-8.0.12.jar". Once this was put into the agent's /jdbc directory, the agent and jobs worked as expected.
Always make sure the MySQL Connector (jdbc driver) is compatible with MySQL database.