<p>*shrug* probably</p>
<div class="gmail_quote">On Jul 26, 2013 6:37 PM, &quot;I put the Who? in Mishehu&quot; &lt;<a href="mailto:mishehu@freeswitch.org">mishehu@freeswitch.org</a>&gt; wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    <div>According to
      <a href="http://www.mysql.com/about/legal/licensing/foss-exception/" target="_blank">http://www.mysql.com/about/legal/licensing/foss-exception/</a> , MySQL
      still lists MPL 1.0/1.1 in the accepted exceptions for linking. 
      Would there any objections if, hypothetically speaking, somebody
      were to write &amp; contribute something similar to switch_pgsql.c
      but for use with the native MySQL client?<br>
      <br>
      -Yossi<br>
      <br>
      On 07/26/2013 03:10 PM, Anthony Minessale wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">We still have to set the same odbcinst.ini stuff
        even in postgres however.
        <div>unixODBC has its own issues as well.</div>
        <div>We do also have a native postgres module but its still new.</div>
        <div><br>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <br>
        <div class="gmail_quote">On Fri, Jul 26, 2013 at 2:40 PM,
          Michael Jerris <span dir="ltr">&lt;<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.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 style="word-wrap:break-word">We use postgres without
              issues.
              <div>
                <div>
                  <div><br>
                    <div>
                      <div>On Jul 26, 2013, at 3:35 PM, Ira Tessler &lt;<a href="mailto:ira@connectmevoice.com" target="_blank">ira@connectmevoice.com</a>&gt;
                        wrote:</div>
                      <br>
                      <blockquote type="cite">
                        <div link="blue" vlink="purple" style="font-family:Helvetica;font-size:medium;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" lang="EN-US">

                          <div>
                            <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Would
                                PostgreSQL be a “better” choice with
                                less “issues”? Just curious.</span></div>
                            <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                            <div>
                              <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanks,</span></div>
                            <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                            <div><span style="color:rgb(34,34,34);font-size:10pt;font-family:Arial,sans-serif;background-repeat:initial initial">Ira Tessler</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(34,34,34)"><br>

                                <span style="background-repeat:initial initial">Lead Software Engineer</span><br>
                                <span style="background-repeat:initial initial">ConnectMe</span><br>
                                <span style="background-repeat:initial initial"><a href="tel:%28732%29%20490-9007%20x2" value="+17324909007" target="_blank">(732) 490-9007 x2</a></span><br>
                              </span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif">ira@connectmevoice.com</span></a></span></div>

                            <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                            <div>
                              <b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"><span> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color:purple;text-decoration:underline" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a><span> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color:purple;text-decoration:underline" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]<span> </span><b>On
                                  Behalf Of<span> </span></b>Anthony
                                Minessale<br>
                                <b>Sent:</b><span> </span>Friday, July
                                26, 2013 2:57 PM<br>
                                <b>To:</b><span> </span>FreeSWITCH Users
                                Help<br>
                                <b>Subject:</b><span> </span>Re:
                                [Freeswitch-users] Lock wait timeout
                                exceeded; try restarting transaction</span></div>
                            <p class="MsoNormal"> </p>
                            <div>
                              <div>
                                <div>
                                  We don&#39;t support issues in mysql other
                                  than recommending the settings to fix
                                  the broken locking.</div>
                              </div>
                              <div>
                                <div>ODBC and mysql both
                                  have their own issues and bug
                                  trackers.</div>
                              </div>
                              <div>
                                <p class="MsoNormal"> </p>
                              </div>
                              <div>
                                <div>
                                  The problem is they struggle with
                                  multi-threaded applications and you
                                  need to do research to find a stable
                                  combo of driver and odbc lib.  </div>
                              </div>
                              <div>
                                <p class="MsoNormal">
                                   </p>
                              </div>
                              <div>
                                <p class="MsoNormal"> </p>
                              </div>
                              <div>
                                <p class="MsoNormal">
                                   </p>
                              </div>
                              <div>
                                <p class="MsoNormal"> </p>
                              </div>
                            </div>
                            <div>
                              <div>
                                 <br>
                              </div>
                              <div>
                                <div>On Fri, Jul 26, 2013
                                  at 1:44 PM, Ira Tessler &lt;<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>&gt;
                                  wrote:</div>
                                <div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I
                                       made the change in odbcinst.ini
                                      not odbc.ini.</span></div>
                                  <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                  <div>
                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">#
                                      Driver from the
                                      mysql-connector-odbc package</span></div>
                                  <div>
                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">#
                                      Setup from the unixODBC-libs
                                      package</span></div>
                                  <div>
                                    <div>
                                      <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">[MySQL]</span></div>
                                    <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Description    
                                        = ODBC for MySQL</span></div>
                                  </div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Driver         
                                      = /usr/lib/libmyodbc3_r.so</span></div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Setup          
                                      = /usr/lib/libodbcmyS.so</span></div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Driver64       
                                      = /usr/lib64/libmyodbc3_r.so</span></div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Setup64        
                                      = /usr/lib64/libodbcmyS.so</span></div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">UsageCount     
                                      = 1<span> </span></span><span style="font-size:11pt;font-family:Wingdings;color:rgb(31,73,125)">ß</span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span> </span>also
                                      added this like as per the wiki</span></div>
                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">FileUsage      
                                      = 1</span></div>
                                  <div>
                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Threading      
                                      = 0<span> </span></span><span style="font-size:11pt;font-family:Wingdings;color:rgb(31,73,125)">ß</span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">- 
                                      added this line as per the wiki</span></div>
                                  <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                  <div>
                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">So
                                      far so good.</span></div>
                                  <div>
                                    <p class="MsoNormal">
                                      <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                    <div><span style="color:rgb(34,34,34);font-size:10pt;font-family:Arial,sans-serif;background-repeat:initial initial">Ira Tessler</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(34,34,34)"><br>

                                        <span style="background-repeat:initial initial">Lead Software
                                          Engineer</span><br>
                                        <span style="background-repeat:initial initial">ConnectMe</span><br>
                                        <span style="background-repeat:initial initial"><a href="tel:%28732%29%20490-9007%20x2" value="+17324909007" target="_blank">(732) 490-9007 x2</a></span><br>
                                      </span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif">ira@connectmevoice.com</span></a></span></div>

                                    <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                  </div>
                                  <div>
                                    <b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"><span> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color:purple;text-decoration:underline" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a><span> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color:purple;text-decoration:underline" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]<span> </span><b>On
                                        Behalf Of<span> </span></b>Lloyd
                                      Aloysius<br>
                                      <b>Sent:</b><span> </span>Friday,
                                      July 26, 2013 2:34 PM</span></div>
                                  <div>
                                    <div><br>
                                      <b>To:</b><span> </span>FreeSWITCH
                                      Users Help<br>
                                      <b>Subject:</b><span> </span>Re:
                                      [Freeswitch-users] Lock wait
                                      timeout exceeded; try restarting
                                      transaction</div>
                                  </div>
                                  <div>
                                    <p class="MsoNormal">
                                       </p>
                                    <div><span style="font-family:Verdana,sans-serif">if
                                        you can generate this problem.
                                        Better you open a issue in JIRA</span></div>
                                    <div>
                                      <p class="MsoNormal"> </p>
                                    </div>
                                    <div>
                                      <div>
                                        <span style="font-family:Verdana,sans-serif">Lloyd<br clear="all">
                                        </span></div>
                                      <div>
                                        <p class="MsoNormal"> </p>
                                        <div>
                                          <p class="MsoNormal">
                                             </p>
                                        </div>
                                        <div>
                                          <div><b><span style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(204,102,0)"> </span></b></div>
                                        </div>
                                      </div>
                                      <div> <br>
                                      </div>
                                      <div>
                                        <div>On Fri, Jul
                                          26, 2013 at 12:32 PM, Ira
                                          Tessler &lt;<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>&gt;
                                          wrote:</div>
                                        <div>
                                          <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Sorry
                                              ment 1.4.0_latest<span> </span></span><span style="font-size:11pt;font-family:Wingdings;color:rgb(31,73,125)">J</span></div>
                                          <div>
                                            <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                            <div>
                                              <div>
                                                <span style="color:rgb(34,34,34);font-size:10pt;font-family:Arial,sans-serif;background-repeat:initial initial">Ira Tessler</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(34,34,34)"><br>

                                                  <span style="background-repeat:initial initial">Lead
                                                    Software Engineer</span><br>
                                                  <span style="background-repeat:initial initial">ConnectMe</span><br>
                                                  <span style="background-repeat:initial initial"><a href="tel:%28732%29%20490-9007%20x2" style="color:purple;text-decoration:underline" target="_blank">(732)
                                                      490-9007 x2</a></span><br>
                                                </span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif">ira@connectmevoice.com</span></a></span></div>

                                            </div>
                                            <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                          </div>
                                          <div>
                                            <div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(181,196,223);padding:3pt 0in 0in">
                                              <div><b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"><span> </span>Ira
                                                  Tessler [mailto:<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>]<span> </span><br>
                                                  <b>Sent:</b><span> </span>Friday,
                                                  July 26, 2013 12:28 PM<br>
                                                  <b>To:</b><span> </span>FreeSWITCH
                                                  Users Help<br>
                                                  <b>Subject:</b><span> </span>RE:
                                                  [Freeswitch-users]
                                                  Lock wait timeout
                                                  exceeded; try
                                                  restarting transaction</span></div>
                                            </div>
                                          </div>
                                          <div>
                                            <p class="MsoNormal"> </p>
                                            <div>
                                              <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanks.
                                                I’ll give it a try and
                                                let you know. FYI, I had
                                                it happen on 1.2.9 and
                                                1.2.4_lastest tarball.</span></div>
                                            <p class="MsoNormal">
                                              <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                            <div><span style="color:rgb(34,34,34);font-size:10pt;font-family:Arial,sans-serif;background-repeat:initial initial">Ira Tessler</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(34,34,34)"><br>

                                                <span style="background-repeat:initial initial">Lead Software
                                                  Engineer</span><br>
                                                <span style="background-repeat:initial initial">ConnectMe</span><br>
                                                <span style="background-repeat:initial initial"><a href="tel:%28732%29%20490-9007%20x2" style="color:purple;text-decoration:underline" target="_blank">(732)
                                                    490-9007 x2</a></span><br>
                                              </span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank"><span style="font-size:10pt;font-family:Arial,sans-serif">ira@connectmevoice.com</span></a></span></div>

                                            <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                            <div>
                                              <b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"><span> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color:purple;text-decoration:underline" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a><span> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color:purple;text-decoration:underline" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]<span> </span><b>On
                                                  Behalf Of<span> </span></b>Lloyd
                                                Aloysius<br>
                                                <b>Sent:</b><span> </span>Friday,
                                                July 26, 2013 12:10 PM<br>
                                                <b>To:</b><span> </span>FreeSWITCH
                                                Users Help<br>
                                                <b>Subject:</b><span> </span>Re:
                                                [Freeswitch-users] Lock
                                                wait timeout exceeded;
                                                try restarting
                                                transaction</span></div>
                                            <p class="MsoNormal"> </p>
                                            <div><span style="font-family:Verdana,sans-serif">I
                                                saw this problem several
                                                times in my Dev
                                                environment. No calls
                                                ... Only two
                                                registrations.</span></div>
                                            <div>
                                              <p class="MsoNormal"> </p>
                                            </div>
                                            <div>
                                              <div>
                                                <span style="font-family:Verdana,sans-serif">But
                                                  after I add
                                                  threading=0 in
                                                  odbc.ini , I never see
                                                  this problem again.
                                                  Also I am using most
                                                  recent version of
                                                  freeswitch</span></div>
                                            </div>
                                            <div>
                                              <p class="MsoNormal">
                                                 </p>
                                            </div>
                                            <div>
                                              <div><span style="font-family:Verdana,sans-serif">I am interested into know why
                                                  this happening even no
                                                  activity in mysql. I
                                                  have lots of resources
                                                  in the machine.</span></div>
                                            </div>
                                            <div>
                                              <p class="MsoNormal"> </p>
                                            </div>
                                            <div>
                                              <p class="MsoNormal">
                                                 </p>
                                            </div>
                                            <div>
                                              <div><span style="font-family:Verdana,sans-serif">Lloyd</span></div>
                                            </div>
                                            <div>
                                              <div>
                                                <p class="MsoNormal">
                                                  <span style="font-family:Arial,sans-serif"> </span></p>
                                              </div>
                                              <div> <br>
                                              </div>
                                              <div>
                                                <div>
                                                  On Fri, Jul 26, 2013
                                                  at 11:30 AM, Ira
                                                  Tessler &lt;<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>&gt;
                                                  wrote:</div>
                                                <div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I
                                                      am getting the
                                                      same problem on my
                                                      development system
                                                      today. I just put
                                                      up a new version
                                                      of mysql. Went
                                                      from 5.1.67 to
                                                      5.6.12. Here is
                                                      the deadlock
                                                      section:</span></div>
                                                  <p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------------------</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">LATEST
                                                      DETECTED DEADLOCK</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------------------</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">2013-07-26
                                                      11:23:22
                                                      7fd473f1e700</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
                                                      (1) TRANSACTION:</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">TRANSACTION
                                                      251674, ACTIVE 2
                                                      sec fetching rows</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">mysql
                                                      tables in use 1,
                                                      locked 1</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">LOCK
                                                      WAIT 3 lock
                                                      struct(s), heap
                                                      size 376, 3 row
                                                      lock(s)</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                                      thread id 38, OS
                                                      thread handle
                                                      0x7fd473fa0700,
                                                      query id 156782
                                                      192.168.1.27 root
                                                      updating</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">delete
                                                      from registrations
                                                      where expires &gt;
                                                      0 and expires
                                                      &lt;= 1374852304
                                                      and
                                                      hostname=&#39;freeswitch_ha0&#39;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
                                                      (1) WAITING FOR
                                                      THIS LOCK TO BE
                                                      GRANTED:</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">RECORD
                                                      LOCKS space id 10
                                                      page no 3 n bits
                                                      96 index
                                                      `GEN_CLUST_INDEX`
                                                      of table
                                                      `freeswitch`.`registrations`
                                                      trx id 251674
                                                      lock_mode X
                                                      waiting</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Record
                                                      lock, heap no 22
                                                      PHYSICAL RECORD:
                                                      n_fields 13;
                                                      compact format;
                                                      info bits 32</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">0:
                                                      len 6; hex
                                                      000000001769;
                                                      asc      i;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1:
                                                      len 6; hex
                                                      00000003d709;
                                                      asc       ;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">2:
                                                      len 7; hex
                                                      070000015b0352;
                                                      asc     [ R;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">3:
                                                      len 3; hex 373033;
                                                      asc 703;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">4:
                                                      len 28; hex
                                                      32323535352e7463702e6861312e746573747362636461782e636f6d;
                                                      asc<span> </span><a href="http://22555.tcp.ha1.testsbcdax.com" style="color:purple;text-decoration:underline" target="_blank">22555.tcp.ha1.testsbcdax.com</a>;;</span></div>

                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5:
                                                      len 30; hex
                                                      313030303130342d302d313730333030304034372e32332e3130362e3233;
                                                      asc<span> </span><a href="mailto:1000104-0-1703000@47.23.106.23" style="color:purple;text-decoration:underline" target="_blank">1000104-0-1703000@47.23.106.23</a>;
                                                      (total 31 bytes);</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">6:
                                                      len 30; hex
                                                      736f6669612f6861315f696e7465726e616c5f7463702f7369703a373033;
                                                      asc
                                                      sofia/ha1_internal_tcp/sip:703;
                                                      (total 152 bytes);</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">7:
                                                      len 4; hex
                                                      d1f2962a; asc   
                                                      *;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">8:
                                                      len 12; hex
                                                      31302e31302e31302e313032;
                                                      asc 10.10.10.102;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">9:
                                                      len 5; hex
                                                      3230303031; asc
                                                      20001;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">10:
                                                      len 3; hex 746370;
                                                      asc tcp;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">11:
                                                      len 14; hex
                                                      667265657377697463685f686131;
                                                      asc
                                                      freeswitch_ha1;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">12:
                                                      SQL NULL;</span></div>
                                                  <p class="MsoNormal">
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
                                                      (2) TRANSACTION:</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">TRANSACTION
                                                      251657, ACTIVE 2
                                                      sec starting index
                                                      read</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">mysql
                                                      tables in use 1,
                                                      locked 1</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5
                                                      lock struct(s),
                                                      heap size 1248, 5
                                                      row lock(s), undo
                                                      log entries 2</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                                      thread id 28, OS
                                                      thread handle
                                                      0x7fd473f1e700,
                                                      query id 156786
                                                      192.168.1.45 root
                                                      updating</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">delete
                                                      from registrations
                                                      where expires &gt;
                                                      0 and expires
                                                      &lt;= 1374852306
                                                      and
                                                      hostname=&#39;freeswitch_ha1&#39;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
                                                      (2) HOLDS THE
                                                      LOCK(S):</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">RECORD
                                                      LOCKS space id 10
                                                      page no 3 n bits
                                                      96 index
                                                      `GEN_CLUST_INDEX`
                                                      of table
                                                      `freeswitch`.`registrations`
                                                      trx id 251657
                                                      lock_mode X locks
                                                      rec but not gap</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Record
                                                      lock, heap no 22
                                                      PHYSICAL RECORD:
                                                      n_fields 13;
                                                      compact format;
                                                      info bits 32</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">0:
                                                      len 6; hex
                                                      000000001769;
                                                      asc      i;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1:
                                                      len 6; hex
                                                      00000003d709;
                                                      asc       ;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">2:
                                                      len 7; hex
                                                      070000015b0352;
                                                      asc     [ R;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">3:
                                                      len 3; hex 373033;
                                                      asc 703;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">4:
                                                      len 28; hex
                                                      32323535352e7463702e6861312e746573747362636461782e636f6d;
                                                      asc<span> </span><a href="http://22555.tcp.ha1.testsbcdax.com" style="color:purple;text-decoration:underline" target="_blank">22555.tcp.ha1.testsbcdax.com</a>;;</span></div>

                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5:
                                                      len 30; hex
                                                      313030303130342d302d313730333030304034372e32332e3130362e3233;
                                                      asc<span> </span><a href="mailto:1000104-0-1703000@47.23.106.23" style="color:purple;text-decoration:underline" target="_blank">1000104-0-1703000@47.23.106.23</a>;
                                                      (total 31 bytes);</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">6:
                                                      len 30; hex
                                                      736f6669612f6861315f696e7465726e616c5f7463702f7369703a373033;
                                                      asc
                                                      sofia/ha1_internal_tcp/sip:703;
                                                      (total 152 bytes);</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">7:
                                                      len 4; hex
                                                      d1f2962a; asc   
                                                      *;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">8:
                                                      len 12; hex
                                                      31302e31302e31302e313032;
                                                      asc 10.10.10.102;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">9:
                                                      len 5; hex
                                                      3230303031; asc
                                                      20001;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">10:
                                                      len 3; hex 746370;
                                                      asc tcp;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">11:
                                                      len 14; hex
                                                      667265657377697463685f686131;
                                                      asc
                                                      freeswitch_ha1;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">12:
                                                      SQL NULL;</span></div>
                                                  <p class="MsoNormal">
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
                                                      (2) WAITING FOR
                                                      THIS LOCK TO BE
                                                      GRANTED:</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">RECORD
                                                      LOCKS space id 10
                                                      page no 3 n bits
                                                      96 index
                                                      `GEN_CLUST_INDEX`
                                                      of table
                                                      `freeswitch`.`registrations`
                                                      trx id 251657
                                                      lock_mode X
                                                      waiting</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Record
                                                      lock, heap no 3
                                                      PHYSICAL RECORD:
                                                      n_fields 13;
                                                      compact format;
                                                      info bits 0</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">0:
                                                      len 6; hex
                                                      0000000016d1;
                                                      asc       ;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1:
                                                      len 6; hex
                                                      000000033bc4;
                                                      asc     ; ;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">2:
                                                      len 7; hex
                                                      d20000022f0110;
                                                      asc     /  ;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">3:
                                                      len 3; hex 383033;
                                                      asc 803;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">4:
                                                      len 21; hex
                                                      32323535382e636d767465737474656c652e636f6d;
                                                      asc<span> </span><a href="http://22558.cmvtesttele.com" style="color:purple;text-decoration:underline" target="_blank">22558.cmvtesttele.com</a>;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5:
                                                      len 30; hex
                                                      62326365383430342d6438313665303162403139322e3136382e3230302e;
                                                      asc<span> </span><a href="mailto:b2ce8404-d816e01b@192.168.200." style="color:purple;text-decoration:underline" target="_blank">b2ce8404-d816e01b@192.168.200.</a>;
                                                      (total 33 bytes);</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">6:
                                                      len 30; hex
                                                      736f6669612f6861305f696e7465726e616c2f7369703a38303340313038;
                                                      asc
                                                      sofia/ha0_internal/sip:803@108;
                                                      (total 46 bytes);</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">7:
                                                      len 4; hex
                                                      d1f29d68; asc   
                                                      h;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">8:
                                                      len 14; hex
                                                      3130382e35382e3130302e313432;
                                                      asc
                                                      108.58.100.142;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">9:
                                                      len 4; hex
                                                      35303630; asc
                                                      5060;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">10:
                                                      len 3; hex 756470;
                                                      asc udp;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">11:
                                                      len 14; hex
                                                      667265657377697463685f686130;
                                                      asc
                                                      freeswitch_ha0;;</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">12:
                                                      SQL NULL;</span></div>
                                                  <p class="MsoNormal">
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
                                                      WE ROLL BACK
                                                      TRANSACTION (1)</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">TRANSACTIONS</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Trx
                                                      id counter 252611</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Purge
                                                      done for trx&#39;s n:o
                                                      &lt; 252607 undo
                                                      n:o &lt; 0 state:
                                                      running but idle</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">History
                                                      list length 2731</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">LIST
                                                      OF TRANSACTIONS
                                                      FOR EACH SESSION:</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
                                                      252530, not
                                                      started</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                                      thread id 127, OS
                                                      thread handle
                                                      0x7fd49c0e4700,
                                                      query id 157673
                                                      192.168.1.45 root
                                                      cleaning up</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
                                                      252039, not
                                                      started</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                                      thread id 126, OS
                                                      thread handle
                                                      0x7fd473e1a700,
                                                      query id 157059
                                                      192.168.1.45 root
                                                      cleaning up</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
                                                      252344, not
                                                      started</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                                      thread id 125, OS
                                                      thread handle
                                                      0x7fd46f12a700,
                                                      query id 157516
                                                      192.168.1.27 root
                                                      cleaning up</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
                                                      0, not started</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                                      thread id 117, OS
                                                      thread handle
                                                      0x7fd473e5b700,
                                                      query id 157835
                                                      localhost root
                                                      init</span></div>
                                                  <div>
                                                    <span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">show
                                                      engine innodb
                                                      status</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
                                                      252610, not
                                                      started</span></div>
                                                  <div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
                                </span></div></div></div></div></div></div></div></div></div></div></div></div></div></div></blockquote></div></div></div></div></div></blockquote></div></div></blockquote></div><br>_________________________________________________________________________<br>

Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>...</blockquote></div>