show graphs with 2 days history

[Alexei]

Please, give us a screenshot of the item definition.

Also, execute the following SQL statements:

select min(from_unixtime(clock)),max(from_unixtime(clock) ) from history where itemid=17660;
select min(from_unixtime(clock)),max(from_unixtime(clock) ) from trends where itemid=17660;

[krusty]

Hi Alexei,

here are the two screenshots.

mysql> select min(from_unixtime(clock)),max(from_unixtime(clock) ) from history where itemid=17660;
+---------------------------+----------------------------+
| min(from_unixtime(clock)) | max(from_unixtime(clock) ) |
+---------------------------+----------------------------+
| NULL                      | NULL                       |
+---------------------------+----------------------------+
1 row in set (0.00 sec)

mysql>

mysql> select min(from_unixtime(clock)),max(from_unixtime(clock) ) from trends where itemid=17660;
+---------------------------+----------------------------+
| min(from_unixtime(clock)) | max(from_unixtime(clock) ) |
+---------------------------+----------------------------+
| NULL                      | NULL                       |
+---------------------------+----------------------------+
1 row in set (0.00 sec)

mysql>

I hope that helps.

[krusty]

I have search in the zabbix database for 17660 but i can not find any entry with this id. Should i use another entry maybe the graphid or something else for the mysql query?

[Alexei]

The graph is empty because of missing data in table 'trends'. I have no idea why though.

[krusty]

Could you shown the graphs about two days history? Why you want to look after the id 17660? I haven´t any id like 17660. I think i should use another id, but i don´t really know which. Can you please tell me what the id 17660 should be?

[krusty]

Hi Alexei,

know I checked out you debug select min(from_unixtime(clock)),max(from_unixtime(clock) ) from history where itemid=17660; with the itemid from the item LAN - IN and the result is the following. I think this looks very well, because the server has got values.

select min(from_unixtime(clock)),max(from_unixtime(clock) ) from history where itemid=17233;
+---------------------------+----------------------------+
| min(from_unixtime(clock)) | max(from_unixtime(clock) ) |
+---------------------------+----------------------------+
| 2005-10-19 08:12:00       | 2005-12-09 08:23:01        |
+---------------------------+----------------------------+
1 row in set (3.53 sec)

mysql> select min(from_unixtime(clock)),max(from_unixtime(clock) ) from trends where itemid=17233;
+---------------------------+----------------------------+
| min(from_unixtime(clock)) | max(from_unixtime(clock) ) |
+---------------------------+----------------------------+
| 2005-10-19 08:00:00       | 2005-12-09 08:00:00        |
+---------------------------+----------------------------+
1 row in set (0.03 sec)

mysql>

What can i do to isolate the bug. Any idea???

[krusty]

Alexei, could you please check this!