yahoo-eng-team team mailing list archive

[Launchpad Bug Tracker <1321044@xxxxxxxxxxxxxxxxxx>]

[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/1321044

Title:
  IPv6 availability ranges now grow without bounds

Status in neutron:
  Expired

Bug description:
  Thanks to the new method of lazily recycling IPs introduced in
  Ia55b66128de9986e075b0f87acc401d211cd91d3 the allocation availability
  range tables in the database grow without any bounds and result in a
  *huge* performance impact on neutron's overall functionality.

  Case in point, this is the db contents after creating and destroying 5
  VMs with IPv6 addresses:

  mysql> select * from ipavailabilityranges where allocation_pool_id in ('10f63364-0541-4b55-8372-582bcfa25cdc','06399db3-6212-42ec-bcaa-919b5ec48e73');
  +--------------------------------------+---------------------------------------+---------------------------------------+
  | allocation_pool_id                   | first_ip                              | last_ip                               |
  +--------------------------------------+---------------------------------------+---------------------------------------+
  | 06399db3-6212-42ec-bcaa-919b5ec48e73 | 2607:f298:7000:9e::2                  | 2607:f298:7000:9e:f816:3eff:fe12:396f |
  | 06399db3-6212-42ec-bcaa-919b5ec48e73 | 2607:f298:7000:9e:f816:3eff:fe12:3971 | 2607:f298:7000:9e:f816:3eff:fe14:24ed |
  | 06399db3-6212-42ec-bcaa-919b5ec48e73 | 2607:f298:7000:9e:f816:3eff:fe14:24ef | 2607:f298:7000:9e:f816:3eff:fe4a:4d15 |
  | 06399db3-6212-42ec-bcaa-919b5ec48e73 | 2607:f298:7000:9e:f816:3eff:fe4a:4d17 | 2607:f298:7000:9e:f816:3eff:fe97:9c7e |
  | 06399db3-6212-42ec-bcaa-919b5ec48e73 | 2607:f298:7000:9e:f816:3eff:fe97:9c80 | 2607:f298:7000:9e:f816:3eff:fec1:cfa0 |
  | 06399db3-6212-42ec-bcaa-919b5ec48e73 | 2607:f298:7000:9e:f816:3eff:fec1:cfa2 | 2607:f298:7000:9e:ffff:ffff:ffff:fffe |
  | 10f63364-0541-4b55-8372-582bcfa25cdc | 10.10.10.148                          | 10.10.10.254                          |
  +--------------------------------------+---------------------------------------+---------------------------------------+

  
  Because these ranges are checked while doing such things as "neutron net-list", this pretty quickly becomes a large performance problem.  After this change was applied, just a couple of days of creating and destroying VMs via automated testing caused the time it took for an admin to run "neutron net-list" to go from just a couple of seconds to over 20 seconds.

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