<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:"MS Gothic";
        panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Georgia;
        panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
        {font-family:Verdana;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:HelveticaNeue-Light;
        panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:"\@MS Gothic";
        panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p
        {mso-style-priority:99;
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR-CA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi all,<o:p></o:p></span></a></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thank you for your advice. &nbsp;I have noticed something in my error log.&nbsp; The &#8220;connection abort&#8221; errors always happen at
 the same intervals&#8230;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Here&#8217;s a look at a part of my log:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:38:11 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:39:55 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:40:10 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:41:55 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:42:11 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:43:54 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:44:10 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:45:53 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">[Mon Mar 27 13:46:10 2017] [error] Software caused connection abort at /eprints3/cgi/exportview line 108.\n<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">There&#8217;s 2 recurring time gaps (1 min 45 secs then 15 secs then it starts over.)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">I&#8217;m a little lost where I should look to pinpoint what is causing this&#8230;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">I looked at my crons jobs and nothing there.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">All help is appreciated!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thank you again!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black">Mathieu Perron</span></b><span style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black"><br>
Chargé de projet informatique et technologique<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black"><o:p>&nbsp;</o:p></span></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FR" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">De&nbsp;:</span></b><span lang="FR" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk]
<b>De la part de</b> Matthew Kerwin<br>
<b>Envoyé&nbsp;:</b> 27 mars 2017 07:06<br>
<b>À&nbsp;:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Objet&nbsp;:</b> Re: [EP-tech] Apache log getting a lot of errors and Mysql Going away<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div id="divtagdefaultwrapper">
<p><span style="font-family:&quot;Georgia&quot;,serif;color:navy">Yeah, for what it's worth we've had a history of these sorts of errors. Eventually I resolved a lot of it by reducing the number of Apache processes and recycling them a little more aggressively. &nbsp;In our
 case, it was a choice between: a few failed connects, or a lot of successful connects that don't go anywhere.<o:p></o:p></span></p>
<p><span style="font-family:&quot;Georgia&quot;,serif;color:navy"><o:p>&nbsp;</o:p></span></p>
<p><span style="font-family:&quot;Georgia&quot;,serif;color:navy">Your mileage may vary, of course.<o:p></o:p></span></p>
<p><span style="font-family:&quot;Georgia&quot;,serif;color:navy"><o:p>&nbsp;</o:p></span></p>
<p><span style="font-family:&quot;Georgia&quot;,serif;color:navy">Cheers<o:p></o:p></span></p>
<div id="Signature">
<p class="MsoNormal"><span lang="EN-AU" style="font-size:6.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#44546A">--
</span><span style="color:navy"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:gray">Matthew</span></b><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:gray">&nbsp;<b>Kerwin</b>&nbsp; |</span><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#7A7A7A">&nbsp;
</span><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:gray">Senior Web&nbsp;Developer</span><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:#7A7A7A">&nbsp;
</span><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:gray">|</span><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;MS Gothic&quot;;color:white"> &nbsp;</span><span style="color:navy"><a href="https://wiki.qut.edu.au/display/lib/Digital&#43;Repository&#43;Team" title="Digital Repository Team" id="LPNoLP"><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:gray;text-decoration:none">Applications
 &amp; Development</span><span lang="EN-AU" style="font-size:10.0pt;font-family:&quot;Verdana&quot;,sans-serif;color:gray;text-decoration:none">&nbsp;</span></a><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:&quot;Georgia&quot;,serif;color:navy"><o:p>&nbsp;</o:p></span></p>
<div>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-family:&quot;Georgia&quot;,serif;color:black">
<hr size="2" width="98%" align="center">
</span></div>
<div id="x_divRplyFwdMsg">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:black">
<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a> &lt;<a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a>&gt; on behalf of Yuri &lt;<a href="mailto:yurj@alfa.it">yurj@alfa.it</a>&gt;<br>
<b>Sent:</b> 27 March 2017 17:03<br>
<b>To:</b> <a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><br>
<b>Subject:</b> Re: [EP-tech] Apache log getting a lot of errors and Mysql Going away</span><span style="font-family:&quot;Georgia&quot;,serif;color:black">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:&quot;Georgia&quot;,serif;color:black">&nbsp;<o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Georgia&quot;,serif;color:black">I think it happens when you've a lot of connections on mysql. Rise up
<br>
the number of connection in mysql and use some script in a cronjob to <br>
check if mysql has gone away and notify you.<br>
<br>
The problem can go even worse when you've a lot of Apache threads and it <br>
eats al the RAM available, you've to rise or lower the apache threads <br>
according to the load.<br>
<br>
<br>
Il 24/03/2017 19:26, Mathieu Perron ha scritto:<br>
&gt;<br>
&gt; Hi,<br>
&gt;<br>
&gt; We are using ePrints v3.3.13 and lately we have been experiencing some <br>
&gt; crashes due to MySQL going away.&nbsp; I looked in the Apache log and I see <br>
&gt; a lot of the following errors:<br>
&gt;<br>
&gt; &#8220;[error] Software caused connection abort at /eprints3/cgi/exportview <br>
&gt; line 108.\n&#8221;<br>
&gt;<br>
&gt; I looked at the cgi script and searched in the files and this script <br>
&gt; has something to do with the Views.pm module.&nbsp; I can&#8217;t seem to make <br>
&gt; the error happen on demand and I&#8217;m wondering if anyone could help me <br>
&gt; with this.&nbsp; I don&#8217;t know if the MySQL server going away is related to <br>
&gt; these errors or not.<br>
&gt;<br>
&gt; Thank you for your time!<br>
&gt;<br>
&gt; *Mathieu Perron*<br>
&gt; Chargé de projet informatique et technologique<br>
&gt;<br>
&gt;<br>
&gt; Service des technologies de l'information<br>
&gt; Université du Québec à Chicoutimi<br>
&gt; 555, boul. de l'Université<br>
&gt; Chicoutimi (Québec) G7H 2B1<br>
&gt;<br>
&gt; <a href="mailto:*Mathieu_Perron@uqac.ca*">*Mathieu_Perron@uqac.ca*</a> &lt;<a href="mailto:Mathieu_Perron@uqac.ca">mailto:Mathieu_Perron@uqac.ca</a>&gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; *logo uqac* &lt;<a href="http://www.uqac.ca/">http://www.uqac.ca/</a>&gt;<br>
&gt;<br>
&gt; Le présent document (y compris les pièces qui y sont annexées, le cas <br>
&gt; échéant) s'adresse au destinataire indiqué et peut contenir des <br>
&gt; renseignements de caractère privé ou confidentiel. Si vous n'êtes pas <br>
&gt; le destinataire de ce document, nous vous signalons qu'il est <br>
&gt; strictement interdit de le diffuser, de le distribuer ou de le <br>
&gt; reproduire. Si ce message vous a été transmis par erreur, veuillez en <br>
&gt; informer l'expéditeur et le supprimer immédiatement. Avant d'imprimer, <br>
&gt; pensez à l'environnement!<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
&gt; *** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
&gt; *** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
&gt; *** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
<br>
<br>
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>