Clean up unreferenced maintainers (after 90 days)
Dear Working Group, In the light of data protection we already clean up unreferenced organisation, person and role objects, and also mntner-role and mntner-person pairs, 90 days after such objects become unreferenced. So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused. Please let us know if you see any issues with this. Kind regards, Tim Bruijnzeels Assistant Manager Software Engineering and Senior Technology Officer RIPE NCC
Tim Bruijnzeels via db-wg wrote:
So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused.
Please let us know if you see any issues with this.
Garbage collection is important. Please fix. Nick
+1 If they are unreferenced/unused, it's positive to clean up. Cheers, Carlos On Sun, 12 Nov 2017, Nick Hilliard via db-wg wrote:
Tim Bruijnzeels via db-wg wrote:
So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused.
Please let us know if you see any issues with this.
Garbage collection is important. Please fix.
Nick
+1 Should have been implemented long ago in my opinion. Christoffer On 12 November 2017 at 07:12, Tim Bruijnzeels via db-wg <db-wg@ripe.net> wrote:
Dear Working Group,
In the light of data protection we already clean up unreferenced organisation, person and role objects, and also mntner-role and mntner-person pairs, 90 days after such objects become unreferenced.
So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused.
Please let us know if you see any issues with this.
Kind regards,
Tim Bruijnzeels Assistant Manager Software Engineering and Senior Technology Officer RIPE NCC
Hi all Several years ago we did look at deleting not only individual objects or pairs, but whole clusters of objects (PERSON, ROLE, MNTNER, ORGANISATION (org-type: other), KEY-CERT) if non of these objects in a cluster were referenced by any operational objects. It is easy to build up a collection of objects now that will never be deleted, but which serve no useful purpose in the database. Personally I think it is time to take a more serious look at cleaning out any data that has no reason to be there. cheersdenisco-chair DB WG From: Christoffer Dam Hansen via db-wg <db-wg@ripe.net> To: Tim Bruijnzeels <tim@ripe.net> Cc: Database WG <db-wg@ripe.net> Sent: Sunday, 12 November 2017, 21:01 Subject: Re: [db-wg] Clean up unreferenced maintainers (after 90 days) +1 Should have been implemented long ago in my opinion. Christoffer On 12 November 2017 at 07:12, Tim Bruijnzeels via db-wg <db-wg@ripe.net> wrote: Dear Working Group, In the light of data protection we already clean up unreferenced organisation, person and role objects, and also mntner-role and mntner-person pairs, 90 days after such objects become unreferenced. So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused. Please let us know if you see any issues with this. Kind regards, Tim Bruijnzeels Assistant Manager Software Engineering and Senior Technology Officer RIPE NCC
denis walker via db-wg wrote:
Several years ago we did look at deleting not only individual objects or pairs, but whole clusters of objects (PERSON, ROLE, MNTNER, ORGANISATION (org-type: other), KEY-CERT) if non of these objects in a cluster were referenced by any operational objects. It is easy to build up a collection of objects now that will never be deleted, but which serve no useful purpose in the database.
Personally I think it is time to take a more serious look at cleaning out any data that has no reason to be there.
I would be in favour of seeing this done. The less fossilized detritus in the database, the better. Nick
Dear Working Group, thank you for your feedback, we have now started to also delete unreferenced maintainer (mntner) objects. Regards Ed Shryane RIPE NCC
On 12 Nov 2017, at 07:12, Tim Bruijnzeels via db-wg <db-wg@ripe.net> wrote:
Dear Working Group,
In the light of data protection we already clean up unreferenced organisation, person and role objects, and also mntner-role and mntner-person pairs, 90 days after such objects become unreferenced.
So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused.
Please let us know if you see any issues with this.
Kind regards,
Tim Bruijnzeels Assistant Manager Software Engineering and Senior Technology Officer RIPE NCC
Thanks for letting us know Ed cheersdenisco-chair DB-WG From: Edward Shryane via db-wg <db-wg@ripe.net> To: Database WG <db-wg@ripe.net> Sent: Thursday, 15 February 2018, 10:13 Subject: Re: [db-wg] Clean up unreferenced maintainers (after 90 days) Dear Working Group, thank you for your feedback, we have now started to also delete unreferenced maintainer (mntner) objects. Regards Ed Shryane RIPE NCC
On 12 Nov 2017, at 07:12, Tim Bruijnzeels via db-wg <db-wg@ripe.net> wrote:
Dear Working Group,
In the light of data protection we already clean up unreferenced organisation, person and role objects, and also mntner-role and mntner-person pairs, 90 days after such objects become unreferenced.
So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused.
Please let us know if you see any issues with this.
Kind regards,
Tim Bruijnzeels Assistant Manager Software Engineering and Senior Technology Officer RIPE NCC
Always looking forward to have a cleaner and up-to-date rir database than yesterday. Thx for the update! Christoffer Dam Hansen netravnen@gmail.com about.me/netravnen On 15 February 2018 at 19:22, denis walker via db-wg <db-wg@ripe.net> wrote:
Thanks for letting us know Ed
cheers denis co-chair DB-WG
________________________________ From: Edward Shryane via db-wg <db-wg@ripe.net> To: Database WG <db-wg@ripe.net> Sent: Thursday, 15 February 2018, 10:13 Subject: Re: [db-wg] Clean up unreferenced maintainers (after 90 days)
Dear Working Group,
thank you for your feedback, we have now started to also delete unreferenced maintainer (mntner) objects.
Regards Ed Shryane RIPE NCC
On 12 Nov 2017, at 07:12, Tim Bruijnzeels via db-wg <db-wg@ripe.net> wrote:
Dear Working Group,
In the light of data protection we already clean up unreferenced organisation, person and role objects, and also mntner-role and mntner-person pairs, 90 days after such objects become unreferenced.
So-far unreferenced maintainers are not cleaned up. We have about 8k such objects in the database. These objects are often syntactically incorrect and poorly maintained - so we would like to clean them up automatically 90 days after they become unused.
Please let us know if you see any issues with this.
Kind regards,
Tim Bruijnzeels Assistant Manager Software Engineering and Senior Technology Officer RIPE NCC
participants (6)
-
Carlos Friaças -
Christoffer Dam Hansen -
denis walker -
Edward Shryane -
Nick Hilliard -
Tim Bruijnzeels