473,396 Members | 1,703 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

4.0.15 lock timeout

I'm running the same application on 4.0.1-alpha-win and 4.0.15-win.
Under 4.0.15 I run the same test client as I run against
4.0.1-alpha-win. The behavior is different. In particular, 4.0.15
produces a "Lock wait timeout exceeded; Try restarting transaction"
which does not occur under 4.0.1-alpha-win.

All tables are innoDB.
No "SELECT...FOR UPDATE" is being done.
transaction isolation level is SERIALIZABLE.
Many Selects go through.
The first update hangs, then I get the lock timeout exception.

I don't think the behavior is correct since this code works fine under
4.0.1.
Has anyone else seen unexplained waits on update? If I had done a
SELECT...FOR UPDATE, then I could understand that the wait might be
caused by an uncommitted transaction that performed the SELECT...FOR
UPDATE.

Any help appreciated.
Jul 19 '05 #1
0 3184

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Antoon Pardon | last post by:
The queue and condition class allow threads to wait only a limited time. However this currently is implemented by a polling loop. Now for those who like to avoid polling I have here a Tlock...
3
by: rkusenet | last post by:
Hi, Version Info: SQLSERVER 2000 SP3 I am trying to understand how SQL Server works with SERIALIZABLE read. I am fairly new to SQL Server, having mainly worked with Informix. We are getting...
2
by: john.livermore | last post by:
I am tracing a SQL Server 2000 production server that gets a query about every second. The Event I chose to watch was "Lock:Timeout". To my surprise I see many of these come through the trace. ...
5
by: harborboy76 | last post by:
Hi all, First of all, just want to let you know that I'm coming from Informix background, and we just recently migrated to DB2. It's been a great new learning experience. For the time being, I...
14
by: Sharon | last post by:
Hi all. I have an ArrayList and sometimes while enumerating through, i get an exception because another thread has added to the ArrayList. To solve this problem, i lock the enumeration, passing...
8
by: Komandur Kannan | last post by:
We have a smart device application running on handhelds(Symbol MC9000G). The backend is Oracle and a middle tier web services development done in Vb.net. We use pessimistic Locking due to...
2
by: Kevin Frey | last post by:
Hello, I've been reading that ASP.NET serialises (ie. processes one at a time) HTTP requests if two simultaneous requests need to access the same session state. It also makes note that ASP.NET...
1
by: pike | last post by:
DB2 8.1 FP7a on AIX 5.2. $ db2 SET CURRENT LOCK TIMEOUT NOT WAIT DB20000I The SQL command completed successfully. $ db2 values current lock timeout 1 ----------- 0
0
by: cwho.work | last post by:
Hi! We are using apache ibatis with our MySQL 5.0 database (using innodb tables), in our web application running on Tomcat 5. Recently we started getting a number of errors relating to...
4
by: jankhana | last post by:
Hi all, I'm having an application in that i use Sql Compact 3.5 with VS2008. I'm running multiple threads in my application which contacts the compact database and accesses the row. It...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.