Nov 18 07:58:15 dbslave-02 mysqld: 191118 7:58:15 [ERROR] mysqld got signal 11 ; Nov 18 07:58:15 dbslave-02 mysqld: This could be because you hit a bug. It is also possible that this binary Nov 18 07:58:15 dbslave-02 mysqld: or one of the libraries it was linked against is corrupt, improperly built, Nov 18 07:58:15 dbslave-02 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Nov 18 07:58:15 dbslave-02 mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Nov 18 07:58:15 dbslave-02 mysqld: We will try our best to scrape up some info that will hopefully help Nov 18 07:58:15 dbslave-02 mysqld: diagnose the problem, but since we have already crashed, Nov 18 07:58:15 dbslave-02 mysqld: something is definitely wrong and this may fail. Nov 18 07:58:15 dbslave-02 mysqld: Server version: 10.3.20-MariaDB-log Nov 18 07:58:15 dbslave-02 mysqld: key_buffer_size=134217728 Nov 18 07:58:15 dbslave-02 mysqld: read_buffer_size=2097152 Nov 18 07:58:15 dbslave-02 mysqld: max_used_connections=8 Nov 18 07:58:15 dbslave-02 mysqld: max_threads=5002 Nov 18 07:58:15 dbslave-02 mysqld: thread_count=25 Nov 18 07:58:15 dbslave-02 mysqld: It is possible that mysqld could use up to Nov 18 07:58:15 dbslave-02 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20731864 K bytes of memory Nov 18 07:58:15 dbslave-02 mysqld: Hope that's ok; if not, decrease some variables in the equation. Nov 18 07:58:15 dbslave-02 mysqld: Thread pointer: 0x7f907c0009a8 Nov 18 07:58:15 dbslave-02 mysqld: Attempting backtrace. You can use the following information to find out Nov 18 07:58:15 dbslave-02 mysqld: where mysqld died. If you see no messages after this, something went Nov 18 07:58:15 dbslave-02 mysqld: terribly wrong... Nov 18 07:58:15 dbslave-02 mysqld: stack_bottom = 0x7f91d4320d00 thread_stack 0x30000 Nov 18 07:58:15 dbslave-02 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55e68be728be] Nov 18 07:58:15 dbslave-02 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x55e68b90f59f] Nov 18 07:58:15 dbslave-02 mysqld: sigaction.c:0(__restore_rt)[0x7fbbfa4d35f0] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(+0xcbb9bf)[0x55e68be379bf] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(+0xcc75da)[0x55e68be435da] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcijP11st_mem_rootP4ListI6StringE+0x47)[0x55e68b914187] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(+0xcbfe19)[0x55e68be3be19] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN18QUICK_RANGE_SELECT20init_ror_merged_scanEbP11st_mem_root+0x85)[0x55e68ba1ce85] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT20init_ror_merged_scanEbP11st_mem_root+0x7d)[0x55e68ba1d09d] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT5resetEv+0x5f)[0x55e68ba1de8f] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z8filesortP3THDP5TABLEP8FilesortP16Filesort_trackerP4JOINy+0x1219)[0x55e68b90ea29] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z17create_sort_indexP3THDP4JOINP13st_join_tableP8Filesort+0xd7)[0x55e68b777737] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN13st_join_table10sort_tableEv+0x73)[0x55e68b777a53] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x2d)[0x55e68b777abd] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x55e68b7672d9] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa7b)[0x55e68b788edb] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x55e68b7890f3] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x55e68b78924a] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cc)[0x55e68b789d5c] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(+0x4c2f4c)[0x55e68b63ef4c] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x668b)[0x55e68b73403b] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22b)[0x55e68b73651b] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ca6)[0x55e68b739106] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x13e)[0x55e68b73a04e] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x221)[0x55e68b80e111] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55e68b80e1dd] Nov 18 07:58:16 dbslave-02 mysqld: /usr/sbin/mysqld(+0xca77ad)[0x55e68be237ad] Nov 18 07:58:16 dbslave-02 mysqld: pthread_create.c:0(start_thread)[0x7fbbfa4cbe65] Nov 18 07:58:16 dbslave-02 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fbbf886c88d] Nov 18 07:58:16 dbslave-02 mysqld: Trying to get some variables. Nov 18 07:58:16 dbslave-02 mysqld: Some pointers may be invalid and cause the dump to abort. Nov 18 07:58:16 dbslave-02 kernel: mysqld[17137]: segfault at 19 ip 000055e68be379bf sp 00007f91d431dd70 error 4 in mysqld[55e68b17c000+12c9000] Nov 18 07:58:16 dbslave-02 mysqld: Query (0x7f907c00f470): SELECT id, direction, from_number, to_number, service, duration_bill, success, DATE_FORMAT(date_time, '%d.%m. %H:%i:%s' ) AS datum, XXXXX_group_id FROM XXX_XXX PARTITION(p11) WHERE kid='XXXX' AND XXXXXXX_id='XXXXX' AND id > 'XXXXXXXX' ORDER BY id DESC LIMIT 50 Nov 18 07:58:16 dbslave-02 mysqld: Connection ID (thread ID): 877338 Nov 18 07:58:16 dbslave-02 mysqld: Status: NOT_KILLED Nov 18 07:58:16 dbslave-02 mysqld: 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 Nov 18 07:58:16 dbslave-02 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Nov 18 07:58:16 dbslave-02 mysqld: information that should help you find out what is causing the crash. Nov 18 07:58:16 dbslave-02 mysqld: Writing a core file... Nov 18 07:58:16 dbslave-02 mysqld: Working directory at /var/lib/mysql Nov 18 07:58:16 dbslave-02 mysqld: Resource Limits: Nov 18 07:58:16 dbslave-02 mysqld: Limit Soft Limit Hard Limit Units Nov 18 07:58:16 dbslave-02 mysqld: Max cpu time unlimited unlimited seconds Nov 18 07:58:16 dbslave-02 mysqld: Max file size unlimited unlimited bytes Nov 18 07:58:16 dbslave-02 mysqld: Max data size unlimited unlimited bytes Nov 18 07:58:16 dbslave-02 mysqld: Max stack size 8388608 unlimited bytes Nov 18 07:58:16 dbslave-02 mysqld: Max core file size 0 unlimited bytes Nov 18 07:58:16 dbslave-02 mysqld: Max resident set unlimited unlimited bytes Nov 18 07:58:16 dbslave-02 mysqld: Max processes 1029963 1029963 processes Nov 18 07:58:16 dbslave-02 mysqld: Max open files 65535 65535 files Nov 18 07:58:16 dbslave-02 mysqld: Max locked memory 65536 65536 bytes Nov 18 07:58:16 dbslave-02 mysqld: Max address space unlimited unlimited bytes Nov 18 07:58:16 dbslave-02 mysqld: Max file locks unlimited unlimited locks Nov 18 07:58:16 dbslave-02 mysqld: Max pending signals 1029963 1029963 signals Nov 18 07:58:16 dbslave-02 mysqld: Max msgqueue size 819200 819200 bytes Nov 18 07:58:16 dbslave-02 mysqld: Max nice priority 0 0 Nov 18 07:58:16 dbslave-02 mysqld: Max realtime priority 0 0 Nov 18 07:58:16 dbslave-02 mysqld: Max realtime timeout unlimited unlimited us Nov 18 07:58:16 dbslave-02 mysqld: Core pattern: core Nov 18 07:58:16 dbslave-02 systemd: mariadb.service: main process exited, code=killed, status=11/SEGV Nov 18 07:58:16 dbslave-02 systemd: Unit mariadb.service entered failed state. Nov 18 07:58:16 dbslave-02 systemd: mariadb.service failed. Nov 18 07:58:21 dbslave-02 systemd: mariadb.service holdoff time over, scheduling restart. Nov 18 07:58:21 dbslave-02 systemd: Stopped MariaDB 10.3.20 database server. Nov 18 07:58:21 dbslave-02 systemd: Starting MariaDB 10.3.20 database server... Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] /usr/sbin/mysqld (mysqld 10.3.20-MariaDB-log) starting as process 65965 ... Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Using Linux native AIO Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Uses event mutexes Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Number of pools: 1 Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Using SSE2 crc32 instructions Nov 18 07:58:22 dbslave-02 mysqld: 2019-11-18 7:58:22 0 [Note] InnoDB: Initializing buffer pool, total size = 160G, instances = 64, chunk size = 128M Nov 18 07:58:27 dbslave-02 mysqld: 2019-11-18 7:58:27 0 [Note] InnoDB: Completed initialization of buffer pool Nov 18 07:58:28 dbslave-02 mysqld: 2019-11-18 7:58:28 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Nov 18 07:58:29 dbslave-02 mysqld: 2019-11-18 7:58:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19766258999001 Nov 18 07:58:43 dbslave-02 mysqld: 2019-11-18 7:58:43 0 [Note] InnoDB: Read redo log up to LSN=19765215502848 Nov 18 07:58:47 dbslave-02 mysqld: 2019-11-18 7:58:47 0 [Note] InnoDB: Ignoring data file './db/XXXXXXXX_XXXX_XXXXXX.ibd' with space ID 19935, since the redo log references ./db/XXXXXXXX_XXXX_XXXXXX.ibd with space ID 19931. Nov 18 07:58:49 dbslave-02 mysqld: 2019-11-18 7:58:49 0 [Note] InnoDB: Ignoring data file './db/XXXXXXXX_XXXX_XXXXXX.ibd' with space ID 19936, since the redo log references ./db/XXXXXXXX_XXXX_XXXXXX.ibd with space ID 19932. Nov 18 07:58:49 dbslave-02 mysqld: 2019-11-18 7:58:49 0 [Note] InnoDB: Ignoring data file './db/XXXXXXXX_XXXX_XXXXXX.ibd' with space ID 19937, since the redo log references ./db/XXXXXXXX_XXXX_XXXXXX.ibd with space ID 19933. Nov 18 07:58:49 dbslave-02 mysqld: 2019-11-18 7:58:49 0 [Note] InnoDB: Ignoring data file './db/XXXXXXXX_XXXX_XXXXXX.ibd' with space ID 19938, since the redo log references ./db/XXXXXXXX_XXXX_XXXXXX.ibd with space ID 19934. Nov 18 07:58:57 dbslave-02 mysqld: 2019-11-18 7:58:57 0 [Note] InnoDB: Transaction 11090939365 was in the XA prepared state. Nov 18 07:58:59 dbslave-02 mysqld: 2019-11-18 7:58:59 0 [Note] InnoDB: To recover: 104637 pages from log Nov 18 07:58:59 dbslave-02 mysqld: 2019-11-18 7:58:59 0 [Note] InnoDB: Transaction 11090939366 was in the XA prepared state. Nov 18 07:58:59 dbslave-02 mysqld: 2019-11-18 7:58:59 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo Nov 18 07:58:59 dbslave-02 mysqld: 2019-11-18 7:58:59 0 [Note] InnoDB: Trx id counter is 11090939367 Nov 18 07:58:59 dbslave-02 mysqld: 2019-11-18 7:58:59 0 [Note] InnoDB: Starting final batch to recover 104636 pages from redo log. Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Last binlog file '/var/lib/mysql/binlog-dbslave-02.000047', position 577738037 Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Starting in background the rollback of recovered transactions Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Rollback of non-prepared transactions completed Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Waiting for purge to start Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: 10.3.20 started; log sequence number 19766271753964; transaction id 11090939369 Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] Plugin 'FEEDBACK' is disabled. Nov 18 07:59:07 dbslave-02 mysqld: 2019-11-18 7:59:07 0 [Note] Recovering after a crash using /var/lib/mysql/binlog-dbslave-02 Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] Starting crash recovery... Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] InnoDB: Starting recovery for XA transactions... Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] InnoDB: Transaction 11090939365 in prepared state after recovery Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] InnoDB: Transaction contains changes to 5 rows Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] InnoDB: Transaction 11090939366 in prepared state after recovery Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] InnoDB: Transaction contains changes to 2 rows Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] InnoDB: 2 transactions in prepared state after recovery Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] Found 2 prepared transaction(s) in InnoDB Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] Crash recovery finished. Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] Server socket created on IP: '10.100.XXX.XX'. Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 8 [Note] Reading Master_info: 'master-from_dbmaster-02@002d01@002d02.info' Relay_info:'relay-log-from_dbmaster-02@002d01@002d02.info' Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 8 [Note] Initialized Master_info from 'master-from_dbmaster-02@002d01@002d02.info' Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 8 [Note] Added new Master_info 'from_dbmaster-02' to hash table Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] Reading of all Master_info entries succeeded Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] Added new Master_info '' to hash table Nov 18 07:59:09 dbslave-02 mysqld: 2019-11-18 7:59:09 0 [Note] /usr/sbin/mysqld: ready for connections. Nov 18 07:59:09 dbslave-02 mysqld: Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Nov 18 07:59:09 dbslave-02 systemd: Started MariaDB 10.3.20 database server. Nov 18 08:03:29 dbslave-02 mysqld: 2019-11-18 8:03:29 0 [Note] InnoDB: Buffer pool(s) load completed at 191118 8:03:29 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] Event Scheduler: Purging the queue. 0 events Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: FTS optimize thread exiting. Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Starting shutdown... Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 0, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 1, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 2, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 3, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 4, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 5, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 6, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 7, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 8, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 9, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 10, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 11, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 12, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 13, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 14, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 15, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 16, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 17, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 18, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:17 dbslave-02 mysqld: 2019-11-18 8:07:17 0 [Note] InnoDB: Instance 19, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 20, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 21, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 22, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 23, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 24, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 25, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 26, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 27, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 28, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 29, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 30, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 31, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 32, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 33, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 34, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 35, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 36, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 37, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 38, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 39, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 40, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 41, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 42, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 43, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 44, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 45, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 46, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 47, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 48, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 49, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 50, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 51, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 52, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 53, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 54, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 55, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 56, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 57, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 58, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 59, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 60, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 61, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 62, restricted to 40960 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Instance 63, restricted to 40955 pages due to innodb_buf_pool_dump_pct=25 Nov 18 08:07:18 dbslave-02 mysqld: 2019-11-18 8:07:18 0 [Note] InnoDB: Buffer pool(s) dump completed at 191118 8:07:18 Nov 18 08:07:24 dbslave-02 mysqld: 2019-11-18 8:07:24 0 [Note] InnoDB: Shutdown completed; log sequence number 19766273500481; transaction id 11090940185 Nov 18 08:07:24 dbslave-02 mysqld: 2019-11-18 8:07:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Nov 18 08:07:24 dbslave-02 mysqld: 2019-11-18 8:07:24 0 [Note] /usr/sbin/mysqld: Shutdown complete Nov 18 08:07:25 dbslave-02 systemd: Stopped MariaDB 10.3.20 database server. Nov 18 08:07:47 dbslave-02 systemd: Starting MariaDB 10.3.20 database server... Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] /usr/sbin/mysqld (mysqld 10.3.20-MariaDB-log) starting as process 69304 ... Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Using Linux native AIO Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Uses event mutexes Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Number of pools: 1 Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Using SSE2 crc32 instructions Nov 18 08:07:47 dbslave-02 mysqld: 2019-11-18 8:07:47 0 [Note] InnoDB: Initializing buffer pool, total size = 160G, instances = 64, chunk size = 128M Nov 18 08:07:53 dbslave-02 mysqld: 2019-11-18 8:07:53 0 [Note] InnoDB: Completed initialization of buffer pool Nov 18 08:07:54 dbslave-02 mysqld: 2019-11-18 8:07:54 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active. Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] InnoDB: 10.3.20 started; log sequence number 19766273500481; transaction id 11090939373 Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] Plugin 'FEEDBACK' is disabled. Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] Server socket created on IP: '10.100.XXX.XX'. Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 8 [Note] Reading Master_info: 'master-from_dbmaster-02@002d01@002d02.info' Relay_info:'relay-log-from_dbmaster-02@002d01@002d02.info' Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 8 [Note] Initialized Master_info from 'master-from_dbmaster-02@002d01@002d02.info' Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 8 [Note] Added new Master_info 'from_dbmaster-02' to hash table Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] Reading of all Master_info entries succeeded Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] Added new Master_info '' to hash table Nov 18 08:07:56 dbslave-02 mysqld: 2019-11-18 8:07:56 0 [Note] /usr/sbin/mysqld: ready for connections. Nov 18 08:07:56 dbslave-02 mysqld: Version: '10.3.20-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Nov 18 08:07:56 dbslave-02 systemd: Started MariaDB 10.3.20 database server. Nov 18 08:09:13 dbslave-02 mysqld: 2019-11-18 8:09:13 2030 [Note] Master 'from_dbmaster-02': Slave I/O thread: Start asynchronous replication to master 'slave@10.100.XXX.XX:3306' in log 'binlog-m2.001815' at position 1073741388 Nov 18 08:09:13 dbslave-02 mysqld: 2019-11-18 8:09:13 2030 [Note] Master 'from_dbmaster-02': Slave I/O thread: connected to master 'slave@10.100.XXX.XX:3306',replication starts at GTID position '1-81-13922339,0-51-4941698647,2-86-2' Nov 18 08:09:13 dbslave-02 mysqld: 2019-11-18 8:09:13 2031 [Note] Master 'from_dbmaster-02': Slave SQL thread initialized, starting replication in log 'binlog-m2.001815' at position 1073741388, relay log '/var/lib/mysql/relay-bin-dbslave-02-from_dbmaster-02@002d01@002d02.000001' position: 4; GTID position '0-51-4941698647,1-81-13922339,2-86-2'