CMDPHP: Poller[0] ERROR: SQL Exec Failed (SOLVED)

[bwood]

Hello,

I'm getting the following error in my Cacti Log File every couple of minutes:

CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from poller_command where poller_id=0"

Does anyone have any suggestions on how to fix this problem?

[TheWitness]

Sounds like a hosed database:

Code: Select all

mysql cacti
> repair table poller_output;
> quit

TheWitness

[bwood]

Thank you for your help, I ran your suggestion through mysql and got the following results:

Code: Select all

mysql> repair table poller_output;
+---------------------+--------+----------+----------------------------------------+
| Table               | Op     | Msg_type | Msg_text                               |
+---------------------+--------+----------+----------------------------------------+
| cacti.poller_output | repair | warning  | Number of rows changed from 815 to 813 |
| cacti.poller_output | repair | status   | OK                                     |
+---------------------+--------+----------+----------------------------------------+
2 rows in set (0.25 sec)

mysql> quit;
Bye

However, I am still receiving the error message in the cacti log. It seems arbitrary, but the fact that it's a big red ERROR bothers me. If anyone has any other suggestions on how to resolve it and make Cacti happy please let me know.

Code: Select all

07/31/2007 08:56:35 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from poller_command where poller_id=0"
07/31/2007 08:55:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from poller_command where poller_id=0"
07/31/2007 08:54:32 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from poller_command where poller_id=0"
07/31/2007 08:53:27 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "delete from poller_command where poller_id=0"

[TheWitness]

Oops: repair table poller_command; my bad...

[bwood]

Here are the results of running the repair on the poller_command table:

Code: Select all

mysql> repair table poller_command;
+----------------------+--------+----------+--------------------------------------------+
| Table                | Op     | Msg_type | Msg_text                                   |
+----------------------+--------+----------+--------------------------------------------+
| cacti.poller_command | repair | info     | Wrong bytesec:   0-  0-  0 at 400; Skipped |
| cacti.poller_command | repair | warning  | Number of rows changed from 5 to 4         |
| cacti.poller_command | repair | status   | OK                                         |
+----------------------+--------+----------+--------------------------------------------+
3 rows in set (0.03 sec)

mysql> quit;
Bye

Thank you for your help, the errors are no longer appearing in my cacti log.