Bug #19890
closed
Use 64-bit id columns to prevent overflow
Description
The default rails ID field is a 32-bit signed int, which overflows after ~2e9 IDs are generated from *_id_sequence.
All id columns should be 64-bit ints.
Updated by Tom Clegg almost 2 years ago
19890-id-bigint @ e219f76f6a8fc11eabb1db7bf0423a0436c40328 -- developer-run-tests: #3434
Is this migration potentially slow enough to merit a mention in the upgrade guide?
Updated by Peter Amstutz almost 2 years ago
User also getting gateway error with user records that had 'id' fields over 2^31
Updated by Brett Smith almost 2 years ago
Tom Clegg wrote in #note-1:
Is this migration potentially slow enough to merit a mention in the upgrade guide?
I vote yes. I think even if it's not relevant for most of our users, highlighting it for those who it might affect is the right call here.
The code in the branch looks good to me.
Updated by Tom Clegg almost 2 years ago
19890-id-bigint @ 0ed815ce9bd5d266808892275d9959546cdd8227
Does this wording look OK?
Slow migration on upgrade¶
This upgrade includes a database schema update (changing an integer column in each table from 32-bit to 64-bit) that may be slow on a large installation. Expect the arvados-api-server package upgrade to take longer than usual.
Updated by Brett Smith almost 2 years ago
Tom Clegg wrote in #note-6:
19890-id-bigint @ 0ed815ce9bd5d266808892275d9959546cdd8227
Does this wording look OK?
Works for me, thanks.
Updated by Tom Clegg almost 2 years ago
- % Done changed from 0 to 100
- Status changed from In Progress to Resolved
Applied in changeset arvados|073cacb8373e770454eb081a1aec39e384681b35.