Push Socorro 1.6.3 to prod tonight 5/12/10

RESOLVED FIXED

Status

Infrastructure & Operations
WebOps: Other
--
major
RESOLVED FIXED
7 years ago
4 years ago

People

(Reporter: laura, Assigned: aravind)

Tracking

other
All
Other
Bug Flags:
needs-downtime +

Details

(Whiteboard: 05/12/2010 @ 7pm)

Attachments

(1 attachment)

(Reporter)

Description

7 years ago
The tag is
http://socorro.googlecode.com/svn/tags/releases/1.6.3_r2051_20100507/

Instructions at 
http://code.google.com/p/socorro/wiki/SocorroUpgrade#Socorro_1.6.3

For items not specifically detailed there, please just update code and restart.

Comment 1

7 years ago
Took a guess at the start time. Need executed duration and a summary of what will be down during this push.
Flags: needs-downtime+
Whiteboard: 05/12/2010 @ 7pm
(Reporter)

Comment 2

7 years ago
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.

Updated

7 years ago
Assignee: server-ops → aravind
Summary: Push Socorro 1.6.3 to prod tonight 5/11/10 → Push Socorro 1.6.3 to prod tonight 5/12/10
(Assignee)

Comment 3

7 years ago
Shut down processors and monitor, updated the db.

breakpad=> alter table reports_20090202 no inherit reports;
ALTER TABLE
breakpad=> alter table reports_20090202
breakpad->   add column process_type TEXT
breakpad-> ;
ALTER TABLE
breakpad=> alter table reports
breakpad->   add column process_type TEXT
breakpad-> ;
ALTER TABLE
breakpad=> alter table reports_20090202 inherit reports;
ALTER TABLE
breakpad=>
(Assignee)

Comment 4

7 years ago
Code update for socorro cron jobs/scripts.

[root@cm-breakpad02 socorro]# svn switch http://socorro.googlecode.com/svn/tags/releases/1.6.3_r2051_20100507/socorro
U    unittest/cron/testBugzilla.py
U    unittest/cron/testDailyUrl.py
 U   unittest/cron
U    unittest/database/testSchemaPartitionedTable.py
 U   unittest/testlib/createJsonDumpStore.py
 U   unittest/testlib/testDB.py
 U   unittest/testlib/loggerForTest.py
 U   unittest/monitor
U    processor/processor.py
U    cron/dailyUrl.py
U    database/schema.py
A    database/migrations
A    database/migrations/migrateProcessType.py
Updated to revision 2069.
[root@cm-breakpad02 socorro]# cd ../scripts/
[root@cm-breakpad02 scripts]# svn switch http://socorro.googlecode.com/svn/tags/releases/1.6.3_r2051_20100507/scripts
At revision 2069.
[root@cm-breakpad02 scripts]#
(Assignee)

Comment 5

7 years ago
Updated webapp code as well.

[root@mradm02 webapp-php]# svn switch http://socorro.googlecode.com/svn/tags/releases/1.6.3_r2051_20100507/webapp-php
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 migrateProcessType.py before restarting.
(Assignee)

Comment 6

7 years ago
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).
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
(Assignee)

Comment 7

7 years ago
Created attachment 445043 [details]
Output from script.
Depends on: 565590
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.