yahoo-eng-team team mailing list archive

[Ihar Hrachyshka <1673427@xxxxxxxxxxxxxxxxxx>]

Fixed by https://review.openstack.org/#/c/446196/

** Changed in: devstack
       Status: New => Fix Released

** Changed in: neutron
       Status: New => Invalid

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

Title:
  mysql OOM ( Out of sort memory, consider increasing server sort buffer
  size )

Status in devstack:
  Fix Released
Status in neutron:
  Invalid

Bug description:
  Neutron fails with:

  http://logs.openstack.org/84/445884/2/gate/gate-neutron-dsvm-api-
  ubuntu-xenial/800e806/logs/screen-q-svc.txt.gz

  2017-03-15 21:02:19.418 30853 ERROR neutron.api.v2.resource DBError: (pymysql.err.InternalError) (1038, u'Out of sort memory, consider increasing server sort buffer size') [SQL: u'SELECT networks.id AS network_id, subnets.id AS subnet_id, subnets.cidr AS subnets_cidr, subnets.ip_version AS subnets_ip_version, networks.name AS network_name, networks.project_id AS networks_project_id, subnets.name AS subnet_name, count(ipallocations.subnet_id) AS used_ips \nFROM networks LEFT OUTER JOIN subnets ON networks.id = subnets.network_id LEFT OUTER JOIN ipallocations ON subnets.id = ipallocations.subnet_id GROUP BY networks.id, subnets.id, subnets.cidr, subnets.ip_version, networks.name, networks.project_id, subnets.name']
  2017-03-15 21:02:19.418 30853 ERROR neutron.api.v2.resource 

  
  So may we consider changing the sort buffer size?

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