[Spce-user] DB error on

[Tung Tran]

Hi Alex

You right, when the user tried to register for first time and it was error
"login failed, internal server error', and mysql came , but after few try
it was success,


I checked all log from /var/log/mysql/mysqld.err but didnt see anything
related to this issue.

Im using ngcp version 4.0.1 on vmware image.


---
Best regards,

*Tung Tran*


*V247 Enterprise Corp*713.358.2257 office   |  281.857.3448 cell
9999 Bellaire Blvd., Ste. 1111* | *Houston, TX 77036
*tung.tran at V247.com | www.V247.com <http://www.v247.com/>*


On Mon, Sep 21, 2015 at 12:10 PM, Alex Lutay <alutay at sipwise.com> wrote:

> Hi,
>
> On 09/21/2015 04:36 PM, Tung Tran wrote:
> > Sometime I saw this error from kamailio-proxy
> >
> > Sep 21 16:31:52 spce proxy[64504]: ERROR: <core> [db_query.c:235]:
> > db_do_insert_cmd(): error while submitting query
> > Sep 21 16:31:52 spce proxy[64504]: ERROR: usrloc [ucontact.c:683]:
> > db_insert_ucontact(): inserting contact in db failed
> > Sep 21 16:31:52 spce proxy[64504]: ERROR: usrloc [urecord.c:589]:
> > insert_ucontact(): failed to insert in database
> > Sep 21 16:31:52 spce proxy[64504]: ERROR: registrar [save.c:507]:
> > insert_contacts(): failed to insert contact
>
> It means kamailio failed to insert record for some reason.
> There should be more info in log. DB gone? DB connection gone?
> What is inside MySQL logs for those time?
>
> Connection can be closed by inactivity timeout, kamailio failed to
> inster record, reconnected and inserted properly, etc...
>
> Hard to say from this side, share steps to reproduce if you have
> together with release version.
>
> > Is it a bug in SPCE? and how to fix it?
>
> Nothing I am aware of.
> Please always specify release version you have.
>
> --
> Alexander Lutay
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://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/20150921/ad9bcf59/attachment-0001.html>