Closed Bug 650821 Opened 14 years ago Closed 14 years ago

Update addons.mozilla.org on 4/21 @ 1400 (6.0.6)

Categories

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

All
Other
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: clouserw, Assigned: nmaul)

Details

(Whiteboard: [4/21 14:00])

Please update AMO this Thursday. No downtime expected. Note the new time! Instructions forming at http://etherpad.mozilla.org:9000/amo-6-0-6-push
I'd like jakem to drive this.. oremj if you could be available if needed that would be awesome.
Assignee: server-ops → nmaul
Whiteboard: [4/21 14:00]
Whiteboard says 14:00, calendar says 4:00pm (SJC time, aka 16:00). When are we doing this?
(In reply to comment #2) > Whiteboard says 14:00, calendar says 4:00pm (SJC time, aka 16:00). When are we > doing this? Refresh the calendar - it should say 2pm (I changed it this morning)
root@mradm02 ~]# ./bin/zamboni_quick_update.sh 6.0.6 6.0.6 Disable cron? [y/n]: y + update_code + git_checkout_tag 6.0.6 + TAG=6.0.6 + git fetch -t origin remote: Counting objects: 802, done. remote: Compressing objects: 100% (359/359), done. remote: Total 653 (delta 481), reused 418 (delta 270) Receiving objects: 100% (653/653), 161.45 KiB, done. Resolving deltas: 100% (481/481), completed with 95 local objects. From https://github.com/jbalogh/zamboni * [new tag] 6.0.6 -> 6.0.6 + git checkout 6.0.6 Previous HEAD position was 58f1a55... ensure the PERF_THRESHOLD is 25 (the sequel) HEAD is now at 50baacb... Disable rabbit/celery paging + git submodule sync Synchronizing submodule url for 'lib/product_details/json' Synchronizing submodule url for 'media/css/global' Synchronizing submodule url for 'media/js/global' Synchronizing submodule url for 'templates/global' + git submodule update --init + [[ 0 == 1 ]] + [[ ! -z 6.0.6 ]] + pushd vendor + git_checkout_tag 6.0.6 + TAG=6.0.6 + git fetch -t origin remote: Counting objects: 75, done. remote: Compressing objects: 100% (66/66), done. remote: Total 69 (delta 21), reused 0 (delta 0) Unpacking objects: 100% (69/69), done. From git://github.com/jbalogh/zamboni-lib * [new tag] 6.0.6 -> 6.0.6 + git checkout 6.0.6 M src/amo-validator M src/check M src/django-multidb-router M src/django-piston M src/django-queryset-transform M src/easy-thumbnails M src/happyforms M src/hera M src/jingo M src/jingo-minify Previous HEAD position was 8ff76b0... Add in django-quieter-formset for less 500 emails HEAD is now at 70224d8... update jingo + git submodule sync Synchronizing submodule url for 'src/amo-validator' Synchronizing submodule url for 'src/bleach' Synchronizing submodule url for 'src/cache-panel' Synchronizing submodule url for 'src/check' Synchronizing submodule url for 'src/commonware' Synchronizing submodule url for 'src/django' Synchronizing submodule url for 'src/django-cache-machine' Synchronizing submodule url for 'src/django-csp' Synchronizing submodule url for 'src/django-debug-toolbar' Synchronizing submodule url for 'src/django-devserver' Synchronizing submodule url for 'src/django-extensions' Synchronizing submodule url for 'src/django-fixture-magic' Synchronizing submodule url for 'src/django-mobility' Synchronizing submodule url for 'src/django-multidb-router' Synchronizing submodule url for 'src/django-nose' Synchronizing submodule url for 'src/django-piston' Synchronizing submodule url for 'src/django-queryset-transform' Synchronizing submodule url for 'src/django-quieter-formset' Synchronizing submodule url for 'src/django-qunit' Synchronizing submodule url for 'src/django-recaptcha' Synchronizing submodule url for 'src/django-tables' Synchronizing submodule url for 'src/django-waffle' Synchronizing submodule url for 'src/easy-thumbnails' Synchronizing submodule url for 'src/fastchardet' Synchronizing submodule url for 'src/happyforms' Synchronizing submodule url for 'src/hera' Synchronizing submodule url for 'src/jingo' Synchronizing submodule url for 'src/jingo-minify' Synchronizing submodule url for 'src/jstestnetlib' Synchronizing submodule url for 'src/nuggets' Synchronizing submodule url for 'src/pymongo' Synchronizing submodule url for 'src/python-oauth2' Synchronizing submodule url for 'src/redis' Synchronizing submodule url for 'src/schematic' Synchronizing submodule url for 'src/test-utils' Synchronizing submodule url for 'src/tower' + git submodule update --init remote: Counting objects: 477, done. remote: Compressing objects: 100% (118/118), done. remote: Total 369 (delta 294), reused 305 (delta 238) Receiving objects: 100% (369/369), 56.73 KiB, done. Resolving deltas: 100% (294/294), completed with 46 local objects. From git://github.com/mozilla/amo-validator e99145a..6e2e1fd master -> origin/master Submodule path 'src/amo-validator': checked out '198f53d435cc234ed4795ff62cd8f2af4cff1e38' Cloning into src/django-waffle... remote: Counting objects: 371, done. remote: Compressing objects: 100% (350/350), done. Receiving objects: 100% (371/371), 46.01 KiB, done. remote: Total 371 (delta 221), reused 0 (delta 0) Resolving deltas: 100% (221/221), done. Submodule path 'src/django-waffle': checked out 'aabfa34fb00e9cad5eb2b887e6b332a5c733914b' remote: Counting objects: 19, done. remote: Compressing objects: 100% (16/16), done. remote: Total 16 (delta 8), reused 0 (delta 0) Unpacking objects: 100% (16/16), done. From git://github.com/jbalogh/jingo dd3a293..85a0939 master -> origin/master Submodule path 'src/jingo': checked out '85a0939d7f273b0fb910a1e76250cbb8c0b91b8b' remote: Counting objects: 29, done. remote: Compressing objects: 100% (21/21), done. remote: Total 21 (delta 10), reused 0 (delta 0) Unpacking objects: 100% (21/21), done. From git://github.com/jsocol/jingo-minify ce4c3d6..94dc142 master -> origin/master From git://github.com/jsocol/jingo-minify * [new tag] 0.3.2 -> 0.3.2 Submodule path 'src/jingo-minify': checked out 'e386427adee49dedce206811c49b783e11597df1' + [[ 0 == 1 ]] + popd + set +x Update locales? [y/n]: Update locales? [y/n]: y U ku/LC_MESSAGES/javascript.po U ku/LC_MESSAGES/messages.po U sv_SE/LC_MESSAGES/javascript.po U sv_SE/LC_MESSAGES/messages.po U uk/LC_MESSAGES/javascript.po U uk/LC_MESSAGES/messages.po U sq/LC_MESSAGES/messages.mo U sq/LC_MESSAGES/javascript.po U sq/LC_MESSAGES/messages.po U da/LC_MESSAGES/javascript.po U da/LC_MESSAGES/messages.po U sr/LC_MESSAGES/messages.mo U sr/LC_MESSAGES/javascript.po U sr/LC_MESSAGES/messages.po U fa/LC_MESSAGES/javascript.po U fa/LC_MESSAGES/messages.po U bg/LC_MESSAGES/messages.mo U bg/LC_MESSAGES/javascript.po U bg/LC_MESSAGES/messages.po U de/LC_MESSAGES/messages.mo U de/LC_MESSAGES/javascript.po U de/LC_MESSAGES/messages.po U ja/LC_MESSAGES/javascript.po U ja/LC_MESSAGES/messages.po U he/LC_MESSAGES/javascript.po U he/LC_MESSAGES/messages.po U fi/LC_MESSAGES/messages.mo U fi/LC_MESSAGES/javascript.po U fi/LC_MESSAGES/messages.po U es_ES/LC_MESSAGES/messages.mo U es_ES/LC_MESSAGES/javascript.po U es_ES/LC_MESSAGES/messages.po U sr_Latn/LC_MESSAGES/javascript.po U sr_Latn/LC_MESSAGES/messages.po U pt_BR/LC_MESSAGES/javascript.po U pt_BR/LC_MESSAGES/messages.po U fr/pages/compatibility_firstrun.thtml U fr/LC_MESSAGES/messages.mo U fr/LC_MESSAGES/javascript.po U fr/LC_MESSAGES/messages.po U nl/LC_MESSAGES/messages.mo U nl/LC_MESSAGES/javascript.po U nl/LC_MESSAGES/messages.po U hr/LC_MESSAGES/javascript.po U hr/LC_MESSAGES/messages.po U th/LC_MESSAGES/javascript.po U th/LC_MESSAGES/messages.po U pl/LC_MESSAGES/messages.mo U pl/LC_MESSAGES/javascript.po U pl/LC_MESSAGES/messages.po U hu/LC_MESSAGES/messages.mo U hu/LC_MESSAGES/javascript.po U hu/LC_MESSAGES/messages.po U vi/LC_MESSAGES/messages.mo U vi/LC_MESSAGES/javascript.po U vi/LC_MESSAGES/messages.po U ro/LC_MESSAGES/javascript.po U ro/LC_MESSAGES/messages.po U ca/LC_MESSAGES/messages.mo U ca/LC_MESSAGES/javascript.po U ca/LC_MESSAGES/messages.po U tr/LC_MESSAGES/messages.mo U tr/LC_MESSAGES/javascript.po U tr/LC_MESSAGES/messages.po U ru/LC_MESSAGES/messages.mo U ru/LC_MESSAGES/javascript.po U ru/LC_MESSAGES/messages.po U pt_PT/LC_MESSAGES/messages.mo U pt_PT/LC_MESSAGES/javascript.po U pt_PT/LC_MESSAGES/messages.po U af/LC_MESSAGES/javascript.po U af/LC_MESSAGES/messages.po U zh_TW/LC_MESSAGES/messages.mo U zh_TW/LC_MESSAGES/javascript.po U zh_TW/LC_MESSAGES/messages.po U id/LC_MESSAGES/javascript.po U id/LC_MESSAGES/messages.po U templates/LC_MESSAGES/javascript.pot U templates/LC_MESSAGES/messages.pot U el/LC_MESSAGES/messages.mo U el/LC_MESSAGES/javascript.po U el/LC_MESSAGES/messages.po U zh_CN/LC_MESSAGES/javascript.mo U zh_CN/LC_MESSAGES/messages.mo U zh_CN/LC_MESSAGES/javascript.po U zh_CN/LC_MESSAGES/messages.po U ar/LC_MESSAGES/javascript.po U ar/LC_MESSAGES/messages.po U ga_IE/LC_MESSAGES/messages.mo U ga_IE/LC_MESSAGES/javascript.po U ga_IE/LC_MESSAGES/messages.po U cs/LC_MESSAGES/messages.mo U cs/LC_MESSAGES/javascript.po U cs/LC_MESSAGES/messages.po U fy_NL/LC_MESSAGES/javascript.po U fy_NL/LC_MESSAGES/messages.po U ko/LC_MESSAGES/messages.mo U ko/LC_MESSAGES/javascript.po U ko/LC_MESSAGES/messages.po U en_US/LC_MESSAGES/messages.mo U en_US/LC_MESSAGES/javascript.po U en_US/LC_MESSAGES/messages.po U eu/LC_MESSAGES/messages.mo U eu/LC_MESSAGES/javascript.po U eu/LC_MESSAGES/messages.po U mn/LC_MESSAGES/javascript.po U mn/LC_MESSAGES/messages.po U cy/LC_MESSAGES/javascript.po U cy/LC_MESSAGES/messages.po U it/LC_MESSAGES/messages.mo U it/LC_MESSAGES/javascript.po U it/LC_MESSAGES/messages.po U sk/LC_MESSAGES/messages.mo U sk/LC_MESSAGES/javascript.po U sk/LC_MESSAGES/messages.po U sl/LC_MESSAGES/messages.mo U sl/LC_MESSAGES/javascript.po U sl/LC_MESSAGES/messages.po Updated to revision 87664. Compress assets? [y/n]: Compress assets? [y/n]: y Run schematic? [y/n]: y Running migration 177: UPDATE bldetails INNER JOIN blitems ON bldetails.id=blitems.details_id SET bldetails.created=blitems.created; UPDATE bldetails INNER JOIN blplugins ON bldetails.id=blplugins.details_id SET bldetails.created=blplugins.created; UPDATE bldetails INNER JOIN blgfxdrivers ON bldetails.id=blgfxdrivers.details_id SET bldetails.created=blgfxdrivers.created; That took 0.04 seconds ################################################## Running migration 178: CREATE TABLE `waffle_flag` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(100) NOT NULL UNIQUE, `everyone` bool, `percent` numeric(3, 1), `superusers` bool NOT NULL, `staff` bool NOT NULL, `authenticated` bool NOT NULL, `rollout` bool NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `waffle_switch` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(100) NOT NULL UNIQUE, `active` bool NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE TABLE `waffle_flag_groups` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `flag_id` integer NOT NULL, `group_id` integer NOT NULL, UNIQUE (`flag_id`, `group_id`) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE `waffle_flag_groups` ADD CONSTRAINT `group_id_refs_id_4ea49f34` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`); ALTER TABLE `waffle_flag_groups` ADD CONSTRAINT `flag_id_refs_id_8e6a807d` FOREIGN KEY (`flag_id`) REFERENCES `waffle_flag` (`id`); CREATE TABLE `waffle_flag_users` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `flag_id` integer NOT NULL, `user_id` integer NOT NULL, UNIQUE (`flag_id`, `user_id`) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE `waffle_flag_users` ADD CONSTRAINT `user_id_refs_id_bae2dfc2` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`); ALTER TABLE `waffle_flag_users` ADD CONSTRAINT `flag_id_refs_id_8fef0c12` FOREIGN KEY (`flag_id`) REFERENCES `waffle_flag` (`id`); That took 0.70 seconds ################################################## Running migration 179: CREATE TABLE `waffle_sample` ( `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `name` varchar(100) NOT NULL UNIQUE, `percent` numeric(4, 1) NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci; That took 0.13 seconds ################################################## Running migration 180: INSERT INTO `waffle_flag` (name, everyone, percent, superusers, staff, authenticated, rollout) VALUES ('disco-pane-show-recs',0,NULL,1,0,0,0); INSERT INTO `waffle_sample` (name, percent) VALUES ('disco-pane-store-collections','0.0'); That took 0.05 seconds ################################################## Running migration 181: -- Before bug 647769 was fixed, versions for unreviewed addons where -- getting created with NULL nomination dates. CREATE TEMPORARY TABLE versions_fix (nomination DATETIME, addon_id INT(11)) SELECT old_v.nomination, old_v.addon_id FROM versions v JOIN addons a on a.id=v.addon_id JOIN files f on f.version_id=v.id JOIN versions old_v on old_v.addon_id=a.id WHERE a.status IN (3,9) and v.nomination IS NULL and f.status <> 7 and old_v.nomination is not NULL; UPDATE versions v JOIN addons a on a.id=v.addon_id JOIN files f on f.version_id=v.id SET v.nomination = (SELECT nomination FROM versions_fix WHERE addon_id = a.id ORDER BY nomination DESC LIMIT 1) WHERE a.status IN (3,9) and v.nomination is NULL and f.status <> 7; That took 0.12 seconds ################################################## Running migration 182: -- As documented in bug 647769 there are versions with null -- nomination dates. These were fixed in migration 181. -- For some reason there are also orphaned versions that -- do not have a valid nominated version. This fixes those by -- setting their nomination date equal to version creation date. UPDATE addons a JOIN versions v on v.addon_id=a.id LEFT JOIN versions good_v on (good_v.addon_id=a.id and good_v.nomination is not null) JOIN files f on f.version_id=v.id SET v.nomination = v.created -- STATUS_NOMINATED, STATUS_LITE_AND_NOMINATED WHERE a.status in (3,9) AND v.nomination is NULL -- this only fixes the orphans (those without a previously -- nominated version) AND good_v.id is null -- STATUS_BETA AND f.status <> 7; That took 0.04 seconds ################################################## Push live? [y/n]: y Push and restart celeryd? [y/n]: y Push and restart celeryd? [y/n]: y [pm-gearman-amo01] run: /data/bin/libget/get-php5-www-git.sh; service celeryd-prod restart [pm-gearman-amo01] out: Not removing addons.mozilla.org-preview/site/app/locale/sr-Latn/ [pm-gearman-amo01] out: Not removing addons.mozilla.org-remora/site/app/locale/sr-Latn/ [pm-gearman-amo01] out: Not removing services.addons.mozilla.org/site/app/locale/sr-Latn/ [pm-gearman-amo01] out: Restarting celery-prod: celery-prod: stopped [pm-gearman-amo01] out: celery-prod: started [pm-gearman-amo01] out: [ OK ] [pm-gearman-amo02] run: /data/bin/libget/get-php5-www-git.sh; service celeryd-prod restart [pm-gearman-amo02] out: Not removing addons.mozilla.org-preview/site/app/locale/sr-Latn/ [pm-gearman-amo02] out: Not removing addons.mozilla.org-remora/site/app/locale/sr-Latn/ [pm-gearman-amo02] out: Not removing services.addons.mozilla.org/site/app/locale/sr-Latn/ [pm-gearman-amo02] out: Restarting celery-prod: celery-prod: stopped [pm-gearman-amo02] out: celery-prod: started [pm-gearman-amo02] out: [ OK ] [pm-gearman-amo01] run: service celeryd-prod-devhub restart [pm-gearman-amo01] out: Restarting celery-prod-devhub: celery-prod-devhub: stopped [pm-gearman-amo01] out: celery-prod-devhub: started [pm-gearman-amo01] out: [ OK ] [pm-gearman-amo02] run: service celeryd-prod-devhub restart [pm-gearman-amo02] out: Restarting celery-prod-devhub: celery-prod-devhub: stopped [pm-gearman-amo02] out: celery-prod-devhub: started [pm-gearman-amo02] out: [ OK ] [pm-app-amodev01] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amodev01] out: Not removing preview/zamboni/apps/nick/ [pm-app-amodev01] out: Not removing prod/zamboni/apps/nick/ [pm-app-amo24] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo26] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo26] out: Not removing prod/zamboni/apps/nick/ [pm-app-amo15] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo05] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo11] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo18] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo16] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo17] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo10] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo04] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo19] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo07] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo21] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo25] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo12] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo27] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo03] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo20] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo02] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo14] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo13] run: /data/bin/libget/get-php5-www-git.sh [pm-app-amo02] run: apachectl graceful [pm-app-amo03] run: apachectl graceful [pm-app-amo04] run: apachectl graceful [pm-app-amo05] run: apachectl graceful [pm-app-amo07] run: apachectl graceful [pm-app-amo10] run: apachectl graceful [pm-app-amo11] run: apachectl graceful [pm-app-amo12] run: apachectl graceful [pm-app-amo13] run: apachectl graceful [pm-app-amo14] run: apachectl graceful [pm-app-amo15] run: apachectl graceful [pm-app-amo16] run: apachectl graceful [pm-app-amo17] run: apachectl graceful [pm-app-amo18] run: apachectl graceful [pm-app-amo19] run: apachectl graceful [pm-app-amo20] run: apachectl graceful [pm-app-amo21] run: apachectl graceful [pm-app-amo24] run: apachectl graceful [pm-app-amo25] run: apachectl graceful [pm-app-amo26] run: apachectl graceful [pm-app-amo27] run: apachectl graceful [pm-app-amodev01] run: apachectl graceful Clear redis/memcache? [y/n]: n Enable cron? [y/n]: y [root@mradm02 ~]#
Completed.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.