842859 - Mailing lists mails have got a long delay on them

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[David Weir (satdav)]

the mailing list mails are delayed by about 5 or 6 hours at times or longer

Comment 1

[Michael Burns [:mburns]]

01:16:08 <@mburns   > [[e-mail]1 ~]# mailq | tail -n1
01:16:09 <@mburns   > -- 38615 Kbytes in 12463 Requests.

Comment 2

[Michael Burns [:mburns]]

01:47:21 <limed> the issue is someone tried to mass subscribe as examplecom
01:47:29 <limed> which is why there is so many emails in the queue
01:48:19 <limed> it looks like thre is also a bunch of folks trying to mass subscribed to a bunch of mailing list with random emails btw
01:48:45 <limed> this person is actually trying to do bad stuff

Feb 19 06:54:10 2013 (25683) addons-user-experience: pending "&ping -c 26 127.0.0.1 &" <[e-mail]>  190.179.183.183
Feb 19 06:54:11 2013 (25686) addons-user-experience: pending "\(select convert\(int,CHAR\(95\)+CHAR\(33\)+CHAR\(64\)+CHAR\(50\)+CHAR\(100\)+CHAR\(105\)+CHAR\(108\)+CHAR\(101\)+CHAR\(109\)+CHAR\(109\)+CHAR\(97\)\) FROM syscolumns\)" <[e-mail]> 190.179.183.183

Comment 3

[Ed Lim [:limed]]

Mailq has been purged

[[e-mail]1 ~]# mailq | tail -n1
-- 1776 Kbytes in 95 Requests.

Comment 4

[Michael Burns [:mburns]]

Mailman is still trying to send out a bunch of registration confirmations to a non-existant address. I'm selectively purging from /var/spool/mailman/out/ and the postfix mailq.

In the mean time, mail is still flowing. There should be no legit messages lost during this cleanup.

Comment 5

[Michael Burns [:mburns]]

[[e-mail]1 ~]# mailq | grep "netsparker=example.com" | awk '{print $1}' | postsuper -d -
postsuper: Deleted: 3921 messages

[[e-mail]1 ~]# for file in `find /var/spool/mailman/out/ -name '*.pck'`; 
do
 if /usr/lib/mailman/bin/dumpdb $file | grep "^To: [e-mail]";
 then
  if [ -e $file ];
  then
   rm -f $file;
  fi;
 fi;
done

Comment 6

[David Weir (satdav)]

Can conform its Now working