The attempt to merge lp:~termie/nova/db_migration into lp:nova failed. Below is the output from the failed tests. TrialTestCase runTest ok AdminAPITest test_admin_disabled ok test_admin_enabled ok APITest test_exceptions_are_converted_to_faults ok Test test_authorize_token ok test_authorize_user ok test_bad_token ok test_bad_user ok test_no_user ok test_token_expiry ok TestLimiter test_authorize_token ok TestFaults test_fault_parts ok test_raise ok test_retry_header ok FlavorsTest test_get_flavor_by_id ok test_get_flavor_list ok GlanceImageServiceTest test_create ok test_create_and_show_non_existing_image ok test_delete ok test_update ok ImageControllerWithGlanceServiceTest test_get_image_details ok test_get_image_index ok LocalImageServiceTest test_create ok test_create_and_show_non_existing_image ok test_delete ok test_update ok LimiterTest test_minute ok test_one_per_period ok test_second ok test_users_get_separate_buckets ok test_we_can_go_indefinitely_if_we_spread_out_requests ok WSGIAppProxyTest test_200 ok test_403 ok test_failure ok WSGIAppTest test_escaping ok test_good_urls ok test_invalid_methods ok test_invalid_urls ok test_response_to_delays ok ServersTest test_create_backup_schedules ok test_create_instance ok test_delete_backup_schedules ok test_delete_server_instance ok test_get_all_server_details ok test_get_server_backup_schedules ok test_get_server_by_id ok test_get_server_list ok test_server_actions ok test_server_diagnostics ok test_server_pause ok test_server_reboot ok test_server_rebuild ok test_server_resize ok test_server_resume ok test_server_suspend ok test_server_unpause ok test_update_bad_params ok test_update_no_body ok test_update_server ok SharedIpGroupsTest test_create_shared_ip_group ok test_delete_shared_ip_group ok test_get_shared_ip_groups ok Test test_ec2 ok test_ec2_root ok test_metadata ok test_not_found ok test_openstack ok test_query_api_versions ok SerializerTest test_basic ok test_defaults_to_json ok test_deserialize ok test_deserialize_empty_xml ok test_suffix_takes_precedence_over_accept_header ok Test test_controller ok test_debug **************************************** REQUEST ENVIRON wsgi.multithread = False SCRIPT_NAME = webob.adhoc_attrs = {'response': } wsgi.input = REQUEST_METHOD = GET HTTP_HOST = localhost:80 PATH_INFO = / SERVER_PROTOCOL = HTTP/1.0 QUERY_STRING = wsgi.version = (1, 0) SERVER_NAME = localhost wsgi.run_once = False wsgi.errors = ', mode 'w' at 0x7f5e68c851e0> wsgi.multiprocess = False wsgi.url_scheme = http SERVER_PORT = 80 **************************************** RESPONSE HEADERS X-Test = checking **************************************** BODY Test result ok test_router ok AccessTestCase test_001_allow_all ok test_002_allow_none ok test_003_allow_project_manager ok test_004_allow_sys_and_net ok ApiEc2TestCase runTest ok test_authorize_revoke_security_group_cidr ok test_authorize_revoke_security_group_foreign_group ok test_create_delete_security_group ok test_describe_instances ok test_get_all_key_pairs ok test_get_all_security_groups ok XmlConversionTestCase runTest ok test_number_conversion ok AuthManagerDbTestCase test_004_signature_is_valid ok test_005_can_get_credentials ok test_add_user_role_doesnt_infect_project_roles ok test_adding_role_to_project_is_ignored_unless_added_to_user ok test_can_add_and_remove_user_role ok test_can_add_remove_user_with_role ok test_can_add_user_to_project ok test_can_create_and_get_project ok test_can_create_and_get_project_with_attributes ok test_can_create_project_with_manager ok test_can_delete_project ok test_can_delete_user ok test_can_generate_x509 ok test_can_list_project_roles ok test_can_list_projects ok test_can_list_user_roles ok test_can_list_users ok test_can_modify_project ok test_can_modify_users ok test_can_remove_project_role_but_keep_user_role ok test_can_remove_user_from_project ok test_can_remove_user_roles ok test_can_retrieve_project_by_user ok test_create_and_find_user ok test_create_and_find_with_properties ok test_create_project_assigns_manager_to_members ok test_no_extra_project_managers ok test_no_extra_project_members ok test_removing_user_role_hides_it_from_project ok AuthManagerLdapTestCase test_004_signature_is_valid ok test_005_can_get_credentials ok test_add_user_role_doesnt_infect_project_roles ok test_adding_role_to_project_is_ignored_unless_added_to_user ok test_can_add_and_remove_user_role ok test_can_add_remove_user_with_role ok test_can_add_user_to_project ok test_can_create_and_get_project ok test_can_create_and_get_project_with_attributes ok test_can_create_project_with_manager ok test_can_delete_project ok test_can_delete_user ok test_can_generate_x509 ok test_can_list_project_roles ok test_can_list_projects ok test_can_list_user_roles ok test_can_list_users ok test_can_modify_project ok test_can_modify_users ok test_can_remove_project_role_but_keep_user_role ok test_can_remove_user_from_project ok test_can_remove_user_roles ok test_can_retrieve_project_by_user ok test_create_and_find_user ok test_create_and_find_with_properties ok test_create_project_assigns_manager_to_members ok test_no_extra_project_managers ok test_no_extra_project_members ok test_removing_user_role_hides_it_from_project ok CloudTestCase test_ajax_console ERROR test_associate_disassociate_address ERROR test_console_output ERROR test_delete_key_pair ERROR test_describe_addresses ERROR test_describe_availability_zones ERROR test_describe_instances ERROR test_describe_key_pairs ERROR test_describe_volumes ERROR test_instance_update_state ERROR test_key_generation ERROR test_run_instances ERROR test_update_of_instance_display_fields ERROR test_update_of_instance_wont_update_private_fields ERROR test_update_of_volume_display_fields ERROR test_update_of_volume_wont_update_private_fields ERROR test_user_editable_image_endpoint ERROR ComputeTestCase test_ajax_console ok test_console_output ok test_create_instance_associates_security_groups ok test_create_instance_defaults_display_name ok test_lock ok test_pause ok test_reboot ok test_run_instance_existing ok test_run_terminate ok test_run_terminate_timestamps ok test_snapshot ok test_suspend ok ConsoleTestCase test_add_console ERROR test_add_console_does_not_duplicate ERROR test_get_pool_creates_new_pool_if_needed ERROR test_get_pool_does_not_create_new_pool_if_exists ERROR test_get_pool_for_instance_host ERROR test_remove_console ERROR FlagsTestCase test_declare ok test_define ok test_flag_leak_left ok test_flag_leak_right ok test_runtime_and_unknown_flags ok NovaFormatterTestCase runTest ok test_contextualized_log ok test_debugging_log ok test_uncontextualized_log ok NovaLoggerTestCase runTest ok test_child_log_has_level_of_parent_flag ok test_has_level_from_flags ok RootLoggerTestCase runTest ok test_handlers_have_nova_formatter ok test_handles_context_kwarg ok test_is_nova_instance ok test_module_level_audit_handles_context_arg ok test_module_level_methods_handle_context_arg ok test_name_is_nova_root ok VerboseLoggerTestCase runTest ok test_will_be_verbose_if_named_nova_and_verbose_flag_set ok LockoutTestCase runTest ok test_lockout ok test_multiple_keys ok test_timeout ok test_window_timeout ok ProjectTestCase test_authors_up_to_date ok NetworkTestCase test_allocate_deallocate_fixed_ip ok test_available_ips ok test_ips_are_reused ok test_public_network_association ok test_side_effects ok test_subnet_edge ok test_too_many_addresses ok test_too_many_networks ok test_vpn_ip_and_port_looks_valid ok QuotaTestCase test_quota_overrides ok test_too_many_addresses ok test_too_many_cores ok test_too_many_gigabytes ok test_too_many_instances ok test_too_many_volumes ok RpcTestCase test_call_exception ok test_call_succeed ok test_context_passed ok test_nested_calls ok SchedulerTestCase test_fallback ok test_named_method ok SimpleDriverTestCase test_doesnt_report_disabled_hosts_as_up ERROR test_least_busy_host_gets_instance ERROR test_least_busy_host_gets_volume ERROR test_reports_enabled_hosts_as_up ERROR test_specific_host_gets_instance ERROR test_too_many_cores ERROR test_too_many_gigabytes ERROR test_will_schedule_on_disabled_host_if_specified ERROR test_wont_sechedule_if_specified_host_is_down ERROR ZoneSchedulerTestCase test_with_two_zones ok ServiceFlagsTestCase test_service_disabled_on_create_based_on_flag ERROR test_service_enabled_on_create_based_on_flag ERROR ServiceManagerTestCase test_attribute_error_for_no_manager ok test_message_gets_to_manager ERROR test_override_manager_method ERROR ServiceTestCase test_create ok test_report_state_newly_connected ok test_report_state_newly_disconnected ok test_report_state_no_service ok TwistdTestCase runTest ok test_basic ok test_help ok test_logfile ok IptablesFirewallTestCase test_static_filters ok LibvirtConnTestCase test_xml_and_uri ok test_xml_and_uri_no_kernel ok test_xml_and_uri_no_ramdisk ok test_xml_and_uri_no_ramdisk_no_kernel ok test_xml_and_uri_rescue ok NWFilterTestCase test_cidr_rule_nwfilter_xml ok test_creates_base_rule_first ok VolumeTestCase test_concurrent_volumes_get_different_targets ok test_create_delete_volume ok test_multi_node ok test_run_attach_detach_volume ok test_too_big_volume ok test_too_many_volumes ok XenAPIVMTestCase test_get_diagnostics ok test_instance_snapshot ok test_list_instances_0 ok test_spawn ok XenAPIVolumeTestCase test_attach_volume ok test_attach_volume_raise_exception ok test_create_iscsi_storage ok test_parse_volume_info_raise_exception ok ====================================================================== ERROR: test_ajax_console (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_associate_disassociate_address (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_console_output (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_delete_key_pair (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_describe_addresses (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_describe_availability_zones (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_describe_instances (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_describe_key_pairs (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_describe_volumes (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_instance_update_state (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_key_generation (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_run_instances (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_update_of_instance_display_fields (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_update_of_instance_wont_update_private_fields (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_update_of_volume_display_fields (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_update_of_volume_wont_update_private_fields (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_user_editable_image_endpoint (nova.tests.test_cloud.CloudTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_cloud.py", line 66, in setUp self.compute.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('hudson', 'nova-compute', False) ====================================================================== ERROR: test_add_console (nova.tests.test_console.ConsoleTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_console.py", line 105, in test_add_console self.console.add_console(self.context, instance_id) File "/tmp/tmpJwQOJ4/nova/exception.py", line 88, in _wrap raise Error(str(e)) Error: (OperationalError) no such table: consoles u'SELECT anon_1.console_pools_created_at AS anon_1_console_pools_created_at, anon_1.console_pools_updated_at AS anon_1_console_pools_updated_at, anon_1.console_pools_deleted_at AS anon_1_console_pools_deleted_at, anon_1.console_pools_deleted AS anon_1_console_pools_deleted, anon_1.console_pools_id AS anon_1_console_pools_id, anon_1.console_pools_address AS anon_1_console_pools_address, anon_1.console_pools_username AS anon_1_console_pools_username, anon_1.console_pools_password AS anon_1_console_pools_password, anon_1.console_pools_console_type AS anon_1_console_pools_console_type, anon_1.console_pools_public_hostname AS anon_1_console_pools_public_hostname, anon_1.console_pools_host AS anon_1_console_pools_host, anon_1.console_pools_compute_host AS anon_1_console_pools_compute_host, consoles_1.created_at AS consoles_1_created_at, consoles_1.updated_at AS consoles_1_updated_at, consoles_1.deleted_at AS consoles_1_deleted_at, consoles_1.deleted AS consoles_1_deleted, consoles_1.id AS consoles_1_id, consoles_1.instance_name AS consoles_1_instance_name, consoles_1.instance_id AS consoles_1_instance_id, consoles_1.password AS consoles_1_password, consoles_1.port AS consoles_1_port, consoles_1.pool_id AS consoles_1_pool_id \nFROM (SELECT console_pools.created_at AS console_pools_created_at, console_pools.updated_at AS console_pools_updated_at, console_pools.deleted_at AS console_pools_deleted_at, console_pools.deleted AS console_pools_deleted, console_pools.id AS console_pools_id, console_pools.address AS console_pools_address, console_pools.username AS console_pools_username, console_pools.password AS console_pools_password, console_pools.console_type AS console_pools_console_type, console_pools.public_hostname AS console_pools_public_hostname, console_pools.host AS console_pools_host, console_pools.compute_host AS console_pools_compute_host \nFROM console_pools \nWHERE console_pools.host = ? AND console_pools.console_type = ? AND console_pools.compute_host IS NULL AND console_pools.deleted = ? \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN consoles AS consoles_1 ON anon_1.console_pools_id = consoles_1.pool_id' ('hudson', 'fake', False) ====================================================================== ERROR: test_add_console_does_not_duplicate (nova.tests.test_console.ConsoleTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_console.py", line 117, in test_add_console_does_not_duplicate cons1 = self.console.add_console(self.context, instance_id) File "/tmp/tmpJwQOJ4/nova/exception.py", line 88, in _wrap raise Error(str(e)) Error: (OperationalError) no such table: consoles u'SELECT anon_1.console_pools_created_at AS anon_1_console_pools_created_at, anon_1.console_pools_updated_at AS anon_1_console_pools_updated_at, anon_1.console_pools_deleted_at AS anon_1_console_pools_deleted_at, anon_1.console_pools_deleted AS anon_1_console_pools_deleted, anon_1.console_pools_id AS anon_1_console_pools_id, anon_1.console_pools_address AS anon_1_console_pools_address, anon_1.console_pools_username AS anon_1_console_pools_username, anon_1.console_pools_password AS anon_1_console_pools_password, anon_1.console_pools_console_type AS anon_1_console_pools_console_type, anon_1.console_pools_public_hostname AS anon_1_console_pools_public_hostname, anon_1.console_pools_host AS anon_1_console_pools_host, anon_1.console_pools_compute_host AS anon_1_console_pools_compute_host, consoles_1.created_at AS consoles_1_created_at, consoles_1.updated_at AS consoles_1_updated_at, consoles_1.deleted_at AS consoles_1_deleted_at, consoles_1.deleted AS consoles_1_deleted, consoles_1.id AS consoles_1_id, consoles_1.instance_name AS consoles_1_instance_name, consoles_1.instance_id AS consoles_1_instance_id, consoles_1.password AS consoles_1_password, consoles_1.port AS consoles_1_port, consoles_1.pool_id AS consoles_1_pool_id \nFROM (SELECT console_pools.created_at AS console_pools_created_at, console_pools.updated_at AS console_pools_updated_at, console_pools.deleted_at AS console_pools_deleted_at, console_pools.deleted AS console_pools_deleted, console_pools.id AS console_pools_id, console_pools.address AS console_pools_address, console_pools.username AS console_pools_username, console_pools.password AS console_pools_password, console_pools.console_type AS console_pools_console_type, console_pools.public_hostname AS console_pools_public_hostname, console_pools.host AS console_pools_host, console_pools.compute_host AS console_pools_compute_host \nFROM console_pools \nWHERE console_pools.host = ? AND console_pools.console_type = ? AND console_pools.compute_host IS NULL AND console_pools.deleted = ? \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN consoles AS consoles_1 ON anon_1.console_pools_id = consoles_1.pool_id' ('hudson', 'fake', False) ====================================================================== ERROR: test_get_pool_creates_new_pool_if_needed (nova.tests.test_console.ConsoleTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_console.py", line 82, in test_get_pool_creates_new_pool_if_needed self.console.driver.console_type) File "/usr/lib/python2.6/unittest.py", line 336, in failUnlessRaises callableObj(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 935, in console_pool_get_by_host_type console_type) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 1910, in console_pool_get_by_host_type options(joinedload('consoles')).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such table: consoles u'SELECT anon_1.console_pools_created_at AS anon_1_console_pools_created_at, anon_1.console_pools_updated_at AS anon_1_console_pools_updated_at, anon_1.console_pools_deleted_at AS anon_1_console_pools_deleted_at, anon_1.console_pools_deleted AS anon_1_console_pools_deleted, anon_1.console_pools_id AS anon_1_console_pools_id, anon_1.console_pools_address AS anon_1_console_pools_address, anon_1.console_pools_username AS anon_1_console_pools_username, anon_1.console_pools_password AS anon_1_console_pools_password, anon_1.console_pools_console_type AS anon_1_console_pools_console_type, anon_1.console_pools_public_hostname AS anon_1_console_pools_public_hostname, anon_1.console_pools_host AS anon_1_console_pools_host, anon_1.console_pools_compute_host AS anon_1_console_pools_compute_host, consoles_1.created_at AS consoles_1_created_at, consoles_1.updated_at AS consoles_1_updated_at, consoles_1.deleted_at AS consoles_1_deleted_at, consoles_1.deleted AS consoles_1_deleted, consoles_1.id AS consoles_1_id, consoles_1.instance_name AS consoles_1_instance_name, consoles_1.instance_id AS consoles_1_instance_id, consoles_1.password AS consoles_1_password, consoles_1.port AS consoles_1_port, consoles_1.pool_id AS consoles_1_pool_id \nFROM (SELECT console_pools.created_at AS console_pools_created_at, console_pools.updated_at AS console_pools_updated_at, console_pools.deleted_at AS console_pools_deleted_at, console_pools.deleted AS console_pools_deleted, console_pools.id AS console_pools_id, console_pools.address AS console_pools_address, console_pools.username AS console_pools_username, console_pools.password AS console_pools_password, console_pools.console_type AS console_pools_console_type, console_pools.public_hostname AS console_pools_public_hostname, console_pools.host AS console_pools_host, console_pools.compute_host AS console_pools_compute_host \nFROM console_pools \nWHERE console_pools.host = ? AND console_pools.console_type = ? AND console_pools.compute_host = ? AND console_pools.deleted = ? \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN consoles AS consoles_1 ON anon_1.console_pools_id = consoles_1.pool_id' ('hudson', 'fake', 'test_compute_host', False) ====================================================================== ERROR: test_get_pool_does_not_create_new_pool_if_exists (nova.tests.test_console.ConsoleTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_console.py", line 98, in test_get_pool_does_not_create_new_pool_if_exists new_pool = db.console_pool_create(self.context, pool_info) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 921, in console_pool_create return IMPL.console_pool_create(context, values) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 1885, in console_pool_create pool.save() File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/models.py", line 57, in save session.flush() File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 1346, in flush self._flush(objects) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 1427, in _flush flush_context.execute() File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/unitofwork.py", line 299, in execute rec.execute(self) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/unitofwork.py", line 443, in execute uow File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/mapper.py", line 1833, in _save_obj execute(statement, params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such table: console_pools u'INSERT INTO console_pools (created_at, updated_at, deleted_at, deleted, address, username, password, console_type, public_hostname, host, compute_host) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' ('2011-01-13 09:17:39.116551', None, None, False, '127.0.0.1', 'test', '1234pass', 'fake', None, 'hudson', 'sometesthostname') ====================================================================== ERROR: test_get_pool_for_instance_host (nova.tests.test_console.ConsoleTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_console.py", line 73, in test_get_pool_for_instance_host pool = self.console.get_pool_for_instance_host(self.context, self.host) File "/tmp/tmpJwQOJ4/nova/console/manager.py", line 104, in get_pool_for_instance_host console_type) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 935, in console_pool_get_by_host_type console_type) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 1910, in console_pool_get_by_host_type options(joinedload('consoles')).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such table: consoles u'SELECT anon_1.console_pools_created_at AS anon_1_console_pools_created_at, anon_1.console_pools_updated_at AS anon_1_console_pools_updated_at, anon_1.console_pools_deleted_at AS anon_1_console_pools_deleted_at, anon_1.console_pools_deleted AS anon_1_console_pools_deleted, anon_1.console_pools_id AS anon_1_console_pools_id, anon_1.console_pools_address AS anon_1_console_pools_address, anon_1.console_pools_username AS anon_1_console_pools_username, anon_1.console_pools_password AS anon_1_console_pools_password, anon_1.console_pools_console_type AS anon_1_console_pools_console_type, anon_1.console_pools_public_hostname AS anon_1_console_pools_public_hostname, anon_1.console_pools_host AS anon_1_console_pools_host, anon_1.console_pools_compute_host AS anon_1_console_pools_compute_host, consoles_1.created_at AS consoles_1_created_at, consoles_1.updated_at AS consoles_1_updated_at, consoles_1.deleted_at AS consoles_1_deleted_at, consoles_1.deleted AS consoles_1_deleted, consoles_1.id AS consoles_1_id, consoles_1.instance_name AS consoles_1_instance_name, consoles_1.instance_id AS consoles_1_instance_id, consoles_1.password AS consoles_1_password, consoles_1.port AS consoles_1_port, consoles_1.pool_id AS consoles_1_pool_id \nFROM (SELECT console_pools.created_at AS console_pools_created_at, console_pools.updated_at AS console_pools_updated_at, console_pools.deleted_at AS console_pools_deleted_at, console_pools.deleted AS console_pools_deleted, console_pools.id AS console_pools_id, console_pools.address AS console_pools_address, console_pools.username AS console_pools_username, console_pools.password AS console_pools_password, console_pools.console_type AS console_pools_console_type, console_pools.public_hostname AS console_pools_public_hostname, console_pools.host AS console_pools_host, console_pools.compute_host AS console_pools_compute_host \nFROM console_pools \nWHERE console_pools.host = ? AND console_pools.console_type = ? AND console_pools.compute_host = ? AND console_pools.deleted = ? \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN consoles AS consoles_1 ON anon_1.console_pools_id = consoles_1.pool_id' ('hudson', 'fake', 'test_compute_host', False) ====================================================================== ERROR: test_remove_console (nova.tests.test_console.ConsoleTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_console.py", line 123, in test_remove_console console_id = self.console.add_console(self.context, instance_id) File "/tmp/tmpJwQOJ4/nova/exception.py", line 88, in _wrap raise Error(str(e)) Error: (OperationalError) no such table: consoles u'SELECT anon_1.console_pools_created_at AS anon_1_console_pools_created_at, anon_1.console_pools_updated_at AS anon_1_console_pools_updated_at, anon_1.console_pools_deleted_at AS anon_1_console_pools_deleted_at, anon_1.console_pools_deleted AS anon_1_console_pools_deleted, anon_1.console_pools_id AS anon_1_console_pools_id, anon_1.console_pools_address AS anon_1_console_pools_address, anon_1.console_pools_username AS anon_1_console_pools_username, anon_1.console_pools_password AS anon_1_console_pools_password, anon_1.console_pools_console_type AS anon_1_console_pools_console_type, anon_1.console_pools_public_hostname AS anon_1_console_pools_public_hostname, anon_1.console_pools_host AS anon_1_console_pools_host, anon_1.console_pools_compute_host AS anon_1_console_pools_compute_host, consoles_1.created_at AS consoles_1_created_at, consoles_1.updated_at AS consoles_1_updated_at, consoles_1.deleted_at AS consoles_1_deleted_at, consoles_1.deleted AS consoles_1_deleted, consoles_1.id AS consoles_1_id, consoles_1.instance_name AS consoles_1_instance_name, consoles_1.instance_id AS consoles_1_instance_id, consoles_1.password AS consoles_1_password, consoles_1.port AS consoles_1_port, consoles_1.pool_id AS consoles_1_pool_id \nFROM (SELECT console_pools.created_at AS console_pools_created_at, console_pools.updated_at AS console_pools_updated_at, console_pools.deleted_at AS console_pools_deleted_at, console_pools.deleted AS console_pools_deleted, console_pools.id AS console_pools_id, console_pools.address AS console_pools_address, console_pools.username AS console_pools_username, console_pools.password AS console_pools_password, console_pools.console_type AS console_pools_console_type, console_pools.public_hostname AS console_pools_public_hostname, console_pools.host AS console_pools_host, console_pools.compute_host AS console_pools_compute_host \nFROM console_pools \nWHERE console_pools.host = ? AND console_pools.console_type = ? AND console_pools.compute_host IS NULL AND console_pools.deleted = ? \n LIMIT 1 OFFSET 0) AS anon_1 LEFT OUTER JOIN consoles AS consoles_1 ON anon_1.console_pools_id = consoles_1.pool_id' ('hudson', 'fake', False) ====================================================================== ERROR: test_doesnt_report_disabled_hosts_as_up (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 185, in test_doesnt_report_disabled_hosts_as_up compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_least_busy_host_gets_instance (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 225, in test_least_busy_host_gets_instance compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_least_busy_host_gets_volume (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 338, in test_least_busy_host_gets_volume volume1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-volume', False) ====================================================================== ERROR: test_reports_enabled_hosts_as_up (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 208, in test_reports_enabled_hosts_as_up compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_specific_host_gets_instance (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 248, in test_specific_host_gets_instance compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_too_many_cores (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 305, in test_too_many_cores compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_too_many_gigabytes (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 361, in test_too_many_gigabytes volume1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-volume', False) ====================================================================== ERROR: test_will_schedule_on_disabled_host_if_specified (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 289, in test_will_schedule_on_disabled_host_if_specified compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_wont_sechedule_if_specified_host_is_down (nova.tests.test_scheduler.SimpleDriverTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_scheduler.py", line 270, in test_wont_sechedule_if_specified_host_is_down compute1.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('host1', 'nova-compute', False) ====================================================================== ERROR: test_service_disabled_on_create_based_on_flag (nova.tests.test_service.ServiceFlagsTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_service.py", line 94, in test_service_disabled_on_create_based_on_flag app.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('foo', 'nova-fake', False) ====================================================================== ERROR: test_service_enabled_on_create_based_on_flag (nova.tests.test_service.ServiceFlagsTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_service.py", line 83, in test_service_enabled_on_create_based_on_flag app.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('foo', 'nova-fake', False) ====================================================================== ERROR: test_message_gets_to_manager (nova.tests.test_service.ServiceManagerTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_service.py", line 65, in test_message_gets_to_manager serv.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('test', 'test', False) ====================================================================== ERROR: test_override_manager_method (nova.tests.test_service.ServiceManagerTestCase) ---------------------------------------------------------------------- Traceback (most recent call last): File "/tmp/tmpJwQOJ4/nova/tests/test_service.py", line 73, in test_override_manager_method serv.start() File "/tmp/tmpJwQOJ4/nova/service.py", line 86, in start self.binary) File "/tmp/tmpJwQOJ4/nova/db/api.py", line 128, in service_get_by_args return IMPL.service_get_by_args(context, host, binary) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 96, in wrapper return f(*args, **kwargs) File "/tmp/tmpJwQOJ4/nova/db/sqlalchemy/api.py", line 247, in service_get_by_args filter_by(deleted=can_read_deleted(context)).\ File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1496, in first ret = list(self[0:1]) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1405, in __getitem__ return list(res) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1565, in __iter__ return self._execute_and_instances(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py", line 1570, in _execute_and_instances mapper=self._mapper_zero_or_none()) File "/usr/lib/python2.6/dist-packages/sqlalchemy/orm/session.py", line 735, in execute clause, params or {}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute params) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1237, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute context) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such column: services.availability_zone u'SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.binary AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.availability_zone AS services_availability_zone \nFROM services \nWHERE services.host = ? AND services.binary = ? AND services.deleted = ? \n LIMIT 1 OFFSET 0' ('test', 'test', False) ---------------------------------------------------------------------- Ran 275 tests in 74.408s FAILED (errors=36)