Page MenuHomeSoftware Heritage
Create Task
Maniphest T2548

Restore CRAN visits deleted in january 2020 from backups
Closed, MigratedEdits Locked
Actions

Description

This script was used in january 2020 to delete all CRAN visits: P585.

This caused some links between origins and snapshots/revisions to be lost, for all packages that had a version removed or were entirely removed from CRAN (see T2536).

It also loses some release history for packages that weren't removed from CRAN (ie. we lost the info they didn't change, or what release they added between visits).

So we should restore these visits from a backup.

Related Objects

Event Timeline

vlorentz triaged this task as Normal priority.Aug 28 2020, 4:06 PM
vlorentz created this task.
vlorentz added a subscriber: ardumont.
vlorentz added a project: System administration.Aug 28 2020, 4:09 PM
vlorentz added a project: Storage manager.
vlorentz raised the priority of this task from Normal to High.Aug 31 2020, 4:37 PM
vlorentz mentioned this in T2536: Investigate CRAN revisions without an origin.
olasd added a subscriber: olasd.Oct 26 2020, 11:44 AM

We don't have database backups going back 10 months (nor 8 months, which was the horizon we would have needed at the time the task was submitted).

However, @ardumont kept the dumps of the tables before dropping the entries: belvedere:~ardumont/cran-origins-to-cleanup-dump-files.tar.gz

If there's some data worth saving in there (AFAIK the format of the snapshots is very wrong, so it's not obvious if there is) we could certainly restore them.

ardumont added a comment.Oct 26 2020, 3:27 PM

And now it's here

cran-origins-to-cleanup-dump-files.tar.gz698 KBDownload
;)

gitlab-migration closed this task as Migrated.Oct 19 2022, 5:57 PM
gitlab-migration claimed this task.
gitlab-migration added a subscriber: gitlab-migration.

This task has been migrated to GitLab.

About · Developer information · Legal