Locking problem with triggers
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
Subject
Views
Written By
Posted
Locking problem with triggers
2937
May 25, 2006 12:48PM
1994
May 29, 2006 03:31PM
1785
May 31, 2006 12:19PM
1816
June 02, 2006 06:29AM
1833
July 14, 2006 03:17AM
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.