[SR-Users] kamailio 4.2 ,have some problems when use mysql db

张顺通 shuntongzhang at gmail.com
Mon Oct 20 11:43:59 CEST 2014


-M 12 can not help. all config is same.

see ka.log in attachment, kamailio version is 4.1.6

version: kamailio 4.1.6 (x86_64/linux) 010d57

flags: STATS: Off, USE_TCP, USE_TLS, TLS_HOOKS, USE_RAW_SOCKS,
DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC,
DBG_QM_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE,
USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST, HAVE_RESOLV_RES

ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 4MB

poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.

id: 010d57

compiled on 16:48:03 Oct 20 2014 with gcc 4.1.2​
 ka.log
<https://docs.google.com/file/d/0B5x1TDtoeVvAZXhaTkdCcllwams/edit?usp=drive_web>
​


2014-10-20 17:11 GMT+08:00 Daniel-Constantin Mierla <miconda at gmail.com>:

>  Can you set in kamailio.cfg:
>
> debug=3
> memdbg=2
> memlog=2
>
> and send the syslog messages printed by kamailio from the moment of
> starting it to me?
>
> They can be a lot, would be good if you can make an archive (tgz) and put
> it somewhere for download.
>
> Cheers,
> Daniel
>
>
> On 20/10/14 11:00, 张顺通 wrote:
>
> when open  MEMDBG ?= 1, I get this
>
>  <core> [mem/q_malloc.c:159]: qm_debug_frag(): BUG: qm_*: prev. fragm.
> tail overwritten(0, 0)[0x7f64241cdfc0:0x7f64241cdff0]!
>
> 2014-10-20 16:20 GMT+08:00 张顺通 <shuntongzhang at gmail.com>:
>
>> I have two computer, one is ok ,the other can not startup.
>>
>> 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang at gmail.com>:
>>
>>> mysql operation is all ok.
>>>
>>> no private memory left.
>>> pkg_malloc is failed.
>>>
>>>
>>>  发自我的小米手机
>>> 在 2014年10月20日 下午1:51,Gonzalo Gasca <gascagonzalo at gmail.com> 写道:
>>>
>>>  Hi,
>>>
>>>  Based on:
>>>
>>>  Oct 20 08:14:45 ka[15500]: ERROR: <core> [db.c:401]:
>>> db_table_version(): error in db_query
>>> Oct 20 08:14:45 ka[15500]: ERROR: dispatcher [dispatch.c:669]:
>>> init_ds_db(): failed to query table version
>>>
>>>  What's the result when you run a direct mysql query for "version" table
>>> for the following "select * from version":
>>>
>>> Example:
>>>
>>>  mysql -h localhost -P 3306 -u root -p
>>>
>>> mysql> use kamailiodb; <Use your kamailio Db name here>
>>>
>>> mysql>desc version;
>>>
>>> mysql> select count(*) from version;
>>>  mysql> select * from version;
>>>
>>>  /G
>>>
>>>
>>>
>>> On Sun, Oct 19, 2014 at 6:38 PM, 张顺通 <shuntongzhang at gmail.com> wrote:
>>>
>>>>  Oct 20 08:14:45 ka[15500]: INFO: rr [../outbound/api.h:54]:
>>>> ob_load_api(): Failed to import bind_ob
>>>> Oct 20 08:14:45 ka[15500]: INFO: rr [rr_mod.c:160]: mod_init():
>>>> outbound module not available
>>>> Oct 20 08:14:45 ka[15500]: INFO: usrloc [hslot.c:53]: ul_init_locks():
>>>> locks array size 1024
>>>> Oct 20 08:14:45 ka[15500]: INFO: auth [auth_mod.c:350]: mod_init():
>>>> auth: qop set, but nonce-count (nc_enabled) support disabled
>>>> Oct 20 08:14:45 ka[15500]: ERROR: <core> [db_res.c:114]:
>>>> db_new_result(): no private memory left
>>>> Oct 20 08:14:45 ka[15500]: ERROR: db_mysql [km_dbase.c:229]:
>>>> db_mysql_store_result(): no memory left
>>>> Oct 20 08:14:45 ka[15500]: ERROR: <core> [db_query.c:139]:
>>>> db_do_query_internal(): error while storing result
>>>> Oct 20 08:14:45 ka[15500]: ERROR: <core> [db.c:401]:
>>>> db_table_version(): error in db_query
>>>> Oct 20 08:14:45 ka[15500]: ERROR: dispatcher [dispatch.c:669]:
>>>> init_ds_db(): failed to query table version
>>>> Oct 20 08:14:45 ka[15500]: ERROR: dispatcher [dispatcher.c:319]:
>>>> mod_init(): could not initiate a connect to the database
>>>> Oct 20 08:14:45 ka[15500]: ERROR: <core> [sr_module.c:968]: init_mod():
>>>> Error while initializing module dispatcher (/lib64/kamailio/dispatcher.so)
>>>>
>>>>  I need help.thks
>>>>
>>>> _______________________________________________
>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>> sr-users at lists.sip-router.org
>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>>>
>>>>
>>>
>>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141020/7244d4a4/attachment.html>


More information about the sr-users mailing list