yahoo-eng-team team mailing list archive

[Russell Bryant <885414@xxxxxxxxxxxxxxxxxx>]

doesn't seem like a valid issue anymore

** Changed in: nova
       Status: Confirmed => 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/885414

Title:
  Instance IDs passed to database as string

Status in OpenStack Compute (Nova):
  Invalid

Bug description:
  If you mistakenly issue a delete-server request against the OS API
  with an EC2 id, the error message indicates that this is being passed
  to the database, which seems risky; certainly not best-practice...

  If the instance ID in the database is an integer, we should probably
  pass an integer to the ORM layer.

  I'm using PostgreSQL, if that's relevant.  Here's the relevant section
  of the log...

  2011-11-02 13:01:35,711 INFO nova.api.openstack.wsgi [-] DELETE http://192.168.10.1:8774/v1.1/novaadmin/servers/i-0000000b
  2011-11-02 13:01:35,711 DEBUG nova.api.openstack.wsgi [-] Empty body provided in request from (pid=20683) deserialize_body /usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py:239
  2011-11-02 13:01:35,712 DEBUG nova.compute.api [-] Going to try to terminate i-0000000b from (pid=20683) delete /usr/lib/python2.7/dist-packages/nova/compute/api.py:758
  2011-11-02 13:01:35,752 ERROR nova.api.openstack [-] Caught error: (DataError) invalid input syntax for integer: "i-0000000b"
  LINE 4: ...HERE instances.deleted = false AND instances.id = 'i-0000000...
                                                               ^
   '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_server_name AS anon_1_instances_server_name, 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_state, 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_local_gb AS anon_1_instances_local_gb, anon_1.instances_hostname AS anon_1_instances_hostname, anon_1.instances_host AS anon_1_instances_host, 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_description 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_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_local_device AS anon_1_instances_default_local_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, volumes_1.created_at AS volumes_1_created_at, volumes_1.updated_at AS volumes_1_updated_at, volumes_1.deleted_at AS volumes_1_deleted_at, volumes_1.deleted AS volumes_1_deleted, volumes_1.id AS volumes_1_id, volumes_1.user_id AS volumes_1_user_id, volumes_1.project_id AS volumes_1_project_id, volumes_1.snapshot_id AS volumes_1_snapshot_id, volumes_1.host AS volumes_1_host, volumes_1.size AS volumes_1_size, volumes_1.availability_zone AS volumes_1_availability_zone, volumes_1.instance_id AS volumes_1_instance_id, volumes_1.mountpoint AS volumes_1_mountpoint, volumes_1.attach_time AS volumes_1_attach_time, volumes_1.status AS volumes_1_status, volumes_1.attach_status AS volumes_1_attach_status, volumes_1.scheduled_at AS volumes_1_scheduled_at, volumes_1.launched_at AS volumes_1_launched_at, volumes_1.terminated_at AS volumes_1_terminated_at, volumes_1.display_name AS volumes_1_display_name, volumes_1.display_description AS volumes_1_display_description, volumes_1.provider_location AS volumes_1_provider_location, volumes_1.provider_auth AS volumes_1_provider_auth, volumes_1.volume_type_id AS volumes_1_volume_type_id, networks_1.created_at AS networks_1_created_at, networks_1.updated_at AS networks_1_updated_at, networks_1.deleted_at AS networks_1_deleted_at, networks_1.deleted AS networks_1_deleted, networks_1.id AS networks_1_id, networks_1.label AS networks_1_label, networks_1.injected AS networks_1_injected, networks_1.cidr AS networks_1_cidr, networks_1.cidr_v6 AS networks_1_cidr_v6, networks_1.multi_host AS networks_1_multi_host, networks_1.gateway_v6 AS networks_1_gateway_v6, networks_1.netmask_v6 AS networks_1_netmask_v6, networks_1.netmask AS networks_1_netmask, networks_1.bridge AS networks_1_bridge, networks_1.bridge_interface AS networks_1_bridge_interface, networks_1.gateway AS networks_1_gateway, networks_1.broadcast AS networks_1_broadcast, networks_1.dns1 AS networks_1_dns1, networks_1.dns2 AS networks_1_dns2, networks_1.vlan AS networks_1_vlan, networks_1.vpn_public_address AS networks_1_vpn_public_address, networks_1.vpn_public_port AS networks_1_vpn_public_port, networks_1.vpn_private_address AS networks_1_vpn_private_address, networks_1.dhcp_start AS networks_1_dhcp_start, networks_1.project_id AS networks_1_project_id, networks_1.priority AS networks_1_priority, networks_1.host AS networks_1_host, networks_1.uuid AS networks_1_uuid, fixed_ips_1.created_at AS fixed_ips_1_created_at, fixed_ips_1.updated_at AS fixed_ips_1_updated_at, fixed_ips_1.deleted_at AS fixed_ips_1_deleted_at, fixed_ips_1.deleted AS fixed_ips_1_deleted, fixed_ips_1.id AS fixed_ips_1_id, fixed_ips_1.address AS fixed_ips_1_address, fixed_ips_1.network_id AS fixed_ips_1_network_id, fixed_ips_1.virtual_interface_id AS fixed_ips_1_virtual_interface_id, fixed_ips_1.instance_id AS fixed_ips_1_instance_id, fixed_ips_1.allocated AS fixed_ips_1_allocated, fixed_ips_1.leased AS fixed_ips_1_leased, fixed_ips_1.reserved AS fixed_ips_1_reserved, fixed_ips_1.host AS fixed_ips_1_host, floating_ips_1.created_at AS floating_ips_1_created_at, floating_ips_1.updated_at AS floating_ips_1_updated_at, floating_ips_1.deleted_at AS floating_ips_1_deleted_at, floating_ips_1.deleted AS floating_ips_1_deleted, floating_ips_1.id AS floating_ips_1_id, floating_ips_1.address AS floating_ips_1_address, floating_ips_1.fixed_ip_id AS floating_ips_1_fixed_ip_id, floating_ips_1.project_id AS floating_ips_1_project_id, floating_ips_1.host AS floating_ips_1_host, floating_ips_1.auto_assigned AS floating_ips_1_auto_assigned, instance_types_1.created_at AS instance_types_1_created_at, instance_types_1.updated_at AS instance_types_1_updated_at, instance_types_1.deleted_at AS instance_types_1_deleted_at, instance_types_1.deleted AS instance_types_1_deleted, instance_types_1.id AS instance_types_1_id, instance_types_1.name AS instance_types_1_name, instance_types_1.memory_mb AS instance_types_1_memory_mb, instance_types_1.vcpus AS instance_types_1_vcpus, instance_types_1.local_gb AS instance_types_1_local_gb, instance_types_1.flavorid AS instance_types_1_flavorid, instance_types_1.swap AS instance_types_1_swap, instance_types_1.rxtx_quota AS instance_types_1_rxtx_quota, instance_types_1.rxtx_cap AS instance_types_1_rxtx_cap, virtual_interfaces_1.created_at AS virtual_interfaces_1_created_at, virtual_interfaces_1.updated_at AS virtual_interfaces_1_updated_at, virtual_interfaces_1.deleted_at AS virtual_interfaces_1_deleted_at, virtual_interfaces_1.deleted AS virtual_interfaces_1_deleted, virtual_interfaces_1.id AS virtual_interfaces_1_id, virtual_interfaces_1.address AS virtual_interfaces_1_address, virtual_interfaces_1.network_id AS virtual_interfaces_1_network_id, virtual_interfaces_1.instance_id AS virtual_interfaces_1_instance_id, virtual_interfaces_1.uuid AS virtual_interfaces_1_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_deleted_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_id AS instance_metadata_1_instance_id \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.server_name AS instances_server_name, 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.local_gb AS instances_local_gb, instances.hostname AS instances_hostname, instances.host AS instances_host, 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.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_local_device AS instances_default_local_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 \nFROM instances \nWHERE instances.deleted = %(deleted_1)s AND instances.id = %(id_1)s \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN volumes AS volumes_1 ON volumes_1.instance_id = anon_1.instances_id AND volumes_1.deleted = %(deleted_2)s LEFT OUTER JOIN fixed_ips AS fixed_ips_1 ON fixed_ips_1.instance_id = anon_1.instances_id AND fixed_ips_1.deleted = %(deleted_3)s LEFT OUTER JOIN networks AS networks_1 ON networks_1.id = fixed_ips_1.network_id LEFT OUTER JOIN floating_ips AS floating_ips_1 ON floating_ips_1.fixed_ip_id = fixed_ips_1.id AND floating_ips_1.deleted = %(deleted_4)s LEFT OUTER JOIN instance_types AS instance_types_1 ON anon_1.instances_instance_type_id = instance_types_1.id LEFT OUTER JOIN virtual_interfaces AS virtual_interfaces_1 ON anon_1.instances_id = virtual_interfaces_1.instance_id LEFT OUTER JOIN security_group_instance_association AS security_group_instance_association_1 ON security_group_instance_association_1.instance_id = anon_1.instances_id AND anon_1.instances_deleted = %(deleted_5)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 = %(deleted_6)s AND security_groups_1.deleted = %(deleted_7)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 = %(deleted_8)s LEFT OUTER JOIN instance_metadata AS instance_metadata_1 ON instance_metadata_1.instance_id = anon_1.instances_id AND instance_metadata_1.deleted = %(deleted_9)s' {'deleted_9': False, 'deleted_8': False, 'deleted_7': False, 'deleted_6': False, 'deleted_5': False, 'deleted_4': False, 'deleted_3': False, 'deleted_2': False, 'deleted_1': False, 'id_1': u'i-0000000b'}
  (nova.api.openstack): TRACE: Traceback (most recent call last):
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/__init__.py", line 64, in __call__
  (nova.api.openstack): TRACE:     return req.get_response(self.application)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response
  (nova.api.openstack): TRACE:     application, catch_exc_info=False)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application
  (nova.api.openstack): TRACE:     app_iter = application(self.environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__
  (nova.api.openstack): TRACE:     return resp(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__
  (nova.api.openstack): TRACE:     return resp(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__
  (nova.api.openstack): TRACE:     return resp(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__
  (nova.api.openstack): TRACE:     response = self.app(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__
  (nova.api.openstack): TRACE:     return resp(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__
  (nova.api.openstack): TRACE:     return resp(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__
  (nova.api.openstack): TRACE:     response = self.app(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__
  (nova.api.openstack): TRACE:     return resp(environ, start_response)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__
  (nova.api.openstack): TRACE:     resp = self.call_func(req, *args, **self.kwargs)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func
  (nova.api.openstack): TRACE:     return self.func(req, *args, **kwargs)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py", line 494, in __call__
  (nova.api.openstack): TRACE:     action_result = self.dispatch(request, action, args)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/wsgi.py", line 522, in dispatch
  (nova.api.openstack): TRACE:     return controller_method(req=request, **action_args)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/scheduler/api.py", line 382, in new_f
  (nova.api.openstack): TRACE:     return f(*args, **kwargs)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/api/openstack/servers.py", line 647, in delete
  (nova.api.openstack): TRACE:     self.compute_api.delete(req.environ['nova.context'], id)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/scheduler/api.py", line 317, in wrapped_f
  (nova.api.openstack): TRACE:     return f(*args, **kwargs)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 759, in delete
  (nova.api.openstack): TRACE:     instance = self._get_instance(context, instance_id, 'terminating')
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 748, in _get_instance
  (nova.api.openstack): TRACE:     return self.get(context, instance_id)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/compute/api.py", line 839, in get
  (nova.api.openstack): TRACE:     instance = self.db.instance_get(context, instance_id)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 495, in instance_get
  (nova.api.openstack): TRACE:     return IMPL.instance_get(context, instance_id)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 119, in wrapper
  (nova.api.openstack): TRACE:     return f(*args, **kwargs)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 1162, in instance_get
  (nova.api.openstack): TRACE:     result = result.first()
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1652, in first
  (nova.api.openstack): TRACE:     ret = list(self[0:1])
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1560, in __getitem__
  (nova.api.openstack): TRACE:     return list(res)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1721, in __iter__
  (nova.api.openstack): TRACE:     return self._execute_and_instances(context)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1726, in _execute_and_instances
  (nova.api.openstack): TRACE:     mapper=self._mapper_zero_or_none())
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 724, in execute
  (nova.api.openstack): TRACE:     clause, params or {})
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1191, in execute
  (nova.api.openstack): TRACE:     params)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
  (nova.api.openstack): TRACE:     return self.__execute_context(context)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1302, in __execute_context
  (nova.api.openstack): TRACE:     context.parameters[0], context=context)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
  (nova.api.openstack): TRACE:     context)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
  (nova.api.openstack): TRACE:     context)
  (nova.api.openstack): TRACE:   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute
  (nova.api.openstack): TRACE:     cursor.execute(statement, parameters)
  (nova.api.openstack): TRACE: DataError: (DataError) invalid input syntax for integer: "i-0000000b"
  (nova.api.openstack): TRACE: LINE 4: ...HERE instances.deleted = false AND instances.id = 'i-0000000...
  (nova.api.openstack): TRACE:                                                              ^
  (nova.api.openstack): TRACE:  '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_server_name AS anon_1_instances_server_name, 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_state, 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_local_gb AS anon_1_instances_local_gb, anon_1.instances_hostname AS anon_1_instances_hostname, anon_1.instances_host AS anon_1_instances_host, 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_description 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_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_local_device AS anon_1_instances_default_local_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, volumes_1.created_at AS volumes_1_created_at, volumes_1.updated_at AS volumes_1_updated_at, volumes_1.deleted_at AS volumes_1_deleted_at, volumes_1.deleted AS volumes_1_deleted, volumes_1.id AS volumes_1_id, volumes_1.user_id AS volumes_1_user_id, volumes_1.project_id AS volumes_1_project_id, volumes_1.snapshot_id AS volumes_1_snapshot_id, volumes_1.host AS volumes_1_host, volumes_1.size AS volumes_1_size, volumes_1.availability_zone AS volumes_1_availability_zone, volumes_1.instance_id AS volumes_1_instance_id, volumes_1.mountpoint AS volumes_1_mountpoint, volumes_1.attach_time AS volumes_1_attach_time, volumes_1.status AS volumes_1_status, volumes_1.attach_status AS volumes_1_attach_status, volumes_1.scheduled_at AS volumes_1_scheduled_at, volumes_1.launched_at AS volumes_1_launched_at, volumes_1.terminated_at AS volumes_1_terminated_at, volumes_1.display_name AS volumes_1_display_name, volumes_1.display_description AS volumes_1_display_description, volumes_1.provider_location AS volumes_1_provider_location, volumes_1.provider_auth AS volumes_1_provider_auth, volumes_1.volume_type_id AS volumes_1_volume_type_id, networks_1.created_at AS networks_1_created_at, networks_1.updated_at AS networks_1_updated_at, networks_1.deleted_at AS networks_1_deleted_at, networks_1.deleted AS networks_1_deleted, networks_1.id AS networks_1_id, networks_1.label AS networks_1_label, networks_1.injected AS networks_1_injected, networks_1.cidr AS networks_1_cidr, networks_1.cidr_v6 AS networks_1_cidr_v6, networks_1.multi_host AS networks_1_multi_host, networks_1.gateway_v6 AS networks_1_gateway_v6, networks_1.netmask_v6 AS networks_1_netmask_v6, networks_1.netmask AS networks_1_netmask, networks_1.bridge AS networks_1_bridge, networks_1.bridge_interface AS networks_1_bridge_interface, networks_1.gateway AS networks_1_gateway, networks_1.broadcast AS networks_1_broadcast, networks_1.dns1 AS networks_1_dns1, networks_1.dns2 AS networks_1_dns2, networks_1.vlan AS networks_1_vlan, networks_1.vpn_public_address AS networks_1_vpn_public_address, networks_1.vpn_public_port AS networks_1_vpn_public_port, networks_1.vpn_private_address AS networks_1_vpn_private_address, networks_1.dhcp_start AS networks_1_dhcp_start, networks_1.project_id AS networks_1_project_id, networks_1.priority AS networks_1_priority, networks_1.host AS networks_1_host, networks_1.uuid AS networks_1_uuid, fixed_ips_1.created_at AS fixed_ips_1_created_at, fixed_ips_1.updated_at AS fixed_ips_1_updated_at, fixed_ips_1.deleted_at AS fixed_ips_1_deleted_at, fixed_ips_1.deleted AS fixed_ips_1_deleted, fixed_ips_1.id AS fixed_ips_1_id, fixed_ips_1.address AS fixed_ips_1_address, fixed_ips_1.network_id AS fixed_ips_1_network_id, fixed_ips_1.virtual_interface_id AS fixed_ips_1_virtual_interface_id, fixed_ips_1.instance_id AS fixed_ips_1_instance_id, fixed_ips_1.allocated AS fixed_ips_1_allocated, fixed_ips_1.leased AS fixed_ips_1_leased, fixed_ips_1.reserved AS fixed_ips_1_reserved, fixed_ips_1.host AS fixed_ips_1_host, floating_ips_1.created_at AS floating_ips_1_created_at, floating_ips_1.updated_at AS floating_ips_1_updated_at, floating_ips_1.deleted_at AS floating_ips_1_deleted_at, floating_ips_1.deleted AS floating_ips_1_deleted, floating_ips_1.id AS floating_ips_1_id, floating_ips_1.address AS floating_ips_1_address, floating_ips_1.fixed_ip_id AS floating_ips_1_fixed_ip_id, floating_ips_1.project_id AS floating_ips_1_project_id, floating_ips_1.host AS floating_ips_1_host, floating_ips_1.auto_assigned AS floating_ips_1_auto_assigned, instance_types_1.created_at AS instance_types_1_created_at, instance_types_1.updated_at AS instance_types_1_updated_at, instance_types_1.deleted_at AS instance_types_1_deleted_at, instance_types_1.deleted AS instance_types_1_deleted, instance_types_1.id AS instance_types_1_id, instance_types_1.name AS instance_types_1_name, instance_types_1.memory_mb AS instance_types_1_memory_mb, instance_types_1.vcpus AS instance_types_1_vcpus, instance_types_1.local_gb AS instance_types_1_local_gb, instance_types_1.flavorid AS instance_types_1_flavorid, instance_types_1.swap AS instance_types_1_swap, instance_types_1.rxtx_quota AS instance_types_1_rxtx_quota, instance_types_1.rxtx_cap AS instance_types_1_rxtx_cap, virtual_interfaces_1.created_at AS virtual_interfaces_1_created_at, virtual_interfaces_1.updated_at AS virtual_interfaces_1_updated_at, virtual_interfaces_1.deleted_at AS virtual_interfaces_1_deleted_at, virtual_interfaces_1.deleted AS virtual_interfaces_1_deleted, virtual_interfaces_1.id AS virtual_interfaces_1_id, virtual_interfaces_1.address AS virtual_interfaces_1_address, virtual_interfaces_1.network_id AS virtual_interfaces_1_network_id, virtual_interfaces_1.instance_id AS virtual_interfaces_1_instance_id, virtual_interfaces_1.uuid AS virtual_interfaces_1_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_deleted_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_id AS instance_metadata_1_instance_id \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.server_name AS instances_server_name, 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.local_gb AS instances_local_gb, instances.hostname AS instances_hostname, instances.host AS instances_host, 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.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_local_device AS instances_default_local_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 \nFROM instances \nWHERE instances.deleted = %(deleted_1)s AND instances.id = %(id_1)s \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN volumes AS volumes_1 ON volumes_1.instance_id = anon_1.instances_id AND volumes_1.deleted = %(deleted_2)s LEFT OUTER JOIN fixed_ips AS fixed_ips_1 ON fixed_ips_1.instance_id = anon_1.instances_id AND fixed_ips_1.deleted = %(deleted_3)s LEFT OUTER JOIN networks AS networks_1 ON networks_1.id = fixed_ips_1.network_id LEFT OUTER JOIN floating_ips AS floating_ips_1 ON floating_ips_1.fixed_ip_id = fixed_ips_1.id AND floating_ips_1.deleted = %(deleted_4)s LEFT OUTER JOIN instance_types AS instance_types_1 ON anon_1.instances_instance_type_id = instance_types_1.id LEFT OUTER JOIN virtual_interfaces AS virtual_interfaces_1 ON anon_1.instances_id = virtual_interfaces_1.instance_id LEFT OUTER JOIN security_group_instance_association AS security_group_instance_association_1 ON security_group_instance_association_1.instance_id = anon_1.instances_id AND anon_1.instances_deleted = %(deleted_5)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 = %(deleted_6)s AND security_groups_1.deleted = %(deleted_7)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 = %(deleted_8)s LEFT OUTER JOIN instance_metadata AS instance_metadata_1 ON instance_metadata_1.instance_id = anon_1.instances_id AND instance_metadata_1.deleted = %(deleted_9)s' {'deleted_9': False, 'deleted_8': False, 'deleted_7': False, 'deleted_6': False, 'deleted_5': False, 'deleted_4': False, 'deleted_3': False, 'deleted_2': False, 'deleted_1': False, 'id_1': u'i-0000000b'}
  (nova.api.openstack): TRACE:

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/885414/+subscriptions