I changed the max_allowed_packet setting in MySQL. It apparently is set to 1MB by default. I changed it to 10M. We'll see. I don't have a copy of the specific email that crashed it, but I did send an email with the same attachment that the other one had. It picked it up fine, no error message, no beeping. :-) If it comes up again, I'll be sure to let you know, and I'll get you more information. Thanks! -- Chris Salter -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Robert Kehl Sent: September 8, 2003 4:30 PM To: User questions and discussions about OTRS. Subject: RE: [otrs] PostMasterPOP3.pl Am Mon, 2003-09-08 um 21.34 schrieb Chris Salter:
Here's the start of the entry. It prints out the email, including MIME encoding of the 4 MB attachment.
MySQL server has gone away, SQL: 'INSERT INTO article_plain (article_id, MySQL server has gone away, SQL: 'INSERT INTO article_attachment
Hopefully this gives you an idea of what's going on. Let me know if you need anything else.
My first idea were to check MySQL's settings on storage limitation, and check the free disk space on the partition holding the MySQL data files. Also I'd check the load of the MySQL server while receiving these emails. You didn't answer one question: Is the problem reproducable, ie. does it happen every time you feed a specific eMail to the script? Are you able to create a mail of that kind holding no confidential info? Regards, Robert Kehl _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs