Sorry, but we don't use sun's apache nor sun's perl. Unfortunately this RT server is on one of the central staff servers so backing out patches would be a very problematic. I might test an RT install on a different box, just to see if it makes a difference.
<br><br>Thanks anyway,<br>Steve.<br><br><br><div><span class="gmail_quote">On 3/12/07, <b class="gmail_sendername"><a href="mailto:jmoseley@pgtv.com">jmoseley@pgtv.com</a></b> <<a href="mailto:jmoseley@pgtv.com">jmoseley@pgtv.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Again, I would back out of all Sun patches that anything to do with apache
<br>or perl, then see if things work - the problems did not start happening<br>until you applied those patches... It also appears you are using Sun's<br>perl and apache that came with Solaris 10 (or you managed to get from Sun)?
<br>If so, I would stronly recommend not using their packages and recompile<br>perl and apache (and other associated modules) from scratch.<br><br><br>James Moseley<br><br><br>James, thanks for your replies.<br><br>All:<br>
<br>[As a reminder I'm on Solaris 10, mysql 5.0.22, RT was 3.6.1, but is now<br>3.6.3]<br><br>I've been snooping around and can't find anything wrong which might cause<br>this. (I've googled, and searched the archives and the wiki.) I've checked
<br>the rt3 database. Unless RT is doing something funny, the db is ok. I.e. it<br>DOES support transactions (except for the sessions table which is a MyISAM<br>table) It DOES NOT get errors in mysql when I do a start transaction nor
<br>when I do a set autocommitt = 0;<br><br><br>The errors I get in the RT logs are:<br><br>Mar 12 10:46:12 localhost RT: Transaction not committed. Usually indicates<br>a software fault. Data loss may have occurred<br>(/opt/rt3/lib/RT/Interface/Web/Handler.pm:194)\n
<br><br>It is of mild curiosity that these errors are occuring on a timed basis<br>rather than on a usage basis. I.e. no one is actually using RT right now,<br>except when I'm testing it.<br><br>What I did this morning:
<br><br>I upgraded RT to 3.6.3, I re-installed DBD::mysql on the RT server, I've<br>restarted apache. and I'm still getting this error. I can see tickets in<br>RT, I just can't create new tickets or update existing ones.
<br><br>Here is the raw error as displayed in the browser from trying to create<br>just one ticket (sorry for the wrap, some of these lines are VERY long):<br><br></blockquote></div>