[SR-Users] Problems while reading from location and parsing expires

Jöran Vinzens vinzens at sipgate.de
Tue Feb 25 12:49:36 CET 2014


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, pid17725, "
udp receiver child=0 sock=172.20.21.3:5060"
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]:
io_watch_add(): DBG: io_watch_add(0x8a9e80, 50, 4, 0x7ff56c667400), fd_no=30
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: : <core> [main.c:1609]:
main_loop(): main_loop: Cannot fork
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]:
io_watch_add(): DBG: io_watch_add(0x8a9e80, 52, 4, 0x7ff56c66748c), fd_no=31
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17723]: ALERT: <core> [main.c:772]:
handle_sigs(): child process 17725 exited normally, status=255
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]:
io_watch_add(): DBG: io_watch_add(0x8a9e80, 54, 4, 0x7ff56c667518), fd_no=32
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17723]: INFO: <core> [main.c:790]:
handle_sigs(): INFO: terminating due to SIGCHLD
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17743]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17736]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17735]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17734]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17733]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17732]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17731]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17730]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17729]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17728]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: INFO: <core> [main.c:841]:
sig_usr(): INFO: signal 15 received
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17743]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17736]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17735]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17734]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17733]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17732]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17731]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17730]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17729]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17728]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [main.c:852]:
sig_usr(): Memory status (pkg):





On Tue, Feb 25, 2014 at 12:36 PM, Daniel-Constantin Mierla <
miconda 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 unixtimestamp instead of the
> datetime.
>
>  when i truncate the location table it starts perfectly, since there are
> no entries stored where it could fail parsing expires date.
>
>  does anybody has similar issue or any suggestions how to solve?
>
>  found in Version: 4.1.0
>
>  many thanks!
>
>  BR
> Jöran
>
>
>  --
>
> Jöran Vinzens
> sipgate GmbH - Gladbacher Str. 74 - 40219 Düsseldorf
>
> HRB Düsseldorf 39841 - Geschäftsführer: Thilo Salmon, Tim Mois
>
> Steuernummer: 106/5724/7147, Umsatzsteuer-ID: DE219349391
> www.sipgate.de - www.sipgate.at - www.sipgate.co.uk
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140225/1d87f6e2/attachment-0001.html>


More information about the sr-users mailing list