[asterisk-users] PJSIP realtime: lots of problems

[Michael Ulitskiy]

On Thursday, October 08, 2015 08:02:19 PM Stefan Tichy wrote:
> Hello Michael
> 
> On Thu, Oct 08, 2015 at 01:32:07PM -0400, Michael Ulitskiy wrote:
> > 
> > extconfig.conf:
> > [settings]
> > ps_endpoints => pgsql,users,pjsip_endpoints_v
> 
> Does it change anything if you use odbc instead of pgsql?
> I did some testing with chan_sip/pgsql and had much less problems
> when pgsql was replaced by odbc.

for some reason i can't make it work.
i've installed and configured odbc. asterisk tells me it's connected:

*CLI> odbc show 

ODBC DSN Settings                                                                                             
-----------------                                                                                             

  Name:   asterisk                                                                                            
  DSN:    asterisk                                                                                            
    Last connection attempt: 1969-12-31 19:00:00                                                              
  Pooled: No                                                                                                  
  Connected: Yes  

i've changed extconfig.conf as follows:
ps_endpoints => odbc,asterisk 

Now asterisk logs the following: 
WARNING[966]: config.c:2905 find_engine: Realtime mapping for 'ps_endpoints' found to engine 'odbc', but the engine is not available
and don't see any queries in database log. Am I doing something wrong?
 
> 
> > 1. The biggest problem: if I have small number of endpoints (roughly up to a 100) then
> > asterisk loads ok and pjsip seems to be working ok (with other problems described below). 
> > If I have larger number of endpoints (several hundred) then intermittently (but often) asterisk 
> > just hangs during loading. Attempting to start asterisk with console (-c) it never reaches the user 
> > prompt. pjsip isn't functional (doesn't reply to any sip messages).
> 
> Did you try "core show locks" in this situation?

Yes, it seems to deadlock in res_config_pgsql. 
I've opened an asterisk issue here: https://issues.asterisk.org/jira/browse/ASTERISK-25455
Will see where it goes.
Thanks,

Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20151008/355777ef/attachment.html>