[Spce-user] SIP Error 500 Internal Error

[Tabi Tabe Tabi]

Here is the screen dump.



On Sun, Mar 1, 2015 at 7:46 PM, Tabi Tabe Tabi <tabi.tabe at gmail.com> wrote:

> Hi mates,
>
> We build a new SPCE server with 8GB RAM and enough HDD. Clean install and
> MySql failed to start during bootup. Same as the old server. SPCE 3.7.1
>
> Previously it straight from build to processing live traffic took less
> than an hour. We have compared all the MySQL version and running V5.5.40.
>
> What have we missed?
>
> Your feedback is much apprecaited.
>
> Regards,
>
> Tabi
>
> On Sun, Mar 1, 2015 at 1:13 PM, Tabi Tabe <tabi.tabe at gmail.com> wrote:
>
>> We noticed now that after restarting the server, MySQL failed to start.
>>
>> Tried several times still won't start.
>>
>> Tabi
>> ------------------------------
>> From: Daniel Grotti <dgrotti at sipwise.com>
>> Sent: ‎3/‎1/‎2015 11:37
>> To: Tabi Tabe Tabi <tabi.tabe at gmail.com>
>> Cc: William Fulton <wfulton at thirdhatch.com>; spce-user at lists.sipwise.com
>>
>> Subject: Re: [Spce-user] SIP Error 500 Internal Error
>>
>> Tabi,
>> Kamailio-proxy.log and lb log would help.
>>
>> Daniel
>> On 1 Mar 2015 08:39, Tabi Tabe Tabi <tabi.tabe at gmail.com> wrote:
>> >
>> > Got enough resources. 50% of memory still available and only 10% of
>> disk used.
>> >
>> > On Sun, Mar 1, 2015 at 8:45 AM, William Fulton <wfulton at thirdhatch.com>
>> wrote:
>> >>
>> >> Yeah, I would check resources.
>> >>
>> >>
>> >>
>> >> From: Tabi Tabe Tabi [mailto:tabi.tabe at gmail.com]
>> >> Sent: Saturday, February 28, 2015 10:33 PM
>> >>
>> >>
>> >> To: William Fulton
>> >> Cc: spce-user at lists.sipwise.com
>> >> Subject: Re: [Spce-user] SIP Error 500 Internal Error
>> >>
>> >>
>> >>
>> >> I am checking memory utilization to see whether it could be running
>> low and causing the MySql to fail on insert.
>> >>
>> >>
>> >>
>> >> On Sun, Mar 1, 2015 at 8:05 AM, William Fulton <wfulton at thirdhatch.com>
>> wrote:
>> >>
>> >> Are you running this on a VM?
>> >>
>> >>
>> >>
>> >> From: Tabi Tabe Tabi [mailto:tabi.tabe at gmail.com]
>> >> Sent: Saturday, February 28, 2015 9:58 PM
>> >> To: William Fulton
>> >> Cc: spce-user at lists.sipwise.com
>> >> Subject: Re: [Spce-user] SIP Error 500 Internal Error
>> >>
>> >>
>> >>
>> >> Thanks William.
>> >>
>> >> I'd been tailing the Kamailio log file and using grep to show only for
>> particular string.
>> >>
>> >>
>> >>
>> >> I found database insert errors before SPCE drops the call.
>> >>
>> >> Mar  1 07:46:44 sipbc-2 proxy[4581]: ERROR: db_mysql [km_dbase.c:122]:
>> db_mysql_submit_query(): driver error on query: Lost connection to MySQL
>> server during query
>> >>
>> >>
>> >>
>> >> Then the next call comes through and is successful.
>> >>
>> >> It looks like a MySQL error. The Service is running fine.
>> >>
>> >> Any ideas how to resolve this one?
>> >>
>> >> Much appreciated.
>> >>
>> >> Tabi
>> >>
>> >>
>> >>
>> >> On Sun, Mar 1, 2015 at 4:06 AM, William Fulton <wfulton at thirdhatch.com>
>> wrote:
>> >>
>> >> Tail the kamailio log when the calls are being rejected and see why:
>> >>
>> >>
>> >>
>> >> tail -f /var/log/ngcp/kamailio-proxy.log
>> >>
>> >>
>> >>
>> >> Best Regards,
>> >>
>> >> William
>> >>
>> >>
>> >>
>> >> From: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] On
>> Behalf Of Tabi Tabe Tabi
>> >> Sent: Saturday, February 28, 2015 2:40 PM
>> >> To: spce-user at lists.sipwise.com
>> >> Subject: [Spce-user] SIP Error 500 Internal Error
>> >>
>> >>
>> >>
>> >> Hi,
>> >>
>> >> Does anyone know what would cause SPCE to reject a call with error
>> code 500 Internal error?
>> >>
>> >> So calls are dropped and some are processed.
>> >>
>> >> Thanks.
>> >>
>> >>
>> >> --
>> >>
>> >> ...Tabi
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >>
>> >> ...Tabi
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >>
>> >> ...Tabi
>> >>
>> >>
>> >
>> >
>> >
>> >
>> > --
>> > ...Tabi
>> >
>>
>
>
>
> --
> ...Tabi
>
>


-- 
...Tabi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150301/6ebb390e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: MySQL error.PNG
Type: image/png
Size: 16677 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150301/6ebb390e/attachment-0001.PNG>