Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Done
-
8.0.15-6, 5.7.26-29
-
None
-
Red Hat Enterprise Linux Server release 6.3
Description
how to repeat:
(1) master-slave, enable multithreaded replication.
slave_parallel_type=LOGICAL_CLOCK
slave_parallel_workers=16
slave_preserve_commit_order=ON
(2) write data on master by sysbench
(3) execute sql on slave continually,sql:
set global super_read_only=OFF; set global super_read_only=ON;
when dead lock occur, show processlist as below:
Attachments
Issue Links
- is duplicated by
-
PS-7368 MTS ordered commit may cause deadlock
-
- Done
-