<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><base href="x-msg://21252/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">We use postgres without issues.<div><br><div><div>On Jul 26, 2013, at 3:35 PM, Ira Tessler <<a href="mailto:ira@connectmevoice.com">ira@connectmevoice.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-US" 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; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div class="WordSection1" style="page: WordSection1; "><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="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(34, 34, 34); background-color: white; background-position: initial initial; 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-color: white; background-position: initial initial; background-repeat: initial initial; ">Lead Software Engineer</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; ">ConnectMe</span><br><span style="background-color: white; background-position: initial initial; 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 href="mailto:ira@connectmevoice.com" target="_blank" style="color: purple; text-decoration: underline; "><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 class="Apple-converted-space"> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Anthony Minessale<br><b>Sent:</b><span class="Apple-converted-space"> </span>Friday, July 26, 2013 2:57 PM<br><b>To:</b><span class="Apple-converted-space"> </span>FreeSWITCH Users Help<br><b>Subject:</b><span class="Apple-converted-space"> </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 class="webkit-block-placeholder"></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 href="mailto:ira@connectmevoice.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </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 class="Apple-converted-space"> </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 class="Apple-converted-space"> </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="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(34, 34, 34); background-color: white; background-position: initial initial; 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-color: white; background-position: initial initial; background-repeat: initial initial; ">Lead Software Engineer</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; ">ConnectMe</span><br><span style="background-color: white; background-position: initial initial; 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 href="mailto:ira@connectmevoice.com" target="_blank" style="color: purple; text-decoration: underline; "><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 class="Apple-converted-space"> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Lloyd Aloysius<br><b>Sent:</b><span class="Apple-converted-space"> </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 class="Apple-converted-space"> </span>FreeSWITCH Users Help<br><b>Subject:</b><span class="Apple-converted-space"> </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 class="webkit-block-placeholder"></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 href="mailto:ira@connectmevoice.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </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="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(34, 34, 34); background-color: white; background-position: initial initial; 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-color: white; background-position: initial initial; background-repeat: initial initial; ">Lead Software Engineer</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; ">ConnectMe</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; "><a href="tel:%28732%29%20490-9007%20x2" target="_blank" style="color: purple; text-decoration: underline; ">(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" target="_blank" style="color: purple; text-decoration: underline; "><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 class="Apple-converted-space"> </span>Ira Tessler [mailto:<a href="mailto:ira@connectmevoice.com" target="_blank" style="color: purple; text-decoration: underline; ">ira@connectmevoice.com</a>]<span class="Apple-converted-space"> </span><br><b>Sent:</b><span class="Apple-converted-space"> </span>Friday, July 26, 2013 12:28 PM<br><b>To:</b><span class="Apple-converted-space"> </span>FreeSWITCH Users Help<br><b>Subject:</b><span class="Apple-converted-space"> </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="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(34, 34, 34); background-color: white; background-position: initial initial; 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-color: white; background-position: initial initial; background-repeat: initial initial; ">Lead Software Engineer</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; ">ConnectMe</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; "><a href="tel:%28732%29%20490-9007%20x2" target="_blank" style="color: purple; text-decoration: underline; ">(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" target="_blank" style="color: purple; text-decoration: underline; "><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 class="Apple-converted-space"> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Lloyd Aloysius<br><b>Sent:</b><span class="Apple-converted-space"> </span>Friday, July 26, 2013 12:10 PM<br><b>To:</b><span class="Apple-converted-space"> </span>FreeSWITCH Users Help<br><b>Subject:</b><span class="Apple-converted-space"> </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 class="webkit-block-placeholder"></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 href="mailto:ira@connectmevoice.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </span><a href="http://22555.tcp.ha1.testsbcdax.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </span><a href="mailto:1000104-0-1703000@47.23.106.23" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </span><a href="http://22555.tcp.ha1.testsbcdax.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </span><a href="mailto:1000104-0-1703000@47.23.106.23" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </span><a href="http://22558.cmvtesttele.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="Apple-converted-space"> </span><a href="mailto:b2ce8404-d816e01b@192.168.200." target="_blank" style="color: purple; text-decoration: underline; ">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="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(34, 34, 34); background-color: white; background-position: initial initial; 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-color: white; background-position: initial initial; background-repeat: initial initial; ">Lead Software Engineer</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; ">ConnectMe</span><br><span style="background-color: white; background-position: initial initial; background-repeat: initial initial; "><a href="tel:%28732%29%20490-9007%20x2" target="_blank" style="color: purple; text-decoration: underline; ">(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" target="_blank" style="color: purple; text-decoration: underline; "><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 class="Apple-converted-space"> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: purple; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Steven Ayre<br><b>Sent:</b><span class="Apple-converted-space"> </span>Wednesday, July 17, 2013 3:55 PM<br><b>To:</b><span class="Apple-converted-space"> </span>FreeSWITCH Users Help<br><b>Subject:</b><span class="Apple-converted-space"> </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 class="webkit-block-placeholder"></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 href="mailto:lloyd.aloysius@gmail.com" target="_blank" style="color: purple; text-decoration: underline; ">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 href="mailto:steveayre@gmail.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="webkit-block-placeholder"></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 href="mailto:rafal.gwizdala@gmail.com" target="_blank" style="color: purple; text-decoration: underline; ">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 class="webkit-block-placeholder"></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 href="mailto:lloyd.aloysius@gmail.com" target="_blank" style="color: purple; text-decoration: underline; ">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; position: static; z-index: auto; "><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 href="tel:41.061450" target="_blank" style="color: purple; text-decoration: underline; ">41.061450</a><span class="Apple-converted-space"> </span>[ERR] switch_odbc.c:514 ERR: [delete from sip_dialogs where (expires = -1 or (expires > 0 and expires <= 1373939087)) and hostname='<a href="http://mydomain.com" target="_blank" style="color: purple; text-decoration: underline; ">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></body></html>