Bug #31656 time information on graphs does not match interval specification
Submitted: 17 Oct 2007 2:02 Modified: 24 Jul 2008 14:09
Reporter: Monty Taylor Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:1.2 OS:Any
Assigned to: Mark Matthews CPU Architecture:Any
Tags: mer 121

[17 Oct 2007 2:02] Monty Taylor
Description:
The service manager and agents are both on machines in new york set to EDT but the web interface is set to display Australian EST and my local PC is set to PST. 
In order to get a graph from 9 - 9:30, I had to select 19:30 - 20:00.

How to repeat:
Set up some servers with the above time zones and then try to zoom in on a graph.

Suggested fix:
The time zones should be consistent. Since the web interface is translating the display of the times for the graph, the intervals input should be of the same time zone. Or else the graph display should be set to translate to the same timezone that the interval selection widget it going to want as input. The absolute time-value correctness here is much less interesting to me than the consistency in the different areas.
[17 Oct 2007 16:25] Andrew Cwik
I was able to reproduce this using 1.2.0.7757. I set the dashboard to eastern time and pointed it to an agent and service manager physically located on a box in Pacific time.  The default interval was 12:00 - 24:00.  When I selected 15:00 - 15:30 I got 18:00 - 18:30.  To get 15:00 - 15:30 I had to select 12:00 - 12:30.    I was not able to reproduce this bug using 1.1.1.5780.
[12 May 2008 19:10] Joshua Ganderson
Don't believe this is still an issue or would have heard more about it in more recent versions.
[19 Jun 2008 21:49] Marcos Palacios
Verified fixed in 2.0.0.6068.
The graph's displayed time is the local time of the Dashboard corresponding to the requested time on the monitored server.
[24 Jul 2008 14:09] Tony Bedford
An entry was added to the 2.0 changelog:

The graph's displayed time was not the local time of the Dashboard corresponding to the requested time on the monitored server.