yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1600721] Re: [mitaka]create firewall which assocation with router will be failed

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: zhanghaixia <zhang.haixia@xxxxxxx>
Date: Mon, 11 Jul 2016 09:33:25 -0000
Reply-to: Bug 1600721 <1600721@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** 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/1600721

Title:
  [mitaka]create firewall which assocation with router will be failed

Status in neutron:
  Invalid

Bug description:
  Traceback (most recent call last):
  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File "/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py", line 84, in resource

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     result
  = method(request=request, **args)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 410,
  in create

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  self._create(request, body, **kwargs)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 148, in
  wrapper

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  ectxt.value = e.inner_exc

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220,
  in __exit__

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  self.force_reraise()

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196,
  in force_reraise

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  six.reraise(self.type_, self.value, self.tb)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in
  wrapper

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  f(*args, **kwargs)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 521,
  in _create

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     obj =
  do_create(body)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 503,
  in do_create

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  request.context, reservation.reservation_id)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220,
  in __exit__

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  self.force_reraise()

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196,
  in force_reraise

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  six.reraise(self.type_, self.value, self.tb)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 496,
  in do_create

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  obj_creator(request.context, **kwargs)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-
  packages/neutron_fwaas/services/firewall/fwaas_plugin.py", line 236,
  in create_firewall

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  firewall['firewall']['tenant_id'], context, firewall)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-
  packages/neutron_fwaas/services/firewall/fwaas_plugin.py", line 229,
  in _get_routers_for_create_firewall

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  self.validate_firewall_routers_not_in_use(context, router_ids)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/oslo_log/helpers.py", line 46, in
  wrapper

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  method(*args, **kwargs)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-
  packages/neutron_fwaas/db/firewall/firewall_router_insertion_db.py",
  line 75, in validate_firewall_routers_not_in_use

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  FirewallRouterAssociation.fw_id != fwid).all()

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line
  2588, in all

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  list(self)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line
  2736, in __iter__

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  self._execute_and_instances(context)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line
  2751, in _execute_and_instances

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     result
  = conn.execute(querycontext.statement, self._params)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
  914, in execute

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  meth(self, multiparams, params)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line
  323, in _execute_on_connection

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     return
  connection._execute_clauseelement(self, multiparams, params)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
  1010, in _execute_clauseelement

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  compiled_sql, distilled_params

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
  1146, in _execute_context

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  context)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
  1337, in _handle_dbapi_exception

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  util.raise_from_cause(newraise, exc_info)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line
  200, in raise_from_cause

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  reraise(type(exception), exception, tb=exc_tb)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
  1139, in _execute_context

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  context)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py",
  line 450, in do_execute

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  cursor.execute(statement, parameters)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 146, in
  execute

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     result
  = self._query(query)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 296, in
  _query

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  conn.query(q)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 781,
  in query

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  self._affected_rows = self._read_query_result(unbuffered=unbuffered)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 942,
  in _read_query_result

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  result.read()

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1138,
  in read

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  first_packet = self.connection._read_packet()

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 906,
  in _read_packet

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  packet.check_error()

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 367,
  in check_error

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  err.raise_mysql_exception(self._data)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in
  raise_mysql_exception

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  _check_mysql_exception(errinfo)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource   File
  "/usr/lib/python2.7/site-packages/pymysql/err.py", line 112, in
  _check_mysql_exception

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource     raise
  errorclass(errno, errorvalue)

  2016-07-11 04:03:54.033 3785 ERROR neutron.api.v2.resource
  ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table
  'neutron.firewall_router_associations' doesn't exist") [SQL: u'SELECT
  firewall_router_associations.router_id AS
  firewall_router_associations_router_id \nFROM
  firewall_router_associations \nWHERE
  firewall_router_associations.router_id IN (%s) AND
  firewall_router_associations.fw_id IS NOT NULL'] [parameters:
  (u'e9381288-04f7-487d-b525-728b5be0fed2',)]

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1600721/+subscriptions
References

[Bug 1600721] [NEW] [mitaka]create firewall which assocation with router will be failed
From: zhanghaixia, 2016-07-11