[asterisk-bugs] [JIRA] (ASTERISK-25475) PJSIP completeion of endpoints name results in query storm and takes a very long time

[mdu113 (JIRA)]

mdu113 created ASTERISK-25475:
---------------------------------

             Summary: PJSIP completeion of endpoints name results in query storm and takes a very long time
                 Key: ASTERISK-25475
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25475
             Project: Asterisk
          Issue Type: Improvement
      Security Level: None
          Components: Channels/chan_pjsip, Resources/res_pjsip
    Affects Versions: 13.6.0
         Environment: linux 64bit
kernel 3.10.17
distro slackware64 14.1 
pjproject 2.4.5
asterisk 13.6.0
            Reporter: mdu113
            Severity: Minor


If I type "pjsip show endpoint" in the console and then
press "Tab" asking for name completion then asterisk hangs for over a minute and I register over 300 queries like this in the db log:
 
SELECT * FROM pjsip_endpoints_v WHERE id LIKE '%' ORDER BY id

At the moment of test I have 173 endpoints in the database.
Issue was commented by Matthew Jordan here: 
http://lists.digium.com/pipermail/asterisk-dev/2015-October/075127.html




--
This message was sent by Atlassian JIRA
(v6.2#6252)