Possible Database corruption

[rfc4711]

I've been trying to add a XML SNMP query for the LM sensors MIB and always getting below error message in my cacti.log, for some reason the graph never updates and does not generate an rrd file. I suspect the database has been corrupted on my graph templates, whatever have in there is working, though adding new graph templates is not. I tested my configuration on a new install and it is working there without a problem, how can I troubleshoot this further?

Below error are shows when I look the the device graphs, the "selected graph template" is blank and cannot be changed.

Code: Select all

2019/01/07 12:04:54 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT   snmp_query_graph_id, GROUP_CONCAT(snmp_field_name ORDER BY snmp_field_name) AS columns   FROM snmp_query_graph_rrd   GROUP BY snmp_query_graph_id   HAVING '
2019/01/07 12:04:54 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
2019/01/07 12:04:54 - CMDPHP SQL Backtrace: (/graphs.php: 104 graph_edit)(/graphs.php: 1351 get_common_graph_templates)(/graphs.php: 451 db_fetch_assoc_prepared)(/lib/database.php: 402 cacti_debug_backtrace)
2019/01/07 12:04:54 - CMDPHP SQL Backtrace: (/graphs.php: 104 graph_edit)(/graphs.php: 1351 get_common_graph_templates)(/graphs.php: 457 db_fetch_cell_prepared)(/lib/database.php: 281 cacti_debug_backtrace)
2019/01/07 12:04:54 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT CONCAT_WS('', graph_template_id, '_', id, '') AS id, name   FROM snmp_query_graph   WHERE (snmp_query_id = 21   AND id IN ()) OR graph_template_id IN () ORDER BY name'
2019/01/07 12:04:54 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) OR graph_template_id IN () ORDER BY name' at line 1
2019/01/07 12:04:54 - CMDPHP SQL Backtrace: (/graphs.php: 104 graph_edit)(/graphs.php: 1403 draw_edit_form)(/lib/html_form.php: 112 draw_edit_control)(/lib/html_form.php: 269 db_fetch_assoc)(/lib/database.php: 361 db_fetch_assoc_prepared)(/lib/database.php: 402 cacti_debug_backtrace)

Code: Select all

Cacti Version	1.1.38
Cacti OS	unix
RSA Fingerprint	30:60:ce:09:de:10:83:b6:fa:29:24:df:f6:64:d1:d2
NET-SNMP Version	NET-SNMP version: 5.7.3
RRDtool Version	RRDtool 1.5.x
HP Version	7.0.32-0ubuntu0.16.04.1
PHP OS	Linux
PHP uname	Linux cacti 4.4.35-1-pve #1 SMP Fri Dec 9 11:09:55 CET 2016 x86_64
PHP SNMP	Installed
max_execution_time	30
memory_limit	128M

[Osiris]

I would suggest trying to update to 1.2, but something is quite odd. Getting SQL errors warrants an issue in GitHub.

[rfc4711]

TY, opened https://github.com/Cacti/cacti/issues/2284 to track this issue.

[ItzNota]

I did an update to the workstation and that is when I started getting that exact error. Tried to downgrade, but still did not work.

[Osiris]

Okay, the data base is not corrupted. The issue is with the Data Query XML export. The other issue, is a bug in Cacti when trying to get the graph templates. I'll be addressed, in the mean time import the following XML, which fixes the problem.