[DBWG] stale route6 and domain objects for removed inet6num

[James]

Dear Ben,

The integrity checker is within the db schema, though with bugs that led
to these stale records. I notice my previous email might have sounded as
if it's a different tool, but it's not, the issue is more on adjusting
certain parameters, we have already made progress internally and fix
should be in production within the week.

Regards,

James

On 25/08/2020 13:57, Ben Maddison via DBWG wrote:

> Hi James,

>

> On 08/25, James wrote:

>> Hello Frank,

>>

>> We now have the child orphan monitoring tool in place and I can confirm

>> that all orphan objects have been cleaned up, now our focus turns to

>> getting the bug fixes implemented asap.

>>

> That is good news, thanks.

>

> However, I'm confused about the need for a separate tool to scrub the DB

> for issues like this after the fact.

> Is there no referential integrity layer in the database schema itself

> that can enforce these types of rule?

> If there is, surely that is where this should be fixed?

>

> Cheers,

>

> Ben

>

> _______________________________________________

> DBWG mailing list

> DBWG at afrinic.net

> https://lists.afrinic.net/mailman/listinfo/dbwg


-- 
James Chirwa
Acting Manager, Member Services Department,
AFRINIC Ltd.
t: +230 403 51 00 | f: +230 466 6758 |
tt: @afrinic | w: www.afrinic.net
SM: facebook.com/afrinic | flickr.com/afrinic | youtube.com/afrinicmedia
____________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.afrinic.net/pipermail/dbwg/attachments/20200826/9dd9c976/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: OpenPGP digital signature
URL: <https://lists.afrinic.net/pipermail/dbwg/attachments/20200826/9dd9c976/attachment.sig>