<html><head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  
  <meta content="text/html; charset=UTF-8" http-equiv="Content-Type"></head><body bgcolor="#FFFFFF" text="#000000" style="zoom: 0%;"><div dir="auto">Thank you<br><br></div>
<div dir="auto">I try it out via rabbitMQ event subscription<br><br></div>
<div class="gmail_quote" >On Apr 23, 2020, at 10:53 AM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">

  
    <tt>Hi Alex,<br>
      <br>
      Typical approach in this case is to do the accounting via a very
      fast backend (like db_flatstore, into a text file) and import the
      files off-sync into db (like every 5 mins).<br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>

</pre>
    <div class="moz-cite-prefix">On 4/23/20 4:37 PM, Alex A wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:171a7422dea.1247b83848131.3910812018483636749@gtanetworkconsulting.com">
      
      <div style="font-family: Verdana, Arial, Helvetica, sans-serif;          font-size: 10pt;">
        <div data-zbluepencil-ignore="true" style="" class="zmail_extra">
          <div>
            <div style="font-family: Verdana, Arial, Helvetica,                sans-serif;font-size: 10.0pt;">
              <div>Hi,<br>
              </div>
            </div>
          </div>
          <blockquote style="border-left: 1px solid rgb(204, 204, 204);              padding-left: 6px; margin: 0px 0px 0px 5px;">
            <div>
              <div style="font-family: Verdana, Arial, Helvetica,                  sans-serif;font-size: 10.0pt;">
                <div><br>
                </div>
                <div>We are looking to deploy accounting/homer
                  integration on Opensips 3.0.2. <br>
                </div>
                <div>As the first step deployed acc module with pgsql
                  backend. <br>
                </div>
                <div><br>
                </div>
                <div>The config seem to be pretty straight-forward - see
                  attached. <br>
                </div>
                <div><br>
                </div>
                <div>It appears that as soon as volume hits about 30-35k
                  in_use transactions - the server stops replying to new
                  requests (or give 408 Timeout) and syslog gets filled
                  with:<br>
                </div>
                <div><br>
                </div>
                <div>Apr 22 10:19:38 opensip1 opensips: Apr 22 10:19:38
                  [19258] CRITICAL:tm:set_timer: set_timer for 1 list
                  called on a "detached" timer -- ignoring:
                  0x7fb63b993cf8<br>
                </div>
                <div>Apr 22 10:19:40 opensip1 opensips: Apr 22 10:19:40
                  [19255] CRITICAL:tm:set_timer: set_timer for 1 list
                  called on a "detached" timer -- ignoring:
                  0x7fb638cf9a40<br>
                </div>
                <div>Apr 22 10:19:40 opensip1 opensips: Apr 22 10:19:40
                  [19260] CRITICAL:tm:set_timer: set_timer for 1 list
                  called on a "detached" timer -- ignoring:
                  0x7fb63f3b23c8<br>
                </div>
                <div>Apr 22 10:19:49 opensip1 opensips: Apr 22 10:19:49
                  [19258] CRITICAL:tm:set_timer: set_timer for 1 list
                  called on a "detached" timer -- ignoring:
                  0x7fb63eb93a80<br>
                </div>
                <div>Apr 22 10:20:01 opensip1 opensips: Apr 22 10:20:01
                  [19267] CRITICAL:tm:set_timer: set_timer for 1 list
                  called on a "detached" timer -- ignoring:
                  0x7fb5de690700<br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div>Although, the remote Postgres service is on SSD
                  with relatively small network latency, it appears to
                  be the bottleneck.<br>
                </div>
                <div>The initial assumption was the Opensips acc uses
                  no-blocking SQL calls (since cdrs are not real-time).<br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div>Another observation: <br>
                </div>
                <div>opensips only opens 20 SQL connections to postgres
                  via tcp 5432.  I have tried playing with
                  db_max_async_connections, however to no avail. <br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div>Any suggestions to troubleshoot ? or any
                  alternatives for accounting in high volume
                  applications would be greatly appreciated. <br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div>Thank you.<br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
                <div><br>
                </div>
              </div>
              <br>
            </div>
          </blockquote>
        </div>
        <div><br>
        </div>
      </div>
      <br>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  
</blockquote></div></body></html>