Page MenuHomeSoftware Heritage
Differential D1324

Use sha1 instead of bigint as FK from origin_visit to snapshot (part 1: add new column)
ClosedPublic
Actions

Authored by vlorentz on Apr 1 2019, 11:51 AM.

Details

Reviewers
olasd
Group Reviewers
Reviewers
Commits
rDSTOCa150fdf05763: Use sha1 instead of bigint as FK from origin_visit to snapshot (part 1: add new…
R65:a150fdf05763: Use sha1 instead of bigint as FK from origin_visit to snapshot (part 1: add new…
rDSTOa150fdf05763: Use sha1 instead of bigint as FK from origin_visit to snapshot (part 1: add new…
Summary

Migration order: run 131.sql then update the storage API

Diff Detail

Repository
rDSTO Storage manager
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.

Event Timeline

vlorentz created this revision.Apr 1 2019, 11:51 AM
swh-public-ci added a comment.Apr 1 2019, 11:57 AM

Build is green
See https://jenkins.softwareheritage.org/job/DSTO/job/tox/246/ for more details.

Harbormaster completed remote builds in B4966: Diff 4203.Apr 1 2019, 11:57 AM
vlorentz added a child revision: D1325: Use sha1 instead of bigint as FK from origin_visit to snapshot (part 2: backfill + start using the new colum for reading + cleanup).Apr 1 2019, 12:01 PM
vlorentz updated this revision to Diff 4207.Apr 1 2019, 1:19 PM

Remove FK constraint

Harbormaster failed remote builds in B4970: Diff 4207!Apr 1 2019, 1:19 PM
swh-public-ci added a comment.Apr 1 2019, 1:19 PM

Build has FAILED

Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tox/250/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tox/250/console

vlorentz updated this revision to Diff 4209.Apr 1 2019, 1:21 PM

rebase

swh-public-ci added a comment.Apr 1 2019, 1:26 PM

Build is green
See https://jenkins.softwareheritage.org/job/DSTO/job/tox/252/ for more details.

Harbormaster completed remote builds in B4972: Diff 4209.Apr 1 2019, 1:26 PM
olasd accepted this revision.Apr 1 2019, 3:04 PM

That commit is missing the increment in the dbversion table.

This revision is now accepted and ready to land.Apr 1 2019, 3:04 PM
vlorentz updated this revision to Diff 4219.Apr 1 2019, 3:17 PM

Increment dbversion in initial schema.

This revision was landed with ongoing or failed builds.Apr 1 2019, 3:17 PM
Closed by commit rDSTOa150fdf05763: Use sha1 instead of bigint as FK from origin_visit to snapshot (part 1: add new… (authored by vlorentz). · Explain Why
This revision was automatically updated to reflect the committed changes.
Harbormaster failed remote builds in B4985: Diff 4219!Apr 1 2019, 3:18 PM
swh-public-ci added a comment.Apr 1 2019, 3:18 PM

Build has FAILED

Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tox/258/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tox/258/console

Revision Contents
Changeset List

PathSize
sql/
upgrades/
10 lines
swh/
storage/
5 lines
sql/
6 lines

Diff 4220

View Options

sql/upgrades/131.sql

Loading...
View Options

swh/storage/db.py

Loading...
View Options

swh/storage/sql/30-swh-schema.sql

Loading...
About · Developer information · Legal