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(a)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-cre…
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@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(a)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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Jöran Vinzens - vinzens(a)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(a)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