Public bug reported:
In neutron/db/quota_db, Quota table has an index for tenant_id,
but db migration script does not create it.
This affects all plugins which create quotas table with db migration.
For example, quotas for nec plugin after db migration (upgrade head) is:
$ mysql neutron_nec -e 'show create table quotas;'
| quotas | CREATE TABLE `quotas` (
`id` varchar(36) NOT NULL,
`tenant_id` varchar(255) DEFAULT NULL,
`resource` varchar(255) DEFAULT NULL,
`limit` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
neutron/db/quota_db.py:
class Quota(model_base.BASEV2, models_v2.HasId):
"""Represent a single quota override for a tenant.
If there is no row for a given tenant id and resource, then the
default for the quota class is used.
"""
tenant_id = sa.Column(sa.String(255), index=True)
resource = sa.Column(sa.String(255))
limit = sa.Column(sa.Integer)
** Affects: neutron
Importance: Low
Assignee: Akihiro Motoki (amotoki)
Status: New
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1277061
Title:
db migration does not create tenant_id index of quotas table
Status in OpenStack Neutron (virtual network service):
New
Bug description:
In neutron/db/quota_db, Quota table has an index for tenant_id,
but db migration script does not create it.
This affects all plugins which create quotas table with db migration.
For example, quotas for nec plugin after db migration (upgrade head)
is:
$ mysql neutron_nec -e 'show create table quotas;'
| quotas | CREATE TABLE `quotas` (
`id` varchar(36) NOT NULL,
`tenant_id` varchar(255) DEFAULT NULL,
`resource` varchar(255) DEFAULT NULL,
`limit` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
neutron/db/quota_db.py:
class Quota(model_base.BASEV2, models_v2.HasId):
"""Represent a single quota override for a tenant.
If there is no row for a given tenant id and resource, then the
default for the quota class is used.
"""
tenant_id = sa.Column(sa.String(255), index=True)
resource = sa.Column(sa.String(255))
limit = sa.Column(sa.Integer)
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1277061/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
