glance-manage db load_metadefs will fail if DB is not empty

Bug #1367771 reported by Pawel Koniszewski
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Glance
Fix Released
High
Pawel Koniszewski

Bug Description

To insert data into DB 'glance-manage db load_metadefs' uses IDs for namespaces which are generated by built-in function in Python - enumerate:

for namespace_id, json_schema_file in enumerate(json_schema_files, start=1):

For empty database it works fine, but this causes problems when there are already metadata namespaces in database. The problem is that when there are already metadata definitions in DB then every invoke of glance-manage db load_metadefs leads to IntegrityErrors because of duplicated IDs.

There are two approaches to fix this:
1. Ask for a namespace just after inserting it. Unfortunately in current implementation we need to do one more query.
2. When this go live - https://review.openstack.org/#/c/120414/ - then we won't need to do another query, because ID is available just after inserting a namespace to DB (namespace.save(session=session)).

Changed in glance:
status: New → In Progress
assignee: nobody → Pawel Koniszewski (pawel-koniszewski)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to glance (master)

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

tags: added: metadef
Changed in glance:
assignee: Pawel Koniszewski (pawel-koniszewski) → Bartosz Fic (bartosz-fic)
Changed in glance:
assignee: Bartosz Fic (bartosz-fic) → Pawel Koniszewski (pawel-koniszewski)
Thierry Carrez (ttx)
Changed in glance:
milestone: none → juno-rc2
importance: Undecided → High
Thierry Carrez (ttx)
Changed in glance:
milestone: juno-rc2 → none
tags: added: juno-rc-potential
Thierry Carrez (ttx)
Changed in glance:
milestone: none → juno-rc2
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to glance (master)

Reviewed: https://review.openstack.org/120432
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=89c04904416270d3c306d430f443a7127c5fc206
Submitter: Jenkins
Branch: master

commit 89c04904416270d3c306d430f443a7127c5fc206
Author: Bartosz Fic <email address hidden>
Date: Tue Oct 7 18:13:51 2014 +0200

    Use ID for namespace generated by DB

    In current implementation ID that is used in namespace to
    insert data to DB is generated by built-in function - enumerate.
    This causes problems with loading the metadata when there are already
    namespaces in DB.

    This patch removes 'enumerate' and asks for namespace ID
    generated by database.

    Change-Id: I235c6310077526cafb898ac007c3601b4d66c9fe
    Closes-Bug: #1367771
    Co-Authored-By: Bartosz Fic <email address hidden>
    Co-Authored-By: Pawel Koniszewski <email address hidden>

Changed in glance:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to glance (proposed/juno)

Fix proposed to branch: proposed/juno
Review: https://review.openstack.org/126856

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to glance (proposed/juno)

Reviewed: https://review.openstack.org/126856
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=76c66343a45cba0068c97d1ad21b46c63977e13d
Submitter: Jenkins
Branch: proposed/juno

commit 76c66343a45cba0068c97d1ad21b46c63977e13d
Author: Bartosz Fic <email address hidden>
Date: Tue Oct 7 18:13:51 2014 +0200

    Use ID for namespace generated by DB

    In current implementation ID that is used in namespace to
    insert data to DB is generated by built-in function - enumerate.
    This causes problems with loading the metadata when there are already
    namespaces in DB.

    This patch removes 'enumerate' and asks for namespace ID
    generated by database.

    Closes-Bug: #1367771
    Co-Authored-By: Bartosz Fic <email address hidden>
    Co-Authored-By: Pawel Koniszewski <email address hidden>
    (cherry picked from commit 89c04904416270d3c306d430f443a7127c5fc206)

    Conflicts:
     glance/db/sqlalchemy/metadata.py

    Change-Id: I235c6310077526cafb898ac007c3601b4d66c9fe

Changed in glance:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in glance:
milestone: juno-rc2 → 2014.2
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to glance (master)

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

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to glance (master)
Download full text (14.4 KiB)

Reviewed: https://review.openstack.org/128928
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=858cd9d4fdf32b4cc52e02ec771d01bfb463aa77
Submitter: Jenkins
Branch: master

commit 96e28428655aa7122ed74b045ff1bda1984255b1
Author: Nikhil Komawar <email address hidden>
Date: Tue Oct 14 13:09:48 2014 -0400

    Fix options and their groups - etc/glance-api.conf

    As per the docs at [0] , some of the options should have been moved
    around in the etc/glance-api.conf. This patch changes the conf file to:

        1. indicate new default values
        2. change the group of some of the configs in order to adhere to
           new groups as expected by the deployer.
        3. deprecated configs have been removed or replaced with new ones.

    [0] http://docs.openstack.org/trunk/config-reference/content/glance-conf-changes-master.html

    Fixes bug: 1380689

    Change-Id: I5b5ab96b050b502007e6660a7a613e252404d4e8

commit 9b176a278116849c8f7b7f4d9a987f37ec52779c
Author: Andy McCrae <email address hidden>
Date: Sat Oct 11 20:56:36 2014 +0100

    Adjust authentication.rst doc to reference "identity_uri"

    The "auth_port", "auth_host", and "auth_protocol" variables were
    deprecated in favour of a single "identity_uri" variable.

    * Adjust authentication.rst doc to reference "identity_uri"

    Change-Id: I48de53f21b8d767b276858ed274066015d765f0e
    Closes-Bug: #1361613

commit 08f83f543bc992ae8f2787fb405e58c33dadba73
Author: Jamie Lennox <email address hidden>
Date: Wed Aug 6 18:24:05 2014 +1000

    Use identity_uri instead of older fragments

    This has been the default option in middleware for a while now and we
    should recommend the default options.

    Change-Id: Ief347c897cf15ab4101936a56404e3a378021b15
    (cherry picked from commit e7110a9c6e0119b3d0c6f5cdb3b9675a82b76039)

commit c0d90a580f87dbbf71e3a5d5c1b5cf8d7c7245b2
Author: Stuart McLaren <email address hidden>
Date: Wed Jul 16 13:33:32 2014 +0000

    Prevent setting swift+config locations

    Forbid setting 'swift+config' locations in a similar
    manner to 'file' for security reasons; knowledge of
    the reference name should not be exploitable.

    Setting swift+config had been prevented when swift
    was the default store, this patch changes to forbid
    setting no matter which store is the default.

    As with change id I75af34145521f533dcd6f5fd7690f5a68f3b44b3
    this is v1 only for now.

    Change-Id: I62c4980bd5c2f3dd77fc40cd007bc1067eca63a4
    Closes-bug: 1334196

commit f259cac74d3e988b4012dcc2abd30091df27f5ce
Author: Wayne Okuma <email address hidden>
Date: Wed Oct 8 08:17:20 2014 -0700

    Metadef schema column name is a reserved word in MySQL

    The metadef_properties and metadef_objects tables both have
    a column named schema. Unfortunately, schema is a reserved word
    in some relational database products, including MySQL and PostgreSQL.
    The metadef_properties.schema and metadef_objects.schema
    columns should be renamed to a non reserved word.

    Conflicts:
     glance/db/sqlalchemy/metadata.py
     glance/tests/unit/test_m...

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.