Re: Locking problem with triggers

[Jaime Alfaro Carballo]

Hello:

I'm having a similar problem. I have a BEFORE UPDATE trigger on table A with the following definition:

CREATE TRIGGER `BEFORE_UPDATE_A` BEFORE UPDATE ON `A`
FOR EACH ROW
BEGIN
SET new.LAST_UPDATE = now();
END;

The trigger works fine as long as no other action is made on the table while the trigger is running, if I try to make a select on table A while updating a row I get an error message "Lock wait timeout exceeded".

¿Has anybody reported this bug to MySQL?

Thank you very much,
Jaime