Too Many Concurrent Executions of the Same Request

By: Borland Staff

Abstract: Caused by recursive triggers

Problem:
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"

Solution:
IB V4.x

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!!

Server Response from: ETNASC03