yahoo-eng-team team mailing list archive

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

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: "Dr. Jens Harbott" <1841788@xxxxxxxxxxxxxxxxxx>
Date: Tue, 23 May 2023 05:49:57 -0000
Reply-to: Bug 1841788 <1841788@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
The original issue seems to have been related to python2.7, which is no
longer supported. It was also never reproduced. Please reopen if you
still see this issue and have a way to reproduce it.

** Changed in: neutron
       Status: New => Invalid

-- 
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:
  Invalid

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
References

[Bug 1841788] [NEW] neutron_dynamic_routing.services.bgp.bgp_plugin.BgpPlugin DBError
From: Donny Davis, 2019-08-28