How We Use MAAS to Manage 5k+ Machines in the world.

boxjan · 13 May 2025 08:58

Last year, I encountered several bugs in MAAS, and after discussions with r00ta, I’d like to share how we utilize MAAS in our environment.

We currently manage over 5,000 bare-metal servers distributed across more than 200 data centers worldwide. While managing 5,000 servers itself might not sound large-scale, their global distribution significantly increases operational complexity.

We initially adopted MAAS version 2.9 in 2019, upgraded to 3.1 in 2021, and are currently migrating to version 3.5. Due to our highly distributed infrastructure—where some data centers host as few as 10 servers, while others handle upwards of 500—we operate approximately six independent MAAS regions globally. For instance, Frankfurt manages servers across EMEA, Singapore oversees Asia-Pacific, and Phoenix handles the Americas. In certain geographical areas, we even maintain two distinct MAAS regions to separately manage different server clusters.

Each MAAS region uses a dedicated /16 private IP block (e.g., 10.0.0.0/16), with the first /24 subnet (10.0.0.0/24) specifically reserved for the control plane.

Every top-of-rack (TOR) switch, corresponding to a Rack controller, has its own exclusive /24 subnet (e.g., 10.0.1.0/24) dedicated for BMC access. Typically, these racks use IP addresses such as 10.0.1.1 or 10.0.1.2 to interface with their BMCs. Most servers utilize a “sharelink” setup, which introduces a management challenge since a server cannot directly manage its own BMC. To address this, we implemented High Availability (HA) Rack controllers. We provided a custom patch to solve this issue in MAAS 3.1; however, migrating to MAAS 3.5 reintroduced complexities due to the adoption of Temporal workflows. A definitive fix is still under active development.

In our environment almost every server possessed a public IP address, with the region API exposed directly to the Internet, allowing rack controllers (rackd) straightforward connectivity. However, in MAAS 3.5, we transitioned to OpenVPN combined with FRRouting (FRR) to handle network connectivity. BGP is utilized to advertise a /32 route for each server’s BMC IP, effectively resolving the “sharelink” management issue. Within our OpenVPN setup, maintaining consistent IP addresses for rack controllers connecting to regional controllers is crucial. We use the ifconfig-pool-persist setting to achieve IP stability. An important consideration here is that enabling both duplicate-cn and ifconfig-pool-persist simultaneously is problematic. Specifically, when duplicate-cn is enabled, network instability can result in changing VPN IP addresses for racks. Consequently, the region mistakenly continues to use the outdated IP, causing the DHCP service to stop functioning entirely until the region daemon (regiond) is manually restarted. That is I meet the problem here: MAAS DHCP Server Issue and Bug Report #2089222.

We deploy rackd, OpenVPN, and FRR within a single privileged LXC container, offering several operational benefits:

Provides MAAS with a “bare-metal-like” environment, greatly simplifying upgrades and migrations.
Enables direct manipulation of the host’s routing table and iptables rules.
Avoids noisy kernel logs typically associated with Snap packaging and AppArmor restrictions.

Additionally, while we maintain our own Chrony configurations for time synchronization, MAAS has a tendency to overwrite these settings. By containing MAAS components within LXC containers, we isolate these configuration changes, thus preserving host settings.

We maintain numerous custom patches tailored specifically to our operational needs. These include features such as Single Sign-On (SSO) integration, delete PXE boot commands before machine power on (as certain older BMC models may unexpectedly reset if they receive PXE boot and power-on commands within a short interval), and many other adjustments to ensure smooth operation.

Finally, MAAS alone isn’t sufficient for managing our extensive infrastructure. To enhance operational efficiency, we’ve developed additional tools that help identify the physical location of servers, and facilitate operations such as OS reinstalls or system reboots.

This is just a brief overview of how we use MAAS in our environment. If you have any questions or want to discuss further, please feel free to reach out.

r00ta · 13 May 2025 10:55

Thank you so much for sharing!

r00ta · 13 May 2025 11:16

we operate approximately six independent MAAS regions globally.

You mean you have 6 independent MAAS regions or 6 regions in HA mode?

If you can share, do you have some statistics about the number of concurrent deployments you have on the MAAS installation that is managing most of the servers?

boxjan · 13 May 2025 13:20

The answer is Yes.

Before we started the upgrade to MAAS 3.5, we maintained six independent MAAS regions to manage all of our production servers (excluding staging and testing environments). Now, as we migrate to version 3.5, we expect to eventually have between five and eight independent MAAS regions, depending on how we decide to segment them geographically and by business unit. For servers originally deployed with MAAS 3.1, we utilize the import feature to migrate them smoothly into the new environment.

Typically, we deploy around 30 machines simultaneously, though occasionally this number rises to about 70. Thanks to Squid caching, network traffic between regions and racks remains moderate—generally around 30-50 Mbps.

Additionally, since we rely on a cloud-hosted PostgreSQL service, and because MAAS always installs a local PostgreSQL instance when deploying regiond, we’ve repackaged MAAS from source to remove PostgreSQL as a dependency.

boxjan · 9 September 2025 03:27

We recently upgraded some region and rack controllers to MAAS 3.5, and started re-deploying machines with Ubuntu 22.04. During this process, we observed that when deploying around 40 nodes simultaneously, about 3–5 nodes would fail without a clear reason, or MAAS would unexpectedly create extra nodes for those machines. This suggests there may be a race condition when processing a high volume of requests.

Additionally, when attempting to delete a rack controller, convert it into a regular machine, and then reinstall it, the release operation fails. After reviewing the code, I noticed that in the MAAS models, the dynamic flag is set for rack controllers that were directly installed on nodes outside of MAAS. In such cases, MAAS attempts to call delete on the node during release. However, after deletion, MAAS still tries to add a node event for it, which fails and causes the transaction to roll back. As a result, the node record always remains in the database, which I believe is incorrect behavior.

As a temporary workaround, I directly modified the database entries to bypass this issue, I need re install them , and install rack on it.

boxjan · 9 September 2025 03:33

region controller log is show here stdout ZZZZZZ is my extra log for debug maas.

