Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mycheckpoint crash tables #21

Closed
GoogleCodeExporter opened this issue Jun 5, 2015 · 3 comments
Closed

mycheckpoint crash tables #21

GoogleCodeExporter opened this issue Jun 5, 2015 · 3 comments

Comments

@GoogleCodeExporter
Copy link

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
Copy link
Author

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

  • Changed state: NotABug

@GoogleCodeExporter
Copy link
Author

Thank you Shlomi.

I converted those tables to InnoDB.

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

@GoogleCodeExporter
Copy link
Author

Thank you Shlomi.

I converted those tables to InnoDB.

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant