829809 - Modify Datazilla B2G Revision Field Size

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Jonathan Eads ( :jeads )]

In preparation for storing B2G test data in datazilla we need to increase the size of the revision field in the database from VARCHAR(16) to VARCHAR(50).  The choice of VARCHAR(16) for the revision size works with the mercurial web services that talos performance test data relies on, which works for all projects except B2G.  B2G (gecko and gaia) utilizes github as the source code repository instead of mercurial.  The github web services that we will need to use in automation require the full 40 char SHA for the revision.

The following github web service call fails if the full SHA is not used:

https://api.github.com/repos/mozilla-b2g/gaia/git/commits/c69d46215195d53c20b777512357982b0b23ac3f

Could someone execute the following alter statements on datazilla-rw-vip.db.scl3.mozilla.com?

USE b2g_perftest_1;
ALTER TABLE `test_run` MODIFY `revision` VARCHAR(50);
ALTER TABLE `metric_threshold` MODIFY `revision` VARCHAR(50);
ALTER TABLE `application_log` MODIFY `revision` VARCHAR(50);
ALTER TABLE `build` MODIFY `revision` VARCHAR(50);

Comment 1

[Sheeri Cabral [:sheeri]]

Done!

mysql> USE b2g_perftest_1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE `test_run` MODIFY `revision` VARCHAR(50);
Query OK, 0 rows affected (0.65 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `metric_threshold` MODIFY `revision` VARCHAR(50);
Query OK, 0 rows affected (0.44 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `application_log` MODIFY `revision` VARCHAR(50);
Query OK, 0 rows affected (0.27 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `build` MODIFY `revision` VARCHAR(50);
Query OK, 0 rows affected (0.31 sec)
Records: 0  Duplicates: 0  Warnings: 0