MAAS 3.2.9 creates Calico Interfaces 80.000 fabrics

Discourse
, , , ,
6

Hi,

I found a fix for my system.

WARNING: POTENTIAL SYSTEM DAMAGE
– Use this solution at your own risk. Ensure a backup and understand the commands before executing.

I used pgAdmin to disable the hardware sync flag in the maasserver_node table.
To clear the fabrics and vlan table:

DELETE FROM maasserver_vlan
WHERE maasserver_vlan.id NOT IN (
    SELECT maasserver_vlan.id 
    FROM maasserver_vlan
    LEFT JOIN maasserver_interface ON maasserver_vlan.id = maasserver_interface.vlan_id
    WHERE maasserver_interface.vlan_id IS NOT NULL i 
)
AND maasserver_vlan.id NOT IN (
    SELECT maasserver_vlan.id 
    FROM maasserver_vlan
    JOIN maasserver_subnet ON maasserver_vlan.id = maasserver_subnet.vlan_id
);

DELETE FROM maasserver_fabric
WHERE maasserver_fabric.id NOT IN (
    SELECT maasserver_fabric.id 
    FROM maasserver_fabric
    LEFT JOIN maasserver_vlan ON maasserver_vlan.fabric_id = maasserver_fabric.id
    WHERE maasserver_vlan.fabric_id IS NOT NULL
);

It works for now, but I hope there will be a fix for the problem in the next release.