Sep 08 10:08:04 region-controller regiond[3740301]: stdout: [info] ZZZZZZ - get req self: <NodeQuerySet [<Node: qhw6kf (master-grouper)>, <Node: wsrpba (stunning-lizard)>, <Node: mmw3hx (enough-kit)>, <Node: g3c3dd (inspired-katydid)>, <Node: eh3ykc (ip-10-12-6-3)>, <Node: 8xxpw4 (ip-10-12-9-3)>, <Node: cx4qcg (composed-longhorn)>, <Node: 84np3f (ample-rabbit)>, <Node: 74sq7r (grand-sunbird)>, <Node: rs3m78 (dear-bird)>, <Node: g38hpw (funky-man)>, <Node: ynh3kh (polite-bluegill)>, <Node: fsy44h (set-mouse)>, <Node: 8br7cb (ip-10-12-11-2)>, <Node: dnhhg7 (capable-crawdad)>, <Node: cx6kpy (heroic-poodle)>, <Node: 6s8ncd (musical-egret)>, <Node: p83n77 (helping-tortoise)>, <Node: g78m7c (thankful-anemone)>, <Node: 4qspta (proven-mongrel)>, '...(remaining elements truncated)...']> args: () kwargs: {'system_id': 'matbts'}
Sep 08 10:08:04 region-controller regiond[3740301]: stdout: [info] ZZZZZZ - get res <NodeQuerySet []> [] 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"."current_release_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" WHERE "maasserver_node"."system_id" = matbts LIMIT 21
Sep 08 10:08:04 region-controller regiond[3740301]: maasserver.websockets.protocol: [critical] Error on request (39) machine.action: Node matching query does not exist.
Sep 08 10:08:04 region-controller regiond[3740301]:         Traceback (most recent call last):
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3.10/threading.py", line 953, in run
Sep 08 10:08:04 region-controller regiond[3740301]:             self._target(*self._args, **self._kwargs)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/provisioningserver/utils/twisted.py", line 821, in worker
Sep 08 10:08:04 region-controller regiond[3740301]:             return target()
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/twisted/_threads/_threadworker.py", line 47, in work
Sep 08 10:08:04 region-controller regiond[3740301]:             task()
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/twisted/_threads/_team.py", line 182, in doWork
Sep 08 10:08:04 region-controller regiond[3740301]:             task()
Sep 08 10:08:04 region-controller regiond[3740301]:         --- <exception caught here> ---
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/twisted/python/threadpool.py", line 244, in inContext
Sep 08 10:08:04 region-controller regiond[3740301]:             result = inContext.theWork()  # type: ignore[attr-defined]
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/twisted/python/threadpool.py", line 260, in <lambda>
Sep 08 10:08:04 region-controller regiond[3740301]:             inContext.theWork = lambda: context.call(  # type: ignore[attr-defined]
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/twisted/python/context.py", line 117, in callWithContext
Sep 08 10:08:04 region-controller regiond[3740301]:             return self.currentContext().callWithContext(ctx, func, *args, **kw)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/twisted/python/context.py", line 82, in callWithContext
Sep 08 10:08:04 region-controller regiond[3740301]:             return func(*args, **kw)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/provisioningserver/utils/twisted.py", line 856, in callInContext
Sep 08 10:08:04 region-controller regiond[3740301]:             return func(*args, **kwargs)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/provisioningserver/utils/twisted.py", line 203, in wrapper
Sep 08 10:08:04 region-controller regiond[3740301]:             result = func(*args, **kwargs)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/utils/orm.py", line 771, in call_within_transaction
Sep 08 10:08:04 region-controller regiond[3740301]:             return func_outside_txn(*args, **kwargs)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/utils/orm.py", line 574, in retrier
Sep 08 10:08:04 region-controller regiond[3740301]:             return func(*args, **kwargs)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3.10/contextlib.py", line 79, in inner
Sep 08 10:08:04 region-controller regiond[3740301]:             return func(*args, **kwds)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/websockets/base.py", line 431, in prep_user_execute
Sep 08 10:08:04 region-controller regiond[3740301]:             return self._call_method_track_queries(
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/websockets/base.py", line 477, in _call_method_track_queries
Sep 08 10:08:04 region-controller regiond[3740301]:             result = method(params)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/websockets/handlers/machine.py", line 1158, in action
Sep 08 10:08:04 region-controller regiond[3740301]:             ) = self._bulk_action(params["filter"], action_name, extra_params)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/websockets/handlers/machine.py", line 1120, in _bulk_action
Sep 08 10:08:04 region-controller regiond[3740301]:             self._action(machine, action_name, extra_params)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/websockets/handlers/machine.py", line 1108, in _action
Sep 08 10:08:04 region-controller regiond[3740301]:             return action.execute(**extra_params)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/node_action.py", line 187, in execute
Sep 08 10:08:04 region-controller regiond[3740301]:             create_audit_event(
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/audit.py", line 33, in create_audit_event
Sep 08 10:08:04 region-controller regiond[3740301]:             Event.objects.register_event_and_event_type(
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/maasserver/models/event.py", line 57, in register_event_and_event_type
Sep 08 10:08:04 region-controller regiond[3740301]:             Node.objects.get(system_id=system_id)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/django/db/models/manager.py", line 85, in manager_method
Sep 08 10:08:04 region-controller regiond[3740301]:             return getattr(self.get_queryset(), name)(*args, **kwargs)
Sep 08 10:08:04 region-controller regiond[3740301]:           File "/usr/lib/python3/dist-packages/django/db/models/query.py", line 438, in get
Sep 08 10:08:04 region-controller regiond[3740301]:             raise self.model.DoesNotExist(
Sep 08 10:08:04 region-controller regiond[3740301]:         maasserver.models.node.DoesNotExist: Node matching query does not exist.

PG TX log is here

2025-09-08 10:08:04.227 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_node" WHERE ("maasserver_node"."system_id" = 'matbts' AND NOT ("maasserver_node"."id" = 163)) LIMIT 1
2025-09-08 10:08:04.227 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_node" WHERE ("maasserver_node"."hardware_uuid" = '8d61d0eb-0868-03ce-e611-b7cf02177237' AND NOT ("maasserver_node"."id" = 163)) LIMIT 1
2025-09-08 10:08:04.228 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_node" WHERE ("maasserver_node"."hostname" = 'ip-10-12-5-3' AND NOT ("maasserver_node"."id" = 163)) LIMIT 1
2025-09-08 10:08:04.229 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: UPDATE "maasserver_node" SET "created" = '2025-09-04T06:21:32.251813'::timestamp, "updated" = '2025-09-08T10:08:04.228811'::timestamp, "system_id" = 'matbts', "hardware_uuid" = '8d61d0eb-0868-03ce-e611-b7cf02177237', "hostname" = 'ip-10-12-5-3', "description" = '', "pool_id" = 0, "domain_id" = 0, "address_ttl" = NULL, "status" = 12, "previous_status" = 6, "status_expires" = NULL, "owner_id" = 1, "bios_boot_method" = NULL, "osystem" = '', "distro_series" = '', "architecture" = 'amd64/generic', "min_hwe_kernel" = NULL, "hwe_kernel" = NULL, "node_type" = 0, "parent_id" = NULL, "agent_name" = '', "error_description" = '', "zone_id" = 1, "cpu_count" = 32, "cpu_speed" = 1800, "memory" = 131072, "swap_size" = NULL, "bmc_id" = 157, "instance_power_parameters" = '{"mac_address": "08:68:8D:61:D0:EB"}', "power_state" = 'off', "power_state_queried" = '2025-09-08T10:03:04.043589'::timestamp, "power_state_updated" = '2025-09-08T10:03:04.112056'::timestamp, "last_image_sync" = NULL, "error" = 'Finished refreshing matbts', "netboot" = true, "ephemeral_deploy" = false, "license_key" = '', "dynamic" = true, "boot_interface_id" = NULL, "boot_cluster_ip" = NULL, "boot_disk_id" = NULL, "gateway_link_ipv4_id" = NULL, "gateway_link_ipv6_id" = NULL, "default_user" = '', "install_rackd" = false, "install_kvm" = false, "register_vmhost" = false, "enable_ssh" = false, "skip_networking" = false, "skip_storage" = false, "url" = 'http://10.108.0.1:5240/MAAS/', "dns_process_id" = NULL, "managing_process_id" = NULL, "current_commissioning_script_set_id" = 694, "current_installation_script_set_id" = NULL, "current_testing_script_set_id" = NULL, "current_release_script_set_id" = NULL, "locked" = false, "last_applied_storage_layout" = '', "current_config_id" = 161, "enable_hw_sync" = false, "sync_interval" = NULL, "last_sync" = NULL WHERE "maasserver_node"."id" = 163
2025-09-08 10:08:04.233 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."system_id" = 'matbts' LIMIT 21
2025-09-08 10:08:04.234 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_eventtype"."id", "maasserver_eventtype"."created", "maasserver_eventtype"."updated", "maasserver_eventtype"."name", "maasserver_eventtype"."description", "maasserver_eventtype"."level" FROM "maasserver_eventtype" WHERE "maasserver_eventtype"."name" = 'NODE_CHANGED_STATUS' LIMIT 21
2025-09-08 10:08:04.235 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: INSERT INTO "maasserver_event" ("created", "updated", "type_id", "node_id", "node_system_id", "node_hostname", "user_id", "username", "ip_address", "endpoint", "user_agent", "action", "description") VALUES ('2025-09-08T10:08:04.234789'::timestamp, '2025-09-08T10:08:04.234789'::timestamp, 10, 163, 'matbts', 'ip-10-12-5-3', NULL, '', NULL, 0, '', '', 'From ''Deployed'' to ''Releasing''') RETURNING "maasserver_event"."id"
2025-09-08 10:08:04.236 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" LEFT OUTER JOIN "maasserver_node" ON ("maasserver_bmc"."id" = "maasserver_node"."bmc_id") WHERE ("maasserver_node"."id" IS NULL AND NOT ("maasserver_bmc"."bmc_type" = 1))
2025-09-08 10:08:04.238 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_node" WHERE ("maasserver_node"."system_id" = 'matbts' AND NOT ("maasserver_node"."id" = 163)) LIMIT 1
2025-09-08 10:08:04.239 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_node" WHERE ("maasserver_node"."hardware_uuid" = '8d61d0eb-0868-03ce-e611-b7cf02177237' AND NOT ("maasserver_node"."id" = 163)) LIMIT 1
2025-09-08 10:08:04.239 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_node" WHERE ("maasserver_node"."hostname" = 'ip-10-12-5-3' AND NOT ("maasserver_node"."id" = 163)) LIMIT 1
2025-09-08 10:08:04.240 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: UPDATE "maasserver_node" SET "created" = '2025-09-04T06:21:32.251813'::timestamp, "updated" = '2025-09-08T10:08:04.239964'::timestamp, "system_id" = 'matbts', "hardware_uuid" = '8d61d0eb-0868-03ce-e611-b7cf02177237', "hostname" = 'ip-10-12-5-3', "description" = '', "pool_id" = 0, "domain_id" = 0, "address_ttl" = NULL, "status" = 12, "previous_status" = 6, "status_expires" = NULL, "owner_id" = 1, "bios_boot_method" = NULL, "osystem" = '', "distro_series" = '', "architecture" = 'amd64/generic', "min_hwe_kernel" = NULL, "hwe_kernel" = NULL, "node_type" = 0, "parent_id" = NULL, "agent_name" = '', "error_description" = '', "zone_id" = 1, "cpu_count" = 32, "cpu_speed" = 1800, "memory" = 131072, "swap_size" = NULL, "bmc_id" = 157, "instance_power_parameters" = '{"mac_address": "08:68:8D:61:D0:EB"}', "power_state" = 'off', "power_state_queried" = '2025-09-08T10:03:04.043589'::timestamp, "power_state_updated" = '2025-09-08T10:03:04.112056'::timestamp, "last_image_sync" = NULL, "error" = 'Finished refreshing matbts', "netboot" = true, "ephemeral_deploy" = false, "license_key" = '', "dynamic" = true, "boot_interface_id" = NULL, "boot_cluster_ip" = NULL, "boot_disk_id" = NULL, "gateway_link_ipv4_id" = NULL, "gateway_link_ipv6_id" = NULL, "default_user" = '', "install_rackd" = false, "install_kvm" = false, "register_vmhost" = false, "enable_ssh" = false, "skip_networking" = false, "skip_storage" = false, "url" = 'http://10.108.0.1:5240/MAAS/', "dns_process_id" = NULL, "managing_process_id" = NULL, "current_commissioning_script_set_id" = 694, "current_installation_script_set_id" = NULL, "current_testing_script_set_id" = NULL, "current_release_script_set_id" = NULL, "locked" = false, "last_applied_storage_layout" = '', "current_config_id" = 161, "enable_hw_sync" = false, "sync_interval" = NULL, "last_sync" = NULL WHERE "maasserver_node"."id" = 163
2025-09-08 10:08:04.242 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" LEFT OUTER JOIN "maasserver_node" ON ("maasserver_bmc"."id" = "maasserver_node"."bmc_id") WHERE ("maasserver_node"."id" IS NULL AND NOT ("maasserver_bmc"."bmc_type" = 1))
2025-09-08 10:08:04.244 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_eventtype"."id", "maasserver_eventtype"."created", "maasserver_eventtype"."updated", "maasserver_eventtype"."name", "maasserver_eventtype"."description", "maasserver_eventtype"."level" FROM "maasserver_eventtype" WHERE "maasserver_eventtype"."name" = 'RELEASING' LIMIT 21
2025-09-08 10:08:04.245 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: INSERT INTO "maasserver_event" ("created", "updated", "type_id", "node_id", "node_system_id", "node_hostname", "user_id", "username", "ip_address", "endpoint", "user_agent", "action", "description") VALUES ('2025-09-08T10:08:04.244728'::timestamp, '2025-09-08T10:08:04.244728'::timestamp, 17, 163, 'matbts', 'ip-10-12-5-3', NULL, '', NULL, 0, '', '', '') RETURNING "maasserver_event"."id"
2025-09-08 10:08:04.246 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_numanodehugepages" WHERE "maasserver_numanodehugepages"."id" IN (SELECT U0."id" FROM "maasserver_numanodehugepages" U0 INNER JOIN "maasserver_numanode" U1 ON (U0."numanode_id" = U1."id") WHERE U1."node_id" = 163)
2025-09-08 10:08:04.249 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_filesystem" WHERE ("maasserver_filesystem"."node_config_id" = 161 AND "maasserver_filesystem"."acquired")
2025-09-08 10:08:04.250 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE ("maasserver_node"."parent_id" = 163 AND "maasserver_node"."node_type" = 1)
2025-09-08 10:08:04.251 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_secret" WHERE "maasserver_secret"."path" = 'node/163/deploy-metadata'
2025-09-08 10:08:04.251 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SAVEPOINT "s139744961861184_x17"
2025-09-08 10:08:04.253 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT DISTINCT "maasserver_bmc"."name" FROM "maasserver_bmc" LEFT OUTER JOIN "maasserver_podhints" ON ("maasserver_bmc"."id" = "maasserver_podhints"."pod_id") LEFT OUTER JOIN "maasserver_podhints_nodes" ON ("maasserver_podhints"."id" = "maasserver_podhints_nodes"."podhints_id") LEFT OUTER JOIN "maasserver_staticipaddress" ON ("maasserver_bmc"."ip_address_id" = "maasserver_staticipaddress"."id") WHERE ("maasserver_bmc"."bmc_type" = 1 AND ("maasserver_podhints_nodes"."node_id" IN (163) OR "maasserver_staticipaddress"."ip" IN (SELECT U0."ip" FROM "maasserver_staticipaddress" U0 INNER JOIN "maasserver_interface_ip_addresses" U1 ON (U0."id" = U1."staticipaddress_id") INNER JOIN "maasserver_interface" U2 ON (U1."interface_id" = U2."id") WHERE U2."node_config_id" = 161)))
2025-09-08 10:08:04.254 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT COUNT(*) AS "__count" FROM "maasserver_node" WHERE "maasserver_node"."bmc_id" = 157
2025-09-08 10:08:04.255 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."id", "maasserver_staticipaddress"."created", "maasserver_staticipaddress"."updated", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type", "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."user_id", "maasserver_staticipaddress"."lease_time", "maasserver_staticipaddress"."temp_expires_on" FROM "maasserver_staticipaddress" WHERE "maasserver_staticipaddress"."id" = 2070 LIMIT 21
2025-09-08 10:08:04.256 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_secret" WHERE "maasserver_secret"."path" IN ('bmc/157/power-parameters')
2025-09-08 10:08:04.257 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."bmc_id" IN (157)
2025-09-08 10:08:04.258 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_numanode"."id" FROM "maasserver_numanode" WHERE "maasserver_numanode"."node_id" IN (163)
2025-09-08 10:08:04.259 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" WHERE "maasserver_interface"."numa_node_id" IN (314, 315) ORDER BY "maasserver_interface"."created" ASC
2025-09-08 10:08:04.261 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."boot_interface_id" IN (1559, 1560)
2025-09-08 10:08:04.262 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodedevice"."id" FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."physical_interface_id" IN (1559, 1560)
2025-09-08 10:08:04.265 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_virtualmachineinterface"."id", "maasserver_virtualmachineinterface"."created", "maasserver_virtualmachineinterface"."updated", "maasserver_virtualmachineinterface"."vm_id", "maasserver_virtualmachineinterface"."mac_address", "maasserver_virtualmachineinterface"."host_interface_id", "maasserver_virtualmachineinterface"."attachment_type" FROM "maasserver_virtualmachineinterface" WHERE "maasserver_virtualmachineinterface"."host_interface_id" IN (1559, 1560)
2025-09-08 10:08:04.267 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_blockdevice"."id", "maasserver_blockdevice"."created", "maasserver_blockdevice"."updated", "maasserver_blockdevice"."node_config_id", "maasserver_blockdevice"."name", "maasserver_blockdevice"."id_path", "maasserver_blockdevice"."size", "maasserver_blockdevice"."block_size", "maasserver_blockdevice"."tags", "maasserver_physicalblockdevice"."blockdevice_ptr_id", "maasserver_physicalblockdevice"."model", "maasserver_physicalblockdevice"."serial", "maasserver_physicalblockdevice"."firmware_version", "maasserver_physicalblockdevice"."numa_node_id" FROM "maasserver_physicalblockdevice" INNER JOIN "maasserver_blockdevice" ON ("maasserver_physicalblockdevice"."blockdevice_ptr_id" = "maasserver_blockdevice"."id") WHERE "maasserver_physicalblockdevice"."numa_node_id" IN (314, 315) ORDER BY "maasserver_physicalblockdevice"."blockdevice_ptr_id" ASC
2025-09-08 10:08:04.268 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_partitiontable"."id" FROM "maasserver_partitiontable" WHERE "maasserver_partitiontable"."block_device_id" IN (1898, 1899)
2025-09-08 10:08:04.269 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_virtualmachinedisk"."id", "maasserver_virtualmachinedisk"."created", "maasserver_virtualmachinedisk"."updated", "maasserver_virtualmachinedisk"."name", "maasserver_virtualmachinedisk"."vm_id", "maasserver_virtualmachinedisk"."backing_pool_id", "maasserver_virtualmachinedisk"."block_device_id", "maasserver_virtualmachinedisk"."size" FROM "maasserver_virtualmachinedisk" WHERE "maasserver_virtualmachinedisk"."block_device_id" IN (1898, 1899)
2025-09-08 10:08:04.270 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."boot_disk_id" IN (1898, 1899)
2025-09-08 10:08:04.271 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodedevice"."id" FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."physical_blockdevice_id" IN (1898, 1899)
2025-09-08 10:08:04.272 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodedevice"."id" FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."numa_node_id" IN (314, 315)
2025-09-08 10:08:04.278 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_vlan"."id" FROM "maasserver_vlan" WHERE "maasserver_vlan"."primary_rack_id" IN (163)
2025-09-08 10:08:04.279 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_vlan"."id" FROM "maasserver_vlan" WHERE "maasserver_vlan"."secondary_rack_id" IN (163)
2025-09-08 10:08:04.280 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."parent_id" IN (163)
2025-09-08 10:08:04.281 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_controllerinfo"."created", "maasserver_controllerinfo"."updated", "maasserver_controllerinfo"."node_id", "maasserver_controllerinfo"."version", "maasserver_controllerinfo"."update_version", "maasserver_controllerinfo"."update_origin", "maasserver_controllerinfo"."update_first_reported", "maasserver_controllerinfo"."install_type", "maasserver_controllerinfo"."snap_cohort", "maasserver_controllerinfo"."snap_revision", "maasserver_controllerinfo"."snap_update_revision", "maasserver_controllerinfo"."vault_configured" FROM "maasserver_controllerinfo" WHERE "maasserver_controllerinfo"."node_id" IN (163)
2025-09-08 10:08:04.282 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_dhcpsnippet"."id", "maasserver_dhcpsnippet"."created", "maasserver_dhcpsnippet"."updated", "maasserver_dhcpsnippet"."name", "maasserver_dhcpsnippet"."value_id", "maasserver_dhcpsnippet"."description", "maasserver_dhcpsnippet"."enabled", "maasserver_dhcpsnippet"."node_id", "maasserver_dhcpsnippet"."subnet_id", "maasserver_dhcpsnippet"."iprange_id" FROM "maasserver_dhcpsnippet" WHERE "maasserver_dhcpsnippet"."node_id" IN (163)
2025-09-08 10:08:04.283 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodeconfig"."id" FROM "maasserver_nodeconfig" WHERE "maasserver_nodeconfig"."node_id" IN (163)
2025-09-08 10:08:04.283 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_blockdevice"."id", "maasserver_blockdevice"."created", "maasserver_blockdevice"."updated", "maasserver_blockdevice"."node_config_id", "maasserver_blockdevice"."name", "maasserver_blockdevice"."id_path", "maasserver_blockdevice"."size", "maasserver_blockdevice"."block_size", "maasserver_blockdevice"."tags" FROM "maasserver_blockdevice" WHERE "maasserver_blockdevice"."node_config_id" IN (161) ORDER BY "maasserver_blockdevice"."id" ASC
2025-09-08 10:08:04.284 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" WHERE "maasserver_interface"."node_config_id" IN (161) ORDER BY "maasserver_interface"."created" ASC
2025-09-08 10:08:04.286 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."boot_interface_id" IN (1561)
2025-09-08 10:08:04.287 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodedevice"."id" FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."physical_interface_id" IN (1561)
2025-09-08 10:08:04.287 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_virtualmachineinterface"."id", "maasserver_virtualmachineinterface"."created", "maasserver_virtualmachineinterface"."updated", "maasserver_virtualmachineinterface"."vm_id", "maasserver_virtualmachineinterface"."mac_address", "maasserver_virtualmachineinterface"."host_interface_id", "maasserver_virtualmachineinterface"."attachment_type" FROM "maasserver_virtualmachineinterface" WHERE "maasserver_virtualmachineinterface"."host_interface_id" IN (1561)
2025-09-08 10:08:04.289 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."current_config_id" IN (161)
2025-09-08 10:08:04.290 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodedevice"."id" FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."node_config_id" IN (161)
2025-09-08 10:08:04.295 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_regioncontrollerprocess"."id", "maasserver_regioncontrollerprocess"."created", "maasserver_regioncontrollerprocess"."updated", "maasserver_regioncontrollerprocess"."region_id", "maasserver_regioncontrollerprocess"."pid" FROM "maasserver_regioncontrollerprocess" WHERE "maasserver_regioncontrollerprocess"."region_id" IN (163) ORDER BY "maasserver_regioncontrollerprocess"."pid" ASC
2025-09-08 10:08:04.295 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_regionrackrpcconnection"."id", "maasserver_regionrackrpcconnection"."created", "maasserver_regionrackrpcconnection"."updated", "maasserver_regionrackrpcconnection"."endpoint_id", "maasserver_regionrackrpcconnection"."rack_controller_id" FROM "maasserver_regionrackrpcconnection" WHERE "maasserver_regionrackrpcconnection"."rack_controller_id" IN (163)
2025-09-08 10:08:04.296 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_scriptset"."id" FROM "maasserver_scriptset" WHERE "maasserver_scriptset"."node_id" IN (163)
2025-09-08 10:08:04.297 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."current_commissioning_script_set_id" IN (694)
2025-09-08 10:08:04.299 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."current_installation_script_set_id" IN (694)
2025-09-08 10:08:04.300 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."current_testing_script_set_id" IN (694)
2025-09-08 10:08:04.302 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."current_release_script_set_id" IN (694)
2025-09-08 10:08:04.303 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_virtualmachine"."id" FROM "maasserver_virtualmachine" WHERE "maasserver_virtualmachine"."machine_id" IN (163)
2025-09-08 10:08:04.305 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_podhints"."id" FROM "maasserver_podhints" WHERE "maasserver_podhints"."pod_id" IN (157)
2025-09-08 10:08:04.306 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_podstoragepool"."id" FROM "maasserver_podstoragepool" WHERE "maasserver_podstoragepool"."pod_id" IN (157)
2025-09-08 10:08:04.307 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_virtualmachine"."id" FROM "maasserver_virtualmachine" WHERE "maasserver_virtualmachine"."bmc_id" IN (157)
2025-09-08 10:08:04.308 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interfacerelationship"."id", "maasserver_interfacerelationship"."created", "maasserver_interfacerelationship"."updated", "maasserver_interfacerelationship"."child_id", "maasserver_interfacerelationship"."parent_id" FROM "maasserver_interfacerelationship" WHERE "maasserver_interfacerelationship"."parent_id" = 1559
2025-09-08 10:08:04.310 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" WHERE "maasserver_interface"."id" = 1561 LIMIT 21
2025-09-08 10:08:04.311 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" INNER JOIN "maasserver_interfacerelationship" ON ("maasserver_interface"."id" = "maasserver_interfacerelationship"."parent_id") WHERE "maasserver_interfacerelationship"."child_id" = 1561 ORDER BY "maasserver_interface"."created" ASC
2025-09-08 10:08:04.314 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."id", "maasserver_staticipaddress"."created", "maasserver_staticipaddress"."updated", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type", "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."user_id", "maasserver_staticipaddress"."lease_time", "maasserver_staticipaddress"."temp_expires_on", COUNT("maasserver_interface_ip_addresses"."interface_id") AS "interface_count" FROM "maasserver_staticipaddress" LEFT OUTER JOIN "maasserver_interface_ip_addresses" ON ("maasserver_staticipaddress"."id" = "maasserver_interface_ip_addresses"."staticipaddress_id") WHERE "maasserver_staticipaddress"."id" IN (SELECT U0."id" FROM "maasserver_staticipaddress" U0 INNER JOIN "maasserver_interface_ip_addresses" U1 ON (U0."id" = U1."staticipaddress_id") WHERE U1."interface_id" = 1559) GROUP BY "maasserver_staticipaddress"."id" HAVING COUNT("maasserver_interface_ip_addresses"."interface_id") <= 1
2025-09-08 10:08:04.316 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interfacerelationship"."id", "maasserver_interfacerelationship"."created", "maasserver_interfacerelationship"."updated", "maasserver_interfacerelationship"."child_id", "maasserver_interfacerelationship"."parent_id" FROM "maasserver_interfacerelationship" WHERE "maasserver_interfacerelationship"."parent_id" = 1560
2025-09-08 10:08:04.316 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" WHERE "maasserver_interface"."id" = 1561 LIMIT 21
2025-09-08 10:08:04.317 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" INNER JOIN "maasserver_interfacerelationship" ON ("maasserver_interface"."id" = "maasserver_interfacerelationship"."parent_id") WHERE "maasserver_interfacerelationship"."child_id" = 1561 ORDER BY "maasserver_interface"."created" ASC
2025-09-08 10:08:04.319 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."id", "maasserver_staticipaddress"."created", "maasserver_staticipaddress"."updated", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type", "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."user_id", "maasserver_staticipaddress"."lease_time", "maasserver_staticipaddress"."temp_expires_on", COUNT("maasserver_interface_ip_addresses"."interface_id") AS "interface_count" FROM "maasserver_staticipaddress" LEFT OUTER JOIN "maasserver_interface_ip_addresses" ON ("maasserver_staticipaddress"."id" = "maasserver_interface_ip_addresses"."staticipaddress_id") WHERE "maasserver_staticipaddress"."id" IN (SELECT U0."id" FROM "maasserver_staticipaddress" U0 INNER JOIN "maasserver_interface_ip_addresses" U1 ON (U0."id" = U1."staticipaddress_id") WHERE U1."interface_id" = 1560) GROUP BY "maasserver_staticipaddress"."id" HAVING COUNT("maasserver_interface_ip_addresses"."interface_id") <= 1
2025-09-08 10:08:04.321 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interfacerelationship"."id", "maasserver_interfacerelationship"."created", "maasserver_interfacerelationship"."updated", "maasserver_interfacerelationship"."child_id", "maasserver_interfacerelationship"."parent_id" FROM "maasserver_interfacerelationship" WHERE "maasserver_interfacerelationship"."parent_id" = 1561
2025-09-08 10:08:04.322 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."id", "maasserver_staticipaddress"."created", "maasserver_staticipaddress"."updated", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type", "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."user_id", "maasserver_staticipaddress"."lease_time", "maasserver_staticipaddress"."temp_expires_on", COUNT("maasserver_interface_ip_addresses"."interface_id") AS "interface_count" FROM "maasserver_staticipaddress" LEFT OUTER JOIN "maasserver_interface_ip_addresses" ON ("maasserver_staticipaddress"."id" = "maasserver_interface_ip_addresses"."staticipaddress_id") WHERE "maasserver_staticipaddress"."id" IN (SELECT U0."id" FROM "maasserver_staticipaddress" U0 INNER JOIN "maasserver_interface_ip_addresses" U1 ON (U0."id" = U1."staticipaddress_id") WHERE U1."interface_id" = 1561) GROUP BY "maasserver_staticipaddress"."id" HAVING COUNT("maasserver_interface_ip_addresses"."interface_id") <= 1
2025-09-08 10:08:04.324 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."gateway_link_ipv4_id" IN (2047, 2048, 2049)
2025-09-08 10:08:04.326 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."gateway_link_ipv6_id" IN (2047, 2048, 2049)
2025-09-08 10:08:04.327 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" IN (2047, 2048, 2049)
2025-09-08 10:08:04.328 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" = 2047
2025-09-08 10:08:04.329 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_dnsresource"."id", "maasserver_dnsresource"."created", "maasserver_dnsresource"."updated", "maasserver_dnsresource"."name", "maasserver_dnsresource"."address_ttl", "maasserver_dnsresource"."domain_id" FROM "maasserver_dnsresource" INNER JOIN "maasserver_dnsresource_ip_addresses" ON ("maasserver_dnsresource"."id" = "maasserver_dnsresource_ip_addresses"."dnsresource_id") WHERE "maasserver_dnsresource_ip_addresses"."staticipaddress_id" = 2047
2025-09-08 10:08:04.331 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" = 2048
2025-09-08 10:08:04.332 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_dnsresource"."id", "maasserver_dnsresource"."created", "maasserver_dnsresource"."updated", "maasserver_dnsresource"."name", "maasserver_dnsresource"."address_ttl", "maasserver_dnsresource"."domain_id" FROM "maasserver_dnsresource" INNER JOIN "maasserver_dnsresource_ip_addresses" ON ("maasserver_dnsresource"."id" = "maasserver_dnsresource_ip_addresses"."dnsresource_id") WHERE "maasserver_dnsresource_ip_addresses"."staticipaddress_id" = 2048
2025-09-08 10:08:04.333 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" = 2049
2025-09-08 10:08:04.333 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_dnsresource"."id", "maasserver_dnsresource"."created", "maasserver_dnsresource"."updated", "maasserver_dnsresource"."name", "maasserver_dnsresource"."address_ttl", "maasserver_dnsresource"."domain_id" FROM "maasserver_dnsresource" INNER JOIN "maasserver_dnsresource_ip_addresses" ON ("maasserver_dnsresource"."id" = "maasserver_dnsresource_ip_addresses"."dnsresource_id") WHERE "maasserver_dnsresource_ip_addresses"."staticipaddress_id" = 2049
2025-09-08 10:08:04.334 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interface_ip_addresses" WHERE "maasserver_interface_ip_addresses"."staticipaddress_id" IN (2047, 2048, 2049)
2025-09-08 10:08:04.342 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_dnsresource_ip_addresses" WHERE "maasserver_dnsresource_ip_addresses"."staticipaddress_id" IN (2047, 2048, 2049)
2025-09-08 10:08:04.342 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_staticipaddress" WHERE "maasserver_staticipaddress"."id" IN (2049, 2048, 2047)
2025-09-08 10:08:04.346 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_subnet"."id", "maasserver_subnet"."created", "maasserver_subnet"."updated", "maasserver_subnet"."name", "maasserver_subnet"."description", "maasserver_subnet"."vlan_id", "maasserver_subnet"."cidr", "maasserver_subnet"."rdns_mode", "maasserver_subnet"."gateway_ip", "maasserver_subnet"."dns_servers", "maasserver_subnet"."allow_dns", "maasserver_subnet"."allow_proxy", "maasserver_subnet"."active_discovery", "maasserver_subnet"."managed", "maasserver_subnet"."disabled_boot_architectures" FROM "maasserver_subnet" WHERE "maasserver_subnet"."id" = 37 LIMIT 21
2025-09-08 10:08:04.347 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" WHERE "maasserver_config"."name" = 'subnet_ip_exhaustion_threshold_count' LIMIT 21
2025-09-08 10:08:04.348 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" LIMIT 21
2025-09-08 10:08:04.349 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_notification"."id", "maasserver_notification"."created", "maasserver_notification"."updated", "maasserver_notification"."ident", "maasserver_notification"."user_id", "maasserver_notification"."users", "maasserver_notification"."admins", "maasserver_notification"."message", "maasserver_notification"."context", "maasserver_notification"."category", "maasserver_notification"."dismissable" FROM "maasserver_notification" WHERE "maasserver_notification"."ident" = 'ip_exhaustion__subnet_37' ORDER BY "maasserver_notification"."id" ASC LIMIT 1
2025-09-08 10:08:04.350 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticroute"."id", "maasserver_staticroute"."created", "maasserver_staticroute"."updated", "maasserver_staticroute"."source_id", "maasserver_staticroute"."destination_id", "maasserver_staticroute"."gateway_ip", "maasserver_staticroute"."metric" FROM "maasserver_staticroute" WHERE "maasserver_staticroute"."source_id" = 37
2025-09-08 10:08:04.351 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type" FROM "maasserver_staticipaddress" WHERE ("maasserver_staticipaddress"."ip" IS NOT NULL AND "maasserver_staticipaddress"."subnet_id" IN (37))
2025-09-08 10:08:04.353 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 37
2025-09-08 10:08:04.354 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 37
2025-09-08 10:08:04.356 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_subnet"."id", "maasserver_subnet"."created", "maasserver_subnet"."updated", "maasserver_subnet"."name", "maasserver_subnet"."description", "maasserver_subnet"."vlan_id", "maasserver_subnet"."cidr", "maasserver_subnet"."rdns_mode", "maasserver_subnet"."gateway_ip", "maasserver_subnet"."dns_servers", "maasserver_subnet"."allow_dns", "maasserver_subnet"."allow_proxy", "maasserver_subnet"."active_discovery", "maasserver_subnet"."managed", "maasserver_subnet"."disabled_boot_architectures" FROM "maasserver_subnet" WHERE "maasserver_subnet"."id" = 38 LIMIT 21
2025-09-08 10:08:04.357 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" WHERE "maasserver_config"."name" = 'subnet_ip_exhaustion_threshold_count' LIMIT 21
2025-09-08 10:08:04.357 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" LIMIT 21
2025-09-08 10:08:04.358 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_notification"."id", "maasserver_notification"."created", "maasserver_notification"."updated", "maasserver_notification"."ident", "maasserver_notification"."user_id", "maasserver_notification"."users", "maasserver_notification"."admins", "maasserver_notification"."message", "maasserver_notification"."context", "maasserver_notification"."category", "maasserver_notification"."dismissable" FROM "maasserver_notification" WHERE "maasserver_notification"."ident" = 'ip_exhaustion__subnet_38' ORDER BY "maasserver_notification"."id" ASC LIMIT 1
2025-09-08 10:08:04.359 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticroute"."id", "maasserver_staticroute"."created", "maasserver_staticroute"."updated", "maasserver_staticroute"."source_id", "maasserver_staticroute"."destination_id", "maasserver_staticroute"."gateway_ip", "maasserver_staticroute"."metric" FROM "maasserver_staticroute" WHERE "maasserver_staticroute"."source_id" = 38
2025-09-08 10:08:04.360 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type" FROM "maasserver_staticipaddress" WHERE ("maasserver_staticipaddress"."ip" IS NOT NULL AND "maasserver_staticipaddress"."subnet_id" IN (38))
2025-09-08 10:08:04.361 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 38
2025-09-08 10:08:04.361 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 38
2025-09-08 10:08:04.363 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_subnet"."id", "maasserver_subnet"."created", "maasserver_subnet"."updated", "maasserver_subnet"."name", "maasserver_subnet"."description", "maasserver_subnet"."vlan_id", "maasserver_subnet"."cidr", "maasserver_subnet"."rdns_mode", "maasserver_subnet"."gateway_ip", "maasserver_subnet"."dns_servers", "maasserver_subnet"."allow_dns", "maasserver_subnet"."allow_proxy", "maasserver_subnet"."active_discovery", "maasserver_subnet"."managed", "maasserver_subnet"."disabled_boot_architectures" FROM "maasserver_subnet" WHERE "maasserver_subnet"."id" = 39 LIMIT 21
2025-09-08 10:08:04.363 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" WHERE "maasserver_config"."name" = 'subnet_ip_exhaustion_threshold_count' LIMIT 21
2025-09-08 10:08:04.364 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" LIMIT 21
2025-09-08 10:08:04.365 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_notification"."id", "maasserver_notification"."created", "maasserver_notification"."updated", "maasserver_notification"."ident", "maasserver_notification"."user_id", "maasserver_notification"."users", "maasserver_notification"."admins", "maasserver_notification"."message", "maasserver_notification"."context", "maasserver_notification"."category", "maasserver_notification"."dismissable" FROM "maasserver_notification" WHERE "maasserver_notification"."ident" = 'ip_exhaustion__subnet_39' ORDER BY "maasserver_notification"."id" ASC LIMIT 1
2025-09-08 10:08:04.366 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticroute"."id", "maasserver_staticroute"."created", "maasserver_staticroute"."updated", "maasserver_staticroute"."source_id", "maasserver_staticroute"."destination_id", "maasserver_staticroute"."gateway_ip", "maasserver_staticroute"."metric" FROM "maasserver_staticroute" WHERE "maasserver_staticroute"."source_id" = 39
2025-09-08 10:08:04.367 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type" FROM "maasserver_staticipaddress" WHERE ("maasserver_staticipaddress"."ip" IS NOT NULL AND "maasserver_staticipaddress"."subnet_id" IN (39))
2025-09-08 10:08:04.367 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 39
2025-09-08 10:08:04.368 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 39
2025-09-08 10:08:04.369 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: UPDATE "maasserver_event" SET "node_hostname" = 'ip-10-12-5-3', "node_id" = NULL WHERE "maasserver_event"."node_id" = 163
2025-09-08 10:08:04.387 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodedevicevpd" WHERE "maasserver_nodedevicevpd"."node_device_id" IN (34277, 34278)
2025-09-08 10:08:04.388 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interface_ip_addresses" WHERE "maasserver_interface_ip_addresses"."interface_id" IN (1559, 1560)
2025-09-08 10:08:04.389 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interfacerelationship" WHERE ("maasserver_interfacerelationship"."child_id" IN (1559, 1560) OR "maasserver_interfacerelationship"."parent_id" IN (1559, 1560))
2025-09-08 10:08:04.389 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_mdns" WHERE "maasserver_mdns"."interface_id" IN (1559, 1560)
2025-09-08 10:08:04.390 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_neighbour" WHERE "maasserver_neighbour"."interface_id" IN (1559, 1560)
2025-09-08 10:08:04.390 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_scriptresult" WHERE "maasserver_scriptresult"."interface_id" IN (1559, 1560)
2025-09-08 10:08:04.390 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_filesystem" WHERE "maasserver_filesystem"."block_device_id" IN (1898, 1899)
2025-09-08 10:08:04.391 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_scriptresult" WHERE "maasserver_scriptresult"."physical_blockdevice_id" IN (1898, 1899)
2025-09-08 10:08:04.393 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodedevicevpd" WHERE "maasserver_nodedevicevpd"."node_device_id" IN (34177, 34178, 34179, 34180, 34181, 34182, 34183, 34184, 34185, 34186, 34187, 34188, 34189, 34190, 34191, 34192, 34193, 34194, 34195, 34196, 34197, 34198, 34199, 34200, 34201, 34202, 34203, 34204, 34205, 34206, 34207, 34208, 34209, 34210, 34211, 34212, 34213, 34214, 34215, 34216, 34217, 34218, 34219, 34220, 34221, 34222, 34223, 34224, 34225, 34226, 34227, 34228, 34229, 34230, 34231, 34232, 34233, 34234, 34235, 34236, 34237, 34238, 34239, 34240, 34241, 34242, 34243, 34244, 34245, 34246, 34247, 34248, 34249, 34250, 34251, 34252, 34253, 34254, 34255, 34256, 34257, 34258, 34259, 34260, 34261, 34262, 34263, 34264, 34265, 34266, 34267, 34268, 34269, 34270, 34271, 34272, 34273, 34274, 34275, 34276, 34279, 34280, 34281, 34282, 34283, 34284, 34285, 34286, 34287, 34288, 34289, 34290, 34291, 34382, 34292, 34293, 34294, 34295, 34296, 34297, 34298, 34299, 34300, 34301, 34302, 34303, 34304, 34305, 34306, 34307, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34318, 34319, 34320, 34321, 34322, 34323, 34324, 34325, 34326, 34327, 34328, 34329, 34330, 34331, 34332, 34333, 34334, 34335, 34336, 34337, 34338, 34339, 34340, 34341, 34342, 34343, 34344, 34345, 34346, 34347, 34348, 34349, 34350, 34351, 34352, 34353, 34354, 34355, 34356, 34357, 34358, 34359, 34360, 34361, 34362, 34363, 34364, 34365, 34366, 34367, 34368, 34369, 34370, 34371, 34372, 34373, 34374, 34375, 34376, 34377, 34378, 34379, 34380, 34381)
2025-09-08 10:08:04.395 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_numanodehugepages" WHERE "maasserver_numanodehugepages"."numanode_id" IN (314, 315)
2025-09-08 10:08:04.395 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interface_ip_addresses" WHERE "maasserver_interface_ip_addresses"."interface_id" IN (1561)
2025-09-08 10:08:04.395 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interfacerelationship" WHERE ("maasserver_interfacerelationship"."child_id" IN (1561) OR "maasserver_interfacerelationship"."parent_id" IN (1561))
2025-09-08 10:08:04.396 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_mdns" WHERE "maasserver_mdns"."interface_id" IN (1561)
2025-09-08 10:08:04.396 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_neighbour" WHERE "maasserver_neighbour"."interface_id" IN (1561)
2025-09-08 10:08:04.398 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_scriptresult" WHERE "maasserver_scriptresult"."interface_id" IN (1561)
2025-09-08 10:08:04.398 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_filesystem" WHERE "maasserver_filesystem"."node_config_id" IN (161)
2025-09-08 10:08:04.398 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_scriptresult" WHERE "maasserver_scriptresult"."script_set_id" IN (694)
2025-09-08 10:08:04.401 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_ownerdata" WHERE "maasserver_ownerdata"."node_id" IN (163)
2025-09-08 10:08:04.402 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_service" WHERE "maasserver_service"."node_id" IN (163)
2025-09-08 10:08:04.402 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_node_tags" WHERE "maasserver_node_tags"."node_id" IN (163)
2025-09-08 10:08:04.403 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_podhints_nodes" WHERE "maasserver_podhints_nodes"."node_id" IN (163)
2025-09-08 10:08:04.403 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_bmcroutablerackcontrollerrelationship" WHERE "maasserver_bmcroutablerackcontrollerrelationship"."rack_controller_id" IN (163)
2025-09-08 10:08:04.404 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_bootresourcefilesync" WHERE "maasserver_bootresourcefilesync"."region_id" IN (163)
2025-09-08 10:08:04.404 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodekey" WHERE "maasserver_nodekey"."node_id" IN (163)
2025-09-08 10:08:04.405 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodemetadata" WHERE "maasserver_nodemetadata"."node_id" IN (163)
2025-09-08 10:08:04.406 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodeuserdata" WHERE "maasserver_nodeuserdata"."node_id" IN (163)
2025-09-08 10:08:04.407 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_rdns" WHERE "maasserver_rdns"."observer_id" IN (163)
2025-09-08 10:08:04.408 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_bmcroutablerackcontrollerrelationship" WHERE "maasserver_bmcroutablerackcontrollerrelationship"."bmc_id" IN (157)
2025-09-08 10:08:04.409 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: UPDATE "maasserver_node" SET "current_commissioning_script_set_id" = NULL WHERE "maasserver_node"."id" IN (163)
2025-09-08 10:08:04.410 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_bmc" WHERE "maasserver_bmc"."id" IN (157)
2025-09-08 10:08:04.412 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_interface"."id", "maasserver_interface"."created", "maasserver_interface"."updated", "maasserver_interface"."node_config_id", "maasserver_interface"."name", "maasserver_interface"."type", "maasserver_interface"."vlan_id", "maasserver_interface"."mac_address", "maasserver_interface"."params", "maasserver_interface"."tags", "maasserver_interface"."enabled", "maasserver_interface"."mdns_discovery_state", "maasserver_interface"."neighbour_discovery_state", "maasserver_interface"."acquired", "maasserver_interface"."vendor", "maasserver_interface"."product", "maasserver_interface"."firmware_version", "maasserver_interface"."link_connected", "maasserver_interface"."interface_speed", "maasserver_interface"."link_speed", "maasserver_interface"."numa_node_id", "maasserver_interface"."sriov_max_vf" FROM "maasserver_interface" INNER JOIN "maasserver_interface_ip_addresses" ON ("maasserver_interface"."id" = "maasserver_interface_ip_addresses"."interface_id") WHERE "maasserver_interface_ip_addresses"."staticipaddress_id" = 2070 ORDER BY "maasserver_interface"."created" ASC LIMIT 1
2025-09-08 10:08:04.413 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT (1) AS "a" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" = 2070 LIMIT 1
2025-09-08 10:08:04.414 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."gateway_link_ipv4_id" IN (2070)
2025-09-08 10:08:04.415 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."gateway_link_ipv6_id" IN (2070)
2025-09-08 10:08:04.417 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" IN (2070)
2025-09-08 10:08:04.418 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_bmc"."id", "maasserver_bmc"."created", "maasserver_bmc"."updated", "maasserver_bmc"."bmc_type", "maasserver_bmc"."ip_address_id", "maasserver_bmc"."power_type", "maasserver_bmc"."power_parameters", "maasserver_bmc"."name", "maasserver_bmc"."version", "maasserver_bmc"."architectures", "maasserver_bmc"."capabilities", "maasserver_bmc"."cores", "maasserver_bmc"."cpu_speed", "maasserver_bmc"."memory", "maasserver_bmc"."local_storage", "maasserver_bmc"."pool_id", "maasserver_bmc"."zone_id", "maasserver_bmc"."tags", "maasserver_bmc"."cpu_over_commit_ratio", "maasserver_bmc"."memory_over_commit_ratio", "maasserver_bmc"."default_storage_pool_id", "maasserver_bmc"."default_macvlan_mode", "maasserver_bmc"."created_with_trust_password", "maasserver_bmc"."created_with_maas_generated_cert", "maasserver_bmc"."created_with_cert_expiration_days", "maasserver_bmc"."created_by_commissioning" FROM "maasserver_bmc" WHERE "maasserver_bmc"."ip_address_id" = 2070
2025-09-08 10:08:04.419 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_dnsresource"."id", "maasserver_dnsresource"."created", "maasserver_dnsresource"."updated", "maasserver_dnsresource"."name", "maasserver_dnsresource"."address_ttl", "maasserver_dnsresource"."domain_id" FROM "maasserver_dnsresource" INNER JOIN "maasserver_dnsresource_ip_addresses" ON ("maasserver_dnsresource"."id" = "maasserver_dnsresource_ip_addresses"."dnsresource_id") WHERE "maasserver_dnsresource_ip_addresses"."staticipaddress_id" = 2070
2025-09-08 10:08:04.419 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interface_ip_addresses" WHERE "maasserver_interface_ip_addresses"."staticipaddress_id" IN (2070)
2025-09-08 10:08:04.420 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_dnsresource_ip_addresses" WHERE "maasserver_dnsresource_ip_addresses"."staticipaddress_id" IN (2070)
2025-09-08 10:08:04.420 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_staticipaddress" WHERE "maasserver_staticipaddress"."id" IN (2070)
2025-09-08 10:08:04.422 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_subnet"."id", "maasserver_subnet"."created", "maasserver_subnet"."updated", "maasserver_subnet"."name", "maasserver_subnet"."description", "maasserver_subnet"."vlan_id", "maasserver_subnet"."cidr", "maasserver_subnet"."rdns_mode", "maasserver_subnet"."gateway_ip", "maasserver_subnet"."dns_servers", "maasserver_subnet"."allow_dns", "maasserver_subnet"."allow_proxy", "maasserver_subnet"."active_discovery", "maasserver_subnet"."managed", "maasserver_subnet"."disabled_boot_architectures" FROM "maasserver_subnet" WHERE "maasserver_subnet"."id" = 37 LIMIT 21
2025-09-08 10:08:04.423 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" WHERE "maasserver_config"."name" = 'subnet_ip_exhaustion_threshold_count' LIMIT 21
2025-09-08 10:08:04.423 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_config"."id", "maasserver_config"."name", "maasserver_config"."value" FROM "maasserver_config" LIMIT 21
2025-09-08 10:08:04.424 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_notification"."id", "maasserver_notification"."created", "maasserver_notification"."updated", "maasserver_notification"."ident", "maasserver_notification"."user_id", "maasserver_notification"."users", "maasserver_notification"."admins", "maasserver_notification"."message", "maasserver_notification"."context", "maasserver_notification"."category", "maasserver_notification"."dismissable" FROM "maasserver_notification" WHERE "maasserver_notification"."ident" = 'ip_exhaustion__subnet_37' ORDER BY "maasserver_notification"."id" ASC LIMIT 1
2025-09-08 10:08:04.425 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticroute"."id", "maasserver_staticroute"."created", "maasserver_staticroute"."updated", "maasserver_staticroute"."source_id", "maasserver_staticroute"."destination_id", "maasserver_staticroute"."gateway_ip", "maasserver_staticroute"."metric" FROM "maasserver_staticroute" WHERE "maasserver_staticroute"."source_id" = 37
2025-09-08 10:08:04.426 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_staticipaddress"."subnet_id", "maasserver_staticipaddress"."ip", "maasserver_staticipaddress"."alloc_type" FROM "maasserver_staticipaddress" WHERE ("maasserver_staticipaddress"."ip" IS NOT NULL AND "maasserver_staticipaddress"."subnet_id" IN (37))
2025-09-08 10:08:04.428 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 37
2025-09-08 10:08:04.428 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_iprange"."id", "maasserver_iprange"."created", "maasserver_iprange"."updated", "maasserver_iprange"."subnet_id", "maasserver_iprange"."type", "maasserver_iprange"."start_ip", "maasserver_iprange"."end_ip", "maasserver_iprange"."user_id", "maasserver_iprange"."comment" FROM "maasserver_iprange" WHERE "maasserver_iprange"."subnet_id" = 37
2025-09-08 10:08:04.430 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_interface" WHERE "maasserver_interface"."id" IN (1561, 1560, 1559)
2025-09-08 10:08:04.437 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."id" IN (34382, 34381, 34380, 34379, 34378, 34377, 34376, 34375, 34374, 34373, 34372, 34371, 34370, 34369, 34368, 34367, 34366, 34365, 34364, 34363, 34362, 34361, 34360, 34359, 34358, 34357, 34356, 34355, 34354, 34353, 34352, 34351, 34350, 34349, 34348, 34347, 34346, 34345, 34344, 34343, 34342, 34341, 34340, 34339, 34338, 34337, 34336, 34335, 34334, 34333, 34332, 34331, 34330, 34329, 34328, 34327, 34326, 34325, 34324, 34323, 34322, 34321, 34320, 34319, 34318, 34317, 34316, 34315, 34314, 34313, 34312, 34311, 34310, 34309, 34308, 34307, 34306, 34305, 34304, 34303, 34302, 34301, 34300, 34299, 34298, 34297, 34296, 34295, 34294, 34293, 34292, 34291, 34290, 34289, 34288, 34287, 34286, 34285, 34284, 34283)
2025-09-08 10:08:04.438 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."id" IN (34282, 34281, 34280, 34279, 34278, 34277, 34276, 34275, 34274, 34273, 34272, 34271, 34270, 34269, 34268, 34267, 34266, 34265, 34264, 34263, 34262, 34261, 34260, 34259, 34258, 34257, 34256, 34255, 34254, 34253, 34252, 34251, 34250, 34249, 34248, 34247, 34246, 34245, 34244, 34243, 34242, 34241, 34240, 34239, 34238, 34237, 34236, 34235, 34234, 34233, 34232, 34231, 34230, 34229, 34228, 34227, 34226, 34225, 34224, 34223, 34222, 34221, 34220, 34219, 34218, 34217, 34216, 34215, 34214, 34213, 34212, 34211, 34210, 34209, 34208, 34207, 34206, 34205, 34204, 34203, 34202, 34201, 34200, 34199, 34198, 34197, 34196, 34195, 34194, 34193, 34192, 34191, 34190, 34189, 34188, 34187, 34186, 34185, 34184, 34183)
2025-09-08 10:08:04.439 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodedevice" WHERE "maasserver_nodedevice"."id" IN (34182, 34181, 34180, 34179, 34178, 34177)
2025-09-08 10:08:04.440 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_physicalblockdevice" WHERE "maasserver_physicalblockdevice"."blockdevice_ptr_id" IN (1899, 1898)
2025-09-08 10:08:04.441 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_blockdevice" WHERE "maasserver_blockdevice"."id" IN (1899, 1898)
2025-09-08 10:08:04.442 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_controllerinfo" WHERE "maasserver_controllerinfo"."node_id" IN (163)
2025-09-08 10:08:04.443 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT COUNT(*) FROM (SELECT DISTINCT "maasserver_controllerinfo"."install_type" AS Col1 FROM "maasserver_controllerinfo") subquery
2025-09-08 10:08:04.443 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT COUNT(*) FROM (SELECT DISTINCT "maasserver_controllerinfo"."update_origin" AS Col1 FROM "maasserver_controllerinfo") subquery
2025-09-08 10:08:04.444 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT COUNT(*) FROM (SELECT DISTINCT "maasserver_controllerinfo"."snap_cohort" AS Col1 FROM "maasserver_controllerinfo") subquery
2025-09-08 10:08:04.444 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT COUNT(*) FROM (SELECT DISTINCT "maasserver_controllerinfo"."version" AS Col1 FROM "maasserver_controllerinfo") subquery
2025-09-08 10:08:04.445 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT COUNT(*) FROM (SELECT DISTINCT "maasserver_controllerinfo"."update_version" AS Col1 FROM "maasserver_controllerinfo" WHERE NOT ("maasserver_controllerinfo"."update_version" = '')) subquery
2025-09-08 10:08:04.445 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_notification"."id", "maasserver_notification"."created", "maasserver_notification"."updated", "maasserver_notification"."ident", "maasserver_notification"."user_id", "maasserver_notification"."users", "maasserver_notification"."admins", "maasserver_notification"."message", "maasserver_notification"."context", "maasserver_notification"."category", "maasserver_notification"."dismissable" FROM "maasserver_notification" WHERE "maasserver_notification"."ident" = 'upgrade_version_issue'
2025-09-08 10:08:04.446 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_controllerinfo"."created", "maasserver_controllerinfo"."updated", "maasserver_controllerinfo"."node_id", "maasserver_controllerinfo"."version", "maasserver_controllerinfo"."update_version", "maasserver_controllerinfo"."update_origin", "maasserver_controllerinfo"."update_first_reported", "maasserver_controllerinfo"."install_type", "maasserver_controllerinfo"."snap_cohort", "maasserver_controllerinfo"."snap_revision", "maasserver_controllerinfo"."snap_update_revision", "maasserver_controllerinfo"."vault_configured" FROM "maasserver_controllerinfo" WHERE NOT ("maasserver_controllerinfo"."version" = '')
2025-09-08 10:08:04.447 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT DISTINCT "maasserver_controllerinfo"."update_origin" FROM "maasserver_controllerinfo" WHERE (("maasserver_controllerinfo"."version" = '3.5.7-16376-g.a0e1cf615' OR "maasserver_controllerinfo"."update_version" = '3.5.7-16376-g.a0e1cf615') AND "maasserver_controllerinfo"."install_type" = 'snap' AND NOT ("maasserver_controllerinfo"."update_origin" = ''))
2025-09-08 10:08:04.448 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT DISTINCT "maasserver_controllerinfo"."snap_cohort" FROM "maasserver_controllerinfo" WHERE (("maasserver_controllerinfo"."version" = '3.5.7-16376-g.a0e1cf615' OR "maasserver_controllerinfo"."update_version" = '3.5.7-16376-g.a0e1cf615') AND "maasserver_controllerinfo"."install_type" = 'snap' AND NOT ("maasserver_controllerinfo"."snap_cohort" = ''))
2025-09-08 10:08:04.449 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_notification"."id", "maasserver_notification"."created", "maasserver_notification"."updated", "maasserver_notification"."ident", "maasserver_notification"."user_id", "maasserver_notification"."users", "maasserver_notification"."admins", "maasserver_notification"."message", "maasserver_notification"."context", "maasserver_notification"."category", "maasserver_notification"."dismissable" FROM "maasserver_notification" WHERE "maasserver_notification"."ident" = 'upgrade_status' ORDER BY "maasserver_notification"."id" ASC LIMIT 1
2025-09-08 10:08:04.450 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_controllerinfo"."version", COUNT("maasserver_controllerinfo"."node_id") AS "count" FROM "maasserver_controllerinfo" WHERE NOT ("maasserver_controllerinfo"."version" = '') GROUP BY "maasserver_controllerinfo"."version"
2025-09-08 10:08:04.450 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodeconfig" WHERE "maasserver_nodeconfig"."id" IN (161)
2025-09-08 10:08:04.451 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_scriptset" WHERE "maasserver_scriptset"."id" IN (694)
2025-09-08 10:08:04.452 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_numanode" WHERE "maasserver_numanode"."id" IN (315, 314)
2025-09-08 10:08:04.452 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_node" WHERE "maasserver_node"."id" IN (163)
2025-09-08 10:08:04.455 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_secret" WHERE "maasserver_secret"."path" IN ('node/163/deploy-metadata', 'node/163/power-parameters')
2025-09-08 10:08:04.455 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_numanode"."id" FROM "maasserver_numanode" WHERE "maasserver_numanode"."node_id" IN (163)
2025-09-08 10:08:04.456 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_vlan"."id" FROM "maasserver_vlan" WHERE "maasserver_vlan"."primary_rack_id" IN (163)
2025-09-08 10:08:04.457 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_vlan"."id" FROM "maasserver_vlan" WHERE "maasserver_vlan"."secondary_rack_id" IN (163)
2025-09-08 10:08:04.458 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."parent_id" IN (163)
2025-09-08 10:08:04.459 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_controllerinfo"."created", "maasserver_controllerinfo"."updated", "maasserver_controllerinfo"."node_id", "maasserver_controllerinfo"."version", "maasserver_controllerinfo"."update_version", "maasserver_controllerinfo"."update_origin", "maasserver_controllerinfo"."update_first_reported", "maasserver_controllerinfo"."install_type", "maasserver_controllerinfo"."snap_cohort", "maasserver_controllerinfo"."snap_revision", "maasserver_controllerinfo"."snap_update_revision", "maasserver_controllerinfo"."vault_configured" FROM "maasserver_controllerinfo" WHERE "maasserver_controllerinfo"."node_id" IN (163)
2025-09-08 10:08:04.460 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_dhcpsnippet"."id", "maasserver_dhcpsnippet"."created", "maasserver_dhcpsnippet"."updated", "maasserver_dhcpsnippet"."name", "maasserver_dhcpsnippet"."value_id", "maasserver_dhcpsnippet"."description", "maasserver_dhcpsnippet"."enabled", "maasserver_dhcpsnippet"."node_id", "maasserver_dhcpsnippet"."subnet_id", "maasserver_dhcpsnippet"."iprange_id" FROM "maasserver_dhcpsnippet" WHERE "maasserver_dhcpsnippet"."node_id" IN (163)
2025-09-08 10:08:04.460 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_nodeconfig"."id" FROM "maasserver_nodeconfig" WHERE "maasserver_nodeconfig"."node_id" IN (163)
2025-09-08 10:08:04.461 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_regioncontrollerprocess"."id", "maasserver_regioncontrollerprocess"."created", "maasserver_regioncontrollerprocess"."updated", "maasserver_regioncontrollerprocess"."region_id", "maasserver_regioncontrollerprocess"."pid" FROM "maasserver_regioncontrollerprocess" WHERE "maasserver_regioncontrollerprocess"."region_id" IN (163) ORDER BY "maasserver_regioncontrollerprocess"."pid" ASC
2025-09-08 10:08:04.462 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_regionrackrpcconnection"."id", "maasserver_regionrackrpcconnection"."created", "maasserver_regionrackrpcconnection"."updated", "maasserver_regionrackrpcconnection"."endpoint_id", "maasserver_regionrackrpcconnection"."rack_controller_id" FROM "maasserver_regionrackrpcconnection" WHERE "maasserver_regionrackrpcconnection"."rack_controller_id" IN (163)
2025-09-08 10:08:04.463 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_scriptset"."id" FROM "maasserver_scriptset" WHERE "maasserver_scriptset"."node_id" IN (163)
2025-09-08 10:08:04.463 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: SELECT "maasserver_virtualmachine"."id" FROM "maasserver_virtualmachine" WHERE "maasserver_virtualmachine"."machine_id" IN (163)
2025-09-08 10:08:04.465 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: UPDATE "maasserver_event" SET "node_hostname" = 'ip-10-12-5-3', "node_id" = NULL WHERE "maasserver_event"."node_id" = 163
2025-09-08 10:08:04.466 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_ownerdata" WHERE "maasserver_ownerdata"."node_id" IN (163)
2025-09-08 10:08:04.467 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_service" WHERE "maasserver_service"."node_id" IN (163)
2025-09-08 10:08:04.467 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_node_tags" WHERE "maasserver_node_tags"."node_id" IN (163)
2025-09-08 10:08:04.467 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_podhints_nodes" WHERE "maasserver_podhints_nodes"."node_id" IN (163)
2025-09-08 10:08:04.468 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_bmcroutablerackcontrollerrelationship" WHERE "maasserver_bmcroutablerackcontrollerrelationship"."rack_controller_id" IN (163)
2025-09-08 10:08:04.468 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_bootresourcefilesync" WHERE "maasserver_bootresourcefilesync"."region_id" IN (163)
2025-09-08 10:08:04.468 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodekey" WHERE "maasserver_nodekey"."node_id" IN (163)
2025-09-08 10:08:04.469 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodemetadata" WHERE "maasserver_nodemetadata"."node_id" IN (163)
2025-09-08 10:08:04.469 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_nodeuserdata" WHERE "maasserver_nodeuserdata"."node_id" IN (163)
2025-09-08 10:08:04.469 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_rdns" WHERE "maasserver_rdns"."observer_id" IN (163)
2025-09-08 10:08:04.469 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: DELETE FROM "maasserver_node" WHERE "maasserver_node"."id" IN (163)
2025-09-08 10:08:04.470 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: RELEASE SAVEPOINT "s139744961861184_x17"
2025-09-08 10:08:04.471 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" WHERE "maasserver_node"."system_id" = 'matbts' LIMIT 21
2025-09-08 10:08:04.472 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: 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"."current_release_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" LIMIT 21
2025-09-08 10:08:04.475 UTC [3750088] maas@maas35 maas-regiond-6efxa8 TX:32673200 Qid:0LOG:  statement: ROLLBACK