Subject | Deadlock during index activation |
---|---|
Author | Alec Swan |
Post date | 2010-07-23T19:39:21Z |
Hello,
Could anybody explain what could cause a deadlock during index
activation on the entire database?
EXECUTE BLOCK AS DECLARE VARIABLE stmt VARCHAR(1000); BEGIN for select
'ALTER INDEX "'||rdb$index_name ||'" ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0 into :stmt
do EXECUTE STATEMENT :stmt; END;
GDS Exception. 335544336. deadlock
Reason: deadlock
Thanks,
Alec
Could anybody explain what could cause a deadlock during index
activation on the entire database?
EXECUTE BLOCK AS DECLARE VARIABLE stmt VARCHAR(1000); BEGIN for select
'ALTER INDEX "'||rdb$index_name ||'" ACTIVE;'
from rdb$indices
where rdb$system_flag is not null and rdb$system_flag = 0 into :stmt
do EXECUTE STATEMENT :stmt; END;
GDS Exception. 335544336. deadlock
Reason: deadlock
Thanks,
Alec