Unsupported rollback
** Changed in: nova
Status: Incomplete => Invalid
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1228141
Title:
getting nova traceback when creating instance
Status in OpenStack Compute (Nova):
Invalid
Bug description:
I just added a new compute node to my cluster. When I try to create an
instance, this node always fails. I see this error message on the
node:
ERROR nova.openstack.common.rpc.common
[req-c5e13da1-97f2-4da5-855f-1c09a11f328a None None] ['Traceback (most recent
call last):\n', ' File "/opt/stack/nova/nova/openstack/common/rpc/amqp.py",
line 461, in _process_data\n **args)\n', ' File
"/opt/stack/nova/nova/openstack/common/rpc/dispatcher.py", line 172, in
dispatch\n result = getattr(proxyobj, method)(ctxt, **kwargs)\n', ' File
"/opt/stack/nova/nova/openstack/common/rpc/common.py", line 439, in inner\n
return catch_client_exception(exceptions, func, *args, **kwargs)\n', ' File
"/opt/stack/nova/nova/openstack/common/rpc/common.py", line 420, in
catch_client_exception\n return func(*args, **kwargs)\n', ' File
"/opt/stack/nova/nova/network/manager.py", line 573, in get_instance_nw_info\n
instance_uuid)\n', ' File "/opt/stack/nova/nova/db/api.py", line 561, in
virtual_interface_get_by_instance\n return
IMPL.virtual_interface_get_by_instance(context, instance_id)\n', ' File
"/opt/stack/nova/nova/db/sqlalche
my/api.py", line 126, in wrapper\n return f(*args, **kwargs)\n', ' File
"/opt/stack/nova/nova/db/sqlalchemy/api.py", line 138, in wrapper\n
instance_get_by_uuid(context, instance_uuid)\n', ' File
"/opt/stack/nova/nova/db/sqlalchemy/api.py", line 126, in wrapper\n return
f(*args, **kwargs)\n', ' File "/opt/stack/nova/nova/db/sqlalchemy/api.py",
line 1678, in instance_get_by_uuid\n columns_to_join=columns_to_join)\n', '
File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 1684, in
_instance_get_by_uuid\n filter_by(uuid=uuid).\\\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2156, in
first\n ret = list(self[0:1])\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2023, in
__getitem__\n return list(res)\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in
__iter__\n return self._execute_and_instances(context)\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/
query.py", line 2242, in _execute_and_instances\n result =
conn.execute(querycontext.statement, self._params)\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in
execute\n params)\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in
_execute_clauseelement\n compiled_sql, distilled_params\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in
_execute_context\n context)\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in
_execute_context\n context)\n', ' File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in
do_execute\n cursor.execute(statement, parameters)\n', ' File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute\n
self.errorhandler(self, exc, value)\n', ' File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler\n raise err
orclass, errorvalue\n', 'OperationalError: (OperationalError) (1054, "Unknown
column \'instances.locked_by\' in \'field list\'") \'SELECT
anon_1.instances_created_at AS anon_1_instances_created_at,
anon_1.instances_updated_at AS anon_1_instances_updated_at,
anon_1.instances_deleted_at AS anon_1_instances_deleted_at,
anon_1.instances_deleted AS anon_1_instances_deleted, anon_1.instances_id AS
anon_1_instances_id, anon_1.instances_user_id AS anon_1_instances_user_id,
anon_1.instances_project_id AS anon_1_instances_project_id,
anon_1.instances_image_ref AS anon_1_instances_image_ref,
anon_1.instances_kernel_id AS anon_1_instances_kernel_id,
anon_1.instances_ramdisk_id AS anon_1_instances_ramdisk_id,
anon_1.instances_hostname AS anon_1_instances_hostname,
anon_1.instances_launch_index AS anon_1_instances_launch_index,
anon_1.instances_key_name AS anon_1_instances_key_name,
anon_1.instances_key_data AS anon_1_instances_key_data,
anon_1.instances_power_state AS anon_1_instances_power_stat
e, anon_1.instances_vm_state AS anon_1_instances_vm_state,
anon_1.instances_task_state AS anon_1_instances_task_state,
anon_1.instances_memory_mb AS anon_1_instances_memory_mb,
anon_1.instances_vcpus AS anon_1_instances_vcpus, anon_1.instances_root_gb AS
anon_1_instances_root_gb, anon_1.instances_ephemeral_gb AS
anon_1_instances_ephemeral_gb, anon_1.instances_host AS anon_1_instances_host,
anon_1.instances_node AS anon_1_instances_node,
anon_1.instances_instance_type_id AS anon_1_instances_instance_type_id,
anon_1.instances_user_data AS anon_1_instances_user_data,
anon_1.instances_reservation_id AS anon_1_instances_reservation_id,
anon_1.instances_scheduled_at AS anon_1_instances_scheduled_at,
anon_1.instances_launched_at AS anon_1_instances_launched_at,
anon_1.instances_terminated_at AS anon_1_instances_terminated_at,
anon_1.instances_availability_zone AS anon_1_instances_availability_zone,
anon_1.instances_display_name AS anon_1_instances_display_name,
anon_1.instances_display_des
cription AS anon_1_instances_display_description, anon_1.instances_launched_on
AS anon_1_instances_launched_on, anon_1.instances_locked AS
anon_1_instances_locked, anon_1.instances_locked_by AS
anon_1_instances_locked_by, anon_1.instances_os_type AS
anon_1_instances_os_type, anon_1.instances_architecture AS
anon_1_instances_architecture, anon_1.instances_vm_mode AS
anon_1_instances_vm_mode, anon_1.instances_uuid AS anon_1_instances_uuid,
anon_1.instances_root_device_name AS anon_1_instances_root_device_name,
anon_1.instances_default_ephemeral_device AS
anon_1_instances_default_ephemeral_device, anon_1.instances_default_swap_device
AS anon_1_instances_default_swap_device, anon_1.instances_config_drive AS
anon_1_instances_config_drive, anon_1.instances_access_ip_v4 AS
anon_1_instances_access_ip_v4, anon_1.instances_access_ip_v6 AS
anon_1_instances_access_ip_v6, anon_1.instances_auto_disk_config AS
anon_1_instances_auto_disk_config, anon_1.instances_progress AS
anon_1_instances_progres
s, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate,
anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate,
anon_1.instances_cell_name AS anon_1_instances_cell_name,
anon_1.instances_internal_id AS anon_1_instances_internal_id,
anon_1.instances_cleaned AS anon_1_instances_cleaned,
instance_info_caches_1.created_at AS instance_info_caches_1_created_at,
instance_info_caches_1.updated_at AS instance_info_caches_1_updated_at,
instance_info_caches_1.deleted_at AS instance_info_caches_1_deleted_at,
instance_info_caches_1.deleted AS instance_info_caches_1_deleted,
instance_info_caches_1.id AS instance_info_caches_1_id,
instance_info_caches_1.network_info AS instance_info_caches_1_network_info,
instance_info_caches_1.instance_uuid AS instance_info_caches_1_instance_uuid,
security_groups_1.created_at AS security_groups_1_created_at,
security_groups_1.updated_at AS security_groups_1_updated_at,
security_groups_1.deleted_at AS security_groups_1_dele
ted_at, security_groups_1.deleted AS security_groups_1_deleted,
security_groups_1.id AS security_groups_1_id, security_groups_1.name AS
security_groups_1_name, security_groups_1.description AS
security_groups_1_description, security_groups_1.user_id AS
security_groups_1_user_id, security_groups_1.project_id AS
security_groups_1_project_id, security_group_rules_1.created_at AS
security_group_rules_1_created_at, security_group_rules_1.updated_at AS
security_group_rules_1_updated_at, security_group_rules_1.deleted_at AS
security_group_rules_1_deleted_at, security_group_rules_1.deleted AS
security_group_rules_1_deleted, security_group_rules_1.id AS
security_group_rules_1_id, security_group_rules_1.parent_group_id AS
security_group_rules_1_parent_group_id, security_group_rules_1.protocol AS
security_group_rules_1_protocol, security_group_rules_1.from_port AS
security_group_rules_1_from_port, security_group_rules_1.to_port AS
security_group_rules_1_to_port, security_group_rules_1.cidr AS
security_group_rules_1_cidr, security_group_rules_1.group_id AS
security_group_rules_1_group_id, instance_metadata_1.created_at AS
instance_metadata_1_created_at, instance_metadata_1.updated_at AS
instance_metadata_1_updated_at, instance_metadata_1.deleted_at AS
instance_metadata_1_deleted_at, instance_metadata_1.deleted AS
instance_metadata_1_deleted, instance_metadata_1.id AS instance_metadata_1_id,
instance_metadata_1.`key` AS instance_metadata_1_key, instance_metadata_1.value
AS instance_metadata_1_value, instance_metadata_1.instance_uuid AS
instance_metadata_1_instance_uuid, instance_system_metadata_1.created_at AS
instance_system_metadata_1_created_at, instance_system_metadata_1.updated_at AS
instance_system_metadata_1_updated_at, instance_system_metadata_1.deleted_at AS
instance_system_metadata_1_deleted_at, instance_system_metadata_1.deleted AS
instance_system_metadata_1_deleted, instance_system_metadata_1.id AS
instance_system_metadata_1_id, instance_system_metadata_1.`key`
AS instance_system_metadata_1_key, instance_system_metadata_1.value AS
instance_system_metadata_1_value, instance_system_metadata_1.instance_uuid AS
instance_system_metadata_1_instance_uuid \\nFROM (SELECT instances.created_at
AS instances_created_at, instances.updated_at AS instances_updated_at,
instances.deleted_at AS instances_deleted_at, instances.deleted AS
instances_deleted, instances.id AS instances_id, instances.user_id AS
instances_user_id, instances.project_id AS instances_project_id,
instances.image_ref AS instances_image_ref, instances.kernel_id AS
instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id,
instances.hostname AS instances_hostname, instances.launch_index AS
instances_launch_index, instances.key_name AS instances_key_name,
instances.key_data AS instances_key_data, instances.power_state AS
instances_power_state, instances.vm_state AS instances_vm_state,
instances.task_state AS instances_task_state,
instances.memory_mb AS instances_memory_mb, instances.vcpus AS
instances_vcpus, instances.root_gb AS instances_root_gb, instances.ephemeral_gb
AS instances_ephemeral_gb, instances.host AS instances_host, instances.node AS
instances_node, instances.instance_type_id AS instances_instance_type_id,
instances.user_data AS instances_user_data, instances.reservation_id AS
instances_reservation_id, instances.scheduled_at AS instances_scheduled_at,
instances.launched_at AS instances_launched_at, instances.terminated_at AS
instances_terminated_at, instances.availability_zone AS
instances_availability_zone, instances.display_name AS instances_display_name,
instances.display_description AS instances_display_description,
instances.launched_on AS instances_launched_on, instances.locked AS
instances_locked, instances.locked_by AS instances_locked_by, instances.os_type
AS instances_os_type, instances.architecture AS instances_architecture,
instances.vm_mode AS instances_vm_mode, instances.uuid AS
instances_uuid, instances.root_device_name AS instances_root_device_name,
instances.default_ephemeral_device AS instances_default_ephemeral_device,
instances.default_swap_device AS instances_default_swap_device,
instances.config_drive AS instances_config_drive, instances.access_ip_v4 AS
instances_access_ip_v4, instances.access_ip_v6 AS instances_access_ip_v6,
instances.auto_disk_config AS instances_auto_disk_config, instances.progress AS
instances_progress, instances.shutdown_terminate AS
instances_shutdown_terminate, instances.disable_terminate AS
instances_disable_terminate, instances.cell_name AS instances_cell_name,
instances.internal_id AS instances_internal_id, instances.cleaned AS
instances_cleaned \\nFROM instances \\nWHERE instances.deleted = %s AND
instances.uuid = %s \\n LIMIT %s) AS anon_1 LEFT OUTER JOIN
instance_info_caches AS instance_info_caches_1 ON
instance_info_caches_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN
security_group_instance_association AS s
ecurity_group_instance_association_1 ON
security_group_instance_association_1.instance_uuid = anon_1.instances_uuid AND
anon_1.instances_deleted = %s LEFT OUTER JOIN security_groups AS
security_groups_1 ON security_groups_1.id =
security_group_instance_association_1.security_group_id AND
security_group_instance_association_1.deleted = %s AND
security_groups_1.deleted = %s LEFT OUTER JOIN security_group_rules AS
security_group_rules_1 ON security_group_rules_1.parent_group_id =
security_groups_1.id AND security_group_rules_1.deleted = %s LEFT OUTER JOIN
instance_metadata AS instance_metadata_1 ON instance_metadata_1.instance_uuid =
anon_1.instances_uuid AND instance_metadata_1.deleted = %s LEFT OUTER JOIN
instance_system_metadata AS instance_system_metadata_1 ON
instance_system_metadata_1.instance_uuid = anon_1.instances_uuid AND
instance_system_metadata_1.deleted = %s\' (0,
\'edaef898-fa8f-48b3-9501-4aa81ecfcd50\', 1, 0, 0, 0, 0, 0, 0)\n']
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1228141/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
