<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Dear Ben,</p>
<p>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.</p>
<p>Regards,</p>
<p>James<br>
</p>
<div class="moz-cite-prefix">On 25/08/2020 13:57, Ben Maddison via
DBWG wrote:<br>
</div>
<blockquote type="cite"
cite="mid:20200825095708.ak5np5yhcan6x3xf@benm-laptop">
<pre class="moz-quote-pre" wrap="">Hi James,
On 08/25, James wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">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
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
DBWG mailing list
<a class="moz-txt-link-abbreviated" href="mailto:DBWG@afrinic.net">DBWG@afrinic.net</a>
<a class="moz-txt-link-freetext" href="https://lists.afrinic.net/mailman/listinfo/dbwg">https://lists.afrinic.net/mailman/listinfo/dbwg</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
James Chirwa
Acting Manager, Member Services Department,
AFRINIC Ltd.
t: +230 403 51 00 | f: +230 466 6758 |
tt: @afrinic | w: <a class="moz-txt-link-abbreviated" href="http://www.afrinic.net">www.afrinic.net</a>
SM: facebook.com/afrinic | flickr.com/afrinic | youtube.com/afrinicmedia
____________________________</pre>
</body>
</html>