We have several subnets, around 3600, but the IPs that return in this query are not part of our network, below are some examples:
1662422 | maas | maasv2 | active | SELECT “maasserver_node”.“id”, “maasserver_node”.“created”, “maasserver_node”.“updated”, “maasserver_node”.“system_id”, “maasserver_node”.“hardware_uuid”, “maa
sserver_node”.“hostname”, “maasserver_node”.“description”, “maasserver_node”.“pool_id”, “maasserver_node”.“domain_id”, “maasserver_node”.“address_ttl”, “maasserver_node”.“status”, “maasserver_node”.“pre
vious_status”, “maasserver_node”.“status_expires”, “maasserver_node”.“owner_id”, “maasserver_node”.“bios_boot_method”, “maasserver_node”.“osystem”, “maasserver_node”.“distro_series”, “maasserver_node”."
architecture", “maasserver_node”.“min_hwe_kernel”, “maasserver_node”.“hwe_kernel”, “maasserver_node”.“node_type”, “maasserver_node”.“parent_id”, “maasserver_node”.“agent_name”, “maasserver_node”.“error_
description”, “maasserver_node”.“zone_id”, “maasserver_node”.“cpu_count”, “maasserver_node”.“cpu_speed”, “maasserver_node”.“memory”, “maasserver_node”.“swap_size”, “maasserver_node”.“bmc_id”, “maasserve
r_node”.“instance_power_parameters”, “maasserver_node”.“power_state”, “maasserver_node”.“power_state_queried”, “maasserver_node”.“power_state_updated”, “maasserver_node”.“last_image_sync”, “maasserver_node”.“error”, “maasserver_node”.“netboot”, “maasserver_node”.“ephemeral_deploy”, “maasserver_node”.“license_key”, “maasserver_node”.“dynamic”, “maasserver_node”.“boot_interface_id”, “maasserver_node”.“boot_cluster_ip”, “maasserver_node”.“boot_disk_id”, “maasserver_node”.“gateway_link_ipv4_id”, “maasserver_node”.“gateway_link_ipv6_id”, “maasserver_node”.“default_user”, “maasserver_node”.“install_rackd”, “maasserver_node”.“install_kvm”, “maasserver_node”.“register_vmhost”, “maasserver_node”.“enable_ssh”, “maasserver_node”.“skip_networking”, “maasserver_node”.“skip_storage”, “maasserver_node”.“url”, “maasserver_node”.“dns_process_id”, “maasserver_node”.“managing_process_id”, “maasserver_node”.“current_commissioning_script_set_id”, “maasserver_node”.“current_installation_script_set_id”, “maasserver_node”.“current_testing_script_set_id”, “maasserver_node”.“locked”, “maasserver_node”.“last_applied_storage_layout”, “maasserver_node”.“current_config_id”, “maasserver_node”.“enable_hw_sync”, “maasserver_node”.“sync_interval”, “maasserver_node”.“last_sync” FROM “maasserver_node” INNER JOIN “maasserver_nodeconfig” ON (“maasserver_node”.“current_config_id” = “maasserver_nodeconfig”.“id”) INNER JOIN “maasserver_interface” ON (“maasserver_nodeconfig”.“id” = “maasserver_interface”.“node_config_id”) INNER JOIN “maasserver_interface_ip_addresses” ON (“maasserver_interface”.“id” = “maasserver_interface_ip_addresses”.“interface_id”) INNER JOIN “maasserver_staticipaddress” ON (“maasserver_interface_ip_addresses”.“staticipaddress_id” = “maasserver_staticipaddress”.“id”) WHERE “maasserver_staticipaddress”.“ip” = ‘45.195.251.243’::inet ORDER BY “maasserver_node”.“id” ASC LIMIT 1 | 2024-06-26 13:43:46.507046+00 | 2024-06-26 13:43:46.507048+00
1658140 | maas | maasv2 | active | SELECT “maasserver_node”.“id”, “maasserver_node”.“created”, “maasserver_node”.“updated”, “maasserver_node”.“system_id”, “maasserver_node”.“hardware_uuid”, “maasserver_node”.“hostname”, “maasserver_node”.“description”, “maasserver_node”.“pool_id”, “maasserver_node”.“domain_id”, “maasserver_node”.“address_ttl”, “maasserver_node”.“status”, “maasserver_node”.“previous_status”, “maasserver_node”.“status_expires”, “maasserver_node”.“owner_id”, “maasserver_node”.“bios_boot_method”, “maasserver_node”.“osystem”, “maasserver_node”.“distro_series”, “maasserver_node”.“architecture”, “maasserver_node”.“min_hwe_kernel”, “maasserver_node”.“hwe_kernel”, “maasserver_node”.“node_type”, “maasserver_node”.“parent_id”, “maasserver_node”.“agent_name”, “maasserver_node”.“error_description”, “maasserver_node”.“zone_id”, “maasserver_node”.“cpu_count”, “maasserver_node”.“cpu_speed”, “maasserver_node”.“memory”, “maasserver_node”.“swap_size”, “maasserver_node”.“bmc_id”, “maasserver_node”.“instance_power_parameters”, “maasserver_node”.“power_state”, “maasserver_node”.“power_state_queried”, “maasserver_node”.“power_state_updated”, “maasserver_node”.“last_image_sync”, “maasserver_node”.“error”, “maasserver_node”.“netboot”, “maasserver_node”.“ephemeral_deploy”, “maasserver_node”.“license_key”, “maasserver_node”.“dynamic”, “maasserver_node”.“boot_interface_id”, “maasserver_node”.“boot_cluster_ip”, “maasserver_node”.“boot_disk_id”, “maasserver_node”.“gateway_link_ipv4_id”, “maasserver_node”.“gateway_link_ipv6_id”, “maasserver_node”.“default_user”, “maasserver_node”.“install_rackd”, “maasserver_node”.“install_kvm”, “maasserver_node”.“register_vmhost”, “maasserver_node”.“enable_ssh”, “maasserver_node”.“skip_networking”, “maasserver_node”.“skip_storage”, “maasserver_node”.“url”, “maasserver_node”.“dns_process_id”, “maasserver_node”.“managing_process_id”, “maasserver_node”.“current_commissioning_script_set_id”, “maasserver_node”.“current_installation_script_set_id”, “maasserver_node”.“current_testing_script_set_id”, “maasserver_node”.“locked”, “maasserver_node”.“last_applied_storage_layout”, “maasserver_node”.“current_config_id”, “maasserver_node”.“enable_hw_sync”, “maasserver_node”.“sync_interval”, “maasserver_node”.“last_sync” FROM “maasserver_node” INNER JOIN “maasserver_nodeconfig” ON (“maasserver_node”.“current_config_id” = “maasserver_nodeconfig”.“id”) INNER JOIN “maasserver_interface” ON (“maasserver_nodeconfig”.“id” = “maasserver_interface”.“node_config_id”) INNER JOIN “maasserver_interface_ip_addresses” ON (“maasserver_interface”.“id” = “maasserver_interface_ip_addresses”.“interface_id”) INNER JOIN “maasserver_staticipaddress” ON (“maasserver_interface_ip_addresses”.“staticipaddress_id” = “maasserver_staticipaddress”.“id”) WHERE “maasserver_staticipaddress”.“ip” = ‘43.249.28.206’::inet ORDER BY “maasserver_node”.“id” ASC LIMIT 1 | 2024-06-26 13:43:46.511954+00 | 2024-06-26 13:43:46.511956+00
1659445 | maas | maasv2 | active | SELECT “maasserver_node”.“id”, “maasserver_node”.“created”, “maasserver_node”.“updated”, “maasserver_node”.“system_id”, “maasserver_node”.“hardware_uuid”, “maasserver_node”.“hostname”, “maasserver_node”.“description”, “maasserver_node”.“pool_id”, “maasserver_node”.“domain_id”, “maasserver_node”.“address_ttl”, “maasserver_node”.“status”, “maasserver_node”.“previous_status”, “maasserver_node”.“status_expires”, “maasserver_node”.“owner_id”, “maasserver_node”.“bios_boot_method”, “maasserver_node”.“osystem”, “maasserver_node”.“distro_series”, “maasserver_node”.“architecture”, “maasserver_node”.“min_hwe_kernel”, “maasserver_node”.“hwe_kernel”, “maasserver_node”.“node_type”, “maasserver_node”.“parent_id”, “maasserver_node”.“agent_name”, “maasserver_node”.“error_description”, “maasserver_node”.“zone_id”, “maasserver_node”.“cpu_count”, “maasserver_node”.“cpu_speed”, “maasserver_node”.“memory”, “maasserver_node”.“swap_size”, “maasserver_node”.“bmc_id”, “maasserver_node”.“instance_power_parameters”, “maasserver_node”.“power_state”, “maasserver_node”.“power_state_queried”, “maasserver_node”.“power_state_updated”, “maasserver_node”.“last_image_sync”, “maasserver_node”.“error”, “maasserver_node”.“netboot”, “maasserver_node”.“ephemeral_deploy”, “maasserver_node”.“license_key”, “maasserver_node”.“dynamic”, “maasserver_node”.“boot_interface_id”, “maasserver_node”.“boot_cluster_ip”, “maasserver_node”.“boot_disk_id”, “maasserver_node”.“gateway_link_ipv4_id”, “maasserver_node”.“gateway_link_ipv6_id”, “maasserver_node”.“default_user”, “maasserver_node”.“install_rackd”, “maasserver_node”.“install_kvm”, “maasserver_node”.“register_vmhost”, “maasserver_node”.“enable_ssh”, “maasserver_node”.“skip_networking”, “maasserver_node”.“skip_storage”, “maasserver_node”.“url”, “maasserver_node”.“dns_process_id”, “maasserver_node”.“managing_process_id”, “maasserver_node”.“current_commissioning_script_set_id”, “maasserver_node”.“current_installation_script_set_id”, “maasserver_node”.“current_testing_script_set_id”, “maasserver_node”.“locked”, “maasserver_node”.“last_applied_storage_layout”, “maasserver_node”.“current_config_id”, “maasserver_node”.“enable_hw_sync”, “maasserver_node”.“sync_interval”, “maasserver_node”.“last_sync” FROM “maasserver_node” INNER JOIN “maasserver_nodeconfig” ON (“maasserver_node”.“current_config_id” = “maasserver_nodeconfig”.“id”) INNER JOIN “maasserver_interface” ON (“maasserver_nodeconfig”.“id” = “maasserver_interface”.“node_config_id”) INNER JOIN “maasserver_interface_ip_addresses” ON (“maasserver_interface”.“id” = “maasserver_interface_ip_addresses”.“interface_id”) INNER JOIN “maasserver_staticipaddress” ON (“maasserver_interface_ip_addresses”.“staticipaddress_id” = “maasserver_staticipaddress”.“id”) WHERE “maasserver_staticipaddress”.“ip” = ‘43.249.30.29’::inet ORDER BY “maasserver_node”.“id” ASC LIMIT 1 | 2024-06-26 13:43:46.512768+00 | 2024-06-26 13:43:46.51277+00
1482867 | maas | maasv2 | active | SELECT “maasserver_node”.“id”, “maasserver_node”.“created”, “maasserver_node”.“updated”, “maasserver_node”.“system_id”, “maasserver_node”.“hardware_uuid”, “maasserver_node”.“hostname”, “maasserver_node”.“description”, “maasserver_node”.“pool_id”, “maasserver_node”.“domain_id”, “maasserver_node”.“address_ttl”, “maasserver_node”.“status”, “maasserver_node”.“previous_status”, “maasserver_node”.“status_expires”, “maasserver_node”.“owner_id”, “maasserver_node”.“bios_boot_method”, “maasserver_node”.“osystem”, “maasserver_node”.“distro_series”, “maasserver_node”.“architecture”, “maasserver_node”.“min_hwe_kernel”, “maasserver_node”.“hwe_kernel”, “maasserver_node”.“node_type”, “maasserver_node”.“parent_id”, “maasserver_node”.“agent_name”, “maasserver_node”.“error_description”, “maasserver_node”.“zone_id”, “maasserver_node”.“cpu_count”, “maasserver_node”.“cpu_speed”, “maasserver_node”.“memory”, “maasserver_node”.“swap_size”, “maasserver_node”.“bmc_id”, “maasserver_node”.“instance_power_parameters”, “maasserver_node”.“power_state”, “maasserver_node”.“power_state_queried”, “maasserver_node”.“power_state_updated”, “maasserver_node”.“last_image_sync”, “maasserver_node”.“error”, “maasserver_node”.“netboot”, “maasserver_node”.“ephemeral_deploy”, “maasserver_node”.“license_key”, “maasserver_node”.“dynamic”, “maasserver_node”.“boot_interface_id”, “maasserver_node”.“boot_cluster_ip”, “maasserver_node”.“boot_disk_id”, “maasserver_node”.“gateway_link_ipv4_id”, “maasserver_node”.“gateway_link_ipv6_id”, “maasserver_node”.“default_user”, “maasserver_node”.“install_rackd”, “maasserver_node”.“install_kvm”, “maasserver_node”.“register_vmhost”, “maasserver_node”.“enable_ssh”, “maasserver_node”.“skip_networking”, “maasserver_node”.“skip_storage”, “maasserver_node”.“url”, “maasserver_node”.“dns_process_id”, “maasserver_node”.“managing_process_id”, “maasserver_node”.“current_commissioning_script_set_id”, “maasserver_node”.“current_installation_script_set_id”, “maasserver_node”.“current_testing_script_set_id”, “maasserver_node”.“locked”, “maasserver_node”.“last_applied_storage_layout”, “maasserver_node”.“current_config_id”, “maasserver_node”.“enable_hw_sync”, “maasserver_node”.“sync_interval”, “maasserver_node”.“last_sync” FROM “maasserver_node” INNER JOIN “maasserver_nodeconfig” ON (“maasserver_node”.“current_config_id” = “maasserver_nodeconfig”.“id”) INNER JOIN “maasserver_interface” ON (“maasserver_nodeconfig”.“id” = “maasserver_interface”.“node_config_id”) INNER JOIN “maasserver_interface_ip_addresses” ON (“maasserver_interface”.“id” = “maasserver_interface_ip_addresses”.“interface_id”) INNER JOIN “maasserver_staticipaddress” ON (“maasserver_interface_ip_addresses”.“staticipaddress_id” = “maasserver_staticipaddress”.“id”) WHERE “maasserver_staticipaddress”.“ip” = ‘45.112.205.102’::inet ORDER BY “maasserver_node”.“id” ASC LIMIT 1 | 2024-06-26 12:17:00.484634+00 | 2024-06-26 12:17:00.484636+00
1484792 | maas | maasv2 | active | SELECT “maasserver_node”.“id”, “maasserver_node”.“created”, “maasserver_node”.“updated”, “maasserver_node”.“system_id”, “maasserver_node”.“hardware_uuid”, “maa
sserver_node”.“hostname”, “maasserver_node”.“description”, “maasserver_node”.“pool_id”, “maasserver_node”.“domain_id”, “maasserver_node”.“address_ttl”, “maasserver_node”.“status”, “maasserver_node”.“pre
vious_status”, “maasserver_node”.“status_expires”, “maasserver_node”.“owner_id”, “maasserver_node”.“bios_boot_method”, “maasserver_node”.“osystem”, “maasserver_node”.“distro_series”, “maasserver_node”."
architecture", “maasserver_node”.“min_hwe_kernel”, “maasserver_node”.“hwe_kernel”, “maasserver_node”.“node_type”, “maasserver_node”.“parent_id”, “maasserver_node”.“agent_name”, “maasserver_node”.“error_
description”, “maasserver_node”.“zone_id”, “maasserver_node”.“cpu_count”, “maasserver_node”.“cpu_speed”, “maasserver_node”.“memory”, “maasserver_node”.“swap_size”, “maasserver_node”.“bmc_id”, “maasserve
r_node”.“instance_power_parameters”, “maasserver_node”.“power_state”, “maasserver_node”.“power_state_queried”, “maasserver_node”.“power_state_updated”, “maasserver_node”.“last_image_sync”, “maasserver_n
ode”.“error”, “maasserver_node”.“netboot”, “maasserver_node”.“ephemeral_deploy”, “maasserver_node”.“license_key”, “maasserver_node”.“dynamic”, “maasserver_node”.“boot_interface_id”, “maasserver_node”.“b
oot_cluster_ip”, “maasserver_node”.“boot_disk_id”, “maasserver_node”.“gateway_link_ipv4_id”, “maasserver_node”.“gateway_link_ipv6_id”, “maasserver_node”.“default_user”, “maasserver_node”.“install_rackd”
, “maasserver_node”.“install_kvm”, “maasserver_node”.“register_vmhost”, “maasserver_node”.“enable_ssh”, “maasserver_node”.“skip_networking”, “maasserver_node”.“skip_storage”, “maasserver_node”.“url”, “m
aasserver_node”.“dns_process_id”, “maasserver_node”.“managing_process_id”, “maasserver_node”.“current_commissioning_script_set_id”, “maasserver_node”.“current_installation_script_set_id”, “maasserver_no
de”.“current_testing_script_set_id”, “maasserver_node”.“locked”, “maasserver_node”.“last_applied_storage_layout”, “maasserver_node”.“current_config_id”, “maasserver_node”.“enable_hw_sync”, “maasserver_node”.“sync_interval”, “maasserver_node”.“last_sync” FROM “maasserver_node” INNER JOIN “maasserver_nodeconfig” ON (“maasserver_node”.“current_config_id” = “maasserver_nodeconfig”.“id”) INNER JOIN “maasserver_interface” ON (“maasserver_nodeconfig”.“id” = “maasserver_interface”.“node_config_id”) INNER JOIN “maasserver_interface_ip_addresses” ON (“maasserver_interface”.“id” = “maasserver_interface_ip_addresses”.“interface_id”) INNER JOIN “maasserver_staticipaddress” ON (“maasserver_interface_ip_addresses”.“staticipaddress_id” = “maasserver_staticipaddress”.“id”) WHERE “maasserver_staticipaddress”.“ip” = ‘45.195.251.12’::inet ORDER BY “maasserver_node”.“id” ASC LIMIT 1 | 2024-06-26 12:17:00.481874+00 | 2024-06-26 12:17:00.481875+00
So much so that if we run the queries manually in the database, they return empty.