Sort flavors with tenant_id return 500

[Hongbin Lu]

I tried to list flavors with 'tenant_id' as a sort key and neutron server returned 500 response. I expected the response to be 4xx.

  $ openstack network flavor create --service-type L3_ROUTER_NAT dummy-flavor
  $ openstack network flavor create --service-type L3_ROUTER_NAT dummy-flavor2
  $ curl -g -i -X GET "http://127.0.0.1:9696/v2.0/flavors?sort_dir=asc&sort_key=tenant_id" -H "Accept: application/json" -H "X-Auth-Token: $TOKEN"
  HTTP/1.1 500 Internal Server Error
  Content-Type: application/json
  Content-Length: 150
  X-Openstack-Request-Id: req-918c6f4d-97c8-4ebf-8d16-35621eac0cb8
  Date: Tue, 05 Jun 2018 19:05:55 GMT

  {"NeutronError": {"message": "Request Failed: internal server error while
  processing your request.", "type": "HTTPInternalServerError", "detail": ""}}

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/570821

[Hirofumi Ichihara (ichihara-hirofumi)]

I cannot reproduce the issue in my env(neutron master branch)

http://paste.openstack.org/show/722686/

[Hongbin Lu (hongbin.lu)]

@Hirofumi Ichihara,

If you do this http://paste.openstack.org/show/722751/ instead, could you reproduce the issue?

[Hirofumi Ichihara (ichihara-hirofumi)]

I can do it. thank you.

[OpenStack Infra (hudson-openstack)]

Change abandoned by boden (<email address hidden>) on branch: master
Review: https://review.opendev.org/570821
Reason: This patch has been stale for awhile now. Moving it to abandoned to clean-up the queue. If this patch is still active, please push an update to it.

[Brian Haley (brian-haley)]

Seems this has been fixed, closing.