Accidentally unsubscribed everyone from open-glam mailing list
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Scann
	Mar 1 2022, 4:05 PM

Description

I made a very BIG mistake -- I accidentally hit the "unsubscribe all" button on this mailing list: https://lists.wikimedia.org/postorius/lists/open-glam.lists.wikimedia.org/ thinking that since it didn't have any email address on the textbox, it wouldn't unsubscribe anyone. But now I've lost all the members on the list.

Amir is already working on this, but putting this here as his request. Also, per Amir's comment, noting that probably it might be a good idea to make a ticket on mailman about this issue. It's too easy to hit this button by accident.

Event Timeline

Scann created this task.Mar 1 2022, 4:05 PM

Restricted Application added a project: User-Ladsgroup. · View Herald TranscriptMar 1 2022, 4:05 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Scann updated the task description. (Show Details)Mar 1 2022, 4:06 PM

Maintenance_bot added a project: SRE.Mar 1 2022, 4:45 PM

@Scann: Feel free to report to upstream at https://gitlab.com/mailman/mailman/-/issues

Done! https://gitlab.com/mailman/mailman/-/issues/983

Unfortunately, I don't' think I can get it back from the binlog because the removal queries is not like list_id = 'open-glam.lists.wikimedia.org', it removes them one by one and it can get really complicated.

I will ask for a recovery and then we need to run this query on mailman: select email from member join address on address_id = address.id where list_id = 'open-glam.lists.wikimedia.org' and role in (1,2);

jcrespo subscribed.Mar 2 2022, 9:42 AM

I re-added everyone from a backup that was made in 2022-03-01 05:53:07 (so anyone subscribing between that time and the time of removal is not included but that's only a couple of hours). Thanks to @jcrespo for providing the backup.

Maintenance_bot moved this task from Incoming to Done on the User-Ladsgroup board.Mar 2 2022, 11:15 AM

THANK YOU SO MUCH, I can't stress enough how grateful I am for all of you solving this issue in such a timely manner. Here I'm sending you a pic of a local flower as a way to express gratitude for your response.

20210513_passiebloem.JPG (213×320 px, 34 KB)

Source

Glad to be of service ^^

Legoktm awarded a token.Mar 3 2022, 12:47 AM

LSobanski subscribed.Mar 10 2022, 3:22 PM

JJMC89 moved this task from Backlog to List maintenance on the Wikimedia-Mailing-lists board.Feb 20 2024, 8:13 AM

Accidentally unsubscribed everyone from open-glam mailing listClosed, ResolvedPublicActions

Description

Event Timeline

Accidentally unsubscribed everyone from open-glam mailing list
Closed, ResolvedPublic
Actions