什么是僵尸交易? [英] What is zombie transaction?

问题描述

无意中发现SqlTransaction代码中提到了zombie transaction.那么，什么是僵尸交易?

I accidentally found zombie transaction is mentioned in SqlTransaction code. So, what is zombie transaction?

推荐答案

僵尸事务是无法提交(由于不可恢复的错误)但仍处于打开状态的事务.

A zombie transaction is a transaction that cannot be committed (due to an unrecoverable error) but is still open.

CREATE TABLE mytable (id INT NOT NULL PRIMARY KEY)
SET XACT_ABORT ON;
BEGIN TRY
        BEGIN TRANSACTION
                INSERT
                INTO    mytable
                VALUES  (1)
                INSERT
                INTO    mytable
                VALUES  (1)
        COMMIT
END TRY
BEGIN CATCH
        PRINT XACT_STATE()
        SELECT  *
        FROM    mytable
        ROLLBACK;
END CATCH
SELECT  *
FROM    mytable

这里，第二个 INSERT 呈现事务僵尸.

Here, the second INSERT renders the transaction zombie.

它不能再写，应该回滚，但你仍然可以在它的范围内读取(最里面的SELECT返回一条记录；最外面的没有).

It cannot write anymore and should be rolled back, but you can still read in its scope (the innermost SELECT returns a record; the outermost does not).

这篇关于什么是僵尸交易?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！