Unknown column 'volumes.instance_uuid' in 'field list' [closed]

asked 2015-06-03 07:53:23 -0500

darren-wang gravatar image

when we finish installation of cinder on block storage node, when type '# cinder-volume' to start cinder-volume, error came like this:

2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup Traceback (most recent call last):
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/openstack/common/threadgroup.py", line 143, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     x.wait()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/openstack/common/threadgroup.py", line 47, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self.thread.wait()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 168, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self._exit_event.wait()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/event.py", line 116, in wait
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return hubs.get_hub().switch()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line 187, in switch
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return self.greenlet.switch()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 194, in main
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     result = function(*args, **kwargs)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/openstack/common/service.py", line 500, in run_service
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     service.start()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/service.py", line 141, in start
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     self.manager.init_host()
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/osprofiler/profiler.py", line 105, in wrapper
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return f(*args, **kwargs)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/volume/manager.py", line 261, in init_host
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     volumes = self.db.volume_get_all_by_host(ctxt, self.host)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/db/api.py", line 222, in volume_get_all_by_host
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup     return IMPL.volume_get_all_by_host(context, host)
2015-06-03 20:50:12.969 25254 TRACE cinder.openstack.common.threadgroup   File "/usr/lib/python2.7/dist-packages/cinder/db/sqlalchemy/api.py", line 154, in wrapper
2015-06-03 ...
(more)
edit retag flag offensive reopen merge delete

Closed for the following reason not a real question by darren-wang
close date 2015-06-23 12:05:17.588961

Comments

Can you check running below command, also check restarting the cinder services.

[root@controller~(openstack_admin)]#cinder-manage db sync
sunnyarora gravatar imagesunnyarora ( 2015-06-03 09:33:43 -0500 )edit

I handle this problem in a savage way, I added those missing columns into DB tables and now it works.

darren-wang gravatar imagedarren-wang ( 2015-06-19 13:00:10 -0500 )edit