[rt-users] possible RT 4.0.4 attachment bug

mjames at guesswho.com mjames at guesswho.com
Fri Jan 6 12:35:25 EST 2012 

OK, this seems to be a relevant portion of the log file. Sorry about the delay in replying. -Mike

[Thu Dec 15 19:38:48 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587.
 (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 19:39:43 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 20:38:53 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 20:39:49 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 21:38:49 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 21:39:29 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 22:38:49 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Thu Dec 15 22:38:56 2011] [warning]: RT::Handle=HASH(0x2b474a6b16f0) couldn't execute the query 'INSERT INTO Attachments (Subject, ContentType, Filename, Headers, MessageId, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 600
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x2b474a6b16f0)', 'INSERT INTO Attachments (Subject, ContentType, Filename, Head...', '', 'application/x-zip-compressed', 'antiques_bkup_20111215_1408.zip', 'Content-Description: antiques_bkup_20111215_1408.zip\x{a}content-...', '', 193, 582, ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 350
        DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x2b474a6b16f0)', 'Attachments', 'Subject', '', 'ContentType', 'application/x-zip-compressed', 'Filename', 'antiques_bkup_20111215_1408.zip', 'Headers', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 36
        DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x2b474a6b16f0)', 'Attachments', 'Subject', '', 'ContentType', 'application/x-zip-compressed', 'Filename', 'antiques_bkup_20111215_1408.zip', 'Headers', ...) called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1292
        DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x2b475ef06b80)', 'Subject', '', 'Filename', 'antiques_bkup_20111215_1408.zip', 'ContentType', 'application/x-zip-compressed', 'Headers', 'Content-Description: antiques_bkup_20111215_1408.zip\x{a}content-...', ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 304
        RT::Record::Create('RT::Attachment=HASH(0x2b475ef06b80)', 'TransactionId', 908, 'ContentType', 'application/x-zip-compressed', 'ContentEncoding', 'none', 'Parent', 582, ...) called at /opt/rt4/sbin/../lib/RT/Attachment.pm line 193
        RT::Attachment::Create('RT::Attachment=HASH(0x2b475ef06b80)', 'TransactionId', 908, 'Parent', 582, 'Attachment', 'MIME::Entity=HASH(0x2b472a166690)') called at /opt/rt4/sbin/../lib/RT/Attachment.pm line 172
        RT::Attachment::Create('RT::Attachment=HASH(0x2b475ef37e40)', 'TransactionId', 908, 'Attachment', 'MIME::Entity=HASH(0x2b472a1586c0)') called at /opt/rt4/sbin/../lib/RT/Transaction.pm line 543
        RT::Transaction::_Attach('RT::Transaction=HASH(0x2b475eea18e0)', 'MIME::Entity=HASH(0x2b472a1586c0)') called at /opt/rt4/sbin/../lib/RT/Transaction.pm line 160
        RT::Transaction::Create('RT::Transaction=HASH(0x2b475eea18e0)', 'ObjectId', 63, 'ObjectType', 'RT::Ticket', 'TimeTaken', 0, 'Type', 'Create', ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 1447
        RT::Record::_NewTransaction('RT::Ticket=HASH(0x2b472a1ca1f0)', 'Type', 'Create', 'TimeTaken', 0, 'MIMEObj', 'MIME::Entity=HASH(0x2b472a1586c0)', 'CommitScrips', 1, ...) called at /opt/rt4/sbin/../lib/RT/Ticket.pm line 676
        RT::Ticket::Create('RT::Ticket=HASH(0x2b472a1ca1f0)', 'Queue', 1, 'Subject', 'FW: Antiques DB', 'Requestor', 'ARRAY(0x2b473ef82fd0)', 'Cc', 'ARRAY(0x2b473ef82fb0)', ...) called at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line 1515
        RT::Interface::Email::Gateway('HASH(0x2b472a1413a0)') called at /opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway line 61
        HTML::Mason::Commands::__ANON__('SessionType', 'REST', 'action', 'correspond', 'queue', 'general', 'message', 'From someone at mydomain.com Thu Dec 15 17:38:29 2011\x{a}Received: ...') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2b472a153410)', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'general', 'message', 'From someone at mydomain.com Thu Dec 15 17:38:29 2011\x{a}Received: ...', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1297
        eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
        HTML::Mason::Request::comp('undef', 'undef', 'undef', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'general', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481
        eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481
        eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 433
        HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b4740cc8a90)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/PSGIHandler.pm line 85
        eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/PSGIHandler.pm line 85
        HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x2b4740cc8a90)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Interp.pm line 342
        HTML::Mason::Interp::exec('undef', 'undef', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'general', 'message', ...) called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/PSGIHandler.pm line 48
        eval {...} called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/PSGIHandler.pm line 48
        HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x2b4740cc6520)', 'HTML::Mason::FakeApache=HASH(0x2b474a73a450)', 'HASH(0x2b473fc3b260)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/PSGIHandler/Streamy.pm line 52
        HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x2b474a73a9e0)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 256
        RT::Interface::Web::Handler::__ANON__('CODE(0x2b474a73a9e0)') called at /usr/lib/perl5/site_perl/5.8.8/Plack/Util.pm line 324
        Plack::Util::__ANON__('CODE(0x2b474a6d35d0)') called at /usr/lib/perl5/site_perl/5.8.8/Plack/Handler/Apache2.pm line 68
        Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 'Apache2::RequestRec=SCALAR(0x2b473a5d1ea0)', 'CODE(0x2b473e6a00d0)') called at /usr/lib/perl5/site_perl/5.8.8/Plack/Handler/Apache2.pm line 91
        Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x2b473a5d1ea0)') called at -e line 0
        eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Dec 15 22:38:56 2011] [crit]: Attachment insert failed: Got a packet bigger than 'max_allowed_packet' bytes (/opt/rt4/sbin/../lib/RT/Attachment.pm:206)
