Cannot delete some instances of model 'Domain' because they are referenced through a protected foreign key

[james beedy]

Domain will not delete even when no records exist.

[Andres Rodriguez (andreserl)]

Hi James,

Do you have any rack controller interfaces in this domain? (e.g. a rack controller with the domain in 'example.com').

[Launchpad Janitor (janitor)]

[Expired for MAAS because there has been no activity for 60 days.]

[zw.paper (zw-paper)]

Hi Andres,

I met this error in my env too.

I do not create any rack controller because this is a domain for testing or some internal using.

Here is what I did:
1. Install a MAAS.
2. Create a domain: test.com
3. Create an A record: host.test.com -> 10.10.10.10
4. Delete the A record

Then I can not delete the domain test.com
the same error msg as James.

What I found:
When deleting the record:
1. MAAS deleted the record from maasserver_dnsresource_ip_addresses in PG.
2. There is one more record in maasserver_dnsresource in PG

When I was trying to delete the domain
1. the record in maasserver_dnsresource has the foreign key pointing to maasserver_domain.

[zw.paper (zw-paper)]

by the way, this also happened in MAAS 2.5.0

[Björn Tillenius (bjornt)]

I'm not able to reproduce this as per the step in comment #4 with MAAS 2.7.0. Can you confirm that this is still and issue with 2.7.0 and attach the logs?

[Launchpad Janitor (janitor)]

[Expired for MAAS because there has been no activity for 60 days.]

[Vladimir Grevtsev (vlgrevtsev)]

Reproduced on latest 2.8.2 (8577-g.a3e674063-0ubuntu1~18.04.1) but only via UI - domains/records created with CLI are deleted ok:

<CLI>

ubuntu@OrangeBox84:~$ maas admin domains create name=mydomain
Success.
Machine-readable output follows:
{
    "authoritative": true,
    "ttl": null,
    "name": "mydomain",
    "is_default": false,
    "resource_record_count": 0,
    "id": 4,
    "resource_uri": "/MAAS/api/2.0/domains/4/"
}
ubuntu@OrangeBox84:~$ maas admin dnsresource-records create fqdn=devci.mydomain rrtype=NS rrdata=ns1-devci.maas
Success.
Machine-readable output follows:
{
    "ttl": null,
    "rrtype": "NS",
    "rrdata": "ns1-devci.maas",
    "id": 5,
    "fqdn": "devci.mydomain",
    "resource_uri": "/MAAS/api/2.0/dnsresourcerecords/5/"
}

ubuntu@OrangeBox84:~$ maas admin dnsresource-record delete 5
Success.
Machine-readable output follows:

ubuntu@OrangeBox84:~$ maas admin domain delete 4
Success.
Machine-readable output follows:

ubuntu@OrangeBox84:~$

[Vladimir Grevtsev (vlgrevtsev)]

The same, but via UI raises an error (see attachment).

[Jochen Wezel (jwezel)]

I can confirm the issue still exists at v2.7.3
Same behaviour as Vladimir Grevtsev (vlgrevtsev) wrote on 2020-09-18

I also created these domains using the web UI, created the test entries for a host, removed the host entries and at the end I would like to remove the DNS domain again.

I do not work / test with the maas console.

Requested bug fixes:
1. Fix of this issue so that new new domains can be removed again as in .mov from vlgrevtsev
2. Fix of existing domains that already have this issue of dead foreign key refererences (database repair or whatever it takes to accomplish this task)