<div dir="ltr">Hi Daniel,<div><br></div><div>We run SPCE of a VM (openstack) with 6GB RAM, 80GB HDD and 10gbps NIC.</div><div><br></div><div><br></div><div>What's interesting is that it ran for a long time with no issues and suddenly started have that error. Here is the resource utilization screen dump</div><div><br></div><div><br></div><div><div>root@sbc-1:~-> # df -h</div><div>Filesystem Size Used Avail Use% Mounted on</div><div>rootfs 79G 5.5G 70G 8% /</div><div>udev 10M 0 10M 0% /dev</div><div>tmpfs 599M 184K 599M 1% /run</div><div>/dev/disk/by-uuid/07741205-d163-44df-ad67-d1b19bf0afb3 79G 5.5G 70G 8% /</div><div>tmpfs 5.0M 0 5.0M 0% /run/lock</div><div>tmpfs 1.2G 0 1.2G 0% /run/shm</div></div><div><br></div><div><br></div><div><br></div><div><div>root@sbc-1:~-> # df -i</div><div>Filesystem Inodes IUsed IFree IUse% Mounted on</div><div>rootfs 5242880 87584 5155296 2% /</div><div>udev 763931 290 763641 1% /dev</div><div>tmpfs 765904 213 765691 1% /run</div><div>/dev/disk/by-uuid/07741205-d163-44df-ad67-d1b19bf0afb3 5242880 87584 5155296 2% /</div><div>tmpfs 765904 2 765902 1% /run/lock</div><div>tmpfs 765904 2 765902 1% /run/shm</div></div><div><br></div><div><br></div><div><br></div><div><div>root@sbc-1:~-> # free -m</div><div> total used free shared buffers cached</div><div>Mem: 5983 4803 1180 0 70 2297</div><div>-/+ buffers/cache: 2435 3548</div><div>Swap: 0 0 0</div></div><div><br></div><div>Regards,</div><div><br></div><div>Tabi</div><div><br></div><img src="http://t.signaletre.com/e1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v4LTTlW653lLR4X9P3HW64QWy01pctGFW2JNYSB1k1H6H0?si=6355392162955264&pi=214ff34f-65bd-4fee-aa71-33deaab1a449" style="display:none!important" height="1" width="1"></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 18, 2015 at 11:16 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">What are your system values ?<br>
Are they satisfying our minimum requirements ?<br>
<span class=""><br>
Daniel<br>
<br>
<br>
<br>
--<br>
Meet us @ ANGACOM: Hall 10.1/booth N10<br>
Exhibition and Congress for Broadband, Cable & Satellite: 9-11 June<br>
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>
<br>
</span><span class="">On 03/18/2015 10:14 AM, Tabi Tabe Tabi wrote:<br>
> Hi Daniel,<br>
><br>
> It is certainly a MySql problem. However we installed a new version of<br>
> SPCE and have exactly the same issue. The version of MySql is 5.5.40 an<br>
> SPCE is 3.7.1. Previous versions all exhibited the same problem.<br>
><br>
> I am thinking of using a script to kill all queries with time longer<br>
> than 200 secs as an interim work around. But would be nice to know why<br>
> this happens.<br>
><br>
><br>
> Regards,<br>
><br>
> Tabi<br>
><br>
</span><span class="">> On Wed, Mar 18, 2015 at 10:44 AM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a><br>
</span><span class="">> <mailto:<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>>> wrote:<br>
><br>
> 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>
</span>> Phone: <a href="tel:%2B43%280%291%20301%202032" value="+4313012032">+43(0)1 301 2032</a> <tel:%2B43%280%291%20301%202032><br>
> Email: <a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a> <mailto:<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>><br>
> Website: <a href="http://www.sipwise.com" target="_blank">www.sipwise.com</a> <<a href="http://www.sipwise.com" target="_blank">http://www.sipwise.com</a>><br>
<span class="">><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>
><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>
> > On Tue, Mar 17, 2015 at 11:45 PM, Alexander Griesser <<a href="mailto:ag@anexia.at">ag@anexia.at</a> <mailto:<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> <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>
> > (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>
</span>> <mailto:<a href="mailto:ag@anexia.at">ag@anexia.at</a> <mailto:<a href="mailto:ag@anexia.at">ag@anexia.at</a>>>____<br>
<span class="">> ><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>
> ><br>
> > Anschrift Hauptsitz Klagenfurt: Feldkirchnerstraße 140, 9020<br>
> > Klagenfurt____<br>
> ><br>
> > Geschäftsführer: Alexander Windbichler____<br>
> ><br>
> > Firmenbuch: FN 289918a | Gerichtsstand: Klagenfurt | UID-Nummer: AT<br>
> > 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>><br>
> > <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><br>
> <mailto:<a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a>><br>
</span>> <mailto:<a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<span class="">> <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>
> ><br>
> > I found that increasing the max_connections in mysql helped. I am<br>
> > trying a few things and will update the forum after testing<br>
> them.____<br>
> ><br>
> > __ __<br>
> ><br>
> > Regards,____<br>
> ><br>
> > __ __<br>
> ><br>
> > Tabi____<br>
> ><br>
> > ____<br>
> ><br>
> > __ __<br>
> ><br>
> > On Tue, Mar 17, 2015 at 7:14 PM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a> <mailto:<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>><br>
</span>> > <mailto:<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a> <mailto:<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>>>><br>
<span class="im HOEnZb">> wrote:____<br>
> ><br>
> > Please grep the incident number in panel.log and panel-debig.log.<br>
> ><br>
> > Daniel____<br>
> ><br>
> > On 17 Mar 2015 18:04, Tabi Tabe Tabi <<a href="mailto:tabi.tabe@gmail.com">tabi.tabe@gmail.com</a> <mailto:<a href="mailto:tabi.tabe@gmail.com">tabi.tabe@gmail.com</a>><br>
</span><div class="HOEnZb"><div class="h5">> > <mailto:<a href="mailto:tabi.tabe@gmail.com">tabi.tabe@gmail.com</a> <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>
> > >____<br>
> ><br>
> ><br>
> ><br>
> > ____<br>
> ><br>
> > __ __<br>
> ><br>
> > -- ____<br>
> ><br>
> > ...Tabi____<br>
> ><br>
> > __ __<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > ...Tabi<br>
> ><br>
><br>
><br>
><br>
><br>
> --<br>
> ...Tabi<br>
><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">...Tabi<div><br></div></div>
</div>