Closed
Bug 1100983
Opened 10 years ago
Closed 10 years ago
Add last_modified column to the job table
Categories
(Tree Management :: Treeherder, defect)
Tree Management
Treeherder
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: mdoglio, Assigned: mdoglio)
References
Details
Attachments
(2 files)
The last_modified column should be a timestamp defaulted to CURRENT_TIMESTAMP. The CURRENT_TIMESTAMP should also be used ON UPDATE.
Assignee | ||
Comment 1•10 years ago
|
||
This will require 3 migration steps on dev/stage/prod where:
step 1 will update the schema defaulting the column to NULL and settings the ON UPDATE CURRENT_TIMESTAMP clause
step 2 will set DEFAULT CURRENT_TIMESTAMP
step 3 will set all the NULL values to GREATEST(submit_timestamp, start_timestamp, end_timestamp)
Assignee | ||
Comment 2•10 years ago
|
||
This change will enable the ui to perform requests of increments, reducing the load on both the service and the client
Assignee | ||
Updated•10 years ago
|
Assignee: nobody → mdoglio
Assignee | ||
Updated•10 years ago
|
Status: NEW → ASSIGNED
Assignee | ||
Comment 3•10 years ago
|
||
Attachment #8524707 -
Flags: review?(cdawson)
Updated•10 years ago
|
Attachment #8524707 -
Flags: review?(cdawson) → review+
Comment 4•10 years ago
|
||
Commit pushed to master at https://github.com/mozilla/treeherder-service
https://github.com/mozilla/treeherder-service/commit/c1713cab92e353c12a0288be6b16dc2de141bebe
Bug 1100983 - Add last_modified column
to the job table
Assignee | ||
Comment 5•10 years ago
|
||
Assignee | ||
Comment 6•10 years ago
|
||
I'm going to use attachment 8524765 [details] to migrate dev/stage/prod
Assignee | ||
Comment 7•10 years ago
|
||
I realize we need some support form the dba to apply this change to production. If I do it by hand I think it will result in a huge table lock.
Assignee | ||
Comment 8•10 years ago
|
||
Only prod is missing.
Assignee | ||
Updated•10 years ago
|
Status: ASSIGNED → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•