-- 8.0.17 - innodb_autoinc_lock_mode's default Value (>= 8.0.3) - 2 ./mtr --debug-server bug96578 Logging: ./mtr --debug-server bug96578 MySQL Version 8.0.17 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [100%] main.bug96578 [ fail ] Test ended at 2019-08-17 07:53:41 CURRENT_TEST: main.bug96578 mysqltest: At line 30: Query 'reap' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query safe_process[6409]: Child process: 6410, exit: 1 Server [mysqld.1 - pid: 6362, winpid: 6362, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2019-08-17T05:53:37.098499Z 0 [Warning] [MY-010099] [Server] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2019-08-17T05:53:37.098536Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2019-08-17T05:53:37.098620Z 0 [Note] [MY-010949] [Server] Basedir set to /export/umesh/server/binaries/GABuilds/mysql-8.0.17/. 2019-08-17T05:53:37.098647Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug (mysqld 8.0.17-debug) starting as process 6363 2019-08-17T05:53:37.114237Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2019-08-17T05:53:37.114893Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2019-08-17T05:53:37.120602Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2019-08-17T05:53:37.120671Z 1 [Note] [MY-012937] [InnoDB] !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-08-17T05:53:37.120697Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins 2019-08-17T05:53:37.120719Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2019-08-17T05:53:37.120746Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2019-08-17T05:53:37.120784Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11 2019-08-17T05:53:37.121403Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2019-08-17T05:53:37.121678Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions 2019-08-17T05:53:37.122590Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './;./;./' 2019-08-17T05:53:37.122731Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2019-08-17T05:53:37.123844Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 6 files. 2019-08-17T05:53:37.125063Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 24.000000M, instances = 1, chunk size =24.000000M 2019-08-17T05:53:37.139195Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2019-08-17T05:53:37.140677Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-08-17T05:53:37.254276Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 19459104, whereas checkpoint_lsn = 19459366 2019-08-17T05:53:37.259850Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2019-08-17T05:53:37.260456Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2019-08-17T05:53:37.260494Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2019-08-17T05:53:37.260873Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2019-08-17T05:53:37.261214Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2019-08-17T05:53:37.281221Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2019-08-17T05:53:37.281289Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1271 2019-08-17T05:53:37.369459Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2019-08-17T05:53:37.369600Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-08-17T05:53:37.385475Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2019-08-17T05:53:37.385920Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2019-08-17T05:53:37.468925Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2019-08-17T05:53:37.469615Z 1 [Note] [MY-012976] [InnoDB] 8.0.17 started; log sequence number 19459366 2019-08-17T05:53:37.537794Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80017'. 2019-08-17T05:53:38.609895Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2019-08-17T05:53:38.617129Z 1 [Note] [MY-012356] [InnoDB] Validated 8/8 tablespaces 2019-08-17T05:53:38.618471Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/mysqld.1/data/ib_buffer_pool 2019-08-17T05:53:38.627438Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 190817 8:53:38 2019-08-17T05:53:38.759132Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80017'. 2019-08-17T05:53:39.737164Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege. 2019-08-17T05:53:39.797175Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2019-08-17T05:53:39.797393Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2019-08-17T05:53:39.820244Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5caf9655-c0b3-11e9-a6ec-0010e05f3e06. 2019-08-17T05:53:39.824598Z 0 [Note] [MY-010303] [Server] Skipping generation of SSL certificates as options related to SSL are specified. 2019-08-17T05:53:39.826606Z 0 [Warning] [MY-010068] [Server] CA certificate /export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/std_data/cacert.pem is self signed. 2019-08-17T05:53:39.826689Z 0 [Note] [MY-010310] [Server] Skipping generation of RSA key pair as --sha256_password_auto_generate_rsa_keys is set to OFF. 2019-08-17T05:53:39.826719Z 0 [Note] [MY-010310] [Server] Skipping generation of RSA key pair as --caching_sha2_password_auto_generate_rsa_keys is set to OFF. 2019-08-17T05:53:39.827048Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 13000 2019-08-17T05:53:39.827119Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2019-08-17T05:53:39.827156Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2019-08-17T05:53:39.827211Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2019-08-17T05:53:39.845361Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-mysqlx-ssl=DISABLED'. 2019-08-17T05:53:39.980896Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''. 2019-08-17T05:53:39.996357Z 4 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 4 2019-08-17T05:53:39.997763Z 0 [System] [MY-010931] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug: ready for connections. Version: '8.0.17-debug' socket: '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - GPL - Debug. 2019-08-17T05:53:40.027111Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2019-08-17T05:53:40.028081Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2019-08-17T05:53:40.028204Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2019-08-17T05:53:40.029119Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 13010' 2019-08-17T05:53:40.029166Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/tmp/mysqlx.1.sock'' 2019-08-17T05:53:40.029200Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/tmp/mysqlx.1.sock' bind-address: '::' port: 13010 mysqld-debug: ../../mysql-8.0.17/sql/handler.cc:3588: int handler::update_auto_increment(): Assertion `next_insert_id >= auto_inc_interval_for_cur_row.minimum()' failed. 05:53:40 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7fa6880241a0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fa7388a1d00 thread_stack 0x46000 /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(my_print_stacktrace(unsigned char*, unsigned long)+0x43) [0x40480bf] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(handle_fatal_signal+0x291) [0x2e25c24] /lib64/libpthread.so.0(+0xf130) [0x7fa7476f7130] /lib64/libc.so.6(gsignal+0x37) [0x7fa745a435d7] /lib64/libc.so.6(abort+0x148) [0x7fa745a44cc8] /lib64/libc.so.6(+0x2e546) [0x7fa745a3c546] /lib64/libc.so.6(+0x2e5f2) [0x7fa745a3c5f2] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(handler::update_auto_increment()+0xf5) [0x2fc01c3] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(ha_innobase::write_row(unsigned char*)+0x3d6) [0x4142c0e] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(handler::ha_write_row(unsigned char*)+0x222) [0x2fca51a] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x199) [0x326aab6] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(Query_result_insert::send_data(THD*, List&)+0x192) [0x326c42a] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug() [0x2bf94e4] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug() [0x2bf960f] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(JOIN::exec()+0x6ce) [0x2bf07ba] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(Sql_cmd_dml::execute_inner(THD*)+0x156) [0x2cc6d66] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(Sql_cmd_dml::execute(THD*)+0x405) [0x2cc63e5] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(mysql_execute_command(THD*, bool)+0x2491) [0x2c60dc5] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(mysql_parse(THD*, Parser_state*)+0x646) [0x2c669e8] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1448) [0x2c5c01d] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug(do_command(THD*)+0x450) [0x2c5a5b5] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug() [0x2e11aab] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug() [0x47b3694] /lib64/libpthread.so.0(+0x7df5) [0x7fa7476efdf5] /lib64/libc.so.6(clone+0x6d) [0x7fa745b0460d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fa68816d1a8): insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c) Connection ID (thread ID): 9 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file safe_process[6362]: Child process: 6363, killed by signal: 6 ----------SERVER LOG END------------- Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; create table temp1 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp1 values (1, 'b1', 'c1'), (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); create table temp2 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp2 values (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); CREATE TABLE extra ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL, PRIMARY KEY (id), UNIQUE KEY uniq_idx (a,b) ) engine = innodb; Warnings: Warning 1681 Integer display width is deprecated and will be removed in a future release. set DEBUG_SYNC = "ha_write_row_end WAIT_FOR flushed EXECUTE 1"; insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c); insert into extra(a, b, c) select * from temp2 on duplicate key update c=values(c); set DEBUG_SYNC = "now SIGNAL flushed"; ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/mysql-test/var/log/main.bug96578/bug96578.log' - found 'core.6363' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 6407] [New LWP 6411] [New LWP 6369] [New LWP 6370] [New LWP 6372] [New LWP 6374] [New LWP 6376] [New LWP 6377] [New LWP 6367] [New LWP 6408] [New LWP 6366] [New LWP 6383] [New LWP 6371] [New LWP 6375] [New LWP 6392] [New LWP 6378] [New LWP 6394] [New LWP 6368] [New LWP 6400] [New LWP 6391] [New LWP 6398] [New LWP 6386] [New LWP 6388] [New LWP 6406] [New LWP 6385] [New LWP 6397] [New LWP 6393] [New LWP 6401] [New LWP 6373] [New LWP 6380] [New LWP 6381] [New LWP 6390] [New LWP 6389] [New LWP 6384] [New LWP 6382] [New LWP 6387] [New LWP 6363] [New LWP 6404] [New LWP 6399] [New LWP 6405] [New LWP 6379] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld-debug --defaults'. Program terminated with signal 6, Aborted. #0 0x00007fa7476f4771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007fa7476f4771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000004048186 in my_write_core (sig=6) at ../../mysql-8.0.17/mysys/stacktrace.cc:305 #2 0x0000000002e25dc3 in handle_fatal_signal (sig=6) at ../../mysql-8.0.17/sql/signal_handler.cc:168 #3 #4 0x00007fa745a435d7 in raise () from /lib64/libc.so.6 #5 0x00007fa745a44cc8 in abort () from /lib64/libc.so.6 #6 0x00007fa745a3c546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fa745a3c5f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000002fc01c3 in handler::update_auto_increment (this=0x7fa6884a53d8) at ../../mysql-8.0.17/sql/handler.cc:3588 #9 0x0000000004142c0e in ha_innobase::write_row (this=0x7fa6884a53d8, record=0x7fa6884a7038 "") at ../../../mysql-8.0.17/storage/innobase/handler/ha_innodb.cc:8563 #10 0x0000000002fca51a in handler::ha_write_row (this=0x7fa6884a53d8, buf=0x7fa6884a7038 "") at ../../mysql-8.0.17/sql/handler.cc:7738 #11 0x000000000326aab6 in write_record (thd=0x7fa6880241a0, table=0x7fa68836d100, info=0x7fa6882c8f88, update=0x7fa6882c9000) at ../../mysql-8.0.17/sql/sql_insert.cc:1609 #12 0x000000000326c42a in Query_result_insert::send_data (this=0x7fa6882c8f40, thd=0x7fa6880241a0, values=...) at ../../mysql-8.0.17/sql/sql_insert.cc:2129 #13 0x0000000002bf94e4 in ExecuteIteratorQuery (join=0x7fa6882c95c0) at ../../mysql-8.0.17/sql/sql_executor.cc:2608 #14 0x0000000002bf960f in do_select (join=0x7fa6882c95c0) at ../../mysql-8.0.17/sql/sql_executor.cc:2640 #15 0x0000000002bf07ba in JOIN::exec (this=0x7fa6882c95c0) at ../../mysql-8.0.17/sql/sql_executor.cc:311 #16 0x0000000002cc6d66 in Sql_cmd_dml::execute_inner (this=0x7fa6882c86d0, thd=0x7fa6880241a0) at ../../mysql-8.0.17/sql/sql_select.cc:904 #17 0x0000000002cc63e5 in Sql_cmd_dml::execute (this=0x7fa6882c86d0, thd=0x7fa6880241a0) at ../../mysql-8.0.17/sql/sql_select.cc:700 #18 0x0000000002c60dc5 in mysql_execute_command (thd=0x7fa6880241a0, first_level=true) at ../../mysql-8.0.17/sql/sql_parse.cc:3433 #19 0x0000000002c669e8 in mysql_parse (thd=0x7fa6880241a0, parser_state=0x7fa7388a0c30) at ../../mysql-8.0.17/sql/sql_parse.cc:5221 #20 0x0000000002c5c01d in dispatch_command (thd=0x7fa6880241a0, com_data=0x7fa7388a1cd0, command=COM_QUERY) at ../../mysql-8.0.17/sql/sql_parse.cc:1755 #21 0x0000000002c5a5b5 in do_command (thd=0x7fa6880241a0) at ../../mysql-8.0.17/sql/sql_parse.cc:1270 #22 0x0000000002e11aab in handle_connection (arg=0x896bd60) at ../../mysql-8.0.17/sql/conn_handler/connection_handler_per_thread.cc:302 #23 0x00000000047b3694 in pfs_spawn_thread (arg=0x8c1aae0) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #24 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #25 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 41 (Thread 0x7fa6fbfff700 (LWP 6379)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734416508, abstime=0x7fa6fbffe900) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734416508, time_in_usec=1000, reset_sig_count=272) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734416508, time_in_usec=1000, reset_sig_count=272) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004285943 in os_event_wait_for >(os_event_t &, uint64_t, uint64_t, ) (event=@0x7fa6fbffeaa8: 0x7fa734416508, spins_limit=0, timeout=1000, condition=...) at ../../../mysql-8.0.17/storage/innobase/include/os0event.ic:138 #5 0x000000000428512e in Log_thread_waiting::wait >() (this=0x7fa6fbffeaa0, stop_condition=...) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:1004 #6 0x0000000004283953 in log_flush_notifier (log_ptr=0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:2451 #7 0x0000000004254028 in std::__invoke_impl (__f=@0x7fa6fbffec80: 0x428365f , __args#0=@0x7fa6fbffec88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x0000000004253f9d in std::__invoke (__fn=@0x7fa6fbffec80: 0x428365f , __args#0=@0x7fa6fbffec88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x0000000004253eba in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa6fbffec80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x0000000004253d84 in std::_Bind::operator()<, void>() (this=0x7fa6fbffec80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x0000000004253b31 in Runnable::operator()(void (*&&)(log_t*), log_t*&&) (this=0x7fa73441da98, f=@0x7fa73441da90: 0x428365f , args#0=@0x7fa73441da88: 0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x000000000425330f in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(log_t*), log_t*&&) (__f=..., __args#0=@0x7fa73441da90: 0x428365f , __args#1=@0x7fa73441da88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000042521ef in std::__invoke(Runnable&&, void (*&&)(log_t*), log_t*&&) (__fn=..., __args#0=@0x7fa73441da90: 0x428365f , __args#1=@0x7fa73441da88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000042541ab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa73441da88) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x000000000425414a in std::thread::_Invoker >::operator() (this=0x7fa73441da88) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000042540b6 in std::thread::_State_impl > >::_M_run (this=0x7fa73441da80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 40 (Thread 0x7fa7388e9700 (LWP 6405)): #0 0x00007fa745a447da in sigwaitinfo () from /lib64/libc.so.6 #1 0x0000000002ad448c in signal_hand (arg=0x0) at ../../mysql-8.0.17/sql/mysqld.cc:3258 #2 0x00000000047b3694 in pfs_spawn_thread (arg=0x8c1aae0) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #3 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 39 (Thread 0x7fa6af5fe700 (LWP 6399)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a4906 in os_event::wait (this=0x7fa734024a48) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:189 #2 0x00000000042a37f4 in os_event::wait_low (this=0x7fa734024a48, reset_sig_count=2) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:371 #3 0x00000000042a3e03 in os_event_wait_low (event=0x7fa734024a48, reset_sig_count=0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:606 #4 0x00000000043aba14 in srv_worker_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2749 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6af5fdcb0: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6af5fdcb0: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6af5fdcb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6af5fdcb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x89efc90, f=@0x89efc88: 0x43ab8a3 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x89efc88: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x89efc88: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x89efc88) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x89efc88) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x89efc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 38 (Thread 0x7fa738930700 (LWP 6404)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000004048c2f in native_cond_wait (cond=0x8ba6d10, mutex=0x8bc2518) at ../../mysql-8.0.17/include/thr_cond.h:109 #2 0x0000000004048d9a in safe_cond_wait (cond=0x8ba6d10, mp=0x8bc24f0, file=0x5376760 "../../mysql-8.0.17/sql/event_queue.cc", line=729) at ../../mysql-8.0.17/mysys/thr_cond.cc:71 #3 0x00000000032961fa in my_cond_wait (cond=0x8ba6d10, mp=0x8ba6ce0, file=0x5376760 "../../mysql-8.0.17/sql/event_queue.cc", line=729) at ../../mysql-8.0.17/include/thr_cond.h:160 #4 0x00000000032962f3 in inline_mysql_cond_wait (that=0x8ba6d10, mutex=0x8ba6ce0, src_file=0x5376760 "../../mysql-8.0.17/sql/event_queue.cc", src_line=729) at ../../mysql-8.0.17/include/mysql/psi/mysql_cond.h:174 #5 0x0000000003298527 in Event_queue::cond_wait (this=0x8ba6ce0, thd=0x8c12a50, abstime=0x0, stage=0x6d4a4c0 , src_func=0x53779f0 "get_top_for_execution_if_time", src_file=0x5376760 "../../mysql-8.0.17/sql/event_queue.cc", src_line=565) at ../../mysql-8.0.17/sql/event_queue.cc:729 #6 0x0000000003297c5c in Event_queue::get_top_for_execution_if_time (this=0x8ba6ce0, thd=0x8c12a50, event_name=0x7fa73892fc98) at ../../mysql-8.0.17/sql/event_queue.cc:564 #7 0x000000000329c468 in Event_scheduler::run (this=0x8ba6db0, thd=0x8c12a50) at ../../mysql-8.0.17/sql/event_scheduler.cc:549 #8 0x000000000329b417 in event_scheduler_thread (arg=0x8be47f0) at ../../mysql-8.0.17/sql/event_scheduler.cc:269 #9 0x00000000047b3694 in pfs_spawn_thread (arg=0x8c1aae0) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #10 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #11 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 37 (Thread 0x7fa747afb880 (LWP 6363)): #0 0x00007fa745afa00d in poll () from /lib64/libc.so.6 #1 0x0000000002e15d3f in Mysqld_socket_listener::listen_for_connection_event (this=0x89eb920) at ../../mysql-8.0.17/sql/conn_handler/socket_connection.cc:1328 #2 0x0000000002aedd6c in Connection_acceptor::connection_event_loop (this=0x89f0050) at ../../mysql-8.0.17/sql/conn_handler/connection_acceptor.h:64 #3 0x0000000002ae0c45 in mysqld_main (argc=69, argv=0x872f078) at ../../mysql-8.0.17/sql/mysqld.cc:6978 #4 0x0000000002ace1b2 in main (argc=6, argv=0x7ffcaeeb83f8) at ../../mysql-8.0.17/sql/main.cc:25 Thread 36 (Thread 0x7fa6dabfd700 (LWP 6387)): #0 0x00007fa7476f699d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000002bbac33 in std::this_thread::sleep_for > (__rtime=...) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:379 #2 0x00000000043ab09e in srv_master_sleep () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2517 #3 0x00000000043ab4d9 in srv_master_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2599 #4 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6dabfccb0: 0x43ab3bf ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #5 0x000000000418c988 in std::__invoke (__fn=@0x7fa6dabfccb0: 0x43ab3bf ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #6 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6dabfccb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #7 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6dabfccb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #8 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa7347217d0, f=@0x7fa7347217c8: 0x43ab3bf ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #9 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa7347217c8: 0x43ab3bf ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #10 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa7347217c8: 0x43ab3bf ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #11 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa7347217c8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #12 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa7347217c8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #13 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa7347217c0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #14 0x0000000004ad9ecf in execute_native_thread_routine () #15 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #16 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x7fa6fa1fc700 (LWP 6382)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa7344165a8, abstime=0x7fa6fa1fb970) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa7344165a8, time_in_usec=1000, reset_sig_count=34) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa7344165a8, time_in_usec=1000, reset_sig_count=34) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004285640 in os_event_wait_for >(os_event_t &, uint64_t, uint64_t, ) (event=@0x7fa6fa1fbb38: 0x7fa7344165a8, spins_limit=0, timeout=1000, condition=...) at ../../../mysql-8.0.17/storage/innobase/include/os0event.ic:138 #5 0x0000000004284e1b in Log_thread_waiting::wait >() (this=0x7fa6fa1fbb30, stop_condition=...) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:1004 #6 0x0000000004280d4f in log_writer (log_ptr=0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:1974 #7 0x0000000004254028 in std::__invoke_impl (__f=@0x7fa6fa1fbc80: 0x4280c29 , __args#0=@0x7fa6fa1fbc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x0000000004253f9d in std::__invoke (__fn=@0x7fa6fa1fbc80: 0x4280c29 , __args#0=@0x7fa6fa1fbc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x0000000004253eba in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa6fa1fbc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x0000000004253d84 in std::_Bind::operator()<, void>() (this=0x7fa6fa1fbc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x0000000004253b31 in Runnable::operator()(void (*&&)(log_t*), log_t*&&) (this=0x7fa7344e0028, f=@0x7fa7344e0020: 0x4280c29 , args#0=@0x7fa7344e0018: 0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x000000000425330f in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(log_t*), log_t*&&) (__f=..., __args#0=@0x7fa7344e0020: 0x4280c29 , __args#1=@0x7fa7344e0018: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000042521ef in std::__invoke(Runnable&&, void (*&&)(log_t*), log_t*&&) (__fn=..., __args#0=@0x7fa7344e0020: 0x4280c29 , __args#1=@0x7fa7344e0018: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000042541ab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa7344e0018) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x000000000425414a in std::thread::_Invoker >::operator() (this=0x7fa7344e0018) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000042540b6 in std::thread::_State_impl > >::_M_run (this=0x7fa7344e0010) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x7fa6f8dfa700 (LWP 6384)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734024c28, abstime=0x7fa6f8df9840) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734024c28, time_in_usec=1000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734024c28, time_in_usec=1000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x00000000043a9344 in srv_error_monitor_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:1774 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6f8df9cb0: 0x43a9112 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6f8df9cb0: 0x43a9112 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6f8df9cb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6f8df9cb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa734568400, f=@0x7fa7345683f8: 0x43a9112 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa7345683f8: 0x43a9112 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa7345683f8: 0x43a9112 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa7345683f8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa7345683f8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa7345683f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x7fa6d97fb700 (LWP 6389)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734b886d8, abstime=0x7fa6d97fab80) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734b886d8, time_in_usec=10000000, reset_sig_count=4) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734b886d8, time_in_usec=10000000, reset_sig_count=0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x00000000045b9ebd in dict_stats_thread () at ../../../mysql-8.0.17/storage/innobase/dict/dict0stats_bg.cc:372 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6d97facb0: 0x45b9e43 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6d97facb0: 0x45b9e43 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6d97facb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6d97facb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa734b69540, f=@0x7fa734b69538: 0x45b9e43 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa734b69538: 0x45b9e43 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa734b69538: 0x45b9e43 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa734b69538) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa734b69538) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa734b69530) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x7fa6d8dfa700 (LWP 6390)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734b00538, abstime=0x7fa6d8df98f0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734b00538, time_in_usec=5000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734b00538, time_in_usec=5000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004442717 in ib_wqueue_timedwait (wq=0x7fa734acbee8, wait_in_usecs=5000000) at ../../../mysql-8.0.17/storage/innobase/ut/ut0wqueue.cc:116 #5 0x000000000464665d in fts_optimize_thread (wq=0x7fa734acbee8) at ../../../mysql-8.0.17/storage/innobase/fts/fts0opt.cc:2844 #6 0x0000000004647ea0 in std::__invoke_impl (__f=@0x7fa6d8df9c80: 0x4646461 , __args#0=@0x7fa6d8df9c88: 0x7fa734acbee8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #7 0x0000000004647e15 in std::__invoke (__fn=@0x7fa6d8df9c80: 0x4646461 , __args#0=@0x7fa6d8df9c88: 0x7fa734acbee8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #8 0x0000000004647d32 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa6d8df9c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #9 0x0000000004647c60 in std::_Bind::operator()<, void>() (this=0x7fa6d8df9c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #10 0x0000000004647b47 in Runnable::operator()(void (*&&)(ib_wqueue_t*), ib_wqueue_t*&&) (this=0x7fa734b00618, f=@0x7fa734b00610: 0x4646461 , args#0=@0x7fa734b00608: 0x7fa734acbee8) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #11 0x00000000046478fd in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(ib_wqueue_t*), ib_wqueue_t*&&) (__f=..., __args#0=@0x7fa734b00610: 0x4646461 , __args#1=@0x7fa734b00608: 0x7fa734acbee8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #12 0x0000000004647409 in std::__invoke(Runnable&&, void (*&&)(ib_wqueue_t*), ib_wqueue_t*&&) (__fn=..., __args#0=@0x7fa734b00610: 0x4646461 , __args#1=@0x7fa734b00608: 0x7fa734acbee8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #13 0x0000000004647fab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734b00608) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #14 0x0000000004647f4a in std::thread::_Invoker >::operator() (this=0x7fa734b00608) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #15 0x0000000004647f2e in std::thread::_State_impl > >::_M_run (this=0x7fa734b00600) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #16 0x0000000004ad9ecf in execute_native_thread_routine () #17 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #18 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7fa6fabfd700 (LWP 6381)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734416468, abstime=0x7fa6fabfc900) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734416468, time_in_usec=1000, reset_sig_count=530) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734416468, time_in_usec=1000, reset_sig_count=530) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004285842 in os_event_wait_for >(os_event_t &, uint64_t, uint64_t, ) (event=@0x7fa6fabfcaa8: 0x7fa734416468, spins_limit=0, timeout=1000, condition=...) at ../../../mysql-8.0.17/storage/innobase/include/os0event.ic:138 #5 0x0000000004285028 in Log_thread_waiting::wait >() (this=0x7fa6fabfcaa0, stop_condition=...) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:1004 #6 0x0000000004282d6b in log_write_notifier (log_ptr=0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:2351 #7 0x0000000004254028 in std::__invoke_impl (__f=@0x7fa6fabfcc80: 0x4282a77 , __args#0=@0x7fa6fabfcc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x0000000004253f9d in std::__invoke (__fn=@0x7fa6fabfcc80: 0x4282a77 , __args#0=@0x7fa6fabfcc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x0000000004253eba in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa6fabfcc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x0000000004253d84 in std::_Bind::operator()<, void>() (this=0x7fa6fabfcc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x0000000004253b31 in Runnable::operator()(void (*&&)(log_t*), log_t*&&) (this=0x7fa7344dfdd8, f=@0x7fa7344dfdd0: 0x4282a77 , args#0=@0x7fa7344dfdc8: 0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x000000000425330f in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(log_t*), log_t*&&) (__f=..., __args#0=@0x7fa7344dfdd0: 0x4282a77 , __args#1=@0x7fa7344dfdc8: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000042521ef in std::__invoke(Runnable&&, void (*&&)(log_t*), log_t*&&) (__fn=..., __args#0=@0x7fa7344dfdd0: 0x4282a77 , __args#1=@0x7fa7344dfdc8: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000042541ab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa7344dfdc8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x000000000425414a in std::thread::_Invoker >::operator() (this=0x7fa7344dfdc8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000042540b6 in std::thread::_State_impl > >::_M_run (this=0x7fa7344dfdc0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7fa6fb5fe700 (LWP 6380)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734416648, abstime=0x7fa6fb5fd930) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734416648, time_in_usec=1000, reset_sig_count=1008) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734416648, time_in_usec=1000, reset_sig_count=1008) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004285741 in os_event_wait_for >(os_event_t &, uint64_t, uint64_t, ) (event=@0x7fa6fb5fdae8: 0x7fa734416648, spins_limit=0, timeout=1000, condition=...) at ../../../mysql-8.0.17/storage/innobase/include/os0event.ic:138 #5 0x0000000004284f22 in Log_thread_waiting::wait >() (this=0x7fa6fb5fdae0, stop_condition=...) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:1004 #6 0x0000000004282458 in log_flusher (log_ptr=0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:2273 #7 0x0000000004254028 in std::__invoke_impl (__f=@0x7fa6fb5fdc80: 0x42820e8 , __args#0=@0x7fa6fb5fdc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x0000000004253f9d in std::__invoke (__fn=@0x7fa6fb5fdc80: 0x42820e8 , __args#0=@0x7fa6fb5fdc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x0000000004253eba in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa6fb5fdc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x0000000004253d84 in std::_Bind::operator()<, void>() (this=0x7fa6fb5fdc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x0000000004253b31 in Runnable::operator()(void (*&&)(log_t*), log_t*&&) (this=0x7fa7344dfb88, f=@0x7fa7344dfb80: 0x42820e8 , args#0=@0x7fa7344dfb78: 0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x000000000425330f in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(log_t*), log_t*&&) (__f=..., __args#0=@0x7fa7344dfb80: 0x42820e8 , __args#1=@0x7fa7344dfb78: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000042521ef in std::__invoke(Runnable&&, void (*&&)(log_t*), log_t*&&) (__fn=..., __args#0=@0x7fa7344dfb80: 0x42820e8 , __args#1=@0x7fa7344dfb78: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000042541ab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa7344dfb78) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x000000000425414a in std::thread::_Invoker >::operator() (this=0x7fa7344dfb78) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000042540b6 in std::thread::_State_impl > >::_M_run (this=0x7fa7344dfb70) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7fa71e1fc700 (LWP 6373)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa71e1fba70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa71e1fba70, m1=0x7fa71e1fbb48, m2=0x7fa71e1fbb08, request=0x7fa71e1fbb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=7, m1=0x7fa71e1fbb48, m2=0x7fa71e1fbb08, request=0x7fa71e1fbb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=7, m1=0x7fa71e1fbb48, m2=0x7fa71e1fbb08, request=0x7fa71e1fbb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=7) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=7) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa71e1fbc80: 0x43b2122 , __args#0=@0x7fa71e1fbc88: 7) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa71e1fbc80: 0x43b2122 , __args#0=@0x7fa71e1fbc88: 7) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa71e1fbc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa71e1fbc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734413b58, f=@0x7fa734413b50: 0x43b2122 , args#0=@0x7fa734413b48: 7) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734413b50: 0x43b2122 , __args#1=@0x7fa734413b48: 7) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734413b50: 0x43b2122 , __args#1=@0x7fa734413b48: 7) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734413b48) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734413b48) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734413b40) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7fa6ae1fc700 (LWP 6401)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a4906 in os_event::wait (this=0x7fa734024b88) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:189 #2 0x00000000042a37f4 in os_event::wait_low (this=0x7fa734024b88, reset_sig_count=2) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:371 #3 0x00000000042a3e03 in os_event_wait_low (event=0x7fa734024b88, reset_sig_count=0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:606 #4 0x00000000043aba14 in srv_worker_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2749 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6ae1fbcb0: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6ae1fbcb0: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6ae1fbcb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6ae1fbcb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x89f1740, f=@0x89f1738: 0x43ab8a3 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x89f1738: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x89f1738: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x89f1738) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x89f1738) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x89f1730) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7fa7389bc700 (LWP 6393)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000004048c2f in native_cond_wait (cond=0x89e7a18, mutex=0x89e7a88) at ../../mysql-8.0.17/include/thr_cond.h:109 #2 0x0000000004048d9a in safe_cond_wait (cond=0x89e7a18, mp=0x89e7a60, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=35) at ../../mysql-8.0.17/mysys/thr_cond.cc:71 #3 0x00000000048a24df in my_cond_wait (cond=0x89e7a18, mp=0x89e79e8, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=35) at ../../../mysql-8.0.17/include/thr_cond.h:160 #4 0x00000000048a25d8 in inline_mysql_cond_wait (that=0x89e7a18, mutex=0x89e79e8, src_file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", src_line=35) at ../../../mysql-8.0.17/include/mysql/psi/mysql_cond.h:174 #5 0x00000000048a27de in xpl::Cond::wait (this=0x89e7a18, mutex=...) at ../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc:35 #6 0x000000000489961b in xpl::Synchronize::Block::wait (this=0x7fa7389bbba0) at ../../../mysql-8.0.17/plugin/x/src/helper/multithread/synchronize.h:49 #7 0x00000000049505db in xpl::Broker_task::wait_for_data_and_swap_queues (this=0x89e7ad0, out_workers_queue=0x7fa7389bbbe0) at ../../../mysql-8.0.17/plugin/x/src/mq/broker_task.cc:113 #8 0x00000000049504b8 in xpl::Broker_task::loop (this=0x89e7ad0) at ../../../mysql-8.0.17/plugin/x/src/mq/broker_task.cc:90 #9 0x0000000004896efd in ngs::Server::run_task (this=0x89e7208, handler=std::shared_ptr (count 3, weak 0) 0x89e7ad0) at ../../../mysql-8.0.17/plugin/x/ngs/src/server.cc:104 #10 0x00000000048970da in ngs::Server::::operator()(void) const (__closure=0x7fa6b00058c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/server.cc:135 #11 0x0000000004898dbe in std::_Function_handler >::_M_invoke(const std::_Any_data &) (__functor=...) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/std_function.h:297 #12 0x00000000043c515e in std::function::operator()() const (this=0x7fa6b0005060) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/std_function.h:687 #13 0x0000000004912cb7 in ngs::Scheduler_dynamic::worker (this=0x89e74c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:236 #14 0x00000000049129ac in ngs::Scheduler_dynamic::worker_proxy (data=0x89e74c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:170 #15 0x00000000047b3694 in pfs_spawn_thread (arg=0x89e8530) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7fa73a308700 (LWP 6397)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa7342e9588, abstime=0x7fa73a307ad0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa7342e9588, time_in_usec=100000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa7342e9588, time_in_usec=100000, reset_sig_count=0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x000000000454592b in Clone_persist_gtid::periodic_write (this=0x7fa7342e94f0) at ../../../mysql-8.0.17/storage/innobase/clone/clone0repl.cc:495 #5 0x0000000004545d61 in clone_gtid_thread (persist_gtid=0x7fa7342e94f0) at ../../../mysql-8.0.17/storage/innobase/clone/clone0repl.cc:569 #6 0x000000000454879e in std::__invoke_impl (__f=@0x7fa73a307c80: 0x4545d49 , __args#0=@0x7fa73a307c88: 0x7fa7342e94f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #7 0x0000000004548699 in std::__invoke (__fn=@0x7fa73a307c80: 0x4545d49 , __args#0=@0x7fa73a307c88: 0x7fa7342e94f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #8 0x000000000454856a in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa73a307c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #9 0x0000000004548456 in std::_Bind::operator()<, void>() (this=0x7fa73a307c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #10 0x0000000004548287 in Runnable::operator()(void (*&&)(Clone_persist_gtid*), Clone_persist_gtid*&&) (this=0x89f0088, f=@0x89f0080: 0x4545d49 , args#0=@0x89f0078: 0x7fa7342e94f0) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #11 0x0000000004547f7d in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(Clone_persist_gtid*), Clone_persist_gtid*&&) (__f=..., __args#0=@0x89f0080: 0x4545d49 , __args#1=@0x89f0078: 0x7fa7342e94f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #12 0x000000000454783b in std::__invoke(Runnable&&, void (*&&)(Clone_persist_gtid*), Clone_persist_gtid*&&) (__fn=..., __args#0=@0x89f0080: 0x4545d49 , __args#1=@0x89f0078: 0x7fa7342e94f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #13 0x0000000004548965 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x89f0078) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #14 0x0000000004548904 in std::thread::_Invoker >::operator() (this=0x89f0078) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #15 0x00000000045488e8 in std::thread::_State_impl > >::_M_run (this=0x89f0070) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #16 0x0000000004ad9ecf in execute_native_thread_routine () #17 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #18 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fa6dbfff700 (LWP 6385)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734024cc8, abstime=0x7fa6dbffeb60) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734024cc8, time_in_usec=5000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734024cc8, time_in_usec=5000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x00000000043a8f72 in srv_monitor_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:1652 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6dbffecb0: 0x43a8ee2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6dbffecb0: 0x43a8ee2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6dbffecb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6dbffecb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa7345687e0, f=@0x7fa7345687d8: 0x43a8ee2 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa7345687d8: 0x43a8ee2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa7345687d8: 0x43a8ee2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa7345687d8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa7345687d8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa7345687d0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fa6ad7fb700 (LWP 6406)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000004048c2f in native_cond_wait (cond=0x70aaea0 , mutex=0x885d3a8) at ../../mysql-8.0.17/include/thr_cond.h:109 #2 0x0000000004048d9a in safe_cond_wait (cond=0x70aaea0 , mp=0x885d380, file=0x56accb0 "../../mysql-8.0.17/sql/rpl_gtid_persist.cc", line=775) at ../../mysql-8.0.17/mysys/thr_cond.cc:71 #3 0x0000000003c98a2d in my_cond_wait (cond=0x70aaea0 , mp=0x70aae60 , file=0x56accb0 "../../mysql-8.0.17/sql/rpl_gtid_persist.cc", line=775) at ../../mysql-8.0.17/include/thr_cond.h:160 #4 0x0000000003c98a9c in inline_mysql_cond_wait (that=0x70aaea0 , mutex=0x70aae60 , src_file=0x56accb0 "../../mysql-8.0.17/sql/rpl_gtid_persist.cc", src_line=775) at ../../mysql-8.0.17/include/mysql/psi/mysql_cond.h:174 #5 0x0000000003c9b66e in compress_gtid_table (p_thd=0x8bda8d0) at ../../mysql-8.0.17/sql/rpl_gtid_persist.cc:775 #6 0x00000000047b3694 in pfs_spawn_thread (arg=0x8c1aae0) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #7 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fa6da1fc700 (LWP 6388)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a4906 in os_event::wait (this=0x7fa734024d68) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:189 #2 0x00000000042a37f4 in os_event::wait_low (this=0x7fa734024d68, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:371 #3 0x00000000042a3e03 in os_event_wait_low (event=0x7fa734024d68, reset_sig_count=0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:606 #4 0x00000000044f541a in buf_dump_thread () at ../../../mysql-8.0.17/storage/innobase/buf/buf0dump.cc:688 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6da1fbcb0: 0x44f5379 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6da1fbcb0: 0x44f5379 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6da1fbcb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6da1fbcb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa734b88da0, f=@0x7fa734b88d98: 0x44f5379 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa734b88d98: 0x44f5379 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa734b88d98: 0x44f5379 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa734b88d98) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa734b88d98) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa734b88d90) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fa6db5fe700 (LWP 6386)): #0 0x00007fa7476f3705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a4906 in os_event::wait (this=0x7fa734024ea8) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:189 #2 0x00000000042a37f4 in os_event::wait_low (this=0x7fa734024ea8, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:371 #3 0x00000000042a3e03 in os_event_wait_low (event=0x7fa734024ea8, reset_sig_count=0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:606 #4 0x00000000044d5245 in buf_resize_thread () at ../../../mysql-8.0.17/storage/innobase/buf/buf0buf.cc:2463 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6db5fdcb0: 0x44d5201 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6db5fdcb0: 0x44d5201 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6db5fdcb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6db5fdcb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa73469e030, f=@0x7fa73469e028: 0x44d5201 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa73469e028: 0x44d5201 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa73469e028: 0x44d5201 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa73469e028) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa73469e028) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa73469e020) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fa6affff700 (LWP 6398)): #0 0x00007fa7476f699d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000002bbac33 in std::this_thread::sleep_for > (__rtime=...) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:379 #2 0x00000000043f9a69 in trx_purge_wait_for_workers_to_complete () at ../../../mysql-8.0.17/storage/innobase/trx/trx0purge.cc:2171 #3 0x00000000043f9e90 in trx_purge (n_purge_threads=4, batch_size=300, truncate=false) at ../../../mysql-8.0.17/storage/innobase/trx/trx0purge.cc:2263 #4 0x00000000043abd9c in srv_do_purge (n_total_purged=0x7fa6afffebc0) at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2837 #5 0x00000000043ac4de in srv_purge_coordinator_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:3001 #6 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6afffecb0: 0x43ac2c2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #7 0x000000000418c988 in std::__invoke (__fn=@0x7fa6afffecb0: 0x43ac2c2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #8 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6afffecb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #9 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6afffecb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #10 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x89f0170, f=@0x89f0168: 0x43ac2c2 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #11 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x89f0168: 0x43ac2c2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #12 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x89f0168: 0x43ac2c2 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #13 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x89f0168) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #14 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x89f0168) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #15 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x89f0160) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #16 0x0000000004ad9ecf in execute_native_thread_routine () #17 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #18 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fa738a48700 (LWP 6391)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000004048c0a in native_cond_timedwait (cond=0x896f280, mutex=0x896f478, abstime=0x7fa738a47c20) at ../../mysql-8.0.17/include/thr_cond.h:100 #2 0x0000000004048f7b in safe_cond_timedwait (cond=0x896f280, mp=0x896f450, abstime=0x7fa738a47c20, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=42) at ../../mysql-8.0.17/mysys/thr_cond.cc:113 #3 0x00000000048a24ac in my_cond_timedwait (cond=0x896f280, mp=0x896f250, abstime=0x7fa738a47c20, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=42) at ../../../mysql-8.0.17/include/thr_cond.h:147 #4 0x00000000048a2690 in inline_mysql_cond_timedwait (that=0x896f280, mutex=0x896f250, abstime=0x7fa738a47c20, src_file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", src_line=42) at ../../../mysql-8.0.17/include/mysql/psi/mysql_cond.h:217 #5 0x00000000048a282a in xpl::Cond::timed_wait (this=0x896f280, mutex=..., nanoseconds=60000000000) at ../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc:42 #6 0x0000000004912aca in ngs::Scheduler_dynamic::wait_if_idle_then_delete_worker (this=0x896f240, thread_waiting_started=@0x7fa738a47d18: 1566021218775) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:198 #7 0x0000000004912cf3 in ngs::Scheduler_dynamic::worker (this=0x896f240) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:245 #8 0x00000000049129ac in ngs::Scheduler_dynamic::worker_proxy (data=0x896f240) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:170 #9 0x00000000047b3694 in pfs_spawn_thread (arg=0x89e7f10) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #10 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #11 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fa6aebfd700 (LWP 6400)): #0 0x00007fa745a9876d in __memset_sse2 () from /lib64/libc.so.6 #1 0x000000000450a0a9 in buf_LRU_block_free_non_file_page (block=0x7fa73275a920) at ../../../mysql-8.0.17/storage/innobase/buf/buf0lru.cc:1923 #2 0x00000000044487b1 in buf_block_free (block=0x7fa73275a920) at ../../../mysql-8.0.17/storage/innobase/include/buf0buf.ic:755 #3 0x000000000444955f in mem_heap_block_free (heap=0x7fa734363008, block=0x7fa7332c4000) at ../../../mysql-8.0.17/storage/innobase/mem/memory.cc:447 #4 0x000000000462669c in mem_heap_free_top (heap=0x7fa734363008, n=32) at ../../../mysql-8.0.17/storage/innobase/include/mem0mem.ic:435 #5 0x00000000046282b9 in ha_delete_hash_node (table=0x7fa73432ca28, del_node=0x7fa7332c40a0) at ../../../mysql-8.0.17/storage/innobase/ha/ha0ha.cc:319 #6 0x00000000044b6413 in ha_search_and_delete_if_found (table=0x7fa73432ca28, fold=12498947312464975990, data=0x7fa73356faca "") at ../../../mysql-8.0.17/storage/innobase/include/ha0ha.ic:203 #7 0x00000000044bd42f in btr_search_update_hash_on_delete (cursor=0x7fa6aebfc070) at ../../../mysql-8.0.17/storage/innobase/btr/btr0sea.cc:1723 #8 0x00000000044ac3eb in btr_cur_optimistic_delete_func (cursor=0x7fa6aebfc070, flags=0, mtr=0x7fa6aebfc170) at ../../../mysql-8.0.17/storage/innobase/btr/btr0cur.cc:4618 #9 0x000000000435f0ec in row_purge_remove_sec_if_poss_leaf (node=0x7fa734547098, index=0x7fa734ac5438, entry=0x7fa6a4007e78) at ../../../mysql-8.0.17/storage/innobase/row/row0purge.cc:536 #10 0x000000000435f1e0 in row_purge_remove_sec_if_poss (node=0x7fa734547098, index=0x7fa734ac5438, entry=0x7fa6a4007e78) at ../../../mysql-8.0.17/storage/innobase/row/row0purge.cc:577 #11 0x000000000435f56f in row_purge_del_mark (node=0x7fa734547098) at ../../../mysql-8.0.17/storage/innobase/row/row0purge.cc:660 #12 0x00000000043606b8 in row_purge_record_func (node=0x7fa734547098, undo_rec=0x7fa6a800bdb0 "%\310N", thr=0x7fa734546ec0, updated_extern=false, thd=0x7fa6a4000950) at ../../../mysql-8.0.17/storage/innobase/row/row0purge.cc:1081 #13 0x0000000004360a08 in row_purge (node=0x7fa734547098, undo_rec=0x7fa6a800bdb0 "%\310N", thr=0x7fa734546ec0) at ../../../mysql-8.0.17/storage/innobase/row/row0purge.cc:1155 #14 0x0000000004360d23 in row_purge_step (thr=0x7fa734546ec0) at ../../../mysql-8.0.17/storage/innobase/row/row0purge.cc:1227 #15 0x00000000042d2f9c in que_thr_step (thr=0x7fa734546ec0) at ../../../mysql-8.0.17/storage/innobase/que/que0que.cc:925 #16 0x00000000042d314f in que_run_threads_low (thr=0x7fa734546ec0) at ../../../mysql-8.0.17/storage/innobase/que/que0que.cc:976 #17 0x00000000042d3304 in que_run_threads (thr=0x7fa734546ec0) at ../../../mysql-8.0.17/storage/innobase/que/que0que.cc:1011 #18 0x00000000043ab884 in srv_task_execute () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2712 #19 0x00000000043aba19 in srv_worker_thread () at ../../../mysql-8.0.17/storage/innobase/srv/srv0srv.cc:2751 #20 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6aebfccb0: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #21 0x000000000418c988 in std::__invoke (__fn=@0x7fa6aebfccb0: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #22 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6aebfccb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #23 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6aebfccb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #24 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x89f01d0, f=@0x89f01c8: 0x43ab8a3 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #25 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x89f01c8: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #26 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x89f01c8: 0x43ab8a3 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #27 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x89f01c8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #28 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x89f01c8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #29 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x89f01c0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #30 0x0000000004ad9ecf in execute_native_thread_routine () #31 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #32 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fa731cd2700 (LWP 6368)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa731cd1a70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa731cd1a70, m1=0x7fa731cd1b48, m2=0x7fa731cd1b08, request=0x7fa731cd1b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=2, m1=0x7fa731cd1b48, m2=0x7fa731cd1b08, request=0x7fa731cd1b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=2, m1=0x7fa731cd1b48, m2=0x7fa731cd1b08, request=0x7fa731cd1b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=2) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=2) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa731cd1c80: 0x43b2122 , __args#0=@0x7fa731cd1c88: 2) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa731cd1c80: 0x43b2122 , __args#0=@0x7fa731cd1c88: 2) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa731cd1c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa731cd1c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734412fc8, f=@0x7fa734412fc0: 0x43b2122 , args#0=@0x7fa734412fb8: 2) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734412fc0: 0x43b2122 , __args#1=@0x7fa734412fb8: 2) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734412fc0: 0x43b2122 , __args#1=@0x7fa734412fb8: 2) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734412fb8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734412fb8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734412fb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fa738976700 (LWP 6394)): #0 0x00007fa745afedd9 in syscall () from /lib64/libc.so.6 #1 0x0000000004a0cb4c in epoll_wait (epfd=28, events=0x896ffa0, maxevents=32, timeout=997) at ../../../mysql-8.0.17/extra/libevent/epoll_sub.c:64 #2 0x0000000004a0c828 in epoll_dispatch (base=0x896fd00, tv=0x7fa738975a40) at ../../../mysql-8.0.17/extra/libevent/epoll.c:462 #3 0x00000000049fb48e in event_base_loop (base=0x896fd00, flags=0) at ../../../mysql-8.0.17/extra/libevent/event.c:1947 #4 0x000000000491aac7 in ngs::Socket_events::loop (this=0x896fc10) at ../../../mysql-8.0.17/plugin/x/ngs/src/socket_events.cc:173 #5 0x000000000491702d in ngs::Socket_acceptors_task::loop (this=0x89701b0) at ../../../mysql-8.0.17/plugin/x/ngs/src/socket_acceptors_task.cc:211 #6 0x0000000004896efd in ngs::Server::run_task (this=0x89e7208, handler=std::shared_ptr (count 2, weak 0) 0x89701b0) at ../../../mysql-8.0.17/plugin/x/ngs/src/server.cc:104 #7 0x0000000004897311 in ngs::Server::start (this=0x89e7208) at ../../../mysql-8.0.17/plugin/x/ngs/src/server.cc:138 #8 0x00000000048a4d82 in xpl::Server::net_thread (this=0x89e7150) at ../../../mysql-8.0.17/plugin/x/src/xpl_server.cc:562 #9 0x00000000048b2fc5 in std::__invoke_impl (__f=@0x89efad0: (void (xpl::Server::*)(xpl::Server * const)) 0x48a4d2e , __t=@0x89efae0: 0x89e7150) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:73 #10 0x00000000048b166f in std::__invoke (__fn=@0x89efad0: (void (xpl::Server::*)(xpl::Server * const)) 0x48a4d2e , __args#0=@0x89efae0: 0x89e7150) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #11 0x00000000048afe3c in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x89efad0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #12 0x00000000048ae8e0 in std::_Bind::operator()<, void>() (this=0x89efad0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #13 0x00000000048ac949 in std::_Function_handler >::_M_invoke(std::_Any_data const&) (__functor=...) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/std_function.h:297 #14 0x00000000043c515e in std::function::operator()() const (this=0x89e88c0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/std_function.h:687 #15 0x0000000004912cb7 in ngs::Scheduler_dynamic::worker (this=0x89e74c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:236 #16 0x00000000049129ac in ngs::Scheduler_dynamic::worker_proxy (data=0x89e74c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:170 #17 0x00000000047b3694 in pfs_spawn_thread (arg=0x89e8910) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fa704bfb700 (LWP 6378)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa7344163c8, abstime=0x7fa704bfa990) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa7344163c8, time_in_usec=1000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa7344163c8, time_in_usec=1000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004285a44 in os_event_wait_for >(os_event_t &, uint64_t, uint64_t, ) (event=@0x7fa704bfab28: 0x7fa7344163c8, spins_limit=0, timeout=1000, condition=...) at ../../../mysql-8.0.17/storage/innobase/include/os0event.ic:138 #5 0x0000000004285234 in Log_thread_waiting::wait >() (this=0x7fa704bfab20, stop_condition=...) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:1004 #6 0x00000000042840aa in log_closer (log_ptr=0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/log/log0write.cc:2540 #7 0x0000000004254028 in std::__invoke_impl (__f=@0x7fa704bfac80: 0x4283fb6 , __args#0=@0x7fa704bfac88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x0000000004253f9d in std::__invoke (__fn=@0x7fa704bfac80: 0x4283fb6 , __args#0=@0x7fa704bfac88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x0000000004253eba in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa704bfac80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x0000000004253d84 in std::_Bind::operator()<, void>() (this=0x7fa704bfac80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x0000000004253b31 in Runnable::operator()(void (*&&)(log_t*), log_t*&&) (this=0x7fa7344e0808, f=@0x7fa7344e0800: 0x4283fb6 , args#0=@0x7fa7344e07f8: 0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x000000000425330f in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(log_t*), log_t*&&) (__f=..., __args#0=@0x7fa7344e0800: 0x4283fb6 , __args#1=@0x7fa7344e07f8: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000042521ef in std::__invoke(Runnable&&, void (*&&)(log_t*), log_t*&&) (__fn=..., __args#0=@0x7fa7344e0800: 0x4283fb6 , __args#1=@0x7fa7344e07f8: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000042541ab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa7344e07f8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x000000000425414a in std::thread::_Invoker >::operator() (this=0x7fa7344e07f8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000042540b6 in std::thread::_State_impl > >::_M_run (this=0x7fa7344e07f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fa738a02700 (LWP 6392)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000004048c0a in native_cond_timedwait (cond=0x896f280, mutex=0x896f478, abstime=0x7fa738a01c20) at ../../mysql-8.0.17/include/thr_cond.h:100 #2 0x0000000004048f7b in safe_cond_timedwait (cond=0x896f280, mp=0x896f450, abstime=0x7fa738a01c20, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=42) at ../../mysql-8.0.17/mysys/thr_cond.cc:113 #3 0x00000000048a24ac in my_cond_timedwait (cond=0x896f280, mp=0x896f250, abstime=0x7fa738a01c20, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=42) at ../../../mysql-8.0.17/include/thr_cond.h:147 #4 0x00000000048a2690 in inline_mysql_cond_timedwait (that=0x896f280, mutex=0x896f250, abstime=0x7fa738a01c20, src_file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", src_line=42) at ../../../mysql-8.0.17/include/mysql/psi/mysql_cond.h:217 #5 0x00000000048a282a in xpl::Cond::timed_wait (this=0x896f280, mutex=..., nanoseconds=60000000000) at ../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc:42 #6 0x0000000004912aca in ngs::Scheduler_dynamic::wait_if_idle_then_delete_worker (this=0x896f240, thread_waiting_started=@0x7fa738a01d18: 1566021218775) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:198 #7 0x0000000004912cf3 in ngs::Scheduler_dynamic::worker (this=0x896f240) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:245 #8 0x00000000049129ac in ngs::Scheduler_dynamic::worker_proxy (data=0x896f240) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:170 #9 0x00000000047b3694 in pfs_spawn_thread (arg=0x89e8220) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #10 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #11 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fa71cdfa700 (LWP 6375)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa71cdf9a70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa71cdf9a70, m1=0x7fa71cdf9b48, m2=0x7fa71cdf9b08, request=0x7fa71cdf9b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=9, m1=0x7fa71cdf9b48, m2=0x7fa71cdf9b08, request=0x7fa71cdf9b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=9, m1=0x7fa71cdf9b48, m2=0x7fa71cdf9b08, request=0x7fa71cdf9b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=9) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=9) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa71cdf9c80: 0x43b2122 , __args#0=@0x7fa71cdf9c88: 9) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa71cdf9c80: 0x43b2122 , __args#0=@0x7fa71cdf9c88: 9) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa71cdf9c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa71cdf9c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734413ff8, f=@0x7fa734413ff0: 0x43b2122 , args#0=@0x7fa734413fe8: 9) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734413ff0: 0x43b2122 , __args#1=@0x7fa734413fe8: 9) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734413ff0: 0x43b2122 , __args#1=@0x7fa734413fe8: 9) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734413fe8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734413fe8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734413fe0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fa71f5fe700 (LWP 6371)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa71f5fda70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa71f5fda70, m1=0x7fa71f5fdb48, m2=0x7fa71f5fdb08, request=0x7fa71f5fdb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=5, m1=0x7fa71f5fdb48, m2=0x7fa71f5fdb08, request=0x7fa71f5fdb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=5, m1=0x7fa71f5fdb48, m2=0x7fa71f5fdb08, request=0x7fa71f5fdb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=5) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=5) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa71f5fdc80: 0x43b2122 , __args#0=@0x7fa71f5fdc88: 5) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa71f5fdc80: 0x43b2122 , __args#0=@0x7fa71f5fdc88: 5) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa71f5fdc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa71f5fdc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa7344136b8, f=@0x7fa7344136b0: 0x43b2122 , args#0=@0x7fa7344136a8: 5) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa7344136b0: 0x43b2122 , __args#1=@0x7fa7344136a8: 5) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa7344136b0: 0x43b2122 , __args#1=@0x7fa7344136a8: 5) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa7344136a8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa7344136a8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa7344136a0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fa6f97fb700 (LWP 6383)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa7343e4428, abstime=0x7fa6f97fab70) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa7343e4428, time_in_usec=1000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa7343e4428, time_in_usec=1000000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x0000000004238b94 in lock_wait_timeout_thread () at ../../../mysql-8.0.17/storage/innobase/lock/lock0wait.cc:494 #5 0x000000000418de0a in std::__invoke_impl (__f=@0x7fa6f97facb0: 0x4238b30 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x000000000418c988 in std::__invoke (__fn=@0x7fa6f97facb0: 0x4238b30 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x000000000418aaa8 in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<>) (this=0x7fa6f97facb0, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x000000000418898a in std::_Bind::operator()<, void>() (this=0x7fa6f97facb0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004185fc8 in Runnable::operator()(void (*&&)()) (this=0x7fa734568150, f=@0x7fa734568148: 0x4238b30 ) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x0000000004180e0c in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)()) (__f=..., __args#0=@0x7fa734568148: 0x4238b30 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x000000000417aa86 in std::__invoke(Runnable&&, void (*&&)()) (__fn=..., __args#0=@0x7fa734568148: 0x4238b30 ) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x000000000418f6df in std::thread::_Invoker >::_M_invoke<0ul, 1ul> (this=0x7fa734568148) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000418f462 in std::thread::_Invoker >::operator() (this=0x7fa734568148) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x000000000418eef0 in std::thread::_State_impl > >::_M_run (this=0x7fa734568140) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fa739449700 (LWP 6366)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa739448a70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa739448a70, m1=0x7fa739448b48, m2=0x7fa739448b08, request=0x7fa739448b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=0, m1=0x7fa739448b48, m2=0x7fa739448b08, request=0x7fa739448b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=0, m1=0x7fa739448b48, m2=0x7fa739448b08, request=0x7fa739448b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=0) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=0) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa739448c80: 0x43b2122 , __args#0=@0x7fa739448c88: 0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa739448c80: 0x43b2122 , __args#0=@0x7fa739448c88: 0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa739448c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa739448c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734412c78, f=@0x7fa734412c70: 0x43b2122 , args#0=@0x7fa734412c68: 0) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734412c70: 0x43b2122 , __args#1=@0x7fa734412c68: 0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734412c70: 0x43b2122 , __args#1=@0x7fa734412c68: 0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734412c68) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734412c68) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734412c60) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fa738120700 (LWP 6408)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000004048c0a in native_cond_timedwait (cond=0x89e7500, mutex=0x89e76e8, abstime=0x7fa73811fc20) at ../../mysql-8.0.17/include/thr_cond.h:100 #2 0x0000000004048f7b in safe_cond_timedwait (cond=0x89e7500, mp=0x89e76c0, abstime=0x7fa73811fc20, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=42) at ../../mysql-8.0.17/mysys/thr_cond.cc:113 #3 0x00000000048a24ac in my_cond_timedwait (cond=0x89e7500, mp=0x89e74d0, abstime=0x7fa73811fc20, file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", line=42) at ../../../mysql-8.0.17/include/thr_cond.h:147 #4 0x00000000048a2690 in inline_mysql_cond_timedwait (that=0x89e7500, mutex=0x89e74d0, abstime=0x7fa73811fc20, src_file=0x5fb9ef8 "../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc", src_line=42) at ../../../mysql-8.0.17/include/mysql/psi/mysql_cond.h:217 #5 0x00000000048a282a in xpl::Cond::timed_wait (this=0x89e7500, mutex=..., nanoseconds=60000000000) at ../../../mysql-8.0.17/plugin/x/src/helper/multithread/cond.cc:42 #6 0x0000000004912aca in ngs::Scheduler_dynamic::wait_if_idle_then_delete_worker (this=0x89e74c0, thread_waiting_started=@0x7fa73811fd18: 1566021220029) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:198 #7 0x0000000004912cf3 in ngs::Scheduler_dynamic::worker (this=0x89e74c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:245 #8 0x00000000049129ac in ngs::Scheduler_dynamic::worker_proxy (data=0x89e74c0) at ../../../mysql-8.0.17/plugin/x/ngs/src/scheduler.cc:170 #9 0x00000000047b3694 in pfs_spawn_thread (arg=0x7fa6b0004e00) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #10 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #11 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fa7326d3700 (LWP 6367)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa7326d2a70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa7326d2a70, m1=0x7fa7326d2b48, m2=0x7fa7326d2b08, request=0x7fa7326d2b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=1, m1=0x7fa7326d2b48, m2=0x7fa7326d2b08, request=0x7fa7326d2b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=1, m1=0x7fa7326d2b48, m2=0x7fa7326d2b08, request=0x7fa7326d2b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=1) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=1) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa7326d2c80: 0x43b2122 , __args#0=@0x7fa7326d2c88: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa7326d2c80: 0x43b2122 , __args#0=@0x7fa7326d2c88: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa7326d2c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa7326d2c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734412d78, f=@0x7fa734412d70: 0x43b2122 , args#0=@0x7fa734412d68: 1) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734412d70: 0x43b2122 , __args#1=@0x7fa734412d68: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734412d70: 0x43b2122 , __args#1=@0x7fa734412d68: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734412d68) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734412d68) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734412d60) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fa7055fc700 (LWP 6377)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734416328, abstime=0x7fa7055fbae0) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734416328, time_in_usec=10000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734416328, time_in_usec=10000, reset_sig_count=1) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x00000000042419f7 in log_checkpointer (log_ptr=0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/log/log0chkp.cc:932 #5 0x0000000004254028 in std::__invoke_impl (__f=@0x7fa7055fbc80: 0x4241926 , __args#0=@0x7fa7055fbc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #6 0x0000000004253f9d in std::__invoke (__fn=@0x7fa7055fbc80: 0x4241926 , __args#0=@0x7fa7055fbc88: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #7 0x0000000004253eba in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa7055fbc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #8 0x0000000004253d84 in std::_Bind::operator()<, void>() (this=0x7fa7055fbc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #9 0x0000000004253b31 in Runnable::operator()(void (*&&)(log_t*), log_t*&&) (this=0x7fa73441d9f8, f=@0x7fa73441d9f0: 0x4241926 , args#0=@0x7fa73441d9e8: 0x7fa734415a00) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #10 0x000000000425330f in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(log_t*), log_t*&&) (__f=..., __args#0=@0x7fa73441d9f0: 0x4241926 , __args#1=@0x7fa73441d9e8: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #11 0x00000000042521ef in std::__invoke(Runnable&&, void (*&&)(log_t*), log_t*&&) (__fn=..., __args#0=@0x7fa73441d9f0: 0x4241926 , __args#1=@0x7fa73441d9e8: 0x7fa734415a00) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #12 0x00000000042541ab in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa73441d9e8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #13 0x000000000425414a in std::thread::_Invoker >::operator() (this=0x7fa73441d9e8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #14 0x00000000042540b6 in std::thread::_State_impl > >::_M_run (this=0x7fa73441d9e0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #15 0x0000000004ad9ecf in execute_native_thread_routine () #16 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fa707fff700 (LWP 6376)): #0 0x00007fa7476f3ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000042a3681 in os_event::timed_wait (this=0x7fa734024e08, abstime=0x7fa707ffe530) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:321 #2 0x00000000042a3bdf in os_event::wait_time_low (this=0x7fa734024e08, time_in_usec=997000, reset_sig_count=2) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:494 #3 0x00000000042a3dde in os_event_wait_time_low (event=0x7fa734024e08, time_in_usec=997000, reset_sig_count=2) at ../../../mysql-8.0.17/storage/innobase/os/os0event.cc:592 #4 0x00000000044ff604 in pc_sleep_if_needed (next_loop_time=9123976333, sig_count=2) at ../../../mysql-8.0.17/storage/innobase/buf/buf0flu.cc:2602 #5 0x000000000450096b in buf_flush_page_coordinator_thread (n_page_cleaners=1) at ../../../mysql-8.0.17/storage/innobase/buf/buf0flu.cc:3066 #6 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa707ffec80: 0x4500554 , __args#0=@0x7fa707ffec88: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #7 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa707ffec80: 0x4500554 , __args#0=@0x7fa707ffec88: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #8 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa707ffec80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #9 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa707ffec80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #10 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734414648, f=@0x7fa734414640: 0x4500554 , args#0=@0x7fa734414638: 1) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #11 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734414640: 0x4500554 , __args#1=@0x7fa734414638: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #12 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734414640: 0x4500554 , __args#1=@0x7fa734414638: 1) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #13 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734414638) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #14 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734414638) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #15 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734414630) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #16 0x0000000004ad9ecf in execute_native_thread_routine () #17 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #18 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fa71d7fb700 (LWP 6374)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa71d7faa70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa71d7faa70, m1=0x7fa71d7fab48, m2=0x7fa71d7fab08, request=0x7fa71d7fab10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=8, m1=0x7fa71d7fab48, m2=0x7fa71d7fab08, request=0x7fa71d7fab10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=8, m1=0x7fa71d7fab48, m2=0x7fa71d7fab08, request=0x7fa71d7fab10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=8) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=8) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa71d7fac80: 0x43b2122 , __args#0=@0x7fa71d7fac88: 8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa71d7fac80: 0x43b2122 , __args#0=@0x7fa71d7fac88: 8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa71d7fac80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa71d7fac80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734413da8, f=@0x7fa734413da0: 0x43b2122 , args#0=@0x7fa734413d98: 8) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734413da0: 0x43b2122 , __args#1=@0x7fa734413d98: 8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734413da0: 0x43b2122 , __args#1=@0x7fa734413d98: 8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734413d98) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734413d98) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734413d90) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fa71ebfd700 (LWP 6372)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa71ebfca70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa71ebfca70, m1=0x7fa71ebfcb48, m2=0x7fa71ebfcb08, request=0x7fa71ebfcb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=6, m1=0x7fa71ebfcb48, m2=0x7fa71ebfcb08, request=0x7fa71ebfcb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=6, m1=0x7fa71ebfcb48, m2=0x7fa71ebfcb08, request=0x7fa71ebfcb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=6) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=6) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa71ebfcc80: 0x43b2122 , __args#0=@0x7fa71ebfcc88: 6) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa71ebfcc80: 0x43b2122 , __args#0=@0x7fa71ebfcc88: 6) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa71ebfcc80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa71ebfcc80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734413908, f=@0x7fa734413900: 0x43b2122 , args#0=@0x7fa7344138f8: 6) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734413900: 0x43b2122 , __args#1=@0x7fa7344138f8: 6) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734413900: 0x43b2122 , __args#1=@0x7fa7344138f8: 6) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa7344138f8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa7344138f8) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa7344138f0) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fa71ffff700 (LWP 6370)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa71fffea70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa71fffea70, m1=0x7fa71fffeb48, m2=0x7fa71fffeb08, request=0x7fa71fffeb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=4, m1=0x7fa71fffeb48, m2=0x7fa71fffeb08, request=0x7fa71fffeb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=4, m1=0x7fa71fffeb48, m2=0x7fa71fffeb08, request=0x7fa71fffeb10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=4) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=4) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa71fffec80: 0x43b2122 , __args#0=@0x7fa71fffec88: 4) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa71fffec80: 0x43b2122 , __args#0=@0x7fa71fffec88: 4) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa71fffec80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa71fffec80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734413468, f=@0x7fa734413460: 0x43b2122 , args#0=@0x7fa734413458: 4) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734413460: 0x43b2122 , __args#1=@0x7fa734413458: 4) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734413460: 0x43b2122 , __args#1=@0x7fa734413458: 4) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734413458) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734413458) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734413450) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fa7312d1700 (LWP 6369)): #0 0x00007fa7467f8644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x000000000429088d in LinuxAIOHandler::collect (this=0x7fa7312d0a70) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2326 #2 0x0000000004290dd3 in LinuxAIOHandler::poll (this=0x7fa7312d0a70, m1=0x7fa7312d0b48, m2=0x7fa7312d0b08, request=0x7fa7312d0b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2471 #3 0x0000000004290f44 in os_aio_linux_handler (global_segment=3, m1=0x7fa7312d0b48, m2=0x7fa7312d0b08, request=0x7fa7312d0b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:2520 #4 0x0000000004296052 in os_aio_handler (segment=3, m1=0x7fa7312d0b48, m2=0x7fa7312d0b08, request=0x7fa7312d0b10) at ../../../mysql-8.0.17/storage/innobase/os/os0file.cc:5931 #5 0x00000000045d985b in fil_aio_wait (segment=3) at ../../../mysql-8.0.17/storage/innobase/fil/fil0fil.cc:7582 #6 0x00000000043b2178 in io_handler_thread (segment=3) at ../../../mysql-8.0.17/storage/innobase/srv/srv0start.cc:280 #7 0x00000000043cac5c in std::__invoke_impl (__f=@0x7fa7312d0c80: 0x43b2122 , __args#0=@0x7fa7312d0c88: 3) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #8 0x00000000043cabd2 in std::__invoke (__fn=@0x7fa7312d0c80: 0x43b2122 , __args#0=@0x7fa7312d0c88: 3) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #9 0x00000000043caabc in std::_Bind::__call(std::tuple<>&&, std::_Index_tuple<0ul>) (this=0x7fa7312d0c80, __args=empty std::tuple) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:400 #10 0x00000000043ca8ae in std::_Bind::operator()<, void>() (this=0x7fa7312d0c80) at /opt/rh/devtoolset-8/root/usr/include/c++/8/functional:484 #11 0x00000000043ca5ad in Runnable::operator()(void (*&&)(unsigned long), unsigned long&&) (this=0x7fa734413218, f=@0x7fa734413210: 0x43b2122 , args#0=@0x7fa734413208: 3) at ../../../mysql-8.0.17/storage/innobase/include/os0thread-create.h:101 #12 0x00000000043c9745 in std::__invoke_impl(std::__invoke_other, Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__f=..., __args#0=@0x7fa734413210: 0x43b2122 , __args#1=@0x7fa734413208: 3) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:60 #13 0x00000000043c696e in std::__invoke(Runnable&&, void (*&&)(unsigned long), unsigned long&&) (__fn=..., __args#0=@0x7fa734413210: 0x43b2122 , __args#1=@0x7fa734413208: 3) at /opt/rh/devtoolset-8/root/usr/include/c++/8/bits/invoke.h:95 #14 0x00000000043cad67 in std::thread::_Invoker >::_M_invoke<0ul, 1ul, 2ul> (this=0x7fa734413208) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:244 #15 0x00000000043cad06 in std::thread::_Invoker >::operator() (this=0x7fa734413208) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:253 #16 0x00000000043cacea in std::thread::_State_impl > >::_M_run (this=0x7fa734413200) at /opt/rh/devtoolset-8/root/usr/include/c++/8/thread:196 #17 0x0000000004ad9ecf in execute_native_thread_routine () #18 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fa7380da700 (LWP 6411)): #0 0x00007fa745afa0cf in ppoll () from /lib64/libc.so.6 #1 0x0000000004a32b55 in vio_io_wait (vio=0x7fa680000970, event=VIO_IO_EVENT_READ, timeout=28800000) at ../../mysql-8.0.17/vio/viosocket.cc:836 #2 0x0000000004a31671 in vio_socket_io_wait (vio=0x7fa680000970, event=VIO_IO_EVENT_READ) at ../../mysql-8.0.17/vio/viosocket.cc:103 #3 0x0000000004a31822 in vio_read (vio=0x7fa680000970, buf=0x7fa6800060c0 "\a", size=4) at ../../mysql-8.0.17/vio/viosocket.cc:166 #4 0x0000000002e0c708 in net_read_raw_loop (net=0x7fa6800027a0, count=4) at ../../mysql-8.0.17/sql-common/net_serv.cc:1199 #5 0x0000000002e0ca02 in net_read_packet_header (net=0x7fa6800027a0) at ../../mysql-8.0.17/sql-common/net_serv.cc:1282 #6 0x0000000002e0d3c4 in net_read_packet (net=0x7fa6800027a0, complen=0x7fa7380d9b90) at ../../mysql-8.0.17/sql-common/net_serv.cc:1572 #7 0x0000000002e0d65e in my_net_read (net=0x7fa6800027a0) at ../../mysql-8.0.17/sql-common/net_serv.cc:1662 #8 0x0000000003200a08 in Protocol_classic::read_packet (this=0x7fa680002008) at ../../mysql-8.0.17/sql/protocol_classic.cc:1374 #9 0x00000000032015e3 in Protocol_classic::get_command (this=0x7fa680002008, com_data=0x7fa7380d9cd0, cmd=0x7fa7380d9cfc) at ../../mysql-8.0.17/sql/protocol_classic.cc:2779 #10 0x0000000002c5a2c8 in do_command (thd=0x7fa680000c00) at ../../mysql-8.0.17/sql/sql_parse.cc:1221 #11 0x0000000002e11aab in handle_connection (arg=0x896bd60) at ../../mysql-8.0.17/sql/conn_handler/connection_handler_per_thread.cc:302 #12 0x00000000047b3694 in pfs_spawn_thread (arg=0x8c1aae0) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #13 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fa745b0460d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fa7388a2700 (LWP 6407)): #0 0x00007fa7476f4771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000004048186 in my_write_core (sig=6) at ../../mysql-8.0.17/mysys/stacktrace.cc:305 #2 0x0000000002e25dc3 in handle_fatal_signal (sig=6) at ../../mysql-8.0.17/sql/signal_handler.cc:168 #3 #4 0x00007fa745a435d7 in raise () from /lib64/libc.so.6 #5 0x00007fa745a44cc8 in abort () from /lib64/libc.so.6 #6 0x00007fa745a3c546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fa745a3c5f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000002fc01c3 in handler::update_auto_increment (this=0x7fa6884a53d8) at ../../mysql-8.0.17/sql/handler.cc:3588 #9 0x0000000004142c0e in ha_innobase::write_row (this=0x7fa6884a53d8, record=0x7fa6884a7038 "") at ../../../mysql-8.0.17/storage/innobase/handler/ha_innodb.cc:8563 #10 0x0000000002fca51a in handler::ha_write_row (this=0x7fa6884a53d8, buf=0x7fa6884a7038 "") at ../../mysql-8.0.17/sql/handler.cc:7738 #11 0x000000000326aab6 in write_record (thd=0x7fa6880241a0, table=0x7fa68836d100, info=0x7fa6882c8f88, update=0x7fa6882c9000) at ../../mysql-8.0.17/sql/sql_insert.cc:1609 #12 0x000000000326c42a in Query_result_insert::send_data (this=0x7fa6882c8f40, thd=0x7fa6880241a0, values=...) at ../../mysql-8.0.17/sql/sql_insert.cc:2129 #13 0x0000000002bf94e4 in ExecuteIteratorQuery (join=0x7fa6882c95c0) at ../../mysql-8.0.17/sql/sql_executor.cc:2608 #14 0x0000000002bf960f in do_select (join=0x7fa6882c95c0) at ../../mysql-8.0.17/sql/sql_executor.cc:2640 #15 0x0000000002bf07ba in JOIN::exec (this=0x7fa6882c95c0) at ../../mysql-8.0.17/sql/sql_executor.cc:311 #16 0x0000000002cc6d66 in Sql_cmd_dml::execute_inner (this=0x7fa6882c86d0, thd=0x7fa6880241a0) at ../../mysql-8.0.17/sql/sql_select.cc:904 #17 0x0000000002cc63e5 in Sql_cmd_dml::execute (this=0x7fa6882c86d0, thd=0x7fa6880241a0) at ../../mysql-8.0.17/sql/sql_select.cc:700 #18 0x0000000002c60dc5 in mysql_execute_command (thd=0x7fa6880241a0, first_level=true) at ../../mysql-8.0.17/sql/sql_parse.cc:3433 #19 0x0000000002c669e8 in mysql_parse (thd=0x7fa6880241a0, parser_state=0x7fa7388a0c30) at ../../mysql-8.0.17/sql/sql_parse.cc:5221 #20 0x0000000002c5c01d in dispatch_command (thd=0x7fa6880241a0, com_data=0x7fa7388a1cd0, command=COM_QUERY) at ../../mysql-8.0.17/sql/sql_parse.cc:1755 #21 0x0000000002c5a5b5 in do_command (thd=0x7fa6880241a0) at ../../mysql-8.0.17/sql/sql_parse.cc:1270 #22 0x0000000002e11aab in handle_connection (arg=0x896bd60) at ../../mysql-8.0.17/sql/conn_handler/connection_handler_per_thread.cc:302 #23 0x00000000047b3694 in pfs_spawn_thread (arg=0x8c1aae0) at ../../../mysql-8.0.17/storage/perfschema/pfs.cc:2854 #24 0x00007fa7476efdf5 in start_thread () from /lib64/libpthread.so.0 #25 0x00007fa745b0460d in clone () from /lib64/libc.so.6 ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 48 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.bug96578 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases - 5.7.27 ./mtr --debug-server --mysqld='--innodb-autoinc-lock-mode=2' bug96578 Logging: ./mtr --debug-server --mysqld=--innodb-autoinc-lock-mode=2 bug96578 MySQL Version 5.7.27 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.27/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; create table temp1 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp1 values (1, 'b1', 'c1'), (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); create table temp2 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp2 values (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); CREATE TABLE extra ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL, PRIMARY KEY (id), UNIQUE KEY uniq_idx (a,b) ) engine = innodb; insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c); insert into extra(a, b, c) select * from temp2 on duplicate key update c=values(c); [100%] main.bug96578 [ fail ] Test ended at 2019-08-17 08:06:46 CURRENT_TEST: main.bug96578 mysqltest: At line 30: query 'reap' failed: 2013: Lost connection to MySQL server during query safe_process[7810]: Child process: 7811, exit: 1 Server [mysqld.1 - pid: 7782, winpid: 7782, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2019-08-17T06:06:45.661816Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-08-17T06:06:45.664216Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2019-08-17T06:06:45.664234Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2019-08-17T06:06:45.664297Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug (mysqld 5.7.27-debug-log) starting as process 7783 ... 2019-08-17T06:06:45.670331Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-08-17T06:06:45.670371Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-08-17T06:06:45.670381Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-08-17T06:06:45.670388Z 0 [Note] InnoDB: Uses event mutexes 2019-08-17T06:06:45.670397Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2019-08-17T06:06:45.670404Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-08-17T06:06:45.670411Z 0 [Note] InnoDB: Using Linux native AIO 2019-08-17T06:06:45.670999Z 0 [Note] InnoDB: Number of pools: 1 2019-08-17T06:06:45.671187Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-08-17T06:06:45.672987Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M 2019-08-17T06:06:45.689337Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-08-17T06:06:45.690046Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-08-17T06:06:45.705349Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-08-17T06:06:45.760945Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-08-17T06:06:45.761051Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-08-17T06:06:45.779334Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-08-17T06:06:45.790950Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-08-17T06:06:45.790970Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-08-17T06:06:45.792186Z 0 [Note] InnoDB: Waiting for purge to start 2019-08-17T06:06:45.842524Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 1350275 2019-08-17T06:06:45.842731Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.27/mysql-test/var/mysqld.1/data/ib_buffer_pool 2019-08-17T06:06:45.843397Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-08-17T06:06:45.848209Z 0 [Warning] unknown variable 'loose-mysqlx-port=13009' 2019-08-17T06:06:45.848227Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/export/umesh/server/binaries/GABuilds/mysql-5.7.27/mysql-test/var/tmp/mysqlx.1.sock' 2019-08-17T06:06:45.848234Z 0 [Warning] unknown variable 'loose-sha256_password_auto_generate_rsa_keys=0' 2019-08-17T06:06:45.849317Z 0 [Note] Salting uuid generator variables, current_pid: 7783, server_start_time: 1566022005, bytes_sent: 0, 2019-08-17T06:06:45.849391Z 0 [Note] Generated uuid: '31322394-c0b5-11e9-a561-0010e05f3e06', server_start_time: 2190719745305065436, bytes_sent: 63029968 2019-08-17T06:06:45.849444Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 31322394-c0b5-11e9-a561-0010e05f3e06. 2019-08-17T06:06:45.850323Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190817 9:06:45 2019-08-17T06:06:45.892290Z 0 [Warning] CA certificate /export/umesh/server/binaries/GABuilds/mysql-5.7.27/mysql-test/std_data/cacert.pem is self signed. 2019-08-17T06:06:45.919086Z 0 [Note] Server hostname (bind-address): '*'; port: 13000 2019-08-17T06:06:45.919138Z 0 [Note] IPv6 is available. 2019-08-17T06:06:45.919161Z 0 [Note] - '::' resolves to '::'; 2019-08-17T06:06:45.919199Z 0 [Note] Server socket created on IP: '::'. 2019-08-17T06:06:45.959396Z 0 [Note] Failed to start slave threads for channel '' 2019-08-17T06:06:45.980228Z 0 [Note] Event Scheduler: Loaded 0 events 2019-08-17T06:06:45.980662Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug: ready for connections. Version: '5.7.27-debug-log' socket: '/export/umesh/server/binaries/GABuilds/mysql-5.7.27/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - Debug (GPL) mysqld-debug: /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/handler.cc:3497: int handler::update_auto_increment(): Assertion `next_insert_id >= auto_inc_interval_for_cur_row.minimum()' failed. 06:06:46 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=2 max_threads=151 thread_count=2 connection_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61035 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fd5b01206c0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fd5fd206e30 thread_stack 0x40000 /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(my_print_stacktrace+0x35)[0x18e447a] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(handle_fatal_signal+0x407)[0xee0a1c] /lib64/libpthread.so.0(+0xf130)[0x7fd606192130] /lib64/libc.so.6(gsignal+0x37)[0x7fd604b895d7] /lib64/libc.so.6(abort+0x148)[0x7fd604b8acc8] /lib64/libc.so.6(+0x2e546)[0x7fd604b82546] /lib64/libc.so.6(+0x2e5f2)[0x7fd604b825f2] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_ZN7handler21update_auto_incrementEv+0xd1)[0xf5ded1] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_ZN11ha_innobase9write_rowEPh+0x60b)[0x19ad367] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_ZN7handler12ha_write_rowEPh+0x21c)[0xf67aec] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z12write_recordP3THDP5TABLEP9COPY_INFOS4_+0xe39)[0x17cb661] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_ZN19Query_result_insert9send_dataER4ListI4ItemE+0x1a3)[0x17ccc3d] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug[0x1553252] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug[0x154fe99] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z10sub_selectP4JOINP7QEP_TABb+0x34a)[0x154f29a] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug[0x154eb0e] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_ZN4JOIN4execEv+0x62e)[0x154c9ca] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x368)[0x15e8c7a] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_ZN21Sql_cmd_insert_select7executeEP3THD+0x365)[0x17cf88f] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z21mysql_execute_commandP3THDb+0x2f1b)[0x1598c25] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z11mysql_parseP3THDP12Parser_state+0x589)[0x159ebd8] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xcc7)[0x15937b4] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(_Z10do_commandP3THD+0x4b3)[0x15925f9] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(handle_connection+0x1e7)[0x16c8e81] /export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug(pfs_spawn_thread+0x170)[0x190f228] /lib64/libpthread.so.0(+0x7df5)[0x7fd60618adf5] /lib64/libc.so.6(clone+0x6d)[0x7fd604c4a60d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fd5b0e7d500): insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c) Connection ID (thread ID): 3 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file safe_process[7782]: Child process: 7783, killed by signal: 6 ----------SERVER LOG END------------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-5.7.27/mysql-test/var/log/main.bug96578/bug96578.log' - found 'core.7783' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 7809] [New LWP 7812] [New LWP 7789] [New LWP 7786] [New LWP 7797] [New LWP 7794] [New LWP 7784] [New LWP 7787] [New LWP 7785] [New LWP 7793] [New LWP 7788] [New LWP 7800] [New LWP 7783] [New LWP 7801] [New LWP 7803] [New LWP 7802] [New LWP 7804] [New LWP 7808] [New LWP 7807] [New LWP 7790] [New LWP 7796] [New LWP 7798] [New LWP 7795] [New LWP 7791] [New LWP 7799] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/umesh/server/binaries/GABuilds/mysql-5.7.27/bin/mysqld-debug --defaults'. Program terminated with signal 6, Aborted. #0 0x00007fd60618f771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007fd60618f771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018e4501 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/mysys/stacktrace.c:249 #2 0x0000000000ee0c12 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/signal_handler.cc:220 #3 #4 0x00007fd604b895d7 in raise () from /lib64/libc.so.6 #5 0x00007fd604b8acc8 in abort () from /lib64/libc.so.6 #6 0x00007fd604b82546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fd604b825f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000f5ded1 in handler::update_auto_increment (this=0x7fd5b0d946d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/handler.cc:3497 #9 0x00000000019ad367 in ha_innobase::write_row (this=0x7fd5b0d946d0, record=0x7fd5b0d8cde0 "") at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/handler/ha_innodb.cc:7567 #10 0x0000000000f67aec in handler::ha_write_row (this=0x7fd5b0d946d0, buf=0x7fd5b0d8cde0 "") at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/handler.cc:8086 #11 0x00000000017cb661 in write_record (thd=0x7fd5b01206c0, table=0x7fd5b0dceb90, info=0x7fd5b0e7f3a8, update=0x7fd5b0e7f420) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_insert.cc:1531 #12 0x00000000017ccc3d in Query_result_insert::send_data (this=0x7fd5b0e7f360, values=...) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_insert.cc:2280 #13 0x0000000001553252 in end_send (join=0x7fd5b0dca1d0, qep_tab=0x7fd5b0dcaa28, end_of_records=false) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:2927 #14 0x000000000154fe99 in evaluate_join_record (join=0x7fd5b0dca1d0, qep_tab=0x7fd5b0dca8b0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:1645 #15 0x000000000154f29a in sub_select (join=0x7fd5b0dca1d0, qep_tab=0x7fd5b0dca8b0, end_of_records=false) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:1297 #16 0x000000000154eb0e in do_select (join=0x7fd5b0dca1d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:950 #17 0x000000000154c9ca in JOIN::exec (this=0x7fd5b0dca1d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:199 #18 0x00000000015e8c7a in handle_query (thd=0x7fd5b01206c0, lex=0x7fd5b0122858, result=0x7fd5b0e7f360, added_options=1342177280, removed_options=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_select.cc:184 #19 0x00000000017cf88f in Sql_cmd_insert_select::execute (this=0x7fd5b0e7f2e8, thd=0x7fd5b01206c0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_insert.cc:3227 #20 0x0000000001598c25 in mysql_execute_command (thd=0x7fd5b01206c0, first_level=true) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:3596 #21 0x000000000159ebd8 in mysql_parse (thd=0x7fd5b01206c0, parser_state=0x7fd5fd206690) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:5570 #22 0x00000000015937b4 in dispatch_command (thd=0x7fd5b01206c0, com_data=0x7fd5fd206e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:1484 #23 0x00000000015925f9 in do_command (thd=0x7fd5b01206c0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:1025 #24 0x00000000016c8e81 in handle_connection (arg=0x3fdf3d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/conn_handler/connection_handler_per_thread.cc:306 #25 0x000000000190f228 in pfs_spawn_thread (arg=0x3f9e080) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/perfschema/pfs.cc:2190 #26 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #27 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fd5e7fff700 (LWP 7799)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7f307 in os_event::wait (this=0x36cdf08) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:171 #2 0x0000000001a7e79d in os_event::wait_low (this=0x36cdf08, reset_sig_count=7) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:358 #3 0x0000000001a7ef31 in os_event_wait_low (event=0x36cdf08, reset_sig_count=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:603 #4 0x0000000001b7baa1 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2519 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fd5f4dfa700 (LWP 7791)): #0 0x00007fd60618eab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7e626 in os_event::timed_wait (this=0x36ce228, abstime=0x7fd5f4df9930) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:308 #2 0x0000000001a7eca6 in os_event::wait_time_low (this=0x36ce228, time_in_usec=847000, reset_sig_count=2) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:480 #3 0x0000000001a7ef0c in os_event_wait_time_low (event=0x36ce228, time_in_usec=847000, reset_sig_count=2) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:586 #4 0x0000000001c68067 in pc_sleep_if_needed (next_loop_time=9124761882, sig_count=2) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/buf/buf0flu.cc:2692 #5 0x0000000001c692b1 in buf_flush_page_cleaner_coordinator (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/buf/buf0flu.cc:3193 #6 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fd5eebfd700 (LWP 7795)): #0 0x00007fd60618eab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7e626 in os_event::timed_wait (this=0x36ce0e8, abstime=0x7fd5eebfce50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:308 #2 0x0000000001a7eca6 in os_event::wait_time_low (this=0x36ce0e8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:480 #3 0x0000000001a7ef0c in os_event_wait_time_low (event=0x36ce0e8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:586 #4 0x0000000001b79c97 in srv_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:1584 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fd5ecdfa700 (LWP 7798)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7f307 in os_event::wait (this=0x36cde68) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:171 #2 0x0000000001a7e79d in os_event::wait_low (this=0x36cde68, reset_sig_count=7) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:358 #3 0x0000000001a7ef31 in os_event_wait_low (event=0x36cde68, reset_sig_count=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:603 #4 0x0000000001b7baa1 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2519 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fd5ee1fc700 (LWP 7796)): #0 0x00007fd60619199d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000001a7f856 in os_thread_sleep (tm=1000000) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0thread.cc:279 #2 0x0000000001b7b452 in srv_master_sleep () at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2329 #3 0x0000000001b7b5c0 in srv_master_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2376 #4 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fd5f57fb700 (LWP 7790)): #0 0x00007fd605f81644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a6e11b in LinuxAIOHandler::collect (this=0x7fd5f57fada0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2506 #2 0x0000000001a6e656 in LinuxAIOHandler::poll (this=0x7fd5f57fada0, m1=0x7fd5f57fae90, m2=0x7fd5f57fae88, request=0x7fd5f57fae50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2666 #3 0x0000000001a6e7e1 in os_aio_linux_handler (global_segment=5, m1=0x7fd5f57fae90, m2=0x7fd5f57fae88, request=0x7fd5f57fae50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2722 #4 0x0000000001a7331b in os_aio_handler (segment=5, m1=0x7fd5f57fae90, m2=0x7fd5f57fae88, request=0x7fd5f57fae50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:6268 #5 0x0000000001cda432 in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fil/fil0fil.cc:5854 #6 0x0000000001b7fd75 in io_handler_thread (arg=0x2e8fe48 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0start.cc:311 #7 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fd5fd248700 (LWP 7807)): #0 0x00007fd606191ec1 in sigwait () from /lib64/libpthread.so.0 #1 0x0000000000ecbbc2 in signal_hand (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/mysqld.cc:2125 #2 0x000000000190f228 in pfs_spawn_thread (arg=0x3fa59d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/perfschema/pfs.cc:2190 #3 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fd5bffff700 (LWP 7808)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001802d98 in native_cond_wait (cond=0x2de3600 , mutex=0x2de35c0 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/include/thr_cond.h:140 #2 0x0000000001802dd7 in my_cond_wait (cond=0x2de3600 , mp=0x2de35c0 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/include/thr_cond.h:195 #3 0x00000000018030c7 in inline_mysql_cond_wait (that=0x2de3600 , mutex=0x2de35c0 , src_file=0x227d5a8 "/export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/rpl_gtid_persist.cc", src_line=879) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/include/mysql/psi/mysql_thread.h:1184 #4 0x0000000001805b79 in compress_gtid_table (p_thd=0x3ff7270) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/rpl_gtid_persist.cc:879 #5 0x000000000190f228 in pfs_spawn_thread (arg=0x3f9e080) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/perfschema/pfs.cc:2190 #6 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fd5e4dfa700 (LWP 7804)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7f307 in os_event::wait (this=0x36ce2c8) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:171 #2 0x0000000001a7e79d in os_event::wait_low (this=0x36ce2c8, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:358 #3 0x0000000001a7ef31 in os_event_wait_low (event=0x36ce2c8, reset_sig_count=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:603 #4 0x0000000001c48da4 in buf_resize_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/buf/buf0buf.cc:3019 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fd5e61fc700 (LWP 7802)): #0 0x00007fd60618eab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7e626 in os_event::timed_wait (this=0x3bc4a18, abstime=0x7fd5e61fbe90) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:308 #2 0x0000000001a7eca6 in os_event::wait_time_low (this=0x3bc4a18, time_in_usec=10000000, reset_sig_count=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:480 #3 0x0000000001a7ef0c in os_event_wait_time_low (event=0x3bc4a18, time_in_usec=10000000, reset_sig_count=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:586 #4 0x0000000001cc3bb1 in dict_stats_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/dict/dict0stats_bg.cc:427 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fd5e57fb700 (LWP 7803)): #0 0x00007fd60618eab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7e626 in os_event::timed_wait (this=0x3c134f8, abstime=0x7fd5e57fac90) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:308 #2 0x0000000001a7eca6 in os_event::wait_time_low (this=0x3c134f8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:480 #3 0x0000000001a7ef0c in os_event_wait_time_low (event=0x3c134f8, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:586 #4 0x0000000001becb4f in ib_wqueue_timedwait (wq=0x3c13338, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/ut/ut0wqueue.cc:160 #5 0x0000000001d1fe4c in fts_optimize_thread (arg=0x3c13338) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fts/fts0opt.cc:2902 #6 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fd5e6bfd700 (LWP 7801)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7f307 in os_event::wait (this=0x36ce188) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:171 #2 0x0000000001a7e79d in os_event::wait_low (this=0x36ce188, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:358 #3 0x0000000001a7ef31 in os_event_wait_low (event=0x36ce188, reset_sig_count=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:603 #4 0x0000000001c5ee61 in buf_dump_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/buf/buf0dump.cc:784 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fd606597740 (LWP 7783)): #0 0x00007fd604c4000d in poll () from /lib64/libc.so.6 #1 0x00000000016cb705 in Mysqld_socket_listener::listen_for_connection_event (this=0x3c10ec0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/conn_handler/socket_connection.cc:852 #2 0x0000000000ed9f04 in Connection_acceptor::connection_event_loop (this=0x3c31820) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/conn_handler/connection_acceptor.h:66 #3 0x0000000000ed17a9 in mysqld_main (argc=94, argv=0x3553448) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/mysqld.cc:5146 #4 0x0000000000ec87e4 in main (argc=9, argv=0x7ffcc943d428) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/main.cc:25 Thread 12 (Thread 0x7fd5e75fe700 (LWP 7800)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7f307 in os_event::wait (this=0x36cdfa8) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:171 #2 0x0000000001a7e79d in os_event::wait_low (this=0x36cdfa8, reset_sig_count=6) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:358 #3 0x0000000001a7ef31 in os_event_wait_low (event=0x36cdfa8, reset_sig_count=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:603 #4 0x0000000001b7baa1 in srv_worker_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2519 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fd5f6bfd700 (LWP 7788)): #0 0x00007fd605f81644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a6e11b in LinuxAIOHandler::collect (this=0x7fd5f6bfcda0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2506 #2 0x0000000001a6e656 in LinuxAIOHandler::poll (this=0x7fd5f6bfcda0, m1=0x7fd5f6bfce90, m2=0x7fd5f6bfce88, request=0x7fd5f6bfce50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2666 #3 0x0000000001a6e7e1 in os_aio_linux_handler (global_segment=3, m1=0x7fd5f6bfce90, m2=0x7fd5f6bfce88, request=0x7fd5f6bfce50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2722 #4 0x0000000001a7331b in os_aio_handler (segment=3, m1=0x7fd5f6bfce90, m2=0x7fd5f6bfce88, request=0x7fd5f6bfce50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:6268 #5 0x0000000001cda432 in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fil/fil0fil.cc:5854 #6 0x0000000001b7fd75 in io_handler_thread (arg=0x2e8fe38 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0start.cc:311 #7 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fd5effff700 (LWP 7793)): #0 0x00007fd60618eab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7e626 in os_event::timed_wait (this=0x3b92db8, abstime=0x7fd5efffee70) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:308 #2 0x0000000001a7eca6 in os_event::wait_time_low (this=0x3b92db8, time_in_usec=1000000, reset_sig_count=2) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:480 #3 0x0000000001a7ef0c in os_event_wait_time_low (event=0x3b92db8, time_in_usec=1000000, reset_sig_count=2) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:586 #4 0x0000000001a46a9d in lock_wait_timeout_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/lock/lock0wait.cc:489 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fd5fcfe5700 (LWP 7785)): #0 0x00007fd605f81644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a6e11b in LinuxAIOHandler::collect (this=0x7fd5fcfe4da0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2506 #2 0x0000000001a6e656 in LinuxAIOHandler::poll (this=0x7fd5fcfe4da0, m1=0x7fd5fcfe4e90, m2=0x7fd5fcfe4e88, request=0x7fd5fcfe4e50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2666 #3 0x0000000001a6e7e1 in os_aio_linux_handler (global_segment=0, m1=0x7fd5fcfe4e90, m2=0x7fd5fcfe4e88, request=0x7fd5fcfe4e50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2722 #4 0x0000000001a7331b in os_aio_handler (segment=0, m1=0x7fd5fcfe4e90, m2=0x7fd5fcfe4e88, request=0x7fd5fcfe4e50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:6268 #5 0x0000000001cda432 in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fil/fil0fil.cc:5854 #6 0x0000000001b7fd75 in io_handler_thread (arg=0x2e8fe20 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0start.cc:311 #7 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fd5f75fe700 (LWP 7787)): #0 0x00007fd605f81644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a6e11b in LinuxAIOHandler::collect (this=0x7fd5f75fdda0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2506 #2 0x0000000001a6e656 in LinuxAIOHandler::poll (this=0x7fd5f75fdda0, m1=0x7fd5f75fde90, m2=0x7fd5f75fde88, request=0x7fd5f75fde50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2666 #3 0x0000000001a6e7e1 in os_aio_linux_handler (global_segment=2, m1=0x7fd5f75fde90, m2=0x7fd5f75fde88, request=0x7fd5f75fde50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2722 #4 0x0000000001a7331b in os_aio_handler (segment=2, m1=0x7fd5f75fde90, m2=0x7fd5f75fde88, request=0x7fd5f75fde50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:6268 #5 0x0000000001cda432 in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fil/fil0fil.cc:5854 #6 0x0000000001b7fd75 in io_handler_thread (arg=0x2e8fe30 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0start.cc:311 #7 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fd5ffeb7700 (LWP 7784)): #0 0x00007fd604b8a7da in sigwaitinfo () from /lib64/libc.so.6 #1 0x00000000018edbf1 in timer_notify_thread_func (arg=0x7ffcc943c9e0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/mysys/posix_timers.c:77 #2 0x000000000190f228 in pfs_spawn_thread (arg=0x3664930) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/perfschema/pfs.cc:2190 #3 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fd5ef5fe700 (LWP 7794)): #0 0x00007fd60618eab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7e626 in os_event::timed_wait (this=0x36ce048, abstime=0x7fd5ef5fdb80) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:308 #2 0x0000000001a7eca6 in os_event::wait_time_low (this=0x36ce048, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:480 #3 0x0000000001a7ef0c in os_event_wait_time_low (event=0x36ce048, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:586 #4 0x0000000001b7a1ef in srv_error_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:1750 #5 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fd5ed7fb700 (LWP 7797)): #0 0x00007fd60618e705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001a7f307 in os_event::wait (this=0x36cddc8) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:171 #2 0x0000000001a7e79d in os_event::wait_low (this=0x36cddc8, reset_sig_count=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:358 #3 0x0000000001a7ef31 in os_event_wait_low (event=0x36cddc8, reset_sig_count=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0event.cc:603 #4 0x0000000001b7bf75 in srv_purge_coordinator_suspend (slot=0x36cd9c0, rseg_history_len=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2675 #5 0x0000000001b7c4a8 in srv_purge_coordinator_thread (arg=0x0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0srv.cc:2791 #6 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fd5f7fff700 (LWP 7786)): #0 0x00007fd605f81644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a6e11b in LinuxAIOHandler::collect (this=0x7fd5f7ffeda0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2506 #2 0x0000000001a6e656 in LinuxAIOHandler::poll (this=0x7fd5f7ffeda0, m1=0x7fd5f7ffee90, m2=0x7fd5f7ffee88, request=0x7fd5f7ffee50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2666 #3 0x0000000001a6e7e1 in os_aio_linux_handler (global_segment=1, m1=0x7fd5f7ffee90, m2=0x7fd5f7ffee88, request=0x7fd5f7ffee50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2722 #4 0x0000000001a7331b in os_aio_handler (segment=1, m1=0x7fd5f7ffee90, m2=0x7fd5f7ffee88, request=0x7fd5f7ffee50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:6268 #5 0x0000000001cda432 in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fil/fil0fil.cc:5854 #6 0x0000000001b7fd75 in io_handler_thread (arg=0x2e8fe28 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0start.cc:311 #7 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fd5f61fc700 (LWP 7789)): #0 0x00007fd605f81644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001a6e11b in LinuxAIOHandler::collect (this=0x7fd5f61fbda0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2506 #2 0x0000000001a6e656 in LinuxAIOHandler::poll (this=0x7fd5f61fbda0, m1=0x7fd5f61fbe90, m2=0x7fd5f61fbe88, request=0x7fd5f61fbe50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2666 #3 0x0000000001a6e7e1 in os_aio_linux_handler (global_segment=4, m1=0x7fd5f61fbe90, m2=0x7fd5f61fbe88, request=0x7fd5f61fbe50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:2722 #4 0x0000000001a7331b in os_aio_handler (segment=4, m1=0x7fd5f61fbe90, m2=0x7fd5f61fbe88, request=0x7fd5f61fbe50) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/os/os0file.cc:6268 #5 0x0000000001cda432 in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/fil/fil0fil.cc:5854 #6 0x0000000001b7fd75 in io_handler_thread (arg=0x2e8fe40 ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/srv/srv0start.cc:311 #7 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fd5fd1c6700 (LWP 7812)): #0 0x00007fd604c4000d in poll () from /lib64/libc.so.6 #1 0x0000000001df1373 in vio_io_wait (vio=0x7fd5b4000970, event=VIO_IO_EVENT_READ, timeout=28800000) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/vio/viosocket.c:786 #2 0x0000000001df01b6 in vio_socket_io_wait (vio=0x7fd5b4000970, event=VIO_IO_EVENT_READ) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/vio/viosocket.c:77 #3 0x0000000001df0292 in vio_read (vio=0x7fd5b4000970, buf=0x7fd5b400a3c0 ".", size=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/vio/viosocket.c:132 #4 0x000000000149b69f in net_read_raw_loop (net=0x7fd5b4002348, count=4) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/net_serv.cc:672 #5 0x000000000149b876 in net_read_packet_header (net=0x7fd5b4002348) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/net_serv.cc:756 #6 0x000000000149b97f in net_read_packet (net=0x7fd5b4002348, complen=0x7fd5fd1c5ce8) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/net_serv.cc:822 #7 0x000000000149bb12 in my_net_read (net=0x7fd5b4002348) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/net_serv.cc:899 #8 0x00000000014b257c in Protocol_classic::read_packet (this=0x7fd5b4001bc8) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/protocol_classic.cc:808 #9 0x00000000014b2a80 in Protocol_classic::get_command (this=0x7fd5b4001bc8, com_data=0x7fd5fd1c5e00, cmd=0x7fd5fd1c5e28) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/protocol_classic.cc:965 #10 0x00000000015922ab in do_command (thd=0x7fd5b4000b70) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:964 #11 0x00000000016c8e81 in handle_connection (arg=0x3fdf3d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/conn_handler/connection_handler_per_thread.cc:306 #12 0x000000000190f228 in pfs_spawn_thread (arg=0x3f9e080) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/perfschema/pfs.cc:2190 #13 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fd5fd207700 (LWP 7809)): #0 0x00007fd60618f771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018e4501 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/mysys/stacktrace.c:249 #2 0x0000000000ee0c12 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/signal_handler.cc:220 #3 #4 0x00007fd604b895d7 in raise () from /lib64/libc.so.6 #5 0x00007fd604b8acc8 in abort () from /lib64/libc.so.6 #6 0x00007fd604b82546 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fd604b825f2 in __assert_fail () from /lib64/libc.so.6 #8 0x0000000000f5ded1 in handler::update_auto_increment (this=0x7fd5b0d946d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/handler.cc:3497 #9 0x00000000019ad367 in ha_innobase::write_row (this=0x7fd5b0d946d0, record=0x7fd5b0d8cde0 "") at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/innobase/handler/ha_innodb.cc:7567 #10 0x0000000000f67aec in handler::ha_write_row (this=0x7fd5b0d946d0, buf=0x7fd5b0d8cde0 "") at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/handler.cc:8086 #11 0x00000000017cb661 in write_record (thd=0x7fd5b01206c0, table=0x7fd5b0dceb90, info=0x7fd5b0e7f3a8, update=0x7fd5b0e7f420) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_insert.cc:1531 #12 0x00000000017ccc3d in Query_result_insert::send_data (this=0x7fd5b0e7f360, values=...) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_insert.cc:2280 #13 0x0000000001553252 in end_send (join=0x7fd5b0dca1d0, qep_tab=0x7fd5b0dcaa28, end_of_records=false) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:2927 #14 0x000000000154fe99 in evaluate_join_record (join=0x7fd5b0dca1d0, qep_tab=0x7fd5b0dca8b0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:1645 #15 0x000000000154f29a in sub_select (join=0x7fd5b0dca1d0, qep_tab=0x7fd5b0dca8b0, end_of_records=false) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:1297 #16 0x000000000154eb0e in do_select (join=0x7fd5b0dca1d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:950 #17 0x000000000154c9ca in JOIN::exec (this=0x7fd5b0dca1d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_executor.cc:199 #18 0x00000000015e8c7a in handle_query (thd=0x7fd5b01206c0, lex=0x7fd5b0122858, result=0x7fd5b0e7f360, added_options=1342177280, removed_options=0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_select.cc:184 #19 0x00000000017cf88f in Sql_cmd_insert_select::execute (this=0x7fd5b0e7f2e8, thd=0x7fd5b01206c0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_insert.cc:3227 #20 0x0000000001598c25 in mysql_execute_command (thd=0x7fd5b01206c0, first_level=true) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:3596 #21 0x000000000159ebd8 in mysql_parse (thd=0x7fd5b01206c0, parser_state=0x7fd5fd206690) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:5570 #22 0x00000000015937b4 in dispatch_command (thd=0x7fd5b01206c0, com_data=0x7fd5fd206e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:1484 #23 0x00000000015925f9 in do_command (thd=0x7fd5b01206c0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/sql_parse.cc:1025 #24 0x00000000016c8e81 in handle_connection (arg=0x3fdf3d0) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/sql/conn_handler/connection_handler_per_thread.cc:306 #25 0x000000000190f228 in pfs_spawn_thread (arg=0x3f9e080) at /export/home/pb2/build/sb_0-34537258-1560179931.8/mysql-5.7.27/storage/perfschema/pfs.cc:2190 #26 0x00007fd60618adf5 in start_thread () from /lib64/libpthread.so.0 #27 0x00007fd604c4a60d in clone () from /lib64/libc.so.6 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 330 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.bug96578 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases -- 5.6.45 ./mtr --debug-server --mysqld='--innodb-autoinc-lock-mode=2' bug96578 Logging: ./mtr --debug-server --mysqld=--innodb-autoinc-lock-mode=2 bug96578 2019-08-17 08:08:51 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2019-08-17 08:08:51 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.45/bin/mysqld-debug (mysqld 5.6.45-debug) starting as process 7905 ... 2019-08-17 08:08:51 7905 [Note] Plugin 'FEDERATED' is disabled. 2019-08-17 08:08:51 7905 [Note] Binlog end 2019-08-17 08:08:51 7905 [Note] Shutting down plugin 'CSV' 2019-08-17 08:08:51 7905 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.45 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.6.45/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; create table temp1 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp1 values (1, 'b1', 'c1'), (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); create table temp2 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp2 values (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); CREATE TABLE extra ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL, PRIMARY KEY (id), UNIQUE KEY uniq_idx (a,b) ) engine = innodb; insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c); insert into extra(a, b, c) select * from temp2 on duplicate key update c=values(c); select id, a, b, c from extra; id a b c 1 2 b2 c2 2 1 b1 c1 5 3 b3 c3 6 4 b4 c4 7 5 b5 c5 drop table extra; main.bug96578 [ pass ] 42 MTR's internal check of the test case 'main.bug96578' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/binaries/GABuilds/mysql-5.6.45/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/umesh/server/binaries/GABuilds/mysql-5.6.45/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/umesh/server/binaries/GABuilds/mysql-5.6.45/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/binaries/GABuilds/mysql-5.6.45/mysql-test/var/tmp/check-mysqld_1.result 2019-08-17 09:08:56.972128999 +0300 +++ /export/umesh/server/binaries/GABuilds/mysql-5.6.45/mysql-test/var/tmp/check-mysqld_1.reject 2019-08-17 09:08:57.180133727 +0300 @@ -533,6 +533,8 @@ def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +temp1 +temp2 tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.042 of 7 seconds executing testcases Check of testcase failed for: main.bug96578 Completed: All 1 tests were successful. ############### 8.0.17 ############### src build after commenting assert - cmake details export LD_LIBRARY_PATH=/export/umesh/utils/GCC-7.3.0/lib64 export CC=/export/umesh/utils/GCC-7.3.0/bin/gcc export CPP=/export/umesh/utils/GCC-7.3.0/bin/cpp export CXX=/export/umesh/utils/GCC-7.3.0/bin/c++ - build details - comment out Assertion vi sql/handler.cc 3588 /* DBUG_ASSERT(next_insert_id >= auto_inc_interval_for_cur_row.minimum()); */ rm -rf bld/ mkdir bld && cd bld rm -rf CMakeCache.txt /export/umesh/utils/cmake-3.14.4/bin/cmake .. \ -DBUILD_CONFIG=mysql_release \ -DINSTALL_LAYOUT=STANDALONE \ -DWITH_NDBCLUSTER_STORAGE_ENGINE=0 \ -DCMAKE_INSTALL_PREFIX=$PWD \ -DWITH_BOOST=../boost make -j32 make install cd mysql-test ./mtr --nocheck-testcases bug96578 Logging: ./mtr --nocheck-testcases bug96578 MySQL Version 8.0.17 Too long tmpdir path '/export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-8.0.17/bld/mysql-test/var/tmp' creating a shorter one - Using tmpdir: '/tmp/GSv15eavur' Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-8.0.17/bld/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; create table temp1 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp1 values (1, 'b1', 'c1'), (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); create table temp2 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp2 values (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); CREATE TABLE extra ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL, PRIMARY KEY (id), UNIQUE KEY uniq_idx (a,b) ) engine = innodb; Warnings: Warning 1681 Integer display width is deprecated and will be removed in a future release. insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c); insert into extra(a, b, c) select * from temp2 on duplicate key update c=values(c); select id, a, b, c from extra; id a b c 1 1 b1 c1 2 2 b2 c2 3 3 b3 c3 5 4 b4 c4 6 5 b5 c5 drop table extra; [100%] main.bug96578 [ pass ] 52 ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.052 of 7 seconds executing testcases Completed: All 1 tests were successful. ### 5.7.27 - build details - comment out Assertion vi sql/handler.cc 3588 /* DBUG_ASSERT(next_insert_id >= auto_inc_interval_for_cur_row.minimum()); */ 3497 /* DBUG_ASSERT(next_insert_id >= auto_inc_interval_for_cur_row.minimum()); */ rm -rf bld/ mkdir bld && cd bld rm -rf CMakeCache.txt /export/umesh/utils/cmake-3.14.4/bin/cmake .. \ -DBUILD_CONFIG=mysql_release \ -DINSTALL_LAYOUT=STANDALONE \ -DWITH_NDBCLUSTER_STORAGE_ENGINE=0 \ -DCMAKE_INSTALL_PREFIX=$PWD \ -DWITH_BOOST=../boost make -j32 make install cd mysql-test ./mtr --mysqld='--innodb-autoinc-lock-mode=2' bug96578 Logging: ./mtr --mysqld=--innodb-autoinc-lock-mode=2 bug96578 MySQL Version 5.7.27 Too long tmpdir path '/export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-5.7.27/bld/mysql-test/var/tmp' creating a shorter one... - using tmpdir: '/tmp/tXVlQL_M5e' Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-5.7.27/bld/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; create table temp1 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp1 values (1, 'b1', 'c1'), (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); create table temp2 (a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL); insert into temp2 values (2,'b2','c2'),(3,'b3','c3'),(4,'b4','c4'),(5,'b5','c5'); CREATE TABLE extra ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, a varchar(36) NOT NULL, b varchar(128) NOT NULL, c varchar(10240) NOT NULL, PRIMARY KEY (id), UNIQUE KEY uniq_idx (a,b) ) engine = innodb; insert into extra(a, b, c) select * from temp1 on duplicate key update c=values(c); insert into extra(a, b, c) select * from temp2 on duplicate key update c=values(c); select id, a, b, c from extra; id a b c 1 1 b1 c1 3 2 b2 c2 4 3 b3 c3 5 4 b4 c4 6 5 b5 c5 drop table extra; [100%] main.bug96578 [ pass ] 18 MTR's internal check of the test case 'main.bug96578' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-5.7.27/bld/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-5.7.27/bld/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /tmp/tXVlQL_M5e/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-5.7.27/bld/mysql-test/var/tmp/check-mysqld_1.result 2019-08-17 09:56:23.251011179 +0300 +++ /export/umesh/server/source/bugs/src_build/fb_builds/96578/mysql-5.7.27/bld/mysql-test/var/tmp/check-mysqld_1.reject 2019-08-17 09:56:23.476016431 +0300 @@ -600,6 +600,8 @@ def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +temp1 +temp2 tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok safe_process[20625]: Child process: 20626, exit: 1 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.018 of 4 seconds executing testcases Check of testcase failed for: main.bug96578 Completed: All 1 tests were successful.