yahoo-eng-team team mailing list archive

[Akihiro Motoki <1277061@xxxxxxxxxxxxxxxxxx>]

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