cleaning up config.pck

Is there a utility / script that will allow me to clean up very large config.pck files? I have a couple lists that receive huge amounts of spam. My problem is the saved bounced information is never removed. I've got a couple config.pck files that are >15M. The size of these files is slowing down the delivery of message as it needs to be read over and over as messages are processed.
-Mike

Mike Cherry wrote:
Is there a utility / script that will allow me to clean up very large config.pck files? I have a couple lists that receive huge amounts of spam. My problem is the saved bounced information is never removed. I've got a couple config.pck files that are >15M. The size of these files is slowing down the delivery of message as it needs to be read over and over as messages are processed.
Are you sure that the issue is saved bounce info? Spam should not cause bounce info to be saved. Unrecognized bounces (spam sent to the list-bounces address) does not store bounce info.
Have you run Mailman's bin/dumpdb on the config.pck files to verify that the size is due to stale bounce info?
If you have a 15MB config.pck, that would be the expected size for a list of some tens of thousands of members. If your list has significantly fewer members than that, then I am really curious to know what is in it.
Anyway, yes there is a script. See <http://www.msapiro.net/scripts/fix_bad_bounce_info.py> (mirrored at <http://fog.ccsf.cc.ca.us/~msapiro/scripts/fix_bad_bounce_info.py>).
This withlist script will remove all bounce info for non-members (there should never be any, but ...) and will also remove stale bounce info for list members. It will not remove non-stale bounce info, and it will not remove bounce info for a member with delivery disabled by bounce, as that is still used to control the notices and eventual removal of the member by cron/disabled.
Let us know how this works for you.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (2)
-
Mark Sapiro
-
Mike Cherry