MySQL – Can’t change ownership of the file Errcode: 1

When trying to repair tables (or optimise), there seems to be an error that is giving me a hard time.

The SQL statement REPAIR TABLE mytablename; returns the following

+---------------------+--------+----------+----------------------------------------------------------------------------------------------+
| Table               | Op     | Msg_type | Msg_text                                                                                     |
+---------------------+--------+----------+----------------------------------------------------------------------------------------------+
| mydbase.mytablename | repair | error    | 1 when fixing table                                                                          |
| mydbase.mytablename | repair | Error    | Can't change ownership of the file '/hds/wd1tb_2/mysql/mydbase/mytablename.MYD' (Errcode: 1) |
| mydbase.mytablename | repair | status   | Operation failed                                                                             |
+---------------------+--------+----------+----------------------------------------------------------------------------------------------+

So, the only solution up to now is to

chmod -R 700 /hds/wd1tb_2/mysql/
chown -R mysql:mysql /hds/wd1tb_2/mysql/

This error has already been reported as a big long time ago, but it seems to be still there, this is the only way around the situation, and it does not seem to have been resolved with MySQL 5.5.33-0+wheezy1

Leave a Reply

Your email address will not be published.