Graph only shows last 3 days

[EugeneP]

Hello.

I have a special aggregated host, which contains aggregated info from group of servers. Now it contains only two values:

Total free space:
grpsum["DBS Servers","vfs.fs.size[/local,free]","last","0"]
item type - numeric (64 bit)
Units - B

Total space:
grpsum["DBS Servers","vfs.fs.size[/local,]","last","0"]
item type - numeric (64 bit)
Units - B

When I created a graph for first value and selected time period - week, it shows a straight line with a value 932.Gb. Values for a week exists in database. Graph attached to this message. What wrong with it? Or i have missed something?

The same graph but for a period of a three days shows correctly. And only 3 days. 4 days period shows only a straight line

[Aly]

I've posted a patch for graphs for 1.4.5 or 1.4.4 some time ago.. Search for it,may be it'll help you.

[EugeneP]

I had solved my problem. Aly, thank you for support but problem was much seriously. I thought earlier that the problem was in dimensions of numbers but after a some investigations i'm not sure.
Plain values from hosts are stored in database as bigint which treats as unsigned int (20). But when we tried to build a graph, we take a data values in "trends" table. Data stored in this table as double(16,4).
Here are some strings from a different tables. One table is trends, other is history_uint.

mysql> select * from trends where itemid=29314 and clock='1213804800';
+--------+------------+-----+--------------------+--------------------+--------------------+
| itemid | clock | num | value_min | value_avg | value_max |
+--------+------------+-----+--------------------+--------------------+--------------------+
| 29314 | 1213804800 | 120 | 1000000000000.0000 | 1000000000000.0000 | 1000000000000.0000 |

mysql> select * from history_uint where itemid='29314' and clock>='1213804700' and clock<='1213804900';
+--------+------------+---------------+
| itemid | clock | value |
+--------+------------+---------------+
| 29314 | 1213804723 | 7422586273792 |
| 29314 | 1213804753 | 7422083489792 |
| 29314 | 1213804784 | 7421784662016 |
| 29314 | 1213804813 | 7421292953600 |
| 29314 | 1213804843 | 7420651036672 |
| 29314 | 1213804873 | 7420264275968 |
+--------+------------+---------------+

and now - the last one...
mysql> select avg(value) from history_uint where itemid='29314' and clock>='1213804700' and clock<='1213804900';
+--------------------+
| avg(value) |
+--------------------+
| 7421443781973.3330 |
+--------------------+

why do we have so different picture?

[Aly]

I will look closer to this problem, but we need some time to collect needed data.