MY MISTAKE!!! This was a response to a different topic Roy had responded to, sorry!!
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Helmuth Ramirez Sent: Thursday, January 11, 2007 9:05 AM To: Roy El-Hames; [EMAIL PROTECTED] Cc: [email protected] Subject: RE: [rt-users] Transaction not being recorded 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roy El-Hames Sent: Thursday, January 11, 2007 8:42 AM To: [EMAIL PROTECTED] Cc: [email protected] 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: [EMAIL PROTECTED] >> >> >> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
