[Expired for neutron because there has been no activity for 60 days.]
** Changed in: neutron
Status: Incomplete => Expired
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1575247
Title:
create_subnet takes O(N) time
Status in neutron:
Expired
Bug description:
Could this be part of the problem?
When creating a subnet, the network query appears to translate to:
67 Query SELECT networks.tenant_id AS networks_tenant_id, networks.id AS
networks_id, networks.name AS networks_name, networks.status AS
networks_status, networks.admin_state_up AS networks_admin_state_up,
networks.mtu AS networks_mtu, networks.vlan_transparent AS
networks_vlan_transparent, networks.availability_zone_hints AS
networks_availability_zone_hints, networks.standard_attr_id AS
networks_standard_attr_id, subnetpoolprefixes_1.cidr AS
subnetpoolprefixes_1_cidr, subnetpoolprefixes_1.subnetpool_id AS
subnetpoolprefixes_1_subnetpool_id, standardattributes_1.created_at AS
standardattributes_1_created_at, standardattributes_1.updated_at AS
standardattributes_1_updated_at, standardattributes_1.id AS
standardattributes_1_id, standardattributes_1.resource_type AS
standardattributes_1_resource_type, standardattributes_1.description AS
standardattributes_1_description, tags_1.standard_attr_id AS
tags_1_standard_attr_id, tags_1.tag AS tags_1_tag, subnetpools_1.tenant_id AS
subnetpools_1_tenant_id, subnetpools_1.id AS subnetpools_1_id,
subnetpools_1.name AS subnetpools_1_name, subnetpools_1.ip_version AS
subnetpools_1_ip_version, subnetpools_1.default_prefixlen AS
subnetpools_1_default_prefixlen, subnetpools_1.min_prefixlen AS
subnetpools_1_min_prefixlen, subnetpools_1.max_prefixlen AS
subnetpools_1_max_prefixlen, subnetpools_1.shared AS subnetpools_1_shared,
subnetpools_1.is_default AS subnetpools_1_is_default,
subnetpools_1.default_quota AS subnetpools_1_default_quota, subnetpools_1.hash
AS subnetpools_1_hash, subnetpools_1.address_scope_id AS
subnetpools_1_address_scope_id, subnetpools_1.standard_attr_id AS
subnetpools_1_standard_attr_id, ipallocationpools_1.id AS
ipallocationpools_1_id, ipallocationpools_1.subnet_id AS
ipallocationpools_1_subnet_id, ipallocationpools_1.first_ip AS
ipallocationpools_1_first_ip, ipallocationpools_1.last_ip AS
ipallocationpools_1_last_ip, dnsnameservers_1.address AS
dnsnameservers_1_address, dnsnameservers_1.subnet_id AS
dnsnameservers_1_subnet_id, dnsnameservers_1.`order` AS dnsnameservers_1_order,
subnetroutes_1.destination AS subnetroutes_1_destination,
subnetroutes_1.nexthop AS subnetroutes_1_nexthop, subnetroutes_1.subnet_id AS
subnetroutes_1_subnet_id, networkrbacs_1.tenant_id AS networkrbacs_1_tenant_id,
networkrbacs_1.id AS networkrbacs_1_id, networkrbacs_1.target_tenant AS
networkrbacs_1_target_tenant, networkrbacs_1.action AS networkrbacs_1_action,
networkrbacs_1.object_id AS networkrbacs_1_object_id,
standardattributes_2.created_at AS standardattributes_2_created_at,
standardattributes_2.updated_at AS standardattributes_2_updated_at,
standardattributes_2.id AS standardattributes_2_id,
standardattributes_2.resource_type AS standardattributes_2_resource_type,
standardattributes_2.description AS standardattributes_2_description,
tags_2.standard_attr_id AS tags_2_standard_attr_id, tags_2.tag AS tags_2_tag,
subnets_1.tenant_id AS subnets_1_tenant_id, subnets_1.id AS subnets_1_id,
subnets_1.name AS subnets_1_name, subnets_1.network_id AS subnets_1_network_id,
subnets_1.subnetpool_id AS subnets_1_subnetpool_id, subnets_1.ip_version AS
subnets_1_ip_version, subnets_1.cidr AS subnets_1_cidr, subnets_1.gateway_ip AS
subnets_1_gateway_ip, subnets_1.enable_dhcp AS subnets_1_enable_dhcp,
subnets_1.ipv6_ra_mode AS subnets_1_ipv6_ra_mode, subnets_1.ipv6_address_mode
AS subnets_1_ipv6_address_mode, subnets_1.standard_attr_id AS
subnets_1_standard_attr_id, networkrbacs_2.tenant_id AS
networkrbacs_2_tenant_id, networkrbacs_2.id AS networkrbacs_2_id,
networkrbacs_2.target_tenant AS networkrbacs_2_target_tenant,
networkrbacs_2.action AS networkrbacs_2_action, networkrbacs_2.object_id AS
networkrbacs_2_object_id, agents_1.id AS agents_1_id, agents_1.agent_type AS
agents_1_agent_type, agents_1.`binary` AS agents_1_binary, agents_1.topic AS
agents_1_topic, agents_1.host AS agents_1_host, agents_1.availability_zone AS
agents_1_availability_zone, agents_1.admin_state_up AS agents_1_admin_state_up,
agents_1.created_at AS agents_1_created_at, agents_1.started_at AS
agents_1_started_at, agents_1.heartbeat_timestamp AS
agents_1_heartbeat_timestamp, agents_1.description AS agents_1_description,
agents_1.configurations AS agents_1_configurations, agents_1.resource_versions
AS agents_1_resource_versions, agents_1.`load` AS agents_1_load,
standardattributes_3.created_at AS standardattributes_3_created_at,
standardattributes_3.updated_at AS standardattributes_3_updated_at,
standardattributes_3.id AS standardattributes_3_id,
standardattributes_3.resource_type AS standardattributes_3_resource_type,
standardattributes_3.description AS standardattributes_3_description,
tags_3.standard_attr_id AS tags_3_standard_attr_id, tags_3.tag AS tags_3_tag,
externalnetworks_1.network_id AS externalnetworks_1_network_id,
externalnetworks_1.is_default AS externalnetworks_1_is_default,
networksecuritybindings_1.network_id AS networksecuritybindings_1_network_id,
networksecuritybindings_1.port_security_enabled AS
networksecuritybindings_1_port_security_enabled,
qos_network_policy_bindings_1.policy_id AS
qos_network_policy_bindings_1_policy_id,
qos_network_policy_bindings_1.network_id AS
qos_network_policy_bindings_1_network_id
FROM networks LEFT OUTER JOIN externalnetworks ON networks.id =
externalnetworks.network_id LEFT OUTER JOIN subnets AS subnets_1 ON networks.id
= subnets_1.network_id LEFT OUTER JOIN subnetpools AS subnetpools_1 ON
subnets_1.subnetpool_id = subnetpools_1.id LEFT OUTER JOIN subnetpoolprefixes
AS subnetpoolprefixes_1 ON subnetpools_1.id =
subnetpoolprefixes_1.subnetpool_id LEFT OUTER JOIN standardattributes AS
standardattributes_1 ON standardattributes_1.id =
subnetpools_1.standard_attr_id LEFT OUTER JOIN tags AS tags_1 ON
standardattributes_1.id = tags_1.standard_attr_id LEFT OUTER JOIN
ipallocationpools AS ipallocationpools_1 ON subnets_1.id =
ipallocationpools_1.subnet_id LEFT OUTER JOIN dnsnameservers AS
dnsnameservers_1 ON subnets_1.id = dnsnameservers_1.subnet_id LEFT OUTER JOIN
subnetroutes AS subnetroutes_1 ON subnets_1.id = subnetroutes_1.subnet_id LEFT
OUTER JOIN networkrbacs AS networkrbacs_1 ON subnets_1.network_id =
networkrbacs_1.object_id LEFT OUTER JOIN standardattributes AS
standardattributes_2 ON standardattributes_2.id = subnets_1.standard_attr_id
LEFT OUTER JOIN tags AS tags_2 ON standardattributes_2.id =
tags_2.standard_attr_id LEFT OUTER JOIN networkrbacs AS networkrbacs_2 ON
networks.id = networkrbacs_2.object_id LEFT OUTER JOIN
(networkdhcpagentbindings AS networkdhcpagentbindings_1 INNER JOIN agents AS
agents_1 ON agents_1.id = networkdhcpagentbindings_1.dhcp_agent_id) ON
networks.id = networkdhcpagentbindings_1.network_id LEFT OUTER JOIN
standardattributes AS standardattributes_3 ON standardattributes_3.id =
networks.standard_attr_id LEFT OUTER JOIN tags AS tags_3 ON
standardattributes_3.id = tags_3.standard_attr_id LEFT OUTER JOIN
externalnetworks AS externalnetworks_1 ON networks.id =
externalnetworks_1.network_id LEFT OUTER JOIN networksecuritybindings AS
networksecuritybindings_1 ON networks.id = networksecuritybindings_1.network_id
LEFT OUTER JOIN qos_network_policy_bindings AS qos_network_policy_bindings_1 ON
networks.id = qos_network_policy_bindings_1.network_id
WHERE networks.id = 'b51ecade-9f8f-4f38-b045-a84e96a4e13a' ORDER BY
dnsnameservers_1.`order`
Is this complexity really necessary?
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1575247/+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
