odd behavior - missing graph

[jlim0930]

I have about 100 hosts thats being graphed with cacti some solaris and some linux a mixture of redhat centos suse etc

i updated 2 of the hosts by recompileing net-snmp and changing the graphs from just bits/sec to bits/sec(64bit counters) and all of the sudden my graphs for solaris interfaces stoped working

the data collection have stoped and i can still see the old graphs but no new data is being logged.

i am also getting a lot of

Code: Select all

 07/05/2006 02:11:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=418"
07/05/2006 02:11:38 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=1066"
07/05/2006 02:11:38 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=418"

can someone please give me some hints on how to resolve this ?

i am using cmd.php to poll
and using 0.8.6h

Thanks[/code]

[gandalf]

i updated 2 of the hosts by recompileing net-snmp and changing the graphs from just bits/sec to bits/sec(64bit counters) and all of the sudden my graphs for solaris interfaces stoped working

From some other thread I learned, that changing _existing_ 32 bit graphs into 64 bit ones will yield insane stuff.
So perhaps deleting those changed graphs/data sources may cure the problem. This will not delete the old rrd files. If you want to keep them, you may want to dump them and restore them with the filename of the rrd files associated to freshly created 64 bit ones
Reinhard