Find the answer to your Linux question:
Results 1 to 2 of 2
Hi, Few of our database tables are locked always whenever insert or update statement are about to execute. We've defined innodb lock time out as 120, so the transaction times ...
  1. 12-27-2010 #1
    chocba
    chocba is offline
    Just Joined!
    Join Date
    Dec 2010
    Posts
    1

    Mysql 5.0.67 In SUSE Linux

    Hi,
    Few of our database tables are locked always whenever insert or update statement are about to execute. We've defined innodb lock time out as 120, so the transaction times out in 2 minutes. Mysql server version is 5.0.67 and SUSE Linux is the OS. Any idea why the tables are getting locked always, please let me know. We see "lock wait time out exception, try restarting transcation" in our tomcat instance logs. Does this version of Mysql requre any patch to be applied? Appreciate any help.

    Below is the snippet of "show variables" command output :

    version 5.0.67
    version_comment SUSE MySQL RPM
    version_compile_machine x86_64
    version_compile_os suse-linux-gnu
    Reply With Quote Reply With Quote
  2. 01-03-2011 #2
    gogalthorp
    gogalthorp is offline
    Linux Guru gogalthorp's Avatar
    Join Date
    Oct 2006
    Location
    West (by God) Virginia
    Posts
    3,105
    Permissions maybe??
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

...