firefart/network_info

(minor) multiple root nodes of the allocation tree

aaronkaplan opened this issue · 4 comments

aaronkaplan commented

Due to the import of multiple RIR files (afrinic, apnic, ripe, arin) we end up with multiple "root" nodes of the allocation, i.e.: multiple entries of 0.0.0.0/0:

 193.0.0.0/8 | RIPE-CIDR-BLOCK | AU                                | Not allocated by APNIC                               | MAINT-APNIC-AP |         | 2008-09-04 06:51:29 | apnic
 0.0.0.0/0   | IANA-BLK        | EU # Country is really world wide | The whole IPv4 address space                         | AFRINIC-HM-MNT |         |                     | afrinic
 0.0.0.0/0   | IANA-BLOCK      | AU                                | General placeholder reference for all IPv4 addresses | MAINT-APNIC-AP |         | 2008-09-04 06:51:49 | apnic

Proposal: the supplied SELECT statements should either dedup these or... we leave it as is (and every user needs to dedup) or we create a UNIQUE index on block.inetnum..

What's the best way to approach this? As a user of the DB , I would implicitly assume there is only one entry per inetnum and it's assigned to one of the RIRs.

firefart commented

I think I will simply merge the entries and prepend the single fields with the source

aaronkaplan commented

Yes, I think that makes sense. If we still have the tree structure of the assignments / sub-allocations iterable via the DB then that reflects the IP address space. Thanks :)

firefart commented

it looks like there are overlapping netranges too which sucks :/

aaronkaplan commented