1211715 - Remove the device table

Status: RESOLVED FIXED

(Tree Management :: Treeherder, defect, P3)

Description

[Ed Morley [:emorley]]

It's not being used for anything.

Comment 1

[Ed Morley [:emorley]]

Attachment: Remove the device table

Comment 2

[Treeherder GitHub Bugbot]

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

https://github.com/mozilla/treeherder/commit/4196822599461e73bb3dd481a644c44cffe1cdae
Bug 1211715 - Remove the device table

Comment 3

[Ed Morley [:emorley]]

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.