The 'system-app' pod fails returning a MySQL error "Cannot delete or update a parent row: a foreign key constraint fails" on Red Hat 3scale API Management

Solution Verified - Updated -

Issue

When we roll out the 3scale template we get errors on our production deploy and our system app deploy similar to the ones below:

ActiveRecord::StatementInvalid: Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails: DROP TABLE `authentication_providers` CASCADE
...
Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails

Environment

  • Red Hat 3scale API Management
    • 2.X On-premises

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content