Since there is no way to limit the result set to 1, I tried to use raw_query inside msilo module. Everytime it executes, it is crashing. The same query if I run in mysql shell, it is returning successfully.
query_len = snprintf(query, 2048, "SELECT * FROM %.*s WHERE %.*s='%.*s' AND %.*s='%.*s' AND %.*s!=%i AND %.*s<%i LIMIT 1;", ms_db_table.len, ms_db_table.s, sc_uri_touser.len, sc_uri_touser.s, puri.user.len, puri.user.s, sc_uri_tohost.len, sc_uri_tohost.s, puri.host.len, puri.host.s, sc_status.len, sc_status.s, 200, sc_status.len, sc_status.s, MSG_NOTIFY_OFFSET);
if (query_len < 0) {
LM_ERR("error in sql snprintf");
goto error;
}
LM_DBG("m_dump_msg: Query=%s\n", query);
query_str.s = query;
query_str.len = query_len;
if (msilo_dbf.raw_query(db_con, &query_str, &db_res) < 0) {
LM_ERR("Failed to query database. Query = %s\n", query);
goto error;
}
The Debug Log at Level 4 shows following:
11(7520) DEBUG: msilo [msilo.c:1120]: m_dump_msg: Query=SELECT * FROM silo WHERE tousername='968257197' AND todomain='50.62.1.7' AND status!=200 AND status<1000 LIMIT 1;
11(7520) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result set at 0x7fdd4b605540
11(7520) DEBUG: db_mysql [km_res.c:68]: 16 columns returned from the query
11(7520) DEBUG: <core> [db_res.c:155]: allocate 128 bytes for result names at 0x7fdd4b5d8dc0
11(7520) DEBUG: <core> [db_res.c:165]: allocate 64 bytes for result types at 0x7fdd4b5d8e60
11(7520) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for RES_NAMES[0] at 0x7fdd4b5d8d90
11(7520) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x7fdd4b5d8d90)[0]=[id]
11(7520) DEBUG: db_mysql [km_res.c:100]: use DB1_INT result type
11(7520) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for RES_NAMES[1] at 0x7fdd4b5d8d60
11(7520) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x7fdd4b5d8d60)[1]=[src_addr]
11(7520) DEBUG: db_mysql [km_res.c:136]: use DB1_STRING result type
11(7520) DEBUG: db_mysql [km_res.c:85]: allocate 16 bytes for RES_NAMES[2] at 0x7fdd4b5d8d30
11(7520) DEBUG: db_mysql [km_res.c:92]: RES_NAMES(0x7fdd4b5d8d30)[2]=[dst_addr]
11(7520) DEBUG: db_mysql [km_res.c:136]: use DB1_STRING result type
<skip>
11(7520) DEBUG: <core> [db_val.c:117]: converting STRING [ac3aeddd9b6f45e6822c824aa2c133b2]
11(7520) DEBUG: <core> [db_val.c:73]: converting INT [0]
11(7520) DEBUG: <core> [db_val.c:73]: converting INT [1]
26(7552) : <core> [pass_fd.c:293]: ERROR: receive_fd: EOF on 22
26(7552) DEBUG: <core> [tcp_main.c:3592]: DBG: handle_ser_child: dead child 11, pid 7520 (shutting down?)
26(7552) DEBUG: <core> [io_wait.h:617]: DBG: io_watch_del (0x842d20, 22, -1, 0x0) fd_no=44 called
26(7552) DEBUG: <core> [tcp_main.c:3353]: DBG: handle_tcp_child: dead tcp child 1 (pid 7520, no 11) (shutting down?)
26(7552) DEBUG: <core> [io_wait.h:617]: DBG: io_watch_del (0x842d20, 25, -1, 0x0) fd_no=43 called
0(7509) ALERT: <core> [main.c:787]: child process 7520 exited by a signal 11
0(7509) ALERT: <core> [main.c:790]: core was not generated
0(7509) INFO: <core> [main.c:802]: INFO: terminating due to SIGCHLD
As you can see something happening to Database connection. Not sure why I am unable to use raw_query. Normal API query from msilo works just fine.
What am I doing wrong to make it crash?
Thanks
Krish Kura