Here's a follow-up to an old topic... The "beeping" phenomenon is back. It choked on a 1.6MB email on Friday. Nothing special about the email, that I could tell. There was also a 64MB email in the inbox, but it just skipped over it and didn't try to download it. It did print a message saying "Message too big" and went on to the problem email. I'm not sure what it was doing, but it tried to print the 1.6MB email to the console, which is what caused the beeping. Any ideas why it would do that? And why is it printing that sort of character? It's obviously not printing just the raw email, because if I remember correctly raw emails don't contain control characters (such as the "beep" character). Yes, the 64MB email is outrageously large, but a 1.6MB email doesn't seem particularly large. I can't imagine that OTRS should ever choke on an email of that size. Any help would be greatly appreciated. Thanks! -- Chris Salter -----Original Message----- From: otrs-admin@otrs.org [mailto:otrs-admin@otrs.org]On Behalf Of Chris Salter Sent: August 5, 2003 9:57 AM To: otrs@otrs.org Subject: RE: [otrs] PostMasterPOP3.pl Jake, I had a 19MB email (19 megs of screenshots, believe it or not) come in to our system last week, with the same results. Win2K, running OTRS 1.1.3. Every once in a while OTRS will choke on emails over 2MB, but normally it at least is good up to 5MB. Above that, it's pretty much guaranteed to choke. With the 19MB email, we discovered the problem because OTRS was trying to print the email to the console window, causing our server to beep like crazy. -- Chris Salter -----Original Message----- From: otrs-admin@otrs.org [mailto:otrs-admin@otrs.org]On Behalf Of Covert, Jake Sent: August 5, 2003 9:28 AM To: otrs@otrs.org Subject: RE: [otrs] PostMasterPOP3.pl It was on a Win2k machine, being run by mstask.exe (Microsoft's task scheduler), so I'm now suspicious that it might have been the culprit. -----Original Message----- From: Yong Li [mailto:yli@mpiz-koeln.mpg.de] Sent: Tuesday, August 05, 2003 8:46 AM To: otrs@otrs.org Subject: Re: [otrs] PostMasterPOP3.pl
"Covert, Jake" wrote:
Once of my customers was gracious enough to try and email us a 30 Meg file as an attachment. When PostMasterPOP3.pl tried to get it, it hung (obviously...).
My question is this: Is there any email input size restrictions on PostMasterPOP3.pl? I know that otrs and mysql can both set their own limits, but this would prevent it from even coming into the system.
There is one default limit of 6M of email size in Default.pm: # --------------------------------------------------- # # # # Start of config options!!! # # PostMaster stuff # # # # --------------------------------------------------- # ... # PostMasterPOP3MaxSize # (max. email size) $Self->{PostMasterPOP3MaxEmailSize} = 1024 * 6; So PostMasterPOP3.pl should handle (skip) it, but I have no idea of why it hung... Best regards, Yong Li _______________________________________________ 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 _______________________________________________ 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 _______________________________________________ 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
Okay, here's some more info. The beeping was back this morning. In this case, it was choking on a 4.4 MB email. Interestingly, in the last two cases (I can't remember about the previous times that I had problems) the emails it had problems with were emails that were sent from OTRS to the customer but the account that OTRS uses to receive emails was CC'd on the outgoing email. (Long story why we do that.) Our server is Windows 2000 Pro SP3, running OTRS 1.1.3. It's a 700 MHz NEC machine with a 15 GB hard drive and 512 MB RAM. There's nothing running on that machine other than OTRS. When I run PostMasterPOP3.pl, it waits for a while, then prints out a message that MySQL has gone away, then it prints out the raw email... Then it looks like it's printing out the rendered file for some reason. (The emails that are having problems all contain attachments.) Next time it happens, I'll try to capture the console output. -- Chris Salter -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Chris Salter Sent: September 3, 2003 11:30 AM To: otrs@otrs.org Subject: RE: [otrs] PostMasterPOP3.pl Here's a follow-up to an old topic... The "beeping" phenomenon is back. It choked on a 1.6MB email on Friday. Nothing special about the email, that I could tell. There was also a 64MB email in the inbox, but it just skipped over it and didn't try to download it. It did print a message saying "Message too big" and went on to the problem email. I'm not sure what it was doing, but it tried to print the 1.6MB email to the console, which is what caused the beeping. Any ideas why it would do that? And why is it printing that sort of character? It's obviously not printing just the raw email, because if I remember correctly raw emails don't contain control characters (such as the "beep" character). Yes, the 64MB email is outrageously large, but a 1.6MB email doesn't seem particularly large. I can't imagine that OTRS should ever choke on an email of that size. Any help would be greatly appreciated. Thanks! -- Chris Salter -----Original Message----- From: otrs-admin@otrs.org [mailto:otrs-admin@otrs.org]On Behalf Of Chris Salter Sent: August 5, 2003 9:57 AM To: otrs@otrs.org Subject: RE: [otrs] PostMasterPOP3.pl Jake, I had a 19MB email (19 megs of screenshots, believe it or not) come in to our system last week, with the same results. Win2K, running OTRS 1.1.3. Every once in a while OTRS will choke on emails over 2MB, but normally it at least is good up to 5MB. Above that, it's pretty much guaranteed to choke. With the 19MB email, we discovered the problem because OTRS was trying to print the email to the console window, causing our server to beep like crazy. -- Chris Salter -----Original Message----- From: otrs-admin@otrs.org [mailto:otrs-admin@otrs.org]On Behalf Of Covert, Jake Sent: August 5, 2003 9:28 AM To: otrs@otrs.org Subject: RE: [otrs] PostMasterPOP3.pl It was on a Win2k machine, being run by mstask.exe (Microsoft's task scheduler), so I'm now suspicious that it might have been the culprit. -----Original Message----- From: Yong Li [mailto:yli@mpiz-koeln.mpg.de] Sent: Tuesday, August 05, 2003 8:46 AM To: otrs@otrs.org Subject: Re: [otrs] PostMasterPOP3.pl
"Covert, Jake" wrote:
Once of my customers was gracious enough to try and email us a 30 Meg file as an attachment. When PostMasterPOP3.pl tried to get it, it hung (obviously...).
My question is this: Is there any email input size restrictions on PostMasterPOP3.pl? I know that otrs and mysql can both set their own limits, but this would prevent it from even coming into the system.
There is one default limit of 6M of email size in Default.pm: # --------------------------------------------------- # # # # Start of config options!!! # # PostMaster stuff # # # # --------------------------------------------------- # ... # PostMasterPOP3MaxSize # (max. email size) $Self->{PostMasterPOP3MaxEmailSize} = 1024 * 6; So PostMasterPOP3.pl should handle (skip) it, but I have no idea of why it hung... Best regards, Yong Li _______________________________________________ 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 _______________________________________________ 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 _______________________________________________ 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 _______________________________________________ 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
Am Fre, 2003-09-05 um 17.01 schrieb Chris Salter:
When I run PostMasterPOP3.pl, it waits for a while, then prints out a message that MySQL has gone away, then it prints out the raw email... Then it looks like it's printing out the rendered file for some reason. (The emails that are having problems all contain attachments.) Next time it happens, I'll try to capture the console output.
When you've captured the output, post it. Forward the offending TWO emails to me (if they do not contain confidential material), if you like. Is the problem reproducable, ie. does it always happen when you'd forward the questioned emails again? And, at last, what do your logs say? Robert Kehl
Sorry, I can't forward the emails, as they contain confidential information.
I've done my best to cut-and-paste the important parts of the log files.
Here's the start of the entry. It prints out the email, including MIME
encoding of the 4 MB attachment.
[Fri Sep 5 10:50:03
2003][Error][Kernel::System::Ticket::ArticleStorageDB::WriteArticlePlain][10
1] MySQL server has gone away, SQL: 'INSERT INTO article_plain (article_id,
body, create_time, create_by, change_time, change_by) VALUES (5650,
'Return-Path:
When I run PostMasterPOP3.pl, it waits for a while, then prints out a message that MySQL has gone away, then it prints out the raw email... Then it looks like it's printing out the rendered file for some reason. (The emails that are having problems all contain attachments.) Next time it happens, I'll try to capture the console output.
When you've captured the output, post it. Forward the offending TWO emails to me (if they do not contain confidential material), if you like. Is the problem reproducable, ie. does it always happen when you'd forward the questioned emails again? And, at last, what do your logs say? 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
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
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
Hi Chris, On Tue, Sep 09, 2003 at 04:06:29PM -0400, Chris Salter wrote:
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!
Just if the beeping comes back, there is also an other storage backend module. The default storage backend is the database module which needs more memory. The other on is using the file system which needs lesser memory. See: http://doc.otrs.org/1.1/html/performance-tuning.html#PERFORMANCE-TUNING-OTRS...
Chris Salter
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
participants (3)
-
Chris Salter -
Martin Edenhofer -
Robert Kehl