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
--
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
