Resource primary key should not be a UUID

Bug #1415237 reported by Zane Bitter
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Heat
Fix Released
Medium
Angus Salkeld

Bug Description

We switched most database tables over to having auto-incrementing integers as primary keys. These are used for all references between tables in the database, while UUIDs are used for user-facing identification of objects. However the Resource table still uses a UUID as a primary key. We want to switch this to an auto-incrementing integer, while leaving the UUID column in place (it is used e.g. to generate physical resource names).

Angus Salkeld (asalkeld)
Changed in heat:
milestone: kilo-2 → kilo-3
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to heat (master)

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

Changed in heat:
assignee: Tetiana Lashchova (tlashchova) → Angus Salkeld (asalkeld)
status: Triaged → In Progress
Changed in heat:
assignee: Angus Salkeld (asalkeld) → Oleksii Chuprykov (ochuprykov)
Changed in heat:
assignee: Oleksii Chuprykov (ochuprykov) → Angus Salkeld (asalkeld)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to heat (master)

Reviewed: https://review.openstack.org/159741
Committed: https://git.openstack.org/cgit/openstack/heat/commit/?id=eb8c81f8db5b34c7574ed0faa549f608d159bd32
Submitter: Jenkins
Branch: master

commit eb8c81f8db5b34c7574ed0faa549f608d159bd32
Author: Angus Salkeld <email address hidden>
Date: Tue Mar 10 13:08:05 2015 +1000

    Create an integer id for the resource table

    Move the old uuid "id" to a new column "uuid". The migration
    script is largely copied from the event_uuid_to_id script.

    This is needed for https://review.openstack.org/#/c/156693/

    Change-Id: Idf7adc9d01425592ec174c373b1b03626c3a0a1d
    Closes-bug: #1415237

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