neutron-server broken for centos

Bug #1487828 reported by Sam Yaple
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla
Fix Released
Critical
Sam Yaple

Bug Description

2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher [req-c429e382-3898-44ce-99f5-59371ae05649 - - - - -] Exception during message handling: (OperationalError) (1054, "Unknown column 'ml2_vxlan_endpoints.host' in 'field list'") 'SELECT ml2_vxlan_endpoints.ip_address AS ml2_vxlan_endpoints_ip_address, ml2_vxlan_endpoints.udp_port AS ml2_vxlan_endpoints_udp_port, ml2_vxlan_endpoints.host AS ml2_vxlan_endpoints_host \nFROM ml2_vxlan_endpoints \nWHERE ml2_vxlan_endpoints.host = %s \n LIMIT %s' ('server02', 1)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher Traceback (most recent call last):
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 142, in _dispatch_and_reply
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher executor_callback))
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 186, in _dispatch
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher executor_callback)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_messaging/rpc/dispatcher.py", line 129, in _do_dispatch
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher result = func(ctxt, **new_args)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/drivers/type_tunnel.py", line 325, in tunnel_sync
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher host_endpoint = driver.obj.get_endpoint_by_host(host)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/drivers/type_tunnel.py", line 253, in get_endpoint_by_host
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher filter_by(host=host).first())
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2367, in first
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher ret = list(self[0:1])
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2228, in __getitem__
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher return list(res)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2438, in __iter__
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher return self._execute_and_instances(context)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in _execute_and_instances
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher result = conn.execute(querycontext.statement, self._params)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher return meth(self, multiparams, params)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher return connection._execute_clauseelement(self, multiparams, params)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher compiled_sql, distilled_params
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher context)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/compat/handle_error.py", line 155, in _handle_dbapi_exception
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher e, statement, parameters, cursor, context)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1155, in _handle_dbapi_exception
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher util.raise_from_cause(newraise, exc_info)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher reraise(type(exception), exception, tb=exc_tb)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher context)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher cursor.execute(statement, parameters)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher self.errorhandler(self, exc, value)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher raise errorclass, errorvalue
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher OperationalError: (OperationalError) (1054, "Unknown column 'ml2_vxlan_endpoints.host' in 'field list'") 'SELECT ml2_vxlan_endpoints.ip_address AS ml2_vxlan_endpoints_ip_address, ml2_vxlan_endpoints.udp_port AS ml2_vxlan_endpoints_udp_port, ml2_vxlan_endpoints.host AS ml2_vxlan_endpoints_host \nFROM ml2_vxlan_endpoints \nWHERE ml2_vxlan_endpoints.host = %s \n LIMIT %s' ('server02', 1)
2015-08-23 06:10:52.455 1 ERROR oslo_messaging.rpc.dispatcher

Revision history for this message
Sam Yaple (s8m) wrote :

This was fixed with a temporary workaround which has since been removed since the upstream code was fixed. The patch did not properly point to this bug to update teh status.

Changed in kolla:
status: Triaged → Fix Committed
Sam Yaple (s8m)
Changed in kolla:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.