<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body><div><div style="font-family: Calibri,sans-serif; font-size: 11pt;">We noticed now that after restarting the server, MySQL failed to start.<br><br>Tried several times still won't start.<br><br>Tabi</div></div><div dir="ltr"><hr><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">From: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="mailto:dgrotti@sipwise.com">Daniel Grotti</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Sent: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;">3/1/2015 11:37</span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">To: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="mailto:tabi.tabe@gmail.com">Tabi Tabe Tabi</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Cc: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;"><a href="mailto:wfulton@thirdhatch.com">William Fulton</a>; <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a></span><br><span style="font-family: Calibri,sans-serif; font-size: 11pt; font-weight: bold;">Subject: </span><span style="font-family: Calibri,sans-serif; font-size: 11pt;">Re: [Spce-user] SIP Error 500 Internal Error</span><br><br></div>Tabi,<br>Kamailio-proxy.log and lb log would help.<br><br>Daniel<br>On 1 Mar 2015 08:39, Tabi Tabe Tabi <tabi.tabe@gmail.com> wrote:<br>><br>> Got enough resources. 50% of memory still available and only 10% of disk used.<br>><br>> On Sun, Mar 1, 2015 at 8:45 AM, William Fulton <wfulton@thirdhatch.com> wrote:<br>>><br>>> Yeah, I would check resources.<br>>><br>>> <br>>><br>>> From: Tabi Tabe Tabi [mailto:tabi.tabe@gmail.com] <br>>> Sent: Saturday, February 28, 2015 10:33 PM<br>>><br>>><br>>> To: William Fulton<br>>> Cc: spce-user@lists.sipwise.com<br>>> Subject: Re: [Spce-user] SIP Error 500 Internal Error<br>>><br>>> <br>>><br>>> I am checking memory utilization to see whether it could be running low and causing the MySql to fail on insert.<br>>><br>>> <br>>><br>>> On Sun, Mar 1, 2015 at 8:05 AM, William Fulton <wfulton@thirdhatch.com> wrote:<br>>><br>>> Are you running this on a VM?<br>>><br>>> <br>>><br>>> From: Tabi Tabe Tabi [mailto:tabi.tabe@gmail.com] <br>>> Sent: Saturday, February 28, 2015 9:58 PM<br>>> To: William Fulton<br>>> Cc: spce-user@lists.sipwise.com<br>>> Subject: Re: [Spce-user] SIP Error 500 Internal Error<br>>><br>>> <br>>><br>>> Thanks William.<br>>><br>>> I'd been tailing the Kamailio log file and using grep to show only for particular string.<br>>><br>>> <br>>><br>>> I found database insert errors before SPCE drops the call.<br>>><br>>> 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<br>>><br>>> <br>>><br>>> Then the next call comes through and is successful.<br>>><br>>> It looks like a MySQL error. The Service is running fine.<br>>><br>>> Any ideas how to resolve this one?<br>>><br>>> Much appreciated.<br>>><br>>> Tabi<br>>><br>>> <br>>><br>>> On Sun, Mar 1, 2015 at 4:06 AM, William Fulton <wfulton@thirdhatch.com> wrote:<br>>><br>>> Tail the kamailio log when the calls are being rejected and see why:<br>>><br>>> <br>>><br>>> tail -f /var/log/ngcp/kamailio-proxy.log<br>>><br>>> <br>>><br>>> Best Regards,<br>>><br>>> William<br>>><br>>> <br>>><br>>> From: Spce-user [mailto:spce-user-bounces@lists.sipwise.com] On Behalf Of Tabi Tabe Tabi<br>>> Sent: Saturday, February 28, 2015 2:40 PM<br>>> To: spce-user@lists.sipwise.com<br>>> Subject: [Spce-user] SIP Error 500 Internal Error<br>>><br>>> <br>>><br>>> Hi,<br>>><br>>> Does anyone know what would cause SPCE to reject a call with error code 500 Internal error?<br>>><br>>> So calls are dropped and some are processed.<br>>><br>>> Thanks.<br>>><br>>><br>>> --<br>>><br>>> ...Tabi<br>>><br>>> <br>>><br>>><br>>><br>>><br>>> --<br>>><br>>> ...Tabi<br>>><br>>> <br>>><br>>><br>>><br>>><br>>> --<br>>><br>>> ...Tabi<br>>><br>>> <br>><br>><br>><br>><br>> -- <br>> ...Tabi<br>><br></body></html>