2020-05-07T12:32:41.059559Z 0 [System] [MY-010116] [Server] /home/anon/mysql/release/mysql-commercial-8.0.20-linux-x86_64-minimal/bin/mysqld (mysqld 8.0.20-commercial) starting as process 4709 2020-05-07T12:32:41.066180Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2020-05-07T12:32:41.066364Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2020-05-07T12:32:41.067826Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2020-05-07T12:32:41.067884Z 1 [Note] [MY-013547] [InnoDB] Atomic write disabled 2020-05-07T12:32:41.067934Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2020-05-07T12:32:41.067975Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins 2020-05-07T12:32:41.068012Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2020-05-07T12:32:41.068057Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2020-05-07T12:32:41.068098Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11 2020-05-07T12:32:41.071317Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2020-05-07T12:32:41.071619Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions 2020-05-07T12:32:41.072157Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2020-05-07T12:32:41.072320Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2020-05-07T12:32:41.077480Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files. 2020-05-07T12:32:41.079471Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 32.000000M, instances = 1, chunk size =32.000000M 2020-05-07T12:32:41.084015Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2020-05-07T12:32:41.084973Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-05-07T12:32:41.153404Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 17253908, whereas checkpoint_lsn = 17253958 2020-05-07T12:32:41.159536Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2020-05-07T12:32:41.159869Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2020-05-07T12:32:41.159963Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2020-05-07T12:32:41.160558Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2020-05-07T12:32:41.161486Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2020-05-07T12:32:41.165682Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2020-05-07T12:32:41.165774Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1243 2020-05-07T12:32:41.386605Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2020-05-07T12:32:41.387011Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-05-07T12:32:41.617487Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2020-05-07T12:32:41.617896Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2020-05-07T12:32:41.959789Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2020-05-07T12:32:41.962222Z 1 [Note] [MY-012976] [InnoDB] 8.0.20 started; log sequence number 17253958 2020-05-07T12:32:41.963422Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2020-05-07T12:32:41.979046Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80017'. 2020-05-07T12:32:42.141445Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2020-05-07T12:32:42.142743Z 1 [Note] [MY-012356] [InnoDB] Validated 6/6 tablespaces 2020-05-07T12:32:42.171026Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80017'. 2020-05-07T12:32:42.179312Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2020-05-07T12:32:42.179832Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060' 2020-05-07T12:32:42.179972Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysqlx.sock'' 2020-05-07T12:32:42.180119Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysqlx.sock' bind-address: '::' port: 33060 2020-05-07T12:32:42.295604Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege. 2020-05-07T12:32:42.322390Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2020-05-07T12:32:42.322873Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2020-05-07T12:32:42.323210Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /home/anon/rpl/intermediate/data/ib_buffer_pool 2020-05-07T12:32:42.331838Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2020-05-07T12:32:42.340704Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 200507 14:32:42 2020-05-07T12:32:42.471174Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-05-07T12:32:42.471619Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-05-07T12:32:42.473603Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2020-05-07T12:32:42.474055Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2020-05-07T12:32:42.474478Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2020-05-07T12:32:42.475224Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3334 2020-05-07T12:32:42.475665Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2020-05-07T12:32:42.476064Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2020-05-07T12:32:42.476462Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2020-05-07T12:32:42.543272Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''. 2020-05-07T12:32:42.551881Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5 2020-05-07T12:32:42.552635Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2020-05-07T12:32:42.553361Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2020-05-07T12:32:42.553561Z 0 [System] [MY-010931] [Server] /home/anon/mysql/release/mysql-commercial-8.0.20-linux-x86_64-minimal/bin/mysqld: ready for connections. Version: '8.0.20-commercial' socket: '/home/anon/rpl/intermediate/sock' port: 3334 MySQL Enterprise Server - Commercial. 2020-05-07T12:32:45.842632Z 8 [Warning] [MY-010604] [Repl] 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-07T12:32:45.864106Z 8 [System] [MY-010597] [Repl] '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-07T12:32:45.887519Z 9 [Warning] [MY-010897] [Repl] 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-07T12:32:45.888437Z 9 [System] [MY-010562] [Repl] 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-07T12:32:45.946750Z 10 [Note] [MY-010581] [Repl] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './fc30-relay-bin.000001' position: 4 2020-05-07T12:32:47.076797Z 32 [Note] [MY-010462] [Repl] Start binlog_dump to master_thread_id(32) slave_server(3), pos(, 4) 2020-05-07T12:32:47.249419Z 33 [Note] [MY-010462] [Repl] Start binlog_dump to master_thread_id(33) slave_server(4), pos(, 4) 2020-05-07T12:33:34.290251Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:142' at master log binlog.000002, end_log_pos 53868; 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: MY-001205 2020-05-07T12:33:34.290251Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:145' at master log binlog.000002, end_log_pos 55014; 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: MY-001205 2020-05-07T12:33:35.290335Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:144' at master log binlog.000002, end_log_pos 54632; 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: MY-001205 2020-05-07T12:33:39.294140Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:148' at master log binlog.000002, end_log_pos 56160; 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: MY-001205 2020-05-07T12:33:40.294145Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:150' at master log binlog.000002, end_log_pos 56924; 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: MY-001205 2020-05-07T12:33:49.395483Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:216' at master log binlog.000002, end_log_pos 82136; 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: MY-001205 2020-05-07T12:33:49.395498Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:218' at master log binlog.000002, end_log_pos 82900; 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: MY-001205 2020-05-07T12:33:49.395498Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:220' at master log binlog.000002, end_log_pos 83664; 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: MY-001205 2020-05-07T12:33:50.395559Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:219' at master log binlog.000002, end_log_pos 83282; 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: MY-001205 2020-05-07T12:34:10.415985Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:241' at master log binlog.000002, end_log_pos 91686; 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: MY-001205 2020-05-07T12:34:11.416284Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:238' at master log binlog.000002, end_log_pos 90540; 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: MY-001205 2020-05-07T12:34:13.416483Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:240' at master log binlog.000002, end_log_pos 91304; 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: MY-001205 2020-05-07T12:34:20.426679Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:34:20.426693Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:20.426681Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:34:20.426679Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:34:20.426758Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:34:20.426801Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:20.426817Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:20.426863Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:20.426917Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:34:21.427556Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:253' at master log binlog.000002, end_log_pos 96270; 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: MY-001205 2020-05-07T12:34:21.427559Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:34:21.427649Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:21.427713Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; 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: MY-001205 2020-05-07T12:34:21.427795Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:34:22.427751Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:34:22.427754Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:34:23.427903Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:34:23.427917Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:23.427932Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:34:23.427990Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:23.428038Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:23.428116Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:34:23.428437Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:34:23.428522Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:34:23.428599Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:25.428585Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:253' at master log binlog.000002, end_log_pos 96270; 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: MY-001205 2020-05-07T12:34:25.428591Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:25.428728Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:34:25.428851Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:34:25.428929Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; 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: MY-001205 2020-05-07T12:34:26.429571Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:34:26.429571Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:257' at master log binlog.000002, end_log_pos 97798; 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: MY-001205 2020-05-07T12:34:26.429571Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:34:27.429756Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:27.429772Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:27.429756Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:27.429800Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:27.429827Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:34:27.429756Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:34:27.429756Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:34:27.429756Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:34:27.429799Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:34:30.430223Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:253' at master log binlog.000002, end_log_pos 96270; 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: MY-001205 2020-05-07T12:34:30.430319Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:30.430400Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:34:30.430485Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:34:30.430558Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; 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: MY-001205 2020-05-07T12:34:30.431698Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:257' at master log binlog.000002, end_log_pos 97798; 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: MY-001205 2020-05-07T12:34:31.431792Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:34:31.431792Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:255' at master log binlog.000002, end_log_pos 97034; 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: MY-001205 2020-05-07T12:34:31.431792Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:34:32.431922Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:34:32.431958Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:32.431922Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:34:32.432036Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:34:32.432109Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:32.432197Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:32.432276Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:32.432348Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:34:32.432432Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:34:38.432077Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:34:38.432129Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:34:38.432079Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; 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: MY-001205 2020-05-07T12:34:38.432189Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:38.432148Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:34:38.432274Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:38.432311Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:38.432377Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:38.432391Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:38.432464Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:34:38.432470Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:34:38.432571Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:34:40.432824Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:34:42.446346Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:34:42.446346Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:34:43.432478Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:34:43.432553Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:34:45.432919Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:45.432920Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:34:45.432919Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:45.433031Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:45.432936Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:34:45.433113Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:45.433182Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:47.433621Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; 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: MY-001205 2020-05-07T12:34:47.433733Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:34:47.433814Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:34:48.433061Z 23 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; 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: MY-001205 2020-05-07T12:34:49.434405Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:34:50.433324Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:257' at master log binlog.000002, end_log_pos 97798; 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: MY-001205 2020-05-07T12:34:50.433322Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:34:50.433333Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:34:50.433425Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:34:52.433549Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:52.433569Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:52.433643Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:34:52.433547Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:52.433719Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:52.433791Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:34:52.433863Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:34:52.433935Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; 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: MY-001205 2020-05-07T12:34:52.436696Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:34:53.433712Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:34:54.434192Z 23 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; 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: MY-001205 2020-05-07T12:34:55.433757Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:34:57.434402Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; 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: MY-001205 2020-05-07T12:34:57.434508Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:257' at master log binlog.000002, end_log_pos 97798; 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: MY-001205 2020-05-07T12:34:59.434438Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:34:59.434550Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:34:59.434687Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:256' at master log binlog.000002, end_log_pos 97416; 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: MY-001205 2020-05-07T12:34:59.434774Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; 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: MY-001205 2020-05-07T12:34:59.434856Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:34:59.434935Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:34:59.435012Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:35:00.434178Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:35:00.434184Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:35:02.435150Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:35:02.435238Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:35:04.434989Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:35:04.435010Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:35:04.435070Z 17 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; 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: MY-001205 2020-05-07T12:35:04.435096Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:35:04.435136Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:257' at master log binlog.000002, end_log_pos 97798; 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: MY-001205 2020-05-07T12:35:07.435376Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:35:08.435948Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:09.435447Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:35:09.435451Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:35:09.435455Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:35:09.435455Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:35:11.436530Z 24 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 14 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:266' at master log binlog.000002, end_log_pos 101236; 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: MY-001205 2020-05-07T12:35:11.436530Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:35:11.436547Z 25 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 15 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:267' at master log binlog.000002, end_log_pos 101618; 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: MY-001205 2020-05-07T12:35:11.436592Z 23 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; 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: MY-001205 2020-05-07T12:35:11.436684Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:35:11.436764Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:11.436835Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; 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: MY-001205 2020-05-07T12:35:12.435839Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:12.435837Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:35:12.435857Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:35:14.435896Z 19 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 9 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:261' at master log binlog.000002, end_log_pos 99326; 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: MY-001205 2020-05-07T12:35:14.435970Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:14.436074Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:35:16.436503Z 28 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; 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: MY-001205 2020-05-07T12:35:16.436498Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:35:16.436548Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:35:16.436498Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:35:16.436559Z 28 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:16.436604Z 18 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 8 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:260' at master log binlog.000002, end_log_pos 98944; 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: MY-001205 2020-05-07T12:35:16.436633Z 28 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:16.436633Z 26 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; 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: MY-001205 2020-05-07T12:35:16.436676Z 26 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:16.436706Z 26 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:16.437436Z 25 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:16.437465Z 10 [ERROR] [MY-010584] [Repl] 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: MY-001756 2020-05-07T12:35:16.438983Z 24 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:16.439157Z 24 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:16.439380Z 19 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:16.439588Z 19 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:16.441113Z 18 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:16.441277Z 18 [ERROR] [MY-010584] [Repl] 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: MY-000000 2020-05-07T12:35:18.441814Z 16 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; 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: MY-001205 2020-05-07T12:35:18.441860Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; 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: MY-001205 2020-05-07T12:35:18.441879Z 16 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:18.441903Z 16 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:18.441973Z 17 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; Error 'Slave worker has stopped after at least one previous worker encountered an error when slave-preserve-commit-order was enabled. To preserve commit order, the last transaction executed by this thread has not been committed. When restarting the slave after fixing any failed threads, you should fix this worker as well.' 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: MY-003030 2020-05-07T12:35:18.442174Z 23 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; 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: MY-001205 2020-05-07T12:35:18.442289Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:35:18.442452Z 21 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 11 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:263' at master log binlog.000002, end_log_pos 100090; 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: MY-001205 2020-05-07T12:35:18.442539Z 30 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; 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: MY-001205 2020-05-07T12:35:18.442575Z 30 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:18.442597Z 30 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:18.442645Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:18.442789Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:18.442893Z 27 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; 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: MY-001205 2020-05-07T12:35:18.442927Z 27 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:18.442948Z 27 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:18.442988Z 22 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; 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: MY-001205 2020-05-07T12:35:18.443031Z 22 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:18.443052Z 22 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:18.441816Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:35:18.441820Z 20 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; 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: MY-001205 2020-05-07T12:35:18.443285Z 20 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:18.443302Z 20 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:18.443360Z 29 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; 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: MY-001205 2020-05-07T12:35:18.443388Z 29 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:18.443405Z 29 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:20.443568Z 11 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; 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: MY-001205 2020-05-07T12:35:20.443616Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:35:20.443632Z 11 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:20.443663Z 11 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:20.443712Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:35:20.443965Z 23 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; 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: MY-001205 2020-05-07T12:35:20.443568Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:20.443568Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:22.444825Z 12 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; 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: MY-001205 2020-05-07T12:35:22.444874Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:22.444893Z 12 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:22.444915Z 12 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:22.444825Z 23 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; 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: MY-001205 2020-05-07T12:35:22.444964Z 23 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:22.444992Z 23 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:22.444825Z 13 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; 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: MY-001205 2020-05-07T12:35:22.445031Z 13 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:22.445051Z 13 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:22.445190Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:24.447596Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:24.447935Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:26.448331Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:26.448331Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:28.449367Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:28.449282Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:30.450239Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:30.450543Z 14 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; 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: MY-001205 2020-05-07T12:35:30.450577Z 14 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:30.450590Z 14 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 2020-05-07T12:35:32.450668Z 15 [Warning] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; 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: MY-001205 2020-05-07T12:35:32.450712Z 15 [ERROR] [MY-010584] [Repl] 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: MY-001205 2020-05-07T12:35:32.450726Z 15 [ERROR] [MY-010584] [Repl] Slave SQL for channel '': Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; Lock wait timeout exceeded; try restarting transaction, Error_code: MY-001205 mysql> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-05-07 14:42:48 0x7fc0302da700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 29 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 284 srv_active, 0 srv_shutdown, 322 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 87885 OS WAIT ARRAY INFO: signal count 67434 RW-shared spins 291, rounds 454, OS waits 166 RW-excl spins 193, rounds 4815, OS waits 122 RW-sx spins 10, rounds 291, OS waits 7 Spin rounds per wait: 1.56 RW-shared, 24.95 RW-excl, 29.10 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 276602 Purge done for trx's n:o < 276602 undo n:o < 0 state: running but idle History list length 16 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421938838054488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421938838035832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421938838036680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421938838034984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421938838034136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 120240, ACTIVE 438 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 15, OS thread handle 140463423760128, query id 1152 Waiting for preceding transaction to commit ---TRANSACTION 118063, ACTIVE 440 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 14, OS thread handle 140463424055040, query id 1150 Waiting for preceding transaction to commit ---TRANSACTION 109463, ACTIVE 448 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 23, OS thread handle 140463421400832, query id 1130 Waiting for preceding transaction to commit ---TRANSACTION 109462, ACTIVE 448 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 13, OS thread handle 140463684675328, query id 1128 Waiting for preceding transaction to commit ---TRANSACTION 109461, ACTIVE 448 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 12, OS thread handle 140463818782464, query id 1126 Waiting for preceding transaction to commit ---TRANSACTION 107253, ACTIVE 450 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 11, OS thread handle 140463819077376, query id 1118 Waiting for preceding transaction to commit ---TRANSACTION 107252, ACTIVE 450 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 2 row lock(s) MySQL thread id 21, OS thread handle 140463421990656, query id 1116 Waiting for preceding transaction to commit INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212) ---TRANSACTION 104981, ACTIVE 452 sec 4 lock struct(s), heap size 1136, 3 row lock(s) MySQL thread id 27, OS thread handle 140463420221184, query id 1080 Waiting for preceding transaction to commit ---TRANSACTION 104978, ACTIVE 452 sec 4 lock struct(s), heap size 1136, 4 row lock(s) MySQL thread id 20, OS thread handle 140463422285568, query id 1076 Waiting for preceding transaction to commit ---TRANSACTION 104973, ACTIVE 452 sec 5 lock struct(s), heap size 1136, 5 row lock(s) MySQL thread id 30, OS thread handle 140463419336448, query id 1070 Waiting for preceding transaction to commit ---TRANSACTION 104968, ACTIVE 452 sec 6 lock struct(s), heap size 1136, 5 row lock(s) MySQL thread id 22, OS thread handle 140463421695744, query id 1066 Waiting for preceding transaction to commit ---TRANSACTION 104963, ACTIVE 452 sec 6 lock struct(s), heap size 1136, 6 row lock(s) MySQL thread id 29, OS thread handle 140463419631360, query id 1058 Waiting for preceding transaction to commit ---TRANSACTION 102883, ACTIVE 454 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28, OS thread handle 140463419926272, query id 1048 Waiting for preceding transaction to commit ---TRANSACTION 102881, ACTIVE 454 sec 1 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 26, OS thread handle 140463420516096, query id 1045 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 979 OS file reads, 233189 OS file writes, 1944 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 1 buffer(s) 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 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 76366140 Log buffer assigned up to 76366140 Log buffer completed up to 76366140 Log written up to 76366140 Log flushed up to 76366140 Added dirty pages up to 76366140 Pages flushed up to 76366140 Last checkpoint at 76366140 219830 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 34357248 Dictionary memory allocated 456195 Buffer pool size 2048 Free buffers 1024 Database pages 1017 Old database pages 355 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 30523, not young 1958 0.00 youngs/s, 0.00 non-youngs/s Pages read 958, created 516, written 13053 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: 1017, 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=4709, Main thread ID=140463457625856 , state=sleeping Number of rows inserted 1, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 550, updated 137715, deleted 224, read 142895 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.00 sec) mysql> show processlist; +----+-----------------+-----------------+------+------------------+------+---------------------------------------------------------------+-----------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------------+-----------------+------+------------------+------+---------------------------------------------------------------+-----------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 606 | Waiting on empty queue | NULL | | 9 | system user | connecting host | NULL | Connect | 603 | Waiting for master to send event | NULL | | 10 | system user | | NULL | Query | 459 | Waiting for workers to exit | NULL | | 11 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 12 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 13 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 14 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 15 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 20 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 21 | system user | | test | Connect | 559 | Waiting for preceding transaction to commit | INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212) | | 22 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 23 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 26 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 27 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 28 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 29 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 30 | system user | | NULL | Connect | 559 | Waiting for preceding transaction to commit | NULL | | 32 | root | localhost:57600 | NULL | Binlog Dump GTID | 601 | Master has sent all binlog to slave; waiting for more updates | NULL | | 33 | root | localhost:57604 | NULL | Binlog Dump GTID | 601 | Master has sent all binlog to slave; waiting for more updates | NULL | | 35 | root | localhost:57836 | test | Query | 0 | starting | show processlist | +----+-----------------+-----------------+------+------------------+------+---------------------------------------------------------------+-----------------------------------------------------------------------------------+ 20 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 | 275 | +--------------+---------------+-----------------+----------------------------+ 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_ERROR_NUMBER | LAST_ERROR_MESSAGE | LAST_ERROR_TIMESTAMP | LAST_APPLIED_TRANSACTION | LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP | LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP | APPLYING_TRANSACTION | APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP | APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP | APPLYING_TRANSACTION_START_APPLY_TIMESTAMP | LAST_APPLIED_TRANSACTION_RETRIES_COUNT | LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER | LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE | LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP | APPLYING_TRANSACTION_RETRIES_COUNT | APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER | APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE | APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP | +--------------+-----------+-----------+---------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+------------------------------------------+----------------------------------------------------+-----------------------------------------------------+------------------------------------------------+----------------------------------------------+------------------------------------------+------------------------------------------------+-------------------------------------------------+--------------------------------------------+----------------------------------------+------------------------------------------------------+--------------------------------------------------------------------+---------------------------------------------------------+------------------------------------+--------------------------------------------------+--------------------------------------------------------------------+-----------------------------------------------------+ | | 1 | NULL | OFF | 1205 | Worker 1 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:274' at master log binlog.000002, end_log_pos 104292; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:20.443659 | c9c7a123-905e-11ea-bcd6-000d6179f72b:254 | 2020-05-07 14:33:29.305456 | 2020-05-07 14:33:29.305456 | 2020-05-07 14:34:18.428079 | 2020-05-07 14:34:35.431702 | c9c7a123-905e-11ea-bcd6-000d6179f72b:274 | 2020-05-07 14:33:29.307062 | 2020-05-07 14:33:29.307062 | 2020-05-07 14:34:35.431711 | 1 | 1213 | Deadlock found when trying to get lock; try restarting transaction | 2020-05-07 14:34:34.430808 | 10 | 1213 | Deadlock found when trying to get lock; try restarting transaction | 2020-05-07 14:35:18.442578 | | | 2 | NULL | OFF | 1205 | Worker 2 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:273' at master log binlog.000002, end_log_pos 103910; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:22.444911 | c9c7a123-905e-11ea-bcd6-000d6179f72b:253 | 2020-05-07 14:33:29.305407 | 2020-05-07 14:33:29.305407 | 2020-05-07 14:34:18.424875 | 2020-05-07 14:34:34.431628 | c9c7a123-905e-11ea-bcd6-000d6179f72b:273 | 2020-05-07 14:33:29.307006 | 2020-05-07 14:33:29.307006 | 2020-05-07 14:34:34.431639 | 4 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:34:30.430265 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:20.443645 | | | 3 | NULL | OFF | 1205 | Worker 3 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:275' at master log binlog.000002, end_log_pos 104674; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:22.445048 | c9c7a123-905e-11ea-bcd6-000d6179f72b:255 | 2020-05-07 14:33:29.305755 | 2020-05-07 14:33:29.305755 | 2020-05-07 14:34:18.426773 | 2020-05-07 14:34:38.433466 | c9c7a123-905e-11ea-bcd6-000d6179f72b:275 | 2020-05-07 14:33:29.307199 | 2020-05-07 14:33:29.307199 | 2020-05-07 14:34:38.433473 | 3 | 1213 | Deadlock found when trying to get lock; try restarting transaction | 2020-05-07 14:34:35.431419 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:20.443739 | | | 4 | NULL | OFF | 1205 | Worker 4 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:276' at master log binlog.000002, end_log_pos 105056; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:30.450588 | c9c7a123-905e-11ea-bcd6-000d6179f72b:256 | 2020-05-07 14:33:29.305859 | 2020-05-07 14:33:29.305859 | 2020-05-07 14:34:18.426344 | 2020-05-07 14:35:04.435335 | c9c7a123-905e-11ea-bcd6-000d6179f72b:276 | 2020-05-07 14:33:29.307257 | 2020-05-07 14:33:29.307257 | 2020-05-07 14:35:04.435345 | 8 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:34:59.434720 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:28.449718 | | | 5 | NULL | OFF | 1205 | Worker 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:32.450723 | c9c7a123-905e-11ea-bcd6-000d6179f72b:257 | 2020-05-07 14:33:29.305889 | 2020-05-07 14:33:29.305889 | 2020-05-07 14:34:18.426365 | 2020-05-07 14:35:09.436507 | c9c7a123-905e-11ea-bcd6-000d6179f72b:277 | 2020-05-07 14:33:29.307317 | 2020-05-07 14:33:29.307317 | 2020-05-07 14:35:09.437136 | 8 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:04.435170 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:30.450289 | | | 6 | NULL | OFF | 1205 | Worker 6 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:258' at master log binlog.000002, end_log_pos 98180; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.441898 | c9c7a123-905e-11ea-bcd6-000d6179f72b:240 | 2020-05-07 14:33:29.303489 | 2020-05-07 14:33:29.303489 | 2020-05-07 14:34:06.408131 | 2020-05-07 14:34:16.417130 | c9c7a123-905e-11ea-bcd6-000d6179f72b:258 | 2020-05-07 14:33:29.305914 | 2020-05-07 14:33:29.305914 | 2020-05-07 14:34:18.426936 | 3 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:34:13.416531 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:16.436587 | | | 7 | NULL | OFF | 3030 | Worker 7 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:259' at master log binlog.000002, end_log_pos 98562; Error 'Slave worker has stopped after at least one previous worker encountered an error when slave-preserve-commit-order was enabled. To preserve commit order, the last transaction executed by this thread has not been committed. When restarting the slave after fixing any failed threads, you should fix this worker as well.' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)' | 2020-05-07 14:35:18.441967 | c9c7a123-905e-11ea-bcd6-000d6179f72b:241 | 2020-05-07 14:33:29.303522 | 2020-05-07 14:33:29.303522 | 2020-05-07 14:34:06.407812 | 2020-05-07 14:34:18.418359 | c9c7a123-905e-11ea-bcd6-000d6179f72b:259 | 2020-05-07 14:33:29.305961 | 2020-05-07 14:33:29.305961 | 2020-05-07 14:34:18.426427 | 3 | 1213 | Deadlock found when trying to get lock; try restarting transaction | 2020-05-07 14:34:15.417393 | 10 | 1213 | Deadlock found when trying to get lock; try restarting transaction | 2020-05-07 14:35:16.440292 | | | 8 | NULL | OFF | 0 | | 0000-00-00 00:00:00.000000 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:260 | 2020-05-07 14:33:29.305993 | 2020-05-07 14:33:29.305993 | 2020-05-07 14:34:18.426480 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:16.436645 | | | 9 | NULL | OFF | 0 | | 0000-00-00 00:00:00.000000 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:261 | 2020-05-07 14:33:29.306108 | 2020-05-07 14:33:29.306108 | 2020-05-07 14:34:18.426488 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:14.435941 | | | 10 | NULL | OFF | 1205 | Worker 10 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:262' at master log binlog.000002, end_log_pos 99708; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.443299 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:262 | 2020-05-07 14:33:29.306276 | 2020-05-07 14:33:29.306276 | 2020-05-07 14:34:18.426781 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:14.436114 | | | 11 | NULL | OFF | 0 | | 0000-00-00 00:00:00.000000 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:263 | 2020-05-07 14:33:29.306297 | 2020-05-07 14:33:29.306297 | 2020-05-07 14:34:18.427023 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.442482 | | | 12 | NULL | OFF | 1205 | Worker 12 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:264' at master log binlog.000002, end_log_pos 100472; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.443048 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:264 | 2020-05-07 14:33:29.306362 | 2020-05-07 14:33:29.306362 | 2020-05-07 14:34:18.427290 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:11.436712 | | | 13 | NULL | OFF | 1205 | Worker 13 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:265' at master log binlog.000002, end_log_pos 100854; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:22.444988 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:265 | 2020-05-07 14:33:29.306430 | 2020-05-07 14:33:29.306430 | 2020-05-07 14:34:18.427655 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:20.443994 | | | 14 | NULL | OFF | 0 | | 0000-00-00 00:00:00.000000 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:266 | 2020-05-07 14:33:29.306471 | 2020-05-07 14:33:29.306471 | 2020-05-07 14:34:18.426602 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:11.436589 | | | 15 | NULL | OFF | 0 | | 0000-00-00 00:00:00.000000 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:267 | 2020-05-07 14:33:29.306519 | 2020-05-07 14:33:29.306519 | 2020-05-07 14:34:18.427434 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:11.436605 | | | 16 | NULL | OFF | 1205 | Worker 16 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:268' at master log binlog.000002, end_log_pos 102000; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:16.436695 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:268 | 2020-05-07 14:33:29.306555 | 2020-05-07 14:33:29.306555 | 2020-05-07 14:34:18.426658 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:09.435504 | | | 17 | NULL | OFF | 1205 | Worker 17 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:269' at master log binlog.000002, end_log_pos 102382; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.442944 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:269 | 2020-05-07 14:33:29.306591 | 2020-05-07 14:33:29.306591 | 2020-05-07 14:34:18.427090 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1213 | Deadlock found when trying to get lock; try restarting transaction | 2020-05-07 14:35:16.438772 | | | 18 | NULL | OFF | 1205 | Worker 18 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:270' at master log binlog.000002, end_log_pos 102764; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:16.436630 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:270 | 2020-05-07 14:33:29.306829 | 2020-05-07 14:33:29.306829 | 2020-05-07 14:34:18.427265 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:09.435491 | | | 19 | NULL | OFF | 1205 | Worker 19 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:271' at master log binlog.000002, end_log_pos 103146; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.443402 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:271 | 2020-05-07 14:33:29.306894 | 2020-05-07 14:33:29.306894 | 2020-05-07 14:34:18.427460 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:11.436589 | | | 20 | NULL | OFF | 1205 | Worker 20 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:272' at master log binlog.000002, end_log_pos 103528; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:18.442592 | | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | 0000-00-00 00:00:00.000000 | c9c7a123-905e-11ea-bcd6-000d6179f72b:272 | 2020-05-07 14:33:29.306931 | 2020-05-07 14:33:29.306931 | 2020-05-07 14:34:18.427713 | 0 | 0 | | 0000-00-00 00:00:00.000000 | 10 | 1205 | Lock wait timeout exceeded; try restarting transaction | 2020-05-07 14:35:12.435912 | +--------------+-----------+-----------+---------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+------------------------------------------+----------------------------------------------------+-----------------------------------------------------+------------------------------------------------+----------------------------------------------+------------------------------------------+------------------------------------------------+-------------------------------------------------+--------------------------------------------+----------------------------------------+------------------------------------------------------+--------------------------------------------------------------------+---------------------------------------------------------+------------------------------------+--------------------------------------------------+--------------------------------------------------------------------+-----------------------------------------------------+ 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 | +--------+-----------+---------------------+---------------------+-------------------+ | 120240 | RUNNING | 2020-05-07 14:35:30 | 15 | 0 | | 118063 | RUNNING | 2020-05-07 14:35:28 | 14 | 0 | | 109463 | RUNNING | 2020-05-07 14:35:20 | 23 | 0 | | 109462 | RUNNING | 2020-05-07 14:35:20 | 13 | 0 | | 109461 | RUNNING | 2020-05-07 14:35:20 | 12 | 0 | | 107253 | RUNNING | 2020-05-07 14:35:18 | 11 | 0 | | 107252 | RUNNING | 2020-05-07 14:35:18 | 21 | 0 | | 104981 | RUNNING | 2020-05-07 14:35:16 | 27 | 0 | | 104978 | RUNNING | 2020-05-07 14:35:16 | 20 | 0 | | 104973 | RUNNING | 2020-05-07 14:35:16 | 30 | 0 | | 104968 | RUNNING | 2020-05-07 14:35:16 | 22 | 0 | | 104963 | RUNNING | 2020-05-07 14:35:16 | 29 | 0 | | 102883 | RUNNING | 2020-05-07 14:35:14 | 28 | 0 | | 102881 | RUNNING | 2020-05-07 14:35:14 | 26 | 0 | +--------+-----------+---------------------+---------------------+-------------------+ 14 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.000002 Read_Master_Log_Pos: 1046367561 Relay_Log_File: fc30-relay-bin.000002 Relay_Log_Pos: 98038 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 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438. 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: 97829 Relay_Log_Space: 1046371299 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: 559 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 5 failed executing transaction 'c9c7a123-905e-11ea-bcd6-000d6179f72b:277' at master log binlog.000002, end_log_pos 105438. 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: c9c7a123-905e-11ea-bcd6-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 14:35:32 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: c9c7a123-905e-11ea-bcd6-000d6179f72b:1-2739183 Executed_Gtid_Set: c9c7a123-905e-11ea-bcd6-000d6179f72b:1-257 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: Master_public_key_path: Get_master_public_key: 0 Network_Namespace: 1 row in set (0.00 sec) mysql> mysql> mysql> ============= (sorry it seems the 8.0.20 -minimal packages have little debug info.... (gdb) thread apply all bt Thread 57 (Thread 0x7fc0302da700 (LWP 5017)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3132c0c ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3132c20 , cond=0x3132be0 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3132be0 , mutex=0x3132c20 ) at pthread_cond_wait.c:655 #3 0x000000000104e1ea in inline_mysql_cond_wait(mysql_cond_t*, mysql_mutex_t*, char const*, int) [clone .constprop.0] () #4 0x000000000104e47b in Per_thread_connection_handler::block_until_new_connection() () #5 0x000000000104e728 in handle_connection () #6 0x0000000001ad5869 in pfs_spawn_thread () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 56 (Thread 0x7fc030322700 (LWP 4991)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7fc03031f9c0, expected=0, futex_word=0x314b450 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7fc03031f9c0, mutex=0x314b3c8 , cond=0x314b428 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x314b428 , mutex=0x314b3c8 , abstime=0x7fc03031f9c0) at pthread_cond_wait.c:667 #3 0x000000000169ef43 in MYSQL_BIN_LOG::wait_for_update(timespec const*) () #4 0x00000000016e33cc in Binlog_sender::wait_new_events(unsigned long long) () #5 0x00000000016e34ca in Binlog_sender::get_binlog_end_pos(Basic_binlog_file_reader*, unsigned long long*) () #6 0x00000000016e44c1 in Binlog_sender::send_binlog(Basic_binlog_file_reader*, unsigned long long) () #7 0x00000000016e4772 in Binlog_sender::run() () #8 0x00000000016e0b8b in mysql_binlog_send(THD*, char*, unsigned long long, Gtid_set*, unsigned int) () #9 0x00000000016e220b in com_binlog_dump_gtid(THD*, char*, unsigned long) () #10 0x0000000000f958d2 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #11 0x0000000000f961a2 in do_command(THD*) () #12 0x000000000104e6b1 in handle_connection () #13 0x0000000001ad5869 in pfs_spawn_thread () #14 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #15 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 55 (Thread 0x7fc03036a700 (LWP 4946)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd80062dc) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd80062b0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd80062b0, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 54 (Thread 0x7fc0303b2700 (LWP 4945)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8006294) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8006268) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8006268, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 53 (Thread 0x7fc0303fa700 (LWP 4944)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8006248) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8006220) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8006220, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 52 (Thread 0x7fc030442700 (LWP 4937)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8006204) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd80061d8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd80061d8, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 51 (Thread 0x7fc03048a700 (LWP 4936)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd80061bc) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8006190) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8006190, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 50 (Thread 0x7fc030562700 (LWP 4933)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd80060e4) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd80060b8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd80060b8, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 49 (Thread 0x7fc0305aa700 (LWP 4932)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd800609c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8006070) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8006070, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 48 (Thread 0x7fc0305f2700 (LWP 4931)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8006050) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8006028) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8006028, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c23e in Commit_order_manager::wait(THD*) () #5 0x00000000010f7ee8 in ha_commit_low(THD*, bool, bool) () #6 0x00000000016ac3a1 in MYSQL_BIN_LOG::commit(THD*, bool) () #7 0x00000000010f8941 in ha_commit_trans(THD*, bool, bool) () #8 0x00000000010338d7 in trans_commit_stmt(THD*, bool) () #9 0x0000000000f938c9 in mysql_execute_command(THD*, bool) () #10 0x0000000000f94054 in mysql_parse(THD*, Parser_state*) () #11 0x00000000016c211d in Query_log_event::do_apply_event(Relay_log_info const*, char const*, unsigned long) () #12 0x00000000016fa002 in Slave_worker::read_and_apply_events(unsigned int, unsigned long long, unsigned int, unsigned long long) () #13 0x00000000016fa36f in Slave_worker::retry_transaction(unsigned int, unsigned long long, unsigned int, unsigned long long) () #14 0x00000000016fa566 in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #15 0x00000000016fbce5 in handle_slave_worker () #16 0x0000000001ad5869 in pfs_spawn_thread () #17 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #18 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 47 (Thread 0x7fc03063a700 (LWP 4929)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd800600c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8005fe0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8005fe0, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 46 (Thread 0x7fc0307a2700 (LWP 4924)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8005ea4) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8005e78) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8005e78, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 45 (Thread 0x7fc0307ea700 (LWP 4923)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8005e5c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8005e30) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8005e30, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 44 (Thread 0x7fc040076700 (LWP 4922)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8005e14) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8005de8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8005de8, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 43 (Thread 0x7fc04805b700 (LWP 4921)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8005dcc) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8005da0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8005da0, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 42 (Thread 0x7fc0480a3700 (LWP 4920)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd8005d80) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd8005cf0, cond=0x7fbfd8005d58) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd8005d58, mutex=0x7fbfd8005cf0) at pthread_cond_wait.c:655 #3 0x000000000170bf31 in Commit_order_manager::wait(Slave_worker*) () #4 0x000000000170c2cc in Commit_order_manager::wait_and_finish(THD*, bool) () #5 0x00000000016f9123 in Slave_worker::slave_worker_ends_group(Log_event*, int) () #6 0x00000000016fa6fe in slave_worker_exec_job_group(Slave_worker*, Relay_log_info*) () #7 0x00000000016fbce5 in handle_slave_worker () #8 0x0000000001ad5869 in pfs_spawn_thread () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 41 (Thread 0x7fc0480eb700 (LWP 4918)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fbfd802070c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fbfd80206b0, cond=0x7fbfd80206e0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fbfd80206e0, mutex=0x7fbfd80206b0) at pthread_cond_wait.c:655 #3 0x00000000016fabdb in inline_mysql_cond_wait(mysql_cond_t*, mysql_mutex_t*, char const*, int) [clone .constprop.0] () #4 0x0000000001705a17 in handle_slave_sql () #5 0x0000000001ad5869 in pfs_spawn_thread () #6 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 40 (Thread 0x7fc048133700 (LWP 4917)): #0 0x00007fc0578db7b6 in __GI_ppoll (fds=0x7fc0481324c8, nfds=1, timeout=, sigmask=0x0) at ../sysdeps/unix/sysv/linux/ppoll.c:39 #1 0x0000000001bbd9d7 in vio_io_wait(Vio*, enum_vio_io_event, int) () #2 0x0000000001bbda4f in vio_socket_io_wait(Vio*, enum_vio_io_event) () #3 0x0000000001bbdb3b in vio_read(Vio*, unsigned char*, unsigned long) () #4 0x0000000001bbdbbc in vio_read_buff(Vio*, unsigned char*, unsigned long) () #5 0x000000000104b7b8 in net_read_raw_loop(NET*, unsigned long) () #6 0x000000000104bd4d in net_read_packet(NET*, unsigned long*) () #7 0x000000000104c7ed in my_net_read(NET*) () #8 0x0000000001042a5e in cli_safe_read_with_ok () #9 0x0000000001045958 in mysql_binlog_fetch () #10 0x000000000170a67c in handle_slave_io () #11 0x0000000001ad5869 in pfs_spawn_thread () #12 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #13 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 39 (Thread 0x7fc04817b700 (LWP 4916)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7fc0481789c0, expected=0, futex_word=0x314b450 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7fc0481789c0, mutex=0x314b3c8 , cond=0x314b428 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x314b428 , mutex=0x314b3c8 , abstime=0x7fc0481789c0) at pthread_cond_wait.c:667 #3 0x000000000169ef43 in MYSQL_BIN_LOG::wait_for_update(timespec const*) () #4 0x00000000016e33cc in Binlog_sender::wait_new_events(unsigned long long) () #5 0x00000000016e34ca in Binlog_sender::get_binlog_end_pos(Basic_binlog_file_reader*, unsigned long long*) () #6 0x00000000016e44c1 in Binlog_sender::send_binlog(Basic_binlog_file_reader*, unsigned long long) () #7 0x00000000016e4772 in Binlog_sender::run() () #8 0x00000000016e0b8b in mysql_binlog_send(THD*, char*, unsigned long long, Gtid_set*, unsigned int) () #9 0x00000000016e220b in com_binlog_dump_gtid(THD*, char*, unsigned long) () #10 0x0000000000f958d2 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #11 0x0000000000f961a2 in do_command(THD*) () #12 0x000000000104e6b1 in handle_connection () #13 0x0000000001ad5869 in pfs_spawn_thread () #14 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #15 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 38 (Thread 0x7fc011ffb700 (LWP 4866)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x30bc4ac ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x30bc4c0 , cond=0x30bc480 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x30bc480 , mutex=0x30bc4c0 ) at pthread_cond_wait.c:655 #3 0x00000000016caf89 in compress_gtid_table () #4 0x0000000001ad5869 in pfs_spawn_thread () #5 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #6 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 37 (Thread 0x7fc049ea5700 (LWP 4865)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x6b86d10) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x6b86cb8, cond=0x6b86ce8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x6b86ce8, mutex=0x6b86cb8) at pthread_cond_wait.c:655 #3 0x0000000001b3eb83 in xpl::Cond::wait(xpl::Mutex&) () #4 0x0000000001b7c295 in xpl::Broker_task::wait_for_data_and_swap_queues(std::queue > >*) () #5 0x0000000001b7c8c4 in xpl::Broker_task::loop() () #6 0x0000000001b35801 in ngs::Server::run_task(std::shared_ptr) () #7 0x0000000001b35848 in std::_Function_handler::_M_invoke(std::_Any_data const&) () #8 0x0000000001b7795f in ngs::Scheduler_dynamic::worker() () #9 0x0000000001ad5869 in pfs_spawn_thread () #10 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #11 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 36 (Thread 0x7fc049f34700 (LWP 4863)): #0 0x00007fc057822c22 in __GI___sigtimedwait (set=0x7fc049f33c90, info=0x7fc049f33d10, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x0000000000eed3e1 in signal_hand () #2 0x0000000001ad5869 in pfs_spawn_thread () #3 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #4 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 35 (Thread 0x7fc049f7c700 (LWP 4862)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x6d3b568) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x6d3b510, cond=0x6d3b540) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x6d3b540, mutex=0x6d3b510) at pthread_cond_wait.c:655 #3 0x000000000123a82a in Event_queue::cond_wait(THD*, timespec*, PSI_stage_info_v1 const*, char const*, char const*, unsigned int) () #4 0x000000000123aef4 in Event_queue::get_top_for_execution_if_time(THD*, Event_queue_element_for_exec**) () #5 0x000000000123c80c in Event_scheduler::run(THD*) () #6 0x000000000123c9b4 in event_scheduler_thread () #7 0x0000000001ad5869 in pfs_spawn_thread () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 34 (Thread 0x7fc0127fc700 (LWP 4861)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fc0440252c4) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fc044025270, cond=0x7fc044025298) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fc044025298, mutex=0x7fc044025270) at pthread_cond_wait.c:655 #3 0x000000000190ff1c in os_event::wait_low(long) () #4 0x0000000001965acc in srv_worker_thread() () #5 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #6 0x0000000001c4f1b0 in execute_native_thread_routine () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 33 (Thread 0x7fc012ffd700 (LWP 4860)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fc044025220) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fc0440251d0, cond=0x7fc0440251f8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fc0440251f8, mutex=0x7fc0440251d0) at pthread_cond_wait.c:655 #3 0x000000000190ff1c in os_event::wait_low(long) () #4 0x0000000001965acc in srv_worker_thread() () #5 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #6 0x0000000001c4f1b0 in execute_native_thread_routine () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 32 (Thread 0x7fc0137fe700 (LWP 4859)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fc044025180) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fc044025130, cond=0x7fc044025158) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fc044025158, mutex=0x7fc044025130) at pthread_cond_wait.c:655 #3 0x000000000190ff1c in os_event::wait_low(long) () #4 0x0000000001965acc in srv_worker_thread() () #5 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #6 0x0000000001c4f1b0 in execute_native_thread_routine () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 31 (Thread 0x7fc013fff700 (LWP 4858)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fc0440250e4) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fc044025090, cond=0x7fc0440250b8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fc0440250b8, mutex=0x7fc044025090) at pthread_cond_wait.c:655 #3 0x000000000190ff1c in os_event::wait_low(long) () #4 0x0000000001965ed5 in srv_purge_coordinator_thread() () #5 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #6 0x0000000001c4f1b0 in execute_native_thread_routine () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 30 (Thread 0x7fc030feb700 (LWP 4857)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc030fea980, expected=0, futex_word=0x7fc0442e9304) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc030feabc0, mutex=0x7fc0442e92b0, cond=0x7fc0442e92d8) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0442e92d8, mutex=0x7fc0442e92b0, abstime=0x7fc030feabc0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x00000000019f3fa7 in Clone_persist_gtid::periodic_write() () #6 0x00000000019f2c01 in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 29 (Thread 0x7fc04bb2f700 (LWP 4856)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fc0440254a0) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fc044025450, cond=0x7fc044025478) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fc044025478, mutex=0x7fc044025450) at pthread_cond_wait.c:655 #3 0x000000000190ff1c in os_event::wait_low(long) () #4 0x00000000019d7742 in buf_dump_thread() () #5 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #6 0x0000000001c4f1b0 in execute_native_thread_routine () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 28 (Thread 0x7fc049fc3700 (LWP 4841)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x0000000001b9298f in epoll_wait () #2 0x0000000001b927a8 in epoll_dispatch () #3 0x0000000001b8bebf in event_base_loop () #4 0x0000000001b35801 in ngs::Server::run_task(std::shared_ptr) () #5 0x0000000001b35848 in std::_Function_handler::_M_invoke(std::_Any_data const&) () #6 0x0000000001b7795f in ngs::Scheduler_dynamic::worker() () #7 0x0000000001ad5869 in pfs_spawn_thread () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 27 (Thread 0x7fc04a00a700 (LWP 4840)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7fc04a009c78, expected=0, futex_word=0x6bfe078) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7fc04a009c78, mutex=0x6bfe020, cond=0x6bfe050) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x6bfe050, mutex=0x6bfe020, abstime=0x7fc04a009c78) at pthread_cond_wait.c:667 #3 0x0000000001b3ec07 in xpl::Cond::timed_wait(xpl::Mutex&, unsigned long long) () #4 0x0000000001b775ba in ngs::Scheduler_dynamic::wait_if_idle_then_delete_worker(unsigned long long&) () #5 0x0000000001b77a44 in ngs::Scheduler_dynamic::worker() () #6 0x0000000001ad5869 in pfs_spawn_thread () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 26 (Thread 0x7fc04a051700 (LWP 4839)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7fc04a050c78, expected=0, futex_word=0x6bfe078) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7fc04a050c78, mutex=0x6bfe020, cond=0x6bfe050) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x6bfe050, mutex=0x6bfe020, abstime=0x7fc04a050c78) at pthread_cond_wait.c:667 #3 0x0000000001b3ec07 in xpl::Cond::timed_wait(xpl::Mutex&, unsigned long long) () #4 0x0000000001b775ba in ngs::Scheduler_dynamic::wait_if_idle_then_delete_worker(unsigned long long&) () #5 0x0000000001b77a44 in ngs::Scheduler_dynamic::worker() () #6 0x0000000001ad5869 in pfs_spawn_thread () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 25 (Thread 0x7fc0317ec700 (LWP 4828)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc0317eb900, expected=0, futex_word=0x7fc0446ba920) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc0317ebb40, mutex=0x7fc0446ba8d0, cond=0x7fc0446ba8f8) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0446ba8f8, mutex=0x7fc0446ba8d0, abstime=0x7fc0317ebb40) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x0000000001995aa9 in ib_wqueue_timedwait(ib_wqueue_t*, long) () #6 0x0000000001a555ae in fts_optimize_thread(ib_wqueue_t*) () #7 0x0000000001a5255b in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 24 (Thread 0x7fc031fed700 (LWP 4827)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc031fecac0, expected=0, futex_word=0x7fc044799490) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc031fecd00, mutex=0x7fc044799440, cond=0x7fc044799468) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc044799468, mutex=0x7fc044799440, abstime=0x7fc031fecd00) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x0000000001a21947 in dict_stats_thread() () #6 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 23 (Thread 0x7fc0327ee700 (LWP 4826)): #0 0x00007fc0584f40b5 in __GI___nanosleep (requested_time=0x7fc0327edd10, remaining=0x7fc0327edd10) at ../sysdeps/unix/sysv/linux/nanosleep.c:28 #1 0x00000000016a07e0 in void std::this_thread::sleep_for >(std::chrono::duration > const&) () #2 0x00000000019670fe in srv_master_thread() () #3 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #4 0x0000000001c4f1b0 in execute_native_thread_routine () #5 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #6 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 22 (Thread 0x7fc032fef700 (LWP 4825)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7fc0440255e0) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7fc044025590, cond=0x7fc0440255b8) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7fc0440255b8, mutex=0x7fc044025590) at pthread_cond_wait.c:655 #3 0x000000000190ff1c in os_event::wait_low(long) () #4 0x00000000019ce4d5 in buf_resize_thread() () #5 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #6 0x0000000001c4f1b0 in execute_native_thread_routine () #7 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 21 (Thread 0x7fc0337f0700 (LWP 4798)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc0337efae0, expected=0, futex_word=0x7fc044025400) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc0337efd20, mutex=0x7fc0440253b0, cond=0x7fc0440253d8) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0440253d8, mutex=0x7fc0440253b0, abstime=0x7fc0337efd20) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x0000000001966dcb in srv_monitor_thread() () #6 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 20 (Thread 0x7fc033ff1700 (LWP 4797)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc033ff0930, expected=0, futex_word=0x7fc044025360) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc033ff0b70, mutex=0x7fc044025310, cond=0x7fc044025338) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc044025338, mutex=0x7fc044025310, abstime=0x7fc033ff0b70) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x0000000001965765 in srv_error_monitor_thread() () #6 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 19 (Thread 0x7fc0347f2700 (LWP 4796)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc0347f1990, expected=0, futex_word=0x7fc0443f62c0) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc0347f1bd0, mutex=0x7fc0443f6270, cond=0x7fc0443f6298) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0443f6298, mutex=0x7fc0443f6270, abstime=0x7fc0347f1bd0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x00000000018e978e in lock_wait_timeout_thread() () #6 0x00000000018f46bf in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 18 (Thread 0x7fc034ff3700 (LWP 4777)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc034ff28a0, expected=0, futex_word=0x7fc044437480) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc034ff2ae0, mutex=0x7fc044437430, cond=0x7fc044437458) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc044437458, mutex=0x7fc044437430, abstime=0x7fc034ff2ae0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x0000000001901d1d in log_writer(log_t*) () #6 0x00000000018f154b in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 17 (Thread 0x7fc0357f4700 (LWP 4776)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc0357f3a60, expected=0, futex_word=0x7fc044437340) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc0357f3ca0, mutex=0x7fc0444372f0, cond=0x7fc044437318) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc044437318, mutex=0x7fc0444372f0, abstime=0x7fc0357f3ca0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x0000000001903b8c in log_write_notifier(log_t*) () #6 0x00000000018f154b in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 16 (Thread 0x7fc035ff5700 (LWP 4775)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc035ff4a80, expected=0, futex_word=0x7fc044437524) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc035ff4cc0, mutex=0x7fc0444374d0, cond=0x7fc0444374f8) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0444374f8, mutex=0x7fc0444374d0, abstime=0x7fc035ff4cc0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x00000000019036da in log_flusher(log_t*) () #6 0x00000000018f154b in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 15 (Thread 0x7fc0367f6700 (LWP 4774)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc0367f5a60, expected=0, futex_word=0x7fc0444373e4) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc0367f5ca0, mutex=0x7fc044437390, cond=0x7fc0444373b8) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0444373b8, mutex=0x7fc044437390, abstime=0x7fc0367f5ca0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x000000000190413f in log_flush_notifier(log_t*) () #6 0x00000000018f154b in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 14 (Thread 0x7fc036ff7700 (LWP 4773)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc036ff6a90, expected=0, futex_word=0x7fc0444372a0) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc036ff6cd0, mutex=0x7fc044437250, cond=0x7fc044437278) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc044437278, mutex=0x7fc044437250, abstime=0x7fc036ff6cd0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x000000000190455c in log_closer(log_t*) () #6 0x00000000018f154b in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 13 (Thread 0x7fc0377f8700 (LWP 4772)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc0377f7ab0, expected=0, futex_word=0x7fc044437200) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc0377f7cf0, mutex=0x7fc0444371b0, cond=0x7fc0444371d8) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc0444371d8, mutex=0x7fc0444371b0, abstime=0x7fc0377f7cf0) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x00000000018ecf05 in log_checkpointer(log_t*) () #6 0x00000000018f154b in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 12 (Thread 0x7fc03a7fc700 (LWP 4743)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7fc03a7fb900, expected=0, futex_word=0x7fc044025544) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7fc03a7fbb40, mutex=0x7fc0440254f0, cond=0x7fc044025518) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x7fc044025518, mutex=0x7fc0440254f0, abstime=0x7fc03a7fbb40) at pthread_cond_wait.c:667 #3 0x0000000001910171 in os_event::timed_wait(timespec const*) () #4 0x000000000191093d in os_event::wait_time_low(unsigned long, long) () #5 0x00000000019db5d9 in buf_flush_page_coordinator_thread(unsigned long) () #6 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #7 0x0000000001c4f1b0 in execute_native_thread_routine () #8 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 11 (Thread 0x7fc03affd700 (LWP 4742)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc04a853000, min_nr=1, nr=256, events=0x7fc044320600, timeout=0x7fc03affc8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 10 (Thread 0x7fc03b7fe700 (LWP 4741)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc04a858000, min_nr=1, nr=256, events=0x7fc04431e600, timeout=0x7fc03b7fd8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7fc03bfff700 (LWP 4740)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc04a85d000, min_nr=1, nr=256, events=0x7fc04431c600, timeout=0x7fc03bffe8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7fc040f39700 (LWP 4739)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc04a862000, min_nr=1, nr=256, events=0x7fc04431a600, timeout=0x7fc040f388d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 7 (Thread 0x7fc04173a700 (LWP 4738)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc05850f000, min_nr=1, nr=256, events=0x7fc0442f55c0, timeout=0x7fc0417398d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7fc041f3b700 (LWP 4737)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc058514000, min_nr=1, nr=256, events=0x7fc0442f35c0, timeout=0x7fc041f3a8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7fc04899d700 (LWP 4736)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc058519000, min_nr=1, nr=256, events=0x7fc0442f15c0, timeout=0x7fc04899c8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7fc04919e700 (LWP 4735)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc05851e000, min_nr=1, nr=256, events=0x7fc0442ef5c0, timeout=0x7fc04919d8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7fc04999f700 (LWP 4734)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc058505000, min_nr=1, nr=256, events=0x7fc0443185f0, timeout=0x7fc04999e8d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7fc04a852700 (LWP 4733)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007fc057cf6157 in __io_getevents_0_4 (ctx=0x7fc05850a000, min_nr=1, nr=256, events=0x7fc0442ecb40, timeout=0x7fc04a8518d0) at io_getevents.c:25 #2 0x0000000001908b02 in LinuxAIOHandler::collect() () #3 0x0000000001909c12 in LinuxAIOHandler::poll(fil_node_t**, void**, IORequest*) () #4 0x000000000190d395 in os_aio_handler(unsigned long, fil_node_t**, void**, IORequest*) () #5 0x0000000001a30362 in fil_aio_wait(unsigned long) () #6 0x00000000019675ad in io_handler_thread(unsigned long) () #7 0x0000000001967c5c in std::thread::_State_impl > >::_M_run() () #8 0x0000000001c4f1b0 in execute_native_thread_routine () #9 0x00007fc0584ea4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007fc0578e6133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7fc0577e5840 (LWP 4709)): #0 0x00007fc0578db6c7 in __GI___poll (fds=0x6b8bec0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x00000000010504bf in Mysqld_socket_listener::listen_for_connection_event() () #2 0x0000000000efa5d8 in mysqld_main(int, char**) () #3 0x00007fc05780df43 in __libc_start_main (main=0xec1a30
, argc=10, argv=0x7fff10c2a2f8, init=, fini=, rtld_fini=, stack_end=0x7fff10c2a2e8) at ../csu/libc-start.c:308 #4 0x0000000000eeaa37 in _start ()