[Spce-user] kamailio-proxy.log error - mysql lost connection

[Martin Wong]

Nothing in the mysqld.err that stands out. After a reboot, the issue goes
away.

Not sure why.

There's dialer traffic which makes lots of calls which probably is the
cause. Not to say that the server load is very high... the CPU is quite low.

Do you think it's because it's a virtual machine?



On Mon, May 27, 2013 at 10:56 PM, Andrew Pogrebennyk <
apogrebennyk at sipwise.com> wrote:

> I think either MySQL went down, or it is overloaded.. Is there anything
> in /var/log/mysql/mysqld.err during this time period?
>
> On 05/27/2013 02:42 PM, Martin Wong wrote:
> > Hi guys, any idea how to figure our what's happening with the ERROR here
> > for MYSQL? Is it due to the SPCE on a Virtual machine?
> >
> > May 27 22:38:27 km1 /usr/sbin/kamailio[10010]: INFO: <script>: IP
> > authorization not provisioned, allow registration - R=sip:x.x.x.x:5060
> > ID=OWM0ZmRjNjkzMTE3NDdhYTczY2QwOTRkZDk4NGU2Y2I.
> > May 27 22:38:27 km1 /usr/sbin/kamailio[10010]: INFO: <script>: Load
> > caller preferences for uuid '9ae3c690-29b0-4e05-9118-cc5a050446a8' and
> > domain part of uri 'sip:manbound at 4x.x.x.x:5060' - R=sip:x.x.x.x:5060
> > ID=OWM0ZmRjNjkzMTE3NDdhYTczY2QwOTRkZDk4NGU2Y2I.
> > May 27 22:38:29 km1 /usr/sbin/kamailio[10008]: ERROR: db_mysql
> > [km_dbase.c:122]: driver error on query: Lost connection to MySQL server
> > during query
> > May 27 22:38:29 km1 /usr/sbin/kamailio[10008]: ERROR: <core>
> > [db_query.c:312]: error while submitting query
> > May 27 22:38:29 km1 /usr/sbin/kamailio[10008]: ERROR: usrloc
> > [ucontact.c:732]: updating database failed
> > May 27 22:38:29 km1 /usr/sbin/kamailio[10008]: ERROR: usrloc
> > [ucontact.c:916]: failed to update database
> > May 27 22:38:29 km1 /usr/sbin/kamailio[10008]: ERROR: registrar
> > [save.c:731]: failed to update contact
> > May 27 22:38:29 km1 /usr/sbin/kamailio[10010]: INFO: <script>: Contacts
> > successfully saved - R=sip:x.x.x.x:5060
> > ID=OWM0ZmRjNjkzMTE3NDdhYTczY2QwOTRkZDk4NGU2Y2I.
> > ~
> >
> >
> >
> >
> > _______________________________________________
> > Spce-user mailing list
> > Spce-user at lists.sipwise.com
> > http://lists.sipwise.com/listinfo/spce-user
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130527/5f2661ec/attachment-0001.html>