If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

[mozillians] re-run geocode migration

VERIFIED FIXED

Status

Infrastructure & Operations Graveyard
WebOps: Engagement
--
major
VERIFIED FIXED
3 years ago
a year ago

People

(Reporter: sancus, Assigned: gozer)

Tracking

Details

(Whiteboard: [kanban:https://kanbanize.com/ctrl_board/4/432] )

Attachments

(1 attachment)

(Reporter)

Description

3 years ago
The mozillians geolocation migration failed on a bunch of profiles that it shouldn't have failed on. I tracked the problem down to an issue with the geodata.json file I uploaded. I'm going to upload a fixed data set in this bug, and the following steps will be needed on prod:

1) Download geocoding.json from this bug.
2) Run ./manage.py loaddata geocoding.json
3) Run the following sql on the database:
UPDATE profile SET geo_country_id=NULL WHERE geo_city_id IS NULL OR geo_region_id IS NULL;
4) Run ./manage.py geocode until it says there are 6 profiles left to geocode.
(Reporter)

Comment 1

3 years ago
Created attachment 8446378 [details]
geocoding.json
(Assignee)

Updated

3 years ago
Whiteboard: [kanban:https://kanbanize.com/ctrl_board/4/432]
(Reporter)

Comment 2

3 years ago
Oops, I forgot to mention a step. Before loading the data, run "truncate geo_geocoding" in the database. The modified steps follow:
1) Download geocoding.json from this bug.
2) Run sql on the db:
TRUNCATE geo_geocoding
3) Run ./manage.py loaddata geocoding.json
4) Run sql on the db:
UPDATE profile SET geo_country_id=NULL WHERE geo_city_id IS NULL OR geo_region_id IS NULL;
5) Run ./manage.py geocode until it says there are 6 profiles left to geocode.

After doing this, https://mozillians.org/en-US/country/United%20States/city/San%20Francisco/ should contain roughly 10 pages of results instead of only a few.
(Reporter)

Updated

3 years ago
Blocks: 1030537
(Assignee)

Updated

3 years ago
Assignee: server-ops-webops → gozer
Status: NEW → ASSIGNED
(Assignee)

Comment 3

3 years ago
6 profiles left to geocode.
Status: ASSIGNED → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
Bumping to QA verified -- results on prod look and behave correctly. Automated tests are passing again.
Status: RESOLVED → VERIFIED
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.