<p>*shrug* probably</p>
<div class="gmail_quote">On Jul 26, 2013 6:37 PM, "I put the Who? in Mishehu" <<a href="mailto:mishehu@freeswitch.org">mishehu@freeswitch.org</a>> 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 & 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"><<a 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>
<div><br>
<div>
<div>On Jul 26, 2013, at 3:35 PM, Ira Tessler <<a 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><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'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 <<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>>
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 <<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>>
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 <<a href="mailto:ira@connectmevoice.com" style="color:purple;text-decoration:underline" target="_blank">ira@connectmevoice.com</a>>
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 >
0 and expires
<= 1374852304
and
hostname='freeswitch_ha0'</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 >
0 and expires
<= 1374852306
and
hostname='freeswitch_ha1'</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's n:o
< 252607 undo
n:o < 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>