MySQL agent fails to collect data when server time zone value is unrecognized or represents more than one time zone values

Problem

MySQL agent is not able to collect data when server time zone value is unrecognized or represents more than one time zones.

The following exception is displayed in logs: CANDLE HOME/logs/kse_instance_name_trace0.log:

The server time zone value 'CDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support.

Where:

instance_name is the agent instance name.
CANDLE_HOME is the agent installation directory.

Symptom

No data is displayed on dashboard for MySQL agent.

Cause

The server time zone value is unrecognized or represents more than one time zones.

Solution

Upgrade MySQL agent to the latest version such as 08.21.03.00.