bugzilla.mozilla.org has resumed normal operation. Attachments prior to 2014 will be unavailable for a few days. This is tracked in Bug 1475801.
Please report any other irregularities here.

Mozpool request id field should be BIGINT

RESOLVED FIXED

Status

Testing Graveyard
Mozpool
RESOLVED FIXED
6 years ago
2 years ago

People

(Reporter: jhopkins, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
I noticed the Mozpool request id field is type INTEGER.

Since we're going to handle tons of requests over the lifetime of this system, I think we should change the data type of that field to BIGINT to avoid an overflow in the future.

Comment 1

6 years ago
Ran into a slight problem, in that sqlite has issues with bigint as a primary key (or at least as autoincrement). Got errors about having to specify the request id when adding to the table. Fixed by leaving the model as is but changing the schema to bigint. Dustin assures me that the fact that it's specified as Integer in the model won't affect anything; sqlalchemy won't enforce size limits.

Code has been pushed; just need to update the prod db.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
(Assignee)

Updated

2 years ago
Product: Testing → Testing Graveyard
You need to log in before you can comment on or make changes to this bug.