autom8 is creating duplicate graphs for my hosts each time they are re scanned. These are not duplicates of pre-existing graphs, but duplicates of graphs originally created by autom8.
I am running cacti 8.7h with plugin arch. 3.0 From what I could tell in the documentation, no patching is required when using plugin arch. 2.9 or higher. The included patch versions were only for 8.7d and 8.7e and the dry run tests with each failed, so I assumed they were not needed.
In the logs I see the following error when adding graphs:
12/23/2015 10:30:27 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=14 AND data_local.host_id=314 AND data_local.snmp_query_id=1 AND data_local.snmp_index='16'"
When I run that query I get:
Unknown column 'output_type' in 'where clause'
Autom8 creating duplicate graphs
Moderators: Developers, Moderators
Re: Autom8 creating duplicate graphs
Resolved by installing the latest version of autom8.
Who is online
Users browsing this forum: No registered users and 5 guests