yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1841788] [NEW] neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin DBError

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Donny Davis <donny@xxxxxxxxxxxxxx>
Date: Wed, 28 Aug 2019 14:01:47 -0000
Reply-to: Bug 1841788 <1841788@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

It would appear that the bgp agent does not recognize translate
attributes


2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager [req-c5bda00a-2fb2-4f1e-8583-cfa842c97d30 1034301cea4d41c2ae979cc80d0c9221 44651bdb0d7a4d28adecd7653d39a38c - default default] Error during notification for neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin.port_callback--9223372036854769834 port, after_update: DBError: 'result' object has no attribute 'translate'
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager Traceback (most recent call last):
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_lib/callbacks/manager.py", line 197, in _notify_loop
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     callback(resource, event, trigger, **kwargs)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 376, in port_callback
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     routes = self.get_advertised_routes(ctx, bgp_speaker)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 225, in get_advertised_routes
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 315, in get_advertised_routes
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     routes = self.get_routes_by_bgp_speaker_id(context, bgp_speaker_id)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 477, in get_routes_by_bgp_speaker_id
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 864, in _get_tenant_network_routes_by_bgp_speaker
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 921, in _tenant_networks_by_bgp_speaker_query
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 470, in _get_address_scope_ids_for_bgp_speaker
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return [scope.id for scope in query.all()]
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2925, in all
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return list(self)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3081, in __iter__
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return self._execute_and_instances(context)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     result = conn.execute(querycontext.statement, self._params)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return meth(self, multiparams, params)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return connection._execute_clauseelement(self, multiparams, params)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     distilled_params,
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     e, statement, parameters, cursor, context
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     util.raise_from_cause(newraise, exc_info)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     cursor, statement, parameters, context
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     cursor.execute(statement, parameters)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 168, in execute
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     query = self.mogrify(query, args)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 147, in mogrify
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     query = query % self._escape_args(args, conn)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 127, in _escape_args
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return dict((key, conn.literal(val)) for (key, val) in args.items())
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 127, in <genexpr>
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return dict((key, conn.literal(val)) for (key, val) in args.items())
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 469, in literal
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return self.escape(obj, self.encoders)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 462, in escape
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return converters.escape_item(obj, self.charset, mapping=mapping)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/converters.py", line 27, in escape_item
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     val = encoder(val, mapping)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/converters.py", line 118, in escape_unicode
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return u"'%s'" % _escape_unicode(value)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/converters.py", line 73, in _escape_unicode
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return value.translate(_escape_table)
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager DBError: 'result' object has no attribute 'translate'
2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager

** Affects: neutron
     Importance: Undecided
         Status: New

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

Title:
  neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin  DBError

Status in neutron:
  New

Bug description:
  It would appear that the bgp agent does not recognize translate
  attributes

  
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager [req-c5bda00a-2fb2-4f1e-8583-cfa842c97d30 1034301cea4d41c2ae979cc80d0c9221 44651bdb0d7a4d28adecd7653d39a38c - default default] Error during notification for neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin.port_callback--9223372036854769834 port, after_update: DBError: 'result' object has no attribute 'translate'
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager Traceback (most recent call last):
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_lib/callbacks/manager.py", line 197, in _notify_loop
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     callback(resource, event, trigger, **kwargs)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 376, in port_callback
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     routes = self.get_advertised_routes(ctx, bgp_speaker)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/services/bgp/bgp_plugin.py", line 225, in get_advertised_routes
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 315, in get_advertised_routes
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     routes = self.get_routes_by_bgp_speaker_id(context, bgp_speaker_id)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 477, in get_routes_by_bgp_speaker_id
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 864, in _get_tenant_network_routes_by_bgp_speaker
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 921, in _tenant_networks_by_bgp_speaker_query
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     bgp_speaker_id)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/neutron_dynamic_routing/db/bgp_db.py", line 470, in _get_address_scope_ids_for_bgp_speaker
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return [scope.id for scope in query.all()]
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2925, in all
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return list(self)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3081, in __iter__
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return self._execute_and_instances(context)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     result = conn.execute(querycontext.statement, self._params)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return meth(self, multiparams, params)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return connection._execute_clauseelement(self, multiparams, params)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     distilled_params,
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     e, statement, parameters, cursor, context
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     util.raise_from_cause(newraise, exc_info)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 296, in raise_from_cause
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     cursor, statement, parameters, context
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     cursor.execute(statement, parameters)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 168, in execute
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     query = self.mogrify(query, args)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 147, in mogrify
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     query = query % self._escape_args(args, conn)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 127, in _escape_args
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return dict((key, conn.literal(val)) for (key, val) in args.items())
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 127, in <genexpr>
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return dict((key, conn.literal(val)) for (key, val) in args.items())
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 469, in literal
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return self.escape(obj, self.encoders)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 462, in escape
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return converters.escape_item(obj, self.charset, mapping=mapping)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/converters.py", line 27, in escape_item
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     val = encoder(val, mapping)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/converters.py", line 118, in escape_unicode
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return u"'%s'" % _escape_unicode(value)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager   File "/usr/lib/python2.7/site-packages/pymysql/converters.py", line 73, in _escape_unicode
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager     return value.translate(_escape_table)
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager DBError: 'result' object has no attribute 'translate'
  2019-08-28 09:56:26.025 46862 ERROR neutron_lib.callbacks.manager

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

[Bug 1841788] Re: neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin DBError
From: Dr. Jens Harbott, 2023-05-23