[Spce-user] SQL Errors

[Jon Bonilla (Manwe)]

El Wed, 6 Feb 2013 13:44:13 -0700
"Maxwell Power" <mpower at entelit.ca> escribió:

> Hello,
> 
>  
> 
> We have been experiencing intermittent SQL errors:
> 
>  
> 
> Feb  6 15:38:51 mci1 /usr/sbin/kamailio[2316]: INFO: <script>: New request -
> M=BYE R=sip:mod_sofia at 69.147.236.18:5060 F=sip:17804178484 at sip.altatel.ca
> T=sip:7804535973 at sip.altatel.ca IP=127.0.0.1:5080 (127.0.0.1:5080)
> ID=bdb9c21d-eb3f-1230-1b8f-f978dce378cb
> 
> Feb  6 15:38:51 mci1 /usr/sbin/kamailio[2316]: INFO: <script>: Stop
> mediaproxy for all branches - R=sip:mod_sofia at 69.147.236.18:5060
> ID=bdb9c21d-eb3f-1230-1b8f-f978dce378cb
> 
> Feb  6 15:38:51 mci1 /usr/sbin/kamailio[2316]: INFO: <script>: Relaying
> request, du='sip:127.0.0.1;r2=on;lr=on;ftag=jQ8BB4Zrt72Dr;ngcplb=yes' -
> R=sip:mod_sofia at 69.147.236.18:5060 ID=bdb9c21d-eb3f-1230-1b8f-f978dce378cb
> 
> Feb  6 15:38:51 mci1 /usr/sbin/kamailio[2305]: INFO: <script>: NAT-Reply -
> S=200 - OK M=BYE IP=127.0.0.1:5080 (127.0.0.1:5060)
> ID=bdb9c21d-eb3f-1230-1b8f-f978dce378cb
> 
> Feb  6 15:38:57 mci1 /usr/sbin/kamailio[2305]: ERROR: db_mysql
> [km_dbase.c:122]: driver error on query: Lost connection to MySQL server
> during query
> 
> Feb  6 15:38:57 mci1 /usr/sbin/kamailio[2305]: ERROR: <core>
> [db_query.c:210]: error while submitting query
> 
> Feb  6 15:38:57 mci1 /usr/sbin/kamailio[2305]: ERROR: acc [acc.c:435]:
> failed to insert into database
> 
>  
> 
> We have tried reinstalling from scratch but still continue to get these
> errors on calls and registrations. Call logs sometimes get duplicated and
> registrations fail intermittently.
> 


Any check about high load? Errors in mysql log? Anything in the system logs?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130206/1afb7504/attachment-0001.asc>