MySQL Bugs: #33819: single PK-only query transactiosn fail with deadlock timeout on BLOB tables

Bug #33819	single PK-only query transactiosn fail with deadlock timeout on BLOB tables
Submitted:	11 Jan 2008 13:00	Modified:	16 Jan 2014 15:23
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-5.0	OS:	Linux
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	5.0.37

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
An application doing SELECTs and INSERTs by primary key on a table with a TEXT field sometimes fail with 

  1205: Lock wait timeout exceeded; try restarting transaction

As each SELECT and INSERT only affects one row and as there is only one statement per transaction no such deadlocks should occur.

How to repeat:
to be added later