Help: DB Exec Failed

[i_lius]

Hi All,
I have these following messages, after a black out

02/01/2011 11:25:20 PM - SYSTEM STATS: Time:20.1996 Method:cmd.php Processes:2 Threads:N/A Hosts:34 HostsPerProcess:17 DataSources:1581 RRDsProcessed:0
02/01/2011 11:25:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'126', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (1114, 'traffic_out', '2011-02-01 23:25:20', '362373268')'
02/01/2011 11:25:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'126', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (1114, 'traffic_in', '2011-02-01 23:25:20', '2798212949')'
02/01/2011 11:25:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'126', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (1113, 'traffic_out', '2011-02-01 23:25:20', '74290847')'
02/01/2011 11:25:20 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'126', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (1113, 'traffic_in', '2011-02-01

done a few test, like rebuild cache, but doesn't help.
Tried with these command, it gives me this answer:

Code: Select all

C:\Users\Admin>mysqlcheck --auto-repair --databases cacti
mysqlcheck: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using pa
ssword: NO) when trying to connect

Had this before and i had to reinstall and lost all the database... hope not to do this again this time....

[BSOD2600]

MySQL error 126 = Incorrect key file for table X. which means you need to repair it.

I'd suggest using the script in /cacti/cli/repair database... but first you need to correct your mysql root access.