ERROR: SQL Exec failed "insert into poller_output...

[skillit]

Hi all,

I've just signed on with a new company that has an implementation of Cacti on Windows 2003 for the purpose of network monitoring. However it doesn't appear to have added any data to the graphs for about 6 weeks, and I've been asked to have a look at it. I'm trying to get my head around this product as fast as possible!

I raised the logging levels for a short while and was getting the following application log events:

**************

Event Type: Error
Event Source: Cacti
Event Category: (1)
Event ID: 2000
Date: 19/06/2007
Time: 11:05:47 AM
User: N/A
Computer: CACTIMON01
Description:
The description for Event ID ( 2000 ) in Source ( Cacti ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Cacti[4348], CMDPHP: ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (1343, '', '2007-06-19 11:05:41', 'AvgDiskQueueLength:0 ProcessorQueueLength:0')".

************

Event Type: Error
Event Source: MySQL
Event Category: None
Event ID: 100
Date: 19/06/2007
Time: 11:05:47 AM
User: N/A
Computer: CACTIMON01
Description:
C:\RRDTool\mysql\bin\mysqld-nt: Can't open file: 'poller_output.MYI' (errno: 130)

For more information, see Help and Support Center at http://www.mysql.com.

****************

To my best reckoning, these are the product versions:

MySQL 4.1.12a
PHP 5.0.4
RRDTool-cygwin 1.2.4

Can anyone point me in the right direction?

[BSOD2600]

Problem #1 is that Mysql error regarding poller_output.myi. Try running:
mysqlcheck --auto-repair --databases cacti. Does poller_output.myi even exist in the mysql\data\cacti directory?

Manually run the poller (change logging level to debug) and see if it gives any output. php <cactipath>\poller.php.

[skillit]

Thanks for that, mysqlcheck reported an error on the poller_output table too. poller_output.myi had a size of 0 bytes. I looked up the reference manual and worked out how to do a REPAIR TABLE USE_FRM to re-create the .myi file.

I have data starting to appear in the graphs again! Thanks for your help.