Ask Your Question
0

OpenStack Juno release Nova error: RemoteError: Remote error: OperationalError (OperationalError) (1048, “Column 'instance_uuid' cannot be null”)

asked 2014-12-26 02:01:59 -0500

Sammy gravatar image

Env:

  • Node 1: controller, running controller services, Mysql, RabbitMQ and etc
  • Node 2: compute1, running nova_compute
  • Node 3: network, running neutron_server
  • Node 4: block1, running cinder-volume

Procedure for reproduce:

Volume creation works. when launching instance in dashboard or with Nova Cli, exception was thrown in instance.save() function in file "/usr/lib/python2.7/dist-packages/nova/compute/manager.py" on compute node, line 2273. Following is the trace in nova-compute log files with debug=true:

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, 25, 11, 11, 36, 186194), None, 13L)

19:11:36.105 20544 TRACE oslo.messaging.rpc.dispatcher [u'Traceback (most recent call last):\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/conductor/manager.py", line 400, in _object_dispatch\n    return getattr(target, method)(context, *args, **kwargs)\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/objects/base.py", line 204, in wrapper\n    return fn(self, ctxt, *args, **kwargs)\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/objects/instance.py", line 500, in save\n    columns_to_join=_expected_cols(expected_attrs))\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 746, in instance_update_and_get_original\n    columns_to_join=columns_to_join)\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 143, in wrapper\n    return f(*args, **kwargs)\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 2289, in instance_update_and_get_original\n    columns_to_join=columns_to_join)\n', u'  
File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 2380, in _instance_update\n    session.add(instance_ref)\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 470, in __exit__\n    self.rollback()\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__\n    compat.reraise(exc_type, exc_value, exc_tb)\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 467, in __exit__\n    self.commit()\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 377, in commit\n    self._prepare_impl()\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 357, in _prepare_impl\n    self.session.flush()\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1919, in flush\n    self._flush(objects)\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2037, in _flush\n    transaction.rollback(_capture_exception=True)\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__\n    compat.reraise(exc_type, exc_value, exc_tb)\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2001, in _flush\n    flush_context.execute()\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute\n    rec.execute(self)\n', u'  
File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute\n    uow\n', u'  
File "/usr/lib/python2.7/dist-packages ...
(more)
edit retag flag offensive close merge delete

2 answers

Sort by » oldest newest most voted
1

answered 2014-12-28 03:15:52 -0500

Looks like nova-manage db sync was not run during install. Can you confirm?

It won't hurt to run it again.

edit flag offensive delete link more
0

answered 2015-01-08 19:57:54 -0500

This issue is further discussed in https://bugs.launchpad.net/nova/+bug/1405741 (Bug #1405741).

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-12-26 02:01:59 -0500

Seen: 545 times

Last updated: Dec 28 '14