Large numbers not recording in rrd

[jodrell]

I'm using Cacti to graph data from MySQL and am having a problem.

One of the graphs displays 0 sometimes and data other times - I know that it will never be 0. I used rrdtool and discovered that the data being written into the rrd is also 0 so it's not the way the graphs are being written.

The values I'm recording can be up to around 5,000,000,000 before they roll over so I've set the data template with a top limit of 100,000,000,000 just to be on the safe side and made it a counter. I then junked all the graphs using this template and recreated them but the sdata is still not showing (until the value rolls over to a much smaller number then everything is fine again).

What have I missed, why is the data not being recorded?

[jodrell]

The number in the rrd becomes 0 when the actual number being monitored is somewhere between 2214907691 and 2656969807 (2.2 and 2.6 billion) . . . I'd love to be more exact but I was,of course, out at lunch!

[jodrell]

I've just tried running the php collection script manually and it's always returning the same value . . . 2147483647 which, afaik is the maximum value for a signed 32bit integer (thanks for that Simon).

Guess I'm going to be hacking around inside some php!

[jodrell]

Got it - changed an int into a float and it's all working again

This was using the http://www.faemalia.net/mysqlUtils/ templates btw