Now looks like:
Cmdphp:poller[0] error:a DB Exec failed!, ERROR: ' 1062 ', SQL: "INSERT into Poller_item (local_data_id, host_id, Action,hos Tname, Snmp_community, Snmp_version, Snmp_timeout, Snmp_username, Snmp_password, Snmp_auth_protocol, snmp_priv_ Passphrase, Snmp_priv_protocol, Snmp_context, Snmp_port, Rrd_name, Rrd_path, Rrd_num, Rrd_step, Rrd_next_step, Arg1, Arg2, Arg3) VALUES (2356, 0, ' 192.168.251.65 ', ' CATV ', ' 2 ', ' $ ', ', ', ' MD5 ', ', ' DES ', ' ', ' 161 ', ' traffic_out ', '/var/www/html/rra/edu-sanhe-s5800_traffic_in_2356.rrd ', ' 2 ', ' 60 ', ' 0 ', '. 1.3.6.1.2.1.31.1.1.1.10.1 ', ', ') '
Go to MySQL
Use "cacti"
Select COUNT (*) from Poller_output;
mysql> truncate TABLE poller_output;
mysql> Select COUNT (*) from Poller_output;
+----------+
| count (*) |
+----------+
| 0 |
+----------+
1 row in Set (0.00 sec)
Or:
# REPAIR Table RepairData Sheet
MySQL> REPAIR TABLE poller_item;
+-------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------+--------+----------+----------+
| cacti.poller_item |Repair | Status | OK |
+-------------------+--------+----------+----------+
1 row in Set (0.02 sec)
mysql>
Repair succeeded.
If the repair fails, you can try using the USE_FRM option, for example:
MySQL> REPAIR TABLE poller_item use_frm;
Cacti does not plot, background prompt database Inter table error.