Last Comment Bug 565066 - Push Socorro 1.6.3 to prod tonight 5/12/10
: Push Socorro 1.6.3 to prod tonight 5/12/10
05/12/2010 @ 7pm
Product: Infrastructure & Operations
Classification: Other
Component: WebOps: Other (show other bugs)
: other
: All Other
: -- major (vote)
: ---
Assigned To: Aravind Gottipati [:aravind]
: matthew zeier [:mrz]
Depends on: 565590
  Show dependency treegraph
Reported: 2010-05-11 10:12 PDT by Laura Thomson :laura
Modified: 2013-10-09 10:29 PDT (History)
9 users (show)
mzeier: needs‑downtime+
See Also:
Due Date:
QA Whiteboard:
Iteration: ---
Points: ---
Cab Review: ServiceNow Change Request (use flag)

Output from script. (14.46 KB, text/plain)
2010-05-12 20:18 PDT, Aravind Gottipati [:aravind]
no flags Details

Description Laura Thomson :laura 2010-05-11 10:12:21 PDT
The tag is

Instructions at

For items not specifically detailed there, please just update code and restart.
Comment 1 matthew zeier [:mrz] 2010-05-11 11:20:53 PDT
Took a guess at the start time. Need executed duration and a summary of what will be down during this push.
Comment 2 Laura Thomson :laura 2010-05-11 11:23:31 PDT
At least an hour to update the database tables; processors will be down during that time.  

Processors, monitors, cron jobs all require restart.

We agreed to update all components from svn during each release so everything else will be down momentarily during that.
Comment 3 Aravind Gottipati [:aravind] 2010-05-12 19:04:41 PDT
Shut down processors and monitor, updated the db.

breakpad=> alter table reports_20090202 no inherit reports;
breakpad=> alter table reports_20090202
breakpad->   add column process_type TEXT
breakpad-> ;
breakpad=> alter table reports
breakpad->   add column process_type TEXT
breakpad-> ;
breakpad=> alter table reports_20090202 inherit reports;
Comment 4 Aravind Gottipati [:aravind] 2010-05-12 19:06:13 PDT
Code update for socorro cron jobs/scripts.

[root@cm-breakpad02 socorro]# svn switch
U    unittest/cron/
U    unittest/cron/
 U   unittest/cron
U    unittest/database/
 U   unittest/testlib/
 U   unittest/testlib/
 U   unittest/testlib/
 U   unittest/monitor
U    processor/
U    cron/
U    database/
A    database/migrations
A    database/migrations/
Updated to revision 2069.
[root@cm-breakpad02 socorro]# cd ../scripts/
[root@cm-breakpad02 scripts]# svn switch
At revision 2069.
[root@cm-breakpad02 scripts]#
Comment 5 Aravind Gottipati [:aravind] 2010-05-12 19:14:52 PDT
Updated webapp code as well.

[root@mradm02 webapp-php]# svn switch
U    application/models/topcrashers.php
U    application/models/common.php
U    application/controllers/query.php
U    application/controllers/topcrasher.php
U    application/controllers/report.php
U    application/controllers/home.php
U    application/libraries/MY_SearchReportHelper.php
U    application/views/layout.php
 U   application/views/mtbf
U    application/views/common/list_reports.php
U    application/views/common/hang_details.php
U    application/views/common/list_by_signature.php
U    application/views/common/query_form.php
U    application/views/common/list_topcrashers.php
U    css/screen.css
U    js/socorro/nav.js
U    js/socorro/report_list.js
U    js/socorro/topcrash.js
 U   js/socorro
Updated to revision 2069.
[root@mradm02 webapp-php]#

Updated all the processor, monitor as well.  Cron jobs have already been updated (per comment #4).  Waiting on before restarting.
Comment 6 Aravind Gottipati [:aravind] 2010-05-12 20:15:06 PDT
All done, processors and monitor restarted.  I am having some problems attaching stuff the output to firefox in my build.. will try later.  For now, everything should be up and running (cleared NS cache as well).
Comment 7 Aravind Gottipati [:aravind] 2010-05-12 20:18:18 PDT
Created attachment 445043 [details]
Output from script.

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