我有一个长时间运行的进程,用于导入产品,但有时会出现死锁错误。根据我的了解,我认为如果在脚本执行期间将隔离级别切换为 Serializable
,就可以解决死锁问题。但是,我该怎么办呢?我可以打开两个终端并使用 Serializable
复现死锁。
conn1: SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALAZIBLE;
conn1: START TRANSACTION;
conn2: START TRANSACTION;
conn1: UPDATE core_config_data set value = 1 WHERE config_id = 1;
conn2: UPDATE core_config_data set value = 1 WHERE config_id = 2;
conn1: UPDATE core_config_data set value = 1 WHERE config_id = 2; waiting...
conn2: UPDATE core_config_data set value = 1 WHERE config_id = 1; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
好的,在此之后,我尝试使用“读未提交
”进行“脏读
”:
conn1: SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
conn1: START TRANSACTION;
conn1: SELECT junk FROM employees WHERE employee_id = 1; junk=test;
conn2: START TRANSACTION;
conn2: update employees set junk='test1' where employee_id = 1;
conn1: SELECT junk FROM employees WHERE employee_id = 1; junk=test;
你知道我错在哪里吗?
这段内容与IT技术无关,请提供正确的内容。