jdbc_response probe crashes after a new MySQL profile is created

Document ID : KB000117100
Last Modified Date : 08/10/2018
Show Technical Document Details
Issue:
Fresh install of the jdbc_response probe is configured with a new MySQL connection.

The Database URL field is updated as follows:
 
jdbc:mysql://<server name>/<database name> 

The connection is tested and reports OK.

After creating a new profile with a query, the query is also tested and works fine however the probe restarts after the configuration is saved and never works again.

The following error can be seen in the probe log:
 
Controller: Max. restarts reached for probe 'jdbc_response' (command = <startup java>) 
Environment:
jdbc_response 1.24 
MySQL 5.5 
Cause:
This issue occurs when the MySQL port is not specified in the Database URL.
Resolution:
In order to avoid this problem create the MySQL connection with the following format for the Database URL:

jdbc:mysql://<server name>:<port number>/<database name>