2018-01-30 20:06:56 140668793899136 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Uses event mutexes 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Using Linux native AIO 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Number of pools: 1 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Completed initialization of buffer pool 2018-01-30 20:06:56 140663521441536 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-30 20:06:56 140668793899136 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*268435456 bytes; LSN=1619207 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Starting to delete and rewrite log files. 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Setting log file ./ib_logfile101 size to 268435456 bytes 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Setting log file ./ib_logfile1 size to 268435456 bytes 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: New log files created, LSN=1619207 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-30 20:06:57 140668793899136 [Note] InnoDB: 5.7.20 started; log sequence number 1619198 2018-01-30 20:06:57 140662913619712 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-30 20:06:57 140668793899136 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-30 20:06:57 140668793899136 [Note] Server socket created on IP: '::'. 2018-01-30 20:06:57 140662913619712 [Note] InnoDB: Buffer pool(s) load completed at 180130 20:06:57 2018-01-30 20:06:57 140668793899136 [Note] Reading of all Master_info entries succeded 2018-01-30 20:06:57 140668793899136 [Note] Added new Master_info '' to hash table 2018-01-30 20:06:57 140668793899136 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-30 20:07:57 140668232783616 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-30 20:07:57 140668232783616 [Note] Event Scheduler: Purging the queue. 0 events 2018-01-30 20:07:57 140663669749504 [Note] InnoDB: FTS optimize thread exiting. 2018-01-30 20:07:57 140668232783616 [Note] InnoDB: Starting shutdown... 2018-01-30 20:07:57 140662913619712 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-30 20:07:57 140662913619712 [Note] InnoDB: Buffer pool(s) dump completed at 180130 20:07:57 2018-01-30 20:07:58 140668232783616 [Note] InnoDB: Shutdown completed; log sequence number 1619496 2018-01-30 20:07:58 140668232783616 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-30 20:07:58 140668232783616 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-30 20:07:58 139926501722240 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Uses event mutexes 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Using Linux native AIO 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Number of pools: 1 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-30 20:07:58 139926501722240 [Note] InnoDB: Completed initialization of buffer pool 2018-01-30 20:07:58 139921225094912 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: Waiting for purge to start 2018-01-30 20:07:59 139926501722240 [Note] InnoDB: 5.7.20 started; log sequence number 1619496 2018-01-30 20:07:59 139921092237056 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-30 20:07:59 139926501722240 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-30 20:07:59 139921092237056 [Note] InnoDB: Buffer pool(s) load completed at 180130 20:07:59 2018-01-30 20:07:59 139926501722240 [Note] Server socket created on IP: '::'. 2018-01-30 20:07:59 139926501722240 [Note] Reading of all Master_info entries succeded 2018-01-30 20:07:59 139926501722240 [Note] Added new Master_info '' to hash table 2018-01-30 20:07:59 139926501722240 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 180130 23:22:31 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f41c8006e78 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 = 0x7f432d567d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5586c60bac4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x5586c5b45825] /lib64/libpthread.so.0(+0xf5e0)[0x7f432d2f05e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5586c5a9fb50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5586c5a9fc33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x5586c5a03957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x5586c5a0831c] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x5586c59aab88] /usr/sbin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x46a)[0x5586c5c8939a] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2b45)[0x5586c59b6165] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x5586c5c6e4d6] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5586c5c74779] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x5586c5c74d45] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ce)[0x5586c5c7152e] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5df)[0x5586c5c72d2f] /usr/sbin/mysqld(+0x4d2af6)[0x5586c59acaf6] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3eea)[0x5586c59b750a] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x5586c5c6e4d6] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5586c5c74779] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x5586c5c74d45] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ce)[0x5586c5c7152e] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5df)[0x5586c5c72d2f] /usr/sbin/mysqld(+0x4d2af6)[0x5586c59acaf6] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3eea)[0x5586c59b750a] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x5586c59bca5e] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x209f)[0x5586c59bfa6f] /usr/sbin/mysqld(_Z10do_commandP3THD+0x149)[0x5586c59c0669] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x5586c5a83efa] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5586c5a8401d] /lib64/libpthread.so.0(+0x7e25)[0x7f432d2e8e25] /lib64/libc.so.6(clone+0x6d)[0x7f432b8c034d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f41acf73990): Delete from mfg.sourceless_parts where part_no in (select part_no from mfg.part_sources where orderpercent>0) Connection ID (thread ID): 8 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 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. 2018-01-30 23:22:40 139701875742848 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Uses event mutexes 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Using Linux native AIO 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Number of pools: 1 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-30 23:22:40 139701875742848 [Note] InnoDB: Completed initialization of buffer pool 2018-01-30 23:22:40 139696599226112 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-30 23:22:41 139701875742848 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-30 23:22:41 139701875742848 [Note] InnoDB: Starting crash recovery from checkpoint LSN=41925496537 2018-01-30 23:22:44 139701875742848 [Note] InnoDB: Starting final batch to recover 559 pages from redo log. 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: Waiting for purge to start 2018-01-30 23:23:07 139701875742848 [Note] InnoDB: 5.7.20 started; log sequence number 41925496595 2018-01-30 23:23:07 139696326948608 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-30 23:23:07 139701875742848 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-30 23:23:07 139696326948608 [Note] InnoDB: Buffer pool(s) load completed at 180130 23:23:07 2018-01-30 23:23:07 139701875742848 [Note] Recovering after a crash using tc.log 2018-01-30 23:23:07 139701875742848 [Note] Starting crash recovery... 2018-01-30 23:23:07 139701875742848 [Note] Crash recovery finished. 2018-01-30 23:23:08 139701875742848 [Note] Server socket created on IP: '::'. 2018-01-30 23:23:08 139701875742848 [Note] Reading of all Master_info entries succeded 2018-01-30 23:23:08 139701875742848 [Note] Added new Master_info '' to hash table 2018-01-30 23:23:08 139701875742848 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-30 23:29:57 139701874202368 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-30 23:29:57 139701874202368 [Note] Event Scheduler: Purging the queue. 0 events 2018-01-30 23:29:57 139696755926784 [Note] InnoDB: FTS optimize thread exiting. 2018-01-30 23:29:57 139701874202368 [Note] InnoDB: Starting shutdown... 2018-01-30 23:29:57 139696326948608 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-30 23:29:57 139696326948608 [Note] InnoDB: Buffer pool(s) dump completed at 180130 23:29:57 2018-01-30 23:29:59 139701874202368 [Note] InnoDB: Shutdown completed; log sequence number 41925497052 2018-01-30 23:29:59 139701874202368 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-30 23:29:59 139701874202368 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-30 23:29:59 140699795802240 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Uses event mutexes 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Using Linux native AIO 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Number of pools: 1 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Completed initialization of buffer pool 2018-01-30 23:29:59 140694520534784 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-30 23:29:59 140699795802240 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-30 23:30:11 140699795802240 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-30 23:30:11 140699795802240 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-30 23:30:11 140699795802240 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-30 23:30:11 140699795802240 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-30 23:30:11 140699795802240 [Note] InnoDB: Waiting for purge to start 2018-01-30 23:30:11 140699795802240 [Note] InnoDB: 5.7.20 started; log sequence number 41925497052 2018-01-30 23:30:11 140694244607744 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-30 23:30:11 140699795802240 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-30 23:30:11 140699795802240 [Note] Server socket created on IP: '::'. 2018-01-30 23:30:11 140699795802240 [Note] Reading of all Master_info entries succeded 2018-01-30 23:30:11 140699795802240 [Note] Added new Master_info '' to hash table 2018-01-30 23:30:11 140699795802240 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-30 23:30:11 140694244607744 [Note] InnoDB: Buffer pool(s) load completed at 180130 23:30:11 180130 23:35:24 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7ff5d80070d8 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 = 0x7ff73941ad70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x560951fcbc4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x560951a56825] /lib64/libpthread.so.0(+0xf5e0)[0x7ff7391a45e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5609519b0b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5609519b0c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x560951914957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x56095191931c] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x5609518bbb88] /usr/sbin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x46a)[0x560951b9a39a] mysys/stacktrace.c:268(my_print_stacktrace)[0x5609518c7165] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x560951b7f4d6] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x560951b85779] sql/sql_delete.cc:310(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List*, unsigned long long, unsigned long long, select_result*))[0x560951b85d45] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x560951b8252e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x560951b83d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5609518bdaf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5609518c850a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x560951b7f4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x560951b85779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x560951b85d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x560951b8252e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x560951b83d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5609518bdaf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5609518c850a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5609518cda5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5609518d0a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x5609518d1669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x560951994efa] sql/sql_connect.cc:1243(handle_one_connection)[0x56095199501d] /lib64/libpthread.so.0(+0x7e25)[0x7ff73919ce25] /lib64/libc.so.6(clone+0x6d)[0x7ff73777434d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7ff5d9da9bd0): Delete from mfg.sourceless_parts where part_no in (select part_no from mfg.part_sources where orderpercent>0) Connection ID (thread ID): 8 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 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. 2018-01-30 23:35:30 140399455127680 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Uses event mutexes 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Using Linux native AIO 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Number of pools: 1 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Completed initialization of buffer pool 2018-01-30 23:35:30 140394181814016 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-30 23:35:30 140399455127680 [Note] InnoDB: Starting crash recovery from checkpoint LSN=41925770672 2018-01-30 23:35:31 140399455127680 [Note] InnoDB: Ignoring data file './mfg/dieingparts.ibd' with space ID 1337, since the redo log references ./mfg/dieingparts.ibd with space ID 1334. 2018-01-30 23:35:31 140399455127680 [Note] InnoDB: Ignoring data file './mfg/buildlist.ibd' with space ID 1338, since the redo log references ./mfg/buildlist.ibd with space ID 1335. 2018-01-30 23:35:31 140399455127680 [Note] InnoDB: Starting final batch to recover 913 pages from redo log. 2018-01-30 23:35:43 140399455127680 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-30 23:35:43 140399455127680 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-30 23:35:43 140399455127680 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-30 23:35:43 140399455127680 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-30 23:35:43 140399455127680 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-30 23:35:43 140399455127680 [Note] InnoDB: 5.7.20 started; log sequence number 41945316977 2018-01-30 23:35:43 140394120029952 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-30 23:35:43 140399455127680 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-30 23:35:43 140399455127680 [Note] Recovering after a crash using tc.log 2018-01-30 23:35:43 140399455127680 [Note] Starting crash recovery... 2018-01-30 23:35:43 140399455127680 [Note] Crash recovery finished. 2018-01-30 23:35:43 140399455127680 [Note] Server socket created on IP: '::'. 2018-01-30 23:35:43 140394120029952 [Note] InnoDB: Buffer pool(s) load completed at 180130 23:35:43 2018-01-30 23:35:43 140399455127680 [Note] Reading of all Master_info entries succeded 2018-01-30 23:35:43 140399455127680 [Note] Added new Master_info '' to hash table 2018-01-30 23:35:43 140399455127680 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 7:46:49 140399453587200 [Warning] Aborted connection 8 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communication packets) 180131 13:17:07 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fb128000a88 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 = 0x7fb14b8ebd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55eebf53cc4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x55eebefc7825] /lib64/libpthread.so.0(+0xf5e0)[0x7fb14b6745e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x55eebef21b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x55eebef21c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x55eebee85957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x55eebee8a31c] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x55eebee2cb88] /usr/sbin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x46a)[0x55eebf10b39a] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2b45)[0x55eebee38165] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x55eebf0f04d6] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x55eebf0f6779] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x55eebf0f6d45] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ce)[0x55eebf0f352e] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5df)[0x55eebf0f4d2f] /usr/sbin/mysqld(+0x4d2af6)[0x55eebee2eaf6] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3eea)[0x55eebee3950a] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x55eebf0f04d6] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x55eebf0f6779] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x55eebf0f6d45] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ce)[0x55eebf0f352e] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5df)[0x55eebf0f4d2f] /usr/sbin/mysqld(+0x4d2af6)[0x55eebee2eaf6] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3eea)[0x55eebee3950a] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x55eebee3ea5e] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x209f)[0x55eebee41a6f] /usr/sbin/mysqld(_Z10do_commandP3THD+0x149)[0x55eebee42669] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x55eebef05efa] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x55eebef0601d] /lib64/libpthread.so.0(+0x7e25)[0x7fb14b66ce25] /lib64/libc.so.6(clone+0x6d)[0x7fb149c4434d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fb12b7d7550): Delete from mfg.RogueWOs where part_no in (Select Part_no from mfg.MRPRecord where Period= NAME_CONST('mrpper',1) and TQty>0) Connection ID (thread ID): 10 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 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. 2018-01-31 13:17:14 140145743136896 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Uses event mutexes 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Using Linux native AIO 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Number of pools: 1 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-31 13:17:14 140145743136896 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-31 13:17:15 140145743136896 [Note] InnoDB: Completed initialization of buffer pool 2018-01-31 13:17:15 140140469753600 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-31 13:17:15 140145743136896 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-31 13:17:15 140145743136896 [Note] InnoDB: Starting crash recovery from checkpoint LSN=83993378032 2018-01-31 13:17:15 140145743136896 [Note] InnoDB: Starting final batch to recover 1009 pages from redo log. 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: Waiting for purge to start 2018-01-31 13:17:27 140145743136896 [Note] InnoDB: 5.7.20 started; log sequence number 83993576758 2018-01-31 13:17:27 140140328044288 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-31 13:17:27 140145743136896 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-31 13:17:27 140145743136896 [Note] Recovering after a crash using tc.log 2018-01-31 13:17:27 140140328044288 [Note] InnoDB: Buffer pool(s) load completed at 180131 13:17:27 2018-01-31 13:17:27 140145743136896 [Note] Starting crash recovery... 2018-01-31 13:17:27 140145743136896 [Note] Crash recovery finished. 2018-01-31 13:17:27 140145743136896 [Note] Server socket created on IP: '::'. 2018-01-31 13:17:27 140145743136896 [Note] Reading of all Master_info entries succeded 2018-01-31 13:17:27 140145743136896 [Note] Added new Master_info '' to hash table 2018-01-31 13:17:27 140145743136896 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 14:46:19 140145589610240 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-31 14:46:19 140145589610240 [Note] Event Scheduler: Purging the queue. 0 events 2018-01-31 14:46:19 140140622804736 [Note] InnoDB: FTS optimize thread exiting. 2018-01-31 14:46:19 140145589610240 [Note] InnoDB: Starting shutdown... 2018-01-31 14:46:19 140140328044288 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-31 14:46:19 140140328044288 [Note] InnoDB: Buffer pool(s) dump completed at 180131 14:46:19 2018-01-31 14:46:21 140145589610240 [Note] InnoDB: Shutdown completed; log sequence number 83993577799 2018-01-31 14:46:21 140145589610240 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-31 14:46:21 140145589610240 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-31 14:46:21 140664324311168 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Uses event mutexes 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Using Linux native AIO 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Number of pools: 1 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-31 14:46:21 140664324311168 [Note] InnoDB: Completed initialization of buffer pool 2018-01-31 14:46:21 140659051648768 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-31 14:46:22 140664324311168 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-31 14:46:33 140664324311168 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-31 14:46:33 140664324311168 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-31 14:46:33 140664324311168 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-31 14:46:33 140664324311168 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-31 14:46:33 140664324311168 [Note] InnoDB: Waiting for purge to start 2018-01-31 14:46:33 140664324311168 [Note] InnoDB: 5.7.20 started; log sequence number 83993577799 2018-01-31 14:46:33 140658989864704 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-31 14:46:33 140664324311168 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-31 14:46:33 140664324311168 [Note] Server socket created on IP: '::'. 2018-01-31 14:46:33 140664324311168 [Note] Reading of all Master_info entries succeded 2018-01-31 14:46:33 140664324311168 [Note] Added new Master_info '' to hash table 2018-01-31 14:46:33 140664324311168 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 14:46:33 140658989864704 [Note] InnoDB: Buffer pool(s) load completed at 180131 14:46:33 180131 14:53:56 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fed8c006e78 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 = 0x7feef6fdad70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x556cdafcbc4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x556cdaa56825] /lib64/libpthread.so.0(+0xf5e0)[0x7feef6d645e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x556cda9b0b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x556cda9b0c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x556cda914957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x556cda91931c] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x556cda8bbb88] mysys/stacktrace.c:268(my_print_stacktrace)[0x556cda9183fb] sql/signal_handler.cc:168(handle_fatal_signal)[0x556cda91929f] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x556cda91a9a4] sql/sql_lex.cc:3848(st_select_lex::optimize_unflattened_subqueries(bool))[0x556cda91b584] sql/sql_parse.cc:4523(mysql_execute_command(THD*))[0x556cda8cd22b] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556cdab7f4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x556cdab85779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x556cdab85d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556cdab8252e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x556cdab83d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x556cda8bdaf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x556cda8c850a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556cdab7f4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x556cdab85779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x556cdab85d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556cdab8252e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x556cdab83d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x556cda8bdaf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x556cda8c850a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556cdab7f4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x556cdab85779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x556cdab85d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556cdab8252e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x556cdab83d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x556cda8bdaf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x556cda8c850a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556cda8cda5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556cda8d0a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x556cda8d1669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x556cda994efa] sql/sql_connect.cc:1243(handle_one_connection)[0x556cda99501d] /lib64/libpthread.so.0(+0x7e25)[0x7feef6d5ce25] /lib64/libc.so.6(clone+0x6d)[0x7feef533434d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fed8eb54f78): Insert into scratch.Bom(Parent,Part_No,Item,Quantity) select Parent,Part_No,Item,Quantity from eng.eco2Bom where Eco_id= NAME_CONST('econo',51912) and Group_ID= NAME_CONST('EcoGrp',_utf8'C' COLLATE 'utf8_general_ci') and Chng='A' and (part_no in (Select Part_no from eng.partmaster) or Part_no in (Select part_no from scratch.PartiallyReleased)) Connection ID (thread ID): 8 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 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. 2018-01-31 14:54:02 140401401792640 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Uses event mutexes 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Using Linux native AIO 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Number of pools: 1 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-31 14:54:02 140401401792640 [Note] InnoDB: Completed initialization of buffer pool 2018-01-31 14:54:02 140396127971072 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-31 14:54:03 140401401792640 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-31 14:54:03 140401401792640 [Note] InnoDB: Starting crash recovery from checkpoint LSN=84042351313 2018-01-31 14:54:03 140401401792640 [Note] InnoDB: Ignoring data file './scratch/bom.ibd' with space ID 2690, since the redo log references ./scratch/bom.ibd with space ID 2681. 2018-01-31 14:54:03 140401401792640 [Note] InnoDB: Ignoring data file './scratch/bbom.ibd' with space ID 2691, since the redo log references ./scratch/bbom.ibd with space ID 2682. 2018-01-31 14:54:04 140401401792640 [Note] InnoDB: Starting final batch to recover 1373 pages from redo log. 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: Waiting for purge to start 2018-01-31 14:54:16 140401401792640 [Note] InnoDB: 5.7.20 started; log sequence number 84065378699 2018-01-31 14:54:16 140395987179264 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-31 14:54:16 140401401792640 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-31 14:54:16 140401401792640 [Note] Recovering after a crash using tc.log 2018-01-31 14:54:16 140401401792640 [Note] Starting crash recovery... 2018-01-31 14:54:16 140401401792640 [Note] Crash recovery finished. 2018-01-31 14:54:16 140401401792640 [Note] Server socket created on IP: '::'. 2018-01-31 14:54:16 140401401792640 [Note] Reading of all Master_info entries succeded 2018-01-31 14:54:16 140401401792640 [Note] Added new Master_info '' to hash table 2018-01-31 14:54:16 140401401792640 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 14:54:16 140395987179264 [Note] InnoDB: Buffer pool(s) load completed at 180131 14:54:16 2018-01-31 15:22:55 140401207527168 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-31 15:22:55 140401207527168 [Note] Event Scheduler: Purging the queue. 0 events 2018-01-31 15:22:55 140396281022208 [Note] InnoDB: FTS optimize thread exiting. 2018-01-31 15:22:55 140401207527168 [Note] InnoDB: Starting shutdown... 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 0, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 1, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 2, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 3, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 4, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 5, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 6, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Instance 7, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-01-31 15:22:55 140395987179264 [Note] InnoDB: Buffer pool(s) dump completed at 180131 15:22:55 2018-01-31 15:22:56 140401207527168 [Note] InnoDB: Shutdown completed; log sequence number 84367825313 2018-01-31 15:22:56 140401207527168 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-31 15:22:56 140401207527168 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-31 15:22:57 140209014167680 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Uses event mutexes 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Using Linux native AIO 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Number of pools: 1 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Completed initialization of buffer pool 2018-01-31 15:22:57 140203735709440 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-31 15:22:57 140209014167680 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-31 15:23:09 140209014167680 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-31 15:23:09 140209014167680 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-31 15:23:09 140209014167680 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-31 15:23:09 140209014167680 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-31 15:23:09 140209014167680 [Note] InnoDB: Waiting for purge to start 2018-01-31 15:23:09 140209014167680 [Note] InnoDB: 5.7.20 started; log sequence number 84367825313 2018-01-31 15:23:09 140203460241152 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-31 15:23:09 140209014167680 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-31 15:23:09 140209014167680 [Note] Server socket created on IP: '::'. 2018-01-31 15:23:09 140209014167680 [Note] Reading of all Master_info entries succeded 2018-01-31 15:23:09 140209014167680 [Note] Added new Master_info '' to hash table 2018-01-31 15:23:09 140209014167680 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 15:23:42 140203460241152 [Note] InnoDB: Buffer pool(s) load completed at 180131 15:23:42 180131 15:27: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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f83980071a8 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 = 0x7f84f4643d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55b57033ac4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x55b56fdc5825] /lib64/libpthread.so.0(+0xf5e0)[0x7f84f43cd5e0] /usr/sbin/mysqld(_ZN13Explain_queryD1Ev+0x91)[0x55b56fd1f9f1] /usr/sbin/mysqld(_Z20delete_explain_queryP3LEX+0x1d)[0x55b56fd248bd] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0xa6)[0x55b56fef4786] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x55b56fef4d45] mysys/stacktrace.c:268(my_print_stacktrace)[0x55b56fef152e] sql/sql_explain.cc:66(Explain_query::~Explain_query())[0x55b56fef2d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55b56fc2caf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55b56fc3750a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55b56feee4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55b56fef4779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55b56fef4d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55b56fef152e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55b56fef2d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55b56fc2caf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55b56fc3750a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55b56feee4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55b56fef4779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55b56fef4d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55b56fef152e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55b56fef2d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55b56fc2caf6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55b56fc3750a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55b56fc3ca5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b56fc3fa6f] sql/sql_parse.cc:1362(do_command(THD*))[0x55b56fc40669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55b56fd03efa] sql/sql_connect.cc:1243(handle_one_connection)[0x55b56fd0401d] /lib64/libpthread.so.0(+0x7e25)[0x7f84f43c5e25] /lib64/libc.so.6(clone+0x6d)[0x7f84f299d34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f83991734f8): Insert into scratch.Bom(Parent,Part_No,Item,Quantity) select Parent,Part_No,Item,Quantity from eng.eco2Bom where Eco_id= NAME_CONST('econo',51912) and Group_ID= NAME_CONST('EcoGrp',_utf8'C' COLLATE 'utf8_general_ci') and Chng='A' and (part_no in (Select Part_no from eng.partmaster) or Part_no in (Select part_no from scratch.PartiallyReleased)) Connection ID (thread ID): 8 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 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. 2018-01-31 15:28:05 139867313760384 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Uses event mutexes 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Using Linux native AIO 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Number of pools: 1 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Completed initialization of buffer pool 2018-01-31 15:28:05 139862040278784 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Starting crash recovery from checkpoint LSN=84396692028 2018-01-31 15:28:05 139867313760384 [Note] InnoDB: Ignoring data file './scratch/bom.ibd' with space ID 2709, since the redo log references ./scratch/bom.ibd with space ID 2702. 2018-01-31 15:28:06 139867313760384 [Note] InnoDB: Ignoring data file './scratch/bbom.ibd' with space ID 2710, since the redo log references ./scratch/bbom.ibd with space ID 2703. 2018-01-31 15:28:07 139867313760384 [Note] InnoDB: Starting final batch to recover 1313 pages from redo log. 2018-01-31 15:28:18 139867313760384 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-31 15:28:18 139867313760384 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-31 15:28:18 139867313760384 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-31 15:28:18 139867313760384 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-31 15:28:18 139867313760384 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-31 15:28:18 139867313760384 [Note] InnoDB: 5.7.20 started; log sequence number 84419490449 2018-01-31 15:28:18 139861633324800 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-31 15:28:18 139867313760384 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-31 15:28:18 139867313760384 [Note] Recovering after a crash using tc.log 2018-01-31 15:28:18 139867313760384 [Note] Starting crash recovery... 2018-01-31 15:28:18 139867313760384 [Note] Crash recovery finished. 2018-01-31 15:28:18 139867313760384 [Note] Server socket created on IP: '::'. 2018-01-31 15:28:18 139867313760384 [Note] Reading of all Master_info entries succeded 2018-01-31 15:28:18 139867313760384 [Note] Added new Master_info '' to hash table 2018-01-31 15:28:18 139867313760384 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 15:28:43 139861633324800 [Note] InnoDB: Buffer pool(s) load completed at 180131 15:28:43 180131 17:22:32 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f3540000a88 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 = 0x7f356575cd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x564324fd1c4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x564324a5c825] /lib64/libpthread.so.0(+0xf5e0)[0x7f35654e65e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5643249b6b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5643249b6c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x56432491a957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x56432491f31c] /usr/sbin/mysqld(_ZN18st_select_lex_unit8optimizeEv+0x1f7)[0x56432495dbb7] /usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0x128)[0x5643248aac28] /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xe4)[0x5643248aa634] /usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5643248c0247] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x544)[0x56432491cc44] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x56432491f29f] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x5643249209a4] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x564324921584] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x8c0b)[0x5643248d322b] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x564324b854d6] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x564324b8b779] mysys/stacktrace.c:268(my_print_stacktrace)[0x564324b8bd45] sql/sql_explain.cc:122(Explain_query::add_node(Explain_node*))[0x564324b8852e] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x564324b89d2f] sql/sql_derived.cc:917(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0x5643248c3af6] sql/sql_select.cc:373(FIX/mariadb-10.2.12/sql/sql_select.cc:3711)[0x5643248ce50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x564324b854d6] sp_instr_stmt:0(0.2.12/sql/sql_parse.cc:5819)[0x564324b8b779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x564324b8bd45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x564324b8852e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x564324b89d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5643248c3af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5643248ce50a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5643248d3a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5643248d6a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x5643248d7669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x56432499aefa] sql/sql_connect.cc:1243(handle_one_connection)[0x56432499b01d] /lib64/libpthread.so.0(+0x7e25)[0x7f35654dee25] /lib64/libc.so.6(clone+0x6d)[0x7f3563ab634d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f3542b98840): Insert into eng.TmpEcoParts(part_no) Select distinct part_no from (Select part_no from eng.eco2parts Join projects.projectheader on eco_id=ProjectNo where Priority=100 union select part_no from eng.eco2bom Join projects.projectheader on eco_id=ProjectNo where Priority=100 and Chng<>'D') as list1 Connection ID (thread ID): 8 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 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. 2018-01-31 17:22:39 140680554956928 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Uses event mutexes 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Using Linux native AIO 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Number of pools: 1 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-01-31 17:22:39 140680554956928 [Note] InnoDB: Completed initialization of buffer pool 2018-01-31 17:22:39 140675279492864 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-31 17:22:40 140680554956928 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-31 17:22:40 140680554956928 [Note] InnoDB: Starting crash recovery from checkpoint LSN=86688386727 2018-01-31 17:22:40 140680554956928 [Note] InnoDB: Starting final batch to recover 4 pages from redo log. 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: Waiting for purge to start 2018-01-31 17:22:52 140680554956928 [Note] InnoDB: 5.7.20 started; log sequence number 86688386809 2018-01-31 17:22:52 140675219826432 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-31 17:22:52 140680554956928 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-31 17:22:52 140680554956928 [Note] Recovering after a crash using tc.log 2018-01-31 17:22:52 140680554956928 [Note] Starting crash recovery... 2018-01-31 17:22:52 140680554956928 [Note] Crash recovery finished. 2018-01-31 17:22:52 140680554956928 [Note] Server socket created on IP: '::'. 2018-01-31 17:22:52 140680554956928 [Note] Reading of all Master_info entries succeded 2018-01-31 17:22:52 140680554956928 [Note] Added new Master_info '' to hash table 2018-01-31 17:22:52 140680554956928 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-31 17:23:15 140675219826432 [Note] InnoDB: Buffer pool(s) load completed at 180131 17:23:15 2018-02-01 12:40:42 140680379188992 [Warning] IP address '10.0.2.2' could not be resolved: Name or service not known 2018-02-01 12:40:42 140680379188992 [Warning] Access denied for user 'root'@'10.0.2.2' (using password: NO) 2018-02-01 12:40:44 140680379188992 [Warning] Access denied for user 'root'@'10.0.2.2' (using password: NO) 2018-02-01 12:40:47 140680379188992 [Warning] Access denied for user 'root'@'10.0.2.2' (using password: NO) 2018-02-01 12:44:22 140680044209920 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-01 12:44:22 140680044209920 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-01 12:44:22 140675436193536 [Note] InnoDB: FTS optimize thread exiting. 2018-02-01 12:44:23 140680044209920 [Note] InnoDB: Starting shutdown... 2018-02-01 12:44:23 140675219826432 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-01 12:44:23 140675219826432 [Note] InnoDB: Buffer pool(s) dump completed at 180201 12:44:23 2018-02-01 12:44:24 140680044209920 [Note] InnoDB: Shutdown completed; log sequence number 86688387052 2018-02-01 12:44:24 140680044209920 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-01 12:44:25 140680044209920 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-01 12:44:25 140445608388736 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Uses event mutexes 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Using Linux native AIO 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Number of pools: 1 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Completed initialization of buffer pool 2018-02-01 12:44:25 140440335009536 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-01 12:44:25 140445608388736 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-01 12:44:36 140445608388736 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-01 12:44:36 140445608388736 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-01 12:44:36 140445608388736 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-01 12:44:36 140445608388736 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-01 12:44:36 140445608388736 [Note] InnoDB: Waiting for purge to start 2018-02-01 12:44:36 140445608388736 [Note] InnoDB: 5.7.20 started; log sequence number 86688387052 2018-02-01 12:44:36 140440273225472 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-01 12:44:36 140445608388736 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-01 12:44:36 140445608388736 [Note] Server socket created on IP: '::'. 2018-02-01 12:44:37 140445608388736 [Note] Reading of all Master_info entries succeded 2018-02-01 12:44:37 140445608388736 [Note] Added new Master_info '' to hash table 2018-02-01 12:44:37 140445608388736 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-01 12:45:02 140440273225472 [Note] InnoDB: Buffer pool(s) load completed at 180201 12:45:02 2018-02-01 16:15:31 140445096077056 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-01 16:15:31 140445096077056 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-01 16:15:31 140440479667968 [Note] InnoDB: FTS optimize thread exiting. 2018-02-01 16:15:31 140445096077056 [Note] InnoDB: Starting shutdown... 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 0, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 1, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 2, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 3, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 4, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 5, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 6, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Instance 7, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 16:15:31 140440273225472 [Note] InnoDB: Buffer pool(s) dump completed at 180201 16:15:31 2018-02-01 16:15:33 140445096077056 [Note] InnoDB: Shutdown completed; log sequence number 86740683389 2018-02-01 16:15:33 140445096077056 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-01 16:15:33 140445096077056 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-01 16:15:33 139949062330496 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Uses event mutexes 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Using Linux native AIO 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Number of pools: 1 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Completed initialization of buffer pool 2018-02-01 16:15:33 139943778916096 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-01 16:15:33 139949062330496 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-01 16:15:44 139949062330496 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-01 16:15:44 139949062330496 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-01 16:15:44 139949062330496 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-01 16:15:44 139949062330496 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-01 16:15:44 139949062330496 [Note] InnoDB: Waiting for purge to start 2018-02-01 16:15:44 139949062330496 [Note] InnoDB: 5.7.20 started; log sequence number 86740683389 2018-02-01 16:15:44 139943640815360 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-01 16:15:44 139949062330496 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-01 16:15:44 139949062330496 [Note] Server socket created on IP: '::'. 2018-02-01 16:15:44 139949062330496 [Note] Reading of all Master_info entries succeded 2018-02-01 16:15:44 139949062330496 [Note] Added new Master_info '' to hash table 2018-02-01 16:15:44 139949062330496 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-01 16:16:10 139943640815360 [Note] InnoDB: Buffer pool(s) load completed at 180201 16:16:10 2018-02-01 16:18:03 139949060785920 [Warning] Access denied for user 'root'@'localhost' (using password: YES) 180201 18:11:06 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=3 max_threads=5002 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f4704006e78 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 = 0x7f486e0dfd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5605dc5a7c4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x5605dc032825] /lib64/libpthread.so.0(+0xf5e0)[0x7f486de695e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5605dbf8cb50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5605dbf8cc33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x5605dbef0957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x5605dbef531c] /usr/sbin/mysqld(_ZN18st_select_lex_unit8optimizeEv+0x1f7)[0x5605dbf33bb7] /usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0x128)[0x5605dbe80c28] /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xe4)[0x5605dbe80634] /usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5605dbe96247] mysys/stacktrace.c:268(my_print_stacktrace)[0x5605dbef2c44] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x5605dbef529f] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x5605dbef69a4] sql/sql_derived.cc:917(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0x5605dbef7584] sql/sql_select.cc:373(FIX/mariadb-10.2.12/sql/sql_select.cc:3711)[0x5605dbea922b] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5605dc15b4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5605dc161779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5605dc161d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5605dc15e52e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5605dc15fd2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5605dbe99af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5605dbea450a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5605dc15b4d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5605dc161779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5605dc161d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5605dc15e52e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5605dc15fd2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5605dbe99af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5605dbea450a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5605dbea9a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5605dbeaca6f] sql/sql_parse.cc:1362(do_command(THD*))[0x5605dbead669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x5605dbf70efa] sql/sql_connect.cc:1243(handle_one_connection)[0x5605dbf7101d] /lib64/libpthread.so.0(+0x7e25)[0x7f486de61e25] /lib64/libc.so.6(clone+0x6d)[0x7f486c43934d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f4706ba82d0): Insert into eng.TmpEcoParts(part_no) Select distinct part_no from (Select part_no from eng.eco2parts Join projects.projectheader on eco_id=ProjectNo where Priority=100 union select part_no from eng.eco2bom Join projects.projectheader on eco_id=ProjectNo where Priority=100 and Chng<>'D') as list1 Connection ID (thread ID): 9 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 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. 2018-02-01 18:11:12 140322220464256 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Uses event mutexes 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Using Linux native AIO 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Number of pools: 1 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-01 18:11:12 140322220464256 [Note] InnoDB: Completed initialization of buffer pool 2018-02-01 18:11:12 140316944713472 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-01 18:11:13 140322220464256 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-01 18:11:13 140322220464256 [Note] InnoDB: Starting crash recovery from checkpoint LSN=89009417069 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: Waiting for purge to start 2018-02-01 18:11:24 140322220464256 [Note] InnoDB: 5.7.20 started; log sequence number 89009417299 2018-02-01 18:11:24 140316807112448 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-01 18:11:24 140322220464256 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-01 18:11:24 140322220464256 [Note] Recovering after a crash using tc.log 2018-02-01 18:11:24 140322220464256 [Note] Starting crash recovery... 2018-02-01 18:11:24 140322220464256 [Note] Crash recovery finished. 2018-02-01 18:11:24 140322220464256 [Note] Server socket created on IP: '::'. 2018-02-01 18:11:24 140322220464256 [Note] Reading of all Master_info entries succeded 2018-02-01 18:11:24 140322220464256 [Note] Added new Master_info '' to hash table 2018-02-01 18:11:24 140322220464256 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-01 18:11:48 140316807112448 [Note] InnoDB: Buffer pool(s) load completed at 180201 18:11:48 2018-02-01 19:41:23 140321683191552 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-01 19:41:23 140321683191552 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-01 19:41:23 140317101414144 [Note] InnoDB: FTS optimize thread exiting. 2018-02-01 19:41:23 140321683191552 [Note] InnoDB: Starting shutdown... 2018-02-01 19:41:23 140316807112448 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-01 19:41:24 140316807112448 [Note] InnoDB: Buffer pool(s) dump completed at 180201 19:41:24 2018-02-01 19:41:25 140321683191552 [Note] InnoDB: Shutdown completed; log sequence number 89009417327 2018-02-01 19:41:25 140321683191552 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-01 19:41:25 140321683191552 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-01 19:41:34 140099808331904 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Uses event mutexes 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Using Linux native AIO 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Number of pools: 1 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-01 19:41:34 140099808331904 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-01 19:41:35 140099808331904 [Note] InnoDB: Completed initialization of buffer pool 2018-02-01 19:41:35 140094531884800 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-01 19:41:35 140099808331904 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-01 19:41:45 140099808331904 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-01 19:41:45 140099808331904 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-01 19:41:45 140099808331904 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-01 19:41:45 140099808331904 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-01 19:41:45 140099808331904 [Note] InnoDB: Waiting for purge to start 2018-02-01 19:41:45 140099808331904 [Note] InnoDB: 5.7.20 started; log sequence number 89009417327 2018-02-01 19:41:45 140094472218368 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-01 19:41:45 140099808331904 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-01 19:41:45 140099808331904 [Note] Server socket created on IP: '::'. 2018-02-01 19:41:46 140099808331904 [Note] Reading of all Master_info entries succeded 2018-02-01 19:41:46 140099808331904 [Note] Added new Master_info '' to hash table 2018-02-01 19:41:46 140099808331904 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-01 19:41:53 140099806787328 [Warning] Access denied for user 'root'@'localhost' (using password: YES) 2018-02-01 19:42:10 140094472218368 [Note] InnoDB: Buffer pool(s) load completed at 180201 19:42:10 2018-02-01 23:29:54 140099806787328 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-01 23:29:54 140099806787328 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-01 23:29:54 140094676543232 [Note] InnoDB: FTS optimize thread exiting. 2018-02-01 23:29:54 140099806787328 [Note] InnoDB: Starting shutdown... 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Instance 0, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Instance 1, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Instance 4, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Instance 5, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Instance 7, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-01 23:29:54 140094472218368 [Note] InnoDB: Buffer pool(s) dump completed at 180201 23:29:54 2018-02-01 23:29:56 140099806787328 [Note] InnoDB: Shutdown completed; log sequence number 89033485066 2018-02-01 23:29:56 140099806787328 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-01 23:29:56 140099806787328 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-01 23:39:23 139839595616384 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Uses event mutexes 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Using Linux native AIO 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Number of pools: 1 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Completed initialization of buffer pool 2018-02-01 23:39:23 139834319116032 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-01 23:39:23 139839595616384 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-01 23:39:34 139839595616384 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-01 23:39:34 139839595616384 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-01 23:39:34 139839595616384 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-01 23:39:34 139839595616384 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-01 23:39:34 139839595616384 [Note] InnoDB: Waiting for purge to start 2018-02-01 23:39:34 139839595616384 [Note] InnoDB: 5.7.20 started; log sequence number 89033485066 2018-02-01 23:39:34 139834186258176 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-01 23:39:34 139839595616384 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-01 23:39:34 139839595616384 [Note] Server socket created on IP: '::'. 2018-02-01 23:39:34 139839595616384 [Note] Reading of all Master_info entries succeded 2018-02-01 23:39:34 139839595616384 [Note] Added new Master_info '' to hash table 2018-02-01 23:39:34 139839595616384 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-01 23:39:59 139834186258176 [Note] InnoDB: Buffer pool(s) load completed at 180201 23:39:59 180201 23:45:22 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f2d80006db8 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 = 0x7f2ef1547d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x558151a9fc4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x55815152a825] /lib64/libpthread.so.0(+0xf5e0)[0x7f2ef12d15e0] /usr/sbin/mysqld(_ZN13Explain_queryD1Ev+0x91)[0x5581514849f1] /usr/sbin/mysqld(_Z20delete_explain_queryP3LEX+0x1d)[0x5581514898bd] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0xa6)[0x558151659786] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x558151659d45] mysys/stacktrace.c:268(my_print_stacktrace)[0x55815165652e] sql/signal_handler.cc:168(handle_fatal_signal)[0x558151657d2f] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x558151391af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55815139c50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5581516534d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x558151659779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x558151659d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55815165652e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x558151657d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x558151391af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55815139c50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5581516534d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x558151659779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x558151659d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55815165652e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x558151657d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x558151391af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55815139c50a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5581513a1a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5581513a4a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x5581513a5669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x558151468efa] sql/sql_connect.cc:1243(handle_one_connection)[0x55815146901d] /lib64/libpthread.so.0(+0x7e25)[0x7f2ef12c9e25] /lib64/libc.so.6(clone+0x6d)[0x7f2eef8a134d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f2d811843d8): Insert into scratch.Bom(Parent,Part_No,Item,Quantity) select Parent,Part_No,Item,Quantity from eng.eco2Bom where Eco_id= NAME_CONST('econo',51912) and Group_ID= NAME_CONST('EcoGrp',_utf8'C' COLLATE 'utf8_general_ci') and Chng='A' and (part_no in (Select Part_no from eng.partmaster) or Part_no in (Select part_no from scratch.PartiallyReleased)) Connection ID (thread ID): 8 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 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. 2018-02-01 23:45:28 140070745368704 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Uses event mutexes 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Using Linux native AIO 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Number of pools: 1 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Completed initialization of buffer pool 2018-02-01 23:45:28 140065470097152 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Starting crash recovery from checkpoint LSN=89062307796 2018-02-01 23:45:28 140070745368704 [Note] InnoDB: Ignoring data file './scratch/bom.ibd' with space ID 2765, since the redo log references ./scratch/bom.ibd with space ID 2741. 2018-02-01 23:45:29 140070745368704 [Note] InnoDB: Ignoring data file './scratch/bbom.ibd' with space ID 2766, since the redo log references ./scratch/bbom.ibd with space ID 2742. 2018-02-01 23:45:29 140070745368704 [Note] InnoDB: Starting final batch to recover 1318 pages from redo log. 2018-02-01 23:45:41 140070745368704 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-01 23:45:41 140070745368704 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-01 23:45:41 140070745368704 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-01 23:45:41 140070745368704 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-01 23:45:41 140070745368704 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-01 23:45:41 140070745368704 [Note] InnoDB: 5.7.20 started; log sequence number 89085146931 2018-02-01 23:45:41 140065402038016 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-01 23:45:41 140070745368704 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-01 23:45:41 140070745368704 [Note] Recovering after a crash using tc.log 2018-02-01 23:45:41 140070745368704 [Note] Starting crash recovery... 2018-02-01 23:45:41 140070745368704 [Note] Crash recovery finished. 2018-02-01 23:45:41 140070745368704 [Note] Server socket created on IP: '::'. 2018-02-01 23:45:41 140070745368704 [Note] Reading of all Master_info entries succeded 2018-02-01 23:45:41 140070745368704 [Note] Added new Master_info '' to hash table 2018-02-01 23:45:41 140070745368704 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-01 23:46:06 140065402038016 [Note] InnoDB: Buffer pool(s) load completed at 180201 23:46:06 180202 1:00:37 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f6378000a88 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 = 0x7f64c2edcd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5645b29e3c4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x5645b246e825] /lib64/libpthread.so.0(+0xf5e0)[0x7f64c2c665e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5645b23c8b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5645b23c8c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x5645b232c957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x5645b233131c] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x5645b22d3b88] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1cfb)[0x5645b23303fb] mysys/stacktrace.c:268(my_print_stacktrace)[0x5645b233129f] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x5645b23329a4] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x5645b2333584] sql/sql_select.cc:373(sql/sql_select.cc:3711)[0x5645b22e522b] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5645b25974d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5645b259d779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5645b259dd45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5645b259a52e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5645b259bd2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5645b22d5af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5645b22e050a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5645b25974d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5645b259d779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5645b259dd45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5645b259a52e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5645b259bd2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5645b22d5af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5645b22e050a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5645b25974d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5645b259d779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5645b259dd45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5645b259a52e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5645b259bd2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x5645b22d5af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x5645b22e050a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5645b22e5a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5645b22e8a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x5645b22e9669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x5645b23acefa] sql/sql_connect.cc:1243(handle_one_connection)[0x5645b23ad01d] /lib64/libpthread.so.0(+0x7e25)[0x7f64c2c5ee25] /lib64/libc.so.6(clone+0x6d)[0x7f64c123634d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f6379131588): Insert into scratch.Bom(Parent,Part_No,Item,Quantity) select Parent,Part_No,Item,Quantity from eng.eco2Bom where Eco_id= NAME_CONST('econo',51912) and Group_ID= NAME_CONST('EcoGrp',_utf8'C' COLLATE 'utf8_general_ci') and Chng='A' and (part_no in (Select Part_no from eng.partmaster) or Part_no in (Select part_no from scratch.PartiallyReleased)) Connection ID (thread ID): 10 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 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. 2018-02-02 1:00:43 140342488381568 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Uses event mutexes 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Using Linux native AIO 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Number of pools: 1 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 1:00:43 140337211590400 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 1:00:43 140342488381568 [Note] InnoDB: Starting crash recovery from checkpoint LSN=89114742518 2018-02-02 1:00:44 140342488381568 [Note] InnoDB: Ignoring data file './scratch/bom.ibd' with space ID 2771, since the redo log references ./scratch/bom.ibd with space ID 2765. 2018-02-02 1:00:44 140342488381568 [Note] InnoDB: Ignoring data file './scratch/bbom.ibd' with space ID 2772, since the redo log references ./scratch/bbom.ibd with space ID 2766. 2018-02-02 1:00:45 140342488381568 [Note] InnoDB: Starting final batch to recover 1214 pages from redo log. 2018-02-02 1:00:57 140342488381568 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 1:00:57 140342488381568 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 1:00:57 140342488381568 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 1:00:57 140342488381568 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 1:00:57 140342488381568 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 1:00:58 140342488381568 [Note] InnoDB: 5.7.20 started; log sequence number 89137480518 2018-02-02 1:00:58 140337073989376 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 1:00:58 140342488381568 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 1:00:58 140342488381568 [Note] Recovering after a crash using tc.log 2018-02-02 1:00:58 140342488381568 [Note] Starting crash recovery... 2018-02-02 1:00:58 140342488381568 [Note] Crash recovery finished. 2018-02-02 1:00:58 140342488381568 [Note] Server socket created on IP: '::'. 2018-02-02 1:00:58 140342488381568 [Note] Reading of all Master_info entries succeded 2018-02-02 1:00:58 140342488381568 [Note] Added new Master_info '' to hash table 2018-02-02 1:00:58 140342488381568 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 1:01:23 140337073989376 [Note] InnoDB: Buffer pool(s) load completed at 180202 1:01:23 180202 13:00:05 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=3 max_threads=5002 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fa2c0000a88 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 = 0x7fa408131d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x563470772c4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x5634701fd825] /lib64/libpthread.so.0(+0xf5e0)[0x7fa407ebb5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x563470157b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x563470157c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x5634700bb957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x5634700c031c] /usr/sbin/mysqld(_ZN18st_select_lex_unit8optimizeEv+0x1f7)[0x5634700febb7] /usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0x128)[0x56347004bc28] /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xe4)[0x56347004b634] /usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x563470061247] mysys/stacktrace.c:268(my_print_stacktrace)[0x5634700bdc44] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x5634700c029f] sql/sql_union.cc:919(st_select_lex_unit::optimize())[0x5634700c19a4] sql/sql_lex.cc:3907(st_select_lex::handle_derived(LEX*, unsigned int))[0x5634700c2584] sql/sql_parse.cc:4523(mysql_execute_command(THD*))[0x56347007422b] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5634703264d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56347032c779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x56347032cd45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x56347032952e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x56347032ad2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x563470064af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x56347006f50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5634703264d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56347032c779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x56347032cd45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x56347032952e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x56347032ad2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x563470064af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x56347006f50a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563470074a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563470077a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x563470078669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x56347013befa] sql/sql_connect.cc:1243(handle_one_connection)[0x56347013c01d] /lib64/libpthread.so.0(+0x7e25)[0x7fa407eb3e25] /lib64/libc.so.6(clone+0x6d)[0x7fa40648b34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fa2c2ba87c0): Insert into eng.TmpEcoParts(part_no) Select distinct part_no from (Select part_no from eng.eco2parts Join projects.projectheader on eco_id=ProjectNo where Priority=100 union select part_no from eng.eco2bom Join projects.projectheader on eco_id=ProjectNo where Priority=100 and Chng<>'D') as list1 Connection ID (thread ID): 8 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 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. 2018-02-02 13:00:12 140337680672896 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Uses event mutexes 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Using Linux native AIO 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Number of pools: 1 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 13:00:12 140332406306560 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 13:00:12 140337680672896 [Note] InnoDB: Starting crash recovery from checkpoint LSN=91406118108 2018-02-02 13:00:13 140337680672896 [Note] InnoDB: Starting final batch to recover 4 pages from redo log. 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: Waiting for purge to start 2018-02-02 13:00:24 140337680672896 [Note] InnoDB: 5.7.20 started; log sequence number 91406118220 2018-02-02 13:00:24 140331999352576 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 13:00:24 140337680672896 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 13:00:24 140337680672896 [Note] Recovering after a crash using tc.log 2018-02-02 13:00:24 140337680672896 [Note] Starting crash recovery... 2018-02-02 13:00:24 140337680672896 [Note] Crash recovery finished. 2018-02-02 13:00:24 140337680672896 [Note] Server socket created on IP: '::'. 2018-02-02 13:00:24 140337680672896 [Note] Reading of all Master_info entries succeded 2018-02-02 13:00:24 140337680672896 [Note] Added new Master_info '' to hash table 2018-02-02 13:00:24 140337680672896 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 13:00:49 140331999352576 [Note] InnoDB: Buffer pool(s) load completed at 180202 13:00:49 2018-02-02 13:08:48 140337117230848 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-02 13:08:48 140337117230848 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-02 13:08:48 140332563007232 [Note] InnoDB: FTS optimize thread exiting. 2018-02-02 13:08:48 140337117230848 [Note] InnoDB: Starting shutdown... 2018-02-02 13:08:48 140331999352576 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-02 13:08:48 140331999352576 [Note] InnoDB: Instance 4, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:08:48 140331999352576 [Note] InnoDB: Buffer pool(s) dump completed at 180202 13:08:48 2018-02-02 13:08:49 140337117230848 [Note] InnoDB: Shutdown completed; log sequence number 91406118479 2018-02-02 13:08:49 140337117230848 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 13:08:49 140337117230848 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-02 13:08:49 139837980686464 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Uses event mutexes 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Using Linux native AIO 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Number of pools: 1 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 13:08:50 139832708503296 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 13:08:50 139837980686464 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 13:09:01 139837980686464 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 13:09:01 139837980686464 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 13:09:01 139837980686464 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 13:09:01 139837980686464 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 13:09:01 139837980686464 [Note] InnoDB: Waiting for purge to start 2018-02-02 13:09:01 139837980686464 [Note] InnoDB: 5.7.20 started; log sequence number 91406118479 2018-02-02 13:09:01 139832575645440 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 13:09:01 139837980686464 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 13:09:01 139837980686464 [Note] Server socket created on IP: '::'. 2018-02-02 13:09:01 139837980686464 [Note] Reading of all Master_info entries succeded 2018-02-02 13:09:01 139837980686464 [Note] Added new Master_info '' to hash table 2018-02-02 13:09:01 139837980686464 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 13:09:26 139832575645440 [Note] InnoDB: Buffer pool(s) load completed at 180202 13:09:26 2018-02-02 13:15:08 139832827680512 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-02 13:15:08 139832827680512 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-02 13:15:08 139832853161728 [Note] InnoDB: FTS optimize thread exiting. 2018-02-02 13:15:08 139832827680512 [Note] InnoDB: Starting shutdown... 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 0, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 1, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 2, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 3, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 4, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 5, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 6, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Instance 7, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 13:15:08 139832575645440 [Note] InnoDB: Buffer pool(s) dump completed at 180202 13:15:08 2018-02-02 13:15:10 139832827680512 [Note] InnoDB: Shutdown completed; log sequence number 91406445302 2018-02-02 13:15:10 139832827680512 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 13:15:11 139832827680512 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-02 13:15:19 139978886969472 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Uses event mutexes 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Using Linux native AIO 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Number of pools: 1 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 13:15:19 139973610563328 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 13:15:19 139978886969472 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 13:15:30 139978886969472 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 13:15:30 139978886969472 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 13:15:30 139978886969472 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 13:15:30 139978886969472 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 13:15:30 139978886969472 [Note] InnoDB: Waiting for purge to start 2018-02-02 13:15:30 139978886969472 [Note] InnoDB: 5.7.20 started; log sequence number 91406445302 2018-02-02 13:15:30 139973469771520 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 13:15:30 139978886969472 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 13:15:30 139978886969472 [Note] Server socket created on IP: '::'. 2018-02-02 13:15:30 139978886969472 [Note] Reading of all Master_info entries succeded 2018-02-02 13:15:30 139978886969472 [Note] Added new Master_info '' to hash table 2018-02-02 13:15:30 139978886969472 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 13:15:58 139973469771520 [Note] InnoDB: Buffer pool(s) load completed at 180202 13:15:58 180202 13:20:03 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=5002 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f4e04007038 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 = 0x7f4f5fbddd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55dfc25efc4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x55dfc207a825] /lib64/libpthread.so.0(+0xf5e0)[0x7f4f5f9675e0] /usr/sbin/mysqld(_ZN13Explain_queryD1Ev+0x91)[0x55dfc1fd49f1] /usr/sbin/mysqld(_Z20delete_explain_queryP3LEX+0x1d)[0x55dfc1fd98bd] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0xa6)[0x55dfc21a9786] /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x55dfc21a9d45] mysys/stacktrace.c:268(my_print_stacktrace)[0x55dfc21a652e] sql/sql_explain.cc:66(Explain_query::~Explain_query())[0x55dfc21a7d2f] sql/sp_head.cc:3065(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55dfc1ee1af6] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55dfc1eec50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55dfc21a34d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55dfc21a9779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55dfc21a9d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55dfc21a652e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55dfc21a7d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55dfc1ee1af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55dfc1eec50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55dfc21a34d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55dfc21a9779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55dfc21a9d45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55dfc21a652e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55dfc21a7d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55dfc1ee1af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55dfc1eec50a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55dfc1ef1a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55dfc1ef4a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x55dfc1ef5669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55dfc1fb8efa] sql/sql_connect.cc:1243(handle_one_connection)[0x55dfc1fb901d] /lib64/libpthread.so.0(+0x7e25)[0x7f4f5f95fe25] /lib64/libc.so.6(clone+0x6d)[0x7f4f5df3734d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f4e05181908): Insert into scratch.Bom(Parent,Part_No,Item,Quantity) select Parent,Part_No,Item,Quantity from eng.eco2Bom where Eco_id= NAME_CONST('econo',51912) and Group_ID= NAME_CONST('EcoGrp',_utf8'C' COLLATE 'utf8_general_ci') and Chng='A' and (part_no in (Select Part_no from eng.partmaster) or Part_no in (Select part_no from scratch.PartiallyReleased)) Connection ID (thread ID): 8 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 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. 2018-02-02 13:20:09 140032982345856 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Uses event mutexes 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Using Linux native AIO 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Number of pools: 1 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 13:20:09 140027705509632 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Starting crash recovery from checkpoint LSN=91435082436 2018-02-02 13:20:09 140032982345856 [Note] InnoDB: Ignoring data file './scratch/bom.ibd' with space ID 2798, since the redo log references ./scratch/bom.ibd with space ID 2777. 2018-02-02 13:20:10 140032982345856 [Note] InnoDB: Ignoring data file './scratch/bbom.ibd' with space ID 2799, since the redo log references ./scratch/bbom.ibd with space ID 2778. 2018-02-02 13:20:11 140032982345856 [Note] InnoDB: Starting final batch to recover 1324 pages from redo log. 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: Waiting for purge to start 2018-02-02 13:20:22 140032982345856 [Note] InnoDB: 5.7.20 started; log sequence number 91458109565 2018-02-02 13:20:22 140027567908608 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 13:20:22 140032982345856 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 13:20:22 140032982345856 [Note] Recovering after a crash using tc.log 2018-02-02 13:20:22 140032982345856 [Note] Starting crash recovery... 2018-02-02 13:20:22 140032982345856 [Note] Crash recovery finished. 2018-02-02 13:20:22 140032982345856 [Note] Server socket created on IP: '::'. 2018-02-02 13:20:23 140032982345856 [Note] Reading of all Master_info entries succeded 2018-02-02 13:20:23 140032982345856 [Note] Added new Master_info '' to hash table 2018-02-02 13:20:23 140032982345856 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 13:20:51 140027567908608 [Note] InnoDB: Buffer pool(s) load completed at 180202 13:20:51 2018-02-02 16:47:42 140032779708160 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-02-02 16:47:42 140032779708160 [Note] Event Scheduler: Purging the queue. 0 events 2018-02-02 16:47:42 140027862210304 [Note] InnoDB: FTS optimize thread exiting. 2018-02-02 16:47:42 140032779708160 [Note] InnoDB: Starting shutdown... 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 0, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 1, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 2, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 3, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 4, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 5, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 6, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Instance 7, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2018-02-02 16:47:42 140027567908608 [Note] InnoDB: Buffer pool(s) dump completed at 180202 16:47:42 2018-02-02 16:47:44 140032779708160 [Note] InnoDB: Shutdown completed; log sequence number 91458110997 2018-02-02 16:47:44 140032779708160 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 16:47:44 140032779708160 [Note] /usr/sbin/mysqld: Shutdown complete 2018-02-02 16:47:50 140334901692544 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Uses event mutexes 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Using Linux native AIO 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Number of pools: 1 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 16:47:50 140329623086848 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 16:47:50 140334901692544 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 16:48:01 140334901692544 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 16:48:01 140334901692544 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 16:48:01 140334901692544 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 16:48:01 140334901692544 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 16:48:01 140334901692544 [Note] InnoDB: Waiting for purge to start 2018-02-02 16:48:01 140334901692544 [Note] InnoDB: 5.7.20 started; log sequence number 91458110997 2018-02-02 16:48:01 140329555027712 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 16:48:01 140334901692544 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 16:48:02 140334901692544 [Note] Server socket created on IP: '::'. 2018-02-02 16:48:02 140334901692544 [Note] Reading of all Master_info entries succeded 2018-02-02 16:48:02 140334901692544 [Note] Added new Master_info '' to hash table 2018-02-02 16:48:02 140334901692544 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 16:48:45 140329555027712 [Note] InnoDB: Buffer pool(s) load completed at 180202 16:48:45 180202 18:45:40 [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.2.12-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=3 max_threads=5002 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11122164 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fa0e0000d08 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 = 0x7fa243df6d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55d4fb4c0c4e] /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x55d4faf4b825] /lib64/libpthread.so.0(+0xf5e0)[0x7fa243b805e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x55d4faea5b50] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x55d4faea5c33] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x55d4fae09957] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x55d4fae0e31c] /usr/sbin/mysqld(_ZN18st_select_lex_unit8optimizeEv+0x1f7)[0x55d4fae4cbb7] /usr/sbin/mysqld(_Z22mysql_derived_optimizeP3THDP3LEXP10TABLE_LIST+0x128)[0x55d4fad99c28] mysys/stacktrace.c:268(my_print_stacktrace)[0x55d4fad99634] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x55d4fadaf247] sql/sql_select.cc:24890(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x55d4fae0bc44] sql/sql_union.cc:919(st_select_lex_unit::optimize())[0x55d4fae0e29f] sql/sql_select.cc:1361(JOIN::optimize_inner())[0x55d4fae0f9a4] sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55d4fae10584] sql/sql_parse.cc:4523(mysql_execute_command(THD*))[0x55d4fadc222b] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55d4fb0744d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55d4fb07a779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55d4fb07ad45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55d4fb07752e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55d4fb078d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55d4fadb2af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55d4fadbd50a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55d4fb0744d6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55d4fb07a779] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55d4fb07ad45] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55d4fb07752e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55d4fb078d2f] sql/sql_parse.cc:2888(do_execute_sp(THD*, sp_head*))[0x55d4fadb2af6] sql/sql_parse.cc:5819(mysql_execute_command(THD*))[0x55d4fadbd50a] sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d4fadc2a5e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d4fadc5a6f] sql/sql_parse.cc:1362(do_command(THD*))[0x55d4fadc6669] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55d4fae89efa] sql/sql_connect.cc:1243(handle_one_connection)[0x55d4fae8a01d] /lib64/libpthread.so.0(+0x7e25)[0x7fa243b78e25] /lib64/libc.so.6(clone+0x6d)[0x7fa24215034d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fa0e2ba0ea0): Insert into eng.TmpEcoParts(part_no) Select distinct part_no from (Select part_no from eng.eco2parts Join projects.projectheader on eco_id=ProjectNo where Priority=100 union select part_no from eng.eco2bom Join projects.projectheader on eco_id=ProjectNo where Priority=100 and Chng<>'D') as list1 Connection ID (thread ID): 8 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 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 at /var/lib/mysql/ 2018-02-02 18:46:32 140144869664896 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Uses event mutexes 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Using Linux native AIO 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Number of pools: 1 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Using SSE2 crc32 instructions 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2018-02-02 18:46:32 140144869664896 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02 18:46:32 140139597338368 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02 18:46:33 140144869664896 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02 18:46:33 140144869664896 [Note] InnoDB: Starting crash recovery from checkpoint LSN=93726687089 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: Waiting for purge to start 2018-02-02 18:46:50 140144869664896 [Note] InnoDB: 5.7.20 started; log sequence number 93726687201 2018-02-02 18:46:50 140139455629056 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-02-02 18:46:50 140144869664896 [Note] Plugin 'FEEDBACK' is disabled. 2018-02-02 18:46:50 140144869664896 [Note] Recovering after a crash using tc.log 2018-02-02 18:46:50 140144869664896 [Note] Starting crash recovery... 2018-02-02 18:46:50 140144869664896 [Note] Crash recovery finished. 2018-02-02 18:46:50 140144869664896 [Note] Server socket created on IP: '::'. 2018-02-02 18:46:52 140144869664896 [Note] Reading of all Master_info entries succeded 2018-02-02 18:46:52 140144869664896 [Note] Added new Master_info '' to hash table 2018-02-02 18:46:52 140144869664896 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-02-02 18:47:22 140139455629056 [Note] InnoDB: Buffer pool(s) load completed at 180202 18:47:22