[Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-04-07 Thread Chris Waltham
A couple of weeks ago our Mailman 2.0 server crashed (a physical problem, it wasn't Mailman's fault!) and we had to upgrade to 2.1 in a real hurry. As a result, I had to copy the entire ~mailman/data directory... which may not have been such a good idea: [EMAIL PROTECTED] ~/data]$ ls -al | w

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-04-07 Thread Mark Sapiro
Chris Waltham wrote: >A couple of weeks ago our Mailman 2.0 server crashed (a physical >problem, it wasn't Mailman's fault!) and we had to upgrade to 2.1 in a >real hurry. As a result, I had to copy the entire ~mailman/data >directory... which may not have been such a good idea: > >[EMAIL PR

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-04-08 Thread Chris Waltham
On Apr 7, 2008, at 6:03 PM, Mark Sapiro wrote: > Chris Waltham wrote: > >> A couple of weeks ago our Mailman 2.0 server crashed (a physical >> problem, it wasn't Mailman's fault!) and we had to upgrade to 2.1 >> in a >> real hurry. As a result, I had to copy the entire ~mailman/data >> directory.

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-04-08 Thread Mark Sapiro
Chris Waltham wrote: > >With the exception of 3-4 lists (out of 800+), I let the "make update" >command run so I presume that actually upgraded the lists. I think I >might just delete the holdmsg files en masse, I can't see why >(organizationally) I should need to keep them. When you delete

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-05-07 Thread Chris Waltham
Hi Mark, Just to re-visit this... On Apr 8, 2008, at 1:24 PM, Mark Sapiro wrote: Chris Waltham wrote: With the exception of 3-4 lists (out of 800+), I let the "make update" command run so I presume that actually upgraded the lists. I think I might just delete the holdmsg files en masse, I

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-05-07 Thread Mark Sapiro
Chris Waltham wrote: >Hi Mark, > >Just to re-visit this... > >On Apr 8, 2008, at 1:24 PM, Mark Sapiro wrote: > >> Chris Waltham wrote: >>> >>> With the exception of 3-4 lists (out of 800+), I let the "make >>> update" >>> command run so I presume that actually upgraded the lists. I think I >>> m

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-05-07 Thread Chris Waltham
On May 7, 2008, at 4:07 PM, Mark Sapiro wrote: I looked at my heldmsg files (all 40,000 of them :-)) and there are a number patterns. Most heldmsg files are from a handful of lists (let's call them baseball and football). If I do a dumpdb of the hockey list's pending.pck file, this is the ou

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-05-07 Thread Mark Sapiro
Chris Waltham wrote: >Can you think of an easy way to discard all the messages in >request.pck _except those_ which still have tokens remaining in >pending.pck? If you're willing to accept that the only messages that have unexpired tokens left in pending.pck are those newer than PENDING_REQU

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-05-08 Thread Chris Waltham
On May 7, 2008, at 4:59 PM, Mark Sapiro wrote: Chris Waltham wrote: Can you think of an easy way to discard all the messages in request.pck _except those_ which still have tokens remaining in pending.pck? If you're willing to accept that the only messages that have unexpired tokens left in

Re: [Mailman-Users] Phantom moderation pending requests & heldmsg files

2008-05-08 Thread Chris Waltham
On May 8, 2008, at 10:23 AM, Chris Waltham wrote: On May 7, 2008, at 4:59 PM, Mark Sapiro wrote: Chris Waltham wrote: Can you think of an easy way to discard all the messages in request.pck _except those_ which still have tokens remaining in pending.pck? If you're willing to accept that t