690032 - add tegras to slavealloc

Status: RESOLVED FIXED

(Release Engineering :: General, defect)

Description

[Mike Taylor [:bear]]

Need to add the tegras to slavealloc so we can start to manage that pool like we do the other slaves

Comment 1

[Mike Taylor [:bear]]

Attachment: tegras insert sql

Comment 2

[Mike Taylor [:bear]]

Comment on attachment 578468 [details]
tegras insert sql

applied to slavealloc's db

Comment 3

[Armen [:armenzg]]

Well, I spent 30-40 minutes making sure that all the values were correct so might as well post the comment.

> insert into slaves set name="tegra-150",distroid=13,bitsid=1,speedid=1,dcid=5,purposeid=4,trustid=5,envid=2,poolid=7,basedir="/builds/",enabled=0;

I see that 11 out of 15 values [1] are set and correctly. (tegra-999,/builds/,linux,32,tests,mtv1,core,mini,prod,tests-mtv1).
locked_masterid, current_masterid, notes and custom_tplid will be NULL which is correct.


##### [1]
mysql> describe slaves;
+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| slaveid          | int(11)      | NO   | PRI | NULL    | auto_increment |
| name             | varchar(128) | NO   | UNI | NULL    |                |
| distroid         | int(11)      | NO   | MUL | NULL    |                |
| bitsid           | int(11)      | NO   | MUL | NULL    |                |
| speedid          | int(11)      | NO   | MUL | NULL    |                |
| purposeid        | int(11)      | NO   | MUL | NULL    |                |
| dcid             | int(11)      | NO   | MUL | NULL    |                |
| trustid          | int(11)      | NO   | MUL | NULL    |                |
| envid            | int(11)      | NO   | MUL | NULL    |                |
| poolid           | int(11)      | NO   | MUL | NULL    |                |
| basedir          | text         | NO   |     | NULL    |                |
| locked_masterid  | int(11)      | YES  | MUL | NULL    |                |
| enabled          | tinyint(1)   | NO   |     | NULL    |                |
| current_masterid | int(11)      | YES  | MUL | NULL    |                |
| notes            | text         | YES  |     | NULL    |                |
| custom_tplid     | int(11)      | YES  |     | NULL    |                |
+------------------+--------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)