Status

RESOLVED FIXED
10 years ago
5 years ago

People

(Reporter: wenzel, Assigned: oremj)

Tracking

Details

(Reporter)

Description

10 years ago
Please execute the SQL from attachment 341269 [details] on prod. AMO's database at your earliest convenience.

It makes the necessary schema changes that should have been executed before the code from bug 432614 was pushed live.

Currently, the out-of-date schema keeps the user deletion feature from working.

-- User impact: As it's a schema change (allow NULL in the email field), the user table will be write locked while that's running. On preview (bug 458380) it took about 1.5 minutes.

CCing morgamic for approval.
a=morgamic
(Assignee)

Updated

10 years ago
Assignee: server-ops → oremj
(Assignee)

Comment 2

10 years ago
mysql> ALTER TABLE `users` CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
Query OK, 2927915 rows affected (2 min 58.77 sec)
Records: 2927915  Duplicates: 0  Warnings: 0
Status: NEW → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → FIXED
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.