[rt-users] Transaction not being recorded

[Roy El-Hames]

what sql engine are you running ISAM/Innodb ??
I did notice this happening a couple of times since upgrading to 3.6.1 
when the system was fairly busy, it seems something is wrong with sql 
transactions when creating a ticket , where its not rolling back if it 
failed (though I am sure if it should roll back)..
I use Innodb /mysql5  ..
I wonder if Jesse or Ruslan have any ideas ..
(mentioning names works most of the time :¬)

Roy



Tobias Heinz wrote:
> I had hundreds of those "transaction not recorded" errors on our rt 
> 3.4.1 Installation.
>
> I posted multiple times to this and other lists, but nobody replied. 
> It appears to be a general Problem with rt, making it unreliable and 
> difficult to use in a production environment.
>
> Luckily rt sends a mail with the problem to the root account.
>
> We routed this account to a public folder in our internal mail system 
> and set  up a team of people keying in the tickets not getting 
> recorded manually.
>
> Best regards
>
> TH
>
> Mathew Snyder schrieb:
>> A problem with transactions not being recorded reared its head in the 
>> last day
>> or two.  It appears that when an email is sent from RT it is not 
>> being added to
>> the ticket as a transaction.
>>
>> Unfortunately, I didn't have MySQL logging turned on so I don't have 
>> that
>> evidence to provide.  However, I have looked at the mail log and have 
>> verified
>> that emails were processed and have since turned MySQL logging on.
>>
>> While I'm waiting for further problems to occur so I can provide the 
>> query
>> errors, could anyone provide insight as to why this might be happening?
>>
>> Mathew
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>   
>
>