Lars,
I ran into the same problem. It turned out to be a MySQL setting problem.
I'm including the message I sent when I fixed it. It hasn't been a problem
since.
-------
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. :-)
-------
The problem is caused by OTRS trying to send too much data at once to MySQL,
which then chokes on it. By fixing the max_allowed_packet setting, MySQL
can handle more data at once. Check the MySQL manual for where to put the
setting.
Hope this helps!
--
Chris Salter
-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of
Lars Monsees
Sent: October 21, 2003 5:30 AM
To: Otrs (E-Mail)
Subject: [otrs] Problem with large attachment (3-4mb)
Hello,
a customer sent a mail with a zip file attached. The file is about 3-4mb and
the maximum allowed upload size is the default 5mb.
The cronjob PostmasterPOP3.pl sends the following message (see below).
As the mail wasn´t properly downloaded it got downloaded every time the
cronjob ran until I manually downloaded the mail.
Could this be a timeout problem with the mysql-server?
Regards,
Lars
DBD::mysql::db do failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 172.
ERROR: OTRS-PM3-10 Perl: 5.8.0 OS: linux Time: Tue Oct 21 10:50:21 2003
Message: MySQL server has gone away, SQL: 'INSERT INTO article_plain
(article_id, body, create_time, create_by, change_time, change_by) VALUES
(648, 'Return-Path:
Received: from mailout08.sul.xxxxx.com (mailout08.sul.t-online.com
[194.25.134.20]) by xxxxxx.net (8.10.2/8.10.2) with ESMTP id h9L87MM28500
for ; Tue, 21 Oct 2003 10:07:22 +0200
Received: from fwd00.aul.xxxxxx by mailout08.sul.xxxxx with smtp id
1ABrZj-0005A8-00; Tue, 21 Oct 2003 10:09:07 +0200
Received: from MMPWS04
(bdBNZYZvYe23tR-gZx-z4vMrASSq+9O8bOOcYf9RshVZqIqckCfD8I@[217.228.12.94]) by
fmrl00.sul.xxxxx with smtp id 1ABrUW-1b40OW0; Tue, 21 Oct 2003 10:03:44
+0200
Message-Id: <000e01c397a9$93207170$fe78a8c0@MMPWS04>
From: "xxxxx xxxx"
To: "xxxxx"
References: <1066721282.876073.298426512.168.2@www.xxxxx.de>
Subject: Re: [Ticket#: 2003102110000015] Re: Mailbox-Fehler
Date: Tue, 21 Oct 2003 10:01:40 +0200
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_NextPart_000_000B_01C397BA.52942E60"
X-Priority: 3
X-Msmail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Seen: false
X-Id: bdBNZYZvYe23tR-gZx-z4vMrASSq+9O8bOOcYf9RshVZqIqckCfD8I@t-dialin.net
Status: U
This is a multi-part message in MIME format.
------=_NextPart_000_000B_01C397BA.52942E60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
(snip)
----- Original Message -----
From: "EasyBuyer"
To: "Stratos Kamitsos"
Sent: Tuesday, October 21, 2003 9:28 AM
Subject: [Ticket#: 2003102110000015] Re: Mailbox-Fehler
(snip)
------=_NextPart_000_000B_01C397BA.52942E60
Content-Type: application/x-zip-compressed;
name="mailbox.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="mailbox.zip"
UEsDBBQAAAAIAHRPVS+5P0Qt/voxAABwAwULAAAAbWFpbGJveC5tZGLsnQt0HNV5gP+ZnX3NPmYl
y8Iv4sXm6Vhm9cCWAdNdvbCFZFl+4Ch2bUnelb3osUKSjYyxJUxepOcktKENUAKlTZvQk6ShkJwS
(snip)
(the zip file)
AhYLFAAAAAgAdE9VL7k/RC3++jEAAHADBQsAAAAAAAAAAAAgAICBAAAAAG1haWxib3gubWRiUEsF
BgAAAAABAAEAOQAAACf7MQAAAA==
------=_NextPart_000_000B_01C397BA.52942E60--
', current_timestamp, 1, current_timestamp, 1)'
Traceback (26066):
Module: Kernel::System::Ticket::ArticleStorageDB::WriteArticlePlain
(v1.9.2.1) Line: 101
Module: Kernel::System::PostMaster::FollowUp::Run (v1.27.2.1) Line: 97
Module: Kernel::System::PostMaster::Run (v1.31.2.3) Line: 178
Module: main::FetchMail (v1.9.2.2) Line: 169
Module: /opt/otrs/bin/PostMasterPOP3.pl (v1.9.2.2) Line: 106
DBD::mysql::db do failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 172.
Invalid conversion in sprintf: "%\313" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%^" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\033" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\230" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\312" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\363" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Use of uninitialized value in sprintf at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\350" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\244" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%`" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Use of uninitialized value in sprintf at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\025" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%_" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%Z" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\341" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%+" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Use of uninitialized value in sprintf at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%$" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Use of uninitialized value in sprintf at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\236" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\371" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\357" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%W" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\375" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Use of uninitialized value in sprintf at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%?" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\277" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\331" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\246" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Use of uninitialized value in sprintf at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\375" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\217" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\217" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\217" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\377" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\217" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\235" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Invalid conversion in sprintf: "%\325" at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
Modification of a read-only value attempted at
/usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm line 287.
_______________________________________________
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
Support oder Consulting für Ihr OTRS System?