<HTML><BODY><div><br>(gdb) bt full<br>#0 0x00000000004fd108 in free_contacts ()<br>No symbol table info available.<br>#1 0x00000000004fe907 in free_contact ()<br>No symbol table info available.<br>#2 0x00000000004d1a19 in clean_hdr_field ()<br>No symbol table info available.<br>#3 0x00007f728e5226d2 in clean_msg_clone (msg=0x7f728f0ef490, max=0x7f728f0f11b8, min=0x7f728f0ef490) at sip_msg.h:116<br> hdr = 0x7f728f0f0f78<br>#4 run_trans_callbacks_locked (type=type@entry=128, trans=trans@entry=0x7f728fa39a98, req=<optimized out>, rpl=rpl@entry=0x7f729ee0c8a0, code=code@entry=487) at t_hooks.c:265<br>No locals.<br>#5 0x00007f728e4edca1 in relay_reply (t=<optimized out>, p_msg=<optimized out>, branch=<optimized out>, msg_status=<optimized out>, cancel_bitmap=<optimized out>) at t_reply.c:1353<br> relay = 0<br> save_clone = 0<br> buf = 0x7f729ee10610 "SIP/2.0 487 Request Terminated\r\nVia:SIP/2.0/SCTP 10.93.137.170:5060;branch=z9hG4bK64779ifCh47j_BY6;yop=00.00.DFA3F6A2.0000.701E\r\nFrom:<sip:9285831720@yyy.xxx.ru;user=phone>;tag=0WDhcAZ.Ua9"...<br> res_len = 548<br> relayed_code = 487<br> relayed_msg = 0x7f729ee0c8a0<br> bm = {to_tag_val = {s = 0x78 <Address 0x78 out of bounds>, len = -1907418374}}<br> totag_retr = 0<br> reply_status = RPS_COMPLETED<br> uas_rb = <optimized out><br> cb_s = {<br> s = 0x7f729ee10610 "SIP/2.0 487 Request Terminated\r\nVia:SIP/2.0/SCTP 10.93.137.170:5060;branch=z9hG4bK64779ifCh47j_BY6;yop=00.00.DFA3F6A2.0000.701E\r\nFrom:<sip:9285831720@yyy.xxx.ru;user=phone>;tag=0WDhcAZ.Ua9"..., len = 548}<br> text = {s = 0x634b623400000000 <Address 0x634b623400000000 out of bounds>, len = 775239475}<br> __FUNCTION__ = "relay_reply"<br>#6 0x00007f728e4f02bd in reply_received (p_msg=0x7f729ee0c8a0) at t_reply.c:1603<br> msg_status = 487<br> last_uac_status = 100<br> branch = 0<br> reply_status = <optimized out><br> timer = 8982449<br> cancel_bitmap = 0<br> uac = 0x7f728fa39c70<br> t = 0x7f728fa39a98<br> backup_list = <optimized out><br> has_reply_route = <optimized out><br> __FUNCTION__ = "reply_received"<br>#7 0x000000000044fe7f in forward_reply ()<br>No symbol table info available.<br>#8 0x0000000000437bfd in receive_msg ()<br>No symbol table info available.<br>#9 0x0000000000536bb0 in udp_read_req ()<br>No symbol table info available.<br>#10 0x00000000005218ca in udp_start_processes ()<br>No symbol table info available.<br>#11 0x000000000041b8a5 in main ()<br>No symbol table info available.<br> <blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">Понедельник, 16 марта 2020, 1:41 +03:00 от users-request@lists.opensips.org:<br> <div id=""><div class="js-helper js-readmsg-msg"><style type="text/css"></style><div><div id="style_15843121010722953226_BODY">Send Users mailing list submissions to<br><a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>or, via email, send a message with subject or body 'help' to<br><a href="/compose?To=users%2drequest@lists.opensips.org">users-request@lists.opensips.org</a><br><br>You can reach the person managing the list at<br><a href="/compose?To=users%2downer@lists.opensips.org">users-owner@lists.opensips.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: segfault at the opensips 2.4.5 (Liviu Chircu)<br> (Johan De Clercq)<br> 2. Escape spaces in From and Contact (Calvin Ellison)<br> 3. db_mysql_convert_rows says no rows but there is one<br> (Calvin Ellison)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sun, 15 Mar 2020 17:05:24 +0000<br>From: Johan De Clercq <<a href="/compose?To=johan@democon.be">johan@democon.be</a>><br>To: Oleg Podguyko <<a href="/compose?To=podguiko@mail.ru">podguiko@mail.ru</a>>, OpenSIPS users mailling list<br><<a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a>><br>Subject: Re: [OpenSIPS-Users] segfault at the opensips 2.4.5 (Liviu<br>Chircu)<br>Message-ID:<br><<a href="/compose?To=AM0PR06MB6226CF9A922D9A627FFFC011A7F80@AM0PR06MB6226.eurprd06.prod.outlook.com">AM0PR06MB6226CF9A922D9A627FFFC011A7F80@AM0PR06MB6226.eurprd06.prod.outlook.com</a>><br><br>Content-Type: text/plain; charset="cp1251"<br><br>Do a backtrace and post the output please.<br><br>Outlook voor iOS<https://aka.ms/o0ukef> downloaden<br>________________________________<br>Van: Users <<a href="/compose?To=users%2dbounces@lists.opensips.org">users-bounces@lists.opensips.org</a>> namens Oleg Podguyko via Users <<a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a>><br>Verzonden: Sunday, March 15, 2020 5:32:58 PM<br>Aan: <a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a> <<a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a>><br>Onderwerp: Re: [OpenSIPS-Users] segfault at the opensips 2.4.5 (Liviu Chircu)<br><br>Hi Liviu!<br><br> I installed version 2.4.7 but continue to have problems with segfault…<br>These are the lines from opensips.log<br><br>Mar 15 15:53:01 xx-spx-2 /usr/sbin/opensips[25271]: CRITICAL:core:sig_usr: segfault in process pid: 25271, id: 11<br>Mar 15 15:53:02 xx-spx-2 /usr/sbin/opensips[25258]: NOTICE:event_jsonrpc:destroy: destroy module ...<br>Mar 15 15:53:02 xx-spx-2 /usr/sbin/opensips[30598]: NOTICE:core:main: version: opensips 2.4.7 (x86_64/linux)<br>Mar 15 15:53:02 xx-spx-2 /usr/sbin/opensips[30598]: WARNING:core:init_reactor_size: shrinking reactor size from 262144 (autodetected via rlimit) to 52428 (limited by memory of 10% from 16Mb)<br>Mar 15 15:53:02 xx-spx-2 /usr/sbin/opensips[30598]: WARNING:core:init_reactor_size: use 'open_files_limit' to enforce other limit or increase pkg memory<br>Mar 15 15:53:02 xx-spx-2 /usr/sbin/opensips[30598]: NOTICE:signaling:mod_init: initializing module ...<br>Mar 15 15:53:02 xx-spx-2 /usr/sbin/opensips[30598]: NOTICE:event_jsonrpc:mod_init: initializing module ...<br><br><br><br>These are the lines from /var/log/messages<br><br>Mar 15 15:53:01 xx-spx-2 kernel: opensips[25271]: segfault at 3836312e58 ip 00000000004fd108 sp 00007fff71716b20 error 4 in opensips[400000+1ae000]<br>Mar 15 15:53:01 xx-spx-2 spx: 2020-03-15T15:53:01.962556+00:00 [warning] <0.1372.0>@sf_osip_mi:handle_event/4:416 <0.20248.5575> connection down: closed (killed: [], unprocessed: [])<br>Mar 15 15:53:01 xx-spx-2 spx: 2020-03-15T15:53:01.975763+00:00 [warning] <0.1372.0>@sf_osip_mi:handle_event/4:426 connection failed, reason {shutdown,econnrefused}<br>Mar 15 15:53:01 xx-spx-2 spx: 2020-03-15T15:53:01.978919+00:00 [warning] <0.1372.0>@sf_osip_mi:handle_event/4:422 connection failed, reason {shutdown,econnrefused}<br>Mar 15 15:53:02 xx-spx-2 systemd: opensips.service: main process exited, code=exited, status=11/n/a<br>Mar 15 15:53:02 xx-spx-2 pkill: pkill: pidfile not valid<br>Mar 15 15:53:02 xx-spx-2 pkill: Try `pkill --help' for more information.<br>Mar 15 15:53:02 xx-spx-2 systemd: opensips.service: control process exited, code=exited status=1<br>Mar 15 15:53:02 xx-spx-2 systemd: Unit opensips.service entered failed state.<br>Mar 15 15:53:02 xx-spx-2 systemd: opensips.service failed.<br>Mar 15 15:53:02 xx-spx-2 spx: 2020-03-15T15:53:02.081992+00:00 [warning] <0.1372.0>@sf_osip_mi:handle_event/4:422 connection failed, reason {shutdown,econnrefused}<br>Mar 15 15:53:02 xx-spx-2 spx: 2020-03-15T15:53:02.184911+00:00 [warning] <0.1372.0>@sf_osip_mi:handle_event/4:422 connection failed, reason {shutdown,econnrefused}<br>Mar 15 15:53:02 xx-spx-2 systemd: opensips.service holdoff time over, scheduling restart.<br>Mar 15 15:53:02 xx-spx-2 systemd: Stopped OpenSIPS is a very fast and flexible SIP (RFC3261) server.<br>Mar 15 15:53:02 xx-spx-2 systemd: Starting OpenSIPS is a very fast and flexible SIP (RFC3261) server...<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: Mar 15 15:53:02 [30587] NOTICE:core:main: config file ok, exiting...<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: Listening on<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: udp: 192.168.9.38 [192.168.9.38]:5060<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: sctp: 10.161.20.226 [10.161.20.226]:5060<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: hep_udp: 192.168.9.38 [192.168.9.38]:6060<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: Aliases:<br>Mar 15 15:53:02 xx-spx-2 opensips-m4cfg: sctp: XXX-XXXXX:5060<br>Mar 15 15:53:02 xx-spx-2 opensips: Listening on<br>Mar 15 15:53:02 xx-spx-2 opensips: udp: 192.168.9.38 [192.168.9.38]:5060<br>Mar 15 15:53:02 xx-spx-2 opensips: sctp: 10.161.20.226 [10.161.20.226]:5060<br>Mar 15 15:53:02 xx-spx-2 opensips: hep_udp: 192.168.9.38 [192.168.9.38]:6060<br>Mar 15 15:53:02 xx-spx-2 opensips: Aliases:<br>Mar 15 15:53:02 xx-spx-2 opensips: sctp: VMS-STAGE:5060<br>Mar 15 15:53:02 xx-spx-2 systemd: Started OpenSIPS is a very fast and flexible SIP (RFC3261) server.<br><br><br><br>What’s wrong?<br>Четверг, 12 марта 2020, 20:00 +03:00 от users-request@lists.opensips.org:<br><br>Send Users mailing list submissions to<br>users@lists.opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dusers@lists.opensips.org">/compose?To=users@lists.opensips.org</a>><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>or, via email, send a message with subject or body 'help' to<br>users-request@lists.opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dusers%252drequest@lists.opensips.org">/compose?To=users%2drequest@lists.opensips.org</a>><br><br>You can reach the person managing the list at<br>users-owner@lists.opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dusers%252downer@lists.opensips.org">/compose?To=users%2downer@lists.opensips.org</a>><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Users digest..."<br><br><br>Today's Topics:<br><br> 1. Re: segfault at the opensips 2.4.5 (Liviu Chircu)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Thu, 12 Mar 2020 18:43:42 +0200<br>From: Liviu Chircu <liviu@opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dliviu@opensips.org">/compose?To=liviu@opensips.org</a>>><br>To: OpenSIPS users mailling list <users@lists.opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dusers@lists.opensips.org">/compose?To=users@lists.opensips.org</a>>><br>Subject: Re: [OpenSIPS-Users] segfault at the opensips 2.4.5<br>Message-ID: <de7e2af8-687e-58da-1804-5d42af260436@opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dde7e2af8%252d687e%252d58da%252d1804%252d5d42af260436@opensips.org">/compose?To=de7e2af8%2d687e%2d58da%2d1804%2d5d42af260436@opensips.org</a>>><br>Content-Type: text/plain; charset=utf-8; format=flowed<br><br>On 12.03.2020 18:32, Oleg Podguyko via Users wrote:<br>><br>> How opensips handles segfault? And what needs to be done so that he<br>> does not die just like in the latter case?<br><br>Hi Oleg,<br><br>If one of the workers segfaults, OpenSIPS will perform a graceful<br>shutdown to the best of its ability, in the following order:<br><br>* each remaining SIP worker gets sent a high-priority termination job.<br>Once they finish processing the current SIP message, they will run this<br>job and terminate<br>* once all workers are stopped:<br> * the dialog module will synchronize all in-memory dialogs to the<br>"dialog" table one last time<br> * the usrloc module will synchronize all in-memory contacts to the<br>"location" table, etc.<br><br>Seeing that you are running 2.4.5, my advice would be to update to 2.4.7<br>nightly [1] as soon as possible. You are missing roughly 1 year worth<br>of fixes, which is huge!<br><br>Best regards,<br><br>[1]: <a href="https://apt.opensips.org/packages.php?v=2.4" target="_blank">https://apt.opensips.org/packages.php?v=2.4</a><br><br>--<br>Liviu Chircu<br><a href="http://www.twitter.com/liviuchircu" target="_blank">www.twitter.com/liviuchircu</a><<a href="http://www.twitter.com/liviuchircu" target="_blank">http://www.twitter.com/liviuchircu</a>> | <a href="http://www.opensips-solutions.com" target="_blank">www.opensips-solutions.com</a><<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a>><br><br>OpenSIPS Summit, Amsterdam, May 2020<br> <a href="http://www.opensips.org/events" target="_blank">www.opensips.org/events</a><<a href="http://www.opensips.org/events" target="_blank">http://www.opensips.org/events</a>><br><br><br><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Users mailing list<br>Users@lists.opensips.org<<a href="/compose?To=%2fcompose%3fTo%3dUsers@lists.opensips.org">/compose?To=Users@lists.opensips.org</a>><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br><br><br>------------------------------<br><br>End of Users Digest, Vol 140, Issue 48<br>**************************************<br><br><br>--<br>Олег Подгуйко<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.opensips.org/pipermail/users/attachments/20200315/bfceb182/attachment-0001.html" target="_blank">http://lists.opensips.org/pipermail/users/attachments/20200315/bfceb182/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 2<br>Date: Sun, 15 Mar 2020 15:29:13 -0700<br>From: Calvin Ellison <<a href="/compose?To=calvin.ellison@voxox.com">calvin.ellison@voxox.com</a>><br>To: OpenSIPS users mailling list <<a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a>><br>Subject: [OpenSIPS-Users] Escape spaces in From and Contact<br>Message-ID:<br><<a href="/compose?To=CAL%2bQDG_c4HWdyWWpKZkzyoOWebX8bh2Fw%2b_T%3d8%2dCi3KxyHXsVg@mail.gmail.com">CAL+QDG_c4HWdyWWpKZkzyoOWebX8bh2Fw+_T=8-Ci3KxyHXsVg@mail.gmail.com</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>There is a broken client outside of my control sending From and Contact<br>with spaces in the URI userinfo part, e.g.<br><br>From: <sip:18669060504 @...<br>or<br>Contact: <sip:SF Bay Ferry@...<br><br>I have an error route to send back "400 bad header" but I'd rather process<br>them to return the intended 302 redirect. Can I fix these broken headers?<br><br>I'm also going to ask Sansay why they aren't rejecting these at our edge.<br><br>Regards,<br><br>*Calvin Ellison*<br>Senior Voice Operations Engineer<br><a href="/compose?To=calvin.ellison@voxox.com">calvin.ellison@voxox.com</a><br><span class="js-phone-number">+1 (213) 285-0555</span><br><br>-----------------------------------------------<br>*voxox.com <<a href="http://www.voxox.com/" target="_blank">http://www.voxox.com/</a>> *<br>5825 Oberlin Drive, Suite 5<br>San Diego, CA 92121<br>[image: Voxox]<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.opensips.org/pipermail/users/attachments/20200315/359fc104/attachment-0001.html" target="_blank">http://lists.opensips.org/pipermail/users/attachments/20200315/359fc104/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 3<br>Date: Sun, 15 Mar 2020 15:40:52 -0700<br>From: Calvin Ellison <<a href="/compose?To=calvin.ellison@voxox.com">calvin.ellison@voxox.com</a>><br>To: OpenSIPS users mailling list <<a href="/compose?To=users@lists.opensips.org">users@lists.opensips.org</a>><br>Subject: [OpenSIPS-Users] db_mysql_convert_rows says no rows but there<br>is one<br>Message-ID:<br><<a href="/compose?To=CAL%2bQDG_yR0sKus4AnZBBrK0E%2b56ap9cSTdoDLuS%2dHOW2%2bLk9%3dw@mail.gmail.com">CAL+QDG_yR0sKus4AnZBBrK0E+56ap9cSTdoDLuS-HOW2+Lk9=w@mail.gmail.com</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>This does not happen on every query response but will happen on every<br>response for the same query. CLI mysql and mariadb clients show the result<br>row correctly, and pcaps confirm that opensips is getting the row response<br>(attached).<br><br>I recompiled opensips against libmariadbclient (Ubuntu<br>libmariadbclient-dev-compat) but that did not change the behavior. Debug<br>for a working and non-working query below.<br><br>Pcap:<br><a href="https://drive.google.com/file/d/1Un8dx8T3eFEhe8_jYIONrLVGhiQ6Xhj6/view?usp=sharing" target="_blank">https://drive.google.com/file/d/1Un8dx8T3eFEhe8_jYIONrLVGhiQ6Xhj6/view?usp=sharing</a><br><br>opensips -V<br>version: opensips 2.4.7 (x86_64/linux)<br>flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC, F_MALLOC,<br>FAST_LOCK-ADAPTIVE_WAIT<br>ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,<br>MAX_URI_SIZE 1024, BUF_SIZE 65535<br>poll method support: poll, epoll, sigio_rt, select.<br>git revision: 9e1fcc915<br>main.c compiled on with gcc 7<br><br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]:<br>DBG:avpops:ops_async_dbquery: query [call<br>lrn.fulldataz('6198077359',curdate())]<br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]: DBG:core:db_init_async:<br>>> 1/220 transfers: (6 - 0x7fb7cc2f5ec8)<br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected<br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]: DBG:tm:t_handle_async:<br>placing async job into reactor<br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]: DBG:tm:io_watch_add:<br>[UDP_worker] io_watch_add op (6 on 12) (0x5605efdf65a0, 6, 16,<br>0x7fb78c103358,1), fd_no=4/104857<br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]:<br>DBG:core:destroy_avp_list: destroying list (nil)<br>Mar 14 20:18:57 localhost /usr/sbin/opensips[2158]: DBG:core:receive_msg:<br>cleaning up<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]: DBG:tm:t_resume_async:<br>resuming on fd 6, transaction 0x7fb78c1001a0<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_async_resume: mysql_read_query_result: 0, 00000 - ""<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]: DBG:core:db_new_result:<br>allocate 48 bytes for result set at 0x7fb7cc2f4ac8<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: 15 columns returned from the query<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:core:db_allocate_columns: allocate 420 bytes for result columns at<br>0x7fb7cc2f6878<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f68f0)[0]=[number]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6900)[1]=[lrn]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6910)[2]=[port type]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_INT result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6920)[3]=[state]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6930)[4]=[network]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6940)[5]=[ocn]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6950)[6]=[ratecenter]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6960)[7]=[class]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6970)[8]=[lata]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6980)[9]=[country]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f6990)[10]=[reachable]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_BIGINT result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f69a0)[11]=[reason]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f69b0)[12]=[dnc]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_INT result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f69c0)[13]=[good]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_BIGINT result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7fb7cc2f69d0)[14]=[delay]<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_get_columns: use DB_DOUBLE result type<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:db_mysql:db_mysql_convert_rows: no rows returned from the query<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:core:db_store_async_con: >> restore conn 0x7fb7cc2f5ec8<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:avpops:resume_async_dbquery: query returned no results<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:core:db_free_columns: freeing result columns at 0x7fb7cc2f6878<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]: DBG:core:db_free_rows:<br>freeing 0 rows<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]:<br>DBG:core:db_free_result: freeing result set at 0x7fb7cc2f4ac8<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]: DBG:tm:io_watch_del:<br>[UDP_worker] io_watch_del op on index -1 6 (0x5605efdf65a0, 6, -1,<br>0x10,0x1) fd_no=5 called<br>Mar 14 20:18:58 localhost /usr/sbin/opensips[2158]: DBG:core:cachedb_store:<br>from script [memcached] - with grp [lrn]<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.opensips.org/pipermail/users/attachments/20200315/6f81c8cd/attachment.html" target="_blank">http://lists.opensips.org/pipermail/users/attachments/20200315/6f81c8cd/attachment.html</a>><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Users mailing list<br><a href="/compose?To=Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br><br><br>------------------------------<br><br>End of Users Digest, Vol 140, Issue 55<br>**************************************</div></div></div></div></blockquote> <div> </div><div data-signature-widget="container"><div data-signature-widget="content"><div>--<br>Олег Подгуйко</div></div></div><div> </div></div></BODY></HTML>