[rt-users] Transaction not being recorded

[Helmuth Ramirez]

Thanks Roy for your help on this again.  I did as you instructed, I am not getting anything in the log.  I am attaching a screenshot of my scrip, just so its clear what it is I'm doing.

And believe me, it was not a silly question...Linux/RT/Perl is a new world to me...there are no "obvious" questions in my book :-) 

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Roy El-Hames
Sent: Thursday, January 11, 2007 8:42 AM
To: tobias at formelheinz.de
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Transaction not being recorded

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

_______________________________________________
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: RT_Scrip.gif
Type: image/gif
Size: 9775 bytes
Desc: RT_Scrip.gif
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070111/dbd4c80f/attachment.gif>