<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">While debugging presence, I found a lot
of the following lines on the freeswitch console</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><tt>2021-03-11 13:26:34.496493 [CRIT]
sofia_presence.c:1377 CHECK SQL: <a class="moz-txt-link-abbreviated" href="mailto:9886@customer.mydomain.net">9886@customer.mydomain.net</a>
[select state,status,rpid,presence_id,uuid from sip_dialogs
where call_info_state != 'seized' and
hostname='fs02.mydomain.net' and profile_name='internal' and
((sip_from_user='9886' and
sip_from_host='customer.mydomain.net') or
presence_id='<a class="moz-txt-link-abbreviated" href="mailto:9886@customer.mydomain.net">9886@customer.mydomain.net</a>') order by rcd desc]</tt><tt><br>
</tt><tt>2021-03-11 13:26:34.496493 [ERR] sofia_presence.c:1435
PRES SQL update sip_subscriptions set version=version+1 where
hostname='fs02.mydomain.net' and profile_name='internal' and
sip_subscriptions.event != 'line-seize' and
sip_subscriptions.proto='sip' and (event='presence' or
event='dialog') and sub_to_user='9886' and
(sub_to_host='customer.mydomain.net' or
sub_to_host='xxx.xx.x.xxx' or sub_to_host='N/A' or
presence_hosts like '%customer.mydomain.net%') and
(sip_subscriptions.profile_name = 'internal' or presence_hosts
like '%customer.mydomain.net%')</tt><tt><br>
</tt></div>
<div class="moz-cite-prefix"><br>
</div>
<ul>
<li>The first query returns 0 entries, when I run it manually,
line is marked as [CRIT]</li>
<ul>
<li>my impression is that this query is always empty because
_all_ values of sip_dialogs.call_info_state are empty,
allthough we have about 100 entries in sip_dialogs table.
Running 100k continuous queries against this table, I could
not find any other value than '' for
sip_dialogs.call_info_state</li>
</ul>
<li>The second query updates 7 entries, when I run it manually,
but line is marked as [ERR] </li>
</ul>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Maybe this info creates some new ideas.<br>
</div>
<div class="moz-cite-prefix"><br>
Best regards<br>
Peter<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Am 11.03.21 um 13:08 schrieb Peter
Steinbach:<br>
</div>
<blockquote type="cite"
cite="mid:5a7ab417-672c-26c7-0545-3e866f0aff50@telefaks.de">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>We made some investigations on our Production database. We set
mysql slow log to 0.02 sec and we did not discover any long
running qeuries concerning presence.</p>
<p>The command<br>
</p>
<p><tt> select * from INFORMATION_SCHEMA.PROCESSLIST where
command <> 'Sleep';</tt><br>
</p>
<p>shows, that presence queries run between 0.1 and 1
milliseconds. So I do not really feel, that the Mysql database
is the bottleneck here. MySQL show about 10-15%CPU on an 8 core
machine. Freeswitch runs at about 50% CPU on a different 8 core
machine.</p>
<p>Nevertheless we have severe problems with presence. I have e.g.
a Snom phone and a Yealink phone on my desk with a BLF for a 3rd
phone, which is not in a call at present. BLF on Snom is "on"
and BLF on Yealink is "blinking". Both should be "off". This is
very strange to me. How can this happen? BTW when this system
was under no load, before we migrated our customers, everything
worked fine.<br>
</p>
<p>So any help is very much appreciated here. <br>
</p>
<p>Another question is still:<br>
</p>
<ul>
<li>does anybody have an idea how to query all internal presence
status from Freewitch or maybe how to correct it?</li>
<ul>
<li>e.g. "sofia_presence_data list number@domain" returns e.g.</li>
</ul>
</ul>
<p><tt>status|rpid|user_agent|network_ip|network_port</tt><tt><br>
</tt><tt>unknown|unknown|N510 IP
PRO/42.250.00.000.000|xx.xxx.xxx.xx|21549</tt><tt><br>
</tt><tt>unknown|unknown|Yealink SIP-T41S 66.83.0.35
805EC025FDA9|xx.xx.xxx.xxx|20901</tt><tt><br>
</tt></p>
<p><tt><br>
</tt></p>
<blockquote>
<ul>
<li>and "sofia_presence_data status number@domain" always
returns<br>
</li>
</ul>
</blockquote>
<p><tt>unknownunknown</tt><br>
<br>
</p>
<blockquote>
<ul>
<li>Database table "sip_subscriptions" however is fine<br>
</li>
</ul>
</blockquote>
<p><br>
</p>
<p>Best regards</p>
<p>Peter<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 10.03.21 um 18:07 schrieb
Guillermo Ruiz Camauer:<br>
</div>
<blockquote type="cite"
cite="mid:CAPNTnnrkQhLQGXftzooAYNVhYR1XMrf-_xnzZeqW=vZO3dJ2AQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div dir="ltr">From your description, it sounds like the DB is
not keeping up with the updates FreeSwitch is making. Have
you tried tuning the db? More memory, faster/more disks?
<div><br>
</div>
<div>Guillermo</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Mar 10, 2021 at 1:16
PM Peter Steinbach <<a href="mailto:lists@telefaks.de"
moz-do-not-send="true">lists@telefaks.de</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>Hello</p>
<p><br>
</p>
<p>we have a Freeswitch installation for a multi tenant
environment. We have extensively tested our Freeswitch
for all call scenarios and all worked fine. This is the
good news.<br>
</p>
<p>However, under higher load (>250 Channels and
>6000 Subscriptions), presence does not seem to work
reliably. I've found some ealier posts on this issue,
which seem to lead to the following 2 solutions</p>
<ul>
<li>use PostgreSQL (we use Mariadb via ODBC, also tested
mod_mariadb, which made things worse)</li>
<li>Move presence handling to Kamailio <br>
</li>
</ul>
<p>As your environment is based on MySQL, we do not want
to move to PostgreSQL without knowing, whether this will
improve the situation.</p>
<p>So far we are catching events via ESL or even grepping
the network and correct the status of presence
informatons sent to the phone. However we discover, that
even if we send corrected PRESENCE_IN via event socket,
our Freeswitch keeps on sending the wrong BLF
information afterwards to the phone. Means BLFs are
blinking or in state red event if the watched phone is
not in a call. So at present we are grepping all
presence informations on the network, crosscheck this
with the channels table and resend the corrected BLF
status via event_socket if needed. But still this is not
sufficiant.<br>
</p>
<p>So I am now asking the community: What is your approach
to overcome this? <br>
</p>
<ul>
<li>Do newer Freeswitch versions perform better for this
case?(Ours is "FreeSWITCH Version
1.10.5-release+git~20200818T185121Z")</li>
<li>which work have you done to overcome this?</li>
<li>does anybody have an idea how to query all internal
presence status from Freewitch or maybe how to correct
it?<br>
</li>
</ul>
<p>Thank you in advance. Any help is appreciated.<br>
</p>
<p>Peter</p>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS
and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Guillermo Ruiz Camauer<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire <a class="moz-txt-link-freetext" href="https://signalwire.com" moz-do-not-send="true">https://signalwire.com</a>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.
Join our online community to chat in real time <a class="moz-txt-link-freetext" href="https://signalwire.community" moz-do-not-send="true">https://signalwire.community</a>
Professional FreeSWITCH Services
<a class="moz-txt-link-abbreviated" href="mailto:sales@freeswitch.com" moz-do-not-send="true">sales@freeswitch.com</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com" moz-do-not-send="true">https://freeswitch.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="https://freeswitch.com/oss" moz-do-not-send="true">https://freeswitch.com/oss</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/confluence" moz-do-not-send="true">https://freeswitch.org/confluence</a>
<a class="moz-txt-link-freetext" href="https://cluecon.com" moz-do-not-send="true">https://cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com" moz-do-not-send="true">https://freeswitch.com</a></pre>
</blockquote>
</blockquote>
<br>
</body>
</html>