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

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

MySQL Statements "Last Seen" column displays the incorrect time for all monitored MySQL databases
Descripción

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).
Resolución
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.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: 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

Historial del artículo:: Creado el: 1/17/2019
Última actualización: 5/7/2023

Título