Thanks. Sounds good to me. Frank
On 24/09/2020 11:14, Simon Seruyinda wrote: > Dear Frank, > > Thank you for pointing this out. We have done some investigation and we found > that the domain objects with the trailing dot were all created in 2005. This > is likely because the old version of the database did not have the syntax > checks that exist now. > The version with the trailing dot stayed in the database because its not > recognised any more by the WHOIS during removal of child objects > These objects currently cannot be queried via port 43 because the WHOIS > automatically removes any trailing dot from the key. Its also not possible > to delete them using the syncupdates for the same reason. We shall therefore > use a Database Migration job to clean them out. > Development on this will begin very soon and we should have them cleaned out > by end of October 2020. > We shall update you incase the timelines change. > > Kind regards; > Simon. > > >> On 13 Sep 2020, at 22:08, Frank Habicht <[email protected]> wrote: >> >> Hi AfriNIC Staff, >> >> We cleaned up all domains objects for non-assigned/non-allocated >> inet[6]num ? >> >> In today's DB dump on FTP I see: >> >> >> domain: 0.216.196.in-addr.arpa. >> descr: --------------------------------- >> descr: Temporarily registered for the >> descr: assignment of a IP addresses >> descr: to be used in the ISOC-ccTLD >> descr: Training : 12-15th Sept 2005 >> descr: --------------------------------- >> org: ORG-KNIC1-AFRINIC >> admin-c: KNIC1-AFRINIC >> tech-c: KNIC1-AFRINIC >> zone-c: KNIC1-AFRINIC >> nserver: noc.cctkd.or.ke >> nserver: a.ns.hopcount.ca >> mnt-by: AFRINIC-HM-MNT >> changed: ***@afrinic.net 20050912 >> source: AFRINIC >> >> and the inetnum doesn't exist. >> >> >> Does this show that the ones ending with 'arpa' were removed and the >> ones ending with 'arpa\.' were not removed? >> >> >> there are many domains duplicated with both versions. >> >> >> Regards, >> Frank >> >> >> [frank@fisi db_2020-09-13]$ egrep >> '^domain.*16.\.2\.196\.in-addr\.arpa\.?$' afrinic.db >> >> domain: 160.2.196.in-addr.arpa. >> domain: 161.2.196.in-addr.arpa. >> domain: 162.2.196.in-addr.arpa. >> domain: 163.2.196.in-addr.arpa. >> domain: 164.2.196.in-addr.arpa. >> domain: 165.2.196.in-addr.arpa. >> domain: 166.2.196.in-addr.arpa. >> domain: 167.2.196.in-addr.arpa. >> domain: 168.2.196.in-addr.arpa. >> domain: 169.2.196.in-addr.arpa. >> domain: 160.2.196.in-addr.arpa >> domain: 161.2.196.in-addr.arpa >> domain: 162.2.196.in-addr.arpa >> domain: 163.2.196.in-addr.arpa >> domain: 164.2.196.in-addr.arpa >> domain: 165.2.196.in-addr.arpa >> domain: 166.2.196.in-addr.arpa >> domain: 167.2.196.in-addr.arpa >> domain: 168.2.196.in-addr.arpa >> domain: 169.2.196.in-addr.arpa >> [frank@fisi db_2020-09-13]$ egrep >> '^domain.*17.\.2\.196\.in-addr\.arpa\.?$' afrinic.db >> >> domain: 170.2.196.in-addr.arpa. >> domain: 171.2.196.in-addr.arpa. >> domain: 172.2.196.in-addr.arpa. >> domain: 173.2.196.in-addr.arpa. >> domain: 174.2.196.in-addr.arpa. >> domain: 175.2.196.in-addr.arpa. >> domain: 176.2.196.in-addr.arpa. >> domain: 177.2.196.in-addr.arpa. >> domain: 178.2.196.in-addr.arpa. >> domain: 179.2.196.in-addr.arpa. >> domain: 170.2.196.in-addr.arpa >> domain: 171.2.196.in-addr.arpa >> domain: 172.2.196.in-addr.arpa >> domain: 173.2.196.in-addr.arpa >> domain: 174.2.196.in-addr.arpa >> domain: 175.2.196.in-addr.arpa >> domain: 176.2.196.in-addr.arpa >> domain: 177.2.196.in-addr.arpa >> domain: 178.2.196.in-addr.arpa >> domain: 179.2.196.in-addr.arpa >> [frank@fisi db_2020-09-13]$ egrep >> '^domain.*18.\.2\.196\.in-addr\.arpa\.?$' afrinic.db >> >> domain: 180.2.196.in-addr.arpa. >> domain: 181.2.196.in-addr.arpa. >> domain: 182.2.196.in-addr.arpa. >> domain: 183.2.196.in-addr.arpa. >> domain: 184.2.196.in-addr.arpa. >> domain: 185.2.196.in-addr.arpa. >> domain: 186.2.196.in-addr.arpa. >> domain: 187.2.196.in-addr.arpa. >> domain: 188.2.196.in-addr.arpa. >> domain: 189.2.196.in-addr.arpa. >> domain: 180.2.196.in-addr.arpa >> domain: 181.2.196.in-addr.arpa >> domain: 182.2.196.in-addr.arpa >> domain: 183.2.196.in-addr.arpa >> domain: 184.2.196.in-addr.arpa >> domain: 185.2.196.in-addr.arpa >> domain: 186.2.196.in-addr.arpa >> domain: 187.2.196.in-addr.arpa >> domain: 188.2.196.in-addr.arpa >> domain: 189.2.196.in-addr.arpa >> [frank@fisi db_2020-09-13]$ >> >> >> >> $ egrep '^domain.*arpa\.$' afrinic.db >> >> domain: 160.2.196.in-addr.arpa. >> domain: 161.2.196.in-addr.arpa. >> domain: 162.2.196.in-addr.arpa. >> domain: 163.2.196.in-addr.arpa. >> domain: 164.2.196.in-addr.arpa. >> domain: 165.2.196.in-addr.arpa. >> domain: 166.2.196.in-addr.arpa. >> domain: 167.2.196.in-addr.arpa. >> domain: 168.2.196.in-addr.arpa. >> domain: 169.2.196.in-addr.arpa. >> domain: 170.2.196.in-addr.arpa. >> domain: 171.2.196.in-addr.arpa. >> domain: 172.2.196.in-addr.arpa. >> domain: 173.2.196.in-addr.arpa. >> domain: 174.2.196.in-addr.arpa. >> domain: 175.2.196.in-addr.arpa. >> domain: 176.2.196.in-addr.arpa. >> domain: 177.2.196.in-addr.arpa. >> domain: 178.2.196.in-addr.arpa. >> domain: 179.2.196.in-addr.arpa. >> domain: 180.2.196.in-addr.arpa. >> domain: 181.2.196.in-addr.arpa. >> domain: 182.2.196.in-addr.arpa. >> domain: 183.2.196.in-addr.arpa. >> domain: 184.2.196.in-addr.arpa. >> domain: 185.2.196.in-addr.arpa. >> domain: 186.2.196.in-addr.arpa. >> domain: 187.2.196.in-addr.arpa. >> domain: 188.2.196.in-addr.arpa. >> domain: 189.2.196.in-addr.arpa. >> domain: 190.2.196.in-addr.arpa. >> domain: 191.2.196.in-addr.arpa. >> domain: 159.0.212.in-addr.arpa. >> domain: 158.0.212.in-addr.arpa. >> domain: 148.0.212.in-addr.arpa. >> domain: 128.0.212.in-addr.arpa. >> domain: 129.0.212.in-addr.arpa. >> domain: 144.202.196.in-addr.arpa. >> domain: 145.202.196.in-addr.arpa. >> domain: 138.0.212.in-addr.arpa. >> domain: 0.216.196.in-addr.arpa. >> domain: 146.0.212.in-addr.arpa. >> domain: 196.163.in-addr.arpa. >> >> >> _______________________________________________ >> DBWG mailing list >> [email protected] >> https://lists.afrinic.net/mailman/listinfo/dbwg > _______________________________________________ DBWG mailing list [email protected] https://lists.afrinic.net/mailman/listinfo/dbwg
