[asterisk-bugs] [JIRA] (ASTERISK-26061) [patch] res_pjsip: improve realtime performance - remove updating all endpoints status on startup

[JoshE (JIRA)]

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

JoshE commented on ASTERISK-26061:
----------------------------------

Thanks for the response Alexei!

So on my 20,000, with your configuration, I am still seeing the 20,000 lookups at boot:

[2016-07-06 20:57:58] DEBUG[23520] res_odbc.c: Reusing ODBC handle 0x26dff78 from class 'config'
[2016-07-06 20:57:58] DEBUG[23520] res_config_odbc.c: Skip: 0; SQL: SELECT * FROM ps_contacts WHERE id LIKE ? ORDER BY id
[2016-07-06 20:57:58] DEBUG[23520] res_config_odbc.c: Parameter 1 ('id LIKE') = '130;@%'

Prior to the patch, having contact field in ps_aors as NULL would produce the "Endpoint ... is unavailable" at boot.  With your patch, those console logs are gone, but my 8 minute boot persists.  No real effect on startup time.

With sorcery cacheing on or off, it actually doesn't really affect the bootup time.  Pretty much stuck on the 8 minute mark regardless of whether it's on or off.  Seems to reduce DB load after that point however, but may not be worth the hassle operationally.

All of my aors (minus a small handful) are qualify_frequency > 0.

I'm going to take another look at where that's being generated and see if I don't have something else on my end that needs fixing, or I'll dig into the source.

Let me know if you have any other inspiration on this.

> [patch] res_pjsip: improve realtime performance - remove updating all endpoints status on startup
> -------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-26061
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26061
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_pjsip
>    Affects Versions: 13.9.1
>            Reporter: Alexei Gradinari
>
> The patch removes updating all Endpoints' status on startup.
> Instead, only non-qualified aors with static contact
> and non-qualified non-expired contacts are retrieved from the realtime to
> update the endpoint status to ONLINE.
> The endpoint name was added to the contact object to simply find the endpoint
> that created this contact.
> The status of endpoints with qualified aors will be updated by 'qualify'
> functions.



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