Graph Skipping first section of the graph when running Grafana 5.3.1 on Raspberry Pi

[cdewar]

When I create a dashboard on my laptop (linux) It works perfectly with no errors on the graph and the graph shows the full information as well as i can change the time range to show any ranges from 1 hour to 1 day.

But when I run the same dashboard with the same MySQL database on the Raspberry Pi it does not display the full graph. See attached photo for what i am talking about.

Also when I chose to view the last 1h of data it is not possible to view it as it says no data points but when I run the same thing on my laptop it shows up with data points.

[torkel]

It’s related to a time zone issue we are having with MySQL datasource, you can fix it if you run you MySQL server in a UTC time zone environment / setting .

We might have a fix for it in an upcoming release

[cdewar]

Thank you @torkel this looks like it fixed my problems. I am currently able to now view and use all of the features of the graph pannel now.

[crzyn8]

I know this was only a few days ago, but are there any updates on this? For various reasons, we are not able to change the time zone on the MySQL server at this time.

[cdewar]

@crzyn8 I used this link to change the time stamp for the data base and so it may help you?

MySQL Set UTC time as default timestamp

Here is also some info for you to look at and then this is what you should see?

mysql> SELECT @@global.time_zone, @@session.time_zone;

+--------------------+---------------------+

| @@global.time_zone | @@session.time_zone |

+--------------------+---------------------+

| SYSTEM             | SYSTEM              |

+--------------------+---------------------+

1 row in set (0.00 sec)

mysql> SELECT CURRENT_TIMESTAMP();

+---------------------+

| CURRENT_TIMESTAMP() |

+---------------------+

| 2012-09-25 16:28:45 |

+---------------------+

1 row in set (0.00 sec)

Then you can set it permanently in the my.cnf file located in ‘ /etc/mysql/’

[mysqld]

**other variables**

default_time_zone='+00:00'

# restart the mysql server using the following command 

service mysql restart 

# Enter these two commands to to comfirm that the change was accepted. 

mysql> SELECT @@global.time_zone, @@session.time_zone;

+--------------------+---------------------+

| @@global.time_zone | @@session.time_zone |

+--------------------+---------------------+

| +00:00             | +00:00              |

+--------------------+---------------------+

1 row in set (0.00 sec)

mysql> SELECT CURRENT_TIMESTAMP();

+---------------------+

| CURRENT_TIMESTAMP() |

+---------------------+

| 2012-09-25 20:27:50 |

+---------------------+

1 row in set (0.01 sec)