<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi Everyone,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>A few weeks ago I sent in a message similar to the problem I
am about to describe. So, I hope someone can tell me a work around, as this
problem is very annoying.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>A user uses the web interface to enter a ticket, as far as
the user is concerned the ticket was entered properly and is happily on its way
of being taken care of. It looks like the ticket made it because e-mails are
sent to the proper parties and everything is all right with the world. Like the
clichés?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Anyway, behind the scenes the ticket never makes it in the
database. The only record of this happening is that in /var/log/.messages (we
are using linux), several errors messages are generated starting with “MySQL
server has gone away”. So, all the inserts and updates going to the
database are dropped and no ticket is anywhere to be found.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The worse part about this error, it only happens less than 1%
of the time.(35 times out of 3500 tickets created). <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have check the database, web server and other system logs
and there is nothing indicating a problem. I also checked the database
structure and tables in MySQL.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am running RT 3.4.4 with RTx::SearchBuilder 1.39, mysql
4.1.15, RTFM 2.1.40, RTx::AssetTracker 1.2.2, RTx::RightsMatrix 0.02.05,
RTx::Statistics 1.18, Apache 2.0.55, mod_perl2, perl 5.8.7. The only thing to
add is that I upgraded from RT V2 back in December.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The bottom line, short of trying to figure out
RTx::SearchBuilder, I have trie deverything I can think of.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Anyway, ideas would be welcome, as well as solutions to this
rather nagging problem.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Take care!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Nick<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:7.5pt;font-family:Arial;font-weight:bold'>---------------------------------------------------------------------------------</span></font></b><o:p></o:p></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:8.0pt;font-family:Arial;font-weight:bold'>Nick
Metrowsky</span></font></b><b><font size=1><span style='font-size:8.0pt;
font-weight:bold'><o:p></o:p></span></font></b></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:8.0pt;font-family:Arial;font-weight:bold'>Consulting
System Administrator</span></font></b><b><font size=1><span style='font-size:
8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:8.0pt;font-family:Arial;font-weight:bold'>303-684-4785
Office</span></font></b><b><font size=1><span style='font-size:8.0pt;
font-weight:bold'><o:p></o:p></span></font></b></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:8.0pt;font-family:Arial;font-weight:bold'>303-684-4100
Fax</span></font></b><b><font size=1><span style='font-size:8.0pt;font-weight:
bold'><o:p></o:p></span></font></b></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:8.0pt;font-family:Arial;font-weight:bold'><a
href="mailto:nmetrowsky@digitalglobe.com"><font size=1><span style='font-size:
7.5pt'>nmetrowsky@digitalglobe.com</span></font></a></span></font></b><b><font
size=1><span style='font-size:8.0pt;font-weight:bold'><o:p></o:p></span></font></b></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:7.5pt;font-family:Arial;font-weight:bold'>DigitalGlobe
®, An Imaging and Information Company</span></font></b><o:p></o:p></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:8.0pt;font-family:Arial;font-weight:bold'><a
href="http://www.digitalglobe.com"><font size=1><span style='font-size:7.5pt'>http://www.digitalglobe.com</span></font></a></span></font></b><o:p></o:p></p>
<p style='margin:0in;margin-bottom:.0001pt;text-indent:-7.5pt'><b><font size=1
face=Arial><span style='font-size:7.5pt;font-family:Arial;font-weight:bold'>---------------------------------------------------------------------------------</span></font></b><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>