[SR-Users] Problems while reading from location and parsing expires
Daniel-Constantin Mierla
miconda at gmail.com
Tue Feb 25 13:03:58 CET 2014
Hello,
the problem is with last_modified column, not with expires. The
structure of your location table is different than the one needed in 4.1:
https://github.com/kamailio/kamailio/blob/4.1/utils/kamctl/mysql/usrloc-create.sql
The issue seems to reside in the middle layer, because the timestamp is
not returned as number, but as datetime format. Not sure it is something
related to some mysql setting.
Cheers,
Daniel
On 25/02/14 12:49, Jöran Vinzens wrote:
> 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 at 217.10.66.173:5064
> <http://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 at 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 <http://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
> <http://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, pid 17725, "udp receiver child=0 sock=172.20.21.3:5060
> <http://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 at gmail.com <mailto:miconda at 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 unix timestamp 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 - 40219Düsseldorf
>>
>>
>> HRB Düsseldorf 39841 -Geschäftsführer:Thilo Salmon, TimMois
>>
>>
>> Steuernummer: 106/5724/7147,Umsatzsteuer-ID: DE219349391
>>
>> www.sipgate.de <http://www.sipgate.de> -www.sipgate.at <http://www.sipgate.at> -www.sipgate.co.uk <http://www.sipgate.co.uk>
>>
>>
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> --
> Daniel-Constantin Mierla -http://www.asipto.com
> http://twitter.com/#!/miconda <http://twitter.com/#%21/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 <mailto:sr-users at lists.sip-router.org>
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
>
> --
> Jöran Vinzens -vinzens at sipgate.de <mailto:vinzens at sipgate.de>
> Telefon: +49 (0)211-63 55 56-21
> Telefax: +49 (0)211-63 55 55-22
>
>
>
> 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 <http://www.sipgate.de> -www.sipgate.at <http://www.sipgate.at> -www.sipgate.co.uk <http://www.sipgate.co.uk>
>
>
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140225/18d23767/attachment-0001.html>
More information about the sr-users
mailing list