Cinder-Volume state down

asked 2015-08-19 03:58:34 -0600

Nazmi gravatar image

updated 2015-08-19 21:00:50 -0600

Hi Openstack community,

I need help regarding the said title, been banging my head trying to find solutions but none so far. The documentations I followed is the official documentation for Openstack Kilo and things been going smooth till I reach chapter 8. Cinder service-list only shows me.

root@controller-2:/# cinder service-list
|      Binary      |     Host     | Zone |  Status | State |         Updated_at         | Disabled Reason |
| cinder-scheduler | controller-2 | nova | enabled |   up  | 2015-08-19T08:55:28.000000 |       None      |
|  cinder-volume   |  block1@lvm  | nova | enabled |  down |            None            |       None      |

The log I retrieved from cinder-volume.log shows me this.

  2015-08-19 16:34:52.946 19184 TRACE cinder.openstack.common.threadgroup OperationalError: (OperationalError) (1054, "Unknown column 'volumes.instance_uuid' in 'field list'") 'SELECT volumes.created_at AS volumes_created_at, volumes.updated_at AS volumes_updated_at, volumes.deleted_at AS volumes_deleted_at, AS volumes_id, volumes._name_id AS volumes__name_id, volumes.ec2_id AS volumes_ec2_id, volumes.user_id AS volumes_user_id, volumes.project_id AS volumes_project_id, volumes.snapshot_id AS volumes_snapshot_id, AS volumes_host, volumes.size AS volumes_size, volumes.availability_zone AS volumes_availability_zone, volumes.instance_uuid AS volumes_instance_uuid, volumes.attached_host AS volumes_attached_host, volumes.mountpoint AS volumes_mountpoint, volumes.attach_time AS volumes_attach_time, volumes.status AS volumes_status, volumes.attach_status AS volumes_attach_status, volumes.migration_status AS volumes_migration_status, volumes.scheduled_at AS volumes_scheduled_at, volumes.launched_at AS volumes_launched_at, volumes.terminated_at AS volumes_terminated_at, volumes.display_name AS volumes_display_name, volumes.display_description AS volumes_display_description, volumes.provider_location AS volumes_provider_location, volumes.provider_auth AS volumes_provider_auth, volumes.provider_geometry AS volumes_provider_geometry, volumes.volume_type_id AS volumes_volume_type_id, volumes.source_volid AS volumes_source_volid, volumes.encryption_key_id AS volumes_encryption_key_id, volumes.deleted AS volumes_deleted, volumes.bootable AS volumes_bootable, volume_types_1.created_at AS volume_types_1_created_at, volume_types_1.updated_at AS volume_types_1_updated_at, volume_types_1.deleted_at AS volume_types_1_deleted_at, volume_types_1.deleted AS volume_types_1_deleted, AS volume_types_1_id, AS volume_types_1_name, volume_types_1.qos_specs_id AS volume_types_1_qos_specs_id, volume_admin_metadata_1.created_at AS volume_admin_metadata_1_created_at, volume_admin_metadata_1.updated_at AS volume_admin_metadata_1_updated_at, volume_admin_metadata_1.deleted_at AS volume_admin_metadata_1_deleted_at, volume_admin_metadata_1.deleted AS volume_admin_metadata_1_deleted, AS volume_admin_metadata_1_id, volume_admin_metadata_1.`key` AS volume_admin_metadata_1_key, volume_admin_metadata_1.value AS volume_admin_metadata_1_value, volume_admin_metadata_1.volume_id AS volume_admin_metadata_1_volume_id, volume_metadata_1.created_at AS volume_metadata_1_created_at, volume_metadata_1.updated_at AS volume_metadata_1_updated_at, volume_metadata_1.deleted_at AS volume_metadata_1_deleted_at, volume_metadata_1.deleted AS volume_metadata_1_deleted, AS volume_metadata_1_id, volume_metadata_1.`key` AS volume_metadata_1_key, volume_metadata_1.value AS volume_metadata_1_value, volume_metadata_1.volume_id AS volume_metadata_1_volume_id \nFROM volumes LEFT OUTER JOIN volume_types AS volume_types_1 ON volumes.volume_type_id = AND volume_types_1.deleted = false LEFT OUTER JOIN volume_admin_metadata AS volume_admin_metadata_1 ON volume_admin_metadata_1.volume_id = AND volume_admin_metadata_1.deleted = false LEFT OUTER JOIN volume_metadata AS volume_metadata_1 ON volume_metadata_1.volume_id = AND volume_metadata_1.deleted = false \nWHERE volumes.deleted = false AND = %s' ('block1@lvm',)
    2015-08-19 16:34:52.946 19184 TRACE cinder.openstack.common.threadgroup
    2015-08-19 16:34:52.961 17844 INFO cinder.openstack.common.service [-] Child 19184 exited with status 0
    2015-08-19 16:34:52.973 17844 INFO cinder.openstack.common.service [-] Started child 19195
    2015-08-19 16:34:52.982 19195 AUDIT cinder.service [-] Starting cinder-volume node (version 2014.1.5)
    2015-08-19 16:34:52.986 19195 INFO cinder.volume.manager [req-759a7203-3e06-4030-8a93-ca6aad4d2692 - - - - -] Starting volume driver LVMVolumeDriver (2.0.0)

I made a partition for /dev/sdb using "fdisk" and also changed the id label to "Linux LVM", I didn't mount however as it requires the configurations made for the /etc/fstab or /etc/mtab which ...

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2015-08-19 22:54:25 -0600

Nazmi gravatar image

updated 2015-08-20 19:58:35 -0600

Based on suggestions from, I login to MySQL server and run the following commands, to add missing columns.

use cinder;

alter table volumes add column instance_uuid varchar (2000) ;
alter table volumes add column attached_host varchar (2000) ;
alter table volumes add column mountpoint varchar (2000) ;
alter table volumes add column attach_time varchar (2000) ;

After inputting the commands, the error 1054 is removed

edit flag offensive delete link more


Good that you found the answer. If you have a different issue, ask a different question. This site is not a discussion forum:

smaffulli gravatar imagesmaffulli ( 2015-08-20 17:26:40 -0600 )edit

Noted, apologies for the mistake

Nazmi gravatar imageNazmi ( 2015-08-20 19:53:29 -0600 )edit

Haha, what a bullshit - developers forget to create a columns in cinder database table volumes! What a shame! OpenStack has a many such things!

Ramirezkiv gravatar imageRamirezkiv ( 2016-01-21 07:52:22 -0600 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2015-08-19 03:58:34 -0600

Seen: 3,794 times

Last updated: Aug 20 '15