[Spce-user] New installation and some issue

[Andreas Granig]

Hi,

With an insert to the DB taking 6 seconds, it seems to me you're having
some storage I/O issues?

Andreas

On 08/23/2016 03:13 PM, qabane me wrote:
> Hi all
> 
> I have installed the latest version 4.4.1 on a VM in proxmox with plenty
> of resources. 12GB and 12 cores.
> 
> I am having some intermittent issues getting my first phone registered
> and notice 2 things in the kamailio proxy log:
> 
> 
> : NOTICE: <script>: Authentication failed, invalid user -
> R=sip:domain.com <http://domain.com> ID=386d439d8d21-uvfjcqs5r0xs
> UA='snom300/8.7.3.19 <http://8.7.3.19>'
> Aug 23 15:09:13 sipwise3 proxy[7889]: ERROR: db_mysql [km_dbase.c:128]:
> db_mysql_submit_query(): driver error on query: Lost connection to MySQL
> server during query (2013)
> Aug 23 15:09:13 sipwise3 proxy[7889]: NOTICE: <core> [db_query.c:60]:
> db_do_submit_query(): alert - query execution too long [6000 ms] for
> [insert into `location` (`username`,`contact`,`expi]
> Aug 23 15:09:13 sipwise3 proxy[7889]: ERROR: <core> [db_query.c:235]:
> db_do_insert_cmd(): error while submitting query
> Aug 23 15:09:13 sipwise3 proxy[7889]: ERROR: usrloc [ucontact.c:684]:
> db_insert_ucontact(): inserting contact in db failed user at domain.com
> <mailto:user at domain.com> (uloc-57bc19e7-1ecc-2)
> Aug 23 15:09:13 sipwise3 proxy[7889]: ERROR: usrloc [urecord.c:420]:
> wb_timer(): inserting contact into database failed (aor: user at domain.com
> <mailto:user at domain.com>)
> 
> the phone will register and then it won't, then it will, etc. I would
> imagine that the above snippet is the cause. This is a brand new
> installation.
> 
> Any thoughts?
> 
> Mark
> 
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>