<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* 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;}
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'>While I am generally please with Request Tracker V3, and I
know it is free software and does more than commercial products selling for
thousands of dollars, it does have it glitches. We are running RT-3.4.4, MySQL
V4.1.5, Apache 2.0.55, mod_per2, perl 5.8.7, DBIx-SearchBuilder-1.35.<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'>We get hundreds of tickets per day, without any issues. So
far, since we upgraded to 3.4.4 from 2.x, we have had about 25 incidents out of
2500+ tickets submitted (since 21 December, 2005) with the following result:<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>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana;font-weight:bold'>error:</span></font></b><font size=1
face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>DBD::mysql::st execute failed: MySQL server has gone
away at /usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm
line 70.</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana;font-weight:bold'>context:</span></font></b><font size=1
face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>...</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>66:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>if ($self->{lock}) {</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>67:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>local $self->{dbh}->{RaiseError} = 1;</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>68:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>69:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>my $sth = $self->{dbh}->prepare_cached(q{SELECT
RELEASE_LOCK(?)}, {}, 1);</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>70:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 color=red face=Verdana><span
style='font-size:7.5pt;font-family:Verdana;color:red'>$sth->execute($self->{lockid});</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>71:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>72:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>$self->{lock} = 0;</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>73:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>} </span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>74:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>}</span></font><o:p></o:p></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>...</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana;font-weight:bold'>code stack:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:70<br>
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:81<br>
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm:87<br>
/usr/local/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm:1258</span></font><o:p></o:p></p>
</td>
</tr>
</table>
<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 it sends out e-mail to everyone and the
ticket never is created in the database.<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'>As far as the system goes, the MySQL server and the various
software components are not being restarted or manipulated in any way. It
looking at /var/log/messages, it looks like Request Tracker cannot access the
MySQL server. Yet, the MySQL logs indicate there are no errors related to the software.
Matter of, the only thing in the logs was when the server was started.<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'>Any information about this issue would be most helpful.<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>
</div>
</body>
</html>