[SR-Users] [sr-dev] presence module makes excessive cleanups when subs_db_mode=3

[Andrew Pogrebennyk]

OK. Thank you, Peter.

On 11/09/2012 12:05 PM, Peter Dunkley wrote:
> This is by design.  When you have many thousands of presence
> subscriptions you need to service them evenly across time instead of in
> big lumps.
> 
> If you don't want this behaviour then you can set the notifier_processes
> modparam to 0.  But, if you do this you should consider not using
> subs_db_mode 3 as there are many race-hazards in presence that are fixed
> by using the notifier_processes.
> 
> Regards,
> 
> Peter
> 
> On Fri, 2012-11-09 at 12:01 +0100, Andrew Pogrebennyk wrote:
>> Hi,
>> when presence module is running with subs_db_mode=3 it makes an
>> excessive number of SQL select queries, litelly dozens per second:
>> > 		25232 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=64 AND event<>'presence.winfo'
>> > 		25233 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=116 AND event<>'presence.winfo'
>> > 		25233 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=116 AND event='presence.winfo'
>> > 		25232 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=64 AND event='presence.winfo'
>> > 		25231 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=14 AND event<>'presence.winfo'
>> > 		25231 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=14 AND event='presence.winfo'
>> > 		25233 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=118 AND event<>'presence.winfo'
>> > 		25232 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=66 AND event<>'presence.winfo'
>> > 		25233 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=118 AND event='presence.winfo'
>> > 		25232 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=66 AND event='presence.winfo'
>> > 		25231 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=16 AND event<>'presence.winfo'
>> > 		25231 Query	select presentity_uri,callid,to_tag,from_tag,event from active_watchers where updated=16 AND event='presence.winfo'
>>
>> Steps to reproduce: registers two subscribers in jitsi and add them to
>> contact lists of each other.
>> The kamailio version is 3.3.2. I'm not doing anything special
>> configuration-wise:
>>
>> loadmodule "presence.so"
>> modparam("presence", "db_url", "mysql://kamailio:snbF93@localhost/kamailio")
>> # in 3.3 the fallback2db change to subs_db_mode
>> modparam("presence", "subs_db_mode", 3)
>> modparam("presence", "notifier_processes", 3)
>>
>>
>> loadmodule "presence_xml.so"
>> modparam("presence_xml", "db_url",
>> "mysql://kamailio:snbF93@localhost/kamailio")
>> modparam("presence_xml", "force_active", 0)
>> modparam("presence_xml", "integrated_xcap_server", 1)
>> # retry-after 5 minutes
>> modparam("presence_xml", "xcapauth_userdel_reason",
>> "probation;retry-after=300")
>>
>> Q: it is a bug of a feature? :)
>> Thanks.
>> Andrew
>>
>> _______________________________________________
>> sr-dev mailing list
>> sr-dev at lists.sip-router.org <mailto:sr-dev at lists.sip-router.org>
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
> 
> -- 
> Peter Dunkley
> Technical Director
> Crocodile RCS Ltd
> 
> 
> 
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>