Description:
2018-03-29T07:35:25.042879Z 34943 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 123; events assigned = 2075649; worker queues filled over overrun level = 6408; waited due a Worker queue full = 4202; waited due the total size = 0; waited at clock conflicts = 2020283630600 waited (count) when Workers occupied = 55068 waited when Workers occupied = 190503642700
2018-03-29T07:37:25.661131Z 34943 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 120; events assigned = 2145281; worker queues filled over overrun level = 6408; waited due a Worker queue full = 4202; waited due the total size = 0; waited at clock conflicts = 2139545324100 waited (count) when Workers occupied = 55072 waited when Workers occupied = 191026928000
2018-03-29T07:39:25.016732Z 34943 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 120; events assigned = 2413569; worker queues filled over overrun level = 6408; waited due a Worker queue full = 4202; waited due the total size = 0; waited at clock conflicts = 2255298130400 waited (count) when Workers occupied = 55075 waited when Workers occupied = 191112637200
2018-03-29T07:40:03.983622Z 34943 [Warning] Slave SQL for channel '': Coordinator thread of multi-threaded slave is being stopped in the middle of assigning a group of events; deferring to exit until the group completion ... , Error_code: 0
2018-03-29T07:40:03.984144Z 34943 [Note] Slave SQL thread for channel '' exiting, replication stopped in log 'sgrdb-bin.002104' at position 325722104
2018-03-29T07:40:04.011857Z 19731 [Note] Slave I/O thread killed while reading event for channel ''
2018-03-29T07:40:04.011879Z 19731 [Note] Slave I/O thread exiting for channel '', read up to log 'sgrdb-bin.002110', position 783272267
How to repeat:
I am not sure.How to repeat it,there are some variables below:
slave_parallel_workers=8;
slave_parallel_type='LOGICAL_CLOCK';
Suggested fix:
I will try to set global slave_parallel_workers=0 and observe result;
command：
stop slave;
set global slave_parallel_workers=0;
start slave;
