Public bug reported: 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? ** Affects: devstack Importance: Undecided Status: New ** Affects: neutron Importance: Medium Status: New ** Also affects: devstack Importance: Undecided Status: New ** 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/1673427 Title: mysql OOM ( Out of sort memory, consider increasing server sort buffer size ) Status in devstack: New Status in neutron: New 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
