Merge ~cjwatson/launchpad:db-artifactory-publishing-columns-not-null into launchpad:db-devel
Proposed by
Colin Watson
Status: | Needs review |
---|---|
Proposed branch: | ~cjwatson/launchpad:db-artifactory-publishing-columns-not-null |
Merge into: | launchpad:db-devel |
Diff against target: |
22 lines (+16/-0) 1 file modified
database/schema/patch-2211-08-0.sql (+16/-0) |
Related bugs: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
William Grant | db | Needs Information | |
Review via email: mp+436604@code.qastaging.launchpad.net |
Commit message
Make Artifactory publishing columns non-nullable
Description of the change
The backfill jobs have all finished everywhere now.
To post a comment you must log in.
There was an error fetching revisions from git servers. Please try again in a few minutes. If the problem persists, contact Launchpad support.
Neither SPPH.format nor BPPH.binarypack ageformat are indexed, so this will likely heavily lock the tables for Some Time.
I also forget if `ALTER COLUMN ... SET NOT NULL` will use an index at all.
We have catalog hacked for this sort of thing in the past, but ideally we'd avoid it again.