|
|
| Author |
Message |
netswords
Joined: 20 Sep 2007 Posts: 13
|
Posted: Tue Nov 13, 2007 7:34 pm Post subject: problem with my cacti |
|
|
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) |
|
| Back to top |
|
 |
idle Cacti User
Joined: 26 May 2004 Posts: 51 Location: Russia: Saint Petersburg
|
Posted: Wed Nov 14, 2007 1:42 am Post subject: |
|
|
netswords
It is usual situation with mysql that corrupt tables after crash.
Run repair from cli, with command:
| Code: | | mysql -uroot -p -e'repair table cacti.poller_output' |
Developers
Perhaps that would be not bad idea to add option to repair DB through cacti interface in "system utilities" menu, since we are using mysql... |
|
| Back to top |
|
 |
netswords
Joined: 20 Sep 2007 Posts: 13
|
Posted: Wed Nov 14, 2007 2:41 am Post subject: |
|
|
| thank u very much, I solve it with your method. |
|
| Back to top |
|
 |
gandalf Developer
Joined: 02 Dec 2004 Posts: 17009 Location: Muenster, Germany
|
Posted: Wed Nov 14, 2007 12:05 pm Post subject: |
|
|
| idle wrote: | netswords
It is usual situation with mysql that corrupt tables after crash.
Run repair from cli, with command:
| Code: | | mysql -uroot -p -e'repair table cacti.poller_output' |
Developers
Perhaps that would be not bad idea to add option to repair DB through cacti interface in "system utilities" menu, since we are using mysql... | Please post a feature request as giben in http://www.cacti.net/bugs.php
Reinhard |
|
| Back to top |
|
 |
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|