[Freeswitch-users] Lock wait timeout exceeded; try restarting transaction
Anthony Minessale
anthony.minessale at gmail.com
Sat Jul 27 06:22:23 MSD 2013
*shrug* probably
On Jul 26, 2013 6:37 PM, "I put the Who? in Mishehu" <mishehu at freeswitch.org>
wrote:
> According to http://www.mysql.com/about/legal/licensing/foss-exception/, 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?
>
> -Yossi
>
> On 07/26/2013 03:10 PM, Anthony Minessale wrote:
>
> We still have to set the same odbcinst.ini stuff even in postgres however.
> unixODBC has its own issues as well.
> We do also have a native postgres module but its still new.
>
>
>
> On Fri, Jul 26, 2013 at 2:40 PM, Michael Jerris <mike at jerris.com> wrote:
>
>> We use postgres without issues.
>>
>> On Jul 26, 2013, at 3:35 PM, Ira Tessler <ira at connectmevoice.com> wrote:
>>
>> Would PostgreSQL be a “better” choice with less “issues”? Just curious.
>>
>>
>> Thanks,
>>
>>
>> Ira Tessler
>> Lead Software Engineer
>> ConnectMe
>> (732) 490-9007 x2
>> ira at connectmevoice.com
>>
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Anthony
>> Minessale
>> *Sent:* Friday, July 26, 2013 2:57 PM
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Lock wait timeout exceeded; try
>> restarting transaction
>>
>>
>> We don't support issues in mysql other than recommending the settings
>> to fix the broken locking.
>> ODBC and mysql both have their own issues and bug trackers.
>>
>>
>> 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.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Fri, Jul 26, 2013 at 1:44 PM, Ira Tessler <ira at connectmevoice.com>
>> wrote:
>> I made the change in odbcinst.ini not odbc.ini.
>>
>>
>> # Driver from the mysql-connector-odbc package
>> # Setup from the unixODBC-libs package
>> [MySQL]
>> Description = ODBC for MySQL
>> Driver = /usr/lib/libmyodbc3_r.so
>> Setup = /usr/lib/libodbcmyS.so
>> Driver64 = /usr/lib64/libmyodbc3_r.so
>> Setup64 = /usr/lib64/libodbcmyS.so
>> UsageCount = 1 ß also added this like as per the wiki
>> FileUsage = 1
>> Threading = 0 ß- added this line as per the wiki
>>
>>
>> So far so good.
>>
>>
>> Ira Tessler
>> Lead Software Engineer
>> ConnectMe
>> (732) 490-9007 x2
>> ira at connectmevoice.com
>>
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Lloyd
>> Aloysius
>> *Sent:* Friday, July 26, 2013 2:34 PM
>>
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Lock wait timeout exceeded; try
>> restarting transaction
>>
>>
>> if you can generate this problem. Better you open a issue in JIRA
>>
>>
>> Lloyd
>>
>>
>>
>>
>> * *
>>
>> On Fri, Jul 26, 2013 at 12:32 PM, Ira Tessler <ira at connectmevoice.com>
>> wrote:
>> Sorry ment 1.4.0_latest J
>>
>>
>> Ira Tessler
>> Lead Software Engineer
>> ConnectMe
>> (732) 490-9007 x2 <%28732%29%20490-9007%20x2>
>> ira at connectmevoice.com
>>
>>
>> *From:* Ira Tessler [mailto:ira at connectmevoice.com]
>> *Sent:* Friday, July 26, 2013 12:28 PM
>> *To:* FreeSWITCH Users Help
>> *Subject:* RE: [Freeswitch-users] Lock wait timeout exceeded; try
>> restarting transaction
>>
>>
>> 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.
>>
>>
>> Ira Tessler
>> Lead Software Engineer
>> ConnectMe
>> (732) 490-9007 x2 <%28732%29%20490-9007%20x2>
>> ira at connectmevoice.com
>>
>>
>> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Lloyd
>> Aloysius
>> *Sent:* Friday, July 26, 2013 12:10 PM
>> *To:* FreeSWITCH Users Help
>> *Subject:* Re: [Freeswitch-users] Lock wait timeout exceeded; try
>> restarting transaction
>>
>>
>> I saw this problem several times in my Dev environment. No calls ... Only
>> two registrations.
>>
>>
>> But after I add threading=0 in odbc.ini , I never see this problem
>> again. Also I am using most recent version of freeswitch
>>
>>
>> I am interested into know why this happening even no activity in mysql.
>> I have lots of resources in the machine.
>>
>>
>>
>>
>> Lloyd
>>
>>
>>
>> On Fri, Jul 26, 2013 at 11:30 AM, Ira Tessler <ira at connectmevoice.com>
>> wrote:
>> 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:
>>
>>
>> ------------------------
>> LATEST DETECTED DEADLOCK
>> ------------------------
>> 2013-07-26 11:23:22 7fd473f1e700
>> *** (1) TRANSACTION:
>> TRANSACTION 251674, ACTIVE 2 sec fetching rows
>> mysql tables in use 1, locked 1
>> LOCK WAIT 3 lock struct(s), heap size 376, 3 row lock(s)
>> MySQL thread id 38, OS thread handle 0x7fd473fa0700, query id 156782
>> 192.168.1.27 root updating
>> delete from registrations where expires > 0 and expires <= 1374852304 and
>> hostname='freeswitch_ha0'
>> *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
>> 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
>> Record lock, heap no 22 PHYSICAL RECORD: n_fields 13; compact format;
>> info bits 32
>> 0: len 6; hex 000000001769; asc i;;
>> 1: len 6; hex 00000003d709; asc ;;
>> 2: len 7; hex 070000015b0352; asc [ R;;
>> 3: len 3; hex 373033; asc 703;;
>> 4: len 28; hex 32323535352e7463702e6861312e746573747362636461782e636f6d;
>> asc 22555.tcp.ha1.testsbcdax.com;;
>> 5: len 30; hex
>> 313030303130342d302d313730333030304034372e32332e3130362e3233; asc
>> 1000104-0-1703000 at 47.23.106.23; (total 31 bytes);
>> 6: len 30; hex
>> 736f6669612f6861315f696e7465726e616c5f7463702f7369703a373033; asc
>> sofia/ha1_internal_tcp/sip:703; (total 152 bytes);
>> 7: len 4; hex d1f2962a; asc *;;
>> 8: len 12; hex 31302e31302e31302e313032; asc 10.10.10.102;;
>> 9: len 5; hex 3230303031; asc 20001;;
>> 10: len 3; hex 746370; asc tcp;;
>> 11: len 14; hex 667265657377697463685f686131; asc freeswitch_ha1;;
>> 12: SQL NULL;
>>
>>
>> *** (2) TRANSACTION:
>> TRANSACTION 251657, ACTIVE 2 sec starting index read
>> mysql tables in use 1, locked 1
>> 5 lock struct(s), heap size 1248, 5 row lock(s), undo log entries 2
>> MySQL thread id 28, OS thread handle 0x7fd473f1e700, query id 156786
>> 192.168.1.45 root updating
>> delete from registrations where expires > 0 and expires <= 1374852306 and
>> hostname='freeswitch_ha1'
>> *** (2) HOLDS THE LOCK(S):
>> 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
>> Record lock, heap no 22 PHYSICAL RECORD: n_fields 13; compact format;
>> info bits 32
>> 0: len 6; hex 000000001769; asc i;;
>> 1: len 6; hex 00000003d709; asc ;;
>> 2: len 7; hex 070000015b0352; asc [ R;;
>> 3: len 3; hex 373033; asc 703;;
>> 4: len 28; hex 32323535352e7463702e6861312e746573747362636461782e636f6d;
>> asc 22555.tcp.ha1.testsbcdax.com;;
>> 5: len 30; hex
>> 313030303130342d302d313730333030304034372e32332e3130362e3233; asc
>> 1000104-0-1703000 at 47.23.106.23; (total 31 bytes);
>> 6: len 30; hex
>> 736f6669612f6861315f696e7465726e616c5f7463702f7369703a373033; asc
>> sofia/ha1_internal_tcp/sip:703; (total 152 bytes);
>> 7: len 4; hex d1f2962a; asc *;;
>> 8: len 12; hex 31302e31302e31302e313032; asc 10.10.10.102;;
>> 9: len 5; hex 3230303031; asc 20001;;
>> 10: len 3; hex 746370; asc tcp;;
>> 11: len 14; hex 667265657377697463685f686131; asc freeswitch_ha1;;
>> 12: SQL NULL;
>>
>>
>> *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
>> 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
>> Record lock, heap no 3 PHYSICAL RECORD: n_fields 13; compact format; info
>> bits 0
>> 0: len 6; hex 0000000016d1; asc ;;
>> 1: len 6; hex 000000033bc4; asc ; ;;
>> 2: len 7; hex d20000022f0110; asc / ;;
>> 3: len 3; hex 383033; asc 803;;
>> 4: len 21; hex 32323535382e636d767465737474656c652e636f6d; asc
>> 22558.cmvtesttele.com;;
>> 5: len 30; hex
>> 62326365383430342d6438313665303162403139322e3136382e3230302e; asc
>> b2ce8404-d816e01b at 192.168.200.; (total 33 bytes);
>> 6: len 30; hex
>> 736f6669612f6861305f696e7465726e616c2f7369703a38303340313038; asc
>> sofia/ha0_internal/sip:803 at 108; (total 46 bytes);
>> 7: len 4; hex d1f29d68; asc h;;
>> 8: len 14; hex 3130382e35382e3130302e313432; asc 108.58.100.142;;
>> 9: len 4; hex 35303630; asc 5060;;
>> 10: len 3; hex 756470; asc udp;;
>> 11: len 14; hex 667265657377697463685f686130; asc freeswitch_ha0;;
>> 12: SQL NULL;
>>
>>
>> *** WE ROLL BACK TRANSACTION (1)
>> ------------
>> TRANSACTIONS
>> ------------
>> Trx id counter 252611
>> Purge done for trx's n:o < 252607 undo n:o < 0 state: running but idle
>> History list length 2731
>> LIST OF TRANSACTIONS FOR EACH SESSION:
>> ---TRANSACTION 252530, not started
>> MySQL thread id 127, OS thread handle 0x7fd49c0e4700, query id 157673
>> 192.168.1.45 root cleaning up
>> ---TRANSACTION 252039, not started
>> MySQL thread id 126, OS thread handle 0x7fd473e1a700, query id 157059
>> 192.168.1.45 root cleaning up
>> ---TRANSACTION 252344, not started
>> MySQL thread id 125, OS thread handle 0x7fd46f12a700, query id 157516
>> 192.168.1.27 root cleaning up
>> ---TRANSACTION 0, not started
>> MySQL thread id 117, OS thread handle 0x7fd473e5b700, query id 157835
>> localhost root init
>> show engine innodb status
>> ---TRANSACTION 252610, not started
>> MySQL
>>
>>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
>
>
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
> ...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130726/1d2fb234/attachment-0001.html
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users
mailing list