Re: [openstack-dev] [Nova] RemoteError: Remote error: OperationalError (OperationalError) (1048, Column 'instance_uuid' cannot be null)
Hi there, I have the same issue on my second and third compute nodes. The first compute node is working properly with the controller node. My environment is Juno + RHEL7.0. I don't think the issue from the new instance not having an uuid. Actually from my opinion, in the log, 67e215e0-2193-439d-89c4-be8c378df78d is the uuid, right? 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] [u'Traceback (most recent call last):\n', u' File . Any suggestion on solving this issue? Regards, Jianbo Zheng ___ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
Re: [openstack-dev] [Nova] RemoteError: Remote error: OperationalError (OperationalError) (1048, Column 'instance_uuid' cannot be null)
I have formatted the messy clutter in the middle of your trace log. Traceback (most recent call last): File /usr/lib/python2.7/site-packages/nova/conductor/manager.py, line 400, in _object_dispatch return getattr(target, method)(context, *args, **kwargs) File /usr/lib/python2.7/site-packages/nova/objects/base.py, line 204, in wrapper return fn(self, ctxt, *args, **kwargs) File /usr/lib/python2.7/site-packages/nova/objects/instance.py, line 500, in save columns_to_join=_expected_cols(expected_attrs)) File /usr/lib/python2.7/site-packages/nova/db/api.py, line 746, in instance_update_and_get_original columns_to_join=columns_to_join) File /usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py, line 143, in wrapper return f(*args, **kwargs) File /usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py, line 2289, in instance_update_and_get_original columns_to_join=columns_to_join) File /usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py, line 2380, in _instance_update session.add(instance_ref) File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 470, in __exit__ self.rollback() File /usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py, line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 467, in __exit__ self.commit() File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 377, in commit self._prepare_impl() File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 357, in _prepare_impl self.session.flush() File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 1919, in flush self._flush(objects) File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 2037, in _flush transaction.rollback(_capture_exception=True) File /usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py, line 60, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py, line 2001, in _flush flush_context.execute() File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py, line 372, in execute rec.execute(self) File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py, line 526, in execute uow File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py, line 60, in save_obj mapper, table, update) File /usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py, line 518, in _emit_update_statements execute(statement, params) File /usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py, line 729, in execute return meth(self, multiparams, params) File /usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py, line 321, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File /usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py, line 826, in _execute_clauseelement compiled_sql, distilled_params File /usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py, line 958, in _execute_context context) File /usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py, line 1156, in _handle_dbapi_exception util.raise_from_cause(newraise, exc_info) File /usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py, line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File /usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py, line 951, in _execute_context context) File /usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py, line 436, in do_execute cursor.execute(statement, parameters) File /usr/lib64/python2.7/site-packages/MySQLdb/cursors.py, line 174, in execute self.errorhandler(self, exc, value) File /usr/lib64/python2.7/site-packages/MySQLdb/connections.py, line 36, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (OperationalError) (1048, Column 'instance_uuid' cannot be null) 'UPDATE instance_extra SET updated_at=%s, instance_uuid=%s WHERE instance_extra.id = %s' (datetime.datetime(2014, 12, 12, 9, 16, 52, 434376), None, 5L) Looks like your new instance doesn't have uuid, and causes to _allocate_network to fail. Instance uuid should have been allocated in nova/compute/api.py::_provision_instances on default. Thanks Regards, -- Accela Zhao From: joejiang ifz...@126.com Reply-To: OpenStack Development Mailing List (not for usage questions) openstack-dev@lists.openstack.org Date: Friday, December 12, 2014 at 5:36 PM To: openstack-dev@lists.openstack.org openstack-dev@lists.openstack.org, openst...@lists.openstack.org openst...@lists.openstack.org Subject: [openstack-dev] [Nova] RemoteError: Remote error: OperationalError (OperationalError) (1048, Column 'instance_uuid' cannot be null) Hi folks, when i launch instance use cirros image
[openstack-dev] [Nova] RemoteError: Remote error: OperationalError (OperationalError) (1048, Column 'instance_uuid' cannot be null)
Hi folks, when i launch instance use cirros image in the new openstack environment(juno version centos7 OS base), the following piece is error logs from compute node. anybody meet the same error? 2014-12-12 17:16:52.481 12966 ERROR nova.compute.manager [-] [instance: 67e215e0-2193-439d-89c4-be8c378df78d] Failed to allocate network(s) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] Traceback (most recent call last): 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/nova/compute/manager.py, line 2190, in _build_resources 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] requested_networks, security_groups) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/nova/compute/manager.py, line 1683, in _build_networks_for_instance 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] requested_networks, macs, security_groups, dhcp_options) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/nova/compute/manager.py, line 1717, in _allocate_network 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] instance.save(expected_task_state=[None]) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/nova/objects/base.py, line 189, in wrapper 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] ctxt, self, fn.__name__, args, kwargs) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/nova/conductor/rpcapi.py, line 351, in object_action 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] objmethod=objmethod, args=args, kwargs=kwargs) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/oslo/messaging/rpc/client.py, line 152, in call 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] retry=self.retry) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/oslo/messaging/transport.py, line 90, in _send 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] timeout=timeout, retry=retry) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/oslo/messaging/_drivers/amqpdriver.py, line 408, in send 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] retry=retry) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] File /usr/lib/python2.7/site-packages/oslo/messaging/_drivers/amqpdriver.py, line 399, in _send 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] raise result 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] RemoteError: Remote error: OperationalError (OperationalError) (1048, Column 'instance_uuid' cannot be null) 'UPDATE instance_extra SET updated_at=%s, instance_uuid=%s WHERE instance_extra.id = %s' (datetime.datetime(2014, 12, 12, 9, 16, 52, 434376), None, 5L) 2014-12-12 17:16:52.481 12966 TRACE nova.compute.manager [instance: 67e215e0-2193-439d-89c4-be8c378df78d] [u'Traceback (most recent call last):\n', u' File /usr/lib/python2.7/site-packages/nova/conductor/manager.py, line 400, in _object_dispatch\nreturn getattr(target, method)(context, *args, **kwargs)\n', u' File /usr/lib/python2.7/site-packages/nova/objects/base.py, line 204, in wrapper\nreturn fn(self, ctxt, *args, **kwargs)\n', u' File /usr/lib/python2.7/site-packages/nova/objects/instance.py, line 500, in save\ncolumns_to_join=_expected_cols(expected_attrs))\n', u' File /usr/lib/python2.7/site-packages/nova/db/api.py, line 746, in instance_update_and_get_original\ncolumns_to_join=columns_to_join)\n', u' File /usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py, line 143, in wrapper\nreturn f(*args, **kwargs)\n', u' File /usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py, line 2289, in