|
when power cut, the cacti server reboot unusual,
the cacti can't work, may be some problem with mysql,
here is the cacti log file,help me.........
11/14/2007 08:30:12 AM - 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) "
11/14/2007 08:30:12 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:12 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:12 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:12 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:11 AM - 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"
11/14/2007 08:30:10 AM - 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"
11/14/2007 08:30:10 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:09 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:09 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:09 AM - 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"
11/14/2007 08:30:09 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:09 AM - CACTID: Poller[0] Host[149] DS[4744] WARNING: Result from SNMP not valid. Partial Result: ...
11/14/2007 08:30:09 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - 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"
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
11/14/2007 08:30:08 AM - CACTID: Poller[0] ERROR: Problem with MySQL: Can't open file: 'poller_output.MYI'. (errno: 145)
Host Information
Cacti Version 0.8.6j
Plugin Architecture 1.1
Poller Type Cactid v0.8.6f
Server Info Linux 2.4.20-8
Web Server Apache/2.0.54 (Unix) PHP/4.4.0
PHP Version 4.4.0
PHP Extensions xml, tokenizer, standard, sockets, session, posix, pcre, overload, mysql, gd, ctype, zlib, apache2handler
MySQL Version 4.0.18
RRDTool Version 1.2.11
SNMP Version 5.2.1.1
Plugins Global Plugin Settings (settings - v0.2)
SuperLinks (superlink - v0.3)
Simple Links page (links - v0.3)
Thresholds (thold - v0.3.5.2)
Device Tracking (mactrack - v1.0)
report it! (report it! - v0.3.2)
Uptime (uptime - v0.3)
Update Checker (update - v0.3)
Host Info (hostinfo - v0.1)
Network Discovery (discovery - v0.7)
FlowView (flowview - v0.3)
Network Tools (tools - v0.2)
Device Monitoring (monitor - v0.7)
PHP Network Weathermap (weathermap - v0.92)
|