Re: [Mailman-Users] MemoryError in htmlformat.py
What version of Mailman are you using? (it looks like one of the 2.1.x versions). Hope you have already fixed this by now, but just in case, here is something you can try. Look in the data directory for Mailman - this is where the held messages are stored. You can actually scan the heldmsg files manually and delete ones that might be overly large. cd /usr/local/mailman/data ls -l The default message format in version 2.1 is pickle (instead of text), but you can still easily look at each held message by using the strings command (strings is a utility that used to be loaded by default, if you don't have it loaded it's very easy to find). strings heldmsg-b2b-list-1.pck Deleting the heldmsg's here does not delete them from your lists request.db file, but when you run admindb for the list, that will compare the heldmsg files to the ones in request.db and then update request.db (the handling of the request.db file is a lot smarter in version 2.1 of Mailman). In other words,once you launch the Web-admindb everything should sync up and you will just see the messages you left that need approving. It *should* work at this point. assuming that problem was a bad email and you deleted the bad email If not, I recommend removing that lists request.db file: /usr/local/mailman/lists/b2b-list/request.db Just rename the file to something else and then try launching the web-admindb again. Good Luck - Jon Carnes == On Wed, 2003-02-19 at 05:14, Stephan Spencer wrote: This one is out of my depth. The Tend to Pending Moderator Requests page has become inaccessible due to a MemoryError. The traceback follows below. Any guidance would be greatly appreciated. (The list in question is gated to the moderated Usenet newsgroup rec.travel.bed+breakfast, so it gets a lot of incoming spam. Not sure if that has anything to do with the problem at hand, however.). Thanks! Traceback (most recent call last): File /usr/local/mailman/scripts/driver, line 87, in run_main main() File /usr/local/mailman/Mailman/Cgi/admindb.py, line 236, in main print doc.Format() File /usr/local/mailman/Mailman/htmlformat.py, line 331, in Format output.append(Container.Format(self, indent)) File /usr/local/mailman/Mailman/htmlformat.py, line 264, in Format output.append(HTMLFormatObject(item, indent)) File /usr/local/mailman/Mailman/htmlformat.py, line 50, in HTMLFormatObject return item.Format(indent) File /usr/local/mailman/Mailman/htmlformat.py, line 417, in Format output = output + Container.Format(self, indent+2) File /usr/local/mailman/Mailman/htmlformat.py, line 264, in Format output.append(HTMLFormatObject(item, indent)) File /usr/local/mailman/Mailman/htmlformat.py, line 50, in HTMLFormatObject return item.Format(indent) File /usr/local/mailman/Mailman/htmlformat.py, line 200, in Format output = output + self.FormatRow(i, indent + 2) MemoryError Python information: Variable Value sys.version 2.2.2 (#1, Jan 14 2003, 02:49:11) [GCC 2.96 2731 (Red Hat Linux 7.1 2.96-98)] sys.executable /usr/local/bin/python sys.prefix /usr/local sys.exec_prefix /usr/local sys.path /usr/local sys.platform linux2 Environment variables: Variable Value PATH_INFO /bnb-list HTTP_ACCEPT */* CONTENT_TYPE application/x-www-form-urlencoded HTTP_REFERER http://www.innsite.com/mailman/admindb/bnb-list SERVER_SOFTWARE Apache/1.3.26 (Unix) PHP/4.2.3 PYTHONPATH /usr/local/mailman SCRIPT_FILENAME /usr/local/mailman/cgi-bin/admindb SERVER_ADMIN [EMAIL PROTECTED] SCRIPT_NAME /mailman/admindb SCRIPT_URI http://www.innsite.com/mailman/admindb/bnb-list SERVER_SIGNATURE Apache/1.3.26 Server at www.innsite.com Port 80 REQUEST_METHOD POST HTTP_HOST www.innsite.com SCRIPT_URL /mailman/admindb/bnb-list SERVER_PROTOCOL HTTP/1.0 QUERY_STRING REQUEST_URI /mailman/admindb/bnb-list CONTENT_LENGTH 35 PATH_TRANSLATED /www/data/innsite/bnb-list HTTP_USER_AGENT Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-us) AppleWebKit/48 (like Gecko) Safari/48 HTTP_CONNECTION close HTTP_COOKIE Apache=219.88.207.149.5151045648465275 SERVER_NAME www.innsite.com REMOTE_ADDR 219.88.207.149 REMOTE_PORT 49346 HTTP_ACCEPT_LANGUAGE en-us, ja;q=0.33, en;q=0.67 SERVER_ADDR 66.250.38.164 SERVER_PORT 80 GATEWAY_INTERFACE CGI/1.1 UNIQUE_ID PlNUVkL6JqQAAAICmwI DOCUMENT_ROOT /www/data/innsite -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/jonc%40nc.rr.com
Re: [Mailman-Users] MemoryError in htmlformat.py
Hmmm Now that is a good question! I assume you tried copying the heldmsg files back into the data directory and then running the web-admindb (and that didn't work?) If so then try sending a message to the list that would be held for moderation and then replace the heldmsg-...pck file that is created with one of the ones you copied off (just renaming it). Then approve the moderated message and see if that does the job proper. If that doesn't work, you can use the strings command to find who sent the message and drop them a note asking them to resend the message. Good Luck (and let us know what happens!) On Fri, 2003-02-21 at 18:53, Stephan Spencer wrote: Thanks for that, Jon. I am indeed running 2.1. I tried deleting held messages but that didn't work. I'm still getting a low-level error: Feb 21 17:38:44 2003 admin(32190): admin(32190): [- Mailman Version: 2.1 -] admin(32190): [- Traceback --] admin(32190): Traceback (most recent call last): admin(32190): File /usr/local/mailman/scripts/driver, line 87, in run_main I deleted request.db and it works fine now. I've made backups of the 15 or so legitimate held messages (heldmsg-bnb-list-xxx.pck). How do I get those back into request.db? Thanks, Stephan On Saturday, February 22, 2003, at 04:54 AM, Jon Carnes wrote: What version of Mailman are you using? (it looks like one of the 2.1.x versions). Hope you have already fixed this by now, but just in case, here is something you can try. Look in the data directory for Mailman - this is where the held messages are stored. You can actually scan the heldmsg files manually and delete ones that might be overly large. cd /usr/local/mailman/data ls -l The default message format in version 2.1 is pickle (instead of text), but you can still easily look at each held message by using the strings command (strings is a utility that used to be loaded by default, if you don't have it loaded it's very easy to find). strings heldmsg-b2b-list-1.pck Deleting the heldmsg's here does not delete them from your lists request.db file, but when you run admindb for the list, that will compare the heldmsg files to the ones in request.db and then update request.db (the handling of the request.db file is a lot smarter in version 2.1 of Mailman). In other words,once you launch the Web-admindb everything should sync up and you will just see the messages you left that need approving. It *should* work at this point. assuming that problem was a bad email and you deleted the bad email If not, I recommend removing that lists request.db file: /usr/local/mailman/lists/b2b-list/request.db Just rename the file to something else and then try launching the web-admindb again. Good Luck - Jon Carnes == On Wed, 2003-02-19 at 05:14, Stephan Spencer wrote: This one is out of my depth. The Tend to Pending Moderator Requests page has become inaccessible due to a MemoryError. The traceback follows below. Any guidance would be greatly appreciated. (The list in question is gated to the moderated Usenet newsgroup rec.travel.bed+breakfast, so it gets a lot of incoming spam. Not sure if that has anything to do with the problem at hand, however.). Thanks! Traceback (most recent call last): File /usr/local/mailman/scripts/driver, line 87, in run_main main() File /usr/local/mailman/Mailman/Cgi/admindb.py, line 236, in main print doc.Format() File /usr/local/mailman/Mailman/htmlformat.py, line 331, in Format output.append(Container.Format(self, indent)) File /usr/local/mailman/Mailman/htmlformat.py, line 264, in Format output.append(HTMLFormatObject(item, indent)) File /usr/local/mailman/Mailman/htmlformat.py, line 50, in HTMLFormatObject return item.Format(indent) File /usr/local/mailman/Mailman/htmlformat.py, line 417, in Format output = output + Container.Format(self, indent+2) File /usr/local/mailman/Mailman/htmlformat.py, line 264, in Format output.append(HTMLFormatObject(item, indent)) File /usr/local/mailman/Mailman/htmlformat.py, line 50, in HTMLFormatObject return item.Format(indent) File /usr/local/mailman/Mailman/htmlformat.py, line 200, in Format output = output + self.FormatRow(i, indent + 2) MemoryError Python information: Variable Value sys.version 2.2.2 (#1, Jan 14 2003, 02:49:11) [GCC 2.96 2731 (Red Hat Linux 7.1 2.96-98)] sys.executable /usr/local/bin/python sys.prefix /usr/local sys.exec_prefix /usr/local sys.path /usr/local sys.platform linux2 Environment variables: Variable Value PATH_INFO /bnb-list HTTP_ACCEPT */* CONTENT_TYPE application/x-www-form-urlencoded HTTP_REFERER http://www.innsite.com/mailman/admindb/bnb-list SERVER_SOFTWARE Apache/1.3.26 (Unix)