Re: [rt-users] possible RT 4.0.4 attachment bug
]: 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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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, mja...@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 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] possible RT 4.0.4 attachment bug
On 01/06/2012 12:35 PM, mja...@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
Re: [rt-users] possible RT 4.0.4 attachment bug
The user had tried to submit a mysqldump that was 20GB as an attachment :) 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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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, mja...@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 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] possible RT 4.0.4 attachment bug
On Fri, 2012-01-06 at 16:11 -0500, mja...@guesswho.com wrote: 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
Re: [rt-users] possible RT 4.0.4 attachment bug
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. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@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 On Fri, 2012-01-06 at 16:11 -0500, mja...@guesswho.com wrote: 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 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] possible RT 4.0.4 attachment bug
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. Mike From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of mja...@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 attachment: ScreenShot006.png RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] possible RT 4.0.4 attachment bug
On Fri, Dec 16, 2011 at 08:24:02AM -0500, mja...@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 pgpVKQH9eYBZZ.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[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 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012