<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Disabled in all profiles:<br>
      &lt;param name="manage-presence" value="false"/&gt;<br>
      <br>
      On 13-07-22 03:40 PM, Anthony Minessale wrote:<br>
    </div>
    <blockquote
cite="mid:CAKbxfG_jJSxqxxbcnt0rkN7ikcEuXmFm4_aeqOW69od8VSF72g@mail.gmail.com"
      type="cite">
      <div dir="ltr">Did you turn of the presence in the sofia profile,
        that is enabled by default and very costly. &nbsp;comment out
        manage-presence</div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">On Mon, Jul 22, 2013 at 2:32 PM, Victor
          Chukalovskiy <span dir="ltr">&lt;<a moz-do-not-send="true"
              href="mailto:victor.chukalovskiy@gmail.com"
              target="_blank">victor.chukalovskiy@gmail.com</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF">
              <div>Michael, Ken, <br>
                <br>
                Thank you for the response. Firstly, let me clarify
                setup for each of DBs in use:<br>
                <br>
                <b>core_db:</b> sqlite, /dev/shm/core.db (RAM) - using
                default 50 max handles<br>
                <b>mod_sofia db</b><b>:</b> sqlite, /opt/fs/db (HDD) <br>
                <b>mod_lcr db:</b> Postgres<br>
                <b>mod_limit:</b> hash backend<br>
                <br>
                Note: I believe we rarely use mod_sofia DB's...this is
                because we don't use any registrations, acl only. When I
                list sofia per-profile db files on production box, most
                of them has not been edited for a couple days. Are my
                conclusions correct here, or do I miss something? Maybe
                they are accessed a lot but only for reading?<br>
                <br>
                I understand recommendations from Ken and from Michaels
                are along the lines of increasing core db and sofia db
                throughput. However here is what puzzles me:<br>
                -the db used most extensively is core_db. It' already in
                the ram.<br>
                -we don't have much load on sofia dbs (or am I mistaken
                in my logic?)<br>
                -error log started with:
                <div class="im"><br>
                  <br>
                  [CRIT] switch_time.c:967 Virtual Migration Detected!
                  Syncing Clock<br>
                </div>
                <div class="im"> [WARNING] switch_scheduler.c:115 Task
                  was executed late by 19 seconds 1 heartbeat (core)<br>
                  <br>
                </div>
                Does it mean that there were abnormal events prior
                hitting 50 max handles limit?<br>
                <br>
                Thank you,<br>
                -Victor
                <div>
                  <div class="h5"><br>
                    <br>
                    On 13-07-22 02:52 PM, Anthony Minessale wrote:<br>
                  </div>
                </div>
              </div>
              <div>
                <div class="h5">
                  <blockquote type="cite">
                    <div dir="ltr">Check the odbcinst.ini settings from
                      the wiki or use native pg mode.
                      <div>increase the max number of pg connections on
                        your server and turn up FS to match
                        in&nbsp;max-db-handles in switch.conf.xml</div>
                      <div><br>
                      </div>
                      <div>You are already beating it up pretty good esp
                        for a fake server though. &nbsp;2500 is a lot.</div>
                      <div><br>
                      </div>
                    </div>
                    <div class="gmail_extra"><br>
                      <br>
                      <div class="gmail_quote">On Mon, Jul 22, 2013 at
                        1:44 PM, Ken Rice <span dir="ltr">&lt;<a
                            moz-do-not-send="true"
                            href="mailto:krice@freeswitch.org"
                            target="_blank">krice@freeswitch.org</a>&gt;</span>
                        wrote:<br>
                        <blockquote class="gmail_quote" style="margin:0
                          0 0 .8ex;border-left:1px #ccc
                          solid;padding-left:1ex">Mount the entire
                          freeswitch/db dir as tmpfs... most of these
                          errors are for<br>
                          the sofia DB getting backed up...<br>
                          <br>
                          The coredb is a completely different sqlite db
                          from the sofia db<br>
                          <br>
                          On 7/22/13 12:54 PM, "Victor Chukalovskiy"
                          &lt;<a moz-do-not-send="true"
                            href="mailto:victor.chukalovskiy@gmail.com"
                            target="_blank">victor.chukalovskiy@gmail.com</a>&gt;<br>
                          wrote:<br>
                          <div>
                            <div><br>
                              &gt; Hello,<br>
                              &gt;<br>
                              &gt; Need some help finding the bottleneck
                              here. Running 1.2.stable on a<br>
                              &gt; decent multi-core vmware platform. No
                              RTP, SIP signaling only. Around<br>
                              &gt; 2500 sessions and 30 average CPS
                              load. Essentially, it's a multi-profile<br>
                              &gt; .xml config that uses mod_lcr
                              extensively (postgres DB). Yesterday it<br>
                              &gt; stopped processing calls with the
                              following log output:<br>
                              &gt;<br>
                              &gt; 2013-07-21 06:00:37.642678 [CRIT]
                              switch_time.c:967 Virtual Migration<br>
                              &gt; Detected! Syncing Clock<br>
                              &gt; 2013-07-21 06:01:07.141734 [WARNING]
                              switch_scheduler.c:115 Task was<br>
                              &gt; executed late by 19 seconds 1
                              heartbeat (core)<br>
                              &gt; 2013-07-21 06:02:32.402668 [CRIT]
                              switch_time.c:967 Virtual Migration<br>
                              &gt; Detected! Syncing Clock<br>
                              &gt; 2013-07-21 06:04:42.499744 [WARNING]
                              switch_scheduler.c:115 Task was<br>
                              &gt; executed late by 115 seconds 1
                              heartbeat (core)<br>
                              &gt; 2013-07-21 06:04:42.499744 [WARNING]
                              switch_scheduler.c:115 Task was<br>
                              &gt; executed late by 74 seconds 2
                              check_ip (core)<br>
                              &gt; 2013-07-21 06:05:15.102683 [CRIT]
                              switch_time.c:967 Virtual Migration<br>
                              &gt; Detected! Syncing Clock<br>
                              &gt; 2013-07-21 06:05:44.961004 [WARNING]
                              switch_scheduler.c:115 Task was<br>
                              &gt; executed late by 22 seconds 1
                              heartbeat (core)<br>
                              &gt; 2013-07-21 06:05:44.961004 [WARNING]
                              switch_scheduler.c:115 Task was<br>
                              &gt; executed late by 2 seconds 2 check_ip
                              (core)<br>
                              &gt; 2013-07-21 06:05:49.322672 [WARNING]
                              mod_lcr.c:448 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:50.962987 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:50.962987 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:50.962987 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; ................................<br>
                              &gt; 2013-07-21 06:05:53.962672 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:54.422671 [ERR]
                              mod_lcr.c:448 Error connecting<br>
                              &gt; 2013-07-21 06:05:54.422671 [WARNING]
                              mod_lcr.c:1779 LCR lookup failed<br>
                              &gt; for 14389955082<br>
                              &gt; 2013-07-21 06:05:54.962671 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:54.962671 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; ................................<br>
                              &gt; 2013-07-21 06:05:55.962758 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:56.062671 [ERR]
                              sofia_glue.c:6605 Error connecting<br>
                              &gt; 2013-07-21 06:05:56.062671 [ERR]
                              sofia_glue.c:6606 Error Opening DB<br>
                              &gt; 2013-07-21 06:05:56.062671 [WARNING]
                              sofia_glue.c:6605 Max handles 50<br>
                              &gt; exceeded, blocking....<br>
                              &gt; 2013-07-21 06:05:56.062671 [ERR]
                              sofia_glue.c:6605 Error connecting<br>
                              &gt; 2013-07-21 06:05:56.062671 [ERR]
                              sofia_glue.c:6606 Error Opening DB<br>
                              &gt;<br>
                              &gt; FreeSWITCH stayed unusable since then
                              until it was restarted.<br>
                              &gt;<br>
                              &gt; FYI core DB is already in the RAM:<br>
                              &gt; &lt;param name="core-db-name"
                              value="/dev/shm/core.db" /&gt;<br>
                              &gt;<br>
                              &gt;<br>
                              &gt; Thank you,<br>
                              &gt; Victor<br>
                              &gt;<br>
                              &gt;
