[solved] No graphs, SQL Cell errors in cacti.log

[hammond1]

Sorry for another no graphs post but I searched the entire forum on the SQL errors in the cacti.log file and couldn't find anything related.


First things first:

OS: Windows 2K Pro
Webserver: Apache 2
Spine: installed, not in use, don't know how to check version - .exe is Spinep2T.exe, file version is 1.0.0.0
MySql: 5.0.51a
PHP: 5.2.5
RRDTool: 1.2.15 win32
Net-SNMP: 5.4.1-3
Cygwin1.dll file version: 1005.25.0.0
Plugin Architecture: no plug-ins that I'm aware of


Everything worked fine for quite awhile then all graphs appeared empty at the same time despite every device showing as up, and every snmpwalk, graph debug, etc. performed on each device revealing that yes, Cacti IS getting data from the devices.

In checking the cacti.log file I see the following:

CMDPHP: Poller[0] ERROR; SQL Cell Failed!, Error:'145', SQL:"select count(*) from poller_item where rrd_next_step<=0"

CMDPHP: Poller[0] ERROR; SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_num from (poller_output,poller_item_ where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

CMDPHP: Poller[0] ERROR; SQL Assoc Failed!, Error:'145', SQL:"select * FROM poller_item WHERE (host_id >=0 AND host_id <= 49 AND rrd_next_step <= 0) ORDER by host_id"

CMDPHP: Poller[0] ERROR; SQL Cell Failed!, Error:'145', SQL:"select count(*) FROM poller_item WHERE (action=2 AND host_id >= 0 AND host_id <= 49 AND rrd_next_step <=0)"

CMDPHP: DB Exec Failed!, Error:'145', SQL:"UPDATE poller_item SET rrd_next_step = rrd_next_step - 300 WHERE (host_id >= 0 AND host_id <=49)'

CMDPHP: DB Exec Failed!, Error:'145', SQL:"UPDATE poller_item SET rrd_next_step = rrd_step - 300 WHERE (host_id >= 0 AND host_id <=49)'

If any one has any suggestions please offer them. Thanks very much for your assistance.

[BSOD2600]

1) what cacti version? fully patched?
2) Spinep2T.exe isn't a legitimate name for Spine, so unless you've renamed it.. I wouldn't use that one.
3) Tried a repair on the database?

Code: Select all

mysqlcheck --auto-repair --databases cacti

Alternatively, you can use \cacti\cli\repair_database.php

[hammond1]

Sorry, Cacti version is 0.8.7b

Am not familiar with mysql command line, in performing the mysqlcheck --auto-repair --databases cacti the output is the following:

"mysqlcheck: Got error: 1045: Access denied for user 'ODBC'@localhost' (using password: NO) when trying to connect"

I see the "user" switch for mysqlcheck but when attempting "mysqlcheck user root" I get the same 1045 error.

[hammond1]

Since I couldn't get mysqlcheck to work I ran the repair_database.php.

All tables were successfully repaired but still no graphs (graphs show "-1.#J" for all values). And now I see in the cacti.log file the following:

07/07/2008 08:45:08 AM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 1652.
07/07/2008 08:45:08 AM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 1651.
07/07/2008 08:45:08 AM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 1653.
07/07/2008 08:45:07 AM - CMDPHP: Poller[0] ERROR: There are no RRA's assigned to local_data_id: 1654.

So I did a rebuild of poller cache, and GRAPHS ARE NOW WORKING! Thanks much for your assistance, hope you had a terrific Independence Day weekend.

[JD]

What did you do to rebuild the poller cache?

-JD-

[hammond1]

In the web gui of the Cacti server go to Console>Utilities>System Utilities>Rebuild Poller Cache.