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