All geek questions in one place

MySQL Rails migration error: "Error renaming schema_migration (errno: -1)"

I am a PHP developer and I am new to Rails, but everything is fine, everything looks pretty simple. However, until this morning I used SQLite and decided to move what I am creating for MySQL. rake db: create works fine, but when I try rake db: migrate, I get the following error:

rake is interrupted! Mysql :: Error: rename error "./test_development/schema_migrations' to './test_development/#sql2-c7b-c' (errno: -1): CREATE UNIQUE INDEX unique_schema_migrationsON. schema_migrations( version)

Thinking it might be a mistake in my migration scripts, I created a clean rails project with simple tables and got the same error. So, I reinstalled MySQL and the mysql gem to make sure that this is not something bad with one of them, and I still have no luck. Here are the versions I'm running:

  • Rails 2.3.4
  • Ruby 1.8.6
  • MySQL 5.1.40
  • MySQL Gem 2.8.1

I have a feeling that this could be due to InnoDB, as I had problems with this engine before on this box. But, if anyone can help me, I would be extremely grateful, as this prevented me from progressing.

Thanks,

Kieran

UPDATE: At the request of Phil, here are the results:

TO SHOW INNODB STATUS ENGINE

and

SHOW VARIABLES AS "innodb%"

+3
1

innodb_force_recovery 6. , -, 0 . InnoDB , SELECT, CREATE TABLE DROP TABLE.

MySQL my.cnf. innodb_force_recovery 0 ( ), MySQL.

+4

Source: https://habr.com/ru/post/1722255/

More articles:


All Articles