sr-dev September 2022

sr-dev@lists.kamailio.org

16 participants
274 discussions

[kamailio/kamailio] [presence] [dialog events] BLF problem: "early" state persisting after "terminated" (Issue #3192)

by liviu-rolo

### Description Relevant modules and parameters in configuration: ``` loadmodule "presence.so" loadmodule "dialog.so" loadmodule "presence_xml.so" loadmodule "pua.so" loadmodule "presence_dialoginfo.so" loadmodule "pua_dialoginfo.so" modparam("dialog", "db_mode", 1) modparam("presence", "subs_db_mode", 2) modparam("presence", "db_table_lock_type", 0) modparam("pua", "db_mode", 2) modparam("pua", "db_table_lock_write", 0) ``` Using 2 UDP receiver processes. User1 is watching (has` SUBSCRIBE`d to) User2, which is called by User3 (call1). User2 doesn't answer, phone is ringing. User1 now also calls User2 (call2), but we don't support receiving a second call so, for this `INVITE`, after 183, almost immediately, a 486 "Busy Here" message is sent and the call is cancelled (call2 finished). The 183 reply generates an "**early**" state on the UDP1 process, while 486 goes to "**terminated**" on the UDP2 process. The `PUBLISH` messages are processed almost concomitantly. The problem is that "**early**" state arrives to the subscriber (User1) after the "**terminated**" one (seen with `sngrep`) so the phone button keeps blinking for a while (... and the state cannot be changed by other call while the "**early**" event is still in the `presentity` table of the database). I suspect a concurrency problem since I didn't reproduce it with only one UDP receiver process. Even if the "**terminated**" lifetime is much smaller (11s vs minutes), I strongly believe it is still there when the "**early**" state is written. Does the "**early**" event checks the database/memory for a "**terminated**" event for the same call ID? Is it because of the missing locks maybe (`db_table_lock_type`, `db_table_lock_write`) ? ### Troubleshooting #### Reproduction Using 2 UDP receiver processes. User1 is watching (has `SUBSCRIBE`d to) User2, which is called by User3 (call1). User2 doesn't answer, phone is ringing. User1 now also calls User2 (call2), but we don't support receiving a second call so, for this `INVITE`, after 183, almost immediately, a 486 "Busy Here" message is sent and the call is cancelled (call2 finished). I would not say that it is systematic, but easy enough to reproduce. #### Debugging Data  #### Log Messages  #### SIP Traffic  ``` (paste your sip traffic here) ``` ### Possible Solutions  ### Additional Information * **Kamailio Version** - output of `kamailio -v` ``` version: kamailio 5.5.4 (x86_64/linux) flags: , EXTRA_DEBUGUSE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. id: unknown compiled with gcc 8.3.0 ``` * **Operating System**: Docker image around ``` $ lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 10 (buster) Release: 10 Codename: buster (paste your output here) ``` -- Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/3192 You are receiving this because you are subscribed to this thread. Message ID: <kamailio/kamailio/issues/3192(a)github.com>

1 year, 8 months

git:master:2cebd46f: dialog: remove strlen() checks when setting a variable

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: 2cebd46f8f2dc3f87c9cfd2054976e347aa75ace URL: https://github.com/kamailio/kamailio/commit/2cebd46f8f2dc3f87c9cfd2054976e3… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2022-09-01T10:53:54+02:00 dialog: remove strlen() checks when setting a variable - assumed key->s and val->s are 0-terminated, which may not be the case --- Modified: src/modules/dialog/dlg_var.c --- Diff: https://github.com/kamailio/kamailio/commit/2cebd46f8f2dc3f87c9cfd2054976e3… Patch: https://github.com/kamailio/kamailio/commit/2cebd46f8f2dc3f87c9cfd2054976e3… --- diff --git a/src/modules/dialog/dlg_var.c b/src/modules/dialog/dlg_var.c index 6c4da06742..ef73c022d0 100644 --- a/src/modules/dialog/dlg_var.c +++ b/src/modules/dialog/dlg_var.c @@ -352,7 +352,7 @@ int get_dlg_variable_uintval(struct dlg_cell *dlg, str *key, unsigned int *uval) int set_dlg_variable(struct dlg_cell *dlg, str *key, str *val) { int ret = -1; - if( !dlg || !key || key->len > strlen(key->s) || (val && val->len > strlen(val->s))) + if( !dlg || !key || !key->s || key->len<=0 ) { LM_ERR("BUG - bad parameters\n"); return -1;

1 year, 8 months

git:master:b7dc2ac6: dialog: wrapper function to set a dlg var with unsigned integer parameter

by Daniel-Constantin Mierla

Module: kamailio Branch: master Commit: b7dc2ac6d66839b38ba8d6f36e9f28bc0a2d1425 URL: https://github.com/kamailio/kamailio/commit/b7dc2ac6d66839b38ba8d6f36e9f28b… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2022-09-01T10:50:30+02:00 dialog: wrapper function to set a dlg var with unsigned integer parameter - use it to set cseq diff value --- Modified: src/modules/dialog/dlg_cseq.c Modified: src/modules/dialog/dlg_var.c Modified: src/modules/dialog/dlg_var.h --- Diff: https://github.com/kamailio/kamailio/commit/b7dc2ac6d66839b38ba8d6f36e9f28b… Patch: https://github.com/kamailio/kamailio/commit/b7dc2ac6d66839b38ba8d6f36e9f28b… --- diff --git a/src/modules/dialog/dlg_cseq.c b/src/modules/dialog/dlg_cseq.c index e5555441fe..d5ffe20c85 100644 --- a/src/modules/dialog/dlg_cseq.c +++ b/src/modules/dialog/dlg_cseq.c @@ -173,8 +173,7 @@ int dlg_cseq_update(sip_msg_t *msg) LM_DBG("nothing to increment\n"); goto done; } - nval.s = int2str(vinc, &nval.len); - if(set_dlg_variable(dlg, &_dlg_cseq_diff_var_name, &nval) <0) { + if(set_dlg_variable_uintval(dlg, &_dlg_cseq_diff_var_name, vinc) <0) { LM_ERR("failed to set the dlg cseq diff var\n"); goto done; } diff --git a/src/modules/dialog/dlg_var.c b/src/modules/dialog/dlg_var.c index 04e48fa636..6c4da06742 100644 --- a/src/modules/dialog/dlg_var.c +++ b/src/modules/dialog/dlg_var.c @@ -378,6 +378,18 @@ int set_dlg_variable(struct dlg_cell *dlg, str *key, str *val) return ret; } +int set_dlg_variable_uintval(struct dlg_cell *dlg, str *key, unsigned int uval) +{ + str sval = STR_NULL; + + sval.s = int2str(uval, &sval.len); + if(sval.s==NULL) { + return -1; + } + + return set_dlg_variable(dlg, key, &sval); +} + int pv_get_dlg_variable(struct sip_msg *msg, pv_param_t *param, pv_value_t *res) { dlg_cell_t *dlg; diff --git a/src/modules/dialog/dlg_var.h b/src/modules/dialog/dlg_var.h index 70579810bf..a4b497dbd7 100644 --- a/src/modules/dialog/dlg_var.h +++ b/src/modules/dialog/dlg_var.h @@ -63,6 +63,7 @@ str* get_dlg_variable(dlg_cell_t *dlg, str *key); int set_dlg_variable(dlg_cell_t *dlg, str *key, str *val); int get_dlg_variable_uintval(struct dlg_cell *dlg, str *key, unsigned int *uval); +int set_dlg_variable_uintval(struct dlg_cell *dlg, str *key, unsigned int uval); int pv_parse_dialog_var_name(pv_spec_p sp, str *in);

1 year, 8 months

[kamailio/kamailio] Function sql_xquery returns 1 for empty query result. (Issue #3163)

by admin-toneca

### Description Function sql_xquery returns 1 for empty query result. #### Reproduction Table sbc_uacreg is empty modparam("sqlops", "sqlcon", "con=>mysql://kamailio:pass@172.31.1.237/fs") if (sql_xquery("con", "SELECT * FROM sbc_uacreg WHERE l_uuid = '$hdr(X-Gateway)'", "ra") == 1) { xlog("(PSTN) SELECT * FROM sbc_uacreg WHERE l_uuid = '$hdr(X-Gateway)' =============================================================================\n"); $var(register) = "1"; } #### Log Messages ``` Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_query.c:72]: db_do_submit_query(): submitted query: SELECT * FROM sbc_uacreg WHERE l_uuid = 'GwProdIpAuth', result 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:119]: db_new_result(): allocate 56 bytes for result set at 0x7fa7c2c91170 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:67]: db_mysql_get_columns(): 16 columns returned from the query Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:156]: db_allocate_columns(): allocate 128 bytes for result names at 0x7fa7c2c91288 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:167]: db_allocate_columns(): allocate 64 bytes for result types at 0x7fa7c2c91370 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7fa7c2c91418 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91418)[0]=[id] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: db_mysql_get_columns(): use DB1_INT result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at 0x7fa7c2c91490 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91490)[1]=[l_uuid] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at 0x7fa7c2c91508 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91508)[2]=[l_username] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at 0x7fa7c2c91580 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91580)[3]=[l_domain] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[4] at 0x7fa7c2c915f8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c915f8)[4]=[r_username] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[5] at 0x7fa7c2c91670 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91670)[5]=[r_domain] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[6] at 0x7fa7c2c916e8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c916e8)[6]=[realm] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[7] at 0x7fa7c2c91760 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91760)[7]=[auth_username] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[8] at 0x7fa7c2c917d8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c917d8)[8]=[auth_password] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[9] at 0x7fa7c2c91850 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91850)[9]=[auth_ha1] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[10] at 0x7fa7c2cbe3c8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe3c8)[10]=[auth_proxy] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[11] at 0x7fa7c2cbe440 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe440)[11]=[expires] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: db_mysql_get_columns(): use DB1_INT result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[12] at 0x7fa7c2cbe4b8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe4b8)[12]=[flags] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: db_mysql_get_columns(): use DB1_INT result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[13] at 0x7fa7c2cbe530 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe530)[13]=[reg_delay] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: db_mysql_get_columns(): use DB1_INT result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[14] at 0x7fa7c2cbe5a8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe5a8)[14]=[contact_addr] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[15] at 0x7fa7c2cbe620 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe620)[15]=[socket] Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: db_mysql_get_columns(): use DB1_STRING result type Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:181]: db_mysql_convert_rows(): no rows returned from the query Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} sqlops [sql_api.c:494]: sql_exec_xquery(): no result after query Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:79]: db_free_columns(): freeing 16 columns Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[0] at 0x7fa7c2c91418 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[1] at 0x7fa7c2c91490 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[2] at 0x7fa7c2c91508 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[3] at 0x7fa7c2c91580 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[4] at 0x7fa7c2c915f8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[5] at 0x7fa7c2c91670 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[6] at 0x7fa7c2c916e8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[7] at 0x7fa7c2c91760 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[8] at 0x7fa7c2c917d8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[9] at 0x7fa7c2c91850 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[10] at 0x7fa7c2cbe3c8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[11] at 0x7fa7c2cbe440 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[12] at 0x7fa7c2cbe4b8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[13] at 0x7fa7c2cbe530 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[14] at 0x7fa7c2cbe5a8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): freeing RES_NAMES[15] at 0x7fa7c2cbe620 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:96]: db_free_columns(): freeing result names at 0x7fa7c2c91288 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:101]: db_free_columns(): freeing result types at 0x7fa7c2c91370 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:138]: db_free_result(): freeing result set at 0x7fa7c2c91170 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: exec: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} *** cfgtrace:dbg_cfg_trace(): request_route=[PSTN] c=[/usr/local/etc/kamailio/kamailio.cfg] l=1155 a=25 n=xlog Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Via] type 1 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Max-Forwards] type 8 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [From] type 4 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [To] type 3 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Call-ID] type 6 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [CSeq] type 5 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Contact] type 7 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [User-Agent] type 28 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Allow] type 21 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Supported] type 17 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Allow-Events] type 39 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Content-Type] type 11 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Content-Disposition] type 30 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Content-Length] type 12 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [X-Gateway] type 0 Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: ERROR: {1 53491654 INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <script>: (PSTN) SELECT * FROM sbc_uacreg WHERE l_uuid = 'GwProdIpAuth' ============================================================================= ``` ### Additional Information * **Kamailio Version** - output of `kamailio -v` ``` version: kamailio 5.7.0-dev0 (x86_64/linux) 0d9380 flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. id: 0d9380 compiled on 14:06:32 May 26 2022 with gcc 11.2.0 ``` * **Operating System**:  ``` Distributor ID: Ubuntu Description: Ubuntu 22.04 LTS Release: 22.04 Codename: jammy Linux ip-172-31-3-158 5.15.0-1011-aws #14-Ubuntu SMP Wed Jun 1 20:54:22 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux ``` -- Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/3163 You are receiving this because you are subscribed to this thread. Message ID: <kamailio/kamailio/issues/3163(a)github.com>

1 year, 8 months

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev September 2022