<div dir="ltr">Hi Daniel,<div><br></div><div>It is certainly a MySql problem. However we installed a new version of SPCE and have exactly the same issue. The version of MySql is 5.5.40 an SPCE is 3.7.1. Previous versions all exhibited the same problem.</div><div><br></div><div>I am thinking of using a script to kill all queries with time longer than 200 secs as an interim work around. But would be nice to know why this happens.</div><div><br></div><div><br></div><div>Regards,</div><div><br></div><div>Tabi</div><img src="http://t.signaletre.com/e1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v4LTTlW653lLR4X9P3HW64QWy01pctGFW2JNYSB1k1H6H0?si=6355392162955264&pi=7277c0ae-edd9-4530-9918-0f7adb31e1c5" style="display:none!important" height="1" width="1"></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 18, 2015 at 10:44 AM, Daniel Grotti <span dir="ltr"><<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Those stuck query are not normal, you must have a problem in myslq.<br>
Can't be that an insert into acc table takes 101443sec!<br>
Maybe you can take a look also into slow-query.log and mysql error.log<br>
<br>
<br>
Daniel<br>
<br>
<br>
<br>
<br>
<br>
--<br>
Meet us @ ANGACOM: Hall 10.1/booth N10Exhibition and Congress for<br>
Broadband, Cable & Satellite: 9-11 June 2015, Cologne<br>
--<br>
<br>
Daniel Grotti<br>
VoIP Engineer<br>
<br>
Phone: <a href="tel:%2B43%280%291%20301%202032" value="+4313012032">+43(0)1 301 2032</a><br>
Email: <a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a><br>
Website: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a><br>
<br>
Particulars according Austrian Companies Code paragraph 14<br>
"Sipwise GmbH“ - Europaring F15 – 2345 Brunn am Gebirge<br>
FN:305595f, Commercial Court Vienna, ATU64002206<br>
<span class=""><br>
On 03/17/2015 10:50 PM, Tabi Tabe Tabi wrote:<br>
> Correct Alex.<br>
><br>
> So far I have traced them to error writing communication packets. On of<br>
> the things I will do is to update the max_allowed_packet value to the<br>
> number of INSERT queries SPCE runs for each transaction. I will see if<br>
> this makes any difference.<br>
><br>
><br>
> Regards,<br>
><br>
> Tabi<br>
><br>
><br>
><br>
</span><span class="">> On Tue, Mar 17, 2015 at 11:45 PM, Alexander Griesser <<a href="mailto:ag@anexia.at">ag@anexia.at</a><br>
</span><span class="">> <mailto:<a href="mailto:ag@anexia.at">ag@anexia.at</a>>> wrote:<br>
><br>
> Well, the problem ist, that all the queries that are hanging here<br>
> are INSERT queries into the acc table, so they’re just hanging and<br>
> are not able to finish, so you will likely experience data loss<br>
</span>> (i.e. calls not properly recorded, etc.).____<br>
><br>
> __ __<br>
><br>
> best,____<br>
><br>
> __ __<br>
><br>
> *Alexander Griesser____*<br>
><br>
> Head of Systems Operations____<br>
><br>
> __ __<br>
><br>
> ANEXIA Internetdienstleistungs GmbH____<br>
><br>
> __ __<br>
><br>
> E-Mail: <a href="mailto:ag@anexia.at">ag@anexia.at</a> <mailto:<a href="mailto:ag@anexia.at">ag@anexia.at</a>>____<br>
><br>
> Web: <a href="http://www.anexia.at" target="_blank">http://www.anexia.at</a> <<a href="http://www.anexia.at/" target="_blank">http://www.anexia.at/</a>>____<br>
><br>
> __ __<br>
<span class="">><br>
> Anschrift Hauptsitz Klagenfurt: Feldkirchnerstraße 140, 9020<br>
</span>> Klagenfurt____<br>
><br>
> Geschäftsführer: Alexander Windbichler____<br>
<span class="">><br>
> Firmenbuch: FN 289918a | Gerichtsstand: Klagenfurt | UID-Nummer: AT<br>
</span>> U63216601____<br>
><br>
> __ __<br>
><br>
> *Von:*Spce-user [mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com">spce-user-bounces@lists.sipwise.com</a><br>
> <mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com">spce-user-bounces@lists.sipwise.com</a>>] *Im Auftrag von *Tabi<br>
> Tabe Tabi<br>
> *Gesendet:* Dienstag, 17. März 2015 22:43<br>
> *An:* Daniel Grotti<br>
> *Cc:* <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a> <mailto:<a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a>><br>
> *Betreff:* Re: [Spce-user] 500 Internal Server error____<br>
><br>
> __ __<br>
><br>
> Update on this issue.____<br>
><br>
> __ __<br>
<span class="">><br>
> I found that increasing the max_connections in mysql helped. I am<br>
</span>> trying a few things and will update the forum after testing them.____<br>
><br>
> __ __<br>
><br>
> Regards,____<br>
><br>
> __ __<br>
><br>
> Tabi____<br>
><br>
> ____<br>
><br>
> __ __<br>
<span class="">><br>
> On Tue, Mar 17, 2015 at 7:14 PM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a><br>
</span>> <mailto:<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>>> wrote:____<br>
<span class="">><br>
> Please grep the incident number in panel.log and panel-debig.log.<br>
><br>
</span>> Daniel____<br>
<span class="">><br>
> On 17 Mar 2015 18:04, Tabi Tabe Tabi <<a href="mailto:tabi.tabe@gmail.com">tabi.tabe@gmail.com</a><br>
</span><span class="">> <mailto:<a href="mailto:tabi.tabe@gmail.com">tabi.tabe@gmail.com</a>>> wrote:<br>
> ><br>
> > Hi,<br>
> > I am running SPCE 3.7.1. I get 500 Internal server error when<br>
> login to the admin web portal. After logging out and try to<br>
> login again, still get the same error below. Any ideas on the<br>
> 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<br>
> timeout error.<br>
> ><br>
> > The server is a VM and has 6GB or RAM, 4 Core processor and<br>
> 80GB disk space. the resources are hardly being used up.<br>
> ><br>
> ><br>
> > --<br>
> > ...Tabi<br>
</span>> >____<br>
><br>
><br>
><br>
> ____<br>
><br>
> __ __<br>
><br>
> -- ____<br>
><br>
> ...Tabi____<br>
><br>
> __ __<br>
><br>
><br>
><br>
<span class="HOEnZb"><font color="#888888">><br>
> --<br>
> ...Tabi<br>
><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">...Tabi<div><br></div></div>
</div>