回复：Re: kamailio 4.2 ，have some problems when use mysql db

List overview All Threads
Download

newer

older

parallel forking

kamailio 4.2 ，have some problems...

shuntongzhang

20 Oct 2014 20 Oct '14

9:52 a.m.

Attachments:

attachment.html (text/html — 4.1 KB)

Show replies by date

张顺通

20 Oct 20 Oct

11:20 a.m.

New subject: [SR-Users] kamailio 4.2 ，have some problems when use mysql db

I have two computer, one is ok ,the other can not startup. 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang(a)gmail.com>om>:

...

mysql operation is all ok. no private memory left. pkg_malloc is failed. 发自我的小米手机在 2014年10月20日下午1:51，Gonzalo Gasca <gascagonzalo(a)gmail.xn--com>:-0s6m5392c 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(a)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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

张顺通

noon

New subject: [SR-Users] kamailio 4.2 ，have some problems when use mysql db

...

I have two computer, one is ok ,the other can not startup. 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang(a)gmail.com>om>:

Daniel-Constantin Mierla

12:11 p.m.

New subject: kamailio 4.2 ，have some problems when use mysql db

...

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(a)gmail.com <mailto:shuntongzhang@gmail.com>>: I have two computer, one is ok ,the other can not startup. 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang(a)gmail.com <mailto:shuntongzhang@gmail.com>>: mysql operation is all ok. no private memory left. pkg_malloc is failed. 发自我的小米手机在 2014年10月20日下午1:51，Gonzalo Gasca <gascagonzalo(a)gmail.com <mailto:gascagonzalo@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(a)gmail.com <mailto:shuntongzhang@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(a)lists.sip-router.org <mailto:sr-users@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 list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

张顺通

12:43 p.m.

New subject: [SR-Users] kamailio 4.2 ，have some problems when use mysql db

-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(a)gmail.com>om>:

...

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(a)gmail.com>om>:

I have two computer, one is ok ,the other can not startup. 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang(a)gmail.com>om>:

mysql operation is all ok. no private memory left. pkg_malloc is failed. 发自我的小米手机在 2014年10月20日下午1:51，Gonzalo Gasca <gascagonzalo(a)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(a)gmail.com> wrote:

_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@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(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla

12:09 p.m.

New subject: kamailio 4.2 ，have some problems when use mysql db

Are both computers using same database or each of them has a database server locally? Do you use same configuration file and command line parameters on both systems? Can you start with higher pkg memory on the computer where you have troubles? Like: kamailio -M 12 ... Cheers, Daniel On 20/10/14 10:20, 张顺通 wrote:

...

I have two computer, one is ok ,the other can not startup. 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang(a)gmail.com <mailto:shuntongzhang@gmail.com>>: mysql operation is all ok. no private memory left. pkg_malloc is failed. 发自我的小米手机在 2014年10月20日下午1:51，Gonzalo Gasca <gascagonzalo(a)gmail.com <mailto:gascagonzalo@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(a)gmail.com <mailto:shuntongzhang@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(a)lists.sip-router.org <mailto:sr-users@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 list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

3687

days inactive

3687

days old

sr-users@lists.kamailio.org

Manage subscription

5 comments

3 participants

tags (0)

participants (3)

Daniel-Constantin Mierla
shuntongzhang
张顺通