Infinite quantity of transactions start and rollback when DB trigger on
rollback contains error
-----------------------------------------------------------------------------------------------
Key: CORE-3445
URL: http://tracker.firebirdsql.org/browse/CORE-3445
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
DDL:
create table tmp (id integer not null,val integer);
commit;
alter table tmp add primary key (id);
insert into tmp values(1,1);
commit;
create or alter trigger dbtg_rollback
active on transaction rollback position 0
as begin
in autonomous transaction do
insert into tmp(id,val) values(1,1);
end;
commit;
recreate table t(id int not null primary key);
commit;
insert into t values(1);
insert into t values(2);
insert into t values(3);
insert into t values(5);
insert into t values(4);
insert into t values(6);
commit;
Scenario:
========
Attach_0:
commit; set transaction read write read committed;
update t set id=-id where id=4;
Then run 300 ISQL sesions that attempts to select table "t" but can not doing
this due to NORECVERSION level of their RC and WAIT clause:
Script file 'SEL.SQL':
commit; set transaction read write read committed;
select * from t where id+0 between 5 and 6;
Batch file 'SEL.BAT':
for /l %%i in (1, 1, %1) do ( start isql -i sel.sql -o sel.log test.fdb )
Run sample for 300 ISQLs:
SEL.BAT 300 [Enter].
This leads to appearing 300 'dead' windows that all are waiting for Attach_0
free record that was updated at the first step.
After waiting ~10 minutes we kill all these windows via PSKILL.EXE utility.
Since that moment Firebird starts a huge number of transactions and they are in
'hang' state a few minutes. After that a hude number of rollbacks begin but
this process seems to be infinite.
Audit log raise in size infinitely but fiebird.log still remains empty.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
