Bug #19890
closed
Use 64-bit id columns to prevent overflow
Added by Tom Clegg almost 2 years ago.
Updated almost 2 years ago.
Release relationship:
Auto
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.
User also getting gateway error with user records that had 'id' fields over 2^31
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.
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.
- % Done changed from 0 to 100
- Status changed from In Progress to Resolved
Also available in: Atom
PDF