Aug 2 23:43:18 CentOS-Test systemd: Starting MariaDB database server... Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] /usr/sbin/mysqld (mysqld 10.2.7-MariaDB) starting as process 3025 ... Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Uses event mutexes Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Compressed tables use zlib 1.2.7 Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Using Linux native AIO Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Number of pools: 1 Aug 2 23:43:18 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Using generic crc32 instructions Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:18 139881481263232 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: Completed initialization of buffer pool Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139880717846272 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: Highest supported file format is Barracuda. Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: 128 out of 128 rollback segments are active. Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: Creating shared tablespace for temporary tables Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] InnoDB: 5.7.18 started; log sequence number 1620182 Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139880550090496 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139880550090496 [Note] InnoDB: Buffer pool(s) load completed at 170802 23:43:19 Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] Plugin 'FEEDBACK' is disabled. Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] Server socket created on IP: '0.0.0.0'. Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] Reading of all Master_info entries succeded Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] Added new Master_info '' to hash table Aug 2 23:43:19 CentOS-Test mysqld: 2017-08-02 23:43:19 139881481263232 [Note] /usr/sbin/mysqld: ready for connections. Aug 2 23:43:19 CentOS-Test mysqld: Version: '10.2.7-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Aug 2 23:43:19 CentOS-Test systemd: Started MariaDB database server. Aug 2 23:44:33 CentOS-Test systemd: Starting Cleanup of Temporary Directories... Aug 2 23:44:33 CentOS-Test systemd: Started Cleanup of Temporary Directories. Aug 2 23:47:14 CentOS-Test mysqld: 2017-08-02 23:47:14 139880845752064 [Warning] IP address '10.0.10.17' could not be resolved: Name or service not known Aug 2 23:48:53 CentOS-Test mysqld: 2017-08-02 23:48:53 139880845448960 [Warning] Access denied for user 'root'@'10.0.10.17' (using password: YES) Aug 2 23:49:58 CentOS-Test mysqld: 170802 23:49:58 [ERROR] mysqld got signal 11 ; Aug 2 23:49:58 CentOS-Test mysqld: This could be because you hit a bug. It is also possible that this binary Aug 2 23:49:58 CentOS-Test mysqld: or one of the libraries it was linked against is corrupt, improperly built, Aug 2 23:49:58 CentOS-Test mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Aug 2 23:49:58 CentOS-Test mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Aug 2 23:49:58 CentOS-Test mysqld: We will try our best to scrape up some info that will hopefully help Aug 2 23:49:58 CentOS-Test mysqld: diagnose the problem, but since we have already crashed, Aug 2 23:49:58 CentOS-Test mysqld: something is definitely wrong and this may fail. Aug 2 23:49:58 CentOS-Test mysqld: Server version: 10.2.7-MariaDB Aug 2 23:49:58 CentOS-Test mysqld: key_buffer_size=134217728 Aug 2 23:49:58 CentOS-Test mysqld: read_buffer_size=131072 Aug 2 23:49:58 CentOS-Test mysqld: max_used_connections=4 Aug 2 23:49:58 CentOS-Test mysqld: max_threads=153 Aug 2 23:49:58 CentOS-Test mysqld: thread_count=10 Aug 2 23:49:58 CentOS-Test mysqld: It is possible that mysqld could use up to Aug 2 23:49:58 CentOS-Test mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467207 K bytes of memory Aug 2 23:49:58 CentOS-Test mysqld: Hope that's ok; if not, decrease some variables in the equation. Aug 2 23:49:58 CentOS-Test mysqld: Thread pointer: 0x7f38b6214f08 Aug 2 23:49:58 CentOS-Test mysqld: Attempting backtrace. You can use the following information to find out Aug 2 23:49:58 CentOS-Test mysqld: where mysqld died. If you see no messages after this, something went Aug 2 23:49:58 CentOS-Test mysqld: terribly wrong... Aug 2 23:49:58 CentOS-Test mysqld: stack_bottom = 0x7f388c1a8d70 thread_stack 0x49000 Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7f38b2c6337e] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x7f38b26a8fad] Aug 2 23:49:58 CentOS-Test mysqld: /lib64/libpthread.so.0(+0xf370)[0x7f38b1c17370] Aug 2 23:49:58 CentOS-Test mysqld: /lib64/libc.so.6(+0x148e78)[0x7f38b02b3e78] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN6String4copyERKS_+0x26)[0x7f38b2592bf6] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN16Item_func_concat7val_strEP6String+0x1ab)[0x7f38b273787b] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN22Item_func_json_extract7val_strEP6String+0xde)[0x7f38b282283e] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN20Item_func_json_value7val_strEP6String+0x35)[0x7f38b281ff85] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4Item8get_dateEP13st_mysql_timey+0x23f)[0x7f38b26bdfcf] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN18Item_time_typecast8get_dateEP13st_mysql_timey+0x2e)[0x7f38b276df6e] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4Item24get_date_with_conversionEP13st_mysql_timey+0x4e)[0x7f38b26be66e] Aug 2 23:49:58 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN18Item_func_coalesce7date_opEP13st_mysql_timej+0x56)[0x7f38b26da8c6] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN27Item_func_hybrid_field_type7val_strEP6String+0x67)[0x7f38b2711787] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4Item13save_in_fieldEP5Fieldb+0x6f)[0x7f38b26b907f] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN5TABLE21update_virtual_fieldsEP7handler21enum_vcol_update_mode+0x1e0)[0x7f38b25c71a0] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x1ca)[0x7f38b26ad8ba] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x20)[0x7f38b27d0430] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x169)[0x7f38b25510c9] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xa0f)[0x7f38b257018f] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x7f38b25703a3] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x7f38b25704fa] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x24c)[0x7f38b257104c] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(+0x4ce906)[0x7f38b2514906] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5e2a)[0x7f38b2520f5a] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x7f38b252431e] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x2029)[0x7f38b25271b9] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x161)[0x7f38b2527d71] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x7f38b25e980a] Aug 2 23:49:59 CentOS-Test mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x7f38b25e992d] Aug 2 23:49:59 CentOS-Test mysqld: /lib64/libpthread.so.0(+0x7dc5)[0x7f38b1c0fdc5] Aug 2 23:49:59 CentOS-Test mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f38b026273d] Aug 2 23:49:59 CentOS-Test mysqld: Trying to get some variables. Aug 2 23:49:59 CentOS-Test mysqld: Some pointers may be invalid and cause the dump to abort. Aug 2 23:49:59 CentOS-Test mysqld: Query (0x7f38b62223e0): select * from `bugTest`.`supplierSendingTimes` limit 0, 1000 Aug 2 23:49:59 CentOS-Test mysqld: Connection ID (thread ID): 12 Aug 2 23:49:59 CentOS-Test mysqld: Status: NOT_KILLED Aug 2 23:49:59 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 2 23:49:59 CentOS-Test mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Aug 2 23:49:59 CentOS-Test mysqld: information that should help you find out what is causing the crash. Aug 2 23:49:59 CentOS-Test systemd: mariadb.service: main process exited, code=killed, status=11/SEGV Aug 2 23:49:59 CentOS-Test systemd: Unit mariadb.service entered failed state. Aug 2 23:49:59 CentOS-Test systemd: mariadb.service failed. Aug 2 23:50:04 CentOS-Test systemd: mariadb.service holdoff time over, scheduling restart. Aug 2 23:50:04 CentOS-Test systemd: Starting MariaDB database server... Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] /usr/sbin/mysqld (mysqld 10.2.7-MariaDB) starting as process 3192 ... Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Uses event mutexes Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Compressed tables use zlib 1.2.7 Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Using Linux native AIO Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Number of pools: 1 Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Using generic crc32 instructions Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Completed initialization of buffer pool Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140380427212544 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Highest supported file format is Barracuda. Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1744462 Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: 128 out of 128 rollback segments are active. Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Creating shared tablespace for temporary tables Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: Waiting for purge to start Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] InnoDB: 5.7.18 started; log sequence number 1744471 Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140380049757952 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140380049757952 [Note] InnoDB: Buffer pool(s) load completed at 170802 23:50:05 Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Plugin 'FEEDBACK' is disabled. Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Recovering after a crash using tc.log Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Starting crash recovery... Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Crash recovery finished. Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Server socket created on IP: '0.0.0.0'. Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [ERROR] mysqld: Table 'user' is marked as crashed and should be repaired Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Warning] Checking table: './mysql/user' Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Reading of all Master_info entries succeded Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] Added new Master_info '' to hash table Aug 2 23:50:05 CentOS-Test mysqld: 2017-08-02 23:50:05 140381194188928 [Note] /usr/sbin/mysqld: ready for connections. Aug 2 23:50:05 CentOS-Test mysqld: Version: '10.2.7-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server Aug 2 23:50:05 CentOS-Test systemd: Started MariaDB database server. Aug 2 23:51:08 CentOS-Test mysqld: 2017-08-02 23:51:08 140380955346688 [Warning] IP address '10.0.10.17' could not be resolved: Name or service not known