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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.