type: ENUM('IDLE','RUNNING','LOCKWAITING','COMMITTING','ROLLINGBACK') NULL
Note:
The current state of the transaction. The possible values include:\n\nIdle: The transaction is in an idle state, that is, it is waiting for the user to input a query.\nRunning: The transaction is executing a query.\nLockWaiting: The transaction is waiting for the pessimistic lock to be acquired. Note that the transaction enters this state at the beginning of the pessimistic locking operation, no matter whether it is blocked by other transactions or not.\nCommitting: The transaction is in the process of commit.\nRollingBack: The transaction is being rolled back.
type: ENUM('NORMAL','LOCKWAITING','COMMITTING','ROLLINGBACK') NULL
Note:
The current state of the transaction. The possible values include:\n\nNormal: The transaction is being executed normally or in an idle state.\nLockWaiting: The transaction is waiting for the pessimistic lock to be acquired. Note that the transaction enters this state at the beginning of the pessimistic locking operation, no matter whether it is blocked by other transactions or not.\nCommitting: The transaction is in the process of commit.\nRollingBack: The transaction is being rolled back.