Hello,

the problem is with last_modified column, not with expires. The structure of your location table is different than the one needed in 4.1:

https://github.com/kamailio/kamailio/blob/4.1/utils/kamctl/mysql/usrloc-create.sql

The issue seems to reside in the middle layer, because the timestamp is not returned as number, but as datetime format. Not sure it is something related to some mysql setting.

Cheers,
Daniel


On 25/02/14 12:49, Jöran Vinzens wrote:
Hi Daniel,

sure.

We are using Mysql Percona 5.1


mysql> describe location
    -> ;
+---------------+---------------------+------+-----+---------------------+-----------------------------+
| Field         | Type                | Null | Key | Default             | Extra                       |
+---------------+---------------------+------+-----+---------------------+-----------------------------+
| username      | varchar(64)         | NO   | PRI |                     |                             |
| domain        | varchar(128)        | NO   | PRI |                     |                             |
| contact       | varchar(255)        | NO   | PRI |                     |                             |
| received      | varchar(255)        | YES  |     | NULL                |                             |
| expires       | datetime            | NO   | MUL | 2030-05-28 21:32:15 |                             |
| q             | float(10,2)         | YES  |     | NULL                |                             |
| callid        | varchar(255)        | YES  |     | NULL                |                             |
| cseq          | int(11)             | YES  |     | NULL                |                             |
| last_modified | timestamp           | NO   |     | CURRENT_TIMESTAMP   | on update CURRENT_TIMESTAMP |
| replicate     | int(10) unsigned    | YES  |     | NULL                |                             |
| state         | tinyint(1) unsigned | YES  |     | NULL                |                             |
| flags         | int(11)             | NO   | MUL | 0                   |                             |
| cflags        | int(11)             | NO   |     | 0                   |                             |
| path          | varchar(512)        | YES  |     | NULL                |                             |
| user_agent    | varchar(50)         | NO   |     |                     |                             |
| socket        | varchar(128)        | YES  |     | NULL                |                             |
| methods       | int(11)             | YES  |     | NULL                |                             |
| ruid          | varchar(64)         | NO   | UNI |                     |                             |
| reg_id        | int(11)             | NO   |     | 0                   |                             |
| instance      | varchar(255)        | YES  |     | NULL                |                             |
+---------------+---------------------+------+-----+---------------------+-----------------------------+
20 rows in set (0.00 sec)


