Cacti error on my poller

[parraja80]

Hi, i got Cacti, and i am monitoring over 500 devices, each one with 3 graphs, but since 3 week ago there is nothing on the graph, and i got this message error in the log.

10/23/2007 09:28:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_command (poller_id, time, action, command) values (0, NOW(), 1, '912:1')"

The number in bold is constantly changing.

I really need help with this,

Thanks

[N3NCY]

Do you have phpMyAdmin (web interface for MySQL) installed?
You may need to try clicking on the "repair table" option.

This can also be done via command line:
http://dev.mysql.com/doc/refman/5.0/en/ ... table.html

Using the phpMyAdmin GUI is an easy way to repair tables.
If you need the command line version syntax let me know.
I can look it up.
It is something like:
mysql --user=root -p mysql
use cacti;
repair table xyz;

[parraja80]

Hi, i did it, but still is not working.

Thanks a lot

[N3NCY]

You said:

but since 3 week ago there is nothing on the graph

Is it just one graph for one device or all graphs for every device (all 500)?

[gandalf]

And please take second link of my signature into consideration. This will at least give you more detailed information
Reinhard

[cwalton]

nevermind, display issue