Title: InterBase: Too Many Concurrent Execution of the Same Request
Question: Too Many Concurrent Execution of the Same Request error when
inserting or updating a table.
"Statement failed, SQLCODE = -693
Too many concurrent executions of the same request"
Answer:
This is caused by recursive triggers. Here is an example of a recursive trigger that will return the error message.
CREATE TRIGGER TGET_CUST_ID2 for TABLE1
BEFORE INSERT
AS
BEGIN
insert into table1(cust_id) values (5);
/* this is a recursive trigger where the same insert
trigger is called
by itself and is creating an infinite loop */
END!!
Re-evaluate the trigger to ensure there is no recursion. Here
is an example to fix the above example to eliminate recursion.
CREATE TRIGGER TGET_CUST_ID for TABLE1
BEFORE INSERT
AS
BEGIN
new.cust_id = 5;
END!!
Author: Jenny Li, James Arias-La Rheir, Wayne Shaddock, Brett Bandy