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:
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

[11 Jan 2008 13:00] Hartmut Holzgraefe
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