【事件描述】
突然之间大量的连接进入数据库、并放开手干，这个使得mysql使用了大量的内存，触发了linux的oom机制。然后mysql就这样
被linux给干掉了。没错MySQL宕机了，要相信我说的话，因为这个事就是我干的，我用sysbench发起了大量连接去压测mysql。
新版本出来了不把它往死里压、我又怎么知道MySQL增强了多少？ 但是这个不是重点、重点是MySQL-8.0.11的故障恢复真的是气死我了
【error log 日志】
2018-06-25T14:16:10.002553+08:00 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.11) starting as process 4030 2018-06-25T14:22:46.993105+08:00 0 [System] [MY-010229] [Server] Starting crash recovery... 2018-06-25T14:22:46.993259+08:00 0 [System] [MY-010232] [Server] Crash recovery finished. 2018-06-25T14:22:48.234620+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2018-06-25T14:22:48.250904+08:00 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.infoschema@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.250975+08:00 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.251001+08:00 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.251023+08:00 0 [Warning] [MY-010315] [Server] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.251087+08:00 0 [Warning] [MY-010323] [Server] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.251108+08:00 0 [Warning] [MY-010323] [Server] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.251133+08:00 0 [Warning] [MY-010311] [Server] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.254446+08:00 0 [Warning] [MY-010330] [Server] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.254483+08:00 0 [Warning] [MY-010330] [Server] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-06-25T14:22:48.261166+08:00 0 [System] [MY-010931] [Server] /usr/local/mysql/bin/mysqld: ready for connections. Version: '8.0.11' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL.
注意看上面的日志 我启动MySQL时间点是 2018-06-25T14:16:10.002553+08:00 一直到 2018-06-25T14:22:46.993105+08:00
我才看到下一行日志中间我知道它在干什么、也不知道进度、作为一个dba我希望有个进度条呀！
不过有了进度条好像也只能等 ... ...
【希望有牛逼的大佬来分析一下pstack的信息】
Thread 21 (Thread 0x7f5a231f7700 (LWP 4031)): #0 0x00007f5a23e8f0ef in malloc () from /lib64/libc.so.6 #1 0x0000000001b4f9eb in ut_allocator<unsigned char>::allocate (this=0x7f5a231e5f88, n_elements=10, hint=<optimized out>, key=0, set_to_zero=false, throw_on_error=<optimized out>) at ../../../mysql-8.0.11/storage/innobase/include/ut0new.h:599 #2 0x0000000001d1a870 in mem_strdup (str=0x2074522 "LOG_DUMMY") at ../../../mysql-8.0.11/storage/innobase/include/mem0mem.ic:543 #3 dict_mem_table_create (name=name@entry=0x2074522 "LOG_DUMMY", space=space@entry=0, n_cols=n_cols@entry=2, n_v_cols=n_v_cols@entry=0, flags=flags@entry=1, flags2=flags2@entry=0) at ../../../mysql-8.0.11/storage/innobase/dict/mem.cc:188 #4 0x0000000001c03bb1 in mlog_parse_index (ptr=<optimized out>, ptr@entry=0x7f5a20e91adf "", end_ptr=end_ptr@entry=0x7f5a20e99cdb " 04200 05", <incomplete sequence 372>, comp=<optimized out>, index=index@entry=0x7f5a231e6058) at ../../../mysql-8.0.11/storage/innobase/mtr/mtr0log.cc:548 #5 0x0000000001beba2f in recv_parse_or_apply_log_rec_body (type=MLOG_COMP_REC_INSERT, ptr=0x7f5a20e91adf "", end_ptr=end_ptr@entry=0x7f5a20e99cdb " 04200 05", <incomplete sequence 372>, space_id=<optimized out>, page_no=<optimized out>, block=block@entry=0x0, mtr=0x0, parsed_bytes=4) at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:1875 #6 0x0000000001bf2f6d in recv_parse_log_rec (type=type@entry=0x7f5a231e631c, ptr=ptr@entry=0x7f5a20e91adb "&8251b", end_ptr=end_ptr@entry=0x7f5a20e99cdb " 04200 05", <incomplete sequence 372>, space_id=space_id@entry=0x7f5a231e6340, page_no=page_no@entry=0x7f5a231e6328, body=body@entry=0x7f5a231e6cb0) at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:2621 #7 0x0000000001bf597d in recv_multi_rec (end_ptr=<optimized out>, ptr=0x7f5a20e91adb "&8251b") at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:2850 #8 recv_parse_log_recs (checkpoint_lsn=<optimized out>) at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:2954 #9 recv_scan_log_recs (checkpoint_lsn=<optimized out>, read_upto_lsn=<optimized out>, contiguous_lsn=<optimized out>, start_lsn=<optimized out>, len=<optimized out>, buf=<optimized out>, max_memory=<optimized out>, log=...) at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:3251 #10 recv_recovery_begin (contiguous_lsn=<synthetic pointer>, log=...) at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:3374 #11 recv_recovery_from_checkpoint_start (log=..., flush_lsn=<optimized out>) at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:3560 #12 0x0000000001cc6f3f in srv_start (create_new_db=create_new_db@entry=false, scan_directories="./;./;./") at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:2135 #13 0x0000000001b6fd25 in innobase_init_files (tablespaces=0x7f5a231f5740, dict_init_mode=<optimized out>) at ../../../mysql-8.0.11/storage/innobase/handler/ha_innodb.cc:4413 #14 innobase_ddse_dict_init (dict_init_mode=<optimized out>, version=<optimized out>, tables=0x7f5a231f5720, tablespaces=0x7f5a231f5740) at ../../../mysql-8.0.11/storage/innobase/handler/ha_innodb.cc:10823 #15 0x000000000199cc97 in dd::bootstrap::DDSE_dict_init (thd=<optimized out>, dict_init_mode=DICT_INIT_CHECK_FILES, version=80011) at ../../mysql-8.0.11/sql/dd/impl/bootstrapper.cc:2079 #16 0x0000000001994c76 in dd::upgrade_57::do_pre_checks_and_initialize_dd (thd=0x3be16d0) at ../../mysql-8.0.11/sql/dd/upgrade/upgrade.cc:891 #17 0x0000000000d70f06 in bootstrap::handle_bootstrap (arg=arg@entry=0x3be16d0) at ../../mysql-8.0.11/sql/bootstrap.cc:346 #18 0x0000000001aa5f5f in pfs_spawn_thread (arg=0x3bed9a0) at ../../../mysql-8.0.11/storage/perfschema/pfs.cc:2814 #19 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #20 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7f5a1a7fc700 (LWP 4041)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f5a1a7fbc90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f5a1a7fbc90, m1=m1@entry=0x7f5a1a7fbd30, m2=m2@entry=0x7f5a1a7fbd38, request=request@entry=0x7f5a1a7fbd40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f5a1a7fbd40, m2=0x7f5a1a7fbd38, m1=0x7f5a1a7fbd30, global_segment=0) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=0, m1=m1@entry=0x7f5a1a7fbd30, m2=m2@entry=0x7f5a1a7fbd38, request=request@entry=0x7f5a1a7fbd40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=0) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=0) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2deca0: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2deca8) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2dec98) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2dec98) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2dec90) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7f5a1affd700 (LWP 4042)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f5a1affcc90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f5a1affcc90, m1=m1@entry=0x7f5a1affcd30, m2=m2@entry=0x7f5a1affcd38, request=request@entry=0x7f5a1affcd40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f5a1affcd40, m2=0x7f5a1affcd38, m1=0x7f5a1affcd30, global_segment=1) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=1, m1=m1@entry=0x7f5a1affcd30, m2=m2@entry=0x7f5a1affcd38, request=request@entry=0x7f5a1affcd40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=1) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=1) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e0b50: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2e0b58) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2e0b48) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2e0b48) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e0b40) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7f5a1b7fe700 (LWP 4043)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f5a1b7fdc90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f5a1b7fdc90, m1=m1@entry=0x7f5a1b7fdd30, m2=m2@entry=0x7f5a1b7fdd38, request=request@entry=0x7f5a1b7fdd40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f5a1b7fdd40, m2=0x7f5a1b7fdd38, m1=0x7f5a1b7fdd30, global_segment=2) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=2, m1=m1@entry=0x7f5a1b7fdd30, m2=m2@entry=0x7f5a1b7fdd38, request=request@entry=0x7f5a1b7fdd40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=2) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=2) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e23f0: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2e23f8) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2e23e8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2e23e8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e23e0) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7f5a1bfff700 (LWP 4044)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f5a1bffec90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f5a1bffec90, m1=m1@entry=0x7f5a1bffed30, m2=m2@entry=0x7f5a1bffed38, request=request@entry=0x7f5a1bffed40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f5a1bffed40, m2=0x7f5a1bffed38, m1=0x7f5a1bffed30, global_segment=3) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=3, m1=m1@entry=0x7f5a1bffed30, m2=m2@entry=0x7f5a1bffed38, request=request@entry=0x7f5a1bffed40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=3) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=3) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e1450: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2e1458) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2e1448) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2e1448) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e1440) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7f5a20dd2700 (LWP 4045)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f5a20dd1c90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f5a20dd1c90, m1=m1@entry=0x7f5a20dd1d30, m2=m2@entry=0x7f5a20dd1d38, request=request@entry=0x7f5a20dd1d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f5a20dd1d40, m2=0x7f5a20dd1d38, m1=0x7f5a20dd1d30, global_segment=4) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=4, m1=m1@entry=0x7f5a20dd1d30, m2=m2@entry=0x7f5a20dd1d38, request=request@entry=0x7f5a20dd1d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=4) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=4) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2df7f0: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2df7f8) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2df7e8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2df7e8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2df7e0) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7f59d4c33700 (LWP 4046)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f59d4c32c90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f59d4c32c90, m1=m1@entry=0x7f59d4c32d30, m2=m2@entry=0x7f59d4c32d38, request=request@entry=0x7f59d4c32d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f59d4c32d40, m2=0x7f59d4c32d38, m1=0x7f59d4c32d30, global_segment=5) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=5, m1=m1@entry=0x7f59d4c32d30, m2=m2@entry=0x7f59d4c32d38, request=request@entry=0x7f59d4c32d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=5) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=5) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e7ec0: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2e7ec8) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2e7eb8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2e7eb8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e7eb0) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7f579e24a700 (LWP 4047)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f579e249c90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f579e249c90, m1=m1@entry=0x7f579e249d30, m2=m2@entry=0x7f579e249d38, request=request@entry=0x7f579e249d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f579e249d40, m2=0x7f579e249d38, m1=0x7f579e249d30, global_segment=6) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=6, m1=m1@entry=0x7f579e249d30, m2=m2@entry=0x7f579e249d38, request=request@entry=0x7f579e249d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=6) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=6) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2ded40: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2ded48) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2ded38) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2ded38) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2ded30) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7f579da49700 (LWP 4048)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f579da48c90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f579da48c90, m1=m1@entry=0x7f579da48d30, m2=m2@entry=0x7f579da48d38, request=request@entry=0x7f579da48d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f579da48d40, m2=0x7f579da48d38, m1=0x7f579da48d30, global_segment=7) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=7, m1=m1@entry=0x7f579da48d30, m2=m2@entry=0x7f579da48d38, request=request@entry=0x7f579da48d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=7) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=7) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2df750: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2df758) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2df748) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2df748) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2df740) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7f579d248700 (LWP 4049)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f579d247c90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f579d247c90, m1=m1@entry=0x7f579d247d30, m2=m2@entry=0x7f579d247d38, request=request@entry=0x7f579d247d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f579d247d40, m2=0x7f579d247d38, m1=0x7f579d247d30, global_segment=8) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=8, m1=m1@entry=0x7f579d247d30, m2=m2@entry=0x7f579d247d38, request=request@entry=0x7f579d247d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=8) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=8) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e1c70: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2e1c78) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2e1c68) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2e1c68) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e1c60) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7f579ca47700 (LWP 4050)): #0 0x00007f5a25898644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001c0e419 in LinuxAIOHandler::collect (this=this@entry=0x7f579ca46c90) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2325 #2 0x0000000001c0ed3a in LinuxAIOHandler::poll (this=this@entry=0x7f579ca46c90, m1=m1@entry=0x7f579ca46d30, m2=m2@entry=0x7f579ca46d38, request=request@entry=0x7f579ca46d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2456 #3 0x0000000001c1163b in os_aio_linux_handler (request=0x7f579ca46d40, m2=0x7f579ca46d38, m1=0x7f579ca46d30, global_segment=9) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:2505 #4 os_aio_handler (segment=segment@entry=9, m1=m1@entry=0x7f579ca46d30, m2=m2@entry=0x7f579ca46d38, request=request@entry=0x7f579ca46d40) at ../../../mysql-8.0.11/storage/innobase/os/os0file.cc:5812 #5 0x0000000001e13742 in fil_aio_wait (segment=segment@entry=9) at ../../../mysql-8.0.11/storage/innobase/fil/fil0fil.cc:7270 #6 0x0000000001cba198 in io_handler_thread (segment=9) at ../../../mysql-8.0.11/storage/innobase/srv/srv0start.cc:264 #7 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #8 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #9 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #10 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #11 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e16d0: 0x1cba170 <io_handler_thread(ulint)>, this=0x7f5a1c2e16d8) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #12 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #13 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #14 _M_invoke<0, 1, 2> (this=0x7f5a1c2e16c8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #15 operator() (this=0x7f5a1c2e16c8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #16 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e16c0) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #17 0x000000000203d14f in execute_native_thread_routine () #18 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #19 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7f579c246700 (LWP 4051)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c337de8) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c337de8, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8b079 in buf_flush_page_coordinator_thread (n_page_cleaners=<optimized out>) at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:2921 #5 0x0000000001cba228 in __invoke_impl<void, void (*&)(unsigned long), unsigned long&> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)(unsigned long), unsigned long&> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void, 0> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)(long unsigned int), long unsigned int> (f=@0x7f5a1c2e0650: 0x1d8ace0 <buf_flush_page_coordinator_thread(size_t)>, this=0x7f5a1c2e0658) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)(unsigned long), unsigned long> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)(unsigned long), unsigned long> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1, 2> (this=0x7f5a1c2e0648) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a1c2e0648) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)(unsigned long), unsigned long> > >::_M_run (this=0x7f5a1c2e0640) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7f579ba45700 (LWP 4052)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a00000988: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a00000990) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a00000988) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a00000988) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a00000980) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7f579b244700 (LWP 4053)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a03627738: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a03627740) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a03627738) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a03627738) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a03627730) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f579aa43700 (LWP 4054)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a036279c8: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a036279d0) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a036279c8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a036279c8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a036279c0) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f579a242700 (LWP 4055)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a03627c58: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a03627c60) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a03627c58) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a03627c58) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a03627c50) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f5799a41700 (LWP 4056)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a03627ee8: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a03627ef0) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a03627ee8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a03627ee8) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a03627ee0) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f5799240700 (LWP 4057)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a03628178: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a03628180) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a03628178) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a03628178) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a03628170) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f5798a3f700 (LWP 4058)): #0 0x00007f5a25aa5945 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000001c16420 in wait (this=0x7f5a1c362918) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:179 #2 os_event::wait_low (this=0x7f5a1c362918, reset_sig_count=1876, reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:337 #3 0x0000000001c166fa in os_event_wait_low (event=<optimized out>, reset_sig_count=reset_sig_count@entry=0) at ../../../mysql-8.0.11/storage/innobase/os/os0event.cc:513 #4 0x0000000001d8a447 in buf_flush_page_cleaner_thread () at ../../../mysql-8.0.11/storage/innobase/buf/buf0flu.cc:3245 #5 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #6 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #7 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #8 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #9 operator()<void (*)()> (f=@0x7f5a03628408: 0x1d8a350 <buf_flush_page_cleaner_thread()>, this=0x7f5a03628410) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #10 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #11 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #12 _M_invoke<0, 1> (this=0x7f5a03628408) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #13 operator() (this=0x7f5a03628408) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #14 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a03628400) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #15 0x000000000203d14f in execute_native_thread_routine () #16 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f578ea3b700 (LWP 4059)): #0 0x00007f5a25aa8e4d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000001becf55 in sleep_for<long, std::ratio<1, 1000000> > (__rtime=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:376 #2 recv_writer_thread () at ../../../mysql-8.0.11/storage/innobase/log/log0recv.cc:750 #3 0x0000000001be7873 in __invoke_impl<void, void (*&)()> (__f=<optimized out>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #4 __invoke<void (*&)()> (__fn=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #5 __call<void> (__args=..., this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:467 #6 operator()<> (this=<synthetic pointer>) at /opt/rh/devtoolset-7/root/usr/include/c++/7/functional:551 #7 operator()<void (*)()> (f=@0x7f5a1c36bb68: 0x1bece30 <recv_writer_thread()>, this=0x7f5a1c36bb70) at ../../../mysql-8.0.11/storage/innobase/include/os0thread-create.h:92 #8 __invoke_impl<void, Runnable, void (*)()> (__f=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:60 #9 __invoke<Runnable, void (*)()> (__fn=...) at /opt/rh/devtoolset-7/root/usr/include/c++/7/bits/invoke.h:95 #10 _M_invoke<0, 1> (this=0x7f5a1c36bb68) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:234 #11 operator() (this=0x7f5a1c36bb68) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:243 #12 std::thread::_State_impl<std::thread::_Invoker<std::tuple<Runnable, void (*)()> > >::_M_run (this=0x7f5a1c36bb60) at /opt/rh/devtoolset-7/root/usr/include/c++/7/thread:186 #13 0x000000000203d14f in execute_native_thread_routine () #14 0x00007f5a25aa1e25 in start_thread () from /lib64/libpthread.so.0 #15 0x00007f5a23f0734d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f5a25ec9840 (LWP 4030)): #0 0x00007f5a25aa2f57 in pthread_join () from /lib64/libpthread.so.0 #1 0x00000000019f7e7d in my_thread_join (thread=<optimized out>, value_ptr=<optimized out>) at ../../mysql-8.0.11/mysys/my_thread.cc:100 #2 0x0000000000d712b2 in bootstrap::run_bootstrap_thread (file=<optimized out>, boot_handler=<optimized out>, thread_type=SYSTEM_THREAD_DD_INITIALIZE) at ../../mysql-8.0.11/sql/bootstrap.cc:404 #3 0x00000000017acb73 in dd::Dictionary_impl::init (dd_init=dd::DD_RESTART_OR_UPGRADE) at ../../mysql-8.0.11/sql/dd/impl/dictionary_impl.cc:139 #4 0x0000000000ab7610 in init_server_components () at ../../mysql-8.0.11/sql/mysqld.cc:5035 #5 0x0000000000b03514 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at ../../mysql-8.0.11/sql/mysqld.cc:5893 #6 0x00007f5a23e30c05 in __libc_start_main () from /lib64/libc.so.6 #7 0x0000000000af2af5 in _start ()
-----