[SR-Users] Problems while reading from location and parsing expires
Jöran Vinzens
vinzens at sipgate.de
Tue Feb 25 13:07:54 CET 2014
Hi,
after correcting DB shema, it's working well. Many thanks!
BR
Jöran
On Tue, Feb 25, 2014 at 1:03 PM, Daniel-Constantin Mierla
<miconda at gmail.com> wrote:
> 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]
> 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;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, pid
> 17725, "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 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 - 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 list
>> 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://www.linkedin.com/in/miconda
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>
>
>
> --
>
> Jöran Vinzens - 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 - www.sipgate.at - www.sipgate.co.uk
>
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.com
> http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
--
Jöran Vinzens - 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 - www.sipgate.at - www.sipgate.co.uk
More information about the sr-users
mailing list