Page MenuHomeSoftware Heritage
Create Task
Maniphest T830

Remove tables occurrence and occurrence_history
Closed, MigratedEdits Locked
Actions

Description

The occurrence and occurrence_history tables are a remnant of the pre-snapshot era of the archive.

Most uses of these tables are for backwards-compatibility only.

We should remove them.

Revisions and Commits

rDSTO Storage manager
D535rDSTO435ebcdbf412 Drop table occurrence_history

Related Objects
Search...

Event Timeline

olasd created this task.Nov 5 2017, 9:28 PM
olasd added a parent task: T565: embrace repository snapshot object in the data model (meta task).
olasd renamed this task from Remove table occurrence to Remove tables occurrence and occurrence_history.Oct 3 2018, 12:05 PM
olasd updated the task description. (Show Details)
olasd claimed this task.Oct 3 2018, 12:18 PM
olasd added a subscriber: zack.

There's some work in progress by @zack in branch feature/schema-revamp of rDSTO, I'll pick that up to drive it to completion.

(I'll bite the bullet and work around T1221 for now)

olasd mentioned this in D460: Remove unused function release_get_by.Oct 3 2018, 2:22 PM
olasd mentioned this in rDSTO1751385f076a: Remove unused function release_get_by.Oct 3 2018, 2:55 PM
olasd added a comment.Oct 3 2018, 3:04 PM

All the old visits have now been migrated to snapshots.

olasd mentioned this in D466: Drop backwards-compatibility features between snapshots and occurrences.Oct 3 2018, 5:30 PM
olasd mentioned this in rDSTO5193e6d59017: Drop backwards-compatibility features between snapshots and occurrences.Oct 3 2018, 6:18 PM
olasd added a revision: D535: Drop table occurrence_history.Oct 15 2018, 4:22 PM
olasd closed this task as Resolved by committing rDSTO435ebcdbf412: Drop table occurrence_history.Oct 16 2018, 12:20 PM
olasd added a commit: rDSTO435ebcdbf412: Drop table occurrence_history.
olasd added a comment.Oct 16 2018, 12:21 PM

zack added a comment.Oct 16 2018, 5:34 PM

\o/

olasd added a comment.Oct 19 2018, 11:30 AM

After a few days of rest:

softwareheritage=> begin;
BEGIN
softwareheritage=> drop table occurrence;
DROP TABLE
softwareheritage=> drop table occurrence_history;
DROP TABLE
softwareheritage=> commit;
COMMIT

The tables are still available on the replicas on somerset and azure, until I have the green light that they can be dropped.

gitlab-migration changed the task status from Resolved to Migrated.Jan 8 2023, 9: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