Hi,
I've installed on xp system the
BETA Windows Installer [v1.4 - 2006-11-16]. All fine during one month
but yesterday the graphes don't works.
I 've a error message in cacti log like mysql error insertion poller, trie to reinstall it???
Whats is mean and how Can I resolve it without to reinstall all???
Thanks by adavance
Dom
[Solved] poller error insertion in mysql
Moderators: Developers, Moderators
1) Well what changed recently with your setup?
2) What exactly is the error you're experiencing?
3) you really should upgrade to cacti 0.8.6j while you're at it.
2) What exactly is the error you're experiencing?
3) you really should upgrade to cacti 0.8.6j while you're at it.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
poller insertion failed in mysql
Hi,
I send you the log file. I don't remenber what I done before this error but all was successfully for one month. I've last verion of cacti
Thanks by advance
02/21/2007 12:28:35 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:34 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:34 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:34 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
I send you the log file. I don't remenber what I done before this error but all was successfully for one month. I've last verion of cacti
Thanks by advance
02/21/2007 12:28:35 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:34 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:34 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:34 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
02/21/2007 12:28:33 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'Table '.\cacti\poller_output' is marked as crashed and should be repaired'
poller insertion failed
Hi
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (210, 'traffic_out', '2007-02-21 13:50:08', '324713903')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, 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"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (210, 'traffic_in', '2007-02-21 13:50:08', '3982543462')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (211, 'traffic_out', '2007-02-21 13:50:08', '109689954')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (211, 'traffic_in', '2007-02-21 13:50:08', '707420774')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (214, 'hdd_used', '2007-02-21 13:50:08', '7999086592')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (214, 'hdd_total', '2007-02-21 13:50:08', '36406374400')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (215, 'hdd_total', '2007-02-21 13:50:08', '734072401920')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (215, 'hdd_used', '2007-02-21 13:50:08', '547926921216')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (216, 'hdd_total', '2007-02-21 13:50:08', '2586836992')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (216, 'hdd_used', '2007-02-21 13:50:08', '801505280')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (217, 'hdd_total', '2007-02-21 13:50:08', '1073152000')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (217, 'hdd_used', '2007-02-21 13:50:08', '785448960')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (218, 'cpu', '2007-02-21 13:50:08', '38')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (219, 'traffic_in', '2007-02-21 13:50:08', '1826467830')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (219, 'traffic_out', '2007-02-21 13:50:08', '2684789292')"
02/21/2007 01:50:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, 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) "
02/21/2007 01:50:09 PM - SYSTEM STATS: Time:6.0519 Method:cmd.php Processes:1 Threads:N/A Hosts:13 HostsPerProcess:13 DataSources:126 RRDsProcessed:0
New cacti log
Thanks
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (210, 'traffic_out', '2007-02-21 13:50:08', '324713903')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, 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"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (210, 'traffic_in', '2007-02-21 13:50:08', '3982543462')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (211, 'traffic_out', '2007-02-21 13:50:08', '109689954')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (211, 'traffic_in', '2007-02-21 13:50:08', '707420774')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (214, 'hdd_used', '2007-02-21 13:50:08', '7999086592')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (214, 'hdd_total', '2007-02-21 13:50:08', '36406374400')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (215, 'hdd_total', '2007-02-21 13:50:08', '734072401920')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (215, 'hdd_used', '2007-02-21 13:50:08', '547926921216')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (216, 'hdd_total', '2007-02-21 13:50:08', '2586836992')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (216, 'hdd_used', '2007-02-21 13:50:08', '801505280')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (217, 'hdd_total', '2007-02-21 13:50:08', '1073152000')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (217, 'hdd_used', '2007-02-21 13:50:08', '785448960')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (218, 'cpu', '2007-02-21 13:50:08', '38')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (219, 'traffic_in', '2007-02-21 13:50:08', '1826467830')"
02/21/2007 01:50:08 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (219, 'traffic_out', '2007-02-21 13:50:08', '2684789292')"
02/21/2007 01:50:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, 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) "
02/21/2007 01:50:09 PM - SYSTEM STATS: Time:6.0519 Method:cmd.php Processes:1 Threads:N/A Hosts:13 HostsPerProcess:13 DataSources:126 RRDsProcessed:0
New cacti log
Thanks
Oh, your mysql database has been corrupted. try: mysqlcheck --auto-repair --databases cacti
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
poller insertion error
hi,
Finally I 've reinstalled cacti installer and all is ok now.
Thanks for all
Finally I 've reinstalled cacti installer and all is ok now.
Thanks for all
I had a server crash at the weekend and the exact same error message in the log file - as I only really use mysql for Cacti I didn't know how to repair the database so this command has come in very handy - all my other mysql based apps have a "repairdb" batch file which I assume is using this same command,BSOD2600 wrote:Oh, your mysql database has been corrupted. try: mysqlcheck --auto-repair --databases cacti
So a major thanks for posting this - helped no end!
Larry
---- lard007skype ----
Who is online
Users browsing this forum: No registered users and 3 guests