本帖最后由 汉服骑射 于 2016-6-26 22:33 编辑
时间久了，不知道楼主还在不在。
我遇到与5楼的兄弟一模一样的问题。
在cinder-volume.log中发现这样一个错误：
2016-06-26 22:19:43.143 16801 TRACE cinder.openstack.common.threadgroup OperationalError: (OperationalError) no such table: volumes u'SELECT volumes.created_at AS volumes_created_at, volumes.updated_at AS volumes_updated_at, volumes.deleted_at AS volumes_deleted_at, volumes.id 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, volumes.host 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.consistencygroup_id AS volumes_consistencygroup_id, volumes.deleted AS volumes_deleted, volumes.bootable AS volumes_bootable, volumes.replication_status AS volumes_replication_status, volumes.replication_extended_status AS volumes_replication_extended_status, volumes.replication_driver_data AS volumes_replication_driver_data, consistencygroups_1.created_at AS consistencygroups_1_created_at, consistencygroups_1.updated_at AS consistencygroups_1_updated_at, consistencygroups_1.deleted_at AS consistencygroups_1_deleted_at, consistencygroups_1.deleted AS consistencygroups_1_deleted, consistencygroups_1.id AS consistencygroups_1_id, consistencygroups_1.user_id AS consistencygroups_1_user_id, consistencygroups_1.project_id AS consistencygroups_1_project_id, consistencygroups_1.host AS consistencygroups_1_host, consistencygroups_1.availability_zone AS consistencygroups_1_availability_zone, consistencygroups_1.name AS consistencygroups_1_name, consistencygroups_1.description AS consistencygroups_1_description, consistencygroups_1.volume_type_id AS consistencygroups_1_volume_type_id, consistencygroups_1.status AS consistencygroups_1_status, 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, volume_metadata_1.id 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, 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, volume_admin_metadata_1.id 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_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, volume_types_1.id AS volume_types_1_id, volume_types_1.name AS volume_types_1_name, volume_types_1.qos_specs_id AS volume_types_1_qos_specs_id \nFROM volumes LEFT OUTER JOIN consistencygroups AS consistencygroups_1 ON volumes.consistencygroup_id = consistencygroups_1.id LEFT OUTER JOIN volume_metadata AS volume_metadata_1 ON volume_metadata_1.volume_id = volumes.id AND volume_metadata_1.deleted = 0 LEFT OUTER JOIN volume_admin_metadata AS volume_admin_metadata_1 ON volume_admin_metadata_1.volume_id = volumes.id AND volume_admin_metadata_1.deleted = 0 LEFT OUTER JOIN volume_types AS volume_types_1 ON volumes.volume_type_id = volume_types_1.id AND volume_types_1.deleted = 0 \nWHERE volumes.deleted = 0 AND (volumes.host = ? OR (volumes.host LIKE ?))' ('sdn03', 'sdn03#%')
说是“ no such table: volumes”
这段日志有点乱，整理一下其中的SQL是这样的：
[mw_shl_code=sql,true]SELECT
volumes.created_at AS volumes_created_at,
volumes.updated_at AS volumes_updated_at,
volumes.deleted_at AS volumes_deleted_at,
volumes.id 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,
volumes.host 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.consistencygroup_id AS volumes_consistencygroup_id,
volumes.deleted AS volumes_deleted,
volumes.bootable AS volumes_bootable,
volumes.replication_status AS volumes_replication_status,
volumes.replication_extended_status AS volumes_replication_extended_status,
volumes.replication_driver_data AS volumes_replication_driver_data,
consistencygroups_1.created_at AS consistencygroups_1_created_at,
consistencygroups_1.updated_at AS consistencygroups_1_updated_at,
consistencygroups_1.deleted_at AS consistencygroups_1_deleted_at,
consistencygroups_1.deleted AS consistencygroups_1_deleted,
consistencygroups_1.id AS consistencygroups_1_id,
consistencygroups_1.user_id AS consistencygroups_1_user_id,
consistencygroups_1.project_id AS consistencygroups_1_project_id,
consistencygroups_1.host AS consistencygroups_1_host,
consistencygroups_1.availability_zone AS consistencygroups_1_availability_zone,
consistencygroups_1.name AS consistencygroups_1_name,
consistencygroups_1.description AS consistencygroups_1_description,
consistencygroups_1.volume_type_id AS consistencygroups_1_volume_type_id,
consistencygroups_1.status AS consistencygroups_1_status,
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,
volume_admin_metadata_1.id 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,
volume_metadata_1.id 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,
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,
volume_types_1.id AS volume_types_1_id,
volume_types_1.name AS volume_types_1_name,
volume_types_1.qos_specs_id AS volume_types_1_qos_specs_id
FROM volumes
LEFT OUTER JOIN consistencygroups AS consistencygroups_1 ON volumes.consistencygroup_id = consistencygroups_1.id
LEFT OUTER JOIN volume_admin_metadata AS volume_admin_metadata_1 ON volume_admin_metadata_1.volume_id = volumes.id AND volume_admin_metadata_1.deleted = 0
LEFT OUTER JOIN volume_metadata AS volume_metadata_1 ON volume_metadata_1.volume_id = volumes.id AND volume_metadata_1.deleted = 0
LEFT OUTER JOIN volume_types AS volume_types_1 ON volumes.volume_type_id = volume_types_1.id AND volume_types_1.deleted = 0
WHERE volumes.deleted = 0 AND (volumes.host = ? OR (volumes.host LIKE ?))
[/mw_shl_code]
把这段SQL复制到MySQL客户端中执行，先后报了3个SQL语法错误，前2个是第56行、第64行加了双引号的key列名，第3个错误是最后一行中两个问号出现的位置。MySQL用问号作为通配符吗？
安装文件出现这样的问题我觉得不可思议。需要debug刚刚安装好的代码吗？
|
/2 
京ICP备2020039040号
简书网举报电话：021-34700000
显身卡
