@Zheng Xi, the GUID you saw is not the value of InstanceTypes.id but the value of InstanceTypes.flavorid, see[1]. PS: Now db table 'instance_types' is deprecated and will be removed in later release, please refer to [2].
[1]https://github.com/openstack/nova/blob/13.0.0.0rc3/nova/db/sqlalchemy/models.py#L409 [2]https://blueprints.launchpad.net/nova/+spec/flavor-instance-type-dedup ** Changed in: nova Status: Confirmed => Invalid -- 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): Invalid 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp

