Aug 3 09:56:10 CentOS-Test mysqld: 170803 9:56:10 [ERROR] mysqld got signal 11 ; Aug 3 09:56:10 CentOS-Test mysqld: This could be because you hit a bug. It is also possible that this binary Aug 3 09:56:10 CentOS-Test mysqld: or one of the libraries it was linked against is corrupt, improperly built, Aug 3 09:56:10 CentOS-Test mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Aug 3 09:56:10 CentOS-Test mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Aug 3 09:56:10 CentOS-Test mysqld: We will try our best to scrape up some info that will hopefully help Aug 3 09:56:10 CentOS-Test mysqld: diagnose the problem, but since we have already crashed, Aug 3 09:56:10 CentOS-Test mysqld: something is definitely wrong and this may fail. Aug 3 09:56:10 CentOS-Test mysqld: Server version: 10.2.7-MariaDB Aug 3 09:56:10 CentOS-Test mysqld: key_buffer_size=134217728 Aug 3 09:56:10 CentOS-Test mysqld: read_buffer_size=131072 Aug 3 09:56:10 CentOS-Test mysqld: max_used_connections=2 Aug 3 09:56:10 CentOS-Test mysqld: max_threads=153 Aug 3 09:56:10 CentOS-Test mysqld: thread_count=7 Aug 3 09:56:10 CentOS-Test mysqld: It is possible that mysqld could use up to Aug 3 09:56:10 CentOS-Test mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467207 K bytes of memory Aug 3 09:56:10 CentOS-Test mysqld: Hope that's ok; if not, decrease some variables in the equation. Aug 3 09:56:10 CentOS-Test mysqld: Thread pointer: 0x7f4a18000a88 Aug 3 09:56:10 CentOS-Test mysqld: Attempting backtrace. You can use the following information to find out Aug 3 09:56:10 CentOS-Test mysqld: where mysqld died. If you see no messages after this, something went Aug 3 09:56:10 CentOS-Test mysqld: terribly wrong... Aug 3 09:56:10 CentOS-Test mysqld: stack_bottom = 0x7f4a0c48ed70 thread_stack 0x49000 Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7f4a2a3c537e] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x7f4a29e0afad] Aug 3 09:56:10 CentOS-Test mysqld: /lib64/libpthread.so.0(+0xf370)[0x7f4a29379370] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xd5)[0x7f4a29bfafd5] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0x53)[0x7f4a29c52273] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(+0x51a8cf)[0x7f4a29cc28cf] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(+0x503593)[0x7f4a29cab593] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x17e)[0x7f4a29cb30de] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa0f)[0x7f4a29cd218f] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x7f4a29cd23a3] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x7f4a29cd24fa] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x24c)[0x7f4a29cd304c] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(+0x4ce906)[0x7f4a29c76906] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5e2a)[0x7f4a29c82f5a] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x7f4a29c8631e] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x2029)[0x7f4a29c891b9] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x161)[0x7f4a29c89d71] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x7f4a29d4b80a] Aug 3 09:56:10 CentOS-Test mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x7f4a29d4b92d] Aug 3 09:56:10 CentOS-Test mysqld: /lib64/libpthread.so.0(+0x7dc5)[0x7f4a29371dc5] Aug 3 09:56:10 CentOS-Test mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f4a279c473d] Aug 3 09:56:10 CentOS-Test mysqld: Trying to get some variables. Aug 3 09:56:10 CentOS-Test mysqld: Some pointers may be invalid and cause the dump to abort. Aug 3 09:56:10 CentOS-Test mysqld: Query (0x7f4a18010330): select * from `bugTest`.`supplierSendingTimes` limit 0, 1000 Aug 3 09:56:10 CentOS-Test mysqld: Connection ID (thread ID): 8 Aug 3 09:56:10 CentOS-Test mysqld: Status: NOT_KILLED Aug 3 09:56:10 CentOS-Test 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 Aug 3 09:56:10 CentOS-Test mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Aug 3 09:56:10 CentOS-Test mysqld: information that should help you find out what is causing the crash. Aug 3 09:56:10 CentOS-Test systemd: mariadb.service: main process exited, code=killed, status=11/SEGV Aug 3 09:56:10 CentOS-Test systemd: Unit mariadb.service entered failed state. Aug 3 09:56:10 CentOS-Test systemd: mariadb.service failed. Aug 3 09:56:16 CentOS-Test systemd: mariadb.service holdoff time over, scheduling restart. Aug 3 09:56:16 CentOS-Test systemd: Starting MariaDB database server... Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] /usr/sbin/mysqld (mysqld 10.2.7-MariaDB) starting as process 19261 ... Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Uses event mutexes Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Compressed tables use zlib 1.2.7 Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Using Linux native AIO Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Number of pools: 1 Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Using generic crc32 instructions Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Completed initialization of buffer pool Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572195845888 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Highest supported file format is Barracuda. Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1746808 Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: 128 out of 128 rollback segments are active. Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Creating shared tablespace for temporary tables Aug 3 09:56:16 CentOS-Test mysqld: 2017-08-03 9:56:16 140572961265792 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] InnoDB: Waiting for purge to start Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] InnoDB: 5.7.18 started; log sequence number 1746817 Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572031432448 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572031432448 [Note] InnoDB: Buffer pool(s) load completed at 170803 9:56:17 Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Plugin 'FEEDBACK' is disabled. Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Recovering after a crash using tc.log Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Starting crash recovery... Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Crash recovery finished. Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Server socket created on IP: '0.0.0.0'. Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Reading of all Master_info entries succeded Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] Added new Master_info '' to hash table Aug 3 09:56:17 CentOS-Test mysqld: 2017-08-03 9:56:17 140572961265792 [Note] /usr/sbin/mysqld: ready for connections. Aug 3 09:56:17 CentOS-Test mysqld: Version: '10.2.7-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Aug 3 09:56:17 CentOS-Test systemd: Started MariaDB database server.