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
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