_________________________________________________________________________<br>
                              &gt; Professional FreeSWITCH Consulting
                              Services:<br>
                              &gt; <a moz-do-not-send="true"
                                href="mailto:consulting@freeswitch.org"
                                target="_blank">consulting@freeswitch.org</a><br>
                              &gt; <a moz-do-not-send="true"
                                href="http://www.freeswitchsolutions.com"
                                target="_blank">http://www.freeswitchsolutions.com</a><br>
                              &gt;<br>
                              &gt; FreeSWITCH-powered IP PBX: The
                              CudaTel Communication Server<br>
                              &gt; <a moz-do-not-send="true"
                                href="http://www.cudatel.com"
                                target="_blank">http://www.cudatel.com</a><br>
                              &gt;<br>
                              &gt; Official FreeSWITCH Sites<br>
                              &gt; <a moz-do-not-send="true"
                                href="http://www.freeswitch.org"
                                target="_blank">http://www.freeswitch.org</a><br>
                              &gt; <a moz-do-not-send="true"
                                href="http://wiki.freeswitch.org"
                                target="_blank">http://wiki.freeswitch.org</a><br>
                              &gt; <a moz-do-not-send="true"
                                href="http://www.cluecon.com"
                                target="_blank">http://www.cluecon.com</a><br>
                              &gt;<br>
                              &gt; FreeSWITCH-users mailing list<br>
                              &gt; <a moz-do-not-send="true"
                                href="mailto:FreeSWITCH-users@lists.freeswitch.org"
                                target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
                              &gt; <a moz-do-not-send="true"
                                href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
                                target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
                              &gt; UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
                                target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
                              &gt; <a moz-do-not-send="true"
                                href="http://www.freeswitch.org"
                                target="_blank">http://www.freeswitch.org</a><br>
                              <br>
                            </div>
                          </div>
                          <span><font color="#888888">--<br>
                              Ken<br>
                              <a moz-do-not-send="true"
                                href="http://www.FreeSWITCH.org"
                                target="_blank">http://www.FreeSWITCH.org</a><br>
                              <a moz-do-not-send="true"
                                href="http://www.ClueCon.com"
                                target="_blank">http://www.ClueCon.com</a><br>
                              <a moz-do-not-send="true"
                                href="http://www.OSTAG.org"
                                target="_blank">http://www.OSTAG.org</a><br>
                              <a moz-do-not-send="true"
                                href="http://irc.freenode.net"
                                target="_blank">irc.freenode.net</a>
                              #freeswitch<br>
                            </font></span>
                          <div>
                            <div><br>
                              <br>
                              <br>
