Possible RT 4.0.4 attachment bug

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?

Mike

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

See screenshot that I captured from webmin for the Tickets table - there are missing tickets in the range between 53 and 184. I have not run shredder or manipulated the database in any way. All I can add is that a user submitted a mysql database dump as an attachment that exceeded the allowed size limit.

MikeFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of mjames@guesswho.com
Sent: Friday, December 16, 2011 8:24 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] possible RT 4.0.4 attachment bug

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?

Mike

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@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

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)

This error will cause the Attachment creation to fail, which cascades up
to the Transaction creation and Ticket creation. All of it is done
inside a database-level transaction which is rolled back on failure.

The end result is the id sequence is incremented, but no such ticket
exists. Such gaps don’t cause any problem though.

What is your max_allowed_packet? I’ll bet it’s tiny and should be
increased.

Thomas

The user had tried to submit a mysqldump that was 20GB as an attachment :slight_smile: 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.

Mike-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: Friday, January 06, 2012 12:51 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] possible RT 4.0.4 attachment bug

On 01/06/2012 12:35 PM, mjames@guesswho.com wrote:

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)

This error will cause the Attachment creation to fail, which cascades up to the Transaction creation and Ticket creation. All of it is done inside a database-level transaction which is rolled back on failure.

The end result is the id sequence is incremented, but no such ticket exists. Such gaps don’t cause any problem though.

What is your max_allowed_packet? I’ll bet it’s tiny and should be increased.

Thomas
RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

The user had tried to submit a mysqldump that was 20GB as an attachment

I’m surprised your mail server didn’t fall over from that.

But I didn’t expect RT to increment the id when ticket creation failed.

For reference, RT isn’t the one incrementing the id – the database is.
This is a side effect of transaction isolation and database integrity.
Not doing so would be a bug.

  • Alex

Thanks. I knew that mysql had done the id increment - I was sloppy in my language. Sorry about that. And now I know more about how database integrity works. Have a good weekend.From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Friday, January 06, 2012 4:21 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] possible RT 4.0.4 attachment bug

The user had tried to submit a mysqldump that was 20GB as an attachment

I’m surprised your mail server didn’t fall over from that.

But I didn’t expect RT to increment the id when ticket creation failed.

For reference, RT isn’t the one incrementing the id – the database is.
This is a side effect of transaction isolation and database integrity.
Not doing so would be a bug.

  • Alex

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012