MySQL Statements "Last Seen" column displays the incorrect time for all monitored MySQL databases
説明
Within dashboard view MySQL DB | Statements, the "Last Seen" column displays the incorrect time for all monitored MySQL databases. It always displays the time as in the future (from a timezone that does not exist). Everything within the MySQL dashboards are displaying correctly apart from this particular column. The database itself is running in CST (Central Standard Time).
対策
To fix the issue follow the steps below:
Upgrade to MySQL cartridge/agent version 5.9.3.10.20
Within the agent properties of the problematic DB agent, change the "Server Time Zone Override" to the required timezone. For example, as this example is located in CST, "CST" would need to be defined in this text field
Save the changes
Deactivate and Activate the agent for the changes to take effect.