Page MenuHomePhabricator

Publish statistics about number of held messages per mailing list (Jan 2021)
Closed, ResolvedPublic

Description

Same as T110609: publish statistics about number of held messages per list but >5y later. At that time, it was:

@sodium:/var/lib/mailman/restore/var/lib/mailman/data# find . | sed -e "s/pck//g" -e "s/[0-9]//g" | sort | uniq -c | sort -nr  | sed -e "s/\.\/heldmsg-//g" -e "s/\.//g" > held_msg_stats_mailman.txt

@sodium:/var/lib/mailman/restore/var/lib/mailman/data# head -n 50 held_msg_stats_mailman.txt

Event Timeline

Aklapper created this task.
Legoktm claimed this task.
Legoktm subscribed.

I ran the same commands, just using /var/lib/mailman/data:

700 wikimedia-in-wb-
689 wikite-l-
256 wikifr-l-
251 wiktionary-l-
237 wikimedia-in-exec-
141 infobg-l-
 77 services-
 63 african-wikimedia-developers-
 59 libref-
 57 best-practices-
 55 audience-research-
 55 affcom-members-
 49 wikija-l-
 48 bilderberg-l-
 47 wikimedia-bd-
 40 wikimedia-ng-
 40 board-nominations-
 30 wikimedia-cm-
 26 wikimedia-mk-
 25 wikimediafr-l-
 25 mediawiki-in-
 24 wikiar-l-
 20 wikiversity-l-
 19 wikimedia-l-
 19 wikimedia-gh-
 15 mediawiki-announce-
 13 openaccess-
 13 betacluster-alerts-
 12 wikimedia-kh-
 12 wikimediabe-l-
 11 wikimedia-us-nyc-discuss-
 11 wikimedia-ec-
 11 ops-
 10 photoreporters-
  9 wikipedia-mai-
  9 wikimedia-us-oh-
  9 wikimedia-in-chn-
  9 /bounce-events-
  8 gendergap-
  7 wikiml-l-
  7 wikimedia-kr-
  7 wikifa-l-
  7 wikibaseug-
  7 unblock-zh-
  7 daily-article-he-
  6 wikimedia-ped-
  6 wikimedia_nyc-
  6 wikimedia-in-mum-
  6 wikimedia-in-blr-
  6 wikimedia-in-amd-

There are 187 lists in total with held messages, please let me know if you'd like the full list.

Thanks. I guess to some extent this issue will become more visible anyway now due to the Mailman3 migration (big big thanks for that).

@Aklapper I don't know why (besides blaming Mailman2) but the numbers I posted above are just wrong. I logged into the mailman@ list just now and it had 1465 held messages. No idea why it didn't show up, but yeah. Given that we didn't copy over pending messages to MM3 everything should be restarting from 0 now.