SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    873
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lock wait timeout exceeded; try restarting transaction even in single db single user

    Dear All,
    I am updating few databases all which I keep as one transaction using .net connector. The best part is that I can still run into this error of "Lock wait timeout exceeded; try restarting transaction" even though I am the only single soul using my database at that time. Any idea how to over come this problem. Thanks.

  2. #2
    SitePoint Member
    Join Date
    Nov 2006
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    take a look at this bug report; All the way at the bottom, last two posts are pretty insightful.

    http://bugs.mysql.com/bug.php?id=10641

  3. #3
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    We also come across same problem and solved by freeing the sql connection which was utilized in previous queries.So there won't be any mistakes with your current queries and code.But you have to free the connections after usage for reusing them from the connection pool(Guess you are using one either directly or indirectly).

    Thanks and Regards,
    Saji T Sathian
    Last edited by sajisathian; Sep 22, 2009 at 01:05. Reason: Error

  4. #4
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up

    If still problems exist Debug your SQL Server


Bookmarks

Posting Permissions

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