API tools faq
paste
Guest User

Untitled

a guest
Aug 13th, 2015
286
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.71 KB | None | 0 0
raw download clone embed print report
  1. 2015-08-13 14:21:57.919 ERROR oslo_db.sqlalchemy.exc_filters [req-b7c07869-514e-4499-8586-189c853910d6 admin demo] DBAPIError exception wrapped from (_mysql_exceptions.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3") [SQL: u'SELECT qos_policies.tenant_id AS qos_policies_tenant_id, qos_policies.id AS qos_policies_id, qos_policies.name AS qos_policies_name, qos_policies.description AS qos_policies_description, qos_policies.shared AS qos_policies_shared \nFROM qos_policies \nWHERE qos_policies.name = %s'] [parameters: ([u'test'],)]
  2. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  3. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  4. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters context)
  5. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  6. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
  7. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
  8. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters self.errorhandler(self, exc, value)
  9. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  10. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass, errorvalue
  11. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3")
  12. 2015-08-13 14:21:57.919 15816 ERROR oslo_db.sqlalchemy.exc_filters
  13. 2015-08-13 14:21:57.921 ERROR neutron.api.v2.resource [req-b7c07869-514e-4499-8586-189c853910d6 admin demo] index failed
  14. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource Traceback (most recent call last):
  15. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/api/v2/resource.py", line 83, in resource
  16. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource result = method(request=request, **args)
  17. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/api/v2/base.py", line 334, in index
  18. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource return self._items(request, True, parent_id)
  19. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/api/v2/base.py", line 261, in _items
  20. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource obj_list = obj_getter(request.context, **kwargs)
  21. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/db/db_base_plugin_common.py", line 49, in inner_filter
  22. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource result = f(*args, **kwargs)
  23. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/db/db_base_plugin_common.py", line 35, in inner
  24. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource result = f(*args, **kwargs)
  25. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/services/qos/qos_plugin.py", line 83, in get_policies
  26. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource return policy_object.QosPolicy.get_objects(context, **filters)
  27. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/objects/qos/policy.py", line 96, in get_objects
  28. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource **kwargs)
  29. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/objects/base.py", line 113, in get_objects
  30. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource db_objs = db_api.get_objects(context, cls.db_model, **kwargs)
  31. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/.autodirect/mtrswgwork/moshele/openstack/neutron/neutron/db/api.py", line 108, in get_objects
  32. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource .filter_by(**kwargs)
  33. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2399, in all
  34. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource return list(self)
  35. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2516, in __iter__
  36. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource return self._execute_and_instances(context)
  37. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2531, in _execute_and_instances
  38. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource result = conn.execute(querycontext.statement, self._params)
  39. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
  40. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource return meth(self, multiparams, params)
  41. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  42. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params)
  43. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  44. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource compiled_sql, distilled_params
  45. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  46. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource context)
  47. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  48. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource util.raise_from_cause(newraise, exc_info)
  49. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
  50. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb)
  51. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  52. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource context)
  53. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  54. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource cursor.execute(statement, parameters)
  55. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
  56. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource self.errorhandler(self, exc, value)
  57. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  58. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource raise errorclass, errorvalue
  59. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource DBError: (_mysql_exceptions.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3") [SQL: u'SELECT qos_policies.tenant_id AS qos_policies_tenant_id, qos_policies.id AS qos_policies_id, qos_policies.name AS qos_policies_name, qos_policies.description AS qos_policies_description, qos_policies.shared AS qos_policies_shared \nFROM qos_policies \nWHERE qos_policies.name = %s'] [parameters: ([u'test'],)]
  60. 2015-08-13 14:21:57.921 15816 ERROR neutron.api.v2.resource
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!