24 Jun
2022
24 Jun
'22
7:23 p.m.
### 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**:
<!--
Details about the operating system, the type: Linux (e.g.,: Debian 8.4, Ubuntu 16.04,
CentOS 7.1, ...), MacOS, xBSD, Solaris, ...;
Kernel details (output of `lsb_release -a` and `uname -a`)
-->
```
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 Jul
1 Jul
12:31 p.m.
The C code returns 2 when there is no result coming back from the db server. The docs are
misleading or are not sync'ed with the code. There is a db result coming back in this
case which includes the columns, just no rows.
For now, you can check if the `$xavp(ra)` is null or not.
We have to make the docs and code coherent in a way or another.
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3163#issuecomment-1172199119
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issues/3163/1172199119(a)github.com>
1:51 p.m.
Actually, I misread the code and it should return 2, the log:
```
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
```
It is from the file and line:
- https://github.com/kamailio/kamailio/blob/master/src/modules/sqlops/sql_api…
It could be the IF evaluation, try:
```
sql_xquery("con", "SELECT * FROM sbc_uacreg WHERE l_uuid =
'$hdr(X-Gateway)'", "ra");
if($rc == 1) {
```
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3163#issuecomment-1172262791
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issues/3163/1172262791(a)github.com>
1 Sep
1 Sep
10:32 a.m.
Closing due to long time inactivity and the code seemed ok on quick check.
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3163#issuecomment-1233936568
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issues/3163/1233936568(a)github.com>
10:32 a.m.
Closed #3163 as completed.
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3163#event-7302963485
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issue/3163/issue_event/7302963485(a)github.com>
600
days inactive
669
days old
4 comments
2 participants
participants (2)
-
admin-toneca -
Daniel-Constantin Mierla