yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1659175] [NEW] Hit internal error when query port with sort-key created_at

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: zhaobo <zhaobo6@xxxxxxxxxx>
Date: Wed, 25 Jan 2017 02:54:05 -0000
Reply-to: Bug 1659175 <1659175@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

Maybe our server not support query resources with created_at. This  is a
standard requirement.

cmd:
neutron port-list --sort-key created_at --sort-dir asc
Request Failed: internal server error while processing your request.
Neutron server returns request_ids: ['req-2da26481-ef77-4bf8-a83c-f0c412d2936c']


2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 88, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 151, in wrapper
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    ectxt.value = e.inner_exc
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 139, in wrapper
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 128, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    traceback.format_exc())
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 123, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*dup_args, **dup_kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/api/v2/base.py", line 369, in index
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return self._items(request, True, parent_id)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/api/v2/base.py", line 308, in _items
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    obj_list = obj_getter(request.context, **kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 163, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return method(*args, **kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 92, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    setattr(e, '_RETRY_EXCEEDED', True)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 88, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 151, in wrapper
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    ectxt.value = e.inner_exc
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 139, in wrapper
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 128, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    traceback.format_exc())
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 123, in wrapped
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*dup_args, **dup_kwargs)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1333, in get_ports
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    page_reverse=page_reverse)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1317, in _get_ports_query
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    sort_keys = db_utils.get_and_validate_sort_keys(sorts, Port)
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/utils.py", line 43, in get_and_validate_sort_keys
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    if isinstance(sort_key_attr.property,
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00mAttributeError: 'AssociationProxy' object has no attribute 'property'
2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m

** Affects: neutron
     Importance: Undecided
     Assignee: zhaobo (zhaobo6)
         Status: New

** Changed in: neutron
     Assignee: (unassigned) => zhaobo (zhaobo6)

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

Title:
  Hit internal error when query port with sort-key created_at

Status in neutron:
  New

Bug description:
  Maybe our server not support query resources with created_at. This  is
  a standard requirement.

  cmd:
  neutron port-list --sort-key created_at --sort-dir asc
  Request Failed: internal server error while processing your request.
  Neutron server returns request_ids: ['req-2da26481-ef77-4bf8-a83c-f0c412d2936c']


  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 88, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 151, in wrapper
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    ectxt.value = e.inner_exc
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 139, in wrapper
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 128, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    traceback.format_exc())
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 123, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*dup_args, **dup_kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/api/v2/base.py", line 369, in index
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return self._items(request, True, parent_id)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/api/v2/base.py", line 308, in _items
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    obj_list = obj_getter(request.context, **kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 163, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return method(*args, **kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 92, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    setattr(e, '_RETRY_EXCEEDED', True)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 88, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 151, in wrapper
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    ectxt.value = e.inner_exc
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 139, in wrapper
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*args, **kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 128, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    traceback.format_exc())
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    self.force_reraise()
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    six.reraise(self.type_, self.value, self.tb)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/api.py", line 123, in wrapped
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    return f(*dup_args, **dup_kwargs)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1333, in get_ports
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    page_reverse=page_reverse)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1317, in _get_ports_query
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    sort_keys = db_utils.get_and_validate_sort_keys(sorts, Port)
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m  File "/usr/local/lib/python2.7/dist-packages/neutron_lib/db/utils.py", line 43, in get_and_validate_sort_keys
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m    if isinstance(sort_key_attr.property,
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00mAttributeError: 'AssociationProxy' object has no attribute 'property'
  2017-01-25 09:42:59.830 TRACE neutron.api.v2.resource ^[[01;35m^[[00m

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

[Bug 1659175] Re: Hit internal error when using StandardAttribute as sort-key
From: OpenStack Infra, 2019-06-02