Hi Daniel,
sure.
We are using Mysql Percona 5.1
mysql> describe location -> ; +---------------+---------------------+------+-----+---------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------------------+-----------------------------+ | username | varchar(64) | NO | PRI | | | | domain | varchar(128) | NO | PRI | | | | contact | varchar(255) | NO | PRI | | | | received | varchar(255) | YES | | NULL | | | expires | datetime | NO | MUL | 2030-05-28 21:32:15 | | | q | float(10,2) | YES | | NULL | | | callid | varchar(255) | YES | | NULL | | | cseq | int(11) | YES | | NULL | | | last_modified | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | replicate | int(10) unsigned | YES | | NULL | | | state | tinyint(1) unsigned | YES | | NULL | | | flags | int(11) | NO | MUL | 0 | | | cflags | int(11) | NO | | 0 | | | path | varchar(512) | YES | | NULL | | | user_agent | varchar(50) | NO | | | | | socket | varchar(128) | YES | | NULL | | | methods | int(11) | YES | | NULL | | | ruid | varchar(64) | NO | UNI | | | | reg_id | int(11) | NO | | 0 | | | instance | varchar(255) | YES | | NULL | | +---------------+---------------------+------+-----+---------------------+-----------------------------+ 20 rows in set (0.00 sec)
Here the Log snippet where the kamailio try to read from DB: (hope this is enough log)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: db_mysql[km_my_con.c:123]: db_ mysql_new_connection(): server version is 5.1.56-rel12.7-log Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (23): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (24): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (21): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): avpops Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: db_mysql[km_my_con.c:123]: db_ mysql_new_connection(): server version is 5.1.56-rel12.7-log Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (28): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (20): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql[km_res.c:85]: db_ mysql_get_columns(): allocate 16 bytes for RES_NAMES[17] at 0x7ff5820432d0 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (19): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (29): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (18): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (30): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (31): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-4): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (17): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) called from <core>: db.c: db_do_init2(302) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (32): nathelper Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql[km_res.c:92]: db_ mysql_get_columns(): RES_NAMES(0x7ff5820432d0)[17]=[domain] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 3072) called from <core>: tcp_main.c: send_fd_queue_init(3163) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff5820669a8 frag. 0x7ff582066978 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql[km_res.c:136]: db_ mysql_get_columns(): use DB1_STRING result type Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 3072) returns address 0x7ff5822bbdc8 frag. 0x7ff5822bbd98 (size=3072) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 56) called from <core>: db_id.c: new_db_id(242) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (14) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql [km_dbase.c:358]: db_mysql_fetch_result(): converting row 0 of 11 count 11 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 53784) called from <core>: io_wait.c: init_io_wait(492) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (3) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (13) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (16) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (2) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 56) returns address 0x7ff582066a20 frag. 0x7ff5820669f0 (size=56) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454a-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (15) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (-1) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (-1) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 176) called from db_mysql: km_dbase.c: db_mysql_fetch_result(360) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 53784) returns address 0x7ff5822bca28 frag. 0x7ff5822bc9f8 (size=53784) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-453f-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-4549-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454c-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-453e-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 6) called from <core>: db_id.c: dupl _string(50) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454b-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454d-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454e-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 176) returns address 0x7ff582066658 frag. 0x7ff582066628 (size=176) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 26892) called from <core>: io_wait.c: init_io_wait(543) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820b89d0 frag. 0x7ff5820b89a0 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 576) called from <core>: db_row.c: db_allocate_row(114) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 26896) returns address 0x7ff5822c9ca0 frag. 0x7ff5822c9c70 (size=26896) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 10) called from <core>: db_id.c: dupl _string(50) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 576) returns address 0x7ff582066768 frag. 0x7ff582066738 (size=576) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [local_timer.c:74]: init_local_timer(): init_local_timer: timer_list between 0x8aa088 and 0x8ee088 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 16) returns address 0x7ff582066ab8 frag. 0x7ff582066a88 (size=16) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_row.c:119]: db_allocate_row(): allocate 576 bytes for row values at 0x7ff582066768 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 9, 1, 0x7ff581dc3078), fd_no=0 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 9) called from <core>: db_id.c: dupl _string(50) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [1012839e11] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 11, 4, 0x7ff56c666424), fd_no=1 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 16) returns address 0x7ff582066b28 frag. 0x7ff582066af8 (size=16) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [ sip:1012839e11@217.10.66.173:5064] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 12, 4, 0x7ff56c6664b0), fd_no=2 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 21) called from <core>: db_id.c: dupl _string(50) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:157]: db_str2val(): converting DATETIME [2014-02-25 11:37:08] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 13, 4, 0x7ff56c66653c), fd_no=3 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582066b98 frag. 0x7ff582066b68 (size=24) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:106]: db_str2val(): converting DOUBLE [-1.00] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 14, 4, 0x7ff56c6665c8), fd_no=4 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 4) called from <core>: db_id.c: dupl _string(50) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [579980924-5064-1@CBH.BA.GG. BHD] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 15, 4, 0x7ff56c666654), fd_no=5 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820b70c0 frag. 0x7ff5820b7090 (size=8) on 1 -th hit Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [4271] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 16, 4, 0x7ff56c6666e0), fd_no=6 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582066a20 found in pool Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [0] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 17, 4, 0x7ff56c66676c), fd_no=7 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): domain Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [0] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 18, 4, 0x7ff56c6667f8), fd_no=8 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): kex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [Grandstream GXP2110 1.0.4.9] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 19, 4, 0x7ff56c666884), fd_no=9 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (-1) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 20, 4, 0x7ff56c666910), fd_no=10 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-4550-] (0 / 19) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [sip:217.116.120.247:5060; lr] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 21, 4, 0x7ff56c66699c), fd_no=11 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): corex Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [udp:172.20.21.3:5060] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 22, 4, 0x7ff56c666a28), fd_no=12 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): uac Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [7135] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 23, 4, 0x7ff56c666ab4), fd_no=13 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [2014-02-25 11:27:08] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 24, 4, 0x7ff56c666b40), fd_no=14 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [db_ut.c:90]: db_str2int(): Unexpected characters: [-02-25 11:27:08] Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 25, 4, 0x7ff56c666bcc), fd_no=15 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [db_val.c:75]: db_str2val(): error while converting integer value from string Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 26, 4, 0x7ff56c666c58), fd_no=16 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: db_mysql[km_row.c:68]: db_ mysql_convert_row(): failed to convert value Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 27, 4, 0x7ff56c666ce4), fd_no=17 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql[km_row.c:69]: db_ mysql_convert_row(): free row at 0x7ff582066658 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 28, 4, 0x7ff56c666d70), fd_no=18 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_row.c:97]: db_free_row(): freeing row values at 0x7ff582066768 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 29, 4, 0x7ff56c666dfc), fd_no=19 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:439]: qm_free(): qm_free(0x7ff581d86010, 0x7ff582066768), called from <core>: db_row.c: db_free_row(98) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 31, 4, 0x7ff56c666e88), fd_no=20 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:474]: qm_free(): qm_free: freeing frag. 0x7ff582066738 alloc'ed from <core>: db_row.c: db_allocate_row(114) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 33, 4, 0x7ff56c666f14), fd_no=21 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: db_mysql [km_dbase.c:375]: db_mysql_fetch_result(): error while converting row #0 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 34, 4, 0x7ff56c666fa0), fd_no=22 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_res.c:54]: db_free_rows(): freeing 0 rows Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 36, 4, 0x7ff56c66702c), fd_no=23 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_res.c:62]: db_free_rows(): freeing rows at 0x7ff582066658 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 38, 4, 0x7ff56c6670b8), fd_no=24 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:439]: qm_free(): qm_free(0x7ff581d86010, 0x7ff582066658), called from <core>: db_res.c: db_free_rows(63) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 40, 4, 0x7ff56c667144), fd_no=25 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:474]: qm_free(): qm_free: freeing frag. 0x7ff582066628 alloc'ed from db_mysql: km_ dbase.c: db_mysql_fetch_result(360) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 42, 4, 0x7ff56c6671d0), fd_no=26 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: usrloc [udomain.c:420]: preload_udomain(): fetching rows failed Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 44, 4, 0x7ff56c66725c), fd_no=27 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: usrloc [ul_mod.c:456]: child_init(): child(1): failed to preload domain 'location' Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 46, 4, 0x7ff56c6672e8), fd_no=28 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [sr_module.c:927]: init_mod_child(): init_mod_child(): Error while initializing module usrloc(/ usr/lib64/kamailio/modules/usrloc.so) Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 48, 4, 0x7ff56c667374), fd_no=29 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [pt.c:346]: fork_process(): ERROR: fork_process(): init_child failed for process 1, pid17725, " udp receiver child=0 sock=172.20.21.3:5060" Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 50, 4, 0x7ff56c667400), fd_no=30 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: : <core> [main.c:1609]: main_loop(): main_loop: Cannot fork Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 52, 4, 0x7ff56c66748c), fd_no=31 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17723]: ALERT: <core> [main.c:772]: handle_sigs(): child process 17725 exited normally, status=255 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 54, 4, 0x7ff56c667518), fd_no=32 Feb 25 11:28:46 hagi /usr/sbin/kamailio[17723]: INFO: <core> [main.c:790]: handle_sigs(): INFO: terminating due to SIGCHLD Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17743]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17736]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17735]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17734]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17733]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17732]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17731]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17730]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17729]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17728]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: INFO: <core> [main.c:841]: sig_usr(): INFO: signal 15 received Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17743]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17736]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17735]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17734]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17733]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17732]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17731]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17730]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17729]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17728]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg): Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [main.c:852]: sig_usr(): Memory status (pkg):
On Tue, Feb 25, 2014 at 12:36 PM, Daniel-Constantin Mierla < miconda@gmail.com> wrote:
Hello,
can you give the output in mysql client for:
describe location
What version of mysql is used?
Can you get the logs with debug=3 in kamailio.cfg?
Cheers, Daniel
On 25/02/14 12:01, Jöran Vinzens wrote:
Hi All,
we are upgrading from kamailio 3.1 to 4.1 and we got stuck at a Problem with usrloc module.
While starting up kamailio reads location from DB and try to parse expires date from DB.
this is the Problem:
Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: <core> [db_ut.c:90]: db_str2int(): Unexpected characters: [-02-25 11:27:08] Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: <core> [db_val.c:75]: db_str2val(): error while converting integer value from string Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: db_mysql[km_row.c:68]: db_ mysql_convert_row(): failed to convert value Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: db_mysql [km_dbase.c:375]: db_mysql_fetch_result(): error while converting row #0 Feb 25 11:42:11 hagi /usr/sbin/kamailio[19580]: ERROR: usrloc [udomain.c:420]: preload_udomain(): fetching rows failed
usrloc Module is configured with db_mode "1" so it saves it's entries by itself. When i have a look on the database it looks good and the expires field is an datetime. From logs it looks like it try to parse a unixtimestamp instead of the datetime.
when i truncate the location table it starts perfectly, since there are no entries stored where it could fail parsing expires date.
does anybody has similar issue or any suggestions how to solve?
found in Version: 4.1.0
many thanks!
BR Jöran
--
Jöran Vinzens sipgate GmbH - Gladbacher Str. 74 - 40219 Düsseldorf
HRB Düsseldorf 39841 - Geschäftsführer: Thilo Salmon, Tim Mois
Steuernummer: 106/5724/7147, Umsatzsteuer-ID: DE219349391 www.sipgate.de - www.sipgate.at - www.sipgate.co.uk
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 Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users