ERROR 1025 (HY000): Error on rename of .. (errno: -1)

Question

I am using Oracle MySQL 5.0.88 in CentOS 5.7 (64-bit). When i am trying to create an index to the tables means it shows

mysql> CREATE INDEX activity_type_id ON activity_log (activity_type_id); ERROR 1025 (HY000): Error on rename of './sample_production/activity_log' to './sample_production/#sql2-665c-7' (errno: -1)

it's some what difficult to search with the error number. Please help me out why this error happens.

score 5 · Accepted Answer · answered May 03 '13 at 09:15

5

According to this the problem may be related to innodb_force_recovery setting.

Run this to check if it's set to zero or not:

 SHOW VARIABLES LIKE 'innodb_force_recovery';

answered May 03 '13 at 09:15

Sam R.

16,027
12
69
122

score 0 · Answer 2 · answered May 03 '13 at 07:43

0

You might have a foreign key relation on that index. Then InnoDB doesn't let you do so. First of all, remove the foreign key first which is gonna remove the index anyway. More information about the error 1025 check out here.

answered May 03 '13 at 07:43

medina

8,051
4
25
24

In my database there is only 1 table is there. – Bathakarai May 03 '13 at 08:02

score 0 · Answer 3 · answered Aug 28 '13 at 05:51

0

I was getting a very similar error. In the end I discovered that SELinux was blocking me from making any changes to my tables. After adjusting the SELinux rules all is OK again.

answered Aug 28 '13 at 05:51

daamsie

1,539
10
15

ERROR 1025 (HY000): Error on rename of .. (errno: -1)

3 Answers3