Commented by: @dyemanov

Does error happen with just one connection or two independent connections? Does the second statement delete the record after the first one or concurrently? Which statement does produce the error - first or second? Any chance for a reproducible test case?

Commented by: Olaf Kluge (okl)

Hello,

I get the error with one connection, the other clients does not call this stored procedure. This SP should delete all records incluedes a certain order, I think, during deleting the one record, the trigger deletes in the same table this with the referenced ID and the SP found not the marked record again and I get an error during SP-Call like this in my post.
By debugging, the statement in SP "delete from table where .. "

Herewith a sql file for creating test-table, insert records and execute for error.

Commented by: Arioch (arioch)

maybe you can workaround (not solve) it by deleting in autonomous transaction

http://www.firebirdsql.org/refdocs/langrefupd25-psql-autonomous-trans.html

Commented by: Erik Jõeveer (erikj)

I have same problem with FB3.0 (no problems with FB2 or FB1.5).
It also involves delete trigger that deletes from same table. And in result it is not possible to delete multiple records from this table in one transaction. It seems that if record is already deleted by trigger then it is still visible in same transaction context and when second delete occurs then this error is thrown:
ISC ERROR CODE:335544348 ISC ERROR MESSAGE: no current record for fetch operation

CREATE TABLE TEST_TABLE (
ID NUMERIC(10,0) NOT NULL,
RELATED_ID NUMERIC(10,0)
);
ALTER TABLE TEST_TABLE ADD PRIMARY KEY (ID);
COMMIT;

SET TERM ^ ;
CREATE TRIGGER TEST_TABLE_D FOR TEST_TABLE
ACTIVE BEFORE DELETE POSITION 0
AS
begin
delete from TEST_TABLE where related_id=http://old.ID;
end
^
SET TERM ; ^
COMMIT;

INSERT INTO TEST_TABLE (ID,RELATED_ID) VALUES (1,NULL);
INSERT INTO TEST_TABLE (ID,RELATED_ID) VALUES (2,1);
COMMIT;

/* AND THIS WILL GIVE ERROR: */
DELETE FROM TEST_TABLE;

Commented by: @dyemanov

This issue is being worked on.