_________________________________________________________________________<br>
                              Professional FreeSWITCH Consulting
                              Services:<br>
                              <a moz-do-not-send="true"
                                href="mailto:consulting@freeswitch.org"
                                target="_blank">consulting@freeswitch.org</a><br>
                              <a moz-do-not-send="true"
                                href="http://www.freeswitchsolutions.com"
                                target="_blank">http://www.freeswitchsolutions.com</a><br>
                              <br>
                              FreeSWITCH-powered IP PBX: The CudaTel
                              Communication Server<br>
                              <a moz-do-not-send="true"
                                href="http://www.cudatel.com"
                                target="_blank">http://www.cudatel.com</a><br>
                              <br>
                              Official FreeSWITCH Sites<br>
                              <a moz-do-not-send="true"
                                href="http://www.freeswitch.org"
                                target="_blank">http://www.freeswitch.org</a><br>
                              <a moz-do-not-send="true"
                                href="http://wiki.freeswitch.org"
                                target="_blank">http://wiki.freeswitch.org</a><br>
                              <a moz-do-not-send="true"
                                href="http://www.cluecon.com"
                                target="_blank">http://www.cluecon.com</a><br>
                              <br>
                              FreeSWITCH-users mailing list<br>
                              <a moz-do-not-send="true"
                                href="mailto:FreeSWITCH-users@lists.freeswitch.org"
                                target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
                              <a moz-do-not-send="true"
                                href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
                                target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
                              UNSUBSCRIBE:<a moz-do-not-send="true"
                                href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
                                target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
                              <a moz-do-not-send="true"
                                href="http://www.freeswitch.org"
                                target="_blank">http://www.freeswitch.org</a><br>
                            </div>
                          </div>
                        </blockquote>
                      </div>
                      <br>
                      <br clear="all">
                      <div><br>
                      </div>
                      -- <br>
                      Anthony Minessale II<br>
                      <br>
                      FreeSWITCH <a moz-do-not-send="true"
                        href="http://www.freeswitch.org/"
                        target="_blank">http://www.freeswitch.org/</a><br>
                      ClueCon <a moz-do-not-send="true"
                        href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
                      Twitter: <a moz-do-not-send="true"
                        href="http://twitter.com/FreeSWITCH_wire"
                        target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
                      <br>
                      AIM: anthm<br>
                      <a moz-do-not-send="true"
                        href="mailto:MSN%3Aanthony_minessale@hotmail.com"
                        target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
                      GTALK/JABBER/<a moz-do-not-send="true"
                        href="mailto:PAYPAL%3Aanthony.minessale@gmail.com"
                        target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
                      IRC: <a moz-do-not-send="true"
                        href="http://irc.freenode.net" target="_blank">irc.freenode.net</a>
                      #freeswitch<br>
                      <br>
                      FreeSWITCH Developer Conference<br>
                      <a moz-do-not-send="true"
                        href="mailto:sip%3A888@conference.freeswitch.org"
                        target="_blank">sip:888@conference.freeswitch.org</a><br>
                      <a moz-do-not-send="true"
                        href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org"
                        target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
                      pstn:+19193869900 </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                    <pre>_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a moz-do-not-send="true" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a moz-do-not-send="true" href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a moz-do-not-send="true" href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>

