[rt-devel] Attachment insert failed: MySQL server has gone away

David Hanson dhanson at concretesoftware.com
Wed Oct 17 15:27:11 EDT 2012


Hello,

My company is fairly new to using RT, about a half a year now, and we
suddenly seem to be having an attachment issue. We are currently using RT
4.0.6 and have been unable to attach images larger than around 1 MB. We
have previously been able to because I had increased the maximum attachment
size in the RT_SiteConfig, http config, and mysql config files. We haven't
recently made any updates to the system that I am aware of.

I have tried restarting the http and mysql services a couple times, but to
no avail. I can still attach smaller image files, but 1MB seems to be about
the limit. The error message seems to be "Attachment insert failed: MySQL
server has gone away". After the attachment insert query, it seems to also
fail on a Scrip query but if the sql server HAS gone away, it comes right
back after those two failures. The MySQL log doesn't appear to have
anything useful from around that time.

The FAQ suggests that if it is not the MaxAttachmentSize then it may be
mod_security, but I don't believe we use that in our http config and I
don't see anything about mod_security in the log.

So it appears to be a MySql issue, but MySql doesn't think anything is
going wrong. Below is the full log message from the error.

[Wed Oct 17 18:20:08 2012] [warning]: DBD::mysql::st execute failed: MySQL
server has gone away at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm
line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)

[Wed Oct 17 18:20:08 2012] [warning]: RT::Handle=HASH(0x7797a60) couldn't
execute the query 'INSERT INTO Attachments (Subject, ContentType, Filename,
Headers, MessageId, Creator, Parent, Created, ContentEncoding, Content,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.

DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7797a60)',
'INSERT INTO Attachments (Subject, ContentType, Filename, Head...',
'DH_Test_IMG_0092', 'application/octet-stream', 'DH_Test_IMG_0092',
'MIME-Version: 1.0\x{a}Subject: DH_Test_IMG_0092\x{a}X-Mailer: MIME-to...',
'', 38, 5845, ...) called at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 350

DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x7797a60)',
'Attachments', 'Subject', 'DH_Test_IMG_0092', 'ContentType',
'application/octet-stream', 'Filename', 'DH_Test_IMG_0092', 'Headers', ...)
called at /usr/local/share/perl5/DBIx/SearchBuilder/Handle/mysql.pm line 36

DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7797a60)',
'Attachments', 'Subject', 'DH_Test_IMG_0092', 'ContentType',
'application/octet-stream', 'Filename', 'DH_Test_IMG_0092', 'Headers', ...)
called at /usr/local/share/perl5/DBIx/SearchBuilder/Record.pm line 1292

DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x7d38bc0)',
'Subject', 'DH_Test_IMG_0092', 'Filename', 'DH_Test_IMG_0092',
'ContentType', 'application/octet-stream', 'Headers', 'MIME-Version:
1.0\x{a}Subject: DH_Test_IMG_0092\x{a}X-Mailer: MIME-to...', ...) called at
/usr/local/rt/sbin/../lib/RT/Record.pm line 316

RT::Record::Create('RT::Attachment=HASH(0x7d38bc0)', 'TransactionId',
12268, 'ContentType', 'application/octet-stream', 'ContentEncoding',
'none', 'Parent', 5845, ...) called at
/usr/local/rt/sbin/../lib/RT/Attachment.pm line 193

RT::Attachment::Create('RT::Attachment=HASH(0x7d38bc0)', 'TransactionId',
12268, 'Parent', 5845, 'Attachment', 'MIME::Entity=HASH(0x7e27b98)') called
at /usr/local/rt/sbin/../lib/RT/Attachment.pm line 172

RT::Attachment::Create('RT::Attachment=HASH(0x7875a48)', 'TransactionId',
12268, 'Attachment', 'MIME::Entity=HASH(0x7e28690)') called at
/usr/local/rt/sbin/../lib/RT/Transaction.pm line 543

RT::Transaction::_Attach('RT::Transaction=HASH(0x7d41d80)',
'MIME::Entity=HASH(0x7e28690)') called at
/usr/local/rt/sbin/../lib/RT/Transaction.pm line 160

RT::Transaction::Create('RT::Transaction=HASH(0x7d41d80)', 'ObjectId', 155,
'ObjectType', 'RT::Ticket', 'TimeTaken', '', 'Type', 'Comment', ...) called
at /usr/local/rt/sbin/../lib/RT/Record.pm line 1459

RT::Record::_NewTransaction('RT::Ticket=HASH(0x7e27df0)', 'Type',
'Comment', 'Data', 'No Subject', 'TimeTaken', '', 'MIMEObj',
'MIME::Entity=HASH(0x7e28690)', ...) called at
/usr/local/rt/sbin/../lib/RT/Ticket.pm line 2243

RT::Ticket::_RecordNote('RT::Ticket=HASH(0x7e27df0)', 'DryRun', 0,
'BccMessageTo', '', 'CcMessageTo', '', 'NoteType', 'Comment', ...) called
at /usr/local/rt/sbin/../lib/RT/Ticket.pm line 2103

RT::Ticket::Comment('RT::Ticket=HASH(0x7e27df0)', 'BccMessageTo', '',
'CcMessageTo', '', 'MIMEObj', 'MIME::Entity=HASH(0x7e28690)', 'TimeTaken',
'', ...) called at /usr/local/rt/sbin/../lib/RT/Interface/Web.pm line 1859

