654921 - Upgrade production BMO to current-staging

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: General, defect)

Description

[:glob ✱]

There's a reasonable amount of changes to bmo/4.0 between production and what's currently on staging; we need to schedule an upgrade to production.

Due to bug 652400, immediately after the code has been updated, the following script needs to be run:

  extensions/ComponentWatching/reset-watch-preferences.pl

Comment 1

[Dave Miller [:justdave]]

What happens if I don't run that script?  What happens while the script is running?  (Does it make schema changes?  Will it run reasonably quick without interrupting site usability if we do a live update?)

Comment 2

[:glob ✱]

(In reply to comment #1)
> What happens if I don't run that script?
> What happens while the script is running?  (Does it make schema changes?
> Will it run reasonably quick without interrupting site usability if we do 
> a live update?)

it doesn't make any schema changes.

current component watchers have entries in the email_setting table which are technically invalid.  prior to this update, they were ignored so the issue was masked.

if the script isn't run, anyone with component watching currently configured will stop receiving emails until they manually update their preferences.

for all users who have manually configured component watching, all component watching entries in email_setting are removed, and rows relating to the default values are inserted.

the time this will take depends on the number of rows returned by:
  SELECT DISTINCT user_id FROM component_watch

i am expecting the script to execute quickly.

all database changes made by the script are wrapped in a single transaction.

Comment 3

[Dave Miller [:justdave]]

[root@ip-admin02 bugzilla.mozilla.org]# sh bzr-update.sh 
+ bzr pull --overwrite -rtag:current-production
+N  extensions/BMO/template/en/default/bug/create/create-mozreps.html.tmpl
+N  extensions/ComponentWatching/reset-watch-preferences.pl
+N  extensions/ComponentWatching/template/en/default/hook/account/prefs/email-relationships.html.tmpl
+N  extensions/Splinter/template/en/default/hook/attachment/edit-action.html.tmpl
+N  skins/custom/search_form.css
 M  Bugzilla/CGI.pm
 M  Bugzilla/Constants.pm
 M  Bugzilla/User.pm
 M  extensions/BMO/Extension.pm
 M  extensions/BMO/lib/Data.pm
 M  extensions/BMO/template/en/default/global/choose-product.html.tmpl
 M  extensions/BMO/template/en/default/hook/global/header-additional_header.html.tmpl
 M  extensions/ComponentWatching/Extension.pm
 M  extensions/ComponentWatching/template/en/default/hook/global/reason-descs-end.none.tmpl
 M  extensions/Splinter/template/en/default/hook/attachment/list-action.html.tmpl
 M  extensions/Splinter/template/en/default/pages/splinter.html.tmpl
 M  extensions/Splinter/web/splinter.js
 M  js/comments.js
 M  skins/standard/IE-fixes.css
 M  skins/standard/attachment.css
 M  skins/standard/global.css
 M  template/en/default/attachment/edit.html.tmpl
 M  template/en/default/attachment/midair.html.tmpl
 M  template/en/default/bug/comments.html.tmpl
 M  template/en/default/bug/create/create-guided.html.tmpl
 M  template/en/default/bug/edit.html.tmpl
 M  template/en/default/bug/field.html.tmpl
 M  template/en/default/bug/process/midair.html.tmpl
 M  template/en/default/global/header.html.tmpl
 M  template/en/default/pages/linked.html.tmpl
 M  template/en/default/search/field.html.tmpl
All changes applied successfully.
Using saved parent location: bzr://bzr.mozilla.org/bmo/4.0/
Now on revision 7675.
Fixing file permissions...
[root@ip-admin02 bugzilla.mozilla.org]# extensions/ComponentWatching/reset-watch-preferences.pl
This script resets the component watching preferences back to
default values.  It is required to be run when upgrading from
version 1.0 to 1.1
Press <ENTER> to start, or CTRL+C to cancel... 

.0/53 (0%)
....................................................Done.
[root@ip-admin02 bugzilla.mozilla.org]# push-bugzilla