Cacti stop graphing

[i_lius]

Dear All,
I have cacti Version 0.8.7e running since early 2010 under Windows 2003, with 80Gb HDD, 1GB RAM. All of the sudden it stops graphing from about two days ago. But the server actually having some snmp traffic going in.
Restarting the server hasn't done any help.


I found this on the log:

Code: Select all

09/15/2010 08:00:06 PM - CMDPHP: Poller[0] Host[15] DS[394] WARNING: Result from CMD not valid. Partial Result: U
09/15/2010 08:00:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (393, 'uptime', '2010-09-15 20:00:05', '139910800')'
09/15/2010 08:00:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (392, 'mem_used', '2010-09-15 20:00:05', '12544')'
09/15/2010 08:00:05 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (391, 'mem_free', '2010-09-15 20:00:05', '127408')' 

anyhelp and advice would be very much appreciated!

Thanks!
Ivan

[i_lius]

Anybody?

[BSOD2600]

Did you google for mysql error 145?

The cacti technical support page show any issues?

[i_lius]

Hi,
what should i be looking in the tech support page?
There seem no error displayed (sorry rather nuub).

Yes i did try google MySQL errno 145

MySQL Errno: 145 (explanation and resolution)

With the MySQL database turned on, you are unable to access your board, or certain functions of your board, because you receive an error number 145 from MySQL. An example error message you may receive is: search_keyword_database execute error, Can't open file: 'prefix_search.MYI'. (errno: 145)

Possible, read only attribute checked, but no changes.
Drive read and write seems ok, plenty of diskspace 42GB out of 50GB.

User name & password for the server has never changed.

Checked the rrd files, there're nothing written since 13/09/10, 8.40PM.

Stuck