<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">According to
<a class="moz-txt-link-freetext" href="http://www.mysql.com/about/legal/licensing/foss-exception/">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 & 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
cite="mid:CAKbxfG8r2kTMXa-Dw9Hx39i0crPj_gPERjz9vgYZ9a9zjmh7Bw@mail.gmail.com"
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"><<a moz-do-not-send="true"
href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>></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 class="h5">
<div><br>
<div>
<div>On Jul 26, 2013, at 3:35 PM, Ira Tessler <<a
moz-do-not-send="true"
href="mailto:ira@connectmevoice.com"
target="_blank">ira@connectmevoice.com</a>>
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 style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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" style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanks,</span></div>
<p class="MsoNormal" style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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">(732) 490-9007 x2</span><br>
</span><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a
moz-do-not-send="true"
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" style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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
moz-do-not-send="true"
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
moz-do-not-send="true"
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" style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
<div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
We don't support issues in mysql other
than recommending the settings to fix
the broken locking.</div>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">ODBC and mysql both
have their own issues and bug
trackers.</div>
</div>
<div>
<p class="MsoNormal" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
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" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
</p>
</div>
<div>
<p class="MsoNormal" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
</div>
<div>
<p class="MsoNormal" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
</p>
</div>
<div>
<p class="MsoNormal" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
</div>
</div>
<div>
<div style="margin:0in 0in
12pt;font-size:12pt;font-family:'Times
New Roman',serif">
<br>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">On Fri, Jul 26, 2013
at 1:44 PM, Ira Tessler <<a
moz-do-not-send="true"
href="mailto:ira@connectmevoice.com"
style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>>
wrote:</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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 style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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 style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">[MySQL]</span></div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Description
= ODBC for MySQL</span></div>
</div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Driver
= /usr/lib/libmyodbc3_r.so</span></div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Setup
= /usr/lib/libodbcmyS.so</span></div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Driver64
= /usr/lib64/libmyodbc3_r.so</span></div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Setup64
= /usr/lib64/libodbcmyS.so</span></div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">FileUsage
= 1</span></div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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" style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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">(732) 490-9007 x2</span><br>
</span><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a
moz-do-not-send="true"
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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
</div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
</p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-family:Verdana,sans-serif">Lloyd<br
clear="all">
</span></div>
<div>
<p class="MsoNormal"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
<div>
<p class="MsoNormal"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
</p>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><b><span
style="font-size:7.5pt;font-family:Verdana,sans-serif;color:rgb(204,102,0)"> </span></b></div>
</div>
</div>
<div style="margin:0in 0in
12pt;font-size:12pt;font-family:'Times
New Roman',serif"> <br>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">On Fri, Jul
26, 2013 at 12:32 PM, Ira
Tessler <<a
moz-do-not-send="true"
href="mailto:ira@connectmevoice.com"
style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>>
wrote:</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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
moz-do-not-send="true"
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
moz-do-not-send="true" 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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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
moz-do-not-send="true"
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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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
moz-do-not-send="true"
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
moz-do-not-send="true"
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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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
moz-do-not-send="true"
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
moz-do-not-send="true"
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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
</p>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
</div>
<div>
<p class="MsoNormal"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
</p>
</div>
<div>
<div style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-family:Verdana,sans-serif">Lloyd</span></div>
</div>
<div>
<div>
<p class="MsoNormal"
style="margin:0in 0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-family:Arial,sans-serif"> </span></p>
</div>
<div style="margin:0in 0in
12pt;font-size:12pt;font-family:'Times
New Roman',serif"> <br>
</div>
<div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
On Fri, Jul 26, 2013
at 11:30 AM, Ira
Tessler <<a
moz-do-not-send="true"
href="mailto:ira@connectmevoice.com"
style="color:purple;text-decoration:underline"
target="_blank">ira@connectmevoice.com</a>>
wrote:</div>
<div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------------------</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">LATEST
DETECTED DEADLOCK</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------------------</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
(1) TRANSACTION:</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">delete
from registrations
where expires >
0 and expires
<= 1374852304
and
hostname='freeswitch_ha0'</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1:
len 6; hex
00000003d709;
asc ;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">4:
len 28; hex
32323535352e7463702e6861312e746573747362636461782e636f6d;
asc<span> </span><a
moz-do-not-send="true" href="http://22555.tcp.ha1.testsbcdax.com"
style="color:purple;text-decoration:underline"
target="_blank">22555.tcp.ha1.testsbcdax.com</a>;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5:
len 30; hex
313030303130342d302d313730333030304034372e32332e3130362e3233;
asc<span> </span><a
moz-do-not-send="true" 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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">7:
len 4; hex
d1f2962a; asc
*;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">12:
SQL NULL;</span></div>
<p class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
(2) TRANSACTION:</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">delete
from registrations
where expires >
0 and expires
<= 1374852306
and
hostname='freeswitch_ha1'</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
(2) HOLDS THE
LOCK(S):</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1:
len 6; hex
00000003d709;
asc ;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">4:
len 28; hex
32323535352e7463702e6861312e746573747362636461782e636f6d;
asc<span> </span><a
moz-do-not-send="true" href="http://22555.tcp.ha1.testsbcdax.com"
style="color:purple;text-decoration:underline"
target="_blank">22555.tcp.ha1.testsbcdax.com</a>;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5:
len 30; hex
313030303130342d302d313730333030304034372e32332e3130362e3233;
asc<span> </span><a
moz-do-not-send="true" 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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">7:
len 4; hex
d1f2962a; asc
*;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">12:
SQL NULL;</span></div>
<p class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">0:
len 6; hex
0000000016d1;
asc ;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">1:
len 6; hex
000000033bc4;
asc ; ;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">2:
len 7; hex
d20000022f0110;
asc / ;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">4:
len 21; hex
32323535382e636d767465737474656c652e636f6d;
asc<span> </span><a
moz-do-not-send="true" href="http://22558.cmvtesttele.com"
style="color:purple;text-decoration:underline"
target="_blank">22558.cmvtesttele.com</a>;;</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">5:
len 30; hex
62326365383430342d6438313665303162403139322e3136382e3230302e;
asc<span> </span><a
moz-do-not-send="true" 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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">12:
SQL NULL;</span></div>
<p class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">***
WE ROLL BACK
TRANSACTION (1)</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">TRANSACTIONS</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">------------</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Trx
id counter 252611</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Purge
done for trx's n:o
< 252607 undo
n:o < 0 state:
running but idle</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">History
list length 2731</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">LIST
OF TRANSACTIONS
FOR EACH SESSION:</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252530, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252039, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252344, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
0, not started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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 style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">show
engine innodb
status</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252610, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 42, OS
thread handle
0x7fd46f332700,
query id 157834
192.168.1.27 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252382, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 39, OS
thread handle
0x7fd473f5f700,
query id 157566
192.168.1.27 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252605, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 157830
192.168.1.27 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252378, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 37, OS
thread handle
0x7fd473edd700,
query id 157553
192.168.1.27 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252609, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 33, OS
thread handle
0x7fd46f22e700,
query id 157832
192.168.1.45 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252387, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 30, OS
thread handle
0x7fd46f26f700,
query id 157592
192.168.1.45 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252396, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 29, OS
thread handle
0x7fd473fe1700,
query id 157609
192.168.1.45 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252319, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><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 157496
192.168.1.45 root
cleaning up</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">---TRANSACTION
252386, not
started</span></div>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">MySQL
thread id 27, OS
thread handle
0x7fd46f2b0700,
query id 157579
192.168.1.45 root
cleaning up</span></div>
<p class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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
moz-do-not-send="true"
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
moz-do-not-send="true" 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"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">
<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
moz-do-not-send="true"
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
moz-do-not-send="true"
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>Steven
Ayre<br>
<b>Sent:</b><span> </span>Wednesday,
July 17, 2013 3:55
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>
<p class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif"> </p>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New Roman',serif">Run
'SHOW
ENGINE INNODB STATUS\G'</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
What does it
show in the
latest deadlock
section?</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
<div>
<div
style="margin:0in
0in
12pt;font-size:12pt;font-family:'Times
New
Roman',serif">
<br>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">On
17 July 2013
14:16, Lloyd
Aloysius <<a
moz-do-not-send="true" href="mailto:lloyd.aloysius@gmail.com"
style="color:purple;text-decoration:underline"
target="_blank">lloyd.aloysius@gmail.com</a>> wrote:</div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"><span
style="font-family:Verdana,sans-serif">This is newly installed switch.
Only one call
and two
registrations.
I do not do
any queries
against the
DB. I do not
see the
problem again
in last 24
hours. But
want to know
how to solve
this issue.</span></div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
<span
style="font-family:Verdana,sans-serif">Switch
- 2 Quad Core
/ 24 GB Memory
/ 15RPM SCSI ,
DB - 2 Quad
Core / 24 GB
Memory / 15RPM
SCSI . Switch
and DB
connected through a
cross over
cable
directly. I do
not think
this related to
a environment
issue.</span></div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
<span
style="font-family:Verdana,sans-serif">Thanks</span></div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"><span
style="font-family:Verdana,sans-serif;color:rgb(136,136,136)">Lloyd</span></div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
</p>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
On Tue, Jul
16, 2013 at
7:01 AM,
Steven Ayre
<<a
moz-do-not-send="true"
href="mailto:steveayre@gmail.com"
style="color:purple;text-decoration:underline"
target="_blank">steveayre@gmail.com</a>> wrote:</div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
+1</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
The error is
the actual
MySQL error,
so yes it's
definitely a
lock timeout.</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">This
means two
different
queries were
trying to
access the
same data at
the same time.
Normally
one'll wait
until the
other is
finished, but
if it waits
too long you
get the lock
timeout error.</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
It can be
caused by a
query taking
too long, or a
transaction
modifying the
data but then
taking too
long before
commit. To
avoid that
make sure
MySQL is tuned
correctly.
Good indexes
on the tables
and good sizes
for the cache
buffers.</div>
</div>
<div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<blockquote
style="border-style:none
none none
solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in
0in 0in
6pt;margin:5pt
0in 5pt 4.8pt">
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Make
sure you're
using a proper
index for the
delete
operation, I'd
also avoid ORs
if possible.</div>
</blockquote>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
The query is
part of
mod_sofia, so
isn't
modifiable.
Having a
KEY(hostname,expires)
on sip_dialogs
may help
though if it
doesn't
already exist
(check with
SHOW CREATE
TABLE
sip_dialogs).</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
</p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Avoid
accessing
sip_dialogs
from any of
your own code
to minimise
the number of
things that
might block
each other.</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
-Steve</div>
</div>
<div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
12pt;font-size:12pt;font-family:'Times
New
Roman',serif">
<br>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">On
16 July 2013
06:48, Rafal
Gwizdala <<a
moz-do-not-send="true" href="mailto:rafal.gwizdala@gmail.com"
style="color:purple;text-decoration:underline"
target="_blank">rafal.gwizdala@gmail.com</a>> wrote:</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">I'd
bet this is a
lock timeout,
caused by
database
operation
taking too
long.</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
Make sure
you're using a
proper index
for the delete
operation, I'd
also avoid ORs
if possible.</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">R</div>
</div>
</div>
<div>
<div
style="margin:0in
0in
12pt;font-size:12pt;font-family:'Times
New
Roman',serif"> <br>
</div>
<div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
On Tue, Jul
16, 2013 at
4:21 AM, Lloyd
Aloysius <<a
moz-do-not-send="true" href="mailto:lloyd.aloysius@gmail.com"
style="color:purple;text-decoration:underline"
target="_blank">lloyd.aloysius@gmail.com</a>> wrote:</div>
</div>
<blockquote
style="border-style:none
none none
solid;border-left-width:1pt;border-left-color:rgb(204,204,204);padding:0in
0in 0in
6pt;margin:5pt
0in 5pt 4.8pt">
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"><span
style="font-family:Verdana,sans-serif">Hi,</span></div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
</p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"><span
style="font-family:Verdana,sans-serif">I got the following error</span></div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
</p>
</div>
<div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"><span
style="font-family:Verdana,sans-serif">2013-07-15 21:47:<a
moz-do-not-send="true"
href="tel:41.061450" style="color:purple;text-decoration:underline"
target="_blank">41.061450</a><span> </span>[ERR]
switch_odbc.c:514
ERR: [delete
from
sip_dialogs
where (expires
= -1 or
(expires >
0 and expires
<=
1373939087))
and hostname='<a
moz-do-not-send="true" href="http://mydomain.com"
style="color:purple;text-decoration:underline"
target="_blank">mydomain.com</a>']</span></div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"><span
style="font-family:Verdana,sans-serif">[STATE: HY000 CODE 1205 ERROR:
[unixODBC][MySQL][ODBC
5.1
Driver][mysqld-5.5.32]Lock
wait timeout
exceeded; try
restarting
transaction]</span></div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
and the
odbcinst.ini</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
[MySQL]</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Description
= ODBC for
MySQL</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
Driver
=
/usr/lib/libmyodbc5.so</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Setup
=
/usr/lib/libodbcmyS.so</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
Driver64
=
/usr/lib64/libmyodbc5.so</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Setup64
=
/usr/lib64/libodbcmyS.so</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
FileUsage
= 1</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Threading
= 0</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
UsageCount
= 1</div>
</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
This is a
mysql memory
leak? How can
fix this
error?</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
DB Server
running with
24 GB memory
and 2 Quad
Core Xeon</div>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif"> </p>
</div>
<div>
<p
class="MsoNormal"
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
</p>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">Thanks</div>
</div>
<div>
<div
style="margin:0in
0in
0.0001pt;font-size:12pt;font-family:'Times
New
Roman',serif">
<span
style="color:rgb(136,136,136)">Lloyd</span></div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</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>