Jump to content
  • 0
Sign in to follow this  
bWolfie

SQL tables crash and need to be repaired

Question

Hi,

 

Few things.

- Using CentOS 6.

- Server is live.

- It has around 100 players on it.

- The issues started around 20 October.

 

It starts like this. An error will pop up in the console, something like this.

161021  1:40:14 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './hercuser_rag/skill.MYI'; try to repair it
And then usually anywhere from 1-12 hours later, the table itself crashes and needs to be repaired. This results in players losing skills and us [server admins] needing to do emergency maintenance.
161021 11:45:55 [ERROR] /usr/libexec/mysqld: Table './hercuser_rag/skill' is marked as crashed and should be repaired
Does anybody know what could be causing this? We don't know where to look for logs other than /var/log/mysqld.log

We've had to take the server down indefinitely until we can solve it.

 

Please help.

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

you must repair all corrupted tables. This can happened because server failure. Probably power loss or reset.

For recover tables use sql commands like:

 

repair table skill;

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.