Official FreeSWITCH Sites
<a moz-do-not-send="true" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a moz-do-not-send="true" href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a>
<a moz-do-not-send="true" href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>

FreeSWITCH-users mailing list
<a moz-do-not-send="true" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<a moz-do-not-send="true" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a moz-do-not-send="true" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a moz-do-not-send="true" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
</pre>
                  </blockquote>
                  <br>
                </div>
              </div>
            </div>
            <br>
_________________________________________________________________________<br>
            Professional FreeSWITCH Consulting Services:<br>
            <a moz-do-not-send="true"
              href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
            <a moz-do-not-send="true"
              href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
            <br>
            FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
            <a moz-do-not-send="true" href="http://www.cudatel.com"
              target="_blank">http://www.cudatel.com</a><br>
            <br>
            Official FreeSWITCH Sites<br>
            <a moz-do-not-send="true" href="http://www.freeswitch.org"
              target="_blank">http://www.freeswitch.org</a><br>
            <a moz-do-not-send="true" href="http://wiki.freeswitch.org"
              target="_blank">http://wiki.freeswitch.org</a><br>
            <a moz-do-not-send="true" href="http://www.cluecon.com"
              target="_blank">http://www.cluecon.com</a><br>
            <br>
            FreeSWITCH-users mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
            <a moz-do-not-send="true"
              href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
              target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
            UNSUBSCRIBE:<a moz-do-not-send="true"
              href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
              target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
            <a moz-do-not-send="true" href="http://www.freeswitch.org"
              target="_blank">http://www.freeswitch.org</a><br>
            <br>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        Anthony Minessale II<br>
        <br>
        FreeSWITCH <a moz-do-not-send="true"
          href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>
        ClueCon <a moz-do-not-send="true"
          href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
        Twitter: <a moz-do-not-send="true"
          href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br>
        <br>
        AIM: anthm<br>
        <a moz-do-not-send="true"
          href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
        GTALK/JABBER/<a moz-do-not-send="true"
          href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
        IRC: <a moz-do-not-send="true" href="http://irc.freenode.net">irc.freenode.net</a>
        #freeswitch<br>
        <br>
        FreeSWITCH Developer Conference<br>
        <a moz-do-not-send="true"
          href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
        <a moz-do-not-send="true"
          href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
        pstn:+19193869900
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>

Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>

FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">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">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>