search

SunshineYang / mycheckpoint

Automatically exported from code.google.com/p/mycheckpoint
0 stars 1 forks source link

mycheckpoint crash tables #21

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.I get errors with mycheckpoint crash tables
2.
3.

What is the expected output? What do you see instead?
110816 21:00:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110816 21:00:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110816 21:00:05 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110816 21:00:07 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110816 21:05:01 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110816 21:05:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110819 12:40:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110819 12:40:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110819 12:40:13 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110819 12:40:19 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110819 12:45:02 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110819 12:45:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110820 10:05:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110820 10:05:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110820 10:15:02 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110825 14:20:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110825 14:20:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110825 14:20:05 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110825 14:20:13 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110825 14:21:07 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110825 14:21:07 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110826 12:50:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110826 12:50:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110826 12:50:10 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110826 12:50:15 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110826 12:55:01 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110826 12:55:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired

What is the output when running with the "--verbose --debug" options?
N/A

What version of the mycheckpoint are you using?
208
What version of the MySQL are you using? (SELECT VERSION())
5.5.13
On what operating system?
Linux

Please provide any additional information below.

Original issue reported on code.google.com by kizer.a...@gmail.com on 26 Aug 2011 at 5:06

GoogleCodeExporter commented 9 years ago 
So, this is a general MyISAM-crash tables scenario. and is not directly related 
to mycheckpoint.

mycheckpoint chooses your default engine for its tables. In you case, that was 
MySQL.
Once fixing the tables, I suggest that you may ALTER them into InnoDB, in case 
you're using InnoDB at all.

Original comment by shlomi.n...@gmail.com on 30 Aug 2011 at 10:06

GoogleCodeExporter commented 9 years ago 
Thank you Shlomi.

I converted those tables to InnoDB.

Original comment by kizer.a...@gmail.com on 30 Aug 2011 at 3:19

GoogleCodeExporter commented 9 years ago 
Thank you Shlomi.

I converted those tables to InnoDB.

Original comment by kizer.a...@gmail.com on 30 Aug 2011 at 3:22