21.11.2019 - DBCL01-01 2019-11-21 8:41:31 328 [Warning] Aborted connection 328 to db: 'unconnected' user: 'slave' host: 'XX.XXX.XXX.82' (Got an error writing communication packets) 2019-11-21 8:41:32 257 [ERROR] Master 'from_dbcl02-01': Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2019-11-21 8:41:32 257 [Note] Master 'from_dbcl02-01': Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binlog-m2.001897' at position 138955929; GTID position '1-81-85182964,0-51-4941698647,2-86-2' 2019-11-21 8:41:32 257 [ERROR] Master 'from_dbcl02-01': Slave I/O: error reconnecting to master 'slave@XX.XXX.XXX.86:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on 'XX.XXX.XXX.86' (111 "Connection refused"), Internal MariaDB error code: 2003 2019-11-21 8:41:32 22 [Warning] Aborted connection 22 to db: 'unconnected' user: 'slave' host: 'XX.XXX.XXX.86' (Got an error writing communication packets) 191121 8:41:41 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=3397 max_threads=5002 thread_count=1794 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ebde834e868 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 = 0x7ec0cd0edd00 thread_stack 0x30000 *** buffer overflow detected ***: /usr/sbin/mysqld terminated ======= Backtrace: ========= /lib64/libc.so.6(__fortify_fail+0x37)[0x7f0dfc7b5527] /lib64/libc.so.6(+0x1166a2)[0x7f0dfc7b36a2] /lib64/libc.so.6(+0x118487)[0x7f0dfc7b5487] /usr/sbin/mysqld(my_addr_resolve+0xda)[0x560f1000866a] /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x560f0fff1a52] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x560f0fa8e59f] /lib64/libpthread.so.0(+0xf5f0)[0x7f0dfe4025f0] /usr/sbin/mysqld(+0xcbb9bf)[0x560f0ffb69bf] /usr/sbin/mysqld(+0xcc75da)[0x560f0ffc25da] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x560f0fa93187] /usr/sbin/mysqld(+0xcbfe19)[0x560f0ffbae19] /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT20init_ror_merged_scanEbP11st_mem_root+0x85)[0x560f0fb9be85] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT20init_ror_merged_scanEbP11st_mem_root+0x7d)[0x560f0fb9c09d] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT5resetEv+0x5f)[0x560f0fb9ce8f] /usr/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x48)[0x560f0f8f6ad8] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x560f0f8e62d9] /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa7b)[0x560f0f907edb] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x560f0f9080f3] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x560f0f90824a] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x560f0f908d5c] /usr/sbin/mysqld(+0x4c2f4c)[0x560f0f7bdf4c] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x668b)[0x560f0f8b303b] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x560f0f8b551b] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ca6)[0x560f0f8b8106] /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x560f0f8b904e] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x221)[0x560f0f98d111] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x560f0f98d1dd] /usr/sbin/mysqld(+0xca77ad)[0x560f0ffa27ad] /lib64/libpthread.so.0(+0x7e65)[0x7f0dfe3fae65] /lib64/libc.so.6(clone+0x6d)[0x7f0dfc79b88d] ======= Memory map: ======== 560f0f2fb000-560f105c4000 r-xp 00000000 08:03 5774978 /usr/sbin/mysqld 560f107c3000-560f108c6000 r--p 012c8000 08:03 5774978 /usr/sbin/mysqld 560f108c6000-560f1097f000 rw-p 013cb000 08:03 5774978 /usr/sbin/mysqld 560f1097f000-560f1121a000 rw-p 00000000 00:00 0 560f11481000-56108d661000 rw-p 00000000 00:00 0 [heap] 7ebd13f08000-7ebd13f09000 ---p 00000000 00:00 0 7ebd13f09000-7ebd13f3a000 rw-p 00000000 00:00 0 7ebd15164000-7ebd15165000 ---p 00000000 00:00 0 7ebd15165000-7ebd15196000 rw-p 00000000 00:00 0 7ebd15196000-7ebd15197000 ---p 00000000 00:00 0 7ebd15197000-7ebd151c8000 rw-p 00000000 00:00 0 7ebd17874000-7ebd17875000 ---p 00000000 00:00 0 7ebd17875000-7ebd178a6000 rw-p 00000000 00:00 0 7ebd179a0000-7ebd179a1000 ---p 00000000 00:00 0 7ebd179a1000-7ebd179d2000 rw-p 00000000 00:00 0 7ebd182ce000-7ebd182cf000 ---p 00000000 00:00 0 7ebd182cf000-7ebd18300000 rw-p 00000000 00:00 0 7ebd1858a000-7ebd1858b000 ---p 00000000 00:00 0 7ebd1858b000-7ebd185bc000 rw-p 00000000 00:00 0 7ebd19b06000-7ebd19b07000 ---p 00000000 00:00 0 7ebd19b07000-7ebd19b38000 rw-p 00000000 00:00 0 7ebd19e8a000-7ebd19e8b000 ---p 00000000 00:00 0 7ebd19e8b000-7ebd19ebc000 rw-p 00000000 00:00 0 7ebd1a146000-7ebd1a147000 ---p 00000000 00:00 0 7ebd1a147000-7ebd1a178000 rw-p 00000000 00:00 0 7ebd1a5f6000-7ebd1a5f7000 ---p 00000000 00:00 0 7ebd1a5f7000-7ebd1a628000 rw-p 00000000 00:00 0 7ebd1b500000-7ebd1b501000 ---p 00000000 00:00 0 7ebd1b501000-7ebd1b532000 rw-p 00000000 00:00 0 7ebd1b94c000-7ebd1b94d000 ---p 00000000 00:00 0 7ebd1b94d000-7ebd1b97e000 rw-p 00000000 00:00 0 7ebd1b9b0000-7ebd1b9b1000 ---p 00000000 00:00 0 7ebd1b9b1000-7ebd1b9e2000 rw-p 00000000 00:00 0 7ebd1bf8c000-7ebd1bf8d000 ---p 00000000 00:00 0 7ebd1bf8d000-7ebd1bfbe000 rw-p 00000000 00:00 0 7ebd1c950000-7ebd1c951000 ---p 00000000 00:00 0 7ebd1c951000-7ebd1c982000 rw-p 00000000 00:00 0 7ebd1ce32000-7ebd1ce33000 ---p 00000000 00:00 0 7ebd1ce33000-7ebd1ce64000 rw-p 00000000 00:00 0 7ebd1d666000-7ebd1d667000 ---p 00000000 00:00 0 7ebd1d667000-7ebd1d698000 rw-p 00000000 00:00 0 7ebd1dd6e000-7ebd1dd6f000 ---p 00000000 00:00 0 7ebd1dd6f000-7ebd1dda0000 rw-p 00000000 00:00 0 7ebd1e3ae000-7ebd1e3af000 ---p 00000000 00:00 0 7ebd1e3af000-7ebd1e3e0000 rw-p 00000000 00:00 0 7ebd1ec14000-7ebd1ec15000 ---p 00000000 00:00 0 7ebd1ec15000-7ebd1ec46000 rw-p 00000000 00:00 0 7ebd1f15a000-7ebd1f15b000 ---p 00000000 00:00 0 7ebd1f15b000-7ebd1f18c000 rw-p 00000000 00:00 0 7ebd1faec000-7ebd1faed000 ---p 00000000 00:00 0 7ebd1faed000-7ebd1fb1e000 rw-p 00000000 00:00 0 7ebd1fd44000-7ebd1fd45000 ---p 00000000 00:00 0 7ebd1fd45000-7ebd1fd76000 rw-p 00000000 00:00 0 7ebd1ff38000-7ebd1ff39000 ---p 00000000 00:00 0 7ebd1ff39000-7ebd1ff6a000 rw-p 00000000 00:00 0 7ebd1ffce000-7ebd1ffcf000 ---p 00000000 00:00 0 7ebd1ffcf000-7ebd20000000 rw-p 00000000 00:00 0 7ebd20000000-7ebd20ae5000 rw-p 00000000 00:00 0 7ebd20ae5000-7ebd24000000 ---p 00000000 00:00 0 7ebd24694000-7ebd24695000 ---p 00000000 00:00 0 7ebd24695000-7ebd246c6000 rw-p 00000000 00:00 0 7ebd249b4000-7ebd249b5000 ---p 00000000 00:00 0 7ebd249b5000-7ebd249e6000 rw-p 00000000 00:00 0 7ebd25440000-7ebd25441000 ---p 00000000 00:00 0 7ebd25441000-7ebd25472000 rw-p 00000000 00:00 0 7ebd2650c000-7ebd2650d000 ---p 00000000 00:00 0 7ebd2650d000-7ebd2653e000 rw-p 00000000 00:00 0 7ebd26638000-7ebd26639000 ---p 00000000 00:00 0 7ebd26639000-7ebd2666a000 rw-p 00000000 00:00 0 7ebd26732000-7ebd26733000 ---p 00000000 00:00 0 7ebd26733000-7ebd26764000 rw-p 00000000 00:00 0 7ebd26890000-7ebd26891000 ---p 00000000 00:00 0 7ebd26891000-7ebd268c2000 rw-p 00000000 00:00 0 7ebd270c4000-7ebd270c5000 ---p 00000000 00:00 0 7ebd270c5000-7ebd270f6000 rw-p 00000000 00:00 0 7ebd275d8000-7ebd275d9000 ---p 00000000 00:00 0 7ebd275d9000-7ebd2760a000 rw-p 00000000 00:00 0 7ebd27a56000-7ebd27a57000 ---p 00000000 00:00 0 7ebd27a57000-7ebd27a88000 rw-p 00000000 00:00 0 7ebd27a88000-7ebd27a89000 ---p 00000000 00:00 0 7ebd27a89000-7ebd27aba000 rw-p 00000000 00:00 0 7ebd28000000-7ebd28b73000 rw-p 00000000 00:00 0 7ebd28b73000-7ebd2c000000 ---p 00000000 00:00 0 7ebd2c000000-7ebd2cb18000 rw-p 00000000 00:00 0 7ebd2cb18000-7ebd30000000 ---p 00000000 00:00 0 7ebd30000000-7ebd30f13000 rw-p 00000000 00:00 0 7ebd30f13000-7ebd34000000 ---p 00000000 00:00 0 7ebd34000000-7ebd34f75000 rw-p 00000000 00:00 0 7ebd34f75000-7ebd38000000 ---p 00000000 00:00 0 7ebd38000000-7ebd38aef000 rw-p 00000000 00:00 0 7ebd38aef000-7ebd3c000000 ---p 00000000 00:00 0 7ebd3c000000-7ebd3cf88000 rw-p 00000000 00:00 0 7ebd3cf88000-7ebd40000000 ---p 00000000 00:00 0 7ebd40000000-7ebd40ab7000 rw-p 00000000 00:00 0 7ebd40ab7000-7ebd44000000 ---p 00000000 00:00 0 7ebd44000000-7ebd44a7c000 rw-p 00000000 00:00 0 7ebd44a7c000-7ebd48000000 ---p 00000000 00:00 0 7ebd48000000-7ebd48ade000 rw-p 00000000 00:00 0 7ebd48ade000-7ebd4c000000 ---p 00000000 00:00 0 7ebd4c000000-7ebd4cb1b000 rw-p 00000000 00:00 0 7ebd4cb1b000-7ebd50000000 ---p 00000000 00:00 0 7ebd50000000-7ebd50a62000 rw-p 00000000 00:00 0 7ebd50a62000-7ebd54000000 ---p 00000000 00:00 0 7ebd54000000-7ebd54afd000 rw-p 00000000 00:00 0 7ebd54afd000-7ebd58000000 ---p 00000000 00:00 0 7ebd58000000-7ebd58f12000 rw-p 00000000 00:00 0 7ebd58f12000-7ebd5c000000 ---p 00000000 00:00 0 7ebd5c000000-7ebd5ca87000 rw-p 00000000 00:00 0 7ebd5ca87000-7ebd60000000 ---p 00000000 00:00 0 7ebd60000000-7ebd60a7b000 rw-p 00000000 00:00 0 7ebd60a7b000-7ebd64000000 ---p 00000000 00:00 0 7ebd64000000-7ebd64a74000 rw-p 00000000 00:00 0 7ebd64a74000-7ebd68000000 ---p 00000000 00:00 0 7ebd68000000-7ebd68a50000 rw-p 00000000 00:00 0 7ebd68a50000-7ebd6c000000 ---p 00000000 00:00 0 7ebd6c000000-7ebd6d09d000 rw-p 00000000 00:00 0 7ebd6d09d000-7ebd70000000 ---p 00000000 00:00 0 7ebd70000000-7ebd70a5e000 rw-p 00000000 00:00 0 7ebd70a5e000-7ebd74000000 ---p 00000000 00:00 0 7ebd74000000-7ebd74a42000 rw-p 00000000 00:00 0 7ebd74a42000-7ebd78000000 ---p 00000000 00:00 0 7ebd78000000-7ebd78b50000 rw-p 00000000 00:00 0 7ebd78b50000-7ebd7c000000 ---p 00000000 00:00 0 7ebd7c000000-7ebd7caaf000 rw-p 00000000 00:00 0 7ebd7caaf000-7ebd80000000 ---p 00000000 00:00 0 7ebd80000000-7ebd80ae7000 rw-p 00000000 00:00 0 7ebd80ae7000-7ebd84000000 ---p 00000000 00:00 0 7ebd84000000-7ebd84e7f000 rw-p 00000000 00:00 0 7ebd84e7f000-7ebd88000000 ---p 00000000 00:00 0 7ebd88000000-7ebd88b81000 rw-p 00000000 00:00 0 7ebd88b81000-7ebd8c000000 ---p 00000000 00:00 0 7ebd8c000000-7ebd8d295000 rw-p 00000000 00:00 0 7ebd8d295000-7ebd90000000 ---p 00000000 00:00 0 7ebd90000000-7ebd90fdf000 rw-p 00000000 00:00 0 7ebd90fdf000-7ebd94000000 ---p 00000000 00:00 0 7ebd94000000-7ebd94eac000 rw-p 00000000 00:00 0 7ebd94eac000-7ebd98000000 ---p 00000000 00:00 0 7ebd98000000-7ebd98fed000 rw-p 00000000 00:00 0 7ebd98fed000-7ebd9c000000 ---p 00000000 00:00 0 7ebd9c000000-7ebd9c9f7000 rw-p 00000000 00:00 0 7ebd9c9f7000-7ebda0000000 ---p 00000000 00:00 0 7ebda0000000-7ebda0bc5000 rw-p 00000000 00:00 0 7ebda0bc5000-7ebda4000000 ---p 00000000 00:00 0 7ebda4000000-7ebda4a58000 rw-p 00000000 00:00 0 7ebda4a58000-7ebda8000000 ---p 00000000 00:00 0 7ebda8000000-7ebda8fb3000 rw-p 00000000 00:00 0 7ebda8fb3000-7ebdac000000 ---p 00000000 00:00 0 7ebdac000000-7ebdad497000 rw-p 00000000 00:00 0 7ebdad497000-7ebdb0000000 ---p 00000000 00:00 0 7ebdb0000000-7ebdb0f24000 rw-p 00000000 00:00 0 7ebdb0f24000-7ebdb4000000 ---p 00000000 00:00 0 7ebdb4000000-7ebdb4b2e000 rw-p 00000000 00:00 0 7ebdb4b2e000-7ebdb8000000 ---p 00000000 00:00 0 7ebdb8000000-7ebdb8b0a000 rw-p 00000000 00:00 0 7ebdb8b0a000-7ebdbc000000 ---p 00000000 00:00 0 7ebdbc000000-7ebdbcbe8000 rw-p 00000000 00:00 0 7ebdbcbe8000-7ebdc0000000 ---p 00000000 00:00 0 7ebdc0000000-7ebdc0bbc000 rw-p 00000000 00:00 0 7ebdc0bbc000-7ebdc4000000 ---p 00000000 00:00 0 7ebdc4000000-7ebdc4a29000 rw-p 00000000 00:00 0 7ebdc4a29000-7ebdc8000000 ---p 00000000 00:00 0 7ebdc8000000-7ebdc92c4000 rw-p 00000000 00:00 0 7ebdc92c4000-7ebdcc000000 ---p 00000000 00:00 0 7ebdcc000000-7ebdccbaf000 rw-p 00000000 00:00 0 7ebdccbaf000-7ebdd0000000 ---p 00000000 00:00 0 7ebdd0000000-7ebdd0a81000 rw-p 00000000 00:00 0 7ebdd0a81000-7ebdd4000000 ---p 00000000 00:00 0 7ebdd4000000-7ebdd4a68000 rw-p 00000000 00:00 0 7ebdd4a68000-7ebdd8000000 ---p 00000000 00:00 0 7ebdd8000000-7ebdd89d0000 rw-p 00000000 00:00 0 7ebdd89d0000-7ebddc000000 ---p 00000000 00:00 0 7ebddc000000-7ebddcb1b000 rw-p 00000000 00:00 0 7ebddcb1b000-7ebde0000000 ---p 00000000 00:00 0 7ebde0000000-7ebde0f04000 rw-p 00000000 00:00 0 7ebde0f04000-7ebde4000000 ---p 00000000 00:00 0 7ebde4000000-7ebde4a0a000 rw-p 00000000 00:00 0 7ebde4a0a000-7ebde8000000 ---p 00000000 00:00 0 7ebde8000000-7ebde8c80000 rw-p 00000000 00:00 0 7ebde8c80000-7ebdec000000 ---p 00000000 00:00 0 7ebdec000000-7ebdecdeb000 rw-p 00000000 00:00 0 7ebdecdeb000-7ebdf0000000 ---p 00000000 00:00 0 7ebdf0000000-7ebdf0ee6000 rw-p 00000000 00:00 0 7ebdf0ee6000-7ebdf4000000 ---p 00000000 00:00 0 7ebdf4000000-7ebdf4be9000 rw-p 00000000 00:00 0 7ebdf4be9000-7ebdf8000000 ---p 00000000 00:00 0 7ebdf8000000-7ebdf8ab5000 rw-p 00000000 00:00 0 7ebdf8ab5000-7ebdfc000000 ---p 00000000 00:00 0 7ebdfc000000-7ebdfcb70000 rw-p 00000000 00:00 0 7ebdfcb70000-7ebe00000000 ---p 00000000 00:00 0 7ebe00000000-7ebe00ab0000 rw-p 00000000 00:00 0 7ebe00ab0000-7ebe04000000 ---p 00000000 00:00 0 7ebe04000000-7ebe04af8000 rw-p 00000000 00:00 0 7ebe04af8000-7ebe08000000 ---p 00000000 00:00 0 7ebe08000000-7ebe08af7000 rw-p 00000000 00:00 0 7ebe08af7000-7ebe0c000000 ---p 00000000 00:00 0 7ebe0c000000-7ebe0cefd000 rw-p 00000000 00:00 0 7ebe0cefd000-7ebe10000000 ---p 00000000 00:00 0 7ebe10000000-7ebe10aca000 rw-p 00000000 00:00 0 7ebe10aca000-7ebe14000000 ---p 00000000 00:00 0 7ebe14000000-7ebe14b1f000 rw-p 00000000 00:00 0 7ebe14b1f000-7ebe18000000 ---p 00000000 00:00 0 7ebe18000000-7ebe18b05000 rw-p 00000000 00:00 0 7ebe18b05000-7ebe1c000000 ---p 00000000 00:00 0 7ebe1c000000-7ebe1cba0000 rw-p 00000000 00:00 0 7ebe1cba0000-7ebe20000000 ---p 00000000 00:00 0 7ebe20000000-7ebe20f5e000 rw-p 00000000 00:00 0 7ebe20f5e000-7ebe24000000 ---p 00000000 00:00 0 7ebe24000000-7ebe24a19000 rw-p 00000000 00:00 0 7ebe24a19000-7ebe28000000 ---p 00000000 00:00 0 7ebe28000000-7ebe28f2f000 rw-p 00000000 00:00 0 7ebe28f2f000-7ebe2c000000 ---p 00000000 00:00 0 7ebe2c000000-7ebe2cb14000 rw-p 00000000 00:00 0 7ebe2cb14000-7ebe30000000 ---p 00000000 00:00 0 7ebe30000000-7ebe30e2d000 rw-p 00000000 00:00 0 7ebe30e2d000-7ebe34000000 ---p 00000000 00:00 0 7ebe34000000-7ebe34bb8000 rw-p 00000000 00:00 0 7ebe34bb8000-7ebe38000000 ---p 00000000 00:00 0 7ebe38000000-7ebe38a26000 rw-p 00000000 00:00 0 7ebe38a26000-7ebe3c000000 ---p 00000000 00:00 0 7ebe3c000000-7ebe3cf85000 rw-p 00000000 00:00 0 7ebe3cf85000-7ebe40000000 ---p 00000000 00:00 0 7ebe40000000-7ebe40b2c000 rw-p 00000000 00:00 0 7ebe40b2c000-7ebe44000000 ---p 00000000 00:00 0 7ebe44000000-7ebe44b24000 rw-p 00000000 00:00 0 7ebe44b24000-7ebe48000000 ---p 00000000 00:00 0 7ebe48000000-7ebe48e82000 rw-p 00000000 00:00 0 7ebe48e82000-7ebe4c000000 ---p 00000000 00:00 0 7ebe4c000000-7ebe4ce62000 rw-p 00000000 00:00 0 7ebe4ce62000-7ebe50000000 ---p 00000000 00:00 0 7ebe50000000-7ebe50ad9000 rw-p 00000000 00:00 0 7ebe50ad9000-7ebe54000000 ---p 00000000 00:00 0 7ebe54000000-7ebe54a7e000 rw-p 00000000 00:00 0 7ebe54a7e000-7ebe58000000 ---p 00000000 00:00 0 7ebe58000000-7ebe58d18000 rw-p 00000000 00:00 0 7ebe58d18000-7ebe5c000000 ---p 00000000 00:00 0 7ebe5c000000-7ebe5cef5000 rw-p 00000000 00:00 0 7ebe5cef5000-7ebe60000000 ---p 00000000 00:00 0 7ebe60000000-7ebe60ecd000 rw-p 00000000 00:00 0 7ebe60ecd000-7ebe64000000 ---p 00000000 00:00 0 7ebe64000000-7ebe64a2c000 rw-p 00000000 00:00 0 7ebe64a2c000-7ebe68000000 ---p 00000000 00:00 0 7ebe68000000-7ebe68ead000 rw-p 00000000 00:00 0 7ebe68ead000-7ebe6c000000 ---p 00000000 00:00 0 7ebe6c000000-7ebe6cab3000 rw-p 00000000 00:00 0 7ebe6cab3000-7ebe70000000 ---p 00000000 00:00 0 7ebe70000000-7ebe70eb8000 rw-p 00000000 00:00 0 7ebe70eb8000-7ebe74000000 ---p 00000000 00:00 0 7ebe74000000-7ebe74ac0000 rw-p 00000000 00:00 0 7ebe74ac0000-7ebe78000000 ---p 00000000 00:00 0 7ebe78000000-7ebe79028000 rw-p 00000000 00:00 0 7ebe79028000-7ebe7c000000 ---p 00000000 00:00 0 7ebe7c000000-7ebe7ce6f000 rw-p 00000000 00:00 0 7ebe7ce6f000-7ebe80000000 ---p 00000000 00:00 0 7ebe80000000-7ebe80a6d000 rw-p 00000000 00:00 0 7ebe80a6d000-7ebe84000000 ---p 00000000 00:00 0 7ebe84000000-7ebe84a17000 rw-p 00000000 00:00 0 7ebe84a17000-7ebe88000000 ---p 00000000 00:00 0 7ebe88000000-7ebe88eb0000 rw-p 00000000 00:00 0 7ebe88eb0000-7ebe8c000000 ---p 00000000 00:00 0 7ebe8c000000-7ebe8cedc000 rw-p 00000000 00:00 0 7ebe8cedc000-7ebe90000000 ---p 00000000 00:00 0 7ebe90000000-7ebe90ec1000 rw-p 00000000 00:00 0 7ebe90ec1000-7ebe94000000 ---p 00000000 00:00 0 7ebe94000000-7ebe950d7000 rw-p 00000000 00:00 0 7ebe950d7000-7ebe98000000 ---p 00000000 00:00 0 7ebe98000000-7ebe98ada000 rw-p 00000000 00:00 0 7ebe98ada000-7ebe9c000000 ---p 00000000 00:00 0 7ebe9c000000-7ebe9ca51000 rw-p 00000000 00:00 0 7ebe9ca51000-7ebea0000000 ---p 00000000 00:00 0 7ebea0000000-7ebea0a34000 rw-p 00000000 00:00 0 7ebea0a34000-7ebea4000000 ---p 00000000 00:00 0 7ebea4000000-7ebea4ed6000 rw-p 00000000 00:00 0 7ebea4ed6000-7ebea8000000 ---p 00000000 00:00 0 7ebea8000000-7ebea8b61000 rw-p 00000000 00:00 0 7ebea8b61000-7ebeac000000 ---p 00000000 00:00 0 7ebeac000000-7ebeacc6c000 rw-p 00000000 00:00 0 7ebeacc6c000-7ebeb0000000 ---p 00000000 00:00 0 7ebeb0000000-7ebeb0f08000 rw-p 00000000 00:00 0 7ebeb0f08000-7ebeb4000000 ---p 00000000 00:00 0 7ebeb4000000-7ebeb4a5e000 rw-p 00000000 00:00 0 7ebeb4a5e000-7ebeb8000000 ---p 00000000 00:00 0 7ebeb8000000-7ebeb8c79000 rw-p 00000000 00:00 0 7ebeb8c79000-7ebebc000000 ---p 00000000 00:00 0 7ebebc000000-7ebebcfab000 rw-p 00000000 00:00 0 7ebebcfab000-7ebec0000000 ---p 00000000 00:00 0 7ebec0000000-7ebec0af2000 rw-p 00000000 00:00 0 7ebec0af2000-7ebec4000000 ---p 00000000 00:00 0 7ebec4000000-7ebec4b34000 rw-p 00000000 00:00 0 7ebec4b34000-7ebec8000000 ---p 00000000 00:00 0 7ebec8000000-7ebec8f19000 rw-p 00000000 00:00 0 7ebec8f19000-7ebecc000000 ---p 00000000 00:00 0 7ebecc000000-7ebeccf8e000 rw-p 00000000 00:00 0 7ebeccf8e000-7ebed0000000 ---p 00000000 00:00 0 7ebed0000000-7ebed0b2e000 rw-p 00000000 00:00 0 7ebed0b2e000-7ebed4000000 ---p 00000000 00:00 0 7ebed4000000-7ebed4b00000 rw-p 00000000 00:00 0 7ebed4b00000-7ebed8000000 ---p 00000000 00:00 0 7ebed8000000-7ebed8f0d000 rw-p 00000000 00:00 0 7ebed8f0d000-7ebedc000000 ---p 00000000 00:00 0 7ebedc000000-7ebedca85000 rw-p 00000000 00:00 0 7ebedca85000-7ebee0000000 ---p 00000000 00:00 0 7ebee0000000-7ebee0bbf000 rw-p 00000000 00:00 0 7ebee0bbf000-7ebee4000000 ---p 00000000 00:00 0 7ebee4000000-7ebee4b32000 rw-p 00000000 00:00 0 7ebee4b32000-7ebee8000000 ---p 00000000 00:00 0 7ebee8000000-7ebee901e000 rw-p 00000000 00:00 0 7ebee901e000-7ebeec000000 ---p 00000000 00:00 0 7ebeec000000-7ebeecbde000 rw-p 00000000 00:00 0 7ebeecbde000-7ebef0000000 ---p 00000000 00:00 0 7ebef0000000-7ebef0af0000 rw-p 00000000 00:00 0 7ebef0af0000-7ebef4000000 ---p 00000000 00:00 0 7ebef4000000-7ebef4c5b000 rw-p 00000000 00:00 0 7ebef4c5b000-7ebef8000000 ---p 00000000 00:00 0 7ebef8000000-7ebef8eca000 rw-p 00000000 00:00 0 7ebef8eca000-7ebefc000000 ---p 00000000 00:00 0 7ebefc000000-7ebefca4a000 rw-p 00000000 00:00 0 7ebefca4a000-7ebf00000000 ---p 00000000 00:00 0 7ebf00000000-7ebf00f92000 rw-p 00000000 00:00 0 7ebf00f92000-7ebf04000000 ---p 00000000 00:00 0 7ebf04000000-7ebf04f65000 rw-p 00000000 00:00 0 7ebf04f65000-7ebf08000000 ---p 00000000 00:00 0 7ebf08000000-7ebf08aab000 rw-p 00000000 00:00 0 7ebf08aab000-7ebf0c000000 ---p 00000000 00:00 0 7ebf0c000000-7ebf0cc68000 rw-p 00000000 00:00 0 7ebf0cc68000-7ebf10000000 ---p 00000000 00:00 0 7ebf10000000-7ebf10c34000 rw-p 00000000 00:00 0 7ebf10c34000-7ebf14000000 ---p 00000000 00:00 0 7ebf14000000-7ebf14b36000 rw-p 00000000 00:00 0 7ebf14b36000-7ebf18000000 ---p 00000000 00:00 0 7ebf18000000-7ebf18e89000 rw-p 00000000 00:00 0 7ebf18e89000-7ebf1c000000 ---p 00000000 00:00 0 7ebf1c000000-7ebf1cadb000 rw-p 00000000 00:00 0 7ebf1cadb000-7ebf20000000 ---p 00000000 00:00 0 7ebf20000000-7ebf213ec000 rw-p 00000000 00:00 0 7ebf213ec000-7ebf24000000 ---p 00000000 00:00 0 7ebf24000000-7ebf24a41000 rw-p 00000000 00:00 0 7ebf24a41000-7ebf28000000 ---p 00000000 00:00 0 7ebf28000000-7ebf28a52000 rw-p 00000000 00:00 0 7ebf28a52000-7ebf2c000000 ---p 00000000 00:00 0 7ebf2c000000-7ebf2cfca000 rw-p 00000000 00:00 0 7ebf2cfca000-7ebf30000000 ---p 00000000 00:00 0 7ebf30000000-7ebf30f4d000 rw-p 00000000 00:00 0 7ebf30f4d000-7ebf34000000 ---p 00000000 00:00 0 7ebf34000000-7ebf34d4f000 rw-p 00000000 00:00 0 7ebf34d4f000-7ebf38000000 ---p 00000000 00:00 0 7ebf38000000-7ebf38a9c000 rw-p 00000000 00:00 0 7ebf38a9c000-7ebf3c000000 ---p 00000000 00:00 0 7ebf3c000000-7ebf3c9b7000 rw-p 00000000 00:00 0 7ebf3c9b7000-7ebf40000000 ---p 00000000 00:00 0 7ebf40000000-7ebf40b21000 rw-p 00000000 00:00 0 7ebf40b21000-7ebf44000000 ---p 00000000 00:00 0 7ebf44000000-7ebf44b09000 rw-p 00000000 00:00 0 7ebf44b09000-7ebf48000000 ---p 00000000 00:00 0 7ebf48000000-7ebf48fb3000 rw-p 00000000 00:00 0 7ebf48fb3000-7ebf4c000000 ---p 00000000 00:00 0 7ebf4c000000-7ebf4cb7a000 rw-p 00000000 00:00 0 7ebf4cb7a000-7ebf50000000 ---p 00000000 00:00 0 7ebf50000000-7ebf50bae000 rw-p 00000000 00:00 0 7ebf50bae000-7ebf54000000 ---p 00000000 00:00 0 7ebf54000000-7ebf54b05000 rw-p 00000000 00:00 0 7ebf54b05000-7ebf58000000 ---p 00000000 00:00 0 7ebf58000000-7ebf58f83000 rw-p 00000000 00:00 0 7ebf58f83000-7ebf5c000000 ---p 00000000 00:00 0 7ebf5c000000-7ebf5cefb000 rw-p 00000000 00:00 0 7ebf5cefb000-7ebf60000000 ---p 00000000 00:00 0 7ebf60000000-7ebf60fec000 rw-p 00000000 00:00 0 7ebf60fec000-7ebf64000000 ---p 00000000 00:00 0 7ebf64000000-7ebf64ab6000 rw-p 00000000 00:00 0 7ebf64ab6000-7ebf68000000 ---p 00000000 00:00 0 7ebf68000000-7ebf68b1f000 rw-p 00000000 00:00 0 7ebf68b1f000-7ebf6c000000 ---p 00000000 00:00 0 7ebf6c000000-7ebf6ca9c000 rw-p 00000000 00:00 0 7ebf6ca9c000-7ebf70000000 ---p 00000000 00:00 0 7ebf70000000-7ebf70f6a000 rw-p 00000000 00:00 0 7ebf70f6a000-7ebf74000000 ---p 00000000 00:00 0 7ebf74000000-7ebf74b43000 rw-p 00000000 00:00 0 7ebf74b43000-7ebf78000000 ---p 00000000 00:00 0 7ebf78000000-7ebf78c29000 rw-p 00000000 00:00 0 7ebf78c29000-7ebf7c000000 ---p 00000000 00:00 0 7ebf7c000000-7ebf7cef1000 rw-p 00000000 00:00 0 7ebf7cef1000-7ebf80000000 ---p 00000000 00:00 0 7ebf80000000-7ebf80b2b000 rw-p 00000000 00:00 0 7ebf80b2b000-7ebf84000000 ---p 00000000 00:00 0 7ebf84000000-7ebf84eb3000 rw-p 00000000 00:00 0 7ebf84eb3000-7ebf88000000 ---p 00000000 00:00 0 7ebf88000000-7ebf89025000 rw-p 00000000 00:00 0 7ebf89025000-7ebf8c000000 ---p 00000000 00:00 0 7ebf8c000000-7ebf8ca5b000 rw-p 00000000 00:00 0 7ebf8ca5b000-7ebf90000000 ---p 00000000 00:00 0 7ebf90000000-7ebf90d1e000 rw-p 00000000 00:00 0 7ebf90d1e000-7ebf94000000 ---p 00000000 00:00 0 7ebf94000000-7ebf94f2c000 rw-p 00000000 00:00 0 7ebf94f2c000-7ebf98000000 ---p 00000000 00:00 0 7ebf98000000-7ebf98e61000 rw-p 00000000 00:00 0 7ebf98e61000-7ebf9c000000 ---p 00000000 00:00 0 7ebf9c000000-7ebf9cbf2000 rw-p 00000000 00:00 0 7ebf9cbf2000-7ebfa0000000 ---p 00000000 00:00 0 7ebfa0000000-7ebfa0e0f000 rw-p 00000000 00:00 0 7ebfa0e0f000-7ebfa4000000 ---p 00000000 00:00 0 7ebfa4000000-7ebfa4bb8000 rw-p 00000000 00:00 0 7ebfa4bb8000-7ebfa8000000 ---p 00000000 00:00 0 7ebfa8000000-7ebfa8c33000 rw-p 00000000 00:00 0 7ebfa8c33000-7ebfac000000 ---p 00000000 00:00 0 7ebfac000000-7ebfacb16000 rw-p 00000000 00:00 0 7ebfacb16000-7ebfb0000000 ---p 00000000 00:00 0 7ebfb0000000-7ebfb0f42000 rw-p 00000000 00:00 0 7ebfb0f42000-7ebfb4000000 ---p 00000000 00:00 0 7ebfb4000000-7ebfb4b02000 rw-p 00000000 00:00 0 7ebfb4b02000-7ebfb8000000 ---p 00000000 00:00 0 7ebfb8000000-7ebfb8a9c000 rw-p 00000000 00:00 0 7ebfb8a9c000-7ebfbc000000 ---p 00000000 00:00 0 7ebfbc000000-7ebfbca6b000 rw-p 00000000 00:00 0 7ebfbca6b000-7ebfc0000000 ---p 00000000 00:00 0 7ebfc0000000-7ebfc1117000 rw-p 00000000 00:00 0 7ebfc1117000-7ebfc4000000 ---p 00000000 00:00 0 7ebfc4000000-7ebfc4d76000 rw-p 00000000 00:00 0 7ebfc4d76000-7ebfc8000000 ---p 00000000 00:00 0 7ebfc8000000-7ebfc8b2d000 rw-p 00000000 00:00 0 7ebfc8b2d000-7ebfcc000000 ---p 00000000 00:00 0 7ebfcc000000-7ebfccdbe000 rw-p 00000000 00:00 0 7ebfccdbe000-7ebfd0000000 ---p 00000000 00:00 0 7ebfd0000000-7ebfd0f9c000 rw-p 00000000 00:00 0 7ebfd0f9c000-7ebfd4000000 ---p 00000000 00:00 0 7ebfd4000000-7ebfd4a79000 rw-p 00000000 00:00 0 7ebfd4a79000-7ebfd8000000 ---p 00000000 00:00 0 7ebfd8000000-7ebfd8f47000 rw-p 00000000 00:00 0 7ebfd8f47000-7ebfdc000000 ---p 00000000 00:00 0 7ebfdc000000-7ebfdcc55000 rw-p 00000000 00:00 0 7ebfdcc55000-7ebfe0000000 ---p 00000000 00:00 0 7ebfe0000000-7ebfe0ce1000 rw-p 00000000 00:00 0 7ebfe0ce1000-7ebfe4000000 ---p 00000000 00:00 0 7ebfe4000000-7ebfe4b3d000 rw-p 00000000 00:00 0 7ebfe4b3d000-7ebfe8000000 ---p 00000000 00:00 0 7ebfe8000000-7ebfe8ad6000 rw-p 00000000 00:00 0 7ebfe8ad6000-7ebfec000000 ---p 00000000 00:00 0 7ebfec000000-7ebfecf25000 rw-p 00000000 00:00 0 7ebfecf25000-7ebff0000000 ---p 00000000 00:00 0 7ebff0000000-7ebff0b9f000 rw-p 00000000 00:00 0 7ebff0b9f000-7ebff4000000 ---p 00000000 00:00 0 7ebff4000000-7ebff4b54000 rw-p 00000000 00:00 0 7ebff4b54000-7ebff8000000 ---p 00000000 00:00 0 7ebff8000000-7ebff8cef000 rw-p 00000000 00:00 0 7ebff8cef000-7ebffc000000 ---p 00000000 00:00 0 7ebffc000000-7ebffcfe6000 rw-p 00000000 00:00 0 7ebffcfe6000-7ec000000000 ---p 00000000 00:00 0 7ec000000000-7ec000d4b000 rw-p 00000000 00:00 0 7ec000d4b000-7ec004000000 ---p 00000000 00:00 0 7ec004000000-7ec004c25000 rw-p 00000000 00:00 0 7ec004c25000-7ec008000000 ---p 00000000 00:00 0 7ec008000000-7ec008c02000 rw-p 00000000 00:00 0 7ec008c02000-7ec00c000000 ---p 00000000 00:00 0 7ec00c000000-7ec00d0a7000 rw-p 00000000 00:00 0 7ec00d0a7000-7ec010000000 ---p 00000000 00:00 0 7ec010000000-7ec010af0000 rw-p 00000000 00:00 0 7ec010af0000-7ec014000000 ---p 00000000 00:00 0 7ec014000000-7ec014a8f000 rw-p 00000000 00:00 0 7ec014a8f000-7ec018000000 ---p 00000000 00:00 0 7ec018000000-7ec018ecf000 rw-p 00000000 00:00 0 7ec018ecf000-7ec01c000000 ---p 00000000 00:00 0 7ec01c000000-7ec01c9c9000 rw-p 00000000 00:00 0 7ec01c9c9000-7ec020000000 ---p 00000000 00:00 0 7ec020000000-7ec020a56000 rw-p 00000000 00:00 0 7ec020a56000-7ec024000000 ---p 00000000 00:00 0 7ec024000000-7ec024f16000 rw-p 00000000 00:00 0 7ec024f16000-7ec028000000 ---p 00000000 00:00 0 7ec028000000-7ec028af2000 rw-p 00000000 00:00 0 7ec028af2000-7ec02c000000 ---p 00000000 00:00 0 7ec02c000000-7ec02ca79000 rw-p 00000000 00:00 0 7ec02ca79000-7ec030000000 ---p 00000000 00:00 0 7ec030000000-7ec030e63000 rw-p 00000000 00:00 0 7ec030e63000-7ec034000000 ---p 00000000 00:00 0 7ec034000000-7ec035cbb000 rw-p 00000000 00:00 0 7ec035cbb000-7ec038000000 ---p 00000000 00:00 0 7ec038000000-7ec038a05000 rw-p 00000000 00:00 0 7ec038a05000-7ec03c000000 ---p 00000000 00:00 0 7ec03c000000-7ec03cafa000 rw-p 00000000 00:00 0 7ec03cafa000-7ec040000000 ---p 00000000 00:00 0 7ec040000000-7ec040c1f000 rw-p 00000000 00:00 0 7ec040c1f000-7ec044000000 ---p 00000000 00:00 0 7ec044000000-7ec044ad6000 rw-p 00000000 00:00 0 7ec044ad6000-7ec048000000 ---p 00000000 00:00 0 7ec048000000-7ec048f47000 rw-p 00000000 00:00 0 7ec048f47000-7ec04c000000 ---p 00000000 00:00 0 7ec04c000000-7ec04d186000 rw-p 00000000 00:00 0 7ec04d186000-7ec050000000 ---p 00000000 00:00 0 7ec050000000-7ec050f04000 rw-p 00000000 00:00 0 7ec050f04000-7ec054000000 ---p 00000000 00:00 0 7ec054000000-7ec054b28000 rw-p 00000000 00:00 0 7ec054b28000-7ec058000000 ---p 00000000 00:00 0 7ec058000000-7ec058c02000 rw-p 00000000 00:00 0 7ec058c02000-7ec05c000000 ---p 00000000 00:00 0 7ec05c000000-7ec05cecb000 rw-p 00000000 00:00 0 7ec05cecb000-7ec060000000 ---p 00000000 00:00 0 7ec060000000-7ec060ac7000 rw-p 00000000 00:00 0 7ec060ac7000-7ec064000000 ---p 00000000 00:00 0 7ec064000000-7ec064a5c000 rw-p 00000000 00:00 0 7ec064a5c000-7ec068000000 ---p 00000000 00:00 0 7ec068000000-7ec068c8e000 rw-p 00000000 00:00 0 7ec068c8e000-7ec06c000000 ---p 00000000 00:00 0 7ec06c000000-7ec06c9ff000 rw-p 00000000 00:00 0 7ec06c9ff000-7ec070000000 ---p 00000000 00:00 0 7ec070000000-7ec070af0000 rw-p 00000000 00:00 0 7ec070af0000-7ec074000000 ---p 00000000 00:00 0 7ec07410e000-7ec07410f000 ---p 00000000 00:00 0 7ec07410f000-7ec074140000 rw-p 00000000 00:00 0 7ec074302000-7ec074303000 ---p 00000000 00:00 0 7ec074303000-7ec074334000 rw-p 00000000 00:00 0 7ec075400000-7ec075401000 ---p 00000000 00:00 0 7ec075401000-7ec075432000 rw-p 00000000 00:00 0 7ec07587e000-7ec07587f000 ---p 00000000 00:00 0 7ec07587f000-7ec0758b0000 rw-p 00000000 00:00 0 7ec0758e2000-7ec0758e3000 ---p 00000000 00:00 0 7ec0758e3000-7ec075914000 rw-p 00000000 00:00 0 7ec075d92000-7ec075d93000 ---p 00000000 00:00 0 7ec075d93000-7ec075dc4000 rw-p 00000000 00:00 0 7ec075df6000-7ec075df7000 ---p 00000000 00:00 0 7ec075df7000-7ec075e28000 rw-p 00000000 00:00 0 7ec07617a000-7ec07617b000 ---p 00000000 00:00 0 7ec07617b000-7ec0761ac000 rw-p 00000000 00:00 0 7ec07649a000-7e2019-11-21 8:41:49 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:41:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:41:49 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:41:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:41:49 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:41:49 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:41:49 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:41:58 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:42:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:42:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886836238889 2019-11-21 8:42:14 0 [Note] InnoDB: Read redo log up to LSN=19880915302400 2019-11-21 8:42:29 0 [Note] InnoDB: Read redo log up to LSN=19882182113280 2019-11-21 8:42:44 0 [Note] InnoDB: Read redo log up to LSN=19883544213504 2019-11-21 8:42:56 0 [Note] InnoDB: Ignoring data file './db/XXXXXX_XXXX_XXXXXX.ibd' with space ID 19946, since the redo log references ./db/XXXXXX_XXXX_XXXXXX.ibd with space ID 19942. 2019-11-21 8:42:58 0 [Note] InnoDB: Ignoring data file './db/XXXXXX_XXXX_XXXXXX.ibd' with space ID 19947, since the redo log references ./db/XXXXXX_XXXX_XXXXXX.ibd with space ID 19943. 2019-11-21 8:42:59 0 [Note] InnoDB: Read redo log up to LSN=19884988168192 2019-11-21 8:42:59 0 [Note] InnoDB: Ignoring data file './db/XXXXXX_XXXX_XXXXXX.ibd' with space ID 19948, since the redo log references ./db/XXXXXX_XXXX_XXXXXX.ibd with space ID 19944. 2019-11-21 8:42:59 0 [Note] InnoDB: Ignoring data file './db/XXXXXX_XXXX_XXXXXX.ibd' with space ID 19949, since the redo log references ./db/XXXXXX_XXXX_XXXXXX.ibd with space ID 19945. 2019-11-21 8:43:14 0 [Note] InnoDB: Read redo log up to LSN=19886192916480 2019-11-21 8:43:29 0 [Note] InnoDB: To recover: 245388 pages from log 2019-11-21 8:43:29 0 [Note] InnoDB: Transaction 11399269579 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269580 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269581 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269582 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269583 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269584 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269585 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269586 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269587 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269588 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269589 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269591 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269593 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: Transaction 11399269595 was in the XA prepared state. 2019-11-21 8:43:30 0 [Note] InnoDB: 27 transaction(s) which must be rolled back or cleaned up in total 13 row operations to undo 2019-11-21 8:43:30 0 [Note] InnoDB: Trx id counter is 11399269607 2019-11-21 8:43:30 0 [Note] InnoDB: Starting final batch to recover 245344 pages from redo log. 2019-11-21 8:43:44 0 [Note] InnoDB: To recover: 130867 pages from log 2019-11-21 8:43:57 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001897', position 592541382 2019-11-21 8:43:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:43:57 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:43:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:43:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:43:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:43:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:43:57 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269592 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269596 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269604 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269600 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269597 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269598 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269606 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269605 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269594 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269601 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269590 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269599 2019-11-21 8:43:57 0 [Note] InnoDB: Rolled back recovered transaction 11399269603 2019-11-21 8:43:57 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:43:57 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886908211374; transaction id 11399269622 2019-11-21 8:43:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:43:57 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:43:57 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:43:59 0 [Note] Starting crash recovery... 2019-11-21 8:43:59 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269587 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269591 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269595 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269583 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269579 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269582 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269581 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269593 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269586 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269585 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269589 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269580 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269588 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction 11399269584 in prepared state after recovery 2019-11-21 8:43:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:43:59 0 [Note] InnoDB: 14 transactions in prepared state after recovery 2019-11-21 8:43:59 0 [Note] Found 14 prepared transaction(s) in InnoDB 2019-11-21 8:43:59 0 [Note] Crash recovery finished. 2019-11-21 8:43:59 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:43:59 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2019-11-21 8:43:59 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:43:59 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:43:59 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:43:59 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:43:59 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:43:59 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2019-11-21 8:43:59 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-11-21 8:43:59 0 [Note] InnoDB: FTS optimize thread exiting. 2019-11-21 8:43:59 0 [Note] InnoDB: Starting shutdown... 2019-11-21 8:43:59 0 [Note] InnoDB: Buffer pool(s) load aborted due to user instigated abort at 191121 8:43:59 2019-11-21 8:43:59 0 [Note] InnoDB: Dumping of buffer pool not started as load was incomplete 2019-11-21 8:44:16 0 [Note] InnoDB: Shutdown completed; log sequence number 19886908243083; transaction id 11399269637 2019-11-21 8:44:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:44:16 0 [Note] /usr/sbin/mysqld: Shutdown complete 2019-11-21 8:46:41 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:46:41 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:46:41 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:46:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:46:41 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:46:41 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:46:41 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:46:50 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:46:52 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:46:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:46:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:46:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:46:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:46:56 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:46:56 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886908243083; transaction id 11399269638 2019-11-21 8:46:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:46:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:46:56 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:46:56 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:46:56 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:46:56 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:46:56 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:46:56 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:46:56 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:47:02 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=264 max_threads=5002 thread_count=271 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7efec40009a8 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 = 0x7f02a92b2d00 thread_stack 0x30000 2019-11-21 8:47:09 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:47:09 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:47:09 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:47:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:47:09 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:47:09 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:47:09 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:47:18 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:47:20 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:47:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908243083 2019-11-21 8:47:23 0 [Note] InnoDB: Transaction 11399272969 was in the XA prepared state. 2019-11-21 8:47:23 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 160 row operations to undo 2019-11-21 8:47:23 0 [Note] InnoDB: Trx id counter is 11399272973 2019-11-21 8:47:23 0 [Note] InnoDB: Starting final batch to recover 878 pages from redo log. 2019-11-21 8:47:26 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001899', position 1030259 2019-11-21 8:47:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:47:26 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:47:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:47:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:47:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:47:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:47:26 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:47:26 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886911437472; transaction id 11399272975 2019-11-21 8:47:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:47:26 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:47:26 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:47:26 0 [Note] Starting crash recovery... 2019-11-21 8:47:26 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:47:26 0 [Note] InnoDB: Transaction 11399272969 in prepared state after recovery 2019-11-21 8:47:26 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:47:26 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:47:26 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:47:26 0 [Note] Crash recovery finished. 2019-11-21 8:47:26 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:47:26 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:47:26 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:47:26 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:47:26 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:47:26 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:47:26 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2019-11-21 8:47:26 0 [Note] InnoDB: Rolled back recovered transaction 11399272583 2019-11-21 8:47:26 0 [Note] InnoDB: Rollback of non-prepared transactions completed 191121 8:47:27 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=125 max_threads=5002 thread_count=132 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f75200009a8 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 = 0x7f75ec331d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55b332ddc8be] 2019-11-21 8:47:34 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:47:34 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:47:34 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:47:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:47:34 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:47:34 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:47:34 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:47:43 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:47:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:47:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908243083 2019-11-21 8:47:47 0 [Note] InnoDB: Transaction 11399273569 was in the XA prepared state. 2019-11-21 8:47:47 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:47:47 0 [Note] InnoDB: Trx id counter is 11399273570 2019-11-21 8:47:47 0 [Note] InnoDB: Starting final batch to recover 1855 pages from redo log. 2019-11-21 8:47:51 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001900', position 125574 2019-11-21 8:47:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:47:51 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:47:51 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:47:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:47:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:47:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:47:51 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:47:51 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:47:51 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886912585520; transaction id 11399273572 2019-11-21 8:47:51 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:47:51 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:47:51 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:47:51 0 [Note] Starting crash recovery... 2019-11-21 8:47:51 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:47:51 0 [Note] InnoDB: Transaction 11399273569 in prepared state after recovery 2019-11-21 8:47:51 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:47:51 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:47:51 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:47:51 0 [Note] Crash recovery finished. 2019-11-21 8:47:51 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:47:51 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:47:51 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:47:51 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:47:51 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:47:51 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:47:51 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:47:52 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=132 max_threads=5002 thread_count=139 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f5b6c0009a8 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 = 0x7f5e90e66d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x561a55f388be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x561a559d559f] /lib64/libpthread.so.0(+0xf5f0)[0x7faa1b2035f0] /usr/sbin/mysqld(+0xcbb9bf)[0x561a55efd9bf] 2019-11-21 8:47:59 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:47:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:47:59 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:47:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:47:59 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:47:59 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:47:59 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:48:08 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:48:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:48:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908243083 2019-11-21 8:48:13 0 [Note] InnoDB: Transaction 11399274855 was in the XA prepared state. 2019-11-21 8:48:13 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 3 row operations to undo 2019-11-21 8:48:13 0 [Note] InnoDB: Trx id counter is 11399274856 2019-11-21 8:48:13 0 [Note] InnoDB: Starting final batch to recover 1955 pages from redo log. 2019-11-21 8:48:16 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001901', position 384104 2019-11-21 8:48:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:48:16 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:48:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:48:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:48:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:48:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:48:16 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:48:16 0 [Note] InnoDB: Rolled back recovered transaction 11399274854 2019-11-21 8:48:16 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:48:16 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886913188374; transaction id 11399274859 2019-11-21 8:48:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:48:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:48:16 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:48:16 0 [Note] Starting crash recovery... 2019-11-21 8:48:16 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:48:16 0 [Note] InnoDB: Transaction 11399274855 in prepared state after recovery 2019-11-21 8:48:16 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:48:16 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:48:16 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:48:16 0 [Note] Crash recovery finished. 2019-11-21 8:48:16 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:48:16 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:48:16 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:48:16 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:48:16 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:48:16 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:48:16 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:48:19 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=143 max_threads=5002 thread_count=150 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f52200009a8 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 = 0x7f5270207d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x559989cdd8be] 2019-11-21 8:48:26 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:48:26 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:48:26 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:48:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:48:26 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:48:26 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:48:26 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:48:35 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:48:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:48:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886913708698 2019-11-21 8:48:39 0 [Note] InnoDB: Transaction 11399276493 was in the XA prepared state. 2019-11-21 8:48:39 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:48:39 0 [Note] InnoDB: Trx id counter is 11399276494 2019-11-21 8:48:39 0 [Note] InnoDB: Starting final batch to recover 2095 pages from redo log. 2019-11-21 8:48:42 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001902', position 481606 2019-11-21 8:48:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:48:42 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:48:42 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:48:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:48:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:48:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:48:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:48:42 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:48:42 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886913991770; transaction id 11399276496 2019-11-21 8:48:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:48:42 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:48:42 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:48:42 0 [Note] Starting crash recovery... 2019-11-21 8:48:42 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:48:42 0 [Note] InnoDB: Transaction 11399276493 in prepared state after recovery 2019-11-21 8:48:42 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:48:42 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:48:42 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:48:42 0 [Note] Crash recovery finished. 2019-11-21 8:48:42 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:48:42 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:48:42 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:48:42 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:48:42 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:48:42 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:48:42 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:48:44 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=161 max_threads=5002 thread_count=168 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f19700009a8 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 = 0x7f1c395dcd00 thread_stack 0x30000 2019-11-21 8:48:51 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:48:51 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:48:51 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:48:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:48:51 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:48:51 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:48:51 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:49:00 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:49:02 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:49:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908487266 2019-11-21 8:49:05 0 [Note] InnoDB: Transaction 11399277632 was in the XA prepared state. 2019-11-21 8:49:05 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:49:05 0 [Note] InnoDB: Trx id counter is 11399277633 2019-11-21 8:49:05 0 [Note] InnoDB: Starting final batch to recover 2149 pages from redo log. 2019-11-21 8:49:07 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001903', position 283938 2019-11-21 8:49:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:49:07 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:49:07 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:49:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:49:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:49:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:49:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:49:07 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:49:07 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886914499131; transaction id 11399277635 2019-11-21 8:49:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:49:07 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:49:07 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:49:07 0 [Note] Starting crash recovery... 2019-11-21 8:49:07 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:49:07 0 [Note] InnoDB: Transaction 11399277632 in prepared state after recovery 2019-11-21 8:49:07 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:49:07 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:49:07 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:49:07 0 [Note] Crash recovery finished. 2019-11-21 8:49:07 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:49:07 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:49:07 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:49:07 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:49:07 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:49:07 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:49:07 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:49:09 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=143 max_threads=5002 thread_count=121 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7eb0980009a8 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 = 0x7eb14c0c1d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x559aeff3c8be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x559aef9d959f] /lib64/libpthread.so.0(+0xf5f0)[0x7efcbb6345f0] /usr/sbin/mysqld(+0xcbb9bf)[0x559aeff019bf] /usr/sbin/mysqld(+0xcc75da)[0x559aeff0d5da] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x559aef9de187] /usr/sbin/mysqld(+0xcbfe19)[0x559aeff05e19] /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT20init_ror_merged_scanEbP11st_mem_root+0x85)[0x559aefae6e85] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT20init_ror_merged_scanEbP11st_mem_root+0x7d)[0x559aefae709d] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT5resetEv+0x5f)[0x559aefae7e8f] /usr/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x48)[0x559aef841ad8] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x559aef8312d9] /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa7b)[0x559aef852edb] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x559aef8530f3] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x559aef85324a] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x559aef853d5c] /usr/sbin/mysqld(+0x4c2f4c)[0x559aef708f4c] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x668b)[0x559aef7fe03b] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x559aef80051b] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ca6)[0x559aef803106] /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x559aef80404e] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x221)[0x559aef8d8111] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x559aef8d81dd] /usr/sbin/mysqld(+0xca77ad)[0x559aefeed7ad] 2019-11-21 8:49:16 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:49:16 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:49:16 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:49:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:49:16 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:49:16 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:49:16 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:49:25 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:49:27 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:49:28 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908487266 2019-11-21 8:49:30 0 [Note] InnoDB: Transaction 11399278594 was in the XA prepared state. 2019-11-21 8:49:30 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:49:30 0 [Note] InnoDB: Trx id counter is 11399278595 2019-11-21 8:49:30 0 [Note] InnoDB: Starting final batch to recover 2218 pages from redo log. 2019-11-21 8:49:33 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001904', position 234364 2019-11-21 8:49:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:49:33 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:49:33 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:49:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:49:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:49:33 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:49:33 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:49:33 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:49:33 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886914928284; transaction id 11399278597 2019-11-21 8:49:33 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:49:33 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:49:33 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:49:33 0 [Note] Starting crash recovery... 2019-11-21 8:49:33 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:49:33 0 [Note] InnoDB: Transaction 11399278594 in prepared state after recovery 2019-11-21 8:49:33 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:49:33 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:49:33 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:49:33 0 [Note] Crash recovery finished. 2019-11-21 8:49:33 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:49:33 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:49:33 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:49:33 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:49:33 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:49:33 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:49:33 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:49:35 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=111 max_threads=5002 thread_count=118 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7eefb80009a8 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 = 0x7ef265a8cd00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5628dedeb8be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x5628de88859f] 2019-11-21 8:49:42 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:49:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:49:42 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:49:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:49:42 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:49:42 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:49:42 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:49:51 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:49:53 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:49:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886915599927 2019-11-21 8:49:56 0 [Note] InnoDB: Transaction 11399280630 was in the XA prepared state. 2019-11-21 8:49:56 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo 2019-11-21 8:49:56 0 [Note] InnoDB: Trx id counter is 11399280631 2019-11-21 8:49:56 0 [Note] InnoDB: Starting final batch to recover 2304 pages from redo log. 2019-11-21 8:49:59 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001905', position 629370 2019-11-21 8:49:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:49:59 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:49:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:49:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:49:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:49:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:49:59 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:49:59 0 [Note] InnoDB: Rolled back recovered transaction 11399280598 2019-11-21 8:49:59 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:49:59 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886915902805; transaction id 11399280634 2019-11-21 8:49:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:49:59 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:49:59 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:49:59 0 [Note] Starting crash recovery... 2019-11-21 8:49:59 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:49:59 0 [Note] InnoDB: Transaction 11399280630 in prepared state after recovery 2019-11-21 8:49:59 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:49:59 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:49:59 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:49:59 0 [Note] Crash recovery finished. 2019-11-21 8:49:59 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:49:59 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:49:59 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:49:59 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:49:59 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:49:59 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:49:59 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:50:01 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=156 max_threads=5002 thread_count=163 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7eb4080009a8 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 = 0x7eb76cd3ad00 thread_stack 0x30000 2019-11-21 8:50:08 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:50:08 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:50:08 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:50:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:50:08 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:50:08 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:50:08 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:50:17 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:50:19 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:50:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908883226 2019-11-21 8:50:21 0 [Note] InnoDB: Transaction 11399282108 was in the XA prepared state. 2019-11-21 8:50:22 0 [Note] InnoDB: Transaction 11399282109 was in the XA prepared state. 2019-11-21 8:50:22 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:50:22 0 [Note] InnoDB: Trx id counter is 11399282110 2019-11-21 8:50:22 0 [Note] InnoDB: Starting final batch to recover 2409 pages from redo log. 2019-11-21 8:50:25 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001906', position 412057 2019-11-21 8:50:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:50:25 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:50:25 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:50:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:50:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:50:25 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:50:25 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:50:25 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:50:25 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886916655493; transaction id 11399282112 2019-11-21 8:50:25 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:50:25 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:50:25 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:50:25 0 [Note] Starting crash recovery... 2019-11-21 8:50:25 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:50:25 0 [Note] InnoDB: Transaction 11399282109 in prepared state after recovery 2019-11-21 8:50:25 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:50:25 0 [Note] InnoDB: Transaction 11399282108 in prepared state after recovery 2019-11-21 8:50:25 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:50:25 0 [Note] InnoDB: 2 transactions in prepared state after recovery 2019-11-21 8:50:25 0 [Note] Found 2 prepared transaction(s) in InnoDB 2019-11-21 8:50:25 0 [Note] Crash recovery finished. 2019-11-21 8:50:25 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:50:25 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:50:25 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:50:25 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:50:25 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:50:25 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:50:25 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:50:27 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=163 max_threads=5002 thread_count=170 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f1cfc0009a8 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 = 0x7f1fc0153d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x560e62b9e8be] 2019-11-21 8:50:34 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:50:34 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:50:34 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:50:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:50:34 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:50:34 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:50:34 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:50:43 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:50:45 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:50:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908883226 2019-11-21 8:50:48 0 [Note] InnoDB: Transaction 11399283679 was in the XA prepared state. 2019-11-21 8:50:48 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:50:48 0 [Note] InnoDB: Trx id counter is 11399283680 2019-11-21 8:50:48 0 [Note] InnoDB: Starting final batch to recover 2508 pages from redo log. 2019-11-21 8:50:51 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001907', position 474759 2019-11-21 8:50:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:50:51 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:50:51 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:50:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:50:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:50:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:50:51 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:50:51 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:50:51 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886917527333; transaction id 11399283682 2019-11-21 8:50:51 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:50:51 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:50:51 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:50:51 0 [Note] Starting crash recovery... 2019-11-21 8:50:51 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:50:51 0 [Note] InnoDB: Transaction 11399283679 in prepared state after recovery 2019-11-21 8:50:51 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:50:51 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:50:51 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:50:51 0 [Note] Crash recovery finished. 2019-11-21 8:50:51 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:50:51 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:50:51 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:50:51 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:50:51 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:50:51 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:50:51 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:50:53 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=138 max_threads=5002 thread_count=145 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7edf900009a8 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 = 0x7ee2e4e0cd00 thread_stack 0x30000 2019-11-21 8:50:59 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:50:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:50:59 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:50:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:50:59 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:50:59 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:50:59 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:51:08 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:51:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:51:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886917902410 2019-11-21 8:51:13 0 [Note] InnoDB: Transaction 11399285135 was in the XA prepared state. 2019-11-21 8:51:13 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:51:13 0 [Note] InnoDB: Trx id counter is 11399285136 2019-11-21 8:51:13 0 [Note] InnoDB: Starting final batch to recover 2583 pages from redo log. 2019-11-21 8:51:16 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001908', position 431448 2019-11-21 8:51:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:51:16 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:51:16 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:51:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:51:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:51:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:51:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:51:16 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:51:16 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886918253307; transaction id 11399285138 2019-11-21 8:51:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:51:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:51:16 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:51:16 0 [Note] Starting crash recovery... 2019-11-21 8:51:16 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:51:16 0 [Note] InnoDB: Transaction 11399285135 in prepared state after recovery 2019-11-21 8:51:16 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:51:16 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:51:16 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:51:16 0 [Note] Crash recovery finished. 2019-11-21 8:51:16 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:51:16 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:51:16 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:51:16 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:51:16 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:51:16 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:51:16 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:51:20 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=191 max_threads=5002 thread_count=198 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ecc500009a8 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 = 0x7ecee11f4d00 thread_stack 0x30000 2019-11-21 8:51:26 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:51:26 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:51:26 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:51:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:51:26 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:51:26 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:51:26 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:51:35 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:51:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:51:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908884242 2019-11-21 8:51:40 0 [Note] InnoDB: Transaction 11399287617 was in the XA prepared state. 2019-11-21 8:51:40 0 [Note] InnoDB: Transaction 11399287595 was in the XA prepared state. 2019-11-21 8:51:40 0 [Note] InnoDB: 3 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo 2019-11-21 8:51:40 0 [Note] InnoDB: Trx id counter is 11399287627 2019-11-21 8:51:40 0 [Note] InnoDB: Starting final batch to recover 2745 pages from redo log. 2019-11-21 8:51:43 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001909', position 783157 2019-11-21 8:51:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:51:43 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:51:43 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:51:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:51:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:51:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:51:43 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:51:43 0 [Note] InnoDB: Rolled back recovered transaction 11399287618 2019-11-21 8:51:43 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:51:43 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886919492564; transaction id 11399287630 2019-11-21 8:51:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:51:43 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:51:43 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:51:43 0 [Note] Starting crash recovery... 2019-11-21 8:51:43 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:51:43 0 [Note] InnoDB: Transaction 11399287617 in prepared state after recovery 2019-11-21 8:51:43 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:51:43 0 [Note] InnoDB: Transaction 11399287595 in prepared state after recovery 2019-11-21 8:51:43 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:51:43 0 [Note] InnoDB: 2 transactions in prepared state after recovery 2019-11-21 8:51:43 0 [Note] Found 2 prepared transaction(s) in InnoDB 2019-11-21 8:51:43 0 [Note] Crash recovery finished. 2019-11-21 8:51:43 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:51:43 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:51:43 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:51:43 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:51:43 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:51:43 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:51:43 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:51:47 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=130 max_threads=5002 thread_count=137 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ec6ec0009a8 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 = 0x7ec7a0739d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x559916c568be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x5599166f359f] /lib64/libpthread.so.0(+0xf5f0)[0x7f132f49d5f0] /usr/sbin/mysqld(+0xcbb9bf)[0x559916c1b9bf] /usr/sbin/mysqld(+0xcc75da)[0x559916c275da] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x5599166f8187] /usr/sbin/mysqld(+0xcbfe19)[0x559916c1fe19] /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT20init_ror_merged_scanEbP11st_mem_root+0x85)[0x559916800e85] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT20init_ror_merged_scanEbP11st_mem_root+0x7d)[0x55991680109d] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT5resetEv+0x5f)[0x559916801e8f] /usr/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x48)[0x55991655bad8] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x55991654b2d9] /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa7b)[0x55991656cedb] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55991656d0f3] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x55991656d24a] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x55991656dd5c] /usr/sbin/mysqld(+0x4c2f4c)[0x559916422f4c] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x668b)[0x55991651803b] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x55991651a51b] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ca6)[0x55991651d106] /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x55991651e04e] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x221)[0x5599165f2111] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5599165f21dd] /usr/sbin/mysqld(+0xca77ad)[0x559916c077ad] /lib64/libpthread.so.0(+0x7e65)[0x7f132f495e65] 2019-11-21 8:51:54 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:51:54 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:51:54 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:51:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:51:54 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:51:54 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:51:54 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:52:03 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:52:05 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:52:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908884242 2019-11-21 8:52:08 0 [Note] InnoDB: Transaction 11399290179 was in the XA prepared state. 2019-11-21 8:52:08 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:52:08 0 [Note] InnoDB: Trx id counter is 11399290180 2019-11-21 8:52:08 0 [Note] InnoDB: Starting final batch to recover 2889 pages from redo log. 2019-11-21 8:52:11 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001910', position 790490 2019-11-21 8:52:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:52:11 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:52:11 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:52:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:52:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:52:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:52:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:52:11 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:52:12 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886920793823; transaction id 11399290182 2019-11-21 8:52:12 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:52:12 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:52:12 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:52:12 0 [Note] Starting crash recovery... 2019-11-21 8:52:12 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:52:12 0 [Note] InnoDB: Transaction 11399290179 in prepared state after recovery 2019-11-21 8:52:12 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:52:12 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:52:12 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:52:12 0 [Note] Crash recovery finished. 2019-11-21 8:52:12 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:52:12 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:52:12 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:52:12 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:52:12 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:52:12 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:52:12 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:52:13 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=130 max_threads=5002 thread_count=137 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f87c00009a8 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 = 0x7f8a0dea6d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x557b212d68be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x557b20d7359f] /lib64/libpthread.so.0(+0xf5f0)[0x7fd6216b45f0] 2019-11-21 8:52:20 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:52:20 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:52:20 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:52:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:52:20 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:52:20 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:52:20 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:52:29 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:52:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:52:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908884242 2019-11-21 8:52:34 0 [Note] InnoDB: Starting final batch to recover 3008 pages from redo log. 2019-11-21 8:52:37 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001911', position 324815 2019-11-21 8:52:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:52:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:52:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:52:37 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:52:37 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:52:37 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:52:37 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886921432526; transaction id 11399291467 2019-11-21 8:52:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:52:37 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:52:37 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:52:37 0 [Note] Starting crash recovery... 2019-11-21 8:52:37 0 [Note] Crash recovery finished. 2019-11-21 8:52:37 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:52:37 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:52:37 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:52:37 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:52:37 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:52:37 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:52:37 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:52:38 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=82 max_threads=5002 thread_count=89 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7edb7c0009a8 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... 2019-11-21 8:52:45 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:52:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:52:45 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:52:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:52:45 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:52:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:52:45 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:52:54 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:52:56 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:52:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908884242 2019-11-21 8:52:59 0 [Note] InnoDB: Transaction 11399292037 was in the XA prepared state. 2019-11-21 8:52:59 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:52:59 0 [Note] InnoDB: Trx id counter is 11399292038 2019-11-21 8:52:59 0 [Note] InnoDB: Starting final batch to recover 3040 pages from redo log. 2019-11-21 8:53:02 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001912', position 94991 2019-11-21 8:53:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:53:02 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:53:02 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:53:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:53:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:53:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:53:02 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:53:02 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:53:02 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886921638806; transaction id 11399292040 2019-11-21 8:53:02 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:53:02 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:53:02 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:53:02 0 [Note] Starting crash recovery... 2019-11-21 8:53:02 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:53:02 0 [Note] InnoDB: Transaction 11399292037 in prepared state after recovery 2019-11-21 8:53:02 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:53:02 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:53:02 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:53:02 0 [Note] Crash recovery finished. 2019-11-21 8:53:02 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:53:02 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:53:02 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:53:02 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:53:02 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:53:02 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:53:02 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:53:04 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=159 max_threads=5002 thread_count=166 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ef9b00009a8 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 = 0x7efac012bd00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x563b51ca68be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x563b5174359f] /lib64/libpthread.so.0(+0xf5f0)[0x7f46372955f0] /usr/sbin/mysqld(+0xcbb9bf)[0x563b51c6b9bf] /usr/sbin/mysqld(+0xcc75da)[0x563b51c775da] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x563b51748187] /usr/sbin/mysqld(+0xcbfe19)[0x563b51c6fe19] /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT20init_ror_merged_scanEbP11st_mem_root+0x85)[0x563b51850e85] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT20init_ror_merged_scanEbP11st_mem_root+0x7d)[0x563b5185109d] /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT5resetEv+0x5f)[0x563b51851e8f] /usr/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x48)[0x563b515abad8] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x563b5159b2d9] /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa7b)[0x563b515bcedb] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x563b515bd0f3] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x563b515bd24a] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x563b515bdd5c] /usr/sbin/mysqld(+0x4c2f4c)[0x563b51472f4c] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x668b)[0x563b5156803b] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x563b5156a51b] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ca6)[0x563b5156d106] /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x563b5156e04e] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x221)[0x563b51642111] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x563b516421dd] /usr/sbin/mysqld(+0xca77ad)[0x563b51c577ad] /lib64/libpthread.so.0(+0x7e65)[0x7f463728de65] /lib64/libc.so.6(clone+0x6d)[0x7f463562e88d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7ef9b000f4a0): SELECT COUNT(id) AS requests FROM api_log PARTITION(p11) WHERE kid='XXXX' AND auth_type='basic' AND auth_id='XXXX' AND created >= DATE_SUB(NOW(), INTERVAL 60 MINUTE) LIMIT 1 Connection ID (thread ID): 540 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on 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... Working directory at /var/lib/mysql Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 1540609 1540609 processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 1540609 1540609 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: core 2019-11-21 8:53:12 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:53:12 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:53:12 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:53:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:53:12 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:53:12 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:53:12 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:53:21 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:53:22 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:53:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886922975346 2019-11-21 8:53:25 0 [Note] InnoDB: Transaction 11399293970 was in the XA prepared state. 2019-11-21 8:53:25 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:53:25 0 [Note] InnoDB: Trx id counter is 11399293971 2019-11-21 8:53:25 0 [Note] InnoDB: Starting final batch to recover 3304 pages from redo log. 2019-11-21 8:53:28 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001913', position 755749 2019-11-21 8:53:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:53:28 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:53:28 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:53:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:53:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:53:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:53:28 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:53:28 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:53:28 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886923054356; transaction id 11399293973 2019-11-21 8:53:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:53:28 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:53:28 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:53:28 0 [Note] Starting crash recovery... 2019-11-21 8:53:28 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:53:28 0 [Note] InnoDB: Transaction 11399293970 in prepared state after recovery 2019-11-21 8:53:28 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:53:28 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:53:28 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:53:28 0 [Note] Crash recovery finished. 2019-11-21 8:53:28 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:53:28 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:53:28 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:53:28 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:53:28 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:53:28 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:53:28 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:53:30 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=156 max_threads=5002 thread_count=163 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f1a7c0009a8 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 = 0x7f1ccffccd00 thread_stack 0x30000 2019-11-21 8:53:37 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:53:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:53:37 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:53:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:53:37 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:53:37 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:53:37 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:53:48 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:53:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908887725 2019-11-21 8:53:51 0 [Note] InnoDB: Transaction 11399295103 was in the XA prepared state. 2019-11-21 8:53:51 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:53:51 0 [Note] InnoDB: Trx id counter is 11399295104 2019-11-21 8:53:51 0 [Note] InnoDB: Starting final batch to recover 3392 pages from redo log. 2019-11-21 8:53:54 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001914', position 305726 2019-11-21 8:53:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:53:54 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:53:54 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:53:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:53:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:53:54 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:53:54 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:53:54 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:53:54 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886923586703; transaction id 11399295106 2019-11-21 8:53:54 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:53:54 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:53:54 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:53:54 0 [Note] Starting crash recovery... 2019-11-21 8:53:54 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:53:54 0 [Note] InnoDB: Transaction 11399295103 in prepared state after recovery 2019-11-21 8:53:54 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:53:54 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:53:54 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:53:54 0 [Note] Crash recovery finished. 2019-11-21 8:53:54 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:53:54 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:53:54 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:53:54 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:53:54 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:53:54 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:53:54 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:53:59 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=185 max_threads=5002 thread_count=192 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ebb080009a8 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 = 0x7ebf34151d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55e48e9498be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55e48e3e659f] /lib64/libpthread.so.0(+0xf5f0)[0x7f0aaa0575f0] 2019-11-21 8:54:06 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:54:06 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:54:06 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:54:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:54:06 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:54:06 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:54:06 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:54:15 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:54:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:54:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908887725 2019-11-21 8:54:20 0 [Note] InnoDB: Transaction 11399298536 was in the XA prepared state. 2019-11-21 8:54:20 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-11-21 8:54:20 0 [Note] InnoDB: Trx id counter is 11399298537 2019-11-21 8:54:20 0 [Note] InnoDB: Starting final batch to recover 3609 pages from redo log. 2019-11-21 8:54:23 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001915', position 1104681 2019-11-21 8:54:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:54:23 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:54:23 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:54:23 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:54:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:54:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:54:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:54:23 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:54:23 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886925396133; transaction id 11399298539 2019-11-21 8:54:23 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:54:23 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:54:23 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:54:23 0 [Note] Starting crash recovery... 2019-11-21 8:54:23 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:54:23 0 [Note] InnoDB: Transaction 11399298536 in prepared state after recovery 2019-11-21 8:54:23 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:54:23 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:54:23 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:54:23 0 [Note] Crash recovery finished. 2019-11-21 8:54:23 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:54:23 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:54:23 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:54:23 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:54:23 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:54:23 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:54:23 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 191121 8:54:26 [ERROR] mysqld got signal 11 ; 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. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.20-MariaDB-log key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=142 max_threads=5002 thread_count=149 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f209c0009a8 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 = 0x7f22e16d6d00 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5632a96678be] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x5632a910459f] 2019-11-21 8:54:33 0 [Note] InnoDB: Using Linux native AIO 2019-11-21 8:54:33 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-21 8:54:33 0 [Note] InnoDB: Uses event mutexes 2019-11-21 8:54:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-21 8:54:33 0 [Note] InnoDB: Number of pools: 1 2019-11-21 8:54:33 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-21 8:54:33 0 [Note] InnoDB: Initializing buffer pool, total size = 288G, instances = 64, chunk size = 128M 2019-11-21 8:54:42 0 [Note] InnoDB: Completed initialization of buffer pool 2019-11-21 8:54:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-21 8:54:45 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19886908887725 2019-11-21 8:54:47 0 [Note] InnoDB: Transaction 11399300285 was in the XA prepared state. 2019-11-21 8:54:47 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo 2019-11-21 8:54:47 0 [Note] InnoDB: Trx id counter is 11399300302 2019-11-21 8:54:47 0 [Note] InnoDB: Starting final batch to recover 3791 pages from redo log. 2019-11-21 8:54:50 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-m1.001916', position 521414 2019-11-21 8:54:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-21 8:54:50 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-11-21 8:54:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-21 8:54:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-21 8:54:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-21 8:54:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-11-21 8:54:50 0 [Note] InnoDB: Waiting for purge to start 2019-11-21 8:54:50 0 [Note] InnoDB: Rolled back recovered transaction 11399300299 2019-11-21 8:54:50 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-11-21 8:54:50 0 [Note] InnoDB: 10.3.20 started; log sequence number 19886926426940; transaction id 11399300305 2019-11-21 8:54:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-11-21 8:54:50 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-11-21 8:54:50 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-m1 2019-11-21 8:54:50 0 [Note] Starting crash recovery... 2019-11-21 8:54:50 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-11-21 8:54:50 0 [Note] InnoDB: Transaction 11399300285 in prepared state after recovery 2019-11-21 8:54:50 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-11-21 8:54:50 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-11-21 8:54:50 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-11-21 8:54:50 0 [Note] Crash recovery finished. 2019-11-21 8:54:50 0 [Note] Server socket created on IP: 'XX.XXX.XXX.81'. 2019-11-21 8:54:50 8 [Note] Reading Master_info: 'master-from_dbcl02@002d01.info' Relay_info:'relay-log-from_dbcl02@002d01.info' 2019-11-21 8:54:50 8 [Note] Initialized Master_info from 'master-from_dbcl02@002d01.info' 2019-11-21 8:54:50 8 [Note] Added new Master_info 'from_dbcl02-01' to hash table 2019-11-21 8:54:50 0 [Note] Reading of all Master_info entries succeeded 2019-11-21 8:54:50 0 [Note] Added new Master_info '' to hash table 2019-11-21 8:54:50 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2019-11-21 8:55:44 13607 [Note] InnoDB: Number of pools: 2 2019-11-21 9:00:36 102301 [Note] Start binlog_dump to slave_server(82), pos(binlog-m1.001897, 4) 2019-11-21 9:01:13 113642 [Note] InnoDB: Number of pools: 3 2019-11-21 9:01:31 118813 [Note] Start binlog_dump to slave_server(86), pos(binlog-m1.001896, 1073742032) 2019-11-21 9:06:00 199792 [Note] Start binlog_dump to slave_server(84), pos(binlog-m1.001897, 592558739) 2019-11-21 9:08:38 249474 [Note] Master 'from_dbcl02-01': Slave I/O thread: Start asynchronous replication to master 'slave@XX.XXX.XXX.86:3306' in log 'binlog-m2.001897' at position 138955929 2019-11-21 9:08:38 249475 [Note] Master 'from_dbcl02-01': Slave SQL thread initialized, starting replication in log 'binlog-m2.001897' at position 138955929, relay log '/var/lib/mysql/relay-bin-m1-from_dbcl02@002d01.000001' position: 4; GTID position '0-51-4941698647,1-81-85182964,2-86-2' 2019-11-21 9:08:38 249474 [Note] Master 'from_dbcl02-01': Slave I/O thread: connected to master 'slave@XX.XXX.XXX.86:3306',replication starts at GTID position '1-81-85182964,0-51-4941698647,2-86-2'