[rt-users] possible RT 4.0.4 attachment bug

[mjames at guesswho.com]

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-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Alex Vandiver
Sent: Friday, January 06, 2012 4:21 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] possible RT 4.0.4 attachment bug

On Fri, 2012-01-06 at 16:11 -0500, mjames at 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