yahoo-eng-team team mailing list archive

[Rodolfo Alonso <2024044@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

There are some tables where some primary key columns are also defined as
key (index). This redundant indexing is no necessary and could raise
SQLAlchemy errors.

These are the tables and columns affected:
* portdataplanestatuses, port_id
* portdnses, port_id
* portuplinkstatuspropagation, port_id
* qos_policies_default, project_id
* quotausages, resource
* subnet_dns_publish_fixed_ips, subnet_id

** Affects: neutron
     Importance: Medium
     Assignee: Rodolfo Alonso (rodolfo-alonso-hernandez)
         Status: New

** Changed in: neutron
     Assignee: (unassigned) => Rodolfo Alonso (rodolfo-alonso-hernandez)

** Changed in: neutron
   Importance: Undecided => Medium

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2024044

Title:
  [sqlalchemy-20] Remove redundant indexes of some tables

Status in neutron:
  New

Bug description:
  There are some tables where some primary key columns are also defined
  as key (index). This redundant indexing is no necessary and could
  raise SQLAlchemy errors.

  These are the tables and columns affected:
  * portdataplanestatuses, port_id
  * portdnses, port_id
  * portuplinkstatuspropagation, port_id
  * qos_policies_default, project_id
  * quotausages, resource
  * subnet_dns_publish_fixed_ips, subnet_id

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