[Thu Dec 15 22:38:56 2011] [crit]: Attachment insert failed: Got a packet bigger than 'max_allowed_packet' bytes (/opt/rt4/sbin/../lib/RT/Attachment.pm:178)
[Thu Dec 15 22:39:11 2011] [info]: <rt-4.0.4-25137-1323988746-553.63-3-0 at x-tracker-01.nationala-1advertising.com> #63/908 - Scrip 3 On Create Autoreply To Requestors (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:301)
[Thu Dec 15 22:39:12 2011] [info]: <rt-4.0.4-25137-1323988746-553.63-3-0 at x-tracker-01.nationala-1advertising.com> sent  To: someone at mydomain.com (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:332)
[Thu Dec 15 22:39:12 2011] [info]: <rt-4.0.4-25137-1323988748-1398.63-4-0 at x-tracker-01.nationala-1advertising.com> #63/908 - Scrip 4 On Create Notify AdminCcs (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:301)
[Thu Dec 15 22:39:12 2011] [info]: <rt-4.0.4-25137-1323988748-1398.63-4-0 at x-tracker-01.nationala-1advertising.com> sent  Bcc: Don at mydomain.com, Jeff at mydomain.com, Mina at mydomain.com, Paulo at mydomain.com, carlos at mydomain.com, marty at mydomain.com (/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:332)
[Thu Dec 15 22:39:12 2011] [info]: Ticket 63 created in queue 'General' by someone (/opt/rt4/sbin/../lib/RT/Ticket.pm:688)
[Fri Dec 16 03:39:01 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 04:39:02 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 05:39:01 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 06:39:04 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 07:39:04 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 08:39:01 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 09:38:59 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 10:39:01 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 11:38:56 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 12:30:19 2011] [info]: RT::Authen::ExternalAuth::LDAP::GetAuth External Auth OK ( My_LDAP ): marty (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:139)
[Fri Dec 16 12:30:19 2011] [warning]: Couldn't enable user 22 (/opt/rt4/sbin/../lib/RT/User.pm:1066)
[Fri Dec 16 12:30:19 2011] [info]: User marked as ENABLED ( marty ) per External Service (, ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274)
[Fri Dec 16 12:30:19 2011] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Address1: , City: , Country: , EmailAddress: marty at mydomain.com, ExternalAuthId: marty, Gecos: marty, Name: marty, Organization: , RealName: Martin Sheen, State: , WorkPhone: x3341, Zip:  (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Fri Dec 16 12:30:19 2011] [info]: Successful login for marty from 192.168.1.111 (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:219)
[Fri Dec 16 12:31:53 2011] [error]: WebRT: Could not load ticket 54 (/opt/rt4/share/html/Elements/Error:82)
[Fri Dec 16 12:31:53 2011] [crit]: HasRights called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:370)
[Fri Dec 16 12:31:53 2011] [warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Principal.pm line 373. (/opt/rt4/sbin/../lib/RT/Principal.pm:373)
[Fri Dec 16 12:31:53 2011] [crit]: HasRight called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:290)
[Fri Dec 16 12:38:47 2011] [warning]: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 587. (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:587)
[Fri Dec 16 13:14:15 2011] [info]: Successful login for root from 192.168.3.11 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:660)
[Fri Dec 16 13:16:16 2011] [info]: RT::Authen::ExternalAuth::LDAP::GetAuth External Auth OK ( My_LDAP ): marty (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:139)
[Fri Dec 16 13:16:16 2011] [warning]: Couldn't enable user 22 (/opt/rt4/sbin/../lib/RT/User.pm:1066)
[Fri Dec 16 13:16:16 2011] [info]: User marked as ENABLED ( marty ) per External Service (, ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274)
[Fri Dec 16 13:16:16 2011] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Address1: , City: , Country: , EmailAddress: marty at mydomain.com, ExternalAuthId: marty, Gecos: marty, Name: marty, Organization: , RealName: Martin Sheen, State: , WorkPhone: x3341, Zip:  (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
[Fri Dec 16 13:16:16 2011] [info]: Successful login for marty from 192.168.3.11 (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:219)
[Fri Dec 16 13:21:10 2011] [error]: WebRT: Could not load ticket 55 (/opt/rt4/share/html/Elements/Error:82)
[Fri Dec 16 13:21:10 2011] [crit]: HasRights called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:370)
[Fri Dec 16 13:21:10 2011] [warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Principal.pm line 373. (/opt/rt4/sbin/../lib/RT/Principal.pm:373)
[Fri Dec 16 13:21:10 2011] [crit]: HasRight called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:290)
[Fri Dec 16 13:21:17 2011] [error]: WebRT: Could not load ticket 56 (/opt/rt4/share/html/Elements/Error:82)
[Fri Dec 16 13:21:17 2011] [crit]: HasRights called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:370)
[Fri Dec 16 13:21:17 2011] [warning]: Use of uninitialized value in concatenation (.) or string at /opt/rt4/sbin/../lib/RT/Principal.pm line 373. (/opt/rt4/sbin/../lib/RT/Principal.pm:373)
[Fri Dec 16 13:21:17 2011] [crit]: HasRight called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:290)
[Fri Dec 16 13:21:21 2011] [error]: WebRT: Could not load ticket 57 (/opt/rt4/share/html/Elements/Error:82)
[Fri Dec 16 13:21:21 2011] [crit]: HasRights called with no valid object (/opt/rt4/sbin/../lib/RT/Principal.pm:370)

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Monday, December 19, 2011 12:58 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] possible RT 4.0.4 attachment bug

On Fri, Dec 16, 2011 at 08:24:02AM -0500, mjames at guesswho.com wrote:
>    This may be a bug in the way attachments are handled in 4.0.4.
>
>    We recently spun up a new instance of RT 4.0.2, then upgraded to 4.0.4. Running on Centos 5.7
>    using MySQL. Yesterday we were at ticket #53. A user sent an email last night with an
>    attachment containing sql statements (a database backup). His ticket id is #63.
>
>    There aren't any intervening tickets. When I use the quick search for example, and try to
>    load a ticket between 53-63, I get an error:
>
>    RT Error Could not load ticket 57 (for example)
>
>    The only thing I can think of is that some of the statements in the attachment were acted on.
>    Is this possible?

What's in your RT logs?

-kevin

More information about the rt-users mailing list