[OpenSIPS-Users] High Volume Accouting backend options

Bogdan-Andrei Iancu bogdan at opensips.org
Fri Apr 24 08:16:05 EST 2020


Just note that RMQ may be lighter than SQL DBs, but much slower than 
db_flatstore.

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
   https://www.opensips-solutions.com

On 4/24/20 1:42 AM, Alex A wrote:
> Thank you
>
> I try it out via rabbitMQ event subscription
>
> On Apr 23, 2020, at 10:53 AM, Bogdan-Andrei Iancu <bogdan at opensips.org 
> <mailto:bogdan at opensips.org>> wrote:
>
>     Hi Alex,
>
>     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).
>
>     Regards,
>
>     Bogdan-Andrei Iancu
>
>     OpenSIPS Founder and Developer
>        https://www.opensips-solutions.com
>
>     On 4/23/20 4:37 PM, Alex A wrote:
>>     Hi,
>>
>>
>>         We are looking to deploy accounting/homer integration on
>>         Opensips 3.0.2.
>>         As the first step deployed acc module with pgsql backend.
>>
>>         The config seem to be pretty straight-forward - see attached.
>>
>>         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:
>>
>>         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
>>         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
>>         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
>>         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
>>         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
>>
>>
>>         Although, the remote Postgres service is on SSD with
>>         relatively small network latency, it appears to be the
>>         bottleneck.
>>         The initial assumption was the Opensips acc uses no-blocking
>>         SQL calls (since cdrs are not real-time).
>>
>>
>>         Another observation:
>>         opensips only opens 20 SQL connections to postgres via tcp
>>         5432.  I have tried playing with db_max_async_connections,
>>         however to no avail.
>>
>>
>>         Any suggestions to troubleshoot ? or any alternatives for
>>         accounting in high volume applications would be greatly
>>         appreciated.
>>
>>
>>         Thank you.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200424/45d80d6d/attachment.html>


More information about the Users mailing list