yahoo-eng-team team mailing list archive

[Zheng Xi Zhou <zzxwill@xxxxxxxxx>]

Public bug reported:

The column 'id' fro table 'instance_types' in database 'nova' is auto-
increased.

MariaDB [nova]> desc instance_types
    -> ;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+

| id           | int(11)      | NO   | PRI | NULL    | auto_increment |

+--------------+--------------+------+-----+---------+----------------+

While in the operation 'create flavor', the default value of 'id' is
'auto', which doesn't mean to be 'AUTO_INCREMENT', instead it generate a
GUID for it, like '0257d5be-821e-4cdd-ad2c-45139e067aad'.

So the database table design doesn't align with the operation in
Horizon. This should be fixed? Thanks.

** Affects: nova
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1569283

Title:
  Table column doesn't align with the operation in Horizon

Status in OpenStack Compute (nova):
  New

Bug description:
  The column 'id' fro table 'instance_types' in database 'nova' is auto-
  increased.

  MariaDB [nova]> desc instance_types
      -> ;
  +--------------+--------------+------+-----+---------+----------------+
  | Field        | Type         | Null | Key | Default | Extra          |
  +--------------+--------------+------+-----+---------+----------------+

  | id           | int(11)      | NO   | PRI | NULL    | auto_increment
  |

  +--------------+--------------+------+-----+---------+----------------+

  While in the operation 'create flavor', the default value of 'id' is
  'auto', which doesn't mean to be 'AUTO_INCREMENT', instead it generate
  a GUID for it, like '0257d5be-821e-4cdd-ad2c-45139e067aad'.

  So the database table design doesn't align with the operation in
  Horizon. This should be fixed? Thanks.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1569283/+subscriptions