yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1600721] [NEW] [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 08:40:06 -0000
Reply-to: Bug 1600721 <1600721@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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',)]

** Affects: neutron
     Importance: Undecided
         Status: New

** Summary changed:

- [mitaka]create firewall which assocation with router will be faiiled
+ [mitaka]create firewall which assocation with router will be failed

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

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
Follow ups

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