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:
: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:
: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@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@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@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@x-tracker-01.nationala-1advertising.com sent To: someone@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@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@x-tracker-01.nationala-1advertising.com sent Bcc: Don@mydomain.com, Jeff@mydomain.com, Mina@mydomain.com, Paulo@mydomain.com, carlos@mydomain.com, marty@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@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@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@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Monday, December 19, 2011 12:58 PM
To: rt-users@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@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
Larger than my max_allowed_packet as you can guess. But I didn’t expect RT to increment the id when ticket creation failed. I thought I’d found a bug. The instance is working fine, btw. No ill effects. Thanks for the explanation.