Error Log -------------- 2020-05-07T10:46:43.062956Z 0 [Note] ./bin/mysqld: ready for connections. Version: '5.7.30-log' socket: '/home/anon/rpl/intermediate/sock' port: 3334 MySQL Community Server (GPL) 2020-05-07T10:46:47.544151Z 2 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=fc30-relay-bin' to avoid this problem. 2020-05-07T10:46:47.560166Z 2 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='127.0.0.1', master_port= 3333, master_log_file='', master_log_pos= 4, master_bind=''. 2020-05-07T10:46:47.582567Z 3 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2020-05-07T10:46:47.583524Z 3 [Note] Slave I/O thread for channel '': connected to master 'root@127.0.0.1:3333',replication started in log 'FIRST' at position 4 2020-05-07T10:46:47.631922Z 4 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './fc30-relay-bin.000001' position: 4 2020-05-07T10:46:48.777661Z 26 [Note] Start binlog_dump to master_thread_id(26) slave_server(3), pos(, 4) 2020-05-07T10:46:48.904109Z 27 [Note] Start binlog_dump to master_thread_id(27) slave_server(4), pos(, 4) 2020-05-07T10:47:25.424326Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424326Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424382Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424403Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424326Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424356Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:691' at master log binlog.000002, end_log_pos 249745; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424357Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:685' at master log binlog.000002, end_log_pos 247573; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424357Z 16 [Warning] Slave SQL for channel '': Worker 12 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:694' at master log binlog.000002, end_log_pos 250831; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424462Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424382Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424383Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424327Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:687' at master log binlog.000002, end_log_pos 248297; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424402Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424330Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424326Z 21 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:699' at master log binlog.000002, end_log_pos 252641; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424435Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:683' at master log binlog.000002, end_log_pos 246849; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424357Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:692' at master log binlog.000002, end_log_pos 250107; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424862Z 23 [Warning] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:25.424910Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:686' at master log binlog.000002, end_log_pos 247935; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425771Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:691' at master log binlog.000002, end_log_pos 249745; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425820Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:683' at master log binlog.000002, end_log_pos 246849; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425843Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425861Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425886Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425904Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425939Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.425966Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.426019Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.426070Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:28.426123Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:687' at master log binlog.000002, end_log_pos 248297; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:30.426023Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:685' at master log binlog.000002, end_log_pos 247573; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:30.426023Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:31.426884Z 23 [Warning] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427679Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427714Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427739Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427679Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:686' at master log binlog.000002, end_log_pos 247935; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427771Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:687' at master log binlog.000002, end_log_pos 248297; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427714Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427803Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427679Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:691' at master log binlog.000002, end_log_pos 249745; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427831Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:683' at master log binlog.000002, end_log_pos 246849; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427817Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427708Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427679Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:32.427916Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:33.426369Z 16 [Warning] Slave SQL for channel '': Worker 12 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:694' at master log binlog.000002, end_log_pos 250831; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:35.427423Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:685' at master log binlog.000002, end_log_pos 247573; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:35.427423Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:35.427477Z 21 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:699' at master log binlog.000002, end_log_pos 252641; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:35.427510Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:692' at master log binlog.000002, end_log_pos 250107; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:37.426845Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:686' at master log binlog.000002, end_log_pos 247935; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:37.426844Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:703' at master log binlog.000002, end_log_pos 254089; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:37.426923Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:687' at master log binlog.000002, end_log_pos 248297; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:37.426981Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:37.427022Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:41.427394Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:691' at master log binlog.000002, end_log_pos 249745; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:41.427394Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:41.427639Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:41.427701Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:43.432483Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:706' at master log binlog.000002, end_log_pos 255175; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:43.432556Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:704' at master log binlog.000002, end_log_pos 254451; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:44.428271Z 16 [Warning] Slave SQL for channel '': Worker 12 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:694' at master log binlog.000002, end_log_pos 250831; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:44.428271Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427532Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427572Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:706' at master log binlog.000002, end_log_pos 255175; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427601Z 23 [Warning] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427573Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:692' at master log binlog.000002, end_log_pos 250107; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427603Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427534Z 21 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:699' at master log binlog.000002, end_log_pos 252641; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427660Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:703' at master log binlog.000002, end_log_pos 254089; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:46.427534Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:48.427907Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:48.427907Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:48.427907Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:48.427985Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:48.427910Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:48.427916Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:704' at master log binlog.000002, end_log_pos 254451; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:50.427974Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:706' at master log binlog.000002, end_log_pos 255175; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:51.428168Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:51.428241Z 16 [Warning] Slave SQL for channel '': Worker 12 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:694' at master log binlog.000002, end_log_pos 250831; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:52.428393Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:703' at master log binlog.000002, end_log_pos 254089; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428400Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428420Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428438Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428480Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428542Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:692' at master log binlog.000002, end_log_pos 250107; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428512Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428605Z 21 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:699' at master log binlog.000002, end_log_pos 252641; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428661Z 23 [Warning] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:53.428719Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:54.428668Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:704' at master log binlog.000002, end_log_pos 254451; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:55.428749Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:706' at master log binlog.000002, end_log_pos 255175; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:55.428749Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:55.428856Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:55.428786Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:55.428887Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:59.429006Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:703' at master log binlog.000002, end_log_pos 254089; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:47:59.429006Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430092Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430092Z 23 [Warning] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430300Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:691' at master log binlog.000002, end_log_pos 249745; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430445Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430557Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430659Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430782Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:692' at master log binlog.000002, end_log_pos 250107; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.430905Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.431022Z 21 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:699' at master log binlog.000002, end_log_pos 252641; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:00.431134Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:02.429013Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:03.429726Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429492Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429526Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:706' at master log binlog.000002, end_log_pos 255175; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429492Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429604Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429637Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429669Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:704' at master log binlog.000002, end_log_pos 254451; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429725Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429777Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:07.429572Z 16 [Warning] Slave SQL for channel '': Worker 12 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:694' at master log binlog.000002, end_log_pos 250831; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:10.430972Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:12.429646Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:12.429646Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:692' at master log binlog.000002, end_log_pos 250107; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:12.429721Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:703' at master log binlog.000002, end_log_pos 254089; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.430921Z 21 [Warning] Slave SQL for channel '': Worker 17 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:699' at master log binlog.000002, end_log_pos 252641; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.430954Z 20 [Warning] Slave SQL for channel '': Worker 16 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:698' at master log binlog.000002, end_log_pos 252279; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431014Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:704' at master log binlog.000002, end_log_pos 254451; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431045Z 16 [Warning] Slave SQL for channel '': Worker 12 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:694' at master log binlog.000002, end_log_pos 250831; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431079Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:688' at master log binlog.000002, end_log_pos 248659; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431136Z 19 [Warning] Slave SQL for channel '': Worker 15 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:697' at master log binlog.000002, end_log_pos 251917; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431047Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:706' at master log binlog.000002, end_log_pos 255175; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.430921Z 24 [Warning] Slave SQL for channel '': Worker 20 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:702' at master log binlog.000002, end_log_pos 253727; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431015Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:705' at master log binlog.000002, end_log_pos 254813; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:14.431638Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:693' at master log binlog.000002, end_log_pos 250469; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:15.430989Z 22 [Warning] Slave SQL for channel '': Worker 18 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:700' at master log binlog.000002, end_log_pos 253003; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:15.430989Z 18 [Warning] Slave SQL for channel '': Worker 14 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:696' at master log binlog.000002, end_log_pos 251555; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:17.429948Z 23 [Warning] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:17.429948Z 17 [Warning] Slave SQL for channel '': Worker 13 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:695' at master log binlog.000002, end_log_pos 251193; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:17.430021Z 23 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 1205 2020-05-07T10:48:17.430049Z 23 [ERROR] Slave SQL for channel '': Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205 2020-05-07T10:48:19.430688Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:703' at master log binlog.000002, end_log_pos 254089; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:20.432091Z 14 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.432286Z 22 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.432473Z 4 [ERROR] Slave SQL for channel '': ... The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state. A restart should restore consistency automatically, although using non-transactional storage for data or info tables or DDL queries could lead to problems. In such cases you have to examine your data (see documentation for details). Error_code: 1756 2020-05-07T10:48:20.432532Z 20 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.432739Z 18 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.433223Z 19 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.434029Z 21 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.435335Z 17 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.435499Z 24 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.435963Z 15 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.436993Z 9 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.438118Z 10 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:20.438371Z 7 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:22.438491Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:22.438539Z 6 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 1205 2020-05-07T10:48:22.438557Z 6 [ERROR] Slave SQL for channel '': Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205 2020-05-07T10:48:22.438598Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:691' at master log binlog.000002, end_log_pos 249745; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:22.438816Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:704' at master log binlog.000002, end_log_pos 254451; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:22.438998Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:22.438999Z 16 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:48:22.439026Z 11 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 1205 2020-05-07T10:48:22.439042Z 11 [ERROR] Slave SQL for channel '': Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205 2020-05-07T10:48:22.439090Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:48:22.439116Z 5 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 1205 2020-05-07T10:48:22.439130Z 5 [ERROR] Slave SQL for channel '': Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205 mysql> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-05-07 13:25:20 0x7ffbb8522700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 1 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2168 srv_active, 0 srv_shutdown, 52 srv_idle srv_master_thread log flush and writes: 2220 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 393540 OS WAIT ARRAY INFO: signal count 281150 RW-shared spins 0, rounds 1142, OS waits 370 RW-excl spins 0, rounds 28850, OS waits 857 RW-sx spins 42, rounds 1167, OS waits 33 Spin rounds per wait: 1142.00 RW-shared, 28850.00 RW-excl, 27.79 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 2085657 Purge done for trx's n:o < 2085657 undo n:o < 0 state: running but idle History list length 41 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422194408605104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422194408585040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422194408585952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 61631, ACTIVE (PREPARED) 2218 sec 7 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 1 MySQL thread id 8, OS thread handle 140719363684096, query id 1884 Waiting for preceding transaction to commit ---TRANSACTION 59252, ACTIVE 2220 sec 2 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 11, OS thread handle 140719362873088, query id 1874 Waiting for preceding transaction to commit ---TRANSACTION 54282, ACTIVE 2225 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 23, OS thread handle 140719106721536, query id 1812 Waiting for preceding transaction to commit -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 310 OS file reads, 24305 OS file writes, 7712 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 8747, node heap has 0 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 0 buffer(s) Hash table size 8747, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 414661946 Log flushed up to 414661946 Pages flushed up to 414661946 Last checkpoint at 414661937 0 pending log flushes, 0 pending chkp writes 5361 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 34357248 Dictionary memory allocated 128880 Buffer pool size 2047 Free buffers 1520 Database pages 522 Old database pages 209 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 278, created 244, written 18864 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 522, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=20189, Main thread ID=140719167633152, state: sleeping Number of rows inserted 24, updated 1042085, deleted 1, read 1042096 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.09 sec) mysql> show processlist; +----+-------------+-----------------+------+------------------+------+---------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------------+------+------------------+------+---------------------------------------------------------------+------------------+ | 3 | system user | | NULL | Connect | 2313 | Waiting for master to send event | NULL | | 4 | system user | | NULL | Connect | 2254 | Waiting for workers to exit | NULL | | 8 | system user | | NULL | Connect | 2277 | Waiting for preceding transaction to commit | NULL | | 11 | system user | | NULL | Connect | 2277 | Waiting for preceding transaction to commit | NULL | | 23 | system user | | NULL | Connect | 2277 | Waiting for preceding transaction to commit | NULL | | 26 | root | localhost:33728 | NULL | Binlog Dump GTID | 2312 | Master has sent all binlog to slave; waiting for more updates | NULL | | 27 | root | localhost:33732 | NULL | Binlog Dump GTID | 2312 | Master has sent all binlog to slave; waiting for more updates | NULL | | 29 | root | localhost:33980 | test | Query | 0 | starting | show processlist | +----+-------------+-----------------+------+------------------+------+---------------------------------------------------------------+------------------+ 8 rows in set (0.00 sec) mysql> select * from performance_schema.replication_applier_status; +--------------+---------------+-----------------+----------------------------+ | CHANNEL_NAME | SERVICE_STATE | REMAINING_DELAY | COUNT_TRANSACTIONS_RETRIES | +--------------+---------------+-----------------+----------------------------+ | | ON | NULL | 217 | +--------------+---------------+-----------------+----------------------------+ 1 row in set (0.00 sec) mysql> select * from performance_schema.replication_applier_status_by_worker; +--------------+-----------+-----------+---------------+------------------------------------------+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+ | CHANNEL_NAME | WORKER_ID | THREAD_ID | SERVICE_STATE | LAST_SEEN_TRANSACTION | LAST_ERROR_NUMBER | LAST_ERROR_MESSAGE | LAST_ERROR_TIMESTAMP | +--------------+-----------+-----------+---------------+------------------------------------------+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+ | | 1 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:689 | 1205 | Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 12:48:22 | | | 2 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:690 | 1205 | Worker 2 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:690' at master log binlog.000002, end_log_pos 249383; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 12:48:22 | | | 3 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:703 | 0 | | 0000-00-00 00:00:00 | | | 4 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:704 | 0 | | 0000-00-00 00:00:00 | | | 5 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:705 | 0 | | 0000-00-00 00:00:00 | | | 6 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:706 | 0 | | 0000-00-00 00:00:00 | | | 7 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:707 | 1205 | Worker 7 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:707' at master log binlog.000002, end_log_pos 255537; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 12:48:22 | | | 8 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:688 | 0 | | 0000-00-00 00:00:00 | | | 9 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:691 | 0 | | 0000-00-00 00:00:00 | | | 10 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:692 | 0 | | 0000-00-00 00:00:00 | | | 11 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:693 | 0 | | 0000-00-00 00:00:00 | | | 12 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:694 | 0 | | 0000-00-00 00:00:00 | | | 13 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:695 | 0 | | 0000-00-00 00:00:00 | | | 14 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:696 | 0 | | 0000-00-00 00:00:00 | | | 15 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:697 | 0 | | 0000-00-00 00:00:00 | | | 16 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:698 | 0 | | 0000-00-00 00:00:00 | | | 17 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:699 | 0 | | 0000-00-00 00:00:00 | | | 18 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:700 | 0 | | 0000-00-00 00:00:00 | | | 19 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:701 | 1205 | Worker 19 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:701' at master log binlog.000002, end_log_pos 253365; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 12:48:17 | | | 20 | NULL | OFF | fc4f82b8-904f-11ea-9f2b-000d6179f72b:702 | 0 | | 0000-00-00 00:00:00 | +--------------+-----------+-----------+---------------+------------------------------------------+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+ 20 rows in set (0.00 sec) mysql> select trx_id,trx_state,trx_started,trx_mysql_thread_id,trx_rows_modified from information_schema.innodb_trx; +--------+-----------+---------------------+---------------------+-------------------+ | trx_id | trx_state | trx_started | trx_mysql_thread_id | trx_rows_modified | +--------+-----------+---------------------+---------------------+-------------------+ | 61631 | RUNNING | 2020-05-07 12:48:22 | 8 | 1 | | 59252 | RUNNING | 2020-05-07 12:48:20 | 11 | 0 | | 54282 | RUNNING | 2020-05-07 12:48:15 | 23 | 0 | +--------+-----------+---------------------+---------------------+-------------------+ 3 rows in set (0.00 sec) mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: root Master_Port: 3333 Connect_Retry: 60 Master_Log_File: binlog.000009 Read_Master_Log_Pos: 22735242 Relay_Log_File: fc30-relay-bin.000002 Relay_Log_Pos: 248535 Relay_Master_Log_File: binlog.000002 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1205 Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any. Skip_Counter: 0 Exec_Master_Log_Pos: 248328 Relay_Log_Space: 7538995738 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 2277 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 1205 Last_SQL_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'fc4f82b8-904f-11ea-9f2b-000d6179f72b:689' at master log binlog.000002, end_log_pos 249021. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any. Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: fc4f82b8-904f-11ea-9f2b-000d6179f72b Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for workers to exit Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 200507 12:48:22 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: fc4f82b8-904f-11ea-9f2b-000d6179f72b:1-20825870 Executed_Gtid_Set: fc4f82b8-904f-11ea-9f2b-000d6179f72b:1-687 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) mysql> (gdb) thread apply all bt Thread 35 (Thread 0x7ffbb8522700 (LWP 20395)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x20acd4c ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x20acce0 , cond=0x20acd20 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x20acd20 , mutex=0x20acce0 ) at pthread_cond_wait.c:655 #3 0x0000000000e26628 in native_cond_wait (mutex=0x20acce0 , cond=0x20acd20 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #4 my_cond_wait (mp=0x20acce0 , cond=0x20acd20 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=152, that=0x20acd20 , mutex=, src_file=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #6 Per_thread_connection_handler::block_until_new_connection () at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:152 #7 0x0000000000e26928 in handle_connection (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:344 #8 0x00000000013f6034 in pfs_spawn_thread (arg=0x42dffc0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #9 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 34 (Thread 0x7ffbb8564700 (LWP 20370)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7ffbb8561e70, expected=0, futex_word=0x20ae708 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7ffbb8561e70, mutex=0x20ae680 , cond=0x20ae6e0 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x20ae6e0 , mutex=0x20ae680 , abstime=0x7ffbb8561e70) at pthread_cond_wait.c:667 #3 0x0000000000f1d8fa in native_cond_timedwait (abstime=0x7ffbb8561e70, mutex=0x20ae680 , cond=0x20ae6e0 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:136 #4 my_cond_timedwait (abstime=0x7ffbb8561e70, mp=0x20ae680 , cond=0x20ae6e0 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:189 #5 inline_mysql_cond_timedwait (src_line=8221, abstime=0x7ffbb8561e70, mutex=0x20ae680 , that=0x20ae6e0 , src_file=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1236 #6 MYSQL_BIN_LOG::wait_for_update_bin_log (this=0x20ae180 , thd=, timeout=0x7ffbb8561e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/binlog.cc:8221 #7 0x0000000000f4087e in Binlog_sender::wait_with_heartbeat (this=, log_pos=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:658 #8 Binlog_sender::wait_new_events (this=0x7ffbb8562530, log_pos=248328) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:637 #9 Binlog_sender::get_binlog_end_pos (log_cache=0x7ffbb8562370, this=0x7ffbb8562530) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:403 #10 Binlog_sender::send_binlog (this=0x7ffbb8562530, log_cache=, start_pos=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:351 #11 0x0000000000f40b07 in Binlog_sender::run (this=0x7ffbb8562530) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:232 #12 0x0000000000f3b3b2 in mysql_binlog_send (thd=, log_ident=, pos=, slave_gtid_executed=, flags=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_master.cc:421 #13 0x0000000000f3dd10 in com_binlog_dump_gtid (thd=0x7ffb30000d80, packet=0x4 , packet_length=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_master.cc:405 #14 0x0000000000d523cb in dispatch_command (thd=0x7ffb30000d80, com_data=0x7ffbb8563dc0, command=COM_BINLOG_DUMP_GTID) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1706 #15 0x0000000000d53ae4 in do_command (thd=0x7ffb30000d80) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1032 #16 0x0000000000e26a8c in handle_connection (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:313 #17 0x00000000013f6034 in pfs_spawn_thread (arg=0x42d28c0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #18 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #19 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 33 (Thread 0x7ffbb85e8700 (LWP 20337)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7ffb8c00a854) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7ffb8c00a2b0, cond=0x7ffb8c00a828) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7ffb8c00a828, mutex=0x7ffb8c00a2b0) at pthread_cond_wait.c:655 #3 0x0000000000f6b196 in native_cond_wait (mutex=0x7ffb8c00a2b0, cond=0x7ffb8c00a828) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #4 my_cond_wait (mp=0x7ffb8c00a2b0, cond=0x7ffb8c00a828) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=100, src_file=0x175ebe0 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc", mutex=0x7ffb8c00a2b0, that=0x7ffb8c00a828) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #6 Commit_order_manager::wait_for_its_turn (this=0x7ffb8c00a2b0, worker=0x7ffb8c750fb0, all=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc:100 #7 0x0000000000f6b330 in Commit_order_manager::report_rollback (this=0x7ffb8c00a2b0, worker=0x7ffb8c750fb0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc:150 #8 0x0000000000f6885f in Slave_worker::slave_worker_ends_group (this=0x7ffb8c750fb0, ev=, error=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:1243 #9 0x0000000000f68fdd in slave_worker_exec_job_group (worker=0x7ffb8c750fb0, rli=0x42a7e90) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:2744 #10 0x0000000000f5430b in handle_slave_worker (arg=0x7ffb8c750fb0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:6239 #11 0x00000000013f6034 in pfs_spawn_thread (arg=0x7ffb8c754c60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #12 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #13 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 32 (Thread 0x7ffbc7a31700 (LWP 20325)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7ffb8c00a4f4) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7ffb8c00a2b0, cond=0x7ffb8c00a4c8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7ffb8c00a4c8, mutex=0x7ffb8c00a2b0) at pthread_cond_wait.c:655 #3 0x0000000000f6b196 in native_cond_wait (mutex=0x7ffb8c00a2b0, cond=0x7ffb8c00a4c8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #4 my_cond_wait (mp=0x7ffb8c00a2b0, cond=0x7ffb8c00a4c8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=100, src_file=0x175ebe0 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc", mutex=0x7ffb8c00a2b0, that=0x7ffb8c00a4c8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #6 Commit_order_manager::wait_for_its_turn (this=0x7ffb8c00a2b0, worker=0x7ffb8c28d210, all=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc:100 #7 0x0000000000f6b330 in Commit_order_manager::report_rollback (this=0x7ffb8c00a2b0, worker=0x7ffb8c28d210) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc:150 #8 0x0000000000f6885f in Slave_worker::slave_worker_ends_group (this=0x7ffb8c28d210, ev=, error=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:1243 #9 0x0000000000f68fdd in slave_worker_exec_job_group (worker=0x7ffb8c28d210, rli=0x42a7e90) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:2744 #10 0x0000000000f5430b in handle_slave_worker (arg=0x7ffb8c28d210) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:6239 #11 0x00000000013f6034 in pfs_spawn_thread (arg=0x7ffb8c290ec0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #12 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #13 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 31 (Thread 0x7ffbc7af7700 (LWP 20322)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7ffb8c00a418) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7ffb8c00a2b0, cond=0x7ffb8c00a3f0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7ffb8c00a3f0, mutex=0x7ffb8c00a2b0) at pthread_cond_wait.c:655 #3 0x0000000000f6b196 in native_cond_wait (mutex=0x7ffb8c00a2b0, cond=0x7ffb8c00a3f0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #4 my_cond_wait (mp=0x7ffb8c00a2b0, cond=0x7ffb8c00a3f0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=100, src_file=0x175ebe0 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc", mutex=0x7ffb8c00a2b0, that=0x7ffb8c00a3f0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #6 Commit_order_manager::wait_for_its_turn (this=0x7ffb8c00a2b0, worker=0x7ffb8c158a80, all=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave_commit_order_manager.cc:100 #7 0x0000000000f2c82d in MYSQL_BIN_LOG::ordered_commit (this=0x20ae180 , thd=0x7ffb7c000b60, all=true, skip_commit=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/binlog.cc:9581 #8 0x0000000000f2d01d in MYSQL_BIN_LOG::commit (this=0x20ae180 , thd=0x7ffb7c000b60, all=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/binlog.cc:8868 #9 0x0000000000857b88 in ha_commit_trans (thd=0x7ffb7c000b60, all=true, ignore_global_read_lock=false) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/handler.cc:1806 #10 0x0000000000e097d9 in trans_commit (thd=0x7ffb7c000b60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/transaction.cc:246 #11 0x0000000000f006c2 in Xid_log_event::do_commit (this=0x7ffb8c4f58e0, thd_arg=0x7ffb7c000b60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/log_event.cc:7138 #12 0x0000000000f005c3 in Xid_apply_log_event::do_apply_event_worker (this=0x7ffb8c4f5928, w=0x7ffb8c158a80) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/log_event.cc:7233 #13 0x0000000000f6654e in Slave_worker::read_and_apply_events (this=0x7ffb8c158a80, start_relay_number=, start_relay_pos=254327, end_relay_number=2, end_relay_pos=254658) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:2087 #14 0x0000000000f66a39 in Slave_worker::retry_transaction (this=0x7ffb8c158a80, start_relay_number=2, start_relay_pos=254327, end_relay_number=2, end_relay_pos=254658) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:1932 #15 0x0000000000f68e89 in slave_worker_exec_job_group (worker=0x7ffb8c158a80, rli=0x42a7e90) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_rli_pdb.cc:2682 #16 0x0000000000f5430b in handle_slave_worker (arg=0x7ffb8c158a80) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:6239 #17 0x00000000013f6034 in pfs_spawn_thread (arg=0x7ffb8c15c730) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #18 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #19 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 30 (Thread 0x7ffbd00fe700 (LWP 20317)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7ffb8c15bd84) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7ffb8c15bd28, cond=0x7ffb8c15bd58) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7ffb8c15bd58, mutex=0x7ffb8c15bd28) at pthread_cond_wait.c:655 #3 0x0000000000f4a546 in native_cond_wait (mutex=0x7ffb8c15bd28, cond=0x7ffb8c15bd58) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #4 my_cond_wait (mp=0x7ffb8c15bd28, cond=0x7ffb8c15bd58) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=7132, mutex=0x7ffb8c15bd28, that=0x7ffb8c15bd58, src_file=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #6 slave_stop_workers (rli=0x42a7e90, mts_inited=0x7ffbd00fde8f) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:7132 #7 0x0000000000f55e5c in handle_slave_sql (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:7574 #8 0x00000000013f6034 in pfs_spawn_thread (arg=0x7ffb94033c00) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #9 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 29 (Thread 0x7ffbd0140700 (LWP 20316)): #0 0x00007ffbd911d6c7 in __GI___poll (fds=0x7ffbd013f8d0, nfds=1, timeout=300000) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x000000000145c1cf in vio_io_wait (vio=, event=, timeout=300000) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:797 #2 0x000000000145c2c3 in vio_socket_io_wait (vio=, event=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:88 #3 0x000000000145c8f8 in vio_read (vio=0x7ffb88010e30, buf=0x7ffb88011050 "B", size=16384) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:143 #4 0x000000000145c9a2 in vio_read_buff (vio=0x7ffb88010e30, buf=0x7ffb88015080 "", size=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/vio/viosocket.c:177 #5 0x0000000000ca2b23 in net_read_raw_loop (net=0x7ffb8800e300, count=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:694 #6 0x0000000000ca34e8 in net_read_packet_header (net=0x7ffb8800e300) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:784 #7 net_read_packet (net=0x7ffb8800e300, complen=0x7ffbd013fa98) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:844 #8 0x0000000000ca366c in my_net_read (net=0x7ffb8800e300) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/net_serv.cc:921 #9 0x0000000000e1d2bf in cli_safe_read_with_ok (mysql=0x7ffb8800e300, parse_ok=0 '\000', is_data_packet=0x0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql-common/client.c:1050 #10 0x0000000000f58107 in read_event (suppress_warnings=0x7ffbd013fe8f, mi=0x425b420, mysql=0x7ffb8800e300) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:4519 #11 handle_slave_io (arg=0x425b420) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_slave.cc:5806 #12 0x00000000013f6034 in pfs_spawn_thread (arg=0x42f0580) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #13 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #14 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 28 (Thread 0x7ffbd01a7700 (LWP 20315)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7ffbd01a4e70, expected=0, futex_word=0x20ae708 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7ffbd01a4e70, mutex=0x20ae680 , cond=0x20ae6e0 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x20ae6e0 , mutex=0x20ae680 , abstime=0x7ffbd01a4e70) at pthread_cond_wait.c:667 #3 0x0000000000f1d8fa in native_cond_timedwait (abstime=0x7ffbd01a4e70, mutex=0x20ae680 , cond=0x20ae6e0 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:136 #4 my_cond_timedwait (abstime=0x7ffbd01a4e70, mp=0x20ae680 , cond=0x20ae6e0 ) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:189 #5 inline_mysql_cond_timedwait (src_line=8221, abstime=0x7ffbd01a4e70, mutex=0x20ae680 , that=0x20ae6e0 , src_file=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1236 #6 MYSQL_BIN_LOG::wait_for_update_bin_log (this=0x20ae180 , thd=, timeout=0x7ffbd01a4e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/binlog.cc:8221 #7 0x0000000000f4087e in Binlog_sender::wait_with_heartbeat (this=, log_pos=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:658 #8 Binlog_sender::wait_new_events (this=0x7ffbd01a5530, log_pos=248328) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:637 #9 Binlog_sender::get_binlog_end_pos (log_cache=0x7ffbd01a5370, this=0x7ffbd01a5530) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:403 #10 Binlog_sender::send_binlog (this=0x7ffbd01a5530, log_cache=, start_pos=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:351 #11 0x0000000000f40b07 in Binlog_sender::run (this=0x7ffbd01a5530) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_binlog_sender.cc:232 #12 0x0000000000f3b3b2 in mysql_binlog_send (thd=, log_ident=, pos=, slave_gtid_executed=, flags=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_master.cc:421 #13 0x0000000000f3dd10 in com_binlog_dump_gtid (thd=0x7ffb94000d80, packet=0x4 , packet_length=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_master.cc:405 #14 0x0000000000d523cb in dispatch_command (thd=0x7ffb94000d80, com_data=0x7ffbd01a6dc0, command=COM_BINLOG_DUMP_GTID) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1706 #15 0x0000000000d53ae4 in do_command (thd=0x7ffb94000d80) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/sql_parse.cc:1032 #16 0x0000000000e26a8c in handle_connection (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_handler_per_thread.cc:313 #17 0x00000000013f6034 in pfs_spawn_thread (arg=0x42f0580) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #18 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #19 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 27 (Thread 0x7ffba6ffd700 (LWP 20263)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x207a8a8 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x207a840 , cond=0x207a880 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x207a880 , mutex=0x207a840 ) at pthread_cond_wait.c:655 #3 0x0000000000ef9e35 in native_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:147 #4 my_cond_wait (mp=, cond=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=885, src_file=0x17524a0 "/export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_gtid_persist.cc", mutex=, that=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/include/mysql/psi/mysql_thread.h:1191 #6 compress_gtid_table (p_thd=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/rpl_gtid_persist.cc:885 #7 0x00000000013f6034 in pfs_spawn_thread (arg=0x42d27d0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 26 (Thread 0x7ffbd01e9700 (LWP 20262)): #0 0x00007ffbd9064c22 in __GI___sigtimedwait (set=set@entry=0x7ffbd01e8db0, info=info@entry=0x7ffbd01e8cf0, timeout=timeout@entry=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x00007ffbd95997ac in __sigwait (set=0x7ffbd01e8db0, sig=0x7ffbd01e8e8c) at ../sysdeps/unix/sysv/linux/sigwait.c:28 #2 0x00000000007f7a2b in signal_hand (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/mysqld.cc:2132 #3 0x00000000013f6034 in pfs_spawn_thread (arg=0x429c8b0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #4 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #5 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 25 (Thread 0x7ffba77fe700 (LWP 20247)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c6c668) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c6c618, cond=0x3c6c640) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c6c640, mutex=0x3c6c618) at pthread_cond_wait.c:655 #3 0x000000000119823b in os_event::wait (this=0x3c6c608) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c6c608, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #5 0x00000000012c87dc in buf_resize_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0buf.cc:3027 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 24 (Thread 0x7ffba7fff700 (LWP 20246)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ffba7ffe8a0, expected=0, futex_word=0x419b298) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ffba7ffeae0, mutex=0x419b248, cond=0x419b270) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x419b270, mutex=0x419b248, abstime=0x7ffba7ffeae0) at pthread_cond_wait.c:667 #3 0x0000000001198a0e in os_event::timed_wait (this=, abstime=0x7ffba7ffeae0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #4 0x0000000001198cf6 in os_event::wait_time_low (this=0x419b238, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #5 0x0000000001284ba4 in ib_wqueue_timedwait (wq=0x4190038, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/ut/ut0wqueue.cc:168 #6 0x0000000001364712 in fts_optimize_thread (arg=0x4190038) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fts/fts0opt.cc:2910 #7 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 23 (Thread 0x7ffbb8ff9700 (LWP 20245)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ffbb8ff8bc0, expected=0, futex_word=0x414f158) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ffbb8ff8e00, mutex=0x414f108, cond=0x414f130) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x414f130, mutex=0x414f108, abstime=0x7ffbb8ff8e00) at pthread_cond_wait.c:667 #3 0x0000000001198a0e in os_event::timed_wait (this=, abstime=0x7ffbb8ff8e00) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #4 0x0000000001198cf6 in os_event::wait_time_low (this=0x414f0f8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #5 0x000000000131b7c4 in dict_stats_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/dict/dict0stats_bg.cc:435 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 22 (Thread 0x7ffbb97fa700 (LWP 20244)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c6c548) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c6c4f8, cond=0x3c6c520) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c6c520, mutex=0x3c6c4f8) at pthread_cond_wait.c:655 #3 0x000000000119823b in os_event::wait (this=0x3c6c4e8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c6c4e8, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #5 0x00000000012d232c in buf_dump_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0dump.cc:792 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 21 (Thread 0x7ffbb9ffb700 (LWP 20243)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c6c39c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c6c348, cond=0x3c6c370) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c6c370, mutex=0x3c6c348) at pthread_cond_wait.c:655 #3 0x000000000119823b in os_event::wait (this=0x3c6c338) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c6c338, reset_sig_count=2939268) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #5 0x00000000012328ee in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2527 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 20 (Thread 0x7ffbba7fc700 (LWP 20242)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c6c30c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c6c2b8, cond=0x3c6c2e0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c6c2e0, mutex=0x3c6c2b8) at pthread_cond_wait.c:655 #3 0x000000000119823b in os_event::wait (this=0x3c6c2a8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c6c2a8, reset_sig_count=3437130) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #5 0x00000000012328ee in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2527 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 19 (Thread 0x7ffbbaffd700 (LWP 20241)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c6c27c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c6c228, cond=0x3c6c250) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c6c250, mutex=0x3c6c228) at pthread_cond_wait.c:655 #3 0x000000000119823b in os_event::wait (this=0x3c6c218) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c6c218, reset_sig_count=4594053) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #5 0x00000000012328ee in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2527 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 18 (Thread 0x7ffbbb7fe700 (LWP 20240)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c6c1e8) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c6c198, cond=0x3c6c1c0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c6c1c0, mutex=0x3c6c198) at pthread_cond_wait.c:655 #3 0x000000000119823b in os_event::wait (this=0x3c6c188) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c6c188, reset_sig_count=974929) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:366 #5 0x0000000001234f5d in srv_purge_coordinator_suspend (rseg_history_len=41, slot=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2683 #6 srv_purge_coordinator_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2799 #7 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 17 (Thread 0x7ffbbbfff700 (LWP 20239)): #0 0x00007ffbd95990b5 in __GI___nanosleep (requested_time=0x7ffbbbffee60, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:28 #1 0x00000000011991b0 in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0thread.cc:287 #2 0x0000000001233607 in srv_master_sleep () at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2337 #3 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:2384 #4 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #5 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 16 (Thread 0x7ffbc0f26700 (LWP 20238)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ffbc0f25c20, expected=0, futex_word=0x3c6c4b8) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ffbc0f25e60, mutex=0x3c6c468, cond=0x3c6c490) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x3c6c490, mutex=0x3c6c468, abstime=0x7ffbc0f25e60) at pthread_cond_wait.c:667 #3 0x0000000001198a0e in os_event::timed_wait (this=, abstime=0x7ffbc0f25e60) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #4 0x0000000001198cf6 in os_event::wait_time_low (this=0x3c6c458, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #5 0x0000000001232ff5 in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:1592 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 15 (Thread 0x7ffbc1727700 (LWP 20237)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ffbc17268b0, expected=0, futex_word=0x3c6c428) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ffbc1726af0, mutex=0x3c6c3d8, cond=0x3c6c400) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x3c6c400, mutex=0x3c6c3d8, abstime=0x7ffbc1726af0) at pthread_cond_wait.c:667 #3 0x0000000001198a0e in os_event::timed_wait (this=, abstime=0x7ffbc1726af0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #4 0x0000000001198cf6 in os_event::wait_time_low (this=0x3c6c3c8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #5 0x0000000001233ec5 in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0srv.cc:1758 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 14 (Thread 0x7ffbc1f28700 (LWP 20236)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ffbc1f27ba0, expected=0, futex_word=0x410e01c) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ffbc1f27de0, mutex=0x410dfc8, cond=0x410dff0) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x410dff0, mutex=0x410dfc8, abstime=0x7ffbc1f27de0) at pthread_cond_wait.c:667 #3 0x0000000001198a0e in os_event::timed_wait (this=, abstime=0x7ffbc1f27de0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #4 0x0000000001198cf6 in os_event::wait_time_low (this=0x410dfb8, time_in_usec=, reset_sig_count=283) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #5 0x000000000116f624 in lock_wait_timeout_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/lock/lock0wait.cc:497 #6 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 13 (Thread 0x7ffbc292e700 (LWP 20206)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ffbc292d790, expected=0, futex_word=0x3c6c5dc) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ffbc292d9d0, mutex=0x3c6c588, cond=0x3c6c5b0) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x3c6c5b0, mutex=0x3c6c588, abstime=0x7ffbc292d9d0) at pthread_cond_wait.c:667 #3 0x0000000001198a0e in os_event::timed_wait (this=, abstime=0x7ffbc292d9d0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:316 #4 0x0000000001198cf6 in os_event::wait_time_low (this=0x3c6c578, time_in_usec=, reset_sig_count=2) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0event.cc:488 #5 0x00000000012d8a4c in pc_sleep_if_needed (sig_count=2, next_loop_time=22834304) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0flu.cc:2700 #6 buf_flush_page_cleaner_coordinator (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/buf/buf0flu.cc:3201 #7 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 12 (Thread 0x7ffbc312f700 (LWP 20205)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd02b2000, min_nr=1, nr=256, events=0x3f56f90, timeout=0x7ffbc312eb50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc312edf0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc312edf0, m1=0x7ffbc312eea8, m2=0x7ffbc312eea0, request=0x7ffbc312ee70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc312ee70, m2=0x7ffbc312eea0, m1=0x7ffbc312eea8, global_segment=9) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=9, m1=0x7ffbc312eea8, m2=0x7ffbc312eea0, request=0x7ffbc312ee70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=9) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 11 (Thread 0x7ffbc3930700 (LWP 20204)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd02b7000, min_nr=1, nr=256, events=0x3f54f90, timeout=0x7ffbc392fb50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc392fdf0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc392fdf0, m1=0x7ffbc392fea8, m2=0x7ffbc392fea0, request=0x7ffbc392fe70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc392fe70, m2=0x7ffbc392fea0, m1=0x7ffbc392fea8, global_segment=8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=8, m1=0x7ffbc392fea8, m2=0x7ffbc392fea0, request=0x7ffbc392fe70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=8) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 10 (Thread 0x7ffbc4131700 (LWP 20203)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd02bc000, min_nr=1, nr=256, events=0x3f52f90, timeout=0x7ffbc4130b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc4130df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc4130df0, m1=0x7ffbc4130ea8, m2=0x7ffbc4130ea0, request=0x7ffbc4130e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc4130e70, m2=0x7ffbc4130ea0, m1=0x7ffbc4130ea8, global_segment=7) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=7, m1=0x7ffbc4130ea8, m2=0x7ffbc4130ea0, request=0x7ffbc4130e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=7) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7ffbc4932700 (LWP 20202)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd02c1000, min_nr=1, nr=256, events=0x3f50f90, timeout=0x7ffbc4931b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc4931df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc4931df0, m1=0x7ffbc4931ea8, m2=0x7ffbc4931ea0, request=0x7ffbc4931e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc4931e70, m2=0x7ffbc4931ea0, m1=0x7ffbc4931ea8, global_segment=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=6, m1=0x7ffbc4931ea8, m2=0x7ffbc4931ea0, request=0x7ffbc4931e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=6) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7ffbc5133700 (LWP 20201)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd95b6000, min_nr=1, nr=256, events=0x3f2a6f0, timeout=0x7ffbc5132b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc5132df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc5132df0, m1=0x7ffbc5132ea8, m2=0x7ffbc5132ea0, request=0x7ffbc5132e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc5132e70, m2=0x7ffbc5132ea0, m1=0x7ffbc5132ea8, global_segment=5) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=5, m1=0x7ffbc5132ea8, m2=0x7ffbc5132ea0, request=0x7ffbc5132e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 7 (Thread 0x7ffbc5934700 (LWP 20200)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd95bb000, min_nr=1, nr=256, events=0x3f286f0, timeout=0x7ffbc5933b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc5933df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc5933df0, m1=0x7ffbc5933ea8, m2=0x7ffbc5933ea0, request=0x7ffbc5933e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc5933e70, m2=0x7ffbc5933ea0, m1=0x7ffbc5933ea8, global_segment=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=4, m1=0x7ffbc5933ea8, m2=0x7ffbc5933ea0, request=0x7ffbc5933e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7ffbc6135700 (LWP 20199)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd95c0000, min_nr=1, nr=256, events=0x3f266f0, timeout=0x7ffbc6134b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc6134df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc6134df0, m1=0x7ffbc6134ea8, m2=0x7ffbc6134ea0, request=0x7ffbc6134e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc6134e70, m2=0x7ffbc6134ea0, m1=0x7ffbc6134ea8, global_segment=3) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=3, m1=0x7ffbc6134ea8, m2=0x7ffbc6134ea0, request=0x7ffbc6134e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7ffbc6936700 (LWP 20198)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd95c5000, min_nr=1, nr=256, events=0x3f246f0, timeout=0x7ffbc6935b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc6935df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc6935df0, m1=0x7ffbc6935ea8, m2=0x7ffbc6935ea0, request=0x7ffbc6935e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc6935e70, m2=0x7ffbc6935ea0, m1=0x7ffbc6935ea8, global_segment=2) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=2, m1=0x7ffbc6935ea8, m2=0x7ffbc6935ea0, request=0x7ffbc6935e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7ffbc7137700 (LWP 20197)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd95ac000, min_nr=1, nr=256, events=0x3f4ecc0, timeout=0x7ffbc7136b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc7136df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc7136df0, m1=0x7ffbc7136ea8, m2=0x7ffbc7136ea0, request=0x7ffbc7136e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc7136e70, m2=0x7ffbc7136ea0, m1=0x7ffbc7136ea8, global_segment=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=1, m1=0x7ffbc7136ea8, m2=0x7ffbc7136ea0, request=0x7ffbc7136e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7ffbc7938700 (LWP 20196)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ffbd957d157 in __io_getevents_0_4 (ctx=0x7ffbd95b1000, min_nr=1, nr=256, events=0x3f3c9e0, timeout=0x7ffbc7937b50) at io_getevents.c:25 #2 0x00000000011913f4 in LinuxAIOHandler::collect (this=0x7ffbc7937df0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2519 #3 0x0000000001193634 in LinuxAIOHandler::poll (this=0x7ffbc7937df0, m1=0x7ffbc7937ea8, m2=0x7ffbc7937ea0, request=0x7ffbc7937e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2679 #4 0x00000000011939ec in os_aio_linux_handler (request=0x7ffbc7937e70, m2=0x7ffbc7937ea0, m1=0x7ffbc7937ea8, global_segment=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:2735 #5 os_aio_handler (segment=0, m1=0x7ffbc7937ea8, m2=0x7ffbc7937ea0, request=0x7ffbc7937e70) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/os/os0file.cc:6281 #6 0x0000000001330cfd in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001236000 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/innobase/srv/srv0start.cc:319 #8 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7ffbd1468700 (LWP 20195)): #0 0x00007ffbd9064c22 in __GI___sigtimedwait (set=0x7ffbd1467e20, info=0x7ffbd1467da0, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x0000000000f912fb in timer_notify_thread_func (arg=) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/mysys/posix_timers.c:89 #2 0x00000000013f6034 in pfs_spawn_thread (arg=0x3c02530) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/storage/perfschema/pfs.cc:2197 #3 0x00007ffbd958f4c0 in start_thread (arg=) at pthread_create.c:479 #4 0x00007ffbd9128133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7ffbd9027740 (LWP 20189)): #0 0x00007ffbd911d6c7 in __GI___poll (fds=0x41db9e0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x0000000000e27df9 in Mysqld_socket_listener::listen_for_connection_event (this=0x41db980) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/socket_connection.cc:859 #2 0x00000000007fcf04 in Connection_acceptor::connection_event_loop (this=0x41db140) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/conn_handler/connection_acceptor.h:73 #3 mysqld_main (argc=41, argv=0x3ad9d28) at /export/home/pb2/build/sb_0-38465026-1584987238.22/mysql-5.7.30/sql/mysqld.cc:5128 #4 0x00007ffbd904ff43 in __libc_start_main (main=0x7f2770 , argc=10, argv=0x7ffc742363a8, init=, fini=, rtld_fini=, stack_end=0x7ffc74236398) at ../csu/libc-start.c:308 #5 0x00000000007f26a9 in _start () (gdb)