<div><div><div>Hi all,</div></div></div><div><br></div><div>I installed openstack (folsom release) on Ubuntu Server 12.04 (+XCP).</div><div>I just got this error, when I try to access the dashboard. Do you have any ideas to solve it?</div>
<div>Thank you</div><div><br></div><div>--------</div><div>2013-03-06 15:56:23 INFO nova.api.openstack.wsgi [req-e14c63e6-b2c4-4ca7-99fa-e294c0d73a3c Afef cep4cma] GET <a href="http://10.0.1.15:8774/v2/2f4008b766f648d4a5b55b9d88ffd23e/servers/detail?project_id=2f4008b766f648d4a5b55b9d88ffd23e">http://10.0.1.15:8774/v2/2f4008b766f648d4a5b55b9d88ffd23e/servers/detail?project_id=2f4008b766f648d4a5b55b9d88ffd23e</a></div>
<div>2013-03-06 15:56:23 DEBUG nova.api.openstack.wsgi [req-e14c63e6-b2c4-4ca7-99fa-e294c0d73a3c Afef cep4cma] No Content-Type provided in request from (pid=24807) get_body /opt/stack/nova/nova/api/openstack/wsgi.py:792</div>
<div>2013-03-06 15:56:23 DEBUG nova.compute.api [req-e14c63e6-b2c4-4ca7-99fa-e294c0d73a3c Afef cep4cma] Searching by: {'deleted': False, 'project_id': u'2f4008b766f648d4a5b55b9d88ffd23e'} from (pid=24807) get_all /opt/stack/nova/nova/compute/api.py:1119</div>
<div>2013-03-06 15:56:23 ERROR nova.api.openstack [req-e14c63e6-b2c4-4ca7-99fa-e294c0d73a3c Afef cep4cma] Caught error: (InternalError) (126, "Incorrect key file for table '/tmp/#sql_38cf_0.MYI'; try to repair it") '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_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_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_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_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_progress, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate, anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate, 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, <a href="http://security_groups_1.id">security_groups_1.id</a> AS security_groups_1_id, <a href="http://security_groups_1.name">security_groups_1.name</a> 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, 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, <a href="http://instance_metadata_1.id">instance_metadata_1.id</a> 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_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, <a href="http://instance_info_caches_1.id">instance_info_caches_1.id</a> 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, 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, <a href="http://instance_types_1.id">instance_types_1.id</a> AS instance_types_1_id, <a href="http://instance_types_1.name">instance_types_1.name</a> 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.root_gb AS instance_types_1_root_gb, instance_types_1.ephemeral_gb AS instance_types_1_ephemeral_gb, instance_types_1.flavorid AS instance_types_1_flavorid, instance_types_1.swap AS instance_types_1_swap, instance_types_1.rxtx_factor AS instance_types_1_rxtx_factor, instance_types_1.vcpu_weight AS instance_types_1_vcpu_weight, instance_types_1.disabled AS instance_types_1_disabled, instance_types_1.is_public AS instance_types_1_is_public, 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, <a href="http://instance_system_metadata_1.id">instance_system_metadata_1.id</a> 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, <a href="http://instances.id">instances.id</a> 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.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 \nFROM instances \nWHERE instances.deleted = %s AND instances.vm_state != %s AND instances.project_id = %s ORDER BY instances.created_at DESC, instances.created_at DESC, instances.created_at DESC, <a href="http://instances.id">instances.id</a> DESC \n LIMIT %s) AS anon_1 LEFT OUTER JOIN security_group_instance_association AS security_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 <a href="http://security_groups_1.id">security_groups_1.id</a> = 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 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_info_caches AS instance_info_caches_1 ON instance_info_caches_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN instance_types AS instance_types_1 ON anon_1.instances_instance_type_id = <a href="http://instance_types_1.id">instance_types_1.id</a> 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 ORDER BY anon_1.instances_created_at DESC, anon_1.instances_created_at DESC, anon_1.instances_created_at DESC, anon_1.instances_id DESC' (0, 'soft-delete', '2f4008b766f648d4a5b55b9d88ffd23e', 1000, 0, 0, 0, 0, 0)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack Traceback (most recent call last):</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/api/openstack/__init__.py", line 81, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return req.get_response(self.application)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1053, in get_response</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack application, catch_exc_info=False)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1022, in call_application</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack app_iter = application(self.environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return resp(environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/keystone/keystone/middleware/auth_token.py", line 288, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return self.app(env, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return resp(environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return resp(environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return resp(environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack response = self.app(environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return resp(environ, start_response)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack resp = self.call_func(req, *args, **self.kwargs)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 208, in call_func</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return self.func(req, *args, **kwargs)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/api/openstack/wsgi.py", line 895, in __call__</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack content_type, body, accept)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/api/openstack/wsgi.py", line 951, in _process_stack</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack action_result = self.dispatch(meth, request, action_args)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/api/openstack/wsgi.py", line 1040, in dispatch</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack return method(req=request, **action_args)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/api/openstack/compute/servers.py", line 455, in detail</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack servers = self._get_servers(req, is_detail=True)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/api/openstack/compute/servers.py", line 536, in _get_servers</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack marker=marker)</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/compute/api.py", line 1173, in get_all</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack marker=marker)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/compute/api.py", line 1199, in _get_instances_by_filters</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack limit=limit, marker=marker)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/db/api.py", line 590, in instance_get_all_by_filters</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack marker=marker)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 125, in wrapper</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack return f(*args, **kwargs)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/opt/stack/nova/nova/db/sqlalchemy/api.py", line 1571, in instance_get_all_by_filters</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack instances = query_prefix.all()</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack return list(self)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack return self._execute_and_instances(context)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack result = conn.execute(querycontext.statement, self._params)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack params)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack compiled_sql, distilled_params</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack context)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1850, in _handle_dbapi_exception</div><div>2013-03-06 15:56:23 TRACE nova.api.openstack None, sys.exc_info()[2]</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack InternalError: (InternalError) (126, "Incorrect key file for table '/tmp/#sql_38cf_0.MYI'; try to repair it") '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_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_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_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_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_progress, anon_1.instances_shutdown_terminate AS anon_1_instances_shutdown_terminate, anon_1.instances_disable_terminate AS anon_1_instances_disable_terminate, 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, <a href="http://security_groups_1.id">security_groups_1.id</a> AS security_groups_1_id, <a href="http://security_groups_1.name">security_groups_1.name</a> 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, 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, <a href="http://instance_metadata_1.id">instance_metadata_1.id</a> 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_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, <a href="http://instance_info_caches_1.id">instance_info_caches_1.id</a> 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, 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, <a href="http://instance_types_1.id">instance_types_1.id</a> AS instance_types_1_id, <a href="http://instance_types_1.name">instance_types_1.name</a> 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.root_gb AS instance_types_1_root_gb, instance_types_1.ephemeral_gb AS instance_types_1_ephemeral_gb, instance_types_1.flavorid AS instance_types_1_flavorid, instance_types_1.swap AS instance_types_1_swap, instance_types_1.rxtx_factor AS instance_types_1_rxtx_factor, instance_types_1.vcpu_weight AS instance_types_1_vcpu_weight, instance_types_1.disabled AS instance_types_1_disabled, instance_types_1.is_public AS instance_types_1_is_public, 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, <a href="http://instance_system_metadata_1.id">instance_system_metadata_1.id</a> 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, <a href="http://instances.id">instances.id</a> 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.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 \nFROM instances \nWHERE instances.deleted = %s AND instances.vm_state != %s AND instances.project_id = %s ORDER BY instances.created_at DESC, instances.created_at DESC, instances.created_at DESC, <a href="http://instances.id">instances.id</a> DESC \n LIMIT %s) AS anon_1 LEFT OUTER JOIN security_group_instance_association AS security_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 <a href="http://security_groups_1.id">security_groups_1.id</a> = 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 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_info_caches AS instance_info_caches_1 ON instance_info_caches_1.instance_uuid = anon_1.instances_uuid LEFT OUTER JOIN instance_types AS instance_types_1 ON anon_1.instances_instance_type_id = <a href="http://instance_types_1.id">instance_types_1.id</a> 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 ORDER BY anon_1.instances_created_at DESC, anon_1.instances_created_at DESC, anon_1.instances_created_at DESC, anon_1.instances_id DESC' (0, 'soft-delete', '2f4008b766f648d4a5b55b9d88ffd23e', 1000, 0, 0, 0, 0, 0)</div>
<div>2013-03-06 15:56:23 TRACE nova.api.openstack </div><div>2013-03-06 15:56:23 INFO nova.api.openstack [req-e14c63e6-b2c4-4ca7-99fa-e294c0d73a3c Afef cep4cma] <a href="http://10.0.1.15:8774/v2/2f4008b766f648d4a5b55b9d88ffd23e/servers/detail?project_id=2f4008b766f648d4a5b55b9d88ffd23e">http://10.0.1.15:8774/v2/2f4008b766f648d4a5b55b9d88ffd23e/servers/detail?project_id=2f4008b766f648d4a5b55b9d88ffd23e</a> returned with HTTP 500</div>
<div>2013-03-06 15:56:23 INFO nova.osapi_compute.wsgi.server [req-e14c63e6-b2c4-4ca7-99fa-e294c0d73a3c Afef cep4cma] 10.0.1.15 "GET /v2/2f4008b766f648d4a5b55b9d88ffd23e/servers/detail?project_id=2f4008b766f648d4a5b55b9d88ffd23e HTTP/1.1" status: 500 len: 335 time: 0.1432030</div>
<div>------------</div><div><br></div>