[OpenSIPS-Devel] [opensips] OpenSIPs Crash when using db_http module (#405)

[apsaras]

Hi

I have the following env
Debian 64bit
OpenSIPs 1.11.3-notls

I am using MemCached and db_http in order to resolve number portability with the following script

modparam("avpops", "db_url", "5 http://x.x.x.x/services")
modparam("avpops","avp_table","GetNumberRouting")
modparam("cachedb_memcached", "cachedb_url","memcached:first://x.x.x.x/")
modparam("cachedb_memcached", "cachedb_url","memcached:second://x.x.x.y/")
modparam("cachedb_memcached", "exec_threshold", 150000)
modparam("db_http", "SSL", 0)
..........
xlog("Check if the number is in portability cache [$avp(num)]");
if(!cache_fetch("memcached:first","$avp(num)",$avp(net)))
{
   xlog("[$avp(num)] Not in cache 1. Query cache 2.");
   if(!cache_fetch("memcached:second","$avp(num)",$avp(net)))
   {
     xlog("[$avp(num)] Not in cache 2. Doing Query to DB_HTTP");
     avp_db_query("$avp(num)","$avp(net)","5");
   }
}

If the number can not be found at Memcached 1, new query sent to Memcached 2 and if not found there as well, third query is sent to db_http resource.

When happens that I get the following

Jan 29 23:12:03 opensips1 /sbin/opensips[5002]: Check if the number is in portability cache [211xxxxxx]
Jan 29 23:12:03 opensips1 /sbin/opensips[5002]: DBG:core:cachedb_fetch: from script [memcached] - with grp [first]
Jan 29 23:12:03 opensips1 /sbin/opensips[5002]: [211xxxxxx] Not in cache 1. Query cache 2.
Jan 29 23:12:03 opensips1 /sbin/opensips[5002]: DBG:core:cachedb_fetch: from script [memcached] - with grp [second]
Jan 29 23:12:03 opensips1 /sbin/opensips[5002]: [211xxxxxx] Not in cache 2. Doing Query to DB_HTTP
Jan 29 23:12:03 opensips1 /sbin/opensips[5002]: DBG:avpops:ops_dbquery_avps: query [211xxxxxx]
Jan 29 23:12:03 opensips1 /sbin/opensips[5064]: CRITICAL:core:receive_fd: EOF on 10
Jan 29 23:12:03 opensips1 /sbin/opensips[5064]: DBG:core:handle_ser_child: dead child 3, pid 5002 (shutting down?)
Jan 29 23:12:03 opensips1 /sbin/opensips[5064]: DBG:core:io_watch_del: io_watch_del op on index -1 10 (0x822ec0, 10, -1, 0x0,0x1) fd_no=95 called
Jan 29 23:12:03 opensips1 /sbin/opensips[5064]: INFO:core:sig_usr: signal 15 received
Jan 29 23:12:03 opensips1 /sbin/opensips[5061]: INFO:core:sig_usr: signal 15 received
Jan 29 23:12:03 opensips1 /sbin/opensips[5058]: INFO:core:sig_usr: signal 15 received
Jan 29 23:12:03 opensips1 /sbin/opensips[5060]: INFO:core:sig_usr: signal 15 received
Jan 29 23:12:03 opensips1 /sbin/opensips[5063]: INFO:core:sig_usr: signal 15 received


---
Reply to this email directly or view it on GitHub:
https://github.com/OpenSIPS/opensips/issues/405
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20150129/bb94afaa/attachment.htm>