MySQL Forums
Forum List  »  Triggers

Locking problem with triggers
Posted by: Mark Rigney
Date: May 25, 2006 12:48PM

Hi,
I having a locking problem that arises when I use a trigger. I have an innodb table (say table X) that is updated via a stored procedure which is called by a trigger on a different table (say table Y). When the trigger fires due to an insert on table Y it calls the stored procedure to update the corresponding record in table X. This is working fine. The problem occurs when I'm doing a simple select on table X. No updates - just a simple query to read rows flagged a certain way. If the stored procedure tries to update table X while the select query is running it says the table is locked and waits.

Any clues? Am I missing something simple?

Thanks in advance,
Mark

Options: ReplyQuote


Subject
Views
Written By
Posted
Locking problem with triggers
2937
May 25, 2006 12:48PM
1816
June 02, 2006 06:29AM


Sorry, you can't reply to this topic. It has been closed.

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.