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

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
skillit
Posts: 2
Joined: Mon Jun 18, 2007 8:11 pm

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

Post by 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?
Last edited by skillit on Tue Jun 19, 2007 7:18 pm, edited 1 time in total.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by 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
Posts: 2
Joined: Mon Jun 18, 2007 8:11 pm

Success

Post by 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.
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests