External constraint key error when DB migration.
Please tell me the corresponding means.
# bin/rails db:migrate RAILS_ENV=development
== 20190411084473 CreateScriptRevisions: migrating ============================
-- create_table(:script_revisions)
rails aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Cannot add foreign key constraint: CREATE TABLE `kuroko2_script_revisions` (`id` int AUTO_INCREMENT PRIMARY KEY, `job_definition_id` int NOT NULL, `script` text NOT NULL, `user_id` int, `changed_at` datetime NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, INDEX `index_kuroko2_script_revisions_on_job_definition_id` (`job_definition_id`), INDEX `index_kuroko2_script_revisions_on_user_id` (`user_id`), CONSTRAINT `fk_rails_753524e5bd`
FOREIGN KEY (`job_definition_id`)
REFERENCES `kuroko2_job_definitions` (`id`)
, CONSTRAINT `fk_rails_4a096a63c7`
FOREIGN KEY (`user_id`)
REFERENCES `kuroko2_users` (`id`)
) ENGINE=InnoDB
/opt/my_kuroko2/db/migrate/20190411084473_create_script_revisions.kuroko2.rb:4:in `up'
/opt/my_kuroko2/bin/rails:9:in `require'
/opt/my_kuroko2/bin/rails:9:in `<top (required)>'
/opt/my_kuroko2/bin/spring:15:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Cannot add foreign key constraint: CREATE TABLE `kuroko2_script_revisions` (`id` int AUTO_INCREMENT PRIMARY KEY, `job_definition_id` int NOT NULL, `script` text NOT NULL, `user_id` int, `changed_at` datetime NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, INDEX `index_kuroko2_script_revisions_on_job_definition_id` (`job_definition_id`), INDEX `index_kuroko2_script_revisions_on_user_id` (`user_id`), CONSTRAINT `fk_rails_753524e5bd`
FOREIGN KEY (`job_definition_id`)
REFERENCES `kuroko2_job_definitions` (`id`)
, CONSTRAINT `fk_rails_4a096a63c7`
FOREIGN KEY (`user_id`)
REFERENCES `kuroko2_users` (`id`)
) ENGINE=InnoDB
/opt/my_kuroko2/db/migrate/20190411084473_create_script_revisions.kuroko2.rb:4:in `up'
/opt/my_kuroko2/bin/rails:9:in `require'
/opt/my_kuroko2/bin/rails:9:in `<top (required)>'
/opt/my_kuroko2/bin/spring:15:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Caused by:
Mysql2::Error: Cannot add foreign key constraint
/opt/my_kuroko2/db/migrate/20190411084473_create_script_revisions.kuroko2.rb:4:in `up'
/opt/my_kuroko2/bin/rails:9:in `require'
/opt/my_kuroko2/bin/rails:9:in `<top (required)>'
/opt/my_kuroko2/bin/spring:15:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)