Network Interface Graphs Disappeared... SQL Assoc Failed

[spike666]

Hey everyone,

I just got Cacti fully working and graphing 2 hosts including the network interface graphs (throughput and error graphing).

I went through to give the graphs more meaningful names ("WAN(eth0)" rather than "eth0" and "LAN(eth1)" rather than "eth1") when the graphs stopped rendering in the preview page, but rendered fine when doing the full-view of the graphs (with daily, weekly, monthly, anually graphs).

At first, when I turned on rrdtool debug output, I was just getting errors along the lines of:

Code: Select all

ERROR: parameter '#FFAB00' does not represent a number in LINE1:#FFAB00:Discards In

now, when I go to view the full-view, nothing renders. No broken images, it's just the normal page but with empty content; the Cacti header is there, just no graphs.

in cacti.log, I have these errors:

Code: Select all

03/05/2007 02:15:56 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   CONCAT_WS('',   case   when host.description is null then 'No Host - '   when host.description is not null then ''   end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name,   data_template_rrd.id   from (data_template_data,data_template_rrd,data_local)   left join host on (data_local.host_id=host.id)   where data_template_rrd.local_data_id=data_local.id   and data_template_data.local_data_id=data_local.id    and data_local.host_id=1   order by name"
03/05/2007 02:15:56 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   CONCAT_WS('',   case   when host.description is null then 'No Host - '   when host.description is not null then ''   end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name,   data_template_rrd.id   from (data_template_data,data_template_rrd,data_local)   left join host on (data_local.host_id=host.id)   where data_template_rrd.local_data_id=data_local.id   and data_template_data.local_data_id=data_local.id    and data_local.host_id=1   order by name"
03/05/2007 02:15:56 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   CONCAT_WS('',   case   when host.description is null then 'No Host - '   when host.description is not null then ''   end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name,   data_template_rrd.id   from (data_template_data,data_template_rrd,data_local)   left join host on (data_local.host_id=host.id)   where data_template_rrd.local_data_id=data_local.id   and data_template_data.local_data_id=data_local.id    and data_local.host_id=1   order by name"
03/05/2007 02:15:56 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   CONCAT_WS('',   case   when host.description is null then 'No Host - '   when host.description is not null then ''   end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name,   data_template_rrd.id   from (data_template_data,data_template_rrd,data_local)   left join host on (data_local.host_id=host.id)   where data_template_rrd.local_data_id=data_local.id   and data_template_data.local_data_id=data_local.id    and data_local.host_id=1   order by name"

It's strange, because I'm still seeing my memory usage and load average graphs... it's just the new graphs I added - the network interface graphs - that are missing.

running poller.php produces no errors on the commandline.

I checked my mysql database to for corruption (as I saw in a post during some mass-googling) and it's working fine.

I'm running:
Gentoo Linux
Apache 2.0.58
PHP 5.1.6
mysql 5.0.26
cacti 0.8.6j

if I left out any info, let me know.

Thanks in advance!

[TheWitness]

What have you changed recently? Did you do a MySQL upgrade? Is the sql_mode variable set in MySQL. If so, unset it and restart MySQL.

TheWitness

[spike666]

What have you changed recently? Did you do a MySQL upgrade? Is the sql_mode variable set in MySQL. If so, unset it and restart MySQL.

TheWitness

I checked the mysql_mode varialbe in my.cnf (you had recommended checking that on the bug track site and in another forum post to other users) and I'm not using it.

I did try to restart mysql, though.

I did recompile gcc since I was having some issues with libtool. it wasn't an upgrade, though. still running 4.1.1

The only real thing that I did was modify the names of my graphs and the names (and only the names) of the related data sources for the graphs that disappeared.

any other ideas?

[spike666]

I was just looking at my logs this morning (I just woke up about 40 minutes ago), and I noticed that the SQL errors have stopped. In fact, there's no errors at all, anymore. It seems that those SQL errors only happened for 4-5 polls in a row when I changed my graph and datasource names, but stopped when I changed them back.

but my graphs are still missing.

I tried deleting the rrd files for the missing graphs (or, rather, hiding them) and re-running poller.php, but that didn't fix it.

Then I tried to create new traffic graphs, and they worked! so I went in and deleted all traffic graphs (the old ones that were broken and the new ones that worked), and it asked about deleting datasources that were in use by those graphs, but it only asked about the sources relating to the new graphs, which leads me to believe that somehow, the graphs that broke lost their connection to their datasources.

I had deleted those graphs, so I couldn't go back and check, but I know I didn't change anything relating to sources, just graph names.

So, I re-added my network interface graphs and re-ran poller.php, and I was able to view the interface graphs detail pages, but was still getting broken images. After deleting the rrd files for those graphs and re-running poller.php, graphs showed up again.

so everything seems to be working.

how do you think this happened? I've seen a couple of posts in various forums about cacti graphs breaking after renaming them (seems to always be interface graphs, but part of me thinks that that's really the only graph anyone would want to rename), so do you think this is a bug?

thanks for the reply. =)