Persona is no longer an option for authentication on BMO. For more details see Persona Deprecated.
Last Comment Bug 538261 - Prod socorro DB, Services, Web deployment
: Prod socorro DB, Services, Web deployment
Product: Infrastructure & Operations
Classification: Other
Component: WebOps: Other (show other bugs)
: other
: All Other
: -- normal (vote)
: ---
Assigned To: server-ops
: matthew zeier [:mrz]
Depends on: 538313
  Show dependency treegraph
Reported: 2010-01-06 14:29 PST by Austin King [:ozten]
Modified: 2013-10-09 10:29 PDT (History)
8 users (show)
See Also:
Due Date:
QA Whiteboard:
Iteration: ---
Points: ---
Cab Review: ServiceNow Change Request (use flag)


Description Austin King [:ozten] 2010-01-06 14:29:36 PST
Socorro 1.3 deployment instructions:
These instructions are an edited version of

This upgrade requires downtime. Please follow typical process (maintenance UI, clear caches when finished, etc)

Push is scheduled for Thursday evening Jan 7th, 2010.

Socorro Server
= Database =

1) ADU
We have a new database table that metrics will populate.
We should create this and start populating ASAP
Doesn't require downtime

Copied from

1.1) A new table has been added for the ADU information. To add it manually, execute this SQL:

CREATE TABLE raw_adu (
    adu_count integer,
    date timestamp without time zone,
    product_name text,
    product_os_platform text,
    product_os_version text,
    product_version text
CREATE INDEX raw_adu_1_idx ON raw_adu (date, 
Grant access from cm-metricsetl01 and cm-metricsetl02.

1.4) Nagios Postgres DB alarm
Create a Nagios check on Take the max value. It should never be more than 48 hours out off from the current time.

2) New index for 'top_crashers_by_signature' table

CREATE INDEX top_crashes_by_signature_window_end_productdims_id_idx on top_crashes_by_signature (window_end desc, productdims_id);

*** New Index for 'build' column on the reports partitions
-- Be on the lookout for a separate IT bug ***

= Services =

3) Deploy AduByDay
3.1) updated to the latest from trunk
3.2) Update config
The string 'adubd.AduByDay?' needs to be added to the 'servicesList' configuration parameter in In addition there needs to be a import for that service.

import as tcbst
import as sighist
import as adubd
servicesList = cm.Option()
servicesList.doc = 'a python list of classes to offer as services'
servicesList.default = [tcbst.TopCrashBySignatureTrends, sighist.SignatureHistory, adubd.AduByDay]

= Processor =
4) Update from trunk
A minor change to the processor will require that it be updated to the latest code from trunk. This change is from Bug 520230 that increased the size of a field in the 'extensions' table.

= Collector =

5) Same as step 4, The collector should have its code updated to the latest from trunk.

Bug 534656 The collector now accepts floating point percentages in the configuration parameter 'throttleConditions'. This will be useful for the anticipated flood when client side throttling changes in FF 3.6.
the Crons

A new configuration parameter called 'truncateUrlLength' has been added to the configuration file ''. Use as a template to add this new parameter. The actual recommended value has yet to be determined.

= Socorro UI =

6) Copy and edit daily.php in order enable ADU.

cp application/config/daily.php-dist application/config/daily.php
Comment 1 K Lars Lohn [:lars] [:klohn] 2010-01-06 14:35:59 PST

3.2 - 'adubd.AduByDay?' should be 'adubd.AduByDay' - a wiki artifact?

4 - drop it, i was never able to get the database change made without disrupting everyone else.  I'll get griswolf to revert the processor source code change
Comment 2 K Lars Lohn [:lars] [:klohn] 2010-01-06 14:50:47 PST
as per my note in Comment #1 regarding 4 - no source checkin reversion is required
Comment 3 Frank Griswold [:griswolf] [:fgriswold] 2010-01-06 17:47:50 PST
The separate IT bug mentioned in #0 2) is Bug 538313
Comment 4 Austin King [:ozten] 2010-01-07 09:20:32 PST
= Crons =
7) Update and configure crons
7.1) Process Bug#537841 for updates to
Comment 5 Austin King [:ozten] 2010-01-07 15:24:18 PST
3.3) Grant Socorro db user/pass read access to raw_adu
Comment 6 Aravind Gottipati [:aravind] 2010-01-07 19:21:25 PST
All done.  Code should sync out to the prod webheads in about 10 minutes.
Comment 7 Austin King [:ozten] 2010-01-07 19:42:05 PST
(In reply to comment #6)
Thanks Aravind. Verified release in prod.

Note You need to log in before you can comment on or make changes to this bug.