[DBWG] stale route6 and domain objects for removed inet6num

James james.chirwa at afrinic.net
Wed Aug 26 03:57:13 UTC 2020

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.



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,
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>

More information about the DBWG mailing list