On build we get a message from child cells where instance['info_cache']['network_info'] is []... and not json-ified. We need to json-ify this before passing to the DB method.
This traceback is for internal mysqldb code, but would likely be some sort of problem against sqlalchemy also.
332407:2013-10-15 15:11:01.336 17434 ERROR nova.cells.messaging [req-32f45513-ca61-4f37-b1a8-eeeb6f5100f3 10085925 5853594] Error processing message locally: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), `updated_at` = '2013-10-15 15:11:01.334702' WHERE `instance_uuid`='8da76d19-b' at line 1")
332408:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging Traceback (most recent call last):
332409:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/cells/messaging.py", line 204, in _process_locally
332410:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging resp_value = self.msg_runner._process_message_locally(self)
332411:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/cells/messaging.py", line 1220, in _process_message_locally
332412:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging return fn(message, **message.method_kwargs)
332413:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/cells/messaging.py", line 999, in instance_update_at_top
332414:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging message.ctxt, instance_uuid, info_cache)
332415:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/api.py", line 838, in instance_info_cache_update
332416:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging return IMPL.instance_info_cache_update(context, instance_uuid, values)
332417:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/openstack/common/db/api.py", line 103, in tpool_wrapper
332418:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging return self.__tpool.execute(attr, *args, **kwargs)
332419:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/eventlet/tpool.py", line 76, in tworker
332420:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging rv = meth(*args,**kwargs)
332421:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/api.py", line 58, in inner
332422:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging result = f(*args, **kwargs)
332423:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/api.py", line 171, in instance_info_cache_update
332424:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging info_cache = method(conn, ctxt, instance_uuid, values)
332425:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/instance_info_cache.py", line 44, in update
332426:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging rows = query.update(conn)
332427:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/sql.py", line 397, in update
332428:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging cursor = self._execute(conn, query, kwargs)
332429:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/sql.py", line 124, in _execute
332430:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging cursor = conn.execute(query, args=query_kwargs)
332431:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/connection.py", line 59, in inner
332432:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging return f(self, *args, **kwargs)
332433:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/nova/db/mysqldb/connection.py", line 243, in execute
332434:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging cursor.execute(query, args)
332435:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/MySQLdb/cursors.py", line 201, in execute
332436:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging self.errorhandler(self, exc, value)
332437:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging File "/opt/rackstack/472.13/nova/lib/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
332438:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging raise errorclass, errorvalue
332439:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), `updated_at` = '2013-10-15 15:11:01.334702' WHERE `instance_uuid`='8da76d19-b' at line 1")
332440:2013-10-15 15:11:01.336 17434 TRACE nova.cells.messaging
Fix proposed to branch: master
Review: https:/