Graph not updating correctly

[stang7423]

Hello,

I'm having problems trying to get one of my graphs to update. I've ran through all the trouble shooting steps I could find/think of, but still the graph won't update correctly. I'm trying to graph the number of queries my Mysql server is doing by using the sql.php script that comes with 0.8.5a. I've tested the script by it self and that works fine. I've manully ran cmd.php and cactid and the correct values are being passed to rrdtool. No here is where I'm stumped, When I first create the graph a first data point will show on the graph, but after the first it appears the graph stops updating. This behavior will repeat if I delete the graph/data source and recreate the graph. All of my other graphs are updating correctly. Has anyone else noticed behavior like this?

-Troy Stanger

[raX]

Some operating systems don't have programs like 'mysqladmin' in the path when cmd.php runs from cron. This is why it might appear to work when run manually, but always fails when run out of cron. To fix, open up 'sql.php' in a text editor and replace 'mysqladmin' with the full path to 'mysqladmin'.

-Ian

[neil]

Ian I am having a similar problem. My Cacti was working OK now!

Problem 1.
For one device graph is incorrect. was correct before

Problem 2.
Since the last two weeks, My graph stop displaying data.
Nothing has changed on my server.

Why why ....!

[raX]

Problem 2.
Since the last two weeks, My graph stop displaying data.
Nothing has changed on my server.

Is it possible that something changed on the device you are graphing? If you are graphing traffic, an ifIndex change could easily cause this to occur.

-Ian

[neil]

It has stop for all my devices.

[raX]

Do you get any errors when running cmd.php manually from the command line? Double and triple check the permissions on the files in your 'rra/' directory and make sure that cmd.php can write to these files when it runs from cron. Sometimes I find that su'ing to the user cmd.php runs as first helps pinpoint the actual issue.

-Ian

[neil]

command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 1, output: 268435456
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 1, output: 223133696
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 2, output: 406478848
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 2, output: 261637120
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 3, output: 39109632
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 3, output: 78848
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 4, output: 15309036544
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 4, output: 2068344832
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 5, output: 2625144832
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 5, output: 749198336
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 6, output: 4096
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 6, output: 4096
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get total 7, output: 1073676288
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_partitions.php 172.16.64.245 s3cur3 2 get used 7, output: 397029376
command: /usr/bin/php -q /var/www/html/cacti/scripts/query_host_cpu.php 172.16.64.245 s3cur3 2 get usage 0, output: 16
snmp: 172.16.254.20:161, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.16, value: 1276507124
snmp: 172.16.254.20:161, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.16, value: 557191717
update /var/www/html/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers N:U
File size limit exceeded (core dumped)

[neil]

What test can I perform. on the System to determine if all Aspect of cacti is ok.

[foo]

Delete your log. It's too large.

Linux has a known issue with files that grow over 2GB in size.

[neil]

Did all that....No luck...

This is new install on a new server.

[twebster]

Make sure the owner of the rra directory is cacti user.

I often run cactid by hand using the root user, so the files get created by root, thus cacti can't write to the rra file. This creates symptoms similiar to yours, the graph works the first few polls and then not longer updates..

good luck,
tony