Rails db:schema:load error: Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails

Question

so I want to switch the database for a reasonably advanced Rails project - I can connect to the DB etc and rails db:prepare worked without errors. However rails db:schema:load resulted in

Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails
The problem is, it's not telling me a lot more. It gives these lines in addition:
/../db/schema.rb:25:in `block in <main>'
/../db/schema.rb:13:in `<main>'
/../bin/rails:5:in `<top (required)>'
/../bin/spring:10:in `block in <top (required)>'
/../bin/spring:7:in `<top (required)>'

Line 13 is the start of the code (comments in the lines before), and line 25 has this:

create_table "active_storage_blobs", charset: "utf8mb4", force: :cascade do |t|

How do I trace what is wrong here? BTW the --trace option didn't help

Looks like this helps stackoverflow.com/questions/43025173/… — dbugger
– dbugger, Commented Dec 4, 2021 at 3:06

tkhobbes · Accepted Answer · 2021-12-05 12:11:14Z

0

For reference: The problem was the acts-as-taggable-on GEM, or more specifically, the line I put into the initializer to enable special characters:

ActsAsTaggableOn.force_binary_collation = true

Commenting this out - and everything works! :)

answered Dec 5, 2021 at 12:11

tkhobbes

6927 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails db:schema:load error: Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related