Here the Log snippet where the kamailio try to read from DB: (hope this is enough log)

Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: db_mysql [km_my_con.c:123]: db_mysql_new_connection(): server version is 5.1.56-rel12.7-log
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (23): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (24): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (21): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): avpops
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: db_mysql [km_my_con.c:123]: db_mysql_new_connection(): server version is 5.1.56-rel12.7-log
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (28): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820c61f8 frag. 0x7ff5820c61c8 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (20): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[17] at 0x7ff5820432d0
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (19): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (29): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (18): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (30): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (31): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-4): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (17): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) called from <core>: db.c: db_do_init2(302)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (32): nathelper
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582042e10 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ff5820432d0)[17]=[domain]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 3072) called from <core>: tcp_main.c: send_fd_queue_init(3163)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff5820669a8 frag. 0x7ff582066978 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 3072) returns address 0x7ff5822bbdc8 frag. 0x7ff5822bbd98 (size=3072) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 56) called from <core>: db_id.c: new_db_id(242)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (14)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql [km_dbase.c:358]: db_mysql_fetch_result(): converting row 0 of 11 count 11
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 53784) called from <core>: io_wait.c: init_io_wait(492)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (3)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (13)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (16)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (2)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 56) returns address 0x7ff582066a20 frag. 0x7ff5820669f0 (size=56) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff58217f010 frag. 0x7ff58217efe0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454a-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (15)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (-1)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (-1)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 176) called from db_mysql: km_dbase.c: db_mysql_fetch_result(360)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17753]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17754]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17755]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 53784) returns address 0x7ff5822bca28 frag. 0x7ff5822bc9f8 (size=53784) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17750]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17751]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-453f-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17752]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-4549-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17749]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454c-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-453e-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 6) called from <core>: db_id.c: dupl_string(50)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17756]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454b-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454d-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-454e-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17748]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 176) returns address 0x7ff582066658 frag. 0x7ff582066628 (size=176) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17747]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17757]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17746]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17758]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17759]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 26892) called from <core>: io_wait.c: init_io_wait(543)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17745]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820b89d0 frag. 0x7ff5820b89a0 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17760]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582042fa0 frag. 0x7ff582042f70 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (14): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 576) called from <core>: db_row.c: db_allocate_row(114)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 26896) returns address 0x7ff5822c9ca0 frag. 0x7ff5822c9c70 (size=26896) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (3): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (13): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (16): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (2): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 10) called from <core>: db_id.c: dupl_string(50)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (15): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17741]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17742]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 576) returns address 0x7ff582066768 frag. 0x7ff582066738 (size=576) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [local_timer.c:74]: init_local_timer(): init_local_timer: timer_list between 0x8aa088 and 0x8ee088
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 16) returns address 0x7ff582066ab8 frag. 0x7ff582066a88 (size=16) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17738]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 28) called from <core>: udp_server.c: udp_rcv_loop(434)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_row.c:119]: db_allocate_row(): allocate 576 bytes for row values at 0x7ff582066768
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 9, 1, 0x7ff581dc3078), fd_no=0
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17727]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17737]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17740]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17726]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 9) called from <core>: db_id.c: dupl_string(50)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17739]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 32) returns address 0x7ff582043000 frag. 0x7ff582042fd0 (size=32) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [1012839e11]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 11, 4, 0x7ff56c666424), fd_no=1
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 16) returns address 0x7ff582066b28 frag. 0x7ff582066af8 (size=16) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [sip:1012839e11@217.10.66.173:5064]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 12, 4, 0x7ff56c6664b0), fd_no=2
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 21) called from <core>: db_id.c: dupl_string(50)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:157]: db_str2val(): converting DATETIME [2014-02-25 11:37:08]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 13, 4, 0x7ff56c66653c), fd_no=3
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 24) returns address 0x7ff582066b98 frag. 0x7ff582066b68 (size=24) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:106]: db_str2val(): converting DOUBLE [-1.00]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 14, 4, 0x7ff56c6665c8), fd_no=4
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:369]: qm_malloc(): qm_malloc(0x7ff581d86010, 4) called from <core>: db_id.c: dupl_string(50)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [579980924-5064-1@CBH.BA.GG.BHD]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 15, 4, 0x7ff56c666654), fd_no=5
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [mem/q_malloc.c:415]: qm_malloc(): qm_malloc(0x7ff581d86010, 8) returns address 0x7ff5820b70c0 frag. 0x7ff5820b7090 (size=8) on 1 -th hit
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [4271]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 16, 4, 0x7ff56c6666e0), fd_no=6
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [db.c:327]: db_do_init2(): connection 0x7ff582066a20 found in pool
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [0]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 17, 4, 0x7ff56c66676c), fd_no=7
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): domain
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [0]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 18, 4, 0x7ff56c6667f8), fd_no=8
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): kex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [Grandstream GXP2110 1.0.4.9]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 19, 4, 0x7ff56c666884), fd_no=9
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: kex [kex_mod.c:156]: child_init(): rank is (-1)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 20, 4, 0x7ff56c666910), fd_no=10
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sruid.c:100]: sruid_init(): root for sruid is [srid-530c705e-4550-] (0 / 19)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [<sip:217.116.120.247:5060;lr>]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 21, 4, 0x7ff56c66699c), fd_no=11
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): corex
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [udp:172.20.21.3:5060]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 22, 4, 0x7ff56c666a28), fd_no=12
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17744]: DEBUG: <core> [sr_module.c:923]: init_mod_child(): DEBUG: init_mod_child (-1): uac
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [7135]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 23, 4, 0x7ff56c666ab4), fd_no=13
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [2014-02-25 11:27:08]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 24, 4, 0x7ff56c666b40), fd_no=14
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [db_ut.c:90]: db_str2int(): Unexpected characters: [-02-25 11:27:08]
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 25, 4, 0x7ff56c666bcc), fd_no=15
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [db_val.c:75]: db_str2val(): error while converting integer value from string
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 26, 4, 0x7ff56c666c58), fd_no=16
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: db_mysql [km_row.c:68]: db_mysql_convert_row(): failed to convert value
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 27, 4, 0x7ff56c666ce4), fd_no=17
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: db_mysql [km_row.c:69]: db_mysql_convert_row(): free row at 0x7ff582066658
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 28, 4, 0x7ff56c666d70), fd_no=18
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_row.c:97]: db_free_row(): freeing row values at 0x7ff582066768
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 29, 4, 0x7ff56c666dfc), fd_no=19
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:439]: qm_free(): qm_free(0x7ff581d86010, 0x7ff582066768), called from <core>: db_row.c: db_free_row(98)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 31, 4, 0x7ff56c666e88), fd_no=20
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:474]: qm_free(): qm_free: freeing frag. 0x7ff582066738 alloc'ed from <core>: db_row.c: db_allocate_row(114)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 33, 4, 0x7ff56c666f14), fd_no=21
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: db_mysql [km_dbase.c:375]: db_mysql_fetch_result(): error while converting row #0
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 34, 4, 0x7ff56c666fa0), fd_no=22
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_res.c:54]: db_free_rows(): freeing 0 rows
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 36, 4, 0x7ff56c66702c), fd_no=23
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [db_res.c:62]: db_free_rows(): freeing rows at 0x7ff582066658
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 38, 4, 0x7ff56c6670b8), fd_no=24
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:439]: qm_free(): qm_free(0x7ff581d86010, 0x7ff582066658), called from <core>: db_res.c: db_free_rows(63)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 40, 4, 0x7ff56c667144), fd_no=25
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: DEBUG: <core> [mem/q_malloc.c:474]: qm_free(): qm_free: freeing frag. 0x7ff582066628 alloc'ed from db_mysql: km_dbase.c: db_mysql_fetch_result(360)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 42, 4, 0x7ff56c6671d0), fd_no=26
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: usrloc [udomain.c:420]: preload_udomain(): fetching rows failed
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 44, 4, 0x7ff56c66725c), fd_no=27
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: usrloc [ul_mod.c:456]: child_init(): child(1): failed to preload domain 'location'
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 46, 4, 0x7ff56c6672e8), fd_no=28
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [sr_module.c:927]: init_mod_child(): init_mod_child(): Error while initializing module usrloc (/usr/lib64/kamailio/modules/usrloc.so)
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17761]: DEBUG: <core> [io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x8a9e80, 48, 4, 0x7ff56c667374), fd_no=29
Feb 25 11:28:46 hagi /usr/sbin/kamailio[17725]: ERROR: <core> [pt.c:346]: fork_process(): ERROR: fork_process(): init_child failed for  process 1, 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@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@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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users




-- 
Jöran Vinzens - vinzens@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