TABLE ON MASTER ------------------ create database test; use test; drop table if exists t; CREATE TABLE `t` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `a_id` bigint(20) NOT NULL, `b_id` bigint(20) NOT NULL, `c_id` smallint(5) NOT NULL, `d_id` varchar(255) NOT NULL DEFAULT '', `created_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_table_name` (`a_id`,`b_id`), KEY `index_b` (`b_id`), key(d_id), unique key(a_id,b_id,d_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; COMMAND TO RUN LOAD TEST ON MASTER: ------ (use the 8.0.20 mysqlslap as it can handle errors): mysqlslap -uroot -h127.0.0.1 -P3333 --query=' INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES ('20123', 1234203, 3, 12345212);' --create-schema=test --iterations=1000 --number-of-queries=100000 --concurrency=100 Master my.cnf -------------- [mysqld] core-file log_error_verbosity = 3 log-bin = binlog binlog_row_event_max_size=1000000 binlog_cache_size=1000000 binlog_format = MIXED binlog_rows_query_log_events = 1 binlog_order_commits=1 sync_binlog = 1000 master_info_repository = TABLE gtid_mode = ON enforce_gtid_consistency = 1 innodb_flush_neighbors = 0 innodb-lock-wait-timeout=50 lock-wait-timeout=1 innodb-flush-log-at-trx-commit=0 skip-innodb-doublewrite innodb-buffer-pool-size=1G innodb-log-file-size=128M sql_mode="" transaction-isolation = REPEATABLE-READ innodb_flush_method = O_DIRECT slave_parallel_type=logical_clock Slave my.cnf: ------------ [mysqld] core-file log_error_verbosity = 3 log-bin = binlog log-slave-updates=1 binlog_format = MIXED binlog_rows_query_log_events = 1 master_info_repository = TABLE relay_log_info_repository = TABLE gtid_mode = ON enforce_gtid_consistency = 1 innodb_flush_neighbors = 0 innodb-lock-wait-timeout=1 lock-wait-timeout=1 skip-innodb-doublewrite innodb-buffer-pool-size=32M innodb-log-file-size=32M sql_mode="" innodb-flush-log-at-trx-commit=0 sync_binlog=10000 binlog_order_commits=1 max_binlog_size = 100M slave_preserve_commit_order = 1 max_relay_log_size = 100M transaction-isolation = REPEATABLE-READ relay_log_recovery = 1 slave_net_timeout = 300 sync_master_info = 100 sync_relay_log_info = 100 slave_parallel_workers = 20 innodb_flush_method = O_DIRECT slave_parallel_type=logical_clock Error Log: ----------- Version: '5.7.28-log' socket: '/home/anon/rpl/intermediate/sock' port: 3334 MySQL Community Server (GPL) 2020-05-07T10:25:02.794699Z 2 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=fc30-relay-bin' to avoid this problem. 2020-05-07T10:25:02.911181Z 2 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='127.0.0.1', master_port= 3333, master_log_file='', master_log_pos= 4, master_bind=''. 2020-05-07T10:25:03.019178Z 3 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2020-05-07T10:25:03.020149Z 3 [Note] Slave I/O thread for channel '': connected to master 'root@127.0.0.1:3333',replication started in log 'FIRST' at position 4 2020-05-07T10:25:03.070636Z 4 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './fc30-relay-bin.000001' position: 4 2020-05-07T10:25:04.455968Z 26 [Note] Start binlog_dump to master_thread_id(26) slave_server(3), pos(, 4) 2020-05-07T10:25:04.921551Z 27 [Note] Start binlog_dump to master_thread_id(27) slave_server(4), pos(, 4) 2020-05-07T10:25:32.539692Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10313ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.) 2020-05-07T10:26:07.472383Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:607' at master log binlog.000002, end_log_pos 219337; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:08.472433Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:609' at master log binlog.000002, end_log_pos 220061; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:23.495400Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:672' at master log binlog.000002, end_log_pos 242867; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:24.495479Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:674' at master log binlog.000002, end_log_pos 243591; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:28.514753Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:683' at master log binlog.000002, end_log_pos 246849; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:29.514838Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:685' at master log binlog.000002, end_log_pos 247573; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:43.530485Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:717' at master log binlog.000002, end_log_pos 259157; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:43.530567Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:720' at master log binlog.000002, end_log_pos 260243; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:44.530548Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:719' at master log binlog.000002, end_log_pos 259881; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:26:44.530548Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:721' at master log binlog.000002, end_log_pos 260605; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:10.540856Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:740' at master log binlog.000002, end_log_pos 267483; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:25.546445Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:758' at master log binlog.000002, end_log_pos 273999; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:27.546711Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:760' at master log binlog.000002, end_log_pos 274723; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:27.546740Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:759' at master log binlog.000002, end_log_pos 274361; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:27.546711Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:761' at master log binlog.000002, end_log_pos 275085; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:27.546809Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:762' at master log binlog.000002, end_log_pos 275447; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:27.546868Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:763' at master log binlog.000002, end_log_pos 275809; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:30.547045Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:763' at master log binlog.000002, end_log_pos 275809; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:30.547148Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:759' at master log binlog.000002, end_log_pos 274361; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:37.548087Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:767' at master log binlog.000002, end_log_pos 277257; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:37.548155Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:766' at master log binlog.000002, end_log_pos 276895; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:41.549649Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:768' at master log binlog.000002, end_log_pos 277619; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:41.549649Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:765' at master log binlog.000002, end_log_pos 276533; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:49.551339Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:770' at master log binlog.000002, end_log_pos 278343; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:49.551339Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:767' at master log binlog.000002, end_log_pos 277257; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:27:53.551451Z 6 [Warning] Slave SQL for channel '': Worker 2 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:770' at master log binlog.000002, end_log_pos 278343; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:05.554728Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:781' at master log binlog.000002, end_log_pos 282325; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:18.566850Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:809' at master log binlog.000002, end_log_pos 292461; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:18.566858Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:810' at master log binlog.000002, end_log_pos 292823; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:19.567181Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:808' at master log binlog.000002, end_log_pos 292099; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:19.567181Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:19.567182Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:815' at master log binlog.000002, end_log_pos 294633; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:22.567527Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:813' at master log binlog.000002, end_log_pos 293909; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:22.567606Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:810' at master log binlog.000002, end_log_pos 292823; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:23.567940Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:815' at master log binlog.000002, end_log_pos 294633; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:23.568016Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:24.567867Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:816' at master log binlog.000002, end_log_pos 294995; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:24.567940Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:808' at master log binlog.000002, end_log_pos 292099; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:24.567998Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:811' at master log binlog.000002, end_log_pos 293185; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:27.568224Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:809' at master log binlog.000002, end_log_pos 292461; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:29.568485Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:812' at master log binlog.000002, end_log_pos 293547; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:30.568565Z 9 [Warning] Slave SQL for channel '': Worker 5 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:808' at master log binlog.000002, end_log_pos 292099; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:34.568778Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:809' at master log binlog.000002, end_log_pos 292461; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:35.568952Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:39.569129Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:815' at master log binlog.000002, end_log_pos 294633; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:39.569128Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:811' at master log binlog.000002, end_log_pos 293185; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:41.569287Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:809' at master log binlog.000002, end_log_pos 292461; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:41.569287Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:812' at master log binlog.000002, end_log_pos 293547; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:42.569359Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:43.569457Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:816' at master log binlog.000002, end_log_pos 294995; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:48.569721Z 10 [Warning] Slave SQL for channel '': Worker 6 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:809' at master log binlog.000002, end_log_pos 292461; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:48.569793Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:812' at master log binlog.000002, end_log_pos 293547; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:49.569877Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:50.569940Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:816' at master log binlog.000002, end_log_pos 294995; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:51.569989Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:813' at master log binlog.000002, end_log_pos 293909; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:53.570158Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:810' at master log binlog.000002, end_log_pos 292823; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:28:56.570355Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:00.570636Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:815' at master log binlog.000002, end_log_pos 294633; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:00.570636Z 11 [Warning] Slave SQL for channel '': Worker 7 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:810' at master log binlog.000002, end_log_pos 292823; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:03.570933Z 8 [Warning] Slave SQL for channel '': Worker 4 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:812' at master log binlog.000002, end_log_pos 293547; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:03.570952Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:07.571490Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:817' at master log binlog.000002, end_log_pos 295357; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:08.571367Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:816' at master log binlog.000002, end_log_pos 294995; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:10.571721Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:817' at master log binlog.000002, end_log_pos 295357; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:12.571944Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:811' at master log binlog.000002, end_log_pos 293185; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:14.571868Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:817' at master log binlog.000002, end_log_pos 295357; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:15.572014Z 15 [Warning] Slave SQL for channel '': Worker 11 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:816' at master log binlog.000002, end_log_pos 294995; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:15.572021Z 14 [Warning] Slave SQL for channel '': Worker 10 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:815' at master log binlog.000002, end_log_pos 294633; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:17.572366Z 13 [Warning] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:17.572429Z 13 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 1205 2020-05-07T10:29:17.572459Z 13 [ERROR] Slave SQL for channel '': Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205 2020-05-07T10:29:19.572535Z 5 [Warning] Slave SQL for channel '': Worker 1 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:817' at master log binlog.000002, end_log_pos 295357; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:19.572535Z 7 [Warning] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:811' at master log binlog.000002, end_log_pos 293185; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:19.572685Z 7 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 1205 2020-05-07T10:29:19.572710Z 7 [ERROR] Slave SQL for channel '': Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:811' at master log binlog.000002, end_log_pos 293185; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205 2020-05-07T10:29:19.574353Z 14 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:29:21.574177Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:813' at master log binlog.000002, end_log_pos 293909; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 2020-05-07T10:29:21.574427Z 15 [ERROR] Slave SQL for channel '': worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Error_code: 0 2020-05-07T10:29:23.574466Z 12 [Warning] Slave SQL for channel '': Worker 8 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:813' at master log binlog.000002, end_log_pos 293909; Error 'Lock wait timeout exceeded; try restarting transaction' on query. Default database: 'test'. Query: 'INSERT IGNORE INTO t(d_id, b_id, c_id, a_id) VALUES (20123, 1234203, 3, 12345212)', Error_code: 1205 Some Outputs -------------- show engine innodb status \G show processlist; select * from performance_schema.replication_applier_status; select * from performance_schema.replication_applier_status_by_worker; select trx_id,trx_state,trx_started,trx_mysql_thread_id,trx_rows_modified from information_schema.innodb_trx; show slave status \G mysql> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-05-07 12:38:59 0x7ff9c8564700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 3 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 562 srv_active, 0 srv_shutdown, 249 srv_idle srv_master_thread log flush and writes: 811 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 101943 OS WAIT ARRAY INFO: signal count 72007 RW-shared spins 0, rounds 548, OS waits 105 RW-excl spins 0, rounds 8604, OS waits 234 RW-sx spins 10, rounds 285, OS waits 8 Spin rounds per wait: 548.00 RW-shared, 8604.00 RW-excl, 28.50 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 557975 Purge done for trx's n:o < 557975 undo n:o < 0 state: running but idle History list length 12 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422186174739888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422186174719824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422186174720736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 228683, ACTIVE (PREPARED) 576 sec 7 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 1 MySQL thread id 5, OS thread handle 140711195490048, query id 2188 Waiting for preceding transaction to commit -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 310 OS file reads, 7455 OS file writes, 2115 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 8747, node heap has 0 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 1 buffer(s) Hash table size 8747, node heap has 0 buffer(s) Hash table size 8747, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 113314935 Log flushed up to 113314935 Pages flushed up to 113314935 Last checkpoint at 113314926 0 pending log flushes, 0 pending chkp writes 1452 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 34357248 Dictionary memory allocated 128880 Buffer pool size 2048 Free buffers 1521 Database pages 522 Old database pages 209 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 278, created 244, written 5923 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 522, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=8619, Main thread ID=140710937548544, state: sleeping Number of rows inserted 24, updated 278279, deleted 1, read 278290 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 | +----+-------------+-----------------+------+------------------+------+---------------------------------------------------------------+------------------+ | 3 | system user | | NULL | Connect | 836 | Waiting for master to send event | NULL | | 4 | system user | | NULL | Connect | 594 | Waiting for workers to exit | NULL | | 5 | system user | | NULL | Connect | 820 | Waiting for preceding transaction to commit | NULL | | 26 | root | localhost:47892 | NULL | Binlog Dump GTID | 835 | Master has sent all binlog to slave; waiting for more updates | NULL | | 27 | root | localhost:47896 | NULL | Binlog Dump GTID | 835 | Master has sent all binlog to slave; waiting for more updates | NULL | | 29 | root | localhost:48110 | test | Query | 0 | starting | show processlist | +----+-------------+-----------------+------+------------------+------+---------------------------------------------------------------+------------------+ 6 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 | 256 | +--------------+---------------+-----------------+----------------------------+ 1 row in set (0.00 sec) mysql> select * from performance_schema.replication_applier_status_by_worker; +--------------+-----------+-----------+---------------+------------------------------------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+ | CHANNEL_NAME | WORKER_ID | THREAD_ID | SERVICE_STATE | LAST_SEEN_TRANSACTION | LAST_ERROR_NUMBER | LAST_ERROR_MESSAGE | LAST_ERROR_TIMESTAMP | +--------------+-----------+-----------+---------------+------------------------------------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+ | | 1 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:817 | 0 | | 0000-00-00 00:00:00 | | | 2 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:807 | 0 | | 0000-00-00 00:00:00 | | | 3 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:811 | 1205 | Worker 3 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:811' at master log binlog.000002, end_log_pos 293185; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 12:29:19 | | | 4 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:812 | 0 | | 0000-00-00 00:00:00 | | | 5 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:808 | 0 | | 0000-00-00 00:00:00 | | | 6 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:809 | 0 | | 0000-00-00 00:00:00 | | | 7 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:810 | 0 | | 0000-00-00 00:00:00 | | | 8 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:813 | 0 | | 0000-00-00 00:00:00 | | | 9 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:814 | 1205 | Worker 9 failed executing transaction 'f07f49ea-904c-11ea-a543-000d6179f72b:814' at master log binlog.000002, end_log_pos 294271; Lock wait timeout exceeded; try restarting transaction | 2020-05-07 12:29:17 | | | 10 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:815 | 0 | | 0000-00-00 00:00:00 | | | 11 | NULL | OFF | f07f49ea-904c-11ea-a543-000d6179f72b:816 | 0 | | 0000-00-00 00:00:00 | | | 12 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 13 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 14 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 15 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 16 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 17 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 18 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 19 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | | | 20 | NULL | OFF | | 0 | | 0000-00-00 00:00:00 | +--------------+-----------+-----------+---------------+------------------------------------------+-------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+ 20 rows in set (0.00 sec) mysql> select trx_id,trx_state,trx_started,trx_mysql_thread_id,trx_rows_modified from information_schema.innodb_trx; +--------+-----------+---------------------+---------------------+-------------------+ | trx_id | trx_state | trx_started | trx_mysql_thread_id | trx_rows_modified | +--------+-----------+---------------------+---------------------+-------------------+ | 228683 | RUNNING | 2020-05-07 12:29:23 | 5 | 1 | +--------+-----------+---------------------+---------------------+-------------------+ 1 row 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.000003 Read_Master_Log_Pos: 933276738 Relay_Log_File: fc30-relay-bin.000002 Relay_Log_Pos: 293061 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: 0 Last_Error: worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Skip_Counter: 0 Exec_Master_Log_Pos: 292854 Relay_Log_Space: 2007026946 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: 820 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: worker thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable. Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: f07f49ea-904c-11ea-a543-000d6179f72b Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for workers to exit Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 200507 12:29:21 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: f07f49ea-904c-11ea-a543-000d6179f72b:1-5544253 Executed_Gtid_Set: f07f49ea-904c-11ea-a543-000d6179f72b:1-810 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) mysql> mysql> mysql> Thread stacks ----------------- [anon@fc30 mysql]$ gdb -ex "set pagination 0" -ex "thread apply all bt" \ > --batch -p $(pidof mysqld) SIGINT is used by the debugger. Are you sure you want to change it? (y or n) [answered Y; input not from terminal] [New LWP 8624] [New LWP 8626] [New LWP 8627] [New LWP 8628] [New LWP 8629] [New LWP 8630] [New LWP 8631] [New LWP 8632] [New LWP 8633] [New LWP 8634] [New LWP 8635] [New LWP 8636] [New LWP 8671] [New LWP 8672] [New LWP 8673] [New LWP 8674] [New LWP 8675] [New LWP 8676] [New LWP 8677] [New LWP 8678] [New LWP 8693] [New LWP 8694] [New LWP 8695] [New LWP 8696] [New LWP 8739] [New LWP 8740] [New LWP 8744] [New LWP 8745] [New LWP 8746] [New LWP 8748] [New LWP 8799] [New LWP 8824] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". warning: Loadable section ".note.gnu.property" outside of ELF segments warning: Loadable section ".note.gnu.property" outside of ELF segments warning: Loadable section ".note.gnu.property" outside of ELF segments 0x00007ff9ea1686c7 in __GI___poll (fds=0x417f3a0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 29 return SYSCALL_CANCEL (poll, fds, nfds, timeout); Thread 33 (Thread 0x7ff9c8564700 (LWP 8824)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x207b5cc ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x207b560 , cond=0x207b5a0 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x207b5a0 , mutex=0x207b560 ) at pthread_cond_wait.c:655 #3 0x0000000000e21628 in native_cond_wait (mutex=0x207b560 , cond=0x207b5a0 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:147 #4 my_cond_wait (mp=0x207b560 , cond=0x207b5a0 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=152, that=0x207b5a0 , mutex=, src_file=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1191 #6 Per_thread_connection_handler::block_until_new_connection () at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/conn_handler/connection_handler_per_thread.cc:152 #7 0x0000000000e21928 in handle_connection (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/conn_handler/connection_handler_per_thread.cc:344 #8 0x00000000010004e4 in pfs_spawn_thread (arg=0x42e3af0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #9 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 32 (Thread 0x7ff9c85a6700 (LWP 8799)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7ff9c85a3e70, expected=0, futex_word=0x207cf8c ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7ff9c85a3e70, mutex=0x207cf00 , cond=0x207cf60 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x207cf60 , mutex=0x207cf00 , abstime=0x7ff9c85a3e70) at pthread_cond_wait.c:667 #3 0x0000000000f177ea in native_cond_timedwait (abstime=0x7ff9c85a3e70, mutex=0x207cf00 , cond=0x207cf60 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:136 #4 my_cond_timedwait (abstime=0x7ff9c85a3e70, mp=0x207cf00 , cond=0x207cf60 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:189 #5 inline_mysql_cond_timedwait (src_line=8227, abstime=0x7ff9c85a3e70, mutex=0x207cf00 , that=0x207cf60 , src_file=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1236 #6 MYSQL_BIN_LOG::wait_for_update_bin_log (this=0x207ca00 , thd=, timeout=0x7ff9c85a3e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/binlog.cc:8227 #7 0x0000000000f38c7e in Binlog_sender::wait_with_heartbeat (this=, log_pos=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:658 #8 Binlog_sender::wait_new_events (this=0x7ff9c85a4530, log_pos=292854) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:637 #9 Binlog_sender::get_binlog_end_pos (log_cache=0x7ff9c85a4370, this=0x7ff9c85a4530) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:403 #10 Binlog_sender::send_binlog (this=0x7ff9c85a4530, log_cache=, start_pos=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:351 #11 0x0000000000f38f07 in Binlog_sender::run (this=0x7ff9c85a4530) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:232 #12 0x0000000000f33842 in mysql_binlog_send (thd=, log_ident=, pos=, slave_gtid_executed=, flags=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_master.cc:421 #13 0x0000000000f351b0 in com_binlog_dump_gtid (thd=0x7ff948000d80, packet=0x4 , packet_length=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_master.cc:405 #14 0x0000000000d4e20f in dispatch_command (thd=0x7ff948000d80, com_data=0x7ff9c85a5dc0, command=COM_BINLOG_DUMP_GTID) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/sql_parse.cc:1706 #15 0x0000000000d4f854 in do_command (thd=0x7ff948000d80) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/sql_parse.cc:1032 #16 0x0000000000e21a8c in handle_connection (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/conn_handler/connection_handler_per_thread.cc:313 #17 0x00000000010004e4 in pfs_spawn_thread (arg=0x42e38c0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #18 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #19 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 31 (Thread 0x7ff9e0d2b700 (LWP 8748)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7ff99400a344) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7ff99400a2b0, cond=0x7ff99400a318) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7ff99400a318, mutex=0x7ff99400a2b0) at pthread_cond_wait.c:655 #3 0x0000000000f63376 in native_cond_wait (mutex=0x7ff99400a2b0, cond=0x7ff99400a318) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:147 #4 my_cond_wait (mp=0x7ff99400a2b0, cond=0x7ff99400a318) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=100, src_file=0x1739d90 "/export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave_commit_order_manager.cc", mutex=0x7ff99400a2b0, that=0x7ff99400a318) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1191 #6 Commit_order_manager::wait_for_its_turn (this=0x7ff99400a2b0, worker=0x7ff994023f90, all=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave_commit_order_manager.cc:100 #7 0x0000000000f2694d in MYSQL_BIN_LOG::ordered_commit (this=0x207ca00 , thd=0x7ff998000b60, all=true, skip_commit=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/binlog.cc:9582 #8 0x0000000000f2712d in MYSQL_BIN_LOG::commit (this=0x207ca00 , thd=0x7ff998000b60, all=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/binlog.cc:8874 #9 0x0000000000850118 in ha_commit_trans (thd=0x7ff998000b60, all=true, ignore_global_read_lock=false) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/handler.cc:1806 #10 0x0000000000e04dc9 in trans_commit (thd=0x7ff998000b60) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/transaction.cc:246 #11 0x0000000000efa552 in Xid_log_event::do_commit (this=0x7ff99415e5f0, thd_arg=0x7ff998000b60) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/log_event.cc:7133 #12 0x0000000000efa453 in Xid_apply_log_event::do_apply_event_worker (this=0x7ff99415e638, w=0x7ff994023f90) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/log_event.cc:7228 #13 0x0000000000f5e72e in Slave_worker::read_and_apply_events (this=0x7ff994023f90, start_relay_number=, start_relay_pos=295233, end_relay_number=2, end_relay_pos=295564) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_rli_pdb.cc:2087 #14 0x0000000000f5ec19 in Slave_worker::retry_transaction (this=0x7ff994023f90, start_relay_number=2, start_relay_pos=295233, end_relay_number=2, end_relay_pos=295564) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_rli_pdb.cc:1932 #15 0x0000000000f61069 in slave_worker_exec_job_group (worker=0x7ff994023f90, rli=0x424be70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_rli_pdb.cc:2682 #16 0x0000000000f491cb in handle_slave_worker (arg=0x7ff994023f90) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:6219 #17 0x00000000010004e4 in pfs_spawn_thread (arg=0x7ff99c033be0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #18 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #19 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 30 (Thread 0x7ff9e0d6d700 (LWP 8746)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x7ff994027294) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x7ff994027238, cond=0x7ff994027268) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x7ff994027268, mutex=0x7ff994027238) at pthread_cond_wait.c:655 #3 0x0000000000f41d36 in native_cond_wait (mutex=0x7ff994027238, cond=0x7ff994027268) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:147 #4 my_cond_wait (mp=0x7ff994027238, cond=0x7ff994027268) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=7112, mutex=0x7ff994027238, that=0x7ff994027268, src_file=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1191 #6 slave_stop_workers (rli=0x424be70, mts_inited=0x7ff9e0d6ce8f) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:7112 #7 0x0000000000f507db in handle_slave_sql (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:7554 #8 0x00000000010004e4 in pfs_spawn_thread (arg=0x7ff99c033be0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #9 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #10 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 29 (Thread 0x7ff9e0daf700 (LWP 8745)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7ff9e0dae910, expected=0, futex_word=0x41ffb78) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7ff9e0dae910, mutex=0x41ffa48, cond=0x41ffb50) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x41ffb50, mutex=0x41ffa48, abstime=0x7ff9e0dae910) at pthread_cond_wait.c:667 #3 0x0000000000f4291a in native_cond_timedwait (abstime=0x7ff9e0dae910, mutex=0x41ffa48, cond=0x41ffb50) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:136 #4 my_cond_timedwait (abstime=0x7ff9e0dae910, mp=0x41ffa48, cond=0x41ffb50) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:189 #5 inline_mysql_cond_timedwait (src_line=4330, abstime=0x7ff9e0dae910, mutex=0x41ffa48, that=0x41ffb50, src_file=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1236 #6 slave_sleep (info=0x41ff4f0, seconds=, thd=0x7ff9a0000bb0, func=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:4330 #7 connect_to_master (thd=0x7ff9a0000bb0, mysql=0x7ff9a000e300, mi=0x41ff4f0, reconnect=true, suppress_warnings=false) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:8952 #8 0x0000000000f49a9e in safe_reconnect (suppress_warnings=true, mi=0x41ff4f0, mysql=0x7ff9a000e300, thd=0x7ff9a0000bb0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:8994 #9 try_to_reconnect (thd=0x7ff9a0000bb0, mysql=0x7ff9a000e300, mi=0x41ff4f0, retry_count=, suppress_warnings=false, messages=0x1fbd820 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:5527 #10 0x0000000000f4afd7 in handle_slave_io (arg=0x41ff4f0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_slave.cc:5827 #11 0x00000000010004e4 in pfs_spawn_thread (arg=0x42e3640) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #12 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #13 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 28 (Thread 0x7ff9e0df1700 (LWP 8744)): #0 futex_abstimed_wait_cancelable (private=0, abstime=0x7ff9e0deee70, expected=0, futex_word=0x207cf8c ) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7ff9e0deee70, mutex=0x207cf00 , cond=0x207cf60 ) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x207cf60 , mutex=0x207cf00 , abstime=0x7ff9e0deee70) at pthread_cond_wait.c:667 #3 0x0000000000f177ea in native_cond_timedwait (abstime=0x7ff9e0deee70, mutex=0x207cf00 , cond=0x207cf60 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:136 #4 my_cond_timedwait (abstime=0x7ff9e0deee70, mp=0x207cf00 , cond=0x207cf60 ) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:189 #5 inline_mysql_cond_timedwait (src_line=8227, abstime=0x7ff9e0deee70, mutex=0x207cf00 , that=0x207cf60 , src_file=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1236 #6 MYSQL_BIN_LOG::wait_for_update_bin_log (this=0x207ca00 , thd=, timeout=0x7ff9e0deee70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/binlog.cc:8227 #7 0x0000000000f38c7e in Binlog_sender::wait_with_heartbeat (this=, log_pos=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:658 #8 Binlog_sender::wait_new_events (this=0x7ff9e0def530, log_pos=292854) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:637 #9 Binlog_sender::get_binlog_end_pos (log_cache=0x7ff9e0def370, this=0x7ff9e0def530) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:403 #10 Binlog_sender::send_binlog (this=0x7ff9e0def530, log_cache=, start_pos=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:351 #11 0x0000000000f38f07 in Binlog_sender::run (this=0x7ff9e0def530) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_binlog_sender.cc:232 #12 0x0000000000f33842 in mysql_binlog_send (thd=, log_ident=, pos=, slave_gtid_executed=, flags=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_master.cc:421 #13 0x0000000000f351b0 in com_binlog_dump_gtid (thd=0x7ff99c000d80, packet=0x4 , packet_length=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_master.cc:405 #14 0x0000000000d4e20f in dispatch_command (thd=0x7ff99c000d80, com_data=0x7ff9e0df0dc0, command=COM_BINLOG_DUMP_GTID) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/sql_parse.cc:1706 #15 0x0000000000d4f854 in do_command (thd=0x7ff99c000d80) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/sql_parse.cc:1032 #16 0x0000000000e21a8c in handle_connection (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/conn_handler/connection_handler_per_thread.cc:313 #17 0x00000000010004e4 in pfs_spawn_thread (arg=0x42e3640) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #18 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #19 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 27 (Thread 0x7ff9affff700 (LWP 8740)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x2049128 ) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x20490c0 , cond=0x2049100 ) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x2049100 , mutex=0x20490c0 ) at pthread_cond_wait.c:655 #3 0x0000000000ef3d15 in native_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:147 #4 my_cond_wait (mp=, cond=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/thr_cond.h:202 #5 inline_mysql_cond_wait (src_line=885, src_file=0x172db20 "/export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_gtid_persist.cc", mutex=, that=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/include/mysql/psi/mysql_thread.h:1191 #6 compress_gtid_table (p_thd=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/rpl_gtid_persist.cc:885 #7 0x00000000010004e4 in pfs_spawn_thread (arg=0x42a4400) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 26 (Thread 0x7ff9e0e33700 (LWP 8739)): #0 0x00007ff9ea0afc22 in __GI___sigtimedwait (set=set@entry=0x7ff9e0e32db0, info=info@entry=0x7ff9e0e32cf0, timeout=timeout@entry=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x00007ff9ea5e47ac in __sigwait (set=0x7ff9e0e32db0, sig=0x7ff9e0e32e8c) at ../sysdeps/unix/sysv/linux/sigwait.c:28 #2 0x00000000007f04bb in signal_hand (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/mysqld.cc:2132 #3 0x00000000010004e4 in pfs_spawn_thread (arg=0x42408a0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #4 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #5 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 25 (Thread 0x7ff9c8ff9700 (LWP 8696)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c10978) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c10928, cond=0x3c10950) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c10950, mutex=0x3c10928) at pthread_cond_wait.c:655 #3 0x00000000010f307b in os_event::wait (this=0x3c10918) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c10918, reset_sig_count=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:366 #5 0x000000000122310c in buf_resize_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/buf/buf0buf.cc:3027 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 24 (Thread 0x7ff9c97fa700 (LWP 8695)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ff9c97f98a0, expected=0, futex_word=0x413f878) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ff9c97f9ae0, mutex=0x413f828, cond=0x413f850) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x413f850, mutex=0x413f828, abstime=0x7ff9c97f9ae0) at pthread_cond_wait.c:667 #3 0x00000000010f384e in os_event::timed_wait (this=, abstime=0x7ff9c97f9ae0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:316 #4 0x00000000010f3b36 in os_event::wait_time_low (this=0x413f818, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:488 #5 0x00000000011df574 in ib_wqueue_timedwait (wq=0x4134618, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/ut/ut0wqueue.cc:168 #6 0x00000000012beeb2 in fts_optimize_thread (arg=0x4134618) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fts/fts0opt.cc:2910 #7 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 23 (Thread 0x7ff9c9ffb700 (LWP 8694)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ff9c9ffabc0, expected=0, futex_word=0x40f3738) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ff9c9ffae00, mutex=0x40f36e8, cond=0x40f3710) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x40f3710, mutex=0x40f36e8, abstime=0x7ff9c9ffae00) at pthread_cond_wait.c:667 #3 0x00000000010f384e in os_event::timed_wait (this=, abstime=0x7ff9c9ffae00) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:316 #4 0x00000000010f3b36 in os_event::wait_time_low (this=0x40f36d8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:488 #5 0x0000000001275fe4 in dict_stats_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/dict/dict0stats_bg.cc:435 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 22 (Thread 0x7ff9ca7fc700 (LWP 8693)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c10858) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c10808, cond=0x3c10830) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c10830, mutex=0x3c10808) at pthread_cond_wait.c:655 #3 0x00000000010f307b in os_event::wait (this=0x3c107f8) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c107f8, reset_sig_count=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:366 #5 0x000000000122cc3c in buf_dump_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/buf/buf0dump.cc:792 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 21 (Thread 0x7ff9caffd700 (LWP 8678)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c106ac) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c10658, cond=0x3c10680) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c10680, mutex=0x3c10658) at pthread_cond_wait.c:655 #3 0x00000000010f307b in os_event::wait (this=0x3c10648) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c10648, reset_sig_count=785267) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:366 #5 0x000000000118d42e in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2527 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 20 (Thread 0x7ff9cb7fe700 (LWP 8677)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c10618) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c105c8, cond=0x3c105f0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c105f0, mutex=0x3c105c8) at pthread_cond_wait.c:655 #3 0x00000000010f307b in os_event::wait (this=0x3c105b8) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c105b8, reset_sig_count=923076) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:366 #5 0x000000000118d42e in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2527 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 19 (Thread 0x7ff9cbfff700 (LWP 8676)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c1058c) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c10538, cond=0x3c10560) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c10560, mutex=0x3c10538) at pthread_cond_wait.c:655 #3 0x00000000010f307b in os_event::wait (this=0x3c10528) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c10528, reset_sig_count=1253079) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:366 #5 0x000000000118d42e in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2527 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 18 (Thread 0x7ff9d0f2c700 (LWP 8675)): #0 futex_wait_cancelable (private=0, expected=0, futex_word=0x3c104fc) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x3c104a8, cond=0x3c104d0) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x3c104d0, mutex=0x3c104a8) at pthread_cond_wait.c:655 #3 0x00000000010f307b in os_event::wait (this=0x3c10498) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:179 #4 os_event::wait_low (this=0x3c10498, reset_sig_count=261861) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:366 #5 0x000000000118fa9d in srv_purge_coordinator_suspend (rseg_history_len=12, slot=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2683 #6 srv_purge_coordinator_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2799 #7 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 17 (Thread 0x7ff9d172d700 (LWP 8674)): #0 0x00007ff9ea5e40b5 in __GI___nanosleep (requested_time=0x7ff9d172ce60, remaining=0x0) at ../sysdeps/unix/sysv/linux/nanosleep.c:28 #1 0x00000000010f3ff0 in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0thread.cc:287 #2 0x000000000118e147 in srv_master_sleep () at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2337 #3 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:2384 #4 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #5 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 16 (Thread 0x7ff9d1f2e700 (LWP 8673)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ff9d1f2dc20, expected=0, futex_word=0x3c107c8) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ff9d1f2de60, mutex=0x3c10778, cond=0x3c107a0) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x3c107a0, mutex=0x3c10778, abstime=0x7ff9d1f2de60) at pthread_cond_wait.c:667 #3 0x00000000010f384e in os_event::timed_wait (this=, abstime=0x7ff9d1f2de60) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:316 #4 0x00000000010f3b36 in os_event::wait_time_low (this=0x3c10768, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:488 #5 0x000000000118db35 in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:1592 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 15 (Thread 0x7ff9d272f700 (LWP 8672)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ff9d272e8b0, expected=0, futex_word=0x3c10738) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ff9d272eaf0, mutex=0x3c106e8, cond=0x3c10710) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x3c10710, mutex=0x3c106e8, abstime=0x7ff9d272eaf0) at pthread_cond_wait.c:667 #3 0x00000000010f384e in os_event::timed_wait (this=, abstime=0x7ff9d272eaf0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:316 #4 0x00000000010f3b36 in os_event::wait_time_low (this=0x3c106d8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:488 #5 0x000000000118ea05 in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0srv.cc:1758 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 14 (Thread 0x7ff9d2f30700 (LWP 8671)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ff9d2f2fba0, expected=0, futex_word=0x40b25fc) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ff9d2f2fde0, mutex=0x40b25a8, cond=0x40b25d0) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x40b25d0, mutex=0x40b25a8, abstime=0x7ff9d2f2fde0) at pthread_cond_wait.c:667 #3 0x00000000010f384e in os_event::timed_wait (this=, abstime=0x7ff9d2f2fde0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:316 #4 0x00000000010f3b36 in os_event::wait_time_low (this=0x40b2598, time_in_usec=, reset_sig_count=292) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:488 #5 0x00000000010ca5b4 in lock_wait_timeout_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/lock/lock0wait.cc:497 #6 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #7 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 13 (Thread 0x7ff9d3731700 (LWP 8636)): #0 futex_reltimed_wait_cancelable (private=0, reltime=0x7ff9d3730790, expected=0, futex_word=0x3c108ec) at ../sysdeps/unix/sysv/linux/futex-internal.h:142 #1 __pthread_cond_wait_common (abstime=0x7ff9d37309d0, mutex=0x3c10898, cond=0x3c108c0) at pthread_cond_wait.c:533 #2 __pthread_cond_timedwait (cond=0x3c108c0, mutex=0x3c10898, abstime=0x7ff9d37309d0) at pthread_cond_wait.c:667 #3 0x00000000010f384e in os_event::timed_wait (this=, abstime=0x7ff9d37309d0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:316 #4 0x00000000010f3b36 in os_event::wait_time_low (this=0x3c10888, time_in_usec=, reset_sig_count=2) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0event.cc:488 #5 0x000000000123335c in pc_sleep_if_needed (sig_count=2, next_loop_time=20055728) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/buf/buf0flu.cc:2700 #6 buf_flush_page_cleaner_coordinator (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/buf/buf0flu.cc:3201 #7 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #8 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 12 (Thread 0x7ff9d3f32700 (LWP 8635)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9e0efc000, min_nr=1, nr=256, events=0x3efb2a0, timeout=0x7ff9d3f31b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d3f31df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d3f31df0, m1=0x7ff9d3f31ea8, m2=0x7ff9d3f31ea0, request=0x7ff9d3f31e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d3f31e70, m2=0x7ff9d3f31ea0, m1=0x7ff9d3f31ea8, global_segment=9) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=9, m1=0x7ff9d3f31ea8, m2=0x7ff9d3f31ea0, request=0x7ff9d3f31e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=9) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 11 (Thread 0x7ff9d4733700 (LWP 8634)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9e0f01000, min_nr=1, nr=256, events=0x3ef92a0, timeout=0x7ff9d4732b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d4732df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d4732df0, m1=0x7ff9d4732ea8, m2=0x7ff9d4732ea0, request=0x7ff9d4732e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d4732e70, m2=0x7ff9d4732ea0, m1=0x7ff9d4732ea8, global_segment=8) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=8, m1=0x7ff9d4732ea8, m2=0x7ff9d4732ea0, request=0x7ff9d4732e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=8) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 10 (Thread 0x7ff9d4f34700 (LWP 8633)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9e0f06000, min_nr=1, nr=256, events=0x3ef72a0, timeout=0x7ff9d4f33b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d4f33df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d4f33df0, m1=0x7ff9d4f33ea8, m2=0x7ff9d4f33ea0, request=0x7ff9d4f33e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d4f33e70, m2=0x7ff9d4f33ea0, m1=0x7ff9d4f33ea8, global_segment=7) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=7, m1=0x7ff9d4f33ea8, m2=0x7ff9d4f33ea0, request=0x7ff9d4f33e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=7) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 9 (Thread 0x7ff9d5735700 (LWP 8632)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9e0f0b000, min_nr=1, nr=256, events=0x3ef52a0, timeout=0x7ff9d5734b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d5734df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d5734df0, m1=0x7ff9d5734ea8, m2=0x7ff9d5734ea0, request=0x7ff9d5734e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d5734e70, m2=0x7ff9d5734ea0, m1=0x7ff9d5734ea8, global_segment=6) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=6, m1=0x7ff9d5734ea8, m2=0x7ff9d5734ea0, request=0x7ff9d5734e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=6) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 8 (Thread 0x7ff9d5f36700 (LWP 8631)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9ea601000, min_nr=1, nr=256, events=0x3ecea00, timeout=0x7ff9d5f35b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d5f35df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d5f35df0, m1=0x7ff9d5f35ea8, m2=0x7ff9d5f35ea0, request=0x7ff9d5f35e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d5f35e70, m2=0x7ff9d5f35ea0, m1=0x7ff9d5f35ea8, global_segment=5) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=5, m1=0x7ff9d5f35ea8, m2=0x7ff9d5f35ea0, request=0x7ff9d5f35e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 7 (Thread 0x7ff9d6737700 (LWP 8630)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9ea606000, min_nr=1, nr=256, events=0x3ecca00, timeout=0x7ff9d6736b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d6736df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d6736df0, m1=0x7ff9d6736ea8, m2=0x7ff9d6736ea0, request=0x7ff9d6736e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d6736e70, m2=0x7ff9d6736ea0, m1=0x7ff9d6736ea8, global_segment=4) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=4, m1=0x7ff9d6736ea8, m2=0x7ff9d6736ea0, request=0x7ff9d6736e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 6 (Thread 0x7ff9d6f38700 (LWP 8629)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9ea60b000, min_nr=1, nr=256, events=0x3ecaa00, timeout=0x7ff9d6f37b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d6f37df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d6f37df0, m1=0x7ff9d6f37ea8, m2=0x7ff9d6f37ea0, request=0x7ff9d6f37e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d6f37e70, m2=0x7ff9d6f37ea0, m1=0x7ff9d6f37ea8, global_segment=3) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=3, m1=0x7ff9d6f37ea8, m2=0x7ff9d6f37ea0, request=0x7ff9d6f37e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7ff9d7739700 (LWP 8628)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9ea610000, min_nr=1, nr=256, events=0x3ec8a00, timeout=0x7ff9d7738b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d7738df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d7738df0, m1=0x7ff9d7738ea8, m2=0x7ff9d7738ea0, request=0x7ff9d7738e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d7738e70, m2=0x7ff9d7738ea0, m1=0x7ff9d7738ea8, global_segment=2) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=2, m1=0x7ff9d7738ea8, m2=0x7ff9d7738ea0, request=0x7ff9d7738e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7ff9d7f3a700 (LWP 8627)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9ea5f7000, min_nr=1, nr=256, events=0x3ef2fd0, timeout=0x7ff9d7f39b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9d7f39df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9d7f39df0, m1=0x7ff9d7f39ea8, m2=0x7ff9d7f39ea0, request=0x7ff9d7f39e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9d7f39e70, m2=0x7ff9d7f39ea0, m1=0x7ff9d7f39ea8, global_segment=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=1, m1=0x7ff9d7f39ea8, m2=0x7ff9d7f39ea0, request=0x7ff9d7f39e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7ff9e0baa700 (LWP 8626)): #0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38 #1 0x00007ff9ea5ce157 in __io_getevents_0_4 (ctx=0x7ff9ea5fc000, min_nr=1, nr=256, events=0x3ee0cf0, timeout=0x7ff9e0ba9b50) at io_getevents.c:25 #2 0x00000000010ec3c4 in LinuxAIOHandler::collect (this=0x7ff9e0ba9df0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2513 #3 0x00000000010ee604 in LinuxAIOHandler::poll (this=0x7ff9e0ba9df0, m1=0x7ff9e0ba9ea8, m2=0x7ff9e0ba9ea0, request=0x7ff9e0ba9e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2673 #4 0x00000000010ee9bc in os_aio_linux_handler (request=0x7ff9e0ba9e70, m2=0x7ff9e0ba9ea0, m1=0x7ff9e0ba9ea8, global_segment=0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:2729 #5 os_aio_handler (segment=0, m1=0x7ff9e0ba9ea8, m2=0x7ff9e0ba9ea0, request=0x7ff9e0ba9e70) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/os/os0file.cc:6275 #6 0x000000000128b4ed in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/fil/fil0fil.cc:5862 #7 0x0000000001190b40 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/innobase/srv/srv0start.cc:319 #8 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #9 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7ff9e24b3700 (LWP 8624)): #0 0x00007ff9ea0afc22 in __GI___sigtimedwait (set=0x7ff9e24b2e20, info=0x7ff9e24b2da0, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29 #1 0x0000000000f8947b in timer_notify_thread_func (arg=) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/mysys/posix_timers.c:89 #2 0x00000000010004e4 in pfs_spawn_thread (arg=0x3ba6310) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/storage/perfschema/pfs.cc:2197 #3 0x00007ff9ea5da4c0 in start_thread (arg=) at pthread_create.c:479 #4 0x00007ff9ea173133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7ff9ea072740 (LWP 8619)): #0 0x00007ff9ea1686c7 in __GI___poll (fds=0x417f3a0, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x0000000000e22df9 in Mysqld_socket_listener::listen_for_connection_event (this=0x417f340) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/conn_handler/socket_connection.cc:859 #2 0x00000000007f5964 in Connection_acceptor::connection_event_loop (this=0x417fa00) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/conn_handler/connection_acceptor.h:73 #3 mysqld_main (argc=41, argv=0x3a7dd28) at /export/home/pb2/build/sb_0-36131509-1569573142.98/mysql-5.7.28/sql/mysqld.cc:5128 #4 0x00007ff9ea09af43 in __libc_start_main (main=0x7eb240 , argc=10, argv=0x7ffc3e880a88, init=, fini=, rtld_fini=, stack_end=0x7ffc3e880a78) at ../csu/libc-start.c:308 #5 0x00000000007eb179 in _start () [Inferior 1 (process 8619) detached] [anon@fc30 mysql]$