MySQL Statements "Last Seen" column displays the incorrect time for all monitored MySQL databases (4314402)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

MySQL Statements "Last Seen" column displays the incorrect time for all monitored MySQL databases
Beschreibung

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).
Lösung
To fix the issue follow the steps below:
1. Upgrade to MySQL cartridge/agent version 5.9.3.10.20
2. 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
3. Save the changes
4. Deactivate and Activate the agent for the changes to take effect.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Titel