[Spce-user] 500 Internal Server error

[Daniel Grotti]

Hi,

Those stuck query are not normal, you must have a problem in myslq.
Can't be that an insert into acc table takes 101443sec!
Maybe you can take a look also into slow-query.log and mysql error.log


Daniel





--
Meet us @ ANGACOM: Hall 10.1/booth N10Exhibition and Congress for
Broadband, Cable & Satellite: 9-11 June 2015, Cologne
--

Daniel Grotti
VoIP Engineer

Phone: +43(0)1 301 2032
Email: dgrotti at sipwise.com
Website: www.sipwise.com

Particulars according Austrian Companies Code paragraph 14
"Sipwise GmbH“ - Europaring F15 – 2345 Brunn am Gebirge
FN:305595f, Commercial Court Vienna, ATU64002206

On 03/17/2015 10:50 PM, Tabi Tabe Tabi wrote:
> Correct Alex.
> 
> 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.
> 
> 
> Regards,
> 
> Tabi
> 
> 
> 
> On Tue, Mar 17, 2015 at 11:45 PM, Alexander Griesser <ag at anexia.at
> <mailto:ag at anexia.at>> wrote:
> 
>     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.).____
> 
>     __ __
> 
>     best,____
> 
>     __ __
> 
>     *Alexander Griesser____*
> 
>     Head of Systems Operations____
> 
>     __ __
> 
>     ANEXIA Internetdienstleistungs GmbH____
> 
>     __ __
> 
>     E-Mail: ag at anexia.at <mailto:ag at anexia.at>____
> 
>     Web: http://www.anexia.at <http://www.anexia.at/>____
> 
>     __ __
> 
>     Anschrift Hauptsitz Klagenfurt: Feldkirchnerstraße 140, 9020
>     Klagenfurt____
> 
>     Geschäftsführer: Alexander Windbichler____
> 
>     Firmenbuch: FN 289918a | Gerichtsstand: Klagenfurt | UID-Nummer: AT
>     U63216601____
> 
>     __ __
> 
>     *Von:*Spce-user [mailto:spce-user-bounces at lists.sipwise.com
>     <mailto:spce-user-bounces at lists.sipwise.com>] *Im Auftrag von *Tabi
>     Tabe Tabi
>     *Gesendet:* Dienstag, 17. März 2015 22:43
>     *An:* Daniel Grotti
>     *Cc:* spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com>
>     *Betreff:* Re: [Spce-user] 500 Internal Server error____
> 
>     __ __
> 
>     Update on this issue.____
> 
>     __ __
> 
>     I found that increasing the max_connections in mysql helped. I am
>     trying a few things and will update the forum after testing them.____
> 
>     __ __
> 
>     Regards,____
> 
>     __ __
> 
>     Tabi____
> 
>     ____
> 
>     __ __
> 
>     On Tue, Mar 17, 2015 at 7:14 PM, Daniel Grotti <dgrotti at sipwise.com
>     <mailto:dgrotti at sipwise.com>> wrote:____
> 
>         Please grep the incident number in panel.log and panel-debig.log.
> 
>         Daniel____
> 
>         On 17 Mar 2015 18:04, Tabi Tabe Tabi <tabi.tabe at gmail.com
>         <mailto:tabi.tabe at gmail.com>> wrote:
>         >
>         > Hi,
>         > 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? 
>         >
>         >
>         >
>         > 500 Internal server error
>         >
>         > We are terribly sorry, an exceptional error has occured:
>         >
>         > incident number: 13CC57719176611F
>         > time of incident: 2015-03-17T16:55:27.252979999Z
>         >
>         >
>         > If the login is successful, I get and NGINX bad gateway or
>         timeout error.
>         >
>         > The server is a VM and has 6GB or RAM, 4 Core processor and
>         80GB disk space. the resources are hardly being used up.
>         >
>         >
>         > --
>         > ...Tabi
>         >____
> 
> 
> 
>     ____
> 
>     __ __
> 
>     -- ____
> 
>     ...Tabi____
> 
>     __ __
> 
> 
> 
> 
> -- 
> ...Tabi
>