Bug #20497 Trigger with INSERT DELAYED causes Error 1165
Submitted: 16 Jun 2006 10:11 Modified: 23 Aug 2006 17:11
Reporter: Thomas Schwanhaeuser Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.22 OS:Linux (Linux AMD64)
Assigned to: Assigned Account CPU Architecture:Any

[16 Jun 2006 10:11] Thomas Schwanhaeuser 
Description:
A trigger which uses a INSERT DELAYED causes a Error 1165 claiming that the target table is locked although it's not

How to repeat:
Create two tables a and b with identical schemas and create a trigger which inserts any updates on table a in table b. It works fine with an INSERT command, but INSERT DELAYED creates the error message:

Error: 1165 SQLSTATE: HY000 (ER_DELAYED_INSERT_TABLE_LOCKED)

Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES

An explicit UNLOCK TABLES before the command didn't show any effect.
[23 Aug 2006 17:11] Tomash Brechko 
This bug is a duplicate of bug#21483.

This bug reveals a part of a problem that will be fixed with a patch for bug#21483.