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 [email protected] 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 [email protected] 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-...@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-...@x-tracker-01.nationala-1advertising.com>
sent To: [email protected] (/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-...@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-...@x-tracker-01.nationala-1advertising.com>
sent Bcc: [email protected], [email protected], [email protected],
[email protected], [email protected], [email protected]
(/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: [email protected], 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: [email protected], 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: [email protected]
[mailto:[email protected]] On Behalf Of Kevin Falcone
Sent: Monday, December 19, 2011 12:58 PM
To: [email protected]
Subject: Re: [rt-users] possible RT 4.0.4 attachment bug
On Fri, Dec 16, 2011 at 08:24:02AM -0500, [email protected] 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
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
