Configuration Group DB Load Fails If Datastore Version is Inactive

Bug #1379563 reported by Auston McReynolds
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Fix Released
Medium
Auston McReynolds

Bug Description

trove-manage db_load_datastore_config_parameters will fail if the datastore_version on which it's being run is marked as inactive (aka active is set to 0).

this is not correct, because it's completely reasonable to want to update/refresh a datastore_version's configuration-group's parameters even if it's inactive.

examples:
- you're rolling out a new datastore_version, so you have it marked as active=0 until your launch date.
- you've rolled out a new datastore_version, and you want to deactivate the old datastore_version. instances built prior to the deactivate are still on the old_version, and can still utilize their configuration-groups, hence the parameters should be update'able by the admin/cloud provider.

how to reproduce:

sudo /usr/local/bin/trove-manage --config-file=/etc/trove/trove.conf datastore_version_update mysql 5.5 mysql 1-2-3-4 "mysql-server-5.5" 0

sudo /usr/local/bin/trove-manage db_load_datastore_config_parameters mysql 5.5 /opt/stack/trove/trove/templates/mysql/validation-rules.json

summary: - Configuration Group Load Fails If Datastore Version is Inactive
+ Configuration Group DB Load Fails If Datastore Version is Inactive
Changed in trove:
importance: Undecided → Medium
milestone: none → kilo-1
status: New → Triaged
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

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

Changed in trove:
assignee: nobody → Auston McReynolds (amcrn)
status: Triaged → In Progress
description: updated
Changed in trove:
milestone: kilo-1 → kilo-2
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/129145
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=7d26dfe906f3509c48fa7a14048e742c6d7268cb
Submitter: Jenkins
Branch: master

commit 7d26dfe906f3509c48fa7a14048e742c6d7268cb
Author: amcrn <email address hidden>
Date: Thu Oct 16 23:14:20 2014 -0700

    Config Group Load Fails If DS Version Inactive

    trove-manage db_load_datastore_config_parameters will fail if
    the datastore_version on which it's being run is marked as
    inactive (aka active is set to 0).

    this is not correct, because it's completely reasonable to want
    to update/refresh a datastore_version's configuration-group's
    parameters even if it's inactive.

    examples:
    - you're working on rolling out a new datastore_version, so
      you have it marked as active=0 until the go-live date.
    - you've rolled out a new datastore_version and want to
      mark the old version as inactive. instances built prior
      to the inactivation are still on the old version, and
      can still utilize their still-assigned configuration-groups,
      hence the parameters should be updateable by the
      administrator.

    Change-Id: I7682fe240c5737438b084d813cf7ce80b4ecca9b
    Closes-Bug: #1379563

Changed in trove:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in trove:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in trove:
milestone: kilo-2 → 2015.1.0
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.