OpenStack DBaaS (Trove)

  1. Bug #1473226
  2. Comment #9

Comment 9 for bug 1473226

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

Reviewed: https://review.openstack.org/299568
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=679e2283ecc888bd567955b4bf431c87043e8d12
Submitter: Jenkins
Branch: master

commit 679e2283ecc888bd567955b4bf431c87043e8d12
Author: Victoria Martinez de la Cruz <email address hidden>
Date: Wed Mar 30 15:05:59 2016 -0300

    Fixes migrations for MySQL 5.6.* and MariaDB 10.1.*

    In MySQL 5.6/MariaDB 10.1 and later versions there was a change
    on the restrictions over foreign keys (FK).

    In 019-datastore-fix.py, we attempt to change a column that is part
    of a FK from NULL to not NULL. This sort of modifications are not
    longer allowed.

    This situation caused trove-manage db_sync and trove-manage db_migrate
    to fail.

    To workaround this, the FK check before executing the ALTER query
    is disabled and then reenabled.

    Change-Id: I666d01235f2c3225aca3fe7520ebdf6d53831cab
    Closes-Bug: #1473226