HTML::Mason::Commands::ProcessUpdateMessage('ARGSRef', 'HASH(0x7e074d8)',
'Actions', 'ARRAY(0x7def938)', 'TicketObj', 'RT::Ticket=HASH(0x7e27df0)')
called at /usr/local/rt/share/html/Ticket/Display.html line 164

HTML::Mason::Commands::__ANON__('TicketObj', 'RT::Ticket=HASH(0x7e27df0)',
'Articles-Include-Article-Named', '', 'UpdateCc', '',
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'SubmitTicket', ...)
called at /usr/local/share/perl5/HTML/Mason/Component.pm line 138

HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7dffa78)',
'TicketObj', 'RT::Ticket=HASH(0x7e27df0)',
'Articles-Include-Article-Named', '', 'UpdateCc', '',
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', ...) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1305

eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295

HTML::Mason::Request::comp(undef, undef, 'TicketObj',
'RT::Ticket=HASH(0x7e27df0)', 'Articles-Include-Article-Named', '',
'UpdateCc', '', 'Object-RT::Ticket-155-CustomField-5-Value', ...) called at
/usr/local/rt/share/html/Ticket/Update.html line 328

HTML::Mason::Commands::__ANON__('Object-RT::Ticket-155-CustomField-5-Value',
'Any', 'UpdateCc', '', 'Articles-Include-Article-Named', '',
'Articles_Content', '', 'SubmitTicket', ...) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 138

HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7cf7620)',
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', 'Articles_Content', '', ...) called
at /usr/local/share/perl5/HTML/Mason/Request.pm line 1305

eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295

HTML::Mason::Request::comp(undef, undef, undef,
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', ...) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 958

HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7d9adb0)')
called at /usr/local/rt/share/html/Ticket/autohandler line 19

HTML::Mason::Commands::__ANON__('Object-RT::Ticket-155-CustomField-5-Value',
'Any', 'UpdateCc', '', 'Articles-Include-Article-Named', '',
'Articles_Content', '', 'SubmitTicket', ...) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 138

HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7dbf490)',
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', 'Articles_Content', '', ...) called
at /usr/local/share/perl5/HTML/Mason/Request.pm line 1305

eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295

HTML::Mason::Request::comp(undef, undef, undef,
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', ...) called at
/usr/local/rt/sbin/../lib/RT/Interface/Web.pm line 568

RT::Interface::Web::ShowRequestedPage('HASH(0x7da6178)') called at
/usr/local/rt/sbin/../lib/RT/Interface/Web.pm line 318

RT::Interface::Web::HandleRequest('HASH(0x7da6178)') called at
/usr/local/rt/share/html/autohandler line 53

HTML::Mason::Commands::__ANON__('Object-RT::Ticket-155-CustomField-5-Value',
'Any', 'UpdateCc', '', 'Articles-Include-Article-Named', '',
'Articles_Content', '', 'SubmitTicket', ...) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 138

HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x77e1848)',
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', 'Articles_Content', '', ...) called
at /usr/local/share/perl5/HTML/Mason/Request.pm line 1300

eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1295

HTML::Mason::Request::comp(undef, undef, undef,
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', ...) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 484

eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 484

eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 436

HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7d9adb0)')
called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line
85

HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7d9adb0)')
called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 345

HTML::Mason::Interp::exec(undef, undef,
'Object-RT::Ticket-155-CustomField-5-Value', 'Any', 'UpdateCc', '',
'Articles-Include-Article-Named', '', 'Articles_Content', ...) called at
/usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line
48

HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x76b2798)',
'HTML::Mason::FakeApache=HASH(0x7d8f938)', 'HASH(0x7db06a8)') called at
/usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52

HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7d9ce70)') called at
/usr/local/rt/sbin/../lib/RT/Interface/Web/Handler.pm line 263

RT::Interface::Web::Handler::__ANON__('CODE(0x7d9ce70)') called at
/usr/local/share/perl5/Plack/Util.pm line 301

Plack::Util::__ANON__('CODE(0x7d9f158)') called at
/usr/local/share/perl5/Plack/Handler/FCGI.pm line 130

Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x7737568)',
'CODE(0x76ac918)') called at /usr/local/share/perl5/Plack/Loader.pm line 84

Plack::Loader::run('Plack::Loader=HASH(0x77373a0)',
'Plack::Handler::FCGI=HASH(0x7737568)') called at
/usr/local/share/perl5/Plack/Runner.pm line 263

Plack::Runner::run('Plack::Runner=HASH(0x73229f0)', 'CODE(0x76ac918)')
called at /usr/local/rt/sbin/rt-server.fcgi line 232

eval {...} called at /usr/local/rt/sbin/rt-server.fcgi line 232
(/usr/local/share/perl5/Carp.pm:103)

[Wed Oct 17 18:20:08 2012] [critical]: Attachment insert failed: MySQL
server has gone away (/usr/local/rt/sbin/../lib/RT/Attachment.pm:206)

[Wed Oct 17 18:20:08 2012] [critical]: Attachment insert failed: MySQL
server has gone away (/usr/local/rt/sbin/../lib/RT/Attachment.pm:178)


I am unsure of what to look into next to try and fix the issue. Could
somebody point me in the right direction?


Thanks,

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20121017/a4102943/attachment-0001.html>


More information about the rt-devel mailing list