MySQL engine doesn't specified at a table s with foreign key constraint.

Bug #1398748 reported by Ilya Pekelny
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Identity (keystone)
Invalid
Low
Unassigned

Bug Description

By default the CI uses MyISAM MySQL engine which doesn't support foreign key constraint. Thus we must explicitly sign MySQL engine as InnoDB at every table declares foreign keys or which is a fk target. Otherwise foreign keys can't be declared.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to keystone (master)

Fix proposed to branch: master
Review: https://review.openstack.org/138712

Changed in keystone:
assignee: nobody → Ilya Pekelny (i159)
status: New → In Progress
Revision history for this message
David Stanek (dstanek) wrote :

Is this something we actually want to do? After reading the comment from jeblair the decision to use MyISAM is deliberate. This seems to be a deployment concern. I don't know if it's practical, but maybe someone is already using an alternative storage engine like IBMDB2I?

Changed in keystone:
importance: Undecided → Low
Revision history for this message
Dolph Mathews (dolph) wrote :

I've abandoned the referenced changed due to inactivity and failing tests. If this is still an issue, please reset the status.

Changed in keystone:
status: In Progress → Incomplete
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on keystone (master)

Change abandoned by Dolph Mathews (<email address hidden>) on branch: master
Review: https://review.openstack.org/138712
Reason: Abandoning due to inactivity and failing tests.

Revision history for this message
Morgan Fainberg (mdrnstm) wrote :

Marking as invalid since this should have expired as incomplete long ago.

Changed in keystone:
assignee: Ilya Pekelny (i159) → nobody
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.