[Spce-user] 500 Internal Server error
Daniel Grotti
dgrotti at sipwise.com
Wed Mar 18 05:16:33 EDT 2015
What are your system values ?
Are they satisfying our minimum requirements ?
Daniel
--
Meet us @ ANGACOM: Hall 10.1/booth N10
Exhibition 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/18/2015 10:14 AM, Tabi Tabe Tabi wrote:
> Hi Daniel,
>
> 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.
>
> 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.
>
>
> Regards,
>
> Tabi
>
> On Wed, Mar 18, 2015 at 10:44 AM, Daniel Grotti <dgrotti at sipwise.com
> <mailto:dgrotti at sipwise.com>> wrote:
>
> 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 <tel:%2B43%280%291%20301%202032>
> Email: dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>
> Website: www.sipwise.com <http://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>
> > <mailto: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>
> <mailto: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>
> > <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>
> <mailto: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>
> > <mailto: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>
> > <mailto: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
> >
>
>
>
>
> --
> ...Tabi
>
More information about the Spce-user
mailing list