Subject Deadlock during index activation
Author Alec Swan
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