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

[Asterisk Team (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-25475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=227933#comment-227933 ] 

Asterisk Team commented on ASTERISK-25475:
------------------------------------------

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

> 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)