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
