[OpenSIPS-Users] High Volume Accouting backend options

[Alex A]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200423/122d0874/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: opensips.cfg
Type: application/octet-stream
Size: 7774 bytes
Desc: not available
URL: <http://lists.opensips.org/pipermail/users/attachments/20200423/122d0874/attachment-0001.obj>