837186 - Critical Datazilla B2G UI Update

Status: RESOLVED FIXED

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

Description

[Jonathan Eads ( :jeads )]

Attachment: A set of sql update statements to back fill new fields

This is a critical update to support the dev team working on gaia/gecko for b2g.  This update modifies the main performance graph to group data by unique combinations of gaia/gecko revisions.  It also separates out data by branch using a new select menu in the UI. These changes require two new fields with indexes on the test_run table in the b2g_perftest_1 database and a back fill to populate the new fields from the json objects stored in the object store.

1.) Run the following alter table statements:
ALTER TABLE `b2g_perftest_1`.`test_run` ADD COLUMN `gecko_revision` VARCHAR(50) NULL DEFAULT NULL  AFTER `status` , ADD COLUMN `build_revision` VARCHAR(50) NULL DEFAULT NULL AFTER `gecko_revision`;

ALTER TABLE `b2g_perftest_1`.`test_run` ADD INDEX `gecko_revision_key` (`gecko_revision` ASC), ADD INDEX `build_revision_key` (`build_revision` ASC);

2.) Execute the attached sql file to backfill the new fields in b2g_perftest_1

It's possible we will receive more data in the interim while we test these changes on stage so step 2 might need to be repeated after we push to production with an updated list of update statements.

Comment 1

[Chris Turra [:cturra]]

dba's - when this is complete, feel free to hit me up so i can push the change to the web application.

Comment 2

[Jonathan Eads ( :jeads )]

dba's any movement on this?

Comment 3

[Corey Shields [:cshields]]

running this down to see what got dropped where.

Comment 4

[Matt Pressman [:mpressman]]

Just got this as critical can I execute this for you?

Comment 5

[Brandon Johnson [:cyborgshadow]]

All done. Sorry for the delay. Note that if you need critical work done you can always have an SRE page us on irc.

Comment 6

[Jonathan Eads ( :jeads )]

Attachment: A set of sql update statements to back fill new fields

Comment 7

[Jonathan Eads ( :jeads )]

The requested alter statements were run but the file of attached sql statements was not.  We have since received more data so I went ahead and updated the attached sql file.

The new changes will not work until the new fields are backfilled.

Please execute update_statements.sql on b2g_perftest_1

Comment 8

[Brandon Johnson [:cyborgshadow]]

All executed.