Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.api.drivers.driver_agent.driver_get [-] ############# Query start Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.04531s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT pool.created_at AS pool_created_at, pool.updated_at AS pool_updated_at, pool.id AS pool_id, pool.project_id AS pool_project_id, pool.name AS pool_name, pool.description AS pool_description, pool.protocol AS pool_protocol, pool.lb_algorithm AS pool_lb_algorithm, pool.provisioning_status AS pool_provisioning_status, pool.operating_status AS pool_operating_status, pool.enabled AS pool_enabled, pool.load_balancer_id AS pool_load_balancer_id, pool.tls_certificate_id AS pool_tls_certificate_id, pool.ca_tls_certificate_id AS pool_ca_tls_certificate_id, pool.crl_container_id AS pool_crl_container_id, pool.tls_enabled AS pool_tls_enabled, pool.tls_ciphers AS pool_tls_ciphers, pool.tls_versions AS pool_tls_versions, pool.alpn_protocols AS pool_alpn_protocols Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM pool Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE pool.id = %(id_1)s AND pool.provisioning_status != %(provisioning_status_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: LIMIT %(param_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00013s] {'id_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8', 'provisioning_status_1': 'DELETED', 'param_1': 1} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.05078s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT tags.resource_id AS tags_resource_id, tags.tag AS tags_tag, anon_1.pool_id AS anon_1_pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM (SELECT pool.id AS pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM pool Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE pool.id = %(id_1)s AND pool.provisioning_status != %(provisioning_status_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: LIMIT %(param_1)s) AS anon_1 INNER JOIN tags ON tags.resource_id = anon_1.pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00012s] {'id_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8', 'provisioning_status_1': 'DELETED', 'param_1': 1} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.db.repositories [-] ############# to_data_model start Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.05458s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT health_monitor.created_at AS health_monitor_created_at, health_monitor.updated_at AS health_monitor_updated_at, health_monitor.id AS health_monitor_id, health_monitor.project_id AS health_monitor_project_id, health_monitor.name AS health_monitor_name, health_monitor.type AS health_monitor_type, health_monitor.pool_id AS health_monitor_pool_id, health_monitor.delay AS health_monitor_delay, health_monitor.timeout AS health_monitor_timeout, health_monitor.fall_threshold AS health_monitor_fall_threshold, health_monitor.rise_threshold AS health_monitor_rise_threshold, health_monitor.http_method AS health_monitor_http_method, health_monitor.url_path AS health_monitor_url_path, health_monitor.expected_codes AS health_monitor_expected_codes, health_monitor.enabled AS health_monitor_enabled, health_monitor.provisioning_status AS health_monitor_provisioning_status, health_monitor.operating_status AS health_monitor_operating_status, health_monitor.http_version AS health_monitor_http_version, health_monitor.domain_name AS health_monitor_domain_name Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM health_monitor Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = health_monitor.pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.05803s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT tags.resource_id AS tags_resource_id, tags.tag AS tags_tag, anon_1.health_monitor_id AS anon_1_health_monitor_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM (SELECT health_monitor.id AS health_monitor_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM health_monitor Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = health_monitor.pool_id) AS anon_1 INNER JOIN tags ON tags.resource_id = anon_1.health_monitor_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00012s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.06043s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT l7policy.created_at AS l7policy_created_at, l7policy.updated_at AS l7policy_updated_at, l7policy.id AS l7policy_id, l7policy.project_id AS l7policy_project_id, l7policy.name AS l7policy_name, l7policy.description AS l7policy_description, l7policy.listener_id AS l7policy_listener_id, l7policy.action AS l7policy_action, l7policy.redirect_pool_id AS l7policy_redirect_pool_id, l7policy.redirect_url AS l7policy_redirect_url, l7policy.redirect_prefix AS l7policy_redirect_prefix, l7policy.redirect_http_code AS l7policy_redirect_http_code, l7policy.position AS l7policy_position, l7policy.enabled AS l7policy_enabled, l7policy.provisioning_status AS l7policy_provisioning_status, l7policy.operating_status AS l7policy_operating_status Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM l7policy Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = l7policy.redirect_pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.06371s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT listener.created_at AS listener_created_at, listener.updated_at AS listener_updated_at, listener.id AS listener_id, listener.project_id AS listener_project_id, listener.name AS listener_name, listener.description AS listener_description, listener.protocol AS listener_protocol, listener.protocol_port AS listener_protocol_port, listener.connection_limit AS listener_connection_limit, listener.load_balancer_id AS listener_load_balancer_id, listener.tls_certificate_id AS listener_tls_certificate_id, listener.default_pool_id AS listener_default_pool_id, listener.provisioning_status AS listener_provisioning_status, listener.operating_status AS listener_operating_status, listener.enabled AS listener_enabled, listener.peer_port AS listener_peer_port, listener.insert_headers AS listener_insert_headers, listener.timeout_client_data AS listener_timeout_client_data, listener.timeout_member_connect AS listener_timeout_member_connect, listener.timeout_member_data AS listener_timeout_member_data, listener.timeout_tcp_inspect AS listener_timeout_tcp_inspect, listener.client_ca_tls_certificate_id AS listener_client_ca_tls_certificate_id, listener.client_authentication AS listener_client_authentication, listener.client_crl_container_id AS listener_client_crl_container_id, listener.tls_ciphers AS listener_tls_ciphers, listener.tls_versions AS listener_tls_versions, listener.alpn_protocols AS listener_alpn_protocols Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM listener Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = listener.default_pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.0675s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT tags.resource_id AS tags_resource_id, tags.tag AS tags_tag, anon_1.listener_id AS anon_1_listener_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM (SELECT listener.id AS listener_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM listener Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = listener.default_pool_id) AS anon_1 INNER JOIN tags ON tags.resource_id = anon_1.listener_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.06984s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT listener_cidr.listener_id AS listener_cidr_listener_id, listener_cidr.cidr AS listener_cidr_cidr Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM listener_cidr Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = listener_cidr.listener_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00010s] {'param_1': '7343344e-59a4-40a0-90d3-0a43a080525b'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.07167s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT l7policy.created_at AS l7policy_created_at, l7policy.updated_at AS l7policy_updated_at, l7policy.id AS l7policy_id, l7policy.project_id AS l7policy_project_id, l7policy.name AS l7policy_name, l7policy.description AS l7policy_description, l7policy.listener_id AS l7policy_listener_id, l7policy.action AS l7policy_action, l7policy.redirect_pool_id AS l7policy_redirect_pool_id, l7policy.redirect_url AS l7policy_redirect_url, l7policy.redirect_prefix AS l7policy_redirect_prefix, l7policy.redirect_http_code AS l7policy_redirect_http_code, l7policy.position AS l7policy_position, l7policy.enabled AS l7policy_enabled, l7policy.provisioning_status AS l7policy_provisioning_status, l7policy.operating_status AS l7policy_operating_status Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM l7policy Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = l7policy.listener_id ORDER BY l7policy.position Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00013s] {'param_1': '7343344e-59a4-40a0-90d3-0a43a080525b'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.07418s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT load_balancer.created_at AS load_balancer_created_at, load_balancer.updated_at AS load_balancer_updated_at, load_balancer.id AS load_balancer_id, load_balancer.project_id AS load_balancer_project_id, load_balancer.name AS load_balancer_name, load_balancer.description AS load_balancer_description, load_balancer.provisioning_status AS load_balancer_provisioning_status, load_balancer.operating_status AS load_balancer_operating_status, load_balancer.topology AS load_balancer_topology, load_balancer.enabled AS load_balancer_enabled, load_balancer.server_group_id AS load_balancer_server_group_id, load_balancer.provider AS load_balancer_provider, load_balancer.flavor_id AS load_balancer_flavor_id, load_balancer.availability_zone AS load_balancer_availability_zone Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM load_balancer Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE load_balancer.id = %(pk_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'pk_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.07711s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT tags.resource_id AS tags_resource_id, tags.tag AS tags_tag, anon_1.load_balancer_id AS anon_1_load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM (SELECT load_balancer.id AS load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM load_balancer Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE load_balancer.id = %(pk_1)s) AS anon_1 INNER JOIN tags ON tags.resource_id = anon_1.load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'pk_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.07939s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT additional_vip.load_balancer_id AS additional_vip_load_balancer_id, additional_vip.ip_address AS additional_vip_ip_address, additional_vip.port_id AS additional_vip_port_id, additional_vip.subnet_id AS additional_vip_subnet_id, additional_vip.network_id AS additional_vip_network_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM additional_vip Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = additional_vip.load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.08141s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT amphora.created_at AS amphora_created_at, amphora.updated_at AS amphora_updated_at, amphora.id AS amphora_id, amphora.load_balancer_id AS amphora_load_balancer_id, amphora.compute_id AS amphora_compute_id, amphora.lb_network_ip AS amphora_lb_network_ip, amphora.vrrp_ip AS amphora_vrrp_ip, amphora.ha_ip AS amphora_ha_ip, amphora.vrrp_port_id AS amphora_vrrp_port_id, amphora.ha_port_id AS amphora_ha_port_id, amphora.cert_expiration AS amphora_cert_expiration, amphora.cert_busy AS amphora_cert_busy, amphora.`role` AS amphora_role, amphora.status AS amphora_status, amphora.vrrp_interface AS amphora_vrrp_interface, amphora.vrrp_id AS amphora_vrrp_id, amphora.vrrp_priority AS amphora_vrrp_priority, amphora.cached_zone AS amphora_cached_zone, amphora.image_id AS amphora_image_id, amphora.compute_flavor AS amphora_compute_flavor Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM amphora Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = amphora.load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.08453s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT listener.created_at AS listener_created_at, listener.updated_at AS listener_updated_at, listener.id AS listener_id, listener.project_id AS listener_project_id, listener.name AS listener_name, listener.description AS listener_description, listener.protocol AS listener_protocol, listener.protocol_port AS listener_protocol_port, listener.connection_limit AS listener_connection_limit, listener.load_balancer_id AS listener_load_balancer_id, listener.tls_certificate_id AS listener_tls_certificate_id, listener.default_pool_id AS listener_default_pool_id, listener.provisioning_status AS listener_provisioning_status, listener.operating_status AS listener_operating_status, listener.enabled AS listener_enabled, listener.peer_port AS listener_peer_port, listener.insert_headers AS listener_insert_headers, listener.timeout_client_data AS listener_timeout_client_data, listener.timeout_member_connect AS listener_timeout_member_connect, listener.timeout_member_data AS listener_timeout_member_data, listener.timeout_tcp_inspect AS listener_timeout_tcp_inspect, listener.client_ca_tls_certificate_id AS listener_client_ca_tls_certificate_id, listener.client_authentication AS listener_client_authentication, listener.client_crl_container_id AS listener_client_crl_container_id, listener.tls_ciphers AS listener_tls_ciphers, listener.tls_versions AS listener_tls_versions, listener.alpn_protocols AS listener_alpn_protocols Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM listener Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = listener.load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00012s] {'param_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.08813s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT pool.created_at AS pool_created_at, pool.updated_at AS pool_updated_at, pool.id AS pool_id, pool.project_id AS pool_project_id, pool.name AS pool_name, pool.description AS pool_description, pool.protocol AS pool_protocol, pool.lb_algorithm AS pool_lb_algorithm, pool.provisioning_status AS pool_provisioning_status, pool.operating_status AS pool_operating_status, pool.enabled AS pool_enabled, pool.load_balancer_id AS pool_load_balancer_id, pool.tls_certificate_id AS pool_tls_certificate_id, pool.ca_tls_certificate_id AS pool_ca_tls_certificate_id, pool.crl_container_id AS pool_crl_container_id, pool.tls_enabled AS pool_tls_enabled, pool.tls_ciphers AS pool_tls_ciphers, pool.tls_versions AS pool_tls_versions, pool.alpn_protocols AS pool_alpn_protocols Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM pool Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = pool.load_balancer_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00012s] {'param_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.09068s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT vip.load_balancer_id AS vip_load_balancer_id, vip.ip_address AS vip_ip_address, vip.port_id AS vip_port_id, vip.subnet_id AS vip_subnet_id, vip.network_id AS vip_network_id, vip.qos_policy_id AS vip_qos_policy_id, vip.octavia_owned AS vip_octavia_owned Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM vip Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE vip.load_balancer_id = %(pk_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'pk_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.09296s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT vrrp_group.load_balancer_id AS vrrp_group_load_balancer_id, vrrp_group.vrrp_group_name AS vrrp_group_vrrp_group_name, vrrp_group.vrrp_auth_type AS vrrp_group_vrrp_auth_type, vrrp_group.vrrp_auth_pass AS vrrp_group_vrrp_auth_pass, vrrp_group.advert_int AS vrrp_group_advert_int Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM vrrp_group Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE vrrp_group.load_balancer_id = %(pk_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'pk_1': 'bff1e960-f9a8-4554-8b20-8baa3bdd6b0e'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.0951s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT sni.listener_id AS sni_listener_id, sni.tls_container_id AS sni_tls_container_id, sni.position AS sni_position Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM sni Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = sni.listener_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': '7343344e-59a4-40a0-90d3-0a43a080525b'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.09705s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT `member`.created_at AS member_created_at, `member`.updated_at AS member_updated_at, `member`.id AS member_id, `member`.project_id AS member_project_id, `member`.name AS member_name, `member`.pool_id AS member_pool_id, `member`.subnet_id AS member_subnet_id, `member`.ip_address AS member_ip_address, `member`.protocol_port AS member_protocol_port, `member`.weight AS member_weight, `member`.backup AS member_backup, `member`.monitor_address AS member_monitor_address, `member`.monitor_port AS member_monitor_port, `member`.provisioning_status AS member_provisioning_status, `member`.operating_status AS member_operating_status, `member`.enabled AS member_enabled Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM `member` Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = `member`.pool_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00012s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.09989s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT tags.resource_id AS tags_resource_id, tags.tag AS tags_tag, anon_1.member_id AS anon_1_member_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM (SELECT `member`.id AS member_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM `member` Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE %(param_1)s = `member`.pool_id) AS anon_1 INNER JOIN tags ON tags.resource_id = anon_1.member_id Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'param_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT 1 Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [cached since 0.1022s ago] {} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] SELECT session_persistence.pool_id AS session_persistence_pool_id, session_persistence.type AS session_persistence_type, session_persistence.cookie_name AS session_persistence_cookie_name, session_persistence.persistence_timeout AS session_persistence_persistence_timeout, session_persistence.persistence_granularity AS session_persistence_persistence_granularity Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: FROM session_persistence Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: WHERE session_persistence.pool_id = %(pk_1)s Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: INFO sqlalchemy.engine.Engine [-] [generated in 0.00011s] {'pk_1': '7373e852-7d8b-4a94-98c7-bca648e5c8d8'} Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.db.repositories [-] ############# to_data_model end Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.api.drivers.driver_agent.driver_get [-] ############# Query end Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.api.drivers.driver_agent.driver_get [-] ############# to provider start Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.api.drivers.driver_agent.driver_get [-] ############# to provider end Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.api.drivers.driver_agent.driver_get [-] ############# to dict start Aug 21 20:40:42 octaviajam octavia-driver-agent[156463]: ERROR octavia.api.drivers.driver_agent.driver_get [-] ############# to dict end