My guess is that primary key index is corrupted. Try REPAIR TABLE rates (if it's a MYISAM table.)

Another thing to try is to re-create the table, and see if you still have the problem.