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

i using oracle mysql 5.0.88 in centos 5.7 (64-bit). when trying create index tables means shows

mysql> create index activity_type_id on activity_log (activity_type_id); error 1025 (hy000): error on rename of './sample_production/activity_log' './sample_production/#sql2-665c-7' (errno: -1)

it's difficult search error number. please me out why error happens.

according this problem may related innodb_force_recovery setting.

run check if it's set 0 or not:

 show variables 'innodb_force_recovery';