graphs stop updating after midnight

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
cactihalo
Posts: 1
Joined: Wed Feb 28, 2007 4:44 am

graphs stop updating after midnight

Post by cactihalo »

Hi

I'm hoping someone can help with this, i've spent a lot of time troubleshooting this problem, but cannot find a solution.

The graph in question gets it's input data from an OS script:

02/28/2007 12:30:10 PM - CMDPHP: Poller[0] Host[60] DS[1415] CMD: /var/www/cacti/scripts/askrouter, output: currin:5576654970 currout:1734618596 total:7311273566

and the database is being updated:
select * from poller_output where local_data_id = '1415';
...
...
...
| 1415 | | 2007-02-28 12:35:09 | currin:5576654970 currout:1734618596 total:7311273566 |

but the graph is not being updated?:

watcher log # ls -latr /var/www/localhost/htdocs/cacti/rra/internet_router_traffic_outcum_1415.rrd
-rwxrwxrwx 1 apache apache 588208 Feb 27 23:55 /var/www/localhost/htdocs/cacti/rra/internet_router_traffic_outcum_1415.rrd


php memory is set to 128M
running cacti 0.8.6.j
with plugins

as a test i created a duplicate of this graph(same host, same templates) and it is working properly.

also, I am getting hundreds of copies(in one poller cycle) of the exact same line in the log file:

02/28/2007 12:35:17 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select data_template_rrd.data_source_name, data_input_fields.data_name from (data_template_rrd,data_input_fields) where data_template_rrd.data_input_field_id=data_input_fields.id and data_template_rrd.local_data_id=1415"



Any help appreciated, where else can I look?

regards
Attachments
graph_image.php.png
graph_image.php.png (26.85 KiB) Viewed 1087 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please check the second link of my signature, especially the part on data source MAX.
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests