Comment 2 for bug 1028465

Revision history for this message
Jay Pipes (jaypipes) wrote : Re: ListServersTest failing on non-smoke test Tempest run

So, it turns out that name search parameters are not passed to exact match column filters any more, but instead are passed to Regex filters :( And it is this that is incorrectly filtering the wrong instances from the output. I added some debug output into nova-api in order to identify the problem...

2012-07-24 11:46:28 DEBUG nova.db.sqlalchemy.api [req-7ecfafb0-3619-49ef-b9f8-dc55eea647d1 ListServerFiltersTest-user ListServerFiltersTest-tenant] *** BEFORE REGEX *** [{'vm_state': u'active', 'availability_zone': None, 'terminated_at': None, 'ramdisk_id': u'a529e5e8-451f-4049-bad1-2d884111d712', 'instance_type_id': 2L, 'updated_at': datetime.datetime(2012, 7, 24, 15, 46, 26), 'vm_mode': None, 'deleted_at': None, 'reservation_id': u'r-tt0b5sbj', 'id': 13L, 'disable_terminate': False, 'root_device_name': u'/dev/vda', 'user_id': u'c04b37baeb164a9689e8f0a0195a2e32', 'uuid': u'4576e6d3-d257-4e28-b68b-30e3efe50d52', 'server_name': None, 'default_swap_device': None, 'hostname': u'server63679872311', 'launched_on': u'uberbox', 'display_description': u'server63679872311', 'key_data': None, 'kernel_id': u'00c2b5f2-75ce-46f2-81d9-775ea5a8682b', 'power_state': 1L, 'default_ephemeral_device': None, 'progress': 0L, 'project_id': u'ea7414d9efe0467f96a8bbf29d0bcd60', 'launched_at': datetime.datetime(2012, 7, 24, 15, 46, 26), 'scheduled_at': datetime.datetime(2012, 7, 24, 15, 46), 'ephemeral_gb': 0L, 'access_ip_v6': None, 'access_ip_v4': None, 'deleted': False, 'key_name': None, 'user_data': u'', 'host': u'uberbox', 'display_name': u'server63679872311', 'task_state': None, 'shutdown_terminate': False, 'root_gb': 0L, 'locked': False, 'created_at': datetime.datetime(2012, 7, 24, 15, 46), 'launch_index': 0L, 'memory_mb': 512L, 'vcpus': 1L, 'image_ref': u'7f697b5a-65a2-4130-a891-a9d6d4c856ed', 'architecture': None, 'auto_disk_config': None, 'os_type': None, 'config_drive': u''}, {'vm_state': u'active', 'availability_zone': None, 'terminated_at': None, 'ramdisk_id': u'a529e5e8-451f-4049-bad1-2d884111d712', 'instance_type_id': 2L, 'updated_at': datetime.datetime(2012, 7, 24, 15, 46, 24), 'vm_mode': None, 'deleted_at': None, 'reservation_id': u'r-bpytbf2j', 'id': 14L, 'disable_terminate': False, 'root_device_name': u'/dev/vda', 'user_id': u'c04b37baeb164a9689e8f0a0195a2e32', 'uuid': u'd14f038b-d258-4391-858d-e4bf300e7a99', 'server_name': None, 'default_swap_device': None, 'hostname': u'server952716972', 'launched_on': u'uberbox', 'display_description': u'server952716972', 'key_data': None, 'kernel_id': u'00c2b5f2-75ce-46f2-81d9-775ea5a8682b', 'power_state': 1L, 'default_ephemeral_device': None, 'progress': 0L, 'project_id': u'ea7414d9efe0467f96a8bbf29d0bcd60', 'launched_at': datetime.datetime(2012, 7, 24, 15, 46, 24), 'scheduled_at': datetime.datetime(2012, 7, 24, 15, 46), 'ephemeral_gb': 0L, 'access_ip_v6': None, 'access_ip_v4': None, 'deleted': False, 'key_name': None, 'user_data': u'', 'host': u'uberbox', 'display_name': u'server952716972', 'task_state': None, 'shutdown_terminate': False, 'root_gb': 0L, 'locked': False, 'created_at': datetime.datetime(2012, 7, 24, 15, 46), 'launch_index': 0L, 'memory_mb': 512L, 'vcpus': 1L, 'image_ref': u'7f697b5a-65a2-4130-a891-a9d6d4c856ed', 'architecture': None, 'auto_disk_config': None, 'os_type': None, 'config_drive': u''}, {'vm_state': u'active', 'availability_zone': None, 'terminated_at': None, 'ramdisk_id': u'a529e5e8-451f-4049-bad1-2d884111d712', 'instance_type_id': 5L, 'updated_at': datetime.datetime(2012, 7, 24, 15, 46, 26), 'vm_mode': None, 'deleted_at': None, 'reservation_id': u'r-vgfb4i5l', 'id': 15L, 'disable_terminate': False, 'root_device_name': u'/dev/vda', 'user_id': u'c04b37baeb164a9689e8f0a0195a2e32', 'uuid': u'3819a879-4a1c-48a2-ad1c-975fb0dfb34b', 'server_name': None, 'default_swap_device': None, 'hostname': u'server34066490098', 'launched_on': u'uberbox', 'display_description': u'server34066490098', 'key_data': None, 'kernel_id': u'00c2b5f2-75ce-46f2-81d9-775ea5a8682b', 'power_state': 1L, 'default_ephemeral_device': None, 'progress': 0L, 'project_id': u'ea7414d9efe0467f96a8bbf29d0bcd60', 'launched_at': datetime.datetime(2012, 7, 24, 15, 46, 26), 'scheduled_at': datetime.datetime(2012, 7, 24, 15, 46, 1), 'ephemeral_gb': 0L, 'access_ip_v6': None, 'access_ip_v4': None, 'deleted': False, 'key_name': None, 'user_data': u'', 'host': u'uberbox', 'display_name': u'server34066490098', 'task_state': None, 'shutdown_terminate': False, 'root_gb': 20L, 'locked': False, 'created_at': datetime.datetime(2012, 7, 24, 15, 46), 'launch_index': 0L, 'memory_mb': 2048L, 'vcpus': 1L, 'image_ref': u'7f697b5a-65a2-4130-a891-a9d6d4c856ed', 'architecture': None, 'auto_disk_config': None, 'os_type': None, 'config_drive': u''}] from (pid=15971) instance_get_all_by_filters /opt/stack/nova/nova/db/sqlalchemy/api.py:1565
2012-07-24 11:46:28 DEBUG nova.db.sqlalchemy.api [req-7ecfafb0-3619-49ef-b9f8-dc55eea647d1 ListServerFiltersTest-user ListServerFiltersTest-tenant] *** AFTER REGEX *** [{'vm_state': u'active', 'availability_zone': None, 'terminated_at': None, 'ramdisk_id': u'a529e5e8-451f-4049-bad1-2d884111d712', 'instance_type_id': 2L, 'updated_at': datetime.datetime(2012, 7, 24, 15, 46, 26), 'vm_mode': None, 'deleted_at': None, 'reservation_id': u'r-tt0b5sbj', 'id': 13L, 'disable_terminate': False, 'root_device_name': u'/dev/vda', 'user_id': u'c04b37baeb164a9689e8f0a0195a2e32', 'uuid': u'4576e6d3-d257-4e28-b68b-30e3efe50d52', 'server_name': None, 'default_swap_device': None, 'hostname': u'server63679872311', 'launched_on': u'uberbox', 'display_description': u'server63679872311', 'key_data': None, 'kernel_id': u'00c2b5f2-75ce-46f2-81d9-775ea5a8682b', 'power_state': 1L, 'default_ephemeral_device': None, 'progress': 0L, 'project_id': u'ea7414d9efe0467f96a8bbf29d0bcd60', 'launched_at': datetime.datetime(2012, 7, 24, 15, 46, 26), 'scheduled_at': datetime.datetime(2012, 7, 24, 15, 46), 'ephemeral_gb': 0L, 'access_ip_v6': None, 'access_ip_v4': None, 'deleted': False, 'key_name': None, 'user_data': u'', 'host': u'uberbox', 'display_name': u'server63679872311', 'task_state': None, 'shutdown_terminate': False, 'root_gb': 0L, 'locked': False, 'created_at': datetime.datetime(2012, 7, 24, 15, 46), 'launch_index': 0L, 'memory_mb': 512L, 'vcpus': 1L, 'image_ref': u'7f697b5a-65a2-4130-a891-a9d6d4c856ed', 'architecture': None, 'auto_disk_config': None, 'os_type': None, 'config_drive': u''}] from (pid=15971) instance_get_all_by_filters /opt/stack/nova/nova/db/sqlalchemy/api.py:1585