<div dir="ltr">Correct Alex.<div><br></div><div>So far I have traced them to error writing communication packets. On of the things I will do is to update the max_allowed_packet value to the number of INSERT queries SPCE runs for each transaction. I will see if this makes any difference.</div><div><br></div><div><br></div><div>Regards,</div><div><br></div><div>Tabi</div><div><br></div><div><pre class="" style="margin-top:0px;padding:5px;border:0px;font-size:13px;overflow:auto;width:auto;max-height:600px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;color:rgb(57,51,24);word-wrap:normal;background-color:rgb(238,238,238)"><br></pre></div><img src="http://t.signaletre.com/e1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v4LTTlW653lLR4X9P3HW64QWy01pctGFW2JNYSB1k1H6H0?si=6355392162955264&pi=3708257a-0f6a-4f67-ea80-514543c95e1d" style="display:none!important" height="1" width="1"></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 17, 2015 at 11:45 PM, Alexander Griesser <span dir="ltr"><<a href="mailto:ag@anexia.at" target="_blank">ag@anexia.at</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="DE" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Well, the problem ist, that all the queries that are hanging here are INSERT queries into the acc table, so they’re just hanging and
are not able to finish, so you will likely experience data loss (i.e. calls not properly recorded, etc.).<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">best,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="DE-AT" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Alexander Griesser<u></u><u></u></span></b></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black">Head of Systems Operations<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">ANEXIA Internetdienstleistungs GmbH<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black">E-Mail:
<a href="mailto:ag@anexia.at" target="_blank">ag@anexia.at</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black">Web:
<a href="http://www.anexia.at/" target="_blank">http://www.anexia.at</a><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:black"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#595959">Anschrift Hauptsitz Klagenfurt: Feldkirchnerstraße 140, 9020 Klagenfurt<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#595959">Geschäftsführer: Alexander Windbichler<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#595959">Firmenbuch: FN 289918a | Gerichtsstand: Klagenfurt | UID-Nummer: AT U63216601<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
</span><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Von:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Spce-user [mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>]
<b>Im Auftrag von </b>Tabi Tabe Tabi<br>
<b>Gesendet:</b> Dienstag, 17. März 2015 22:43<br>
<b>An:</b> Daniel Grotti<span class=""><br>
<b>Cc:</b> <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br>
<b>Betreff:</b> Re: [Spce-user] 500 Internal Server error<u></u><u></u></span></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Update on this issue.<u></u><u></u></p><div><div class="h5">
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I found that increasing the max_connections in mysql helped. I am trying a few things and will update the forum after testing them.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Regards,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Tabi<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u><u></u></p>
</div></div></div><div><div class="h5">
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Tue, Mar 17, 2015 at 7:14 PM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Please grep the incident number in panel.log and panel-debig.log.<br>
<span style="color:#888888"><br>
<span>Daniel</span></span><u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">On 17 Mar 2015 18:04, Tabi Tabe Tabi <<a href="mailto:tabi.tabe@gmail.com" target="_blank">tabi.tabe@gmail.com</a>> wrote:<br>
><br>
> Hi,<br>
> I am running SPCE 3.7.1. I get 500 Internal server error when login to the admin web portal. After logging out and try to login again, still get the same error below. Any ideas on the cause and how to fix it? <br>
><br>
><br>
><br>
> 500 Internal server error<br>
><br>
> We are terribly sorry, an exceptional error has occured:<br>
><br>
> incident number: 13CC57719176611F<br>
> time of incident: 2015-03-17T16:55:27.252979999Z<br>
><br>
><br>
> If the login is successful, I get and NGINX bad gateway or timeout error.<br>
><br>
> The server is a VM and has 6GB or RAM, 4 Core processor and 80GB disk space. the resources are hardly being used up.<br>
><br>
><br>
> --<br>
> ...Tabi<br>
><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<p class="MsoNormal">...Tabi<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">...Tabi<div><br></div></div>
</div>