Status

Tree Management
Treeherder
P3
normal
RESOLVED FIXED
2 years ago
2 years ago

People

(Reporter: emorley, Assigned: emorley)

Tracking

(Blocks: 1 bug)

Details

Attachments

(1 attachment)

It's not being used for anything.
Created attachment 8670013 [details] [review]
Remove the device table
Attachment #8670013 - Flags: review?(cdawson)

Updated

2 years ago
Attachment #8670013 - Flags: review?(cdawson) → review+

Comment 2

2 years ago
Commit pushed to master at https://github.com/mozilla/treeherder

https://github.com/mozilla/treeherder/commit/4196822599461e73bb3dd481a644c44cffe1cdae
Bug 1211715 - Remove the device table
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → FIXED
Before this is deployed, reference_data_signatures.device_name needs to be given a default (job.device_id already defaults to NULL).

ALTER TABLE treeherder.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL;

Run against Heroku:
16:28:35	ALTER TABLE treeherder.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL	0 row(s) affected Records: 0  Duplicates: 0  Warnings: 0	2.610 sec

Stage:
16:48:02	ALTER TABLE treeherder_stage.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL	0 row(s) affected Records: 0  Duplicates: 0  Warnings: 0	0.156 sec

Prod:
16:51:47	ALTER TABLE treeherder.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL	0 row(s) affected Records: 0  Duplicates: 0  Warnings: 0	3.437 sec


I'll file a separate bug to drop device table, reference_data_signatures.device_name and job.device_id.
Blocks: 1213899
You need to log in before you can comment on or make changes to this bug.