514755 - Push SUMO 1.3 to production on Thursday September 10th 2009

Status: VERIFIED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Laura Thomson :laura]

Tag is here:
http://svn.mozilla.org/projects/sumo/tags/1.3/1.3_20090904_r50928/

There are quite a few other changes to make during the push window - Paul and James will provide details.

Comment 1

[Derek Moore [:dmoore]]

Are the additional changes a prerequisite for this update? Should we still proceed without them?

Comment 2

[Laura Thomson :laura]

They are needed - here they are.  Bugs have SQL files and/or config details.

SQL Patches (to be done by IT)
Bug 511542 - Post titles need to be updated for bug 505652
Bug 511952 - Hard coded "firefox" instances -- see comment 5
Bug 460220 - Integrate new sumo search admin -- 2 SQL patches!!
Bug 498678 - Periods (.) should be acceptable in article titles
Bug 511250 - Attachment 395676 [details] can run, needs the database connection info, or 395874 can generate the SQL later


Prefs to enable/configure 
Bug 487598 - Localized articles should inherit en-us page categories -- pref
Bug 498001 - Improve UI and feedback for watching categories to say you'll be e-mailed and offer easy way to turn off -- content label
Bug 504603 - Investigate if 'This answer solved my problem' feature is p10n compatible -- pref
Bug 460253 - Allow new articles to be renamed by anyone until they're first published -- pref
Bug 502025 - Create and implement modules on the sidebar template for the new start page -- create sidebar modules
Bug 492585 - Set margins on Thunderbird module -- update content label
Bug 511986 - Move minify's $config into a config file -- create config file
Bug 502092 - [Productization] Create admin preference to enable/disable minify  -- allow read/write permissions to files/minify.conf + pref
Bug 498056 - Force non-KB articles to have a category -- pref
Bug 465029 - Warn when creating articles with bad characters -- pref
Bug 511699 - Make SHOWFOR configurable -- create config file

Check:
Bug 502245 - Move memcache configuration to an administrative panel -- check memcache is on
Bug 511952 - Hard coded "firefox" instances -- regressions from removing a whole lib
Bug 476546 - SVN-remove /sumo/trunk/webroot/language_files/langmapping.php -- regressions from removing a whole directory

Comment 3

[Paul Craciunoiu [:paulc]]

We've had issues with minify.conf on stage in bug 513413
The web server needs to have permissions to write to and read from webroot/files/minify.conf

Comment 4

[Paul Craciunoiu [:paulc]]

Here's a short outline of the SQL patches:

These need to run _BEFORE_ the push
Bug 460220 - Integrate new sumo search admin -- 2 SQL patches!!
Bug 498678 - Periods (.) should be acceptable in article titles

The rest need to run _AFTER_
For db consistency, it's important to run those after.

Comment 5

[Derek Moore [:dmoore]]

pre-push SQL from 460220 executed successfully

Comment 6

[Derek Moore [:dmoore]]

SQL from 498678 executed successfully

Comment 7

[Laura Thomson :laura]

Roll back please, we have a regression identical to https://bugzilla.mozilla.org/show_bug.cgi?id=513823 showing up.  The SQL changes shouldn't matter.

We just need to go back to the old tag and dump cache, will fix our stuff and try again likely Thursday.

Old tag was I believe
https://svn.mozilla.org/projects/sumo/tags/1.2/1.2.1_20090729_r48039/

Comment 8

[Derek Moore [:dmoore]]

Reverted as requested

Comment 9

[Laura Thomson :laura]

New tag will be forthcoming today.  Waiting on bug 515517 before tagging.

Comment 10

[Laura Thomson :laura]

New tag:
https://bugzilla.mozilla.org/show_bug.cgi?id=515517

Comment 11

[Laura Thomson :laura]

Let me try that again
https://svn.mozilla.org/projects/sumo/tags/1.3/1.3_20090910_r51251/

Comment 12

[Derek Moore [:dmoore]]

switched and pushed

post-push SQL from 460220 executed successfully

Comment 13

[Derek Moore [:dmoore]]

SQL from 511952 executed successfully

Comment 14

[Derek Moore [:dmoore]]

Production SQL from 511452 generated after minor modifications, 23244 rows modified.

Comment 15

[Derek Moore [:dmoore]]

Production SQL from 511250 generated, 134763 update statements executed.

Comment 16

[Stephen Donner [:stephend] Not actively reading bugmail]

Derek: anything left to do here on your end?

Comment 17

[Stephen Donner [:stephend] Not actively reading bugmail]

Thanks -- verified FIXED; we ran all our Selenium (http://viewvc.svn.mozilla.org/vc/projects/sumo/trunk/tests/frontend/), as well as tested 10 or so of the most-important bugs on production.