2018-01-02 12:02:53 139823085553792 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Uses event mutexes 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Number of pools: 1 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:02:53 139822287841024 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:02:53 139823085553792 [Note] InnoDB: 5.7.20 started; log sequence number 57146840218 2018-01-02 12:02:53 139821846619904 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:02:53 139823085553792 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:02:53 139823085553792 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:02:53 139823085553792 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:02:53 139821846619904 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:02:53 2018-01-02 12:02:53 139823085553792 [Note] Server socket created on IP: '::'. 2018-01-02 12:02:53 139822996240128 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:02:53 139823085553792 [Note] Reading of all Master_info entries succeded 2018-01-02 12:02:53 139823085553792 [Note] Added new Master_info '' to hash table 2018-01-02 12:02:53 139823085553792 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:04:29 139822595065600 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 12:04: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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=999 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f2a9c0009a8 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 = 0x7f2afc1c3d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x557d6f1eed6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x557d6ec7260d] /lib64/libpthread.so.0(+0xf5e0)[0x7f2b1919a5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x557d6ebcfdf0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x557d6ebcfed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x557d6eb33b17] mysys/stacktrace.c:268(my_print_stacktrace)[0x557d6eb384dc] sql/signal_handler.cc:168(handle_fatal_signal)[0x557d6eadadf8] sql/sql_explain.cc:122(Explain_query::add_node(Explain_node*))[0x557d6eb375bb] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x557d6eb3845f] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x557d6eb39b64] sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557d6eb3a744] /usr/sbin/mysqld(+0x4162ac)[0x557d6ea202ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x557d6eae61fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x557d6edb3b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x557d6eda58be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x557d6ed9af47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x557d6eda1059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x557d6eda13e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x557d6ed9de0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x557d6ed9f60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x557d6eadce66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x557d6eae5c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x557d6ed9adb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x557d6eda1059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x557d6eda1625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x557d6ed9de0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x557d6ed9f60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x557d6eadce66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x557d6eae5c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x557d6ed9adb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x557d6eda1059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x557d6eda1625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x557d6ed9de0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x557d6ed9f60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x557d6eadce66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x557d6eae5c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x557d6ed9adb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x557d6eda1059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x557d6eda1625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x557d6ed9de0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x557d6ed9f60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x557d6eadce66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x557d6eae5c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x557d6eaffade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x557d6eaffd20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x557d6eb00a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x557d6eb00b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557d6eaee7b2] sql/sql_parse.cc:1362(do_command(THD*))[0x557d6eaf06a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x557d6ebb405a] sql/sql_connect.cc:1262(handle_one_connection)[0x557d6ebb417d] /lib64/libpthread.so.0(+0x7e25)[0x7f2b19192e25] /lib64/libc.so.6(clone+0x6d)[0x7f2b1776a34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f2a9d31ec40): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',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-02 12:04:37 139696366692480 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Uses event mutexes 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Number of pools: 1 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:04:37 139695569520384 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Starting crash recovery from checkpoint LSN=57244354511 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Trx id counter is 4963840 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:04:37 139695489021696 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 12:04:37 139695489021696 [Note] InnoDB: Rolling back trx with id 4963433, 86 rows to undo 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: Waiting for purge to start 2018-01-02 12:04:37 139695489021696 [Note] InnoDB: Rollback of trx with id 4963433 completed 2018-01-02 12:04:37 139695489021696 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 12:04:37 139696366692480 [Note] InnoDB: 5.7.20 started; log sequence number 57244355150 2018-01-02 12:04:37 139695489021696 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:04:37 139696366692480 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:04:37 139696366692480 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:04:37 139696366692480 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:04:37 139696366692480 [Note] Recovering after a crash using tc.log 2018-01-02 12:04:37 139696366692480 [Note] Starting crash recovery... 2018-01-02 12:04:37 139696366692480 [Note] Crash recovery finished. 2018-01-02 12:04:37 139695489021696 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:04:37 2018-01-02 12:04:37 139696366692480 [Note] Server socket created on IP: '::'. 2018-01-02 12:04:37 139696228046592 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:04:37 139696366692480 [Note] Reading of all Master_info entries succeded 2018-01-02 12:04:37 139696366692480 [Note] Added new Master_info '' to hash table 2018-01-02 12:04:37 139696366692480 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:04:59 139695892842240 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 12:10:20 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.2.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f0d140009a8 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 = 0x7f0d7c0d1d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x560d570bdd6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x560d56b4160d] /lib64/libpthread.so.0(+0xf5e0)[0x7f0d981145e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x560d56a9edf0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x560d56a9eed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x560d56a02b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x560d56a074dc] mysys/stacktrace.c:268(my_print_stacktrace)[0x560d569a9df8] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x560d56a065bb] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x560d56a0745f] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x560d56a08b64] sql/sql_select.cc:373(sql/sql_select.cc:3695)[0x560d56a09744] /usr/sbin/mysqld(+0x4162ac)[0x560d568ef2ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x560d569b51fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x560d56c82b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x560d56c748be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x560d56c69f47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x560d56c70059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x560d56c703e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x560d56c6ce0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x560d56c6e60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x560d569abe66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x560d569b4c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x560d56c69db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x560d56c70059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x560d56c70625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x560d56c6ce0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x560d56c6e60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x560d569abe66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x560d569b4c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x560d56c69db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x560d56c70059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x560d56c70625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x560d56c6ce0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x560d56c6e60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x560d569abe66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x560d569b4c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x560d56c69db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x560d56c70059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x560d56c70625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x560d56c6ce0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x560d56c6e60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x560d569abe66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x560d569b4c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x560d569ceade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x560d569ced20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x560d569cfa87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x560d569cfb17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x560d569bd7b2] sql/sql_parse.cc:1362(do_command(THD*))[0x560d569bf6a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x560d56a8305a] sql/sql_connect.cc:1262(handle_one_connection)[0x560d56a8317d] /lib64/libpthread.so.0(+0x7e25)[0x7f0d9810ce25] /lib64/libc.so.6(clone+0x6d)[0x7f0d966e434d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f0d152fb478): CALL SP_COPY_ADDRESS_TEMPLATES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 11 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-02 12:10:26 140536229447808 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Uses event mutexes 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Number of pools: 1 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:10:26 140535434737408 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Starting crash recovery from checkpoint LSN=57339352819 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/ROLE_HIERARCHIES.ibd' with space ID 176046, since the redo log references ./ipswichdb/ROLE_HIERARCHIES.ibd with space ID 175607. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/ROLE_QUALIFICATIONS.ibd' with space ID 176047, since the redo log references ./ipswichdb/ROLE_QUALIFICATIONS.ibd with space ID 175608. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/ROUTER_CONFIGURATIONS.ibd' with space ID 176048, since the redo log references ./ipswichdb/ROUTER_CONFIGURATIONS.ibd with space ID 175609. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/ROUTER_DETAILS.ibd' with space ID 176049, since the redo log references ./ipswichdb/ROUTER_DETAILS.ibd with space ID 175610. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SCAN_INSTANCES.ibd' with space ID 176050, since the redo log references ./ipswichdb/SCAN_INSTANCES.ibd with space ID 175611. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACCESS.ibd' with space ID 176051, since the redo log references ./ipswichdb/SECURITY_ACCESS.ibd with space ID 175612. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACE.ibd' with space ID 176052, since the redo log references ./ipswichdb/SECURITY_ACE.ibd with space ID 175613. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACE_ACCESS.ibd' with space ID 176053, since the redo log references ./ipswichdb/SECURITY_ACE_ACCESS.ibd with space ID 175614. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACLS.ibd' with space ID 176054, since the redo log references ./ipswichdb/SECURITY_ACLS.ibd with space ID 175615. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACL_ENTRY.ibd' with space ID 176055, since the redo log references ./ipswichdb/SECURITY_ACL_ENTRY.ibd with space ID 175616. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_IDENTIFIERS.ibd' with space ID 176056, since the redo log references ./ipswichdb/SECURITY_IDENTIFIERS.ibd with space ID 175617. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_MEMBERS.ibd' with space ID 176057, since the redo log references ./ipswichdb/SECURITY_MEMBERS.ibd with space ID 175618. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_PATH.ibd' with space ID 176058, since the redo log references ./ipswichdb/SECURITY_PATH.ibd with space ID 175619. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SEGMENT_TYPE_TEMPLATE_ELEMENTS.ibd' with space ID 176059, since the redo log references ./ipswichdb/SEGMENT_TYPE_TEMPLATE_ELEMENTS.ibd with space ID 175620. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_FUNCTION_COMPLETION_EMAIL.ibd' with space ID 176060, since the redo log references ./ipswichdb/SENT_FUNCTION_COMPLETION_EMAIL.ibd with space ID 175621. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_NEW_ORGANISATION_EMAIL.ibd' with space ID 176061, since the redo log references ./ipswichdb/SENT_NEW_ORGANISATION_EMAIL.ibd with space ID 175622. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_NEW_USER_EMAIL.ibd' with space ID 176062, since the redo log references ./ipswichdb/SENT_NEW_USER_EMAIL.ibd with space ID 175623. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_PASSWORD_CHANGE_EMAIL.ibd' with space ID 176063, since the redo log references ./ipswichdb/SENT_PASSWORD_CHANGE_EMAIL.ibd with space ID 175624. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_PASSWORD_RESET_EMAIL.ibd' with space ID 176064, since the redo log references ./ipswichdb/SENT_PASSWORD_RESET_EMAIL.ibd with space ID 175625. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_TASK_EMAIL.ibd' with space ID 176065, since the redo log references ./ipswichdb/SENT_TASK_EMAIL.ibd with space ID 175626. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SIGNATORY_OBLIGATIONS.ibd' with space ID 176066, since the redo log references ./ipswichdb/SIGNATORY_OBLIGATIONS.ibd with space ID 175627. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SOFTWARE_LICENSE_AGREEMENTS.ibd' with space ID 176067, since the redo log references ./ipswichdb/SOFTWARE_LICENSE_AGREEMENTS.ibd with space ID 175628. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SOFTWARE_LICENSE_DETAILS.ibd' with space ID 176068, since the redo log references ./ipswichdb/SOFTWARE_LICENSE_DETAILS.ibd with space ID 175629. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SOFTWARE_LICENSE_STRINGS.ibd' with space ID 176069, since the redo log references ./ipswichdb/SOFTWARE_LICENSE_STRINGS.ibd with space ID 175630. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/STANDALONE_TARIFF_ITEMS.ibd' with space ID 176070, since the redo log references ./ipswichdb/STANDALONE_TARIFF_ITEMS.ibd with space ID 175631. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/STANDARDS_COLLECTION_DOCUMENTS.ibd' with space ID 176071, since the redo log references ./ipswichdb/STANDARDS_COLLECTION_DOCUMENTS.ibd with space ID 175632. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/STRATEGY_DETAILS.ibd' with space ID 176072, since the redo log references ./ipswichdb/STRATEGY_DETAILS.ibd with space ID 175633. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/STRENGTH_DETAILS.ibd' with space ID 176073, since the redo log references ./ipswichdb/STRENGTH_DETAILS.ibd with space ID 175634. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/STRENGTH_INPUT_DATA.ibd' with space ID 176074, since the redo log references ./ipswichdb/STRENGTH_INPUT_DATA.ibd with space ID 175635. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/STRENGTH_LOADED_DATA.ibd' with space ID 176075, since the redo log references ./ipswichdb/STRENGTH_LOADED_DATA.ibd with space ID 175636. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SUPPLIER_DETAILS.ibd' with space ID 176076, since the redo log references ./ipswichdb/SUPPLIER_DETAILS.ibd with space ID 175637. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SUPPLY_DETAILS.ibd' with space ID 176077, since the redo log references ./ipswichdb/SUPPLY_DETAILS.ibd with space ID 175638. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SWITCH_CONFIGURATIONS.ibd' with space ID 176078, since the redo log references ./ipswichdb/SWITCH_CONFIGURATIONS.ibd with space ID 175639. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SWITCH_DETAILS.ibd' with space ID 176079, since the redo log references ./ipswichdb/SWITCH_DETAILS.ibd with space ID 175640. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SWOT_BREAKDOWN.ibd' with space ID 176080, since the redo log references ./ipswichdb/SWOT_BREAKDOWN.ibd with space ID 175641. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SWOT_DOCUMENTS.ibd' with space ID 176081, since the redo log references ./ipswichdb/SWOT_DOCUMENTS.ibd with space ID 175642. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_COMPONENT_DETAILS.ibd' with space ID 176082, since the redo log references ./ipswichdb/SW_COMPONENT_DETAILS.ibd with space ID 175643. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_GENERIC_VERSION_NAMES.ibd' with space ID 176083, since the redo log references ./ipswichdb/SW_GENERIC_VERSION_NAMES.ibd with space ID 175644. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_MITIGATIONS.ibd' with space ID 176084, since the redo log references ./ipswichdb/SW_MITIGATIONS.ibd with space ID 175645. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PATCH_APPLICATIONS.ibd' with space ID 176085, since the redo log references ./ipswichdb/SW_PATCH_APPLICATIONS.ibd with space ID 175646. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_DETAILS.ibd' with space ID 176086, since the redo log references ./ipswichdb/SW_PRODUCT_DETAILS.ibd with space ID 175647. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_PATCHES.ibd' with space ID 176087, since the redo log references ./ipswichdb/SW_PRODUCT_PATCHES.ibd with space ID 175648. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_SUPPORT_DETAILS.ibd' with space ID 176088, since the redo log references ./ipswichdb/SW_PRODUCT_SUPPORT_DETAILS.ibd with space ID 175649. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_TYPES.ibd' with space ID 176089, since the redo log references ./ipswichdb/SW_PRODUCT_TYPES.ibd with space ID 175650. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_VERSION_DETAILS.ibd' with space ID 176090, since the redo log references ./ipswichdb/SW_PRODUCT_VERSION_DETAILS.ibd with space ID 175651. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_VULNERABILITIES.ibd' with space ID 176091, since the redo log references ./ipswichdb/SW_VULNERABILITIES.ibd with space ID 175652. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SW_VULNERABILITIES_IMPACT.ibd' with space ID 176092, since the redo log references ./ipswichdb/SW_VULNERABILITIES_IMPACT.ibd with space ID 175653. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/SYSTEM_TEXT.ibd' with space ID 176093, since the redo log references ./ipswichdb/SYSTEM_TEXT.ibd with space ID 175654. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TARIFF_DETAILS.ibd' with space ID 176094, since the redo log references ./ipswichdb/TARIFF_DETAILS.ibd with space ID 175655. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TARIFF_ITEMS.ibd' with space ID 176095, since the redo log references ./ipswichdb/TARIFF_ITEMS.ibd with space ID 175656. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TARIFF_ITEM_TYPES.ibd' with space ID 176096, since the redo log references ./ipswichdb/TARIFF_ITEM_TYPES.ibd with space ID 175657. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ACTIVATIONS.ibd' with space ID 176097, since the redo log references ./ipswichdb/TASK_ACTIVATIONS.ibd with space ID 175658. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ACTIVATION_LINKS.ibd' with space ID 176098, since the redo log references ./ipswichdb/TASK_ACTIVATION_LINKS.ibd with space ID 175659. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ACTIVATION_OUTPUTS.ibd' with space ID 176099, since the redo log references ./ipswichdb/TASK_ACTIVATION_OUTPUTS.ibd with space ID 175660. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ASSETS.ibd' with space ID 176100, since the redo log references ./ipswichdb/TASK_ASSETS.ibd with space ID 175661. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_CLASSES.ibd' with space ID 176101, since the redo log references ./ipswichdb/TASK_CLASSES.ibd with space ID 175662. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_COLLECTION_DOCUMENTS.ibd' with space ID 176102, since the redo log references ./ipswichdb/TASK_COLLECTION_DOCUMENTS.ibd with space ID 175663. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DATA_EVIDENCE_DETAILS.ibd' with space ID 176103, since the redo log references ./ipswichdb/TASK_DATA_EVIDENCE_DETAILS.ibd with space ID 175664. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DATA_ITEMS.ibd' with space ID 176104, since the redo log references ./ipswichdb/TASK_DATA_ITEMS.ibd with space ID 175665. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DELIVERABLES.ibd' with space ID 176105, since the redo log references ./ipswichdb/TASK_DELIVERABLES.ibd with space ID 175666. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DELIVERABLES_EVIDENCE_DETAILS.ibd' with space ID 176106, since the redo log references ./ipswichdb/TASK_DELIVERABLES_EVIDENCE_DETAILS.ibd with space ID 175667. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DETAILS.ibd' with space ID 176107, since the redo log references ./ipswichdb/TASK_DETAILS.ibd with space ID 175668. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DOCUMENT_EVIDENCE_DETAILS.ibd' with space ID 176108, since the redo log references ./ipswichdb/TASK_DOCUMENT_EVIDENCE_DETAILS.ibd with space ID 175669. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_EVIDENCE_DOCUMENTS.ibd' with space ID 176109, since the redo log references ./ipswichdb/TASK_EVIDENCE_DOCUMENTS.ibd with space ID 175670. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_FUNCTIONS.ibd' with space ID 176110, since the redo log references ./ipswichdb/TASK_FUNCTIONS.ibd with space ID 175671. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_FUNCTION_EVIDENCE_DETAILS.ibd' with space ID 176111, since the redo log references ./ipswichdb/TASK_FUNCTION_EVIDENCE_DETAILS.ibd with space ID 175672. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_INPUTS.ibd' with space ID 176112, since the redo log references ./ipswichdb/TASK_INPUTS.ibd with space ID 175673. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_INPUT_DATA.ibd' with space ID 176113, since the redo log references ./ipswichdb/TASK_INPUT_DATA.ibd with space ID 175674. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_INSTANCE_REFS.ibd' with space ID 176114, since the redo log references ./ipswichdb/TASK_INSTANCE_REFS.ibd with space ID 175675. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_LINKS.ibd' with space ID 176115, since the redo log references ./ipswichdb/TASK_LINKS.ibd with space ID 175676. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_LOADED_DATA.ibd' with space ID 176116, since the redo log references ./ipswichdb/TASK_LOADED_DATA.ibd with space ID 175677. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_OUTPUTS.ibd' with space ID 176117, since the redo log references ./ipswichdb/TASK_OUTPUTS.ibd with space ID 175678. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RECORDS.ibd' with space ID 176118, since the redo log references ./ipswichdb/TASK_RECORDS.ibd with space ID 175679. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RECORD_EVIDENCE_DETAILS.ibd' with space ID 176119, since the redo log references ./ipswichdb/TASK_RECORD_EVIDENCE_DETAILS.ibd with space ID 175680. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RESOURCES.ibd' with space ID 176120, since the redo log references ./ipswichdb/TASK_RESOURCES.ibd with space ID 175681. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RESPONSES.ibd' with space ID 176121, since the redo log references ./ipswichdb/TASK_RESPONSES.ibd with space ID 175682. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RESPONSE_EVIDENCE_DETAILS.ibd' with space ID 176122, since the redo log references ./ipswichdb/TASK_RESPONSE_EVIDENCE_DETAILS.ibd with space ID 175683. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ROLES.ibd' with space ID 176123, since the redo log references ./ipswichdb/TASK_ROLES.ibd with space ID 175684. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_STATUS_VALUES.ibd' with space ID 176124, since the redo log references ./ipswichdb/TASK_STATUS_VALUES.ibd with space ID 175685. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_TRIGGERS.ibd' with space ID 176125, since the redo log references ./ipswichdb/TASK_TRIGGERS.ibd with space ID 175686. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_USED_APPLICATIONS.ibd' with space ID 176126, since the redo log references ./ipswichdb/TASK_USED_APPLICATIONS.ibd with space ID 175687. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_VARIATIONS.ibd' with space ID 176127, since the redo log references ./ipswichdb/TASK_VARIATIONS.ibd with space ID 175688. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_ELEMENTS.ibd' with space ID 176128, since the redo log references ./ipswichdb/TEMPLATE_ELEMENTS.ibd with space ID 175689. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_GROUPS.ibd' with space ID 176129, since the redo log references ./ipswichdb/TEMPLATE_GROUPS.ibd with space ID 175690. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_GROUP_MEMBERS.ibd' with space ID 176130, since the redo log references ./ipswichdb/TEMPLATE_GROUP_MEMBERS.ibd with space ID 175691. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_RESPONSE_TYPES.ibd' with space ID 176131, since the redo log references ./ipswichdb/TEMPLATE_RESPONSE_TYPES.ibd with space ID 175692. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TEST_TABLE.ibd' with space ID 176132, since the redo log references ./ipswichdb/TEST_TABLE.ibd with space ID 175693. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_ACTORS.ibd' with space ID 176133, since the redo log references ./ipswichdb/THREAT_ACTORS.ibd with space ID 175694. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_ACTOR_TYPES.ibd' with space ID 176134, since the redo log references ./ipswichdb/THREAT_ACTOR_TYPES.ibd with space ID 175695. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_CONTINGENCIES.ibd' with space ID 176135, since the redo log references ./ipswichdb/THREAT_CONTINGENCIES.ibd with space ID 175696. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATATYPE_IMPACTS.ibd' with space ID 176136, since the redo log references ./ipswichdb/THREAT_DATATYPE_IMPACTS.ibd with space ID 175697. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATATYPE_METHODS.ibd' with space ID 176137, since the redo log references ./ipswichdb/THREAT_DATATYPE_METHODS.ibd with space ID 175698. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATA_IMPACTS.ibd' with space ID 176138, since the redo log references ./ipswichdb/THREAT_DATA_IMPACTS.ibd with space ID 175699. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATA_METHODS.ibd' with space ID 176139, since the redo log references ./ipswichdb/THREAT_DATA_METHODS.ibd with space ID 175700. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DETAILS.ibd' with space ID 176140, since the redo log references ./ipswichdb/THREAT_DETAILS.ibd with space ID 175701. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_IMPACTS.ibd' with space ID 176141, since the redo log references ./ipswichdb/THREAT_IMPACTS.ibd with space ID 175702. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_INPUT_DATA.ibd' with space ID 176142, since the redo log references ./ipswichdb/THREAT_INPUT_DATA.ibd with space ID 175703. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_LOADED_DATA.ibd' with space ID 176143, since the redo log references ./ipswichdb/THREAT_LOADED_DATA.ibd with space ID 175704. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_MITIGATIONS.ibd' with space ID 176144, since the redo log references ./ipswichdb/THREAT_MITIGATIONS.ibd with space ID 175705. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/THROTTLE_TABLE.ibd' with space ID 176145, since the redo log references ./ipswichdb/THROTTLE_TABLE.ibd with space ID 175706. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/TRAINING_PROVIDERS.ibd' with space ID 176146, since the redo log references ./ipswichdb/TRAINING_PROVIDERS.ibd with space ID 175707. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/USER_ITEM_TYPES.ibd' with space ID 176147, since the redo log references ./ipswichdb/USER_ITEM_TYPES.ibd with space ID 175708. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/VPN_ELEMENT.ibd' with space ID 176148, since the redo log references ./ipswichdb/VPN_ELEMENT.ibd with space ID 175709. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/VPN_ENABLED_DEVICES.ibd' with space ID 176149, since the redo log references ./ipswichdb/VPN_ENABLED_DEVICES.ibd with space ID 175710. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/VULNERABILITY_RISKS.ibd' with space ID 176150, since the redo log references ./ipswichdb/VULNERABILITY_RISKS.ibd with space ID 175711. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/WEAKNESS_DETAILS.ibd' with space ID 176151, since the redo log references ./ipswichdb/WEAKNESS_DETAILS.ibd with space ID 175712. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/WEAKNESS_INPUT_DATA.ibd' with space ID 176152, since the redo log references ./ipswichdb/WEAKNESS_INPUT_DATA.ibd with space ID 175713. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/WEAKNESS_LOADED_DATA.ibd' with space ID 176153, since the redo log references ./ipswichdb/WEAKNESS_LOADED_DATA.ibd with space ID 175714. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/WIFI_ELEMENT.ibd' with space ID 176154, since the redo log references ./ipswichdb/WIFI_ELEMENT.ibd with space ID 175715. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/WUFOO_FORMS.ibd' with space ID 176155, since the redo log references ./ipswichdb/WUFOO_FORMS.ibd with space ID 175716. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_BRANDING_THEMES.ibd' with space ID 176156, since the redo log references ./ipswichdb/XERO_BRANDING_THEMES.ibd with space ID 175717. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_INVOICES.ibd' with space ID 176157, since the redo log references ./ipswichdb/XERO_INVOICES.ibd with space ID 175718. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_ITEM_CODES.ibd' with space ID 176158, since the redo log references ./ipswichdb/XERO_ITEM_CODES.ibd with space ID 175719. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_LINE_ITEMS.ibd' with space ID 176159, since the redo log references ./ipswichdb/XERO_LINE_ITEMS.ibd with space ID 175720. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Trx id counter is 4971520 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Starting final batch to recover 1333 pages from redo log. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:10:26 140535356454656 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 12:10:26 140535356454656 [Note] InnoDB: Rolling back trx with id 4971013, 86 rows to undo 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:10:26 140536229447808 [Note] InnoDB: 5.7.20 started; log sequence number 57339360283 2018-01-02 12:10:26 140535356454656 [Note] InnoDB: Rollback of trx with id 4971013 completed 2018-01-02 12:10:26 140535356454656 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 12:10:26 140534920230656 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:10:26 140536229447808 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:10:26 140536229447808 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:10:26 140536229447808 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:10:26 140536229447808 [Note] Recovering after a crash using tc.log 2018-01-02 12:10:26 140536229447808 [Note] Starting crash recovery... 2018-01-02 12:10:26 140536229447808 [Note] Crash recovery finished. 2018-01-02 12:10:26 140534920230656 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:10:26 2018-01-02 12:10:26 140536229447808 [Note] Server socket created on IP: '::'. 2018-01-02 12:10:26 140536095069952 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:10:26 140536229447808 [Note] Reading of all Master_info entries succeded 2018-01-02 12:10:26 140536229447808 [Note] Added new Master_info '' to hash table 2018-01-02 12:10:26 140536229447808 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:12:55 140535760037632 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 12:13:11 140535760037632 [Warning] Aborted connection 9 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 2018-01-02 12:14:10 140535759734528 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 12:31:39 140535759734528 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 180102 12:32: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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fd0940008c8 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 = 0x7fd108097d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5584f9e94d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x5584f991860d] /lib64/libpthread.so.0(+0xf5e0)[0x7fd123c9e5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5584f9875df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5584f9875ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x5584f97d9b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x5584f97de4dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x5584f9780df8] mysys/stacktrace.c:268(my_print_stacktrace)[0x5584f97dd5bb] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x5584f97de45f] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x5584f97dfb64] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x5584f97e0744] /usr/sbin/mysqld(+0x4162ac)[0x5584f96c62ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5584f978c1fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x5584f9a59b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x5584f9a4b8be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x5584f9a40f47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5584f9a47059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x5584f9a473e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5584f9a43e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5584f9a4560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5584f9782e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5584f978bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5584f9a40db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5584f9a47059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5584f9a47625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5584f9a43e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5584f9a4560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5584f9782e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5584f978bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5584f9a40db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5584f9a47059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5584f9a47625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5584f9a43e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5584f9a4560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5584f9782e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5584f978bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5584f9a40db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5584f9a47059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5584f9a47625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5584f9a43e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5584f9a4560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5584f9782e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5584f978bc0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x5584f97a5ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x5584f97a5d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x5584f97a6a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x5584f97a6b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5584f97947b2] sql/sql_parse.cc:1362(do_command(THD*))[0x5584f97966a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x5584f985a05a] sql/sql_connect.cc:1262(handle_one_connection)[0x5584f985a17d] /lib64/libpthread.so.0(+0x7e25)[0x7fd123c96e25] /lib64/libc.so.6(clone+0x6d)[0x7fd12226e34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fd095314770): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 22 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-02 12:32:28 140147174336640 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Uses event mutexes 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Number of pools: 1 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:32:28 140146373318400 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Starting crash recovery from checkpoint LSN=57814669842 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Trx id counter is 5006592 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:32:28 140146364925696 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 12:32:28 140146364925696 [Note] InnoDB: Rolling back trx with id 5006143, 86 rows to undo 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:32:28 140147174336640 [Note] InnoDB: 5.7.20 started; log sequence number 57814670203 2018-01-02 12:32:28 140146364925696 [Note] InnoDB: Rollback of trx with id 5006143 completed 2018-01-02 12:32:28 140146364925696 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 12:32:28 140145588172544 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:32:28 140147174336640 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:32:28 140147174336640 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:32:28 140147174336640 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:32:28 140147174336640 [Note] Recovering after a crash using tc.log 2018-01-02 12:32:28 140147174336640 [Note] Starting crash recovery... 2018-01-02 12:32:28 140147174336640 [Note] Crash recovery finished. 2018-01-02 12:32:28 140145588172544 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:32:28 2018-01-02 12:32:28 140147174336640 [Note] Server socket created on IP: '::'. 2018-01-02 12:32:28 140147065173760 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:32:28 140147174336640 [Note] Reading of all Master_info entries succeded 2018-01-02 12:32:28 140147174336640 [Note] Added new Master_info '' to hash table 2018-01-02 12:32:28 140147174336640 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:35:13 140146667149056 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 12:35:32 140146667149056 [Warning] Aborted connection 10 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 180102 12:36: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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f76040009a8 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 = 0x7f767029bd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x562412634d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x5624120b860d] /lib64/libpthread.so.0(+0xf5e0)[0x7f768e4c05e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x562412015df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x562412015ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x562411f79b17] mysys/stacktrace.c:268(my_print_stacktrace)[0x562411f7e4dc] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x562411f20df8] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x562411f7d5bb] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x562411f7e45f] sql/sql_select.cc:3695(mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x562411f7fb64] sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x562411f80744] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x562411e662ac] sql/sql_parse.cc:3462(mysql_execute_command(THD*))[0x562411f2c1fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x5624121f9b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x5624121eb8be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x5624121e0f47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5624121e7059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x5624121e73e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5624121e3e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5624121e560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x562411f22e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x562411f2bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5624121e0db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5624121e7059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5624121e7625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5624121e3e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5624121e560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x562411f22e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x562411f2bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5624121e0db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5624121e7059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5624121e7625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5624121e3e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5624121e560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x562411f22e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x562411f2bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5624121e0db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5624121e7059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5624121e7625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5624121e3e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5624121e560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x562411f22e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x562411f2bc0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x562411f45ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x562411f45d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x562411f46a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x562411f46b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562411f347b2] sql/sql_parse.cc:1362(do_command(THD*))[0x562411f366a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x562411ffa05a] sql/sql_connect.cc:1262(handle_one_connection)[0x562411ffa17d] /lib64/libpthread.so.0(+0x7e25)[0x7f768e4b8e25] /lib64/libc.so.6(clone+0x6d)[0x7f768ca9034d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f7604aa1c70): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 12 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-02 12:36:30 140012354562176 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Uses event mutexes 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Number of pools: 1 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:36:30 140011560003328 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Starting crash recovery from checkpoint LSN=57909726528 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Trx id counter is 5014016 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:36:30 140011549492992 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 12:36:30 140011549492992 [Note] InnoDB: Rolling back trx with id 5013725, 86 rows to undo 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:36:30 140012354562176 [Note] InnoDB: 5.7.20 started; log sequence number 57909727151 2018-01-02 12:36:30 140011387197184 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:36:30 140012354562176 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:36:30 140012354562176 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:36:30 140012354562176 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:36:30 140012354562176 [Note] Recovering after a crash using tc.log 2018-01-02 12:36:30 140012354562176 [Note] Starting crash recovery... 2018-01-02 12:36:30 140012354562176 [Note] Crash recovery finished. 2018-01-02 12:36:30 140011549492992 [Note] InnoDB: Rollback of trx with id 5013725 completed 2018-01-02 12:36:30 140011549492992 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 12:36:30 140012354562176 [Note] Server socket created on IP: '::'. 2018-01-02 12:36:30 140012243285760 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:36:30 140012354562176 [Note] Reading of all Master_info entries succeded 2018-01-02 12:36:30 140012354562176 [Note] Added new Master_info '' to hash table 2018-01-02 12:36:30 140012354562176 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:36:31 140011387197184 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:36:31 2018-01-02 12:37:54 140011840976640 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 12:48:12 140011840673536 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 12:49:59 140011840673536 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 12:50:05 140011840673536 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 180102 12:51:14 [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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f56b00008c8 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 = 0x7f570c070d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x559e005c2d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x559e0004660d] /lib64/libpthread.so.0(+0xf5e0)[0x7f572a6985e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x559dfffa3df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x559dfffa3ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x559dfff07b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x559dfff0c4dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x559dffeaedf8] mysys/stacktrace.c:268(my_print_stacktrace)[0x559dfff0b5bb] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x559dfff0c45f] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x559dfff0db64] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x559dfff0e744] sql/sql_select.cc:1993(JOIN::optimize_inner())[0x559dffdf42ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x559dffeba1fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x559e00187b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x559e001798be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x559e0016ef47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559e00175059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x559e001753e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559e00171e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559e0017360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559dffeb0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559dffeb9c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559e0016edb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559e00175059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x559e00175625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559e00171e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559e0017360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559dffeb0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559dffeb9c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559e0016edb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559e00175059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x559e00175625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559e00171e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559e0017360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559dffeb0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559dffeb9c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x559dffed3ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x559dffed3d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x559dffed4a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x559dffed4b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559dffec27b2] sql/sql_parse.cc:1362(do_command(THD*))[0x559dffec46a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x559dfff8805a] sql/sql_connect.cc:1262(handle_one_connection)[0x559dfff8817d] /lib64/libpthread.so.0(+0x7e25)[0x7f572a690e25] /lib64/libc.so.6(clone+0x6d)[0x7f5728c6834d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f56b0d82b30): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 19 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-02 12:51:20 140160568830080 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Uses event mutexes 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Number of pools: 1 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:51:20 140159769925376 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58289739696 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 74 row operations to undo 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Trx id counter is 5041664 2018-01-02 12:51:20 140160568830080 [Note] InnoDB: Starting final batch to recover 28 pages from redo log. 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:51:21 140159761532672 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 12:51:21 140159761532672 [Note] InnoDB: Rolling back trx with id 5041314, 74 rows to undo 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: Waiting for purge to start 2018-01-02 12:51:21 140159761532672 [Note] InnoDB: Rollback of trx with id 5041314 completed 2018-01-02 12:51:21 140159761532672 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 12:51:21 140160568830080 [Note] InnoDB: 5.7.20 started; log sequence number 58289740335 2018-01-02 12:51:21 140159761532672 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:51:21 140160568830080 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:51:21 140160568830080 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:51:21 140160568830080 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:51:21 140160568830080 [Note] Recovering after a crash using tc.log 2018-01-02 12:51:21 140160568830080 [Note] Starting crash recovery... 2018-01-02 12:51:21 140160568830080 [Note] Crash recovery finished. 2018-01-02 12:51:21 140159761532672 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:51:21 2018-01-02 12:51:21 140160568830080 [Note] Server socket created on IP: '::'. 2018-01-02 12:51:21 140160420247296 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:51:21 140160568830080 [Note] Reading of all Master_info entries succeded 2018-01-02 12:51:21 140160568830080 [Note] Added new Master_info '' to hash table 2018-01-02 12:51:21 140160568830080 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:53:02 140160419641088 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 12:53:09 140160419641088 [Warning] Aborted connection 9 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 180102 12:59: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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f791c0009a8 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 = 0x7f799008ed70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5577ade6fd6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x5577ad8f360d] /lib64/libpthread.so.0(+0xf5e0)[0x7f79acabc5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5577ad850df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5577ad850ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x5577ad7b4b17] mysys/stacktrace.c:268(my_print_stacktrace)[0x5577ad7b94dc] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x5577ad75bdf8] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x5577ad7b85bb] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x5577ad7b945f] sql/sql_select.cc:3695(mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5577ad7bab64] sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5577ad7bb744] /usr/sbin/mysqld(+0x4162ac)[0x5577ad6a12ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5577ad7671fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x5577ada34b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x5577ada268be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x5577ada1bf47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5577ada22059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x5577ada223e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5577ada1ee0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5577ada2060f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5577ad75de66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5577ad766c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5577ada1bdb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5577ada22059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5577ada22625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5577ada1ee0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5577ada2060f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5577ad75de66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5577ad766c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5577ada1bdb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5577ada22059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5577ada22625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5577ada1ee0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5577ada2060f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5577ad75de66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5577ad766c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x5577ad780ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x5577ad780d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x5577ad781a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x5577ad781b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5577ad76f7b2] sql/sql_parse.cc:1362(do_command(THD*))[0x5577ad7716a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x5577ad83505a] sql/sql_connect.cc:1262(handle_one_connection)[0x5577ad83517d] /lib64/libpthread.so.0(+0x7e25)[0x7f79acab4e25] /lib64/libc.so.6(clone+0x6d)[0x7f79ab08c34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f791d229f00): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 14 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-02 12:59:30 140295158278272 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Uses event mutexes 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Using Linux native AIO 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Number of pools: 1 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 12:59:30 140294365148928 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58479767418 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 74 row operations to undo 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Trx id counter is 5056000 2018-01-02 12:59:30 140295158278272 [Note] InnoDB: Starting final batch to recover 44 pages from redo log. 2018-01-02 12:59:31 140295158278272 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 12:59:31 140294354638592 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 12:59:31 140294354638592 [Note] InnoDB: Rolling back trx with id 5055627, 74 rows to undo 2018-01-02 12:59:31 140295158278272 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 12:59:31 140295158278272 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 12:59:31 140295158278272 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 12:59:31 140295158278272 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 12:59:31 140295158278272 [Note] InnoDB: 5.7.20 started; log sequence number 58479798443 2018-01-02 12:59:31 140294066517760 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 12:59:31 140295158278272 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 12:59:31 140295158278272 [Note] Plugin 'gssapi' is disabled. 2018-01-02 12:59:31 140295158278272 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 12:59:31 140295158278272 [Note] Recovering after a crash using tc.log 2018-01-02 12:59:31 140295158278272 [Note] Starting crash recovery... 2018-01-02 12:59:31 140295158278272 [Note] Crash recovery finished. 2018-01-02 12:59:31 140294354638592 [Note] InnoDB: Rollback of trx with id 5055627 completed 2018-01-02 12:59:31 140294354638592 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 12:59:31 140295158278272 [Note] Server socket created on IP: '::'. 2018-01-02 12:59:31 140294304282368 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 12:59:31 140295158278272 [Note] Reading of all Master_info entries succeded 2018-01-02 12:59:31 140295158278272 [Note] Added new Master_info '' to hash table 2018-01-02 12:59:31 140295158278272 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 12:59:32 140294066517760 [Note] InnoDB: Buffer pool(s) load completed at 180102 12:59:32 2018-01-02 13:02:13 140294303676160 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 13:02:43 140294303676160 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 13:02:46 140294303676160 [Warning] Aborted connection 11 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 180102 13:07:43 [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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f98700009a8 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 = 0x7f98d01cbd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55e0d6d4cd6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55e0d67d060d] /lib64/libpthread.so.0(+0xf5e0)[0x7f9902d3c5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x55e0d672ddf0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x55e0d672ded3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x55e0d6691b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x55e0d66964dc] mysys/stacktrace.c:268(my_print_stacktrace)[0x55e0d6638df8] sql/signal_handler.cc:168(handle_fatal_signal)[0x55e0d66955bb] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x55e0d669645f] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x55e0d6697b64] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x55e0d6698744] /usr/sbin/mysqld(+0x4162ac)[0x55e0d657e2ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55e0d66441fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x55e0d6911b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x55e0d69038be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x55e0d68f8f47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55e0d68ff059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x55e0d68ff3e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55e0d68fbe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55e0d68fd60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55e0d663ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55e0d6643c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55e0d68f8db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55e0d68ff059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55e0d68ff625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55e0d68fbe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55e0d68fd60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55e0d663ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55e0d6643c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55e0d68f8db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55e0d68ff059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55e0d68ff625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55e0d68fbe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55e0d68fd60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55e0d663ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55e0d6643c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x55e0d665dade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x55e0d665dd20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x55e0d665ea87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55e0d665eb17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55e0d664c7b2] sql/sql_parse.cc:1362(do_command(THD*))[0x55e0d664e6a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55e0d671205a] sql/sql_connect.cc:1262(handle_one_connection)[0x55e0d671217d] /lib64/libpthread.so.0(+0x7e25)[0x7f9902d34e25] /lib64/libc.so.6(clone+0x6d)[0x7f990130c34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f987116ca20): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 15 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-02 13:07:49 140178154264704 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Uses event mutexes 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Using Linux native AIO 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Number of pools: 1 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 13:07:49 140177352447744 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58669862748 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 74 row operations to undo 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Trx id counter is 5070336 2018-01-02 13:07:49 140178154264704 [Note] InnoDB: Starting final batch to recover 37 pages from redo log. 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 13:07:50 140177344055040 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 13:07:50 140177344055040 [Note] InnoDB: Rolling back trx with id 5069965, 74 rows to undo 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: Waiting for purge to start 2018-01-02 13:07:50 140177344055040 [Note] InnoDB: Rollback of trx with id 5069965 completed 2018-01-02 13:07:50 140177344055040 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 13:07:50 140178154264704 [Note] InnoDB: 5.7.20 started; log sequence number 58669863518 2018-01-02 13:07:50 140177344055040 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 13:07:50 140178154264704 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 13:07:50 140178154264704 [Note] Plugin 'gssapi' is disabled. 2018-01-02 13:07:50 140178154264704 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 13:07:50 140178154264704 [Note] Recovering after a crash using tc.log 2018-01-02 13:07:50 140178154264704 [Note] Starting crash recovery... 2018-01-02 13:07:50 140178154264704 [Note] Crash recovery finished. 2018-01-02 13:07:50 140177344055040 [Note] InnoDB: Buffer pool(s) load completed at 180102 13:07:50 2018-01-02 13:07:50 140178154264704 [Note] Server socket created on IP: '::'. 2018-01-02 13:07:50 140178069587712 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 13:07:50 140178154264704 [Note] Reading of all Master_info entries succeded 2018-01-02 13:07:50 140178154264704 [Note] Added new Master_info '' to hash table 2018-01-02 13:07:50 140178154264704 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 13:09:26 140177672124160 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 13:24:53 140177669699328 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 180102 13:31:27 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.2.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f7d380008c8 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 = 0x7f7da8352d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55b04e064d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55b04dae860d] /lib64/libpthread.so.0(+0xf5e0)[0x7f7dc4d835e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x55b04da45df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x55b04da45ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x55b04d9a9b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x55b04d9ae4dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x55b04d950df8] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1cfb)[0x55b04d9ad5bb] mysys/stacktrace.c:268(my_print_stacktrace)[0x55b04d9ae45f] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x55b04d9afb64] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x55b04d9b0744] sql/sql_select.h:1504(JOIN::exec_join_tab_cnt())[0x55b04d8962ac] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55b04d95c1fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x55b04dc29b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x55b04dc1b8be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x55b04dc10f47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55b04dc17059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x55b04dc173e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55b04dc13e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55b04dc1560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55b04d952e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55b04d95bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55b04dc10db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55b04dc17059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55b04dc17625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55b04dc13e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55b04dc1560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55b04d952e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55b04d95bc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55b04dc10db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55b04dc17059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55b04dc17625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55b04dc13e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55b04dc1560f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55b04d952e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55b04d95bc0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x55b04d975ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x55b04d975d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x55b04d976a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55b04d976b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55b04d9647b2] sql/sql_parse.cc:1362(do_command(THD*))[0x55b04d9666a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55b04da2a05a] sql/sql_connect.cc:1262(handle_one_connection)[0x55b04da2a17d] /lib64/libpthread.so.0(+0x7e25)[0x7f7dc4d7be25] /lib64/libc.so.6(clone+0x6d)[0x7f7dc335334d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f7d39247650): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 17 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-02 13:31:33 139661559023744 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Uses event mutexes 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Using Linux native AIO 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Number of pools: 1 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 13:31:33 139660765198080 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Starting crash recovery from checkpoint LSN=59049992393 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 74 row operations to undo 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Trx id counter is 5098496 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 13:31:33 139660754687744 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 13:31:33 139660754687744 [Note] InnoDB: Rolling back trx with id 5097967, 74 rows to undo 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: Waiting for purge to start 2018-01-02 13:31:33 139660754687744 [Note] InnoDB: Rollback of trx with id 5097967 completed 2018-01-02 13:31:33 139660754687744 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 13:31:33 139661559023744 [Note] InnoDB: 5.7.20 started; log sequence number 59049992402 2018-01-02 13:31:33 139660754687744 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 13:31:33 139661559023744 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 13:31:33 139661559023744 [Note] Plugin 'gssapi' is disabled. 2018-01-02 13:31:33 139661559023744 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 13:31:33 139661559023744 [Note] Recovering after a crash using tc.log 2018-01-02 13:31:33 139661559023744 [Note] Starting crash recovery... 2018-01-02 13:31:33 139661559023744 [Note] Crash recovery finished. 2018-01-02 13:31:33 139660754687744 [Note] InnoDB: Buffer pool(s) load completed at 180102 13:31:33 2018-01-02 13:31:33 139661559023744 [Note] Server socket created on IP: '::'. 2018-01-02 13:31:33 139661062891264 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 13:31:33 139661559023744 [Note] Reading of all Master_info entries succeded 2018-01-02 13:31:33 139661559023744 [Note] Added new Master_info '' to hash table 2018-01-02 13:31:33 139661559023744 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 13:44:36 139660729509632 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 13:45:52 139660727084800 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 13:45:59 139660727084800 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 13:46:07 139660727084800 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 13:46:52 139660729509632 [Warning] Aborted connection 9 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 2018-01-02 14:32:21 139660729509632 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2018-01-02 14:32:21 139660729509632 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2018-01-02 14:50:25 139660729509632 [Warning] Aborted connection 22 to db: 'ipswichdb' user: 'root' host: 'localhost' (Got an error writing communication packets) 2018-01-02 14:50:54 139660600772352 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 14:50:54 139660600772352 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 14:50:54 139660600772352 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 14:50:54 139660600772352 [Note] Event Scheduler: Stopped 2018-01-02 14:50:54 139660600772352 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 14:50:54 139660634343168 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 14:50:54 139660600772352 [Note] InnoDB: Starting shutdown... 2018-01-02 14:50:54 139660754687744 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 14:50:54 139660754687744 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 14:50:54 139660754687744 [Note] InnoDB: Buffer pool(s) dump completed at 180102 14:50:54 2018-01-02 14:51:55 139660600772352 [Note] InnoDB: Waiting for 1 active transactions to finish 2018-01-02 14:52:55 139660600772352 [Note] InnoDB: Waiting for 1 active transactions to finish 2018-01-02 14:53:56 139660600772352 [Note] InnoDB: Waiting for 1 active transactions to finish 2018-01-02 14:58:50 139858091288704 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Uses event mutexes 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Using Linux native AIO 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Number of pools: 1 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 14:58:50 139857297684224 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Starting crash recovery from checkpoint LSN=59145137066 2018-01-02 14:58:50 139858091288704 [Note] InnoDB: Starting final batch to recover 28 pages from redo log. 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: Waiting for purge to start 2018-01-02 14:58:51 139858091288704 [Note] InnoDB: 5.7.20 started; log sequence number 59145180432 2018-01-02 14:58:51 139856936163072 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 14:58:51 139858091288704 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 14:58:51 139858091288704 [Note] Plugin 'gssapi' is disabled. 2018-01-02 14:58:51 139858091288704 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 14:58:51 139858091288704 [Note] Recovering after a crash using tc.log 2018-01-02 14:58:51 139858091288704 [Note] Starting crash recovery... 2018-01-02 14:58:51 139858091288704 [Note] Crash recovery finished. 2018-01-02 14:58:51 139858091288704 [Note] Server socket created on IP: '::'. 2018-01-02 14:58:51 139857624565504 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 14:58:51 139858091288704 [Note] Reading of all Master_info entries succeded 2018-01-02 14:58:51 139858091288704 [Note] Added new Master_info '' to hash table 2018-01-02 14:58:51 139858091288704 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 14:58:51 139856936163072 [Note] InnoDB: Buffer pool(s) load completed at 180102 14:58:51 2018-01-02 14:59:00 139857288988416 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 14:59:00 139857288988416 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 14:59:00 139857177302784 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 14:59:00 139857288988416 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 14:59:00 139857288988416 [Note] Event Scheduler: Stopped 2018-01-02 14:59:00 139857288988416 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 14:59:00 139857288988416 [Note] InnoDB: Starting shutdown... 2018-01-02 14:59:00 139856936163072 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 14:59:00 139856936163072 [Note] InnoDB: Instance 0, restricted to 2047 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 14:59:00 139856936163072 [Note] InnoDB: Buffer pool(s) dump completed at 180102 14:59:00 2018-01-02 14:59:01 139857288988416 [Note] InnoDB: Shutdown completed; log sequence number 59145181281 2018-01-02 14:59:01 139857288988416 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 14:59:01 139857288988416 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-02 15:00:25 140477834811520 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Uses event mutexes 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Number of pools: 1 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:00:25 140477035476736 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:00:25 140477834811520 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:00:26 140477834811520 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:00:26 140477834811520 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:00:26 140477834811520 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:00:26 140477834811520 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:00:26 140477834811520 [Note] InnoDB: 5.7.20 started; log sequence number 59145181281 2018-01-02 15:00:26 140476736845568 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:00:26 140477834811520 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:00:26 140477834811520 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:00:26 140477834811520 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:00:26 140477834811520 [Note] Server socket created on IP: '::'. 2018-01-02 15:00:26 140477332563712 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:00:26 140477834811520 [Note] Reading of all Master_info entries succeded 2018-01-02 15:00:26 140477834811520 [Note] Added new Master_info '' to hash table 2018-01-02 15:00:26 140477834811520 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:00:26 140476736845568 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:00:26 2018-01-02 15:01:10 140477331654400 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 15:01:10 140477331654400 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 15:01:10 140477331654400 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 15:01:10 140476985120512 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 15:01:10 140477331654400 [Note] Event Scheduler: Stopped 2018-01-02 15:01:10 140477331654400 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 15:01:10 140477331654400 [Note] InnoDB: Starting shutdown... 2018-01-02 15:01:10 140476736845568 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 15:01:10 140476736845568 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 15:01:10 140476736845568 [Note] InnoDB: Buffer pool(s) dump completed at 180102 15:01:10 2018-01-02 15:01:11 140477331654400 [Note] InnoDB: Shutdown completed; log sequence number 59145184073 2018-01-02 15:01:11 140477331654400 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:01:11 140477331654400 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-02 15:01:33 140417328773248 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Uses event mutexes 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Number of pools: 1 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:01:33 140416528439040 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:01:33 140417328773248 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:01:34 140417328773248 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:01:34 140417328773248 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:01:34 140417328773248 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:01:34 140417328773248 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:01:34 140417328773248 [Note] InnoDB: Waiting for purge to start 2018-01-02 15:01:34 140417328773248 [Note] InnoDB: 5.7.20 started; log sequence number 59145184073 2018-01-02 15:01:34 140416154326784 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:01:34 140417328773248 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:01:34 140417328773248 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:01:34 140417328773248 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:01:34 140417328773248 [Note] Server socket created on IP: '::'. 2018-01-02 15:01:34 140417178187520 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:01:34 140417328773248 [Note] Reading of all Master_info entries succeded 2018-01-02 15:01:34 140417328773248 [Note] Added new Master_info '' to hash table 2018-01-02 15:01:34 140417328773248 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:01:34 140416154326784 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:01:34 2018-01-02 15:02:06 140416846612224 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 15:02:06 140416846612224 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 15:02:06 140416846612224 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 15:02:06 140416846612224 [Note] Event Scheduler: Stopped 2018-01-02 15:02:06 140416846612224 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 15:02:06 140416405976832 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 15:02:06 140416846612224 [Note] InnoDB: Starting shutdown... 2018-01-02 15:02:06 140416154326784 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 15:02:06 140416154326784 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 15:02:06 140416154326784 [Note] InnoDB: Buffer pool(s) dump completed at 180102 15:02:06 2018-01-02 15:02:07 140416846612224 [Note] InnoDB: Shutdown completed; log sequence number 59145184101 2018-01-02 15:02:07 140416846612224 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:02:07 140416846612224 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-02 15:02:08 140640038062208 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Uses event mutexes 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Number of pools: 1 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:02:08 140639237601024 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: Waiting for purge to start 2018-01-02 15:02:08 140640038062208 [Note] InnoDB: 5.7.20 started; log sequence number 59145184101 2018-01-02 15:02:08 140638880253696 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:02:08 140640038062208 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:02:08 140640038062208 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:02:08 140640038062208 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:02:08 140640038062208 [Note] Server socket created on IP: '::'. 2018-01-02 15:02:08 140639912662784 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:02:08 140640038062208 [Note] Reading of all Master_info entries succeded 2018-01-02 15:02:08 140640038062208 [Note] Added new Master_info '' to hash table 2018-01-02 15:02:08 140640038062208 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:02:08 140638880253696 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:02:08 2018-01-02 15:03:18 140639513794304 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 15:04:56 140639511369472 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 15:09:39 140639511369472 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 15:12:43 140639511369472 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 15:14: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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fe8c80009a8 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 = 0x7fe9301dcd70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c39715ed6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55c396be260d] /lib64/libpthread.so.0(+0xf5e0)[0x7fe94f43a5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x55c396b3fdf0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x55c396b3fed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x55c396aa3b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x55c396aa84dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x55c396a4adf8] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1cfb)[0x55c396aa75bb] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x55c396aa845f] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x55c396aa9b64] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x55c396aaa744] /usr/sbin/mysqld(+0x4162ac)[0x55c3969902ac] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x286b)[0x55c396a561fb] /usr/sbin/mysqld(_Z17mysql_open_cursorP3THDP13select_resultPP18Server_side_cursor+0x187)[0x55c396d23b37] /usr/sbin/mysqld(_ZN9sp_cursor4openEP3THD+0x1e)[0x55c396d158be] /usr/sbin/mysqld(_ZN14sp_instr_copen9exec_coreEP3THDPj+0x27)[0x55c396d0af47] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x55c396d11059] /usr/sbin/mysqld(_ZN14sp_instr_copen7executeEP3THDPj+0x48)[0x55c396d113e8] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x7ce)[0x55c396d0de0e] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5df)[0x55c396d0f60f] /usr/sbin/mysqld(+0x4d2e66)[0x55c396a4ce66] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x227a)[0x55c396a55c0a] /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x36)[0x55c396d0adb6] mysys/stacktrace.c:268(my_print_stacktrace)[0x55c396d11059] sql/signal_handler.cc:168(handle_fatal_signal)[0x55c396d11625] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x55c396d0de0e] /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5df)[0x55c396d0f60f] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x55c396a4ce66] sql/sql_select.cc:373(sql/sql_select.cc:3695)[0x55c396a55c0a] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c396d0adb6] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x55c396d11059] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55c396d11625] sp_head:0(-10.2.11/sql/sp_head.cc:3181)[0x55c396d0de0e] sp_head:0(LD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sp_head.cc:3181)[0x55c396d0f60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55c396a4ce66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55c396a55c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c396d0adb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c396d11059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c396d11625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55c396d0de0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55c396d0f60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55c396a4ce66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55c396a55c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x55c396a6fade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x55c396a6fd20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x55c396a70a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55c396a70b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c396a5e7b2] sql/sql_parse.cc:1362(do_command(THD*))[0x55c396a606a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55c396b2405a] sql/sql_connect.cc:1262(handle_one_connection)[0x55c396b2417d] /lib64/libpthread.so.0(+0x7e25)[0x7fe94f432e25] /lib64/libc.so.6(clone+0x6d)[0x7fe94da0a34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fe8ca124b80): CALL SP_COPY_ADDRESS_TEMPLATE_ELEMENTS ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 18 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-02 15:14:13 140466976688256 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Uses event mutexes 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Number of pools: 1 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:14:13 140466180605696 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Starting crash recovery from checkpoint LSN=59459813536 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 556 row operations to undo 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Trx id counter is 5133312 2018-01-02 15:14:13 140466976688256 [Note] InnoDB: Starting final batch to recover 1698 pages from redo log. 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:14:14 140466100107008 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 15:14:14 140466100107008 [Note] InnoDB: Rolling back trx with id 5132959, 556 rows to undo 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: Waiting for purge to start 2018-01-02 15:14:14 140466100107008 [Note] InnoDB: Rollback of trx with id 5132959 completed 2018-01-02 15:14:14 140466100107008 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 15:14:14 140466976688256 [Note] InnoDB: 5.7.20 started; log sequence number 59461593170 2018-01-02 15:14:14 140466100107008 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:14:14 140466976688256 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:14:14 140466976688256 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:14:14 140466976688256 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:14:14 140466976688256 [Note] Recovering after a crash using tc.log 2018-01-02 15:14:14 140466976688256 [Note] Starting crash recovery... 2018-01-02 15:14:14 140466976688256 [Note] Crash recovery finished. 2018-01-02 15:14:14 140466100107008 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:14:14 2018-01-02 15:14:14 140466976688256 [Note] Server socket created on IP: '::'. 2018-01-02 15:14:14 140466976688256 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired 2018-01-02 15:14:14 140466976688256 [ERROR] mysqld: Table 'user' is marked as crashed and should be repaired 2018-01-02 15:14:14 140466976688256 [Warning] Checking table: './mysql/user' 2018-01-02 15:14:14 140466976688256 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly 2018-01-02 15:14:14 140466976688256 [ERROR] mysqld: Table './mysql/roles_mapping' is marked as crashed and should be repaired 2018-01-02 15:14:14 140466976688256 [ERROR] mysqld: Table 'roles_mapping' is marked as crashed and should be repaired 2018-01-02 15:14:14 140466976688256 [Warning] Checking table: './mysql/roles_mapping' 2018-01-02 15:14:14 140466976688256 [ERROR] mysql.roles_mapping: 1 client is using or hasn't closed the table properly 2018-01-02 15:14:14 140466976688256 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired 2018-01-02 15:14:14 140466976688256 [ERROR] mysqld: Table 'event' is marked as crashed and should be repaired 2018-01-02 15:14:14 140466976688256 [Warning] Checking table: './mysql/event' 2018-01-02 15:14:14 140466976688256 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly 2018-01-02 15:14:14 140466503624448 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:14:14 140466976688256 [Note] Reading of all Master_info entries succeded 2018-01-02 15:14:14 140466976688256 [Note] Added new Master_info '' to hash table 2018-01-02 15:14:14 140466976688256 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:16:39 140466172212992 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 15:16:46 140466172212992 [Warning] Aborted connection 9 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 2018-01-02 15:17:07 140466172212992 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 15:20:20 140466169788160 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 15:23:28 [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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=2 max_threads=999 thread_count=9 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fc0640009a8 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 = 0x7fc0d4272d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x556a1c27cd6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x556a1bd0060d] /lib64/libpthread.so.0(+0xf5e0)[0x7fc10400a5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x556a1bc5ddf0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x556a1bc5ded3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x556a1bbc1b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x556a1bbc64dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x556a1bb68df8] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1cfb)[0x556a1bbc55bb] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x556a1bbc645f] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x94)[0x556a1bbc7b64] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x556a1bbc8744] /usr/sbin/mysqld(+0x4162ac)[0x556a1baae2ac] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x286b)[0x556a1bb741fb] mysys/stacktrace.c:268(my_print_stacktrace)[0x556a1be41b37] sql/sql_explain.cc:86(Explain_query::get_select(unsigned int))[0x556a1be338be] /usr/sbin/mysqld(_ZN14sp_instr_copen9exec_coreEP3THDPj+0x27)[0x556a1be28f47] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x556a1be2f059] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x556a1be2f3e8] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556a1be2be0e] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x556a1be2d60f] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x556a1bb6ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556a1bb73c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556a1be28db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x556a1be2f059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x556a1be2f625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556a1be2be0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x556a1be2d60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556a1bb6ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556a1bb73c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556a1be28db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x556a1be2f059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x556a1be2f625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556a1be2be0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x556a1be2d60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556a1bb6ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556a1bb73c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556a1be28db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x556a1be2f059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x556a1be2f625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556a1be2be0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x556a1be2d60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556a1bb6ae66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556a1bb73c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x556a1bb8dade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x556a1bb8dd20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x556a1bb8ea87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x556a1bb8eb17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556a1bb7c7b2] sql/sql_parse.cc:1362(do_command(THD*))[0x556a1bb7e6a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x556a1bc4205a] sql/sql_connect.cc:1262(handle_one_connection)[0x556a1bc4217d] /lib64/libpthread.so.0(+0x7e25)[0x7fc104002e25] /lib64/libc.so.6(clone+0x6d)[0x7fc1025da34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fc0644fa278): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 17 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-02 15:23:34 140003719051392 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Uses event mutexes 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Number of pools: 1 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:23:34 140002923919104 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Starting crash recovery from checkpoint LSN=59772537504 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/PURCHASE_DETAILS.ibd' with space ID 186992, since the redo log references ./ipswichdb/PURCHASE_DETAILS.ibd with space ID 186526. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/QUALIFICATION_DEPENDENCIES.ibd' with space ID 186993, since the redo log references ./ipswichdb/QUALIFICATION_DEPENDENCIES.ibd with space ID 186389. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/QUALIFICATION_DETAILS.ibd' with space ID 186994, since the redo log references ./ipswichdb/QUALIFICATION_DETAILS.ibd with space ID 186387. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/QUALIFICATION_REQUIRED_COURSES.ibd' with space ID 186995, since the redo log references ./ipswichdb/QUALIFICATION_REQUIRED_COURSES.ibd with space ID 186388. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/QUALYS_BYHOST_PATCHES.ibd' with space ID 186996, since the redo log references ./ipswichdb/QUALYS_BYHOST_PATCHES.ibd with space ID 186519. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/QUALYS_PATCHES.ibd' with space ID 186997, since the redo log references ./ipswichdb/QUALYS_PATCHES.ibd with space ID 186518. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/QUALYS_PATCHFIXES.ibd' with space ID 186998, since the redo log references ./ipswichdb/QUALYS_PATCHFIXES.ibd with space ID 186520. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REGULATION_COLLECTION_DOCUMENTS.ibd' with space ID 186999, since the redo log references ./ipswichdb/REGULATION_COLLECTION_DOCUMENTS.ibd with space ID 186494. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RELATION_INPUT_DATA.ibd' with space ID 187000, since the redo log references ./ipswichdb/RELATION_INPUT_DATA.ibd with space ID 186337. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RELATION_LOADED_DATA.ibd' with space ID 187001, since the redo log references ./ipswichdb/RELATION_LOADED_DATA.ibd with space ID 186338. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REPOSITORY_DATA_HOLDINGS.ibd' with space ID 187002, since the redo log references ./ipswichdb/REPOSITORY_DATA_HOLDINGS.ibd with space ID 186568. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REPOSITORY_DATA_TYPES.ibd' with space ID 187003, since the redo log references ./ipswichdb/REPOSITORY_DATA_TYPES.ibd with space ID 186567. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REPOSITORY_DETAILS.ibd' with space ID 187004, since the redo log references ./ipswichdb/REPOSITORY_DETAILS.ibd with space ID 186565. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENTS_DETAILS.ibd' with space ID 187005, since the redo log references ./ipswichdb/REQUIREMENTS_DETAILS.ibd with space ID 186401. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_INPUT_DATA.ibd' with space ID 187017, since the redo log references ./ipswichdb/REQUIREMENT_INPUT_DATA.ibd with space ID 186335. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_INSTANCES.ibd' with space ID 187018, since the redo log references ./ipswichdb/REQUIREMENT_INSTANCES.ibd with space ID 186451. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_LINKS.ibd' with space ID 187019, since the redo log references ./ipswichdb/REQUIREMENT_LINKS.ibd with space ID 186416. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_LOADED_DATA.ibd' with space ID 187020, since the redo log references ./ipswichdb/REQUIREMENT_LOADED_DATA.ibd with space ID 186336. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_REFERENCES.ibd' with space ID 187021, since the redo log references ./ipswichdb/REQUIREMENT_REFERENCES.ibd with space ID 186413. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_TEMPLATES.ibd' with space ID 187022, since the redo log references ./ipswichdb/REQUIREMENT_TEMPLATES.ibd with space ID 186399. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/REQUIREMENT_TRIGGERS.ibd' with space ID 187023, since the redo log references ./ipswichdb/REQUIREMENT_TRIGGERS.ibd with space ID 186430. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RESOURCE_DETAILS.ibd' with space ID 187024, since the redo log references ./ipswichdb/RESOURCE_DETAILS.ibd with space ID 186445. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RESOURCE_TYPES.ibd' with space ID 187025, since the redo log references ./ipswichdb/RESOURCE_TYPES.ibd with space ID 186446. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RESPONSE_DEFINITIONS.ibd' with space ID 187026, since the redo log references ./ipswichdb/RESPONSE_DEFINITIONS.ibd with space ID 186301. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RESPONSE_ELEMENTS.ibd' with space ID 187027, since the redo log references ./ipswichdb/RESPONSE_ELEMENTS.ibd with space ID 186304. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RESPONSE_GROUPS.ibd' with space ID 187028, since the redo log references ./ipswichdb/RESPONSE_GROUPS.ibd with space ID 186303. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RESPONSE_STATUS_VALUES.ibd' with space ID 187029, since the redo log references ./ipswichdb/RESPONSE_STATUS_VALUES.ibd with space ID 186302. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RISK_DETAILS.ibd' with space ID 187030, since the redo log references ./ipswichdb/RISK_DETAILS.ibd with space ID 186605. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RISK_DOCUMENTS.ibd' with space ID 187031, since the redo log references ./ipswichdb/RISK_DOCUMENTS.ibd with space ID 186589. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RISK_IMPACTS.ibd' with space ID 187032, since the redo log references ./ipswichdb/RISK_IMPACTS.ibd with space ID 186611. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RISK_INPUT_DATA.ibd' with space ID 187033, since the redo log references ./ipswichdb/RISK_INPUT_DATA.ibd with space ID 186353. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/RISK_LOADED_DATA.ibd' with space ID 187034, since the redo log references ./ipswichdb/RISK_LOADED_DATA.ibd with space ID 186354. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/ROLE_DETAILS.ibd' with space ID 187035, since the redo log references ./ipswichdb/ROLE_DETAILS.ibd with space ID 186391. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/ROLE_HIERARCHIES.ibd' with space ID 187036, since the redo log references ./ipswichdb/ROLE_HIERARCHIES.ibd with space ID 186393. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/ROLE_QUALIFICATIONS.ibd' with space ID 187037, since the redo log references ./ipswichdb/ROLE_QUALIFICATIONS.ibd with space ID 186394. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/ROUTER_CONFIGURATIONS.ibd' with space ID 187038, since the redo log references ./ipswichdb/ROUTER_CONFIGURATIONS.ibd with space ID 186558. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/ROUTER_DETAILS.ibd' with space ID 187039, since the redo log references ./ipswichdb/ROUTER_DETAILS.ibd with space ID 186557. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SCAN_INSTANCES.ibd' with space ID 187040, since the redo log references ./ipswichdb/SCAN_INSTANCES.ibd with space ID 186666. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACCESS.ibd' with space ID 187041, since the redo log references ./ipswichdb/SECURITY_ACCESS.ibd with space ID 186695. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACE.ibd' with space ID 187042, since the redo log references ./ipswichdb/SECURITY_ACE.ibd with space ID 186693. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACE_ACCESS.ibd' with space ID 187043, since the redo log references ./ipswichdb/SECURITY_ACE_ACCESS.ibd with space ID 186696. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACLS.ibd' with space ID 187044, since the redo log references ./ipswichdb/SECURITY_ACLS.ibd with space ID 186688. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_ACL_ENTRY.ibd' with space ID 187045, since the redo log references ./ipswichdb/SECURITY_ACL_ENTRY.ibd with space ID 186694. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_IDENTIFIERS.ibd' with space ID 187046, since the redo log references ./ipswichdb/SECURITY_IDENTIFIERS.ibd with space ID 186691. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_MEMBERS.ibd' with space ID 187047, since the redo log references ./ipswichdb/SECURITY_MEMBERS.ibd with space ID 186692. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SECURITY_PATH.ibd' with space ID 187048, since the redo log references ./ipswichdb/SECURITY_PATH.ibd with space ID 186697. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SEGMENT_TYPE_TEMPLATE_ELEMENTS.ibd' with space ID 187049, since the redo log references ./ipswichdb/SEGMENT_TYPE_TEMPLATE_ELEMENTS.ibd with space ID 186323. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_FUNCTION_COMPLETION_EMAIL.ibd' with space ID 187050, since the redo log references ./ipswichdb/SENT_FUNCTION_COMPLETION_EMAIL.ibd with space ID 186707. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_NEW_ORGANISATION_EMAIL.ibd' with space ID 187051, since the redo log references ./ipswichdb/SENT_NEW_ORGANISATION_EMAIL.ibd with space ID 186710. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_NEW_USER_EMAIL.ibd' with space ID 187052, since the redo log references ./ipswichdb/SENT_NEW_USER_EMAIL.ibd with space ID 186704. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_PASSWORD_CHANGE_EMAIL.ibd' with space ID 187053, since the redo log references ./ipswichdb/SENT_PASSWORD_CHANGE_EMAIL.ibd with space ID 186705. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_PASSWORD_RESET_EMAIL.ibd' with space ID 187054, since the redo log references ./ipswichdb/SENT_PASSWORD_RESET_EMAIL.ibd with space ID 186706. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SENT_TASK_EMAIL.ibd' with space ID 187055, since the redo log references ./ipswichdb/SENT_TASK_EMAIL.ibd with space ID 186703. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SIGNATORY_OBLIGATIONS.ibd' with space ID 187056, since the redo log references ./ipswichdb/SIGNATORY_OBLIGATIONS.ibd with space ID 186373. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SOFTWARE_LICENSE_AGREEMENTS.ibd' with space ID 187057, since the redo log references ./ipswichdb/SOFTWARE_LICENSE_AGREEMENTS.ibd with space ID 186529. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SOFTWARE_LICENSE_DETAILS.ibd' with space ID 187058, since the redo log references ./ipswichdb/SOFTWARE_LICENSE_DETAILS.ibd with space ID 186530. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SOFTWARE_LICENSE_STRINGS.ibd' with space ID 187059, since the redo log references ./ipswichdb/SOFTWARE_LICENSE_STRINGS.ibd with space ID 186531. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/STANDALONE_TARIFF_ITEMS.ibd' with space ID 187060, since the redo log references ./ipswichdb/STANDALONE_TARIFF_ITEMS.ibd with space ID 186673. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/STANDARDS_COLLECTION_DOCUMENTS.ibd' with space ID 187061, since the redo log references ./ipswichdb/STANDARDS_COLLECTION_DOCUMENTS.ibd with space ID 186492. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/STRATEGY_DETAILS.ibd' with space ID 187062, since the redo log references ./ipswichdb/STRATEGY_DETAILS.ibd with space ID 186574. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/STRENGTH_DETAILS.ibd' with space ID 187063, since the redo log references ./ipswichdb/STRENGTH_DETAILS.ibd with space ID 186576. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/STRENGTH_INPUT_DATA.ibd' with space ID 187064, since the redo log references ./ipswichdb/STRENGTH_INPUT_DATA.ibd with space ID 186339. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/STRENGTH_LOADED_DATA.ibd' with space ID 187065, since the redo log references ./ipswichdb/STRENGTH_LOADED_DATA.ibd with space ID 186340. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SUPPLIER_DETAILS.ibd' with space ID 187066, since the redo log references ./ipswichdb/SUPPLIER_DETAILS.ibd with space ID 186376. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SUPPLY_DETAILS.ibd' with space ID 187067, since the redo log references ./ipswichdb/SUPPLY_DETAILS.ibd with space ID 186377. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SWITCH_CONFIGURATIONS.ibd' with space ID 187068, since the redo log references ./ipswichdb/SWITCH_CONFIGURATIONS.ibd with space ID 186564. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SWITCH_DETAILS.ibd' with space ID 187069, since the redo log references ./ipswichdb/SWITCH_DETAILS.ibd with space ID 186563. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SWOT_BREAKDOWN.ibd' with space ID 187070, since the redo log references ./ipswichdb/SWOT_BREAKDOWN.ibd with space ID 186599. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SWOT_DOCUMENTS.ibd' with space ID 187071, since the redo log references ./ipswichdb/SWOT_DOCUMENTS.ibd with space ID 186575. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_COMPONENT_DETAILS.ibd' with space ID 187072, since the redo log references ./ipswichdb/SW_COMPONENT_DETAILS.ibd with space ID 186546. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_GENERIC_VERSION_NAMES.ibd' with space ID 187073, since the redo log references ./ipswichdb/SW_GENERIC_VERSION_NAMES.ibd with space ID 186504. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_MITIGATIONS.ibd' with space ID 187074, since the redo log references ./ipswichdb/SW_MITIGATIONS.ibd with space ID 186513. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PATCH_APPLICATIONS.ibd' with space ID 187075, since the redo log references ./ipswichdb/SW_PATCH_APPLICATIONS.ibd with space ID 186510. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_DETAILS.ibd' with space ID 187076, since the redo log references ./ipswichdb/SW_PRODUCT_DETAILS.ibd with space ID 186503. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_PATCHES.ibd' with space ID 187077, since the redo log references ./ipswichdb/SW_PRODUCT_PATCHES.ibd with space ID 186509. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_SUPPORT_DETAILS.ibd' with space ID 187078, since the redo log references ./ipswichdb/SW_PRODUCT_SUPPORT_DETAILS.ibd with space ID 186514. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_TYPES.ibd' with space ID 187079, since the redo log references ./ipswichdb/SW_PRODUCT_TYPES.ibd with space ID 186507. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_PRODUCT_VERSION_DETAILS.ibd' with space ID 187080, since the redo log references ./ipswichdb/SW_PRODUCT_VERSION_DETAILS.ibd with space ID 186508. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_VULNERABILITIES.ibd' with space ID 187081, since the redo log references ./ipswichdb/SW_VULNERABILITIES.ibd with space ID 186511. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SW_VULNERABILITIES_IMPACT.ibd' with space ID 187082, since the redo log references ./ipswichdb/SW_VULNERABILITIES_IMPACT.ibd with space ID 186512. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/SYSTEM_TEXT.ibd' with space ID 187083, since the redo log references ./ipswichdb/SYSTEM_TEXT.ibd with space ID 186361. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TARIFF_DETAILS.ibd' with space ID 187084, since the redo log references ./ipswichdb/TARIFF_DETAILS.ibd with space ID 186668. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TARIFF_ITEMS.ibd' with space ID 187085, since the redo log references ./ipswichdb/TARIFF_ITEMS.ibd with space ID 186671. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TARIFF_ITEM_TYPES.ibd' with space ID 187086, since the redo log references ./ipswichdb/TARIFF_ITEM_TYPES.ibd with space ID 186670. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ACTIVATIONS.ibd' with space ID 187087, since the redo log references ./ipswichdb/TASK_ACTIVATIONS.ibd with space ID 186460. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ACTIVATION_LINKS.ibd' with space ID 187088, since the redo log references ./ipswichdb/TASK_ACTIVATION_LINKS.ibd with space ID 186682. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ACTIVATION_OUTPUTS.ibd' with space ID 187089, since the redo log references ./ipswichdb/TASK_ACTIVATION_OUTPUTS.ibd with space ID 186461. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ASSETS.ibd' with space ID 187090, since the redo log references ./ipswichdb/TASK_ASSETS.ibd with space ID 186440. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_CLASSES.ibd' with space ID 187091, since the redo log references ./ipswichdb/TASK_CLASSES.ibd with space ID 186435. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_COLLECTION_DOCUMENTS.ibd' with space ID 187092, since the redo log references ./ipswichdb/TASK_COLLECTION_DOCUMENTS.ibd with space ID 186424. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DATA_EVIDENCE_DETAILS.ibd' with space ID 187093, since the redo log references ./ipswichdb/TASK_DATA_EVIDENCE_DETAILS.ibd with space ID 186477. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DATA_ITEMS.ibd' with space ID 187094, since the redo log references ./ipswichdb/TASK_DATA_ITEMS.ibd with space ID 186470. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DELIVERABLES.ibd' with space ID 187095, since the redo log references ./ipswichdb/TASK_DELIVERABLES.ibd with space ID 186469. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DELIVERABLES_EVIDENCE_DETAILS.ibd' with space ID 187096, since the redo log references ./ipswichdb/TASK_DELIVERABLES_EVIDENCE_DETAILS.ibd with space ID 186478. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DETAILS.ibd' with space ID 187097, since the redo log references ./ipswichdb/TASK_DETAILS.ibd with space ID 186433. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_DOCUMENT_EVIDENCE_DETAILS.ibd' with space ID 187098, since the redo log references ./ipswichdb/TASK_DOCUMENT_EVIDENCE_DETAILS.ibd with space ID 186479. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_EVIDENCE_DOCUMENTS.ibd' with space ID 187099, since the redo log references ./ipswichdb/TASK_EVIDENCE_DOCUMENTS.ibd with space ID 186468. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_FUNCTIONS.ibd' with space ID 187100, since the redo log references ./ipswichdb/TASK_FUNCTIONS.ibd with space ID 186471. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_FUNCTION_EVIDENCE_DETAILS.ibd' with space ID 187101, since the redo log references ./ipswichdb/TASK_FUNCTION_EVIDENCE_DETAILS.ibd with space ID 186476. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_INPUTS.ibd' with space ID 187102, since the redo log references ./ipswichdb/TASK_INPUTS.ibd with space ID 186447. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_INPUT_DATA.ibd' with space ID 187103, since the redo log references ./ipswichdb/TASK_INPUT_DATA.ibd with space ID 186331. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_INSTANCE_REFS.ibd' with space ID 187104, since the redo log references ./ipswichdb/TASK_INSTANCE_REFS.ibd with space ID 186462. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_LINKS.ibd' with space ID 187105, since the redo log references ./ipswichdb/TASK_LINKS.ibd with space ID 186681. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_LOADED_DATA.ibd' with space ID 187106, since the redo log references ./ipswichdb/TASK_LOADED_DATA.ibd with space ID 186332. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_OUTPUTS.ibd' with space ID 187107, since the redo log references ./ipswichdb/TASK_OUTPUTS.ibd with space ID 186448. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RECORDS.ibd' with space ID 187108, since the redo log references ./ipswichdb/TASK_RECORDS.ibd with space ID 186467. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RECORD_EVIDENCE_DETAILS.ibd' with space ID 187109, since the redo log references ./ipswichdb/TASK_RECORD_EVIDENCE_DETAILS.ibd with space ID 186481. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RESOURCES.ibd' with space ID 187110, since the redo log references ./ipswichdb/TASK_RESOURCES.ibd with space ID 186442. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RESPONSES.ibd' with space ID 187111, since the redo log references ./ipswichdb/TASK_RESPONSES.ibd with space ID 186466. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_RESPONSE_EVIDENCE_DETAILS.ibd' with space ID 187112, since the redo log references ./ipswichdb/TASK_RESPONSE_EVIDENCE_DETAILS.ibd with space ID 186482. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_ROLES.ibd' with space ID 187113, since the redo log references ./ipswichdb/TASK_ROLES.ibd with space ID 186441. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_STATUS_VALUES.ibd' with space ID 187114, since the redo log references ./ipswichdb/TASK_STATUS_VALUES.ibd with space ID 186463. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_TRIGGERS.ibd' with space ID 187115, since the redo log references ./ipswichdb/TASK_TRIGGERS.ibd with space ID 186434. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_USED_APPLICATIONS.ibd' with space ID 187116, since the redo log references ./ipswichdb/TASK_USED_APPLICATIONS.ibd with space ID 186551. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TASK_VARIATIONS.ibd' with space ID 187117, since the redo log references ./ipswichdb/TASK_VARIATIONS.ibd with space ID 186604. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_ELEMENTS.ibd' with space ID 187118, since the redo log references ./ipswichdb/TEMPLATE_ELEMENTS.ibd with space ID 186297. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_GROUPS.ibd' with space ID 187119, since the redo log references ./ipswichdb/TEMPLATE_GROUPS.ibd with space ID 186298. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_GROUP_MEMBERS.ibd' with space ID 187120, since the redo log references ./ipswichdb/TEMPLATE_GROUP_MEMBERS.ibd with space ID 186299. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TEMPLATE_RESPONSE_TYPES.ibd' with space ID 187121, since the redo log references ./ipswichdb/TEMPLATE_RESPONSE_TYPES.ibd with space ID 186300. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TEST_TABLE.ibd' with space ID 187122, since the redo log references ./ipswichdb/TEST_TABLE.ibd with space ID 186357. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_ACTORS.ibd' with space ID 187123, since the redo log references ./ipswichdb/THREAT_ACTORS.ibd with space ID 186639. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_ACTOR_TYPES.ibd' with space ID 187124, since the redo log references ./ipswichdb/THREAT_ACTOR_TYPES.ibd with space ID 186640. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_CONTINGENCIES.ibd' with space ID 187125, since the redo log references ./ipswichdb/THREAT_CONTINGENCIES.ibd with space ID 186585. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATATYPE_IMPACTS.ibd' with space ID 187126, since the redo log references ./ipswichdb/THREAT_DATATYPE_IMPACTS.ibd with space ID 186647. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATATYPE_METHODS.ibd' with space ID 187127, since the redo log references ./ipswichdb/THREAT_DATATYPE_METHODS.ibd with space ID 186644. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATA_IMPACTS.ibd' with space ID 187128, since the redo log references ./ipswichdb/THREAT_DATA_IMPACTS.ibd with space ID 186648. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DATA_METHODS.ibd' with space ID 187129, since the redo log references ./ipswichdb/THREAT_DATA_METHODS.ibd with space ID 186645. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_DETAILS.ibd' with space ID 187130, since the redo log references ./ipswichdb/THREAT_DETAILS.ibd with space ID 186579. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_IMPACTS.ibd' with space ID 187131, since the redo log references ./ipswichdb/THREAT_IMPACTS.ibd with space ID 186584. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_INPUT_DATA.ibd' with space ID 187132, since the redo log references ./ipswichdb/THREAT_INPUT_DATA.ibd with space ID 186345. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_LOADED_DATA.ibd' with space ID 187133, since the redo log references ./ipswichdb/THREAT_LOADED_DATA.ibd with space ID 186346. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THREAT_MITIGATIONS.ibd' with space ID 187134, since the redo log references ./ipswichdb/THREAT_MITIGATIONS.ibd with space ID 186583. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/THROTTLE_TABLE.ibd' with space ID 187135, since the redo log references ./ipswichdb/THROTTLE_TABLE.ibd with space ID 186367. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/TRAINING_PROVIDERS.ibd' with space ID 187136, since the redo log references ./ipswichdb/TRAINING_PROVIDERS.ibd with space ID 186380. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/USER_ITEM_TYPES.ibd' with space ID 187137, since the redo log references ./ipswichdb/USER_ITEM_TYPES.ibd with space ID 186489. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/VPN_ELEMENT.ibd' with space ID 187138, since the redo log references ./ipswichdb/VPN_ELEMENT.ibd with space ID 186554. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/VPN_ENABLED_DEVICES.ibd' with space ID 187139, since the redo log references ./ipswichdb/VPN_ENABLED_DEVICES.ibd with space ID 186555. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/VULNERABILITY_RISKS.ibd' with space ID 187140, since the redo log references ./ipswichdb/VULNERABILITY_RISKS.ibd with space ID 186665. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/WEAKNESS_DETAILS.ibd' with space ID 187141, since the redo log references ./ipswichdb/WEAKNESS_DETAILS.ibd with space ID 186577. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/WEAKNESS_INPUT_DATA.ibd' with space ID 187142, since the redo log references ./ipswichdb/WEAKNESS_INPUT_DATA.ibd with space ID 186341. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/WEAKNESS_LOADED_DATA.ibd' with space ID 187143, since the redo log references ./ipswichdb/WEAKNESS_LOADED_DATA.ibd with space ID 186342. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/WIFI_ELEMENT.ibd' with space ID 187144, since the redo log references ./ipswichdb/WIFI_ELEMENT.ibd with space ID 186553. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/WUFOO_FORMS.ibd' with space ID 187145, since the redo log references ./ipswichdb/WUFOO_FORMS.ibd with space ID 186679. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_BRANDING_THEMES.ibd' with space ID 187146, since the redo log references ./ipswichdb/XERO_BRANDING_THEMES.ibd with space ID 186685. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_INVOICES.ibd' with space ID 187147, since the redo log references ./ipswichdb/XERO_INVOICES.ibd with space ID 186674. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_ITEM_CODES.ibd' with space ID 187148, since the redo log references ./ipswichdb/XERO_ITEM_CODES.ibd with space ID 186672. 2018-01-02 15:23:34 140003719051392 [Note] InnoDB: Ignoring data file './ipswichdb/XERO_LINE_ITEMS.ibd' with space ID 187149, since the redo log references ./ipswichdb/XERO_LINE_ITEMS.ibd with space ID 186675. 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: Trx id counter is 5157888 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: Starting final batch to recover 1736 pages from redo log. 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:23:35 140002845501184 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 15:23:35 140002845501184 [Note] InnoDB: Rolling back trx with id 5157584, 86 rows to undo 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:23:35 140002845501184 [Note] InnoDB: Rollback of trx with id 5157584 completed 2018-01-02 15:23:35 140002845501184 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 15:23:35 140003719051392 [Note] InnoDB: 5.7.20 started; log sequence number 59772546593 2018-01-02 15:23:35 140002845501184 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:23:35 140003719051392 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:23:35 140003719051392 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:23:35 140003719051392 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:23:35 140003719051392 [Note] Recovering after a crash using tc.log 2018-01-02 15:23:35 140003719051392 [Note] Starting crash recovery... 2018-01-02 15:23:35 140003719051392 [Note] Crash recovery finished. 2018-01-02 15:23:35 140002845501184 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:23:35 2018-01-02 15:23:35 140003719051392 [Note] Server socket created on IP: '::'. 2018-01-02 15:23:35 140003719051392 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired 2018-01-02 15:23:35 140003719051392 [ERROR] mysqld: Table 'user' is marked as crashed and should be repaired 2018-01-02 15:23:35 140003719051392 [Warning] Checking table: './mysql/user' 2018-01-02 15:23:35 140003719051392 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly 2018-01-02 15:23:35 140003719051392 [ERROR] mysqld: Table './mysql/roles_mapping' is marked as crashed and should be repaired 2018-01-02 15:23:35 140003719051392 [ERROR] mysqld: Table 'roles_mapping' is marked as crashed and should be repaired 2018-01-02 15:23:35 140003719051392 [Warning] Checking table: './mysql/roles_mapping' 2018-01-02 15:23:35 140003719051392 [ERROR] mysql.roles_mapping: 1 client is using or hasn't closed the table properly 2018-01-02 15:23:35 140003719051392 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired 2018-01-02 15:23:35 140003719051392 [ERROR] mysqld: Table 'event' is marked as crashed and should be repaired 2018-01-02 15:23:35 140003719051392 [Warning] Checking table: './mysql/event' 2018-01-02 15:23:35 140003719051392 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly 2018-01-02 15:23:35 140003586791168 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:23:35 140003719051392 [Note] Reading of all Master_info entries succeded 2018-01-02 15:23:35 140003719051392 [Note] Added new Master_info '' to hash table 2018-01-02 15:23:35 140003719051392 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:26:17 140003586184960 [Warning] Access denied for user 'ipswichdba'@'localhost' (using password: YES) 2018-01-02 15:26:41 140003251410688 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 15:26:41 140003251410688 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 15:26:41 140002795144960 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 15:26:41 140003251410688 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 15:26:41 140003251410688 [Note] Event Scheduler: Stopped 2018-01-02 15:26:41 140003251410688 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 15:26:41 140003251410688 [Note] InnoDB: Starting shutdown... 2018-01-02 15:26:41 140002845501184 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 15:26:41 140002845501184 [Note] InnoDB: Instance 0, restricted to 2047 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 15:26:41 140002845501184 [Note] InnoDB: Buffer pool(s) dump completed at 180102 15:26:41 2018-01-02 15:26:42 140003251410688 [Note] InnoDB: Shutdown completed; log sequence number 59870026257 2018-01-02 15:26:42 140003251410688 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:26:42 140003251410688 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-02 15:26:43 139704985766016 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Uses event mutexes 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Number of pools: 1 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:26:43 139704190797568 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: Waiting for purge to start 2018-01-02 15:26:43 139704985766016 [Note] InnoDB: 5.7.20 started; log sequence number 59870026257 2018-01-02 15:26:43 139704028600064 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:26:43 139704985766016 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:26:43 139704985766016 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:26:43 139704985766016 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:26:43 139704985766016 [Note] Server socket created on IP: '::'. 2018-01-02 15:26:43 139704884852480 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:26:43 139704985766016 [Note] Reading of all Master_info entries succeded 2018-01-02 15:26:43 139704985766016 [Note] Added new Master_info '' to hash table 2018-01-02 15:26:43 139704985766016 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:26:43 139704028600064 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:26:43 2018-01-02 15:27:09 139704482625280 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 15:27:12 [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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=999 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f0f240009a8 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 = 0x7f0f7c0f6d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5587a10c2d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x5587a0b4660d] /lib64/libpthread.so.0(+0xf5e0)[0x7f0f99cde5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x5587a0aa3df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x5587a0aa3ed3] mysys/stacktrace.c:268(my_print_stacktrace)[0x5587a0a07b17] sql/signal_handler.cc:168(handle_fatal_signal)[0x5587a0a0c4dc] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x5587a09aedf8] sql/sql_select.h:1504(JOIN::exec_join_tab_cnt())[0x5587a0a0b5bb] sql/sql_select.cc:1086(JOIN::optimize())[0x5587a0a0c45f] sql/sql_select.cc:3695(mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5587a0a0db64] sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5587a0a0e744] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5587a08f42ac] sql/sql_parse.cc:3462(mysql_execute_command(THD*))[0x5587a09ba1fb] sql/sql_cursor.cc:142(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x5587a0c87b37] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x5587a0c798be] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x5587a0c6ef47] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5587a0c75059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x5587a0c753e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5587a0c71e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5587a0c7360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5587a09b0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5587a09b9c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5587a0c6edb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5587a0c75059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5587a0c75625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5587a0c71e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5587a0c7360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5587a09b0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5587a09b9c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5587a0c6edb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5587a0c75059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5587a0c75625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5587a0c71e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5587a0c7360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5587a09b0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5587a09b9c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5587a0c6edb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5587a0c75059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x5587a0c75625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x5587a0c71e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x5587a0c7360f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x5587a09b0e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x5587a09b9c0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x5587a09d3ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x5587a09d3d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x5587a09d4a87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x5587a09d4b17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5587a09c27b2] sql/sql_parse.cc:1362(do_command(THD*))[0x5587a09c46a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x5587a0a8805a] sql/sql_connect.cc:1262(handle_one_connection)[0x5587a0a8817d] /lib64/libpthread.so.0(+0x7e25)[0x7f0f99cd6e25] /lib64/libc.so.6(clone+0x6d)[0x7f0f982ae34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f0f24bb4018): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59831), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) 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-01-02 15:27:18 139897975548032 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Uses event mutexes 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Number of pools: 1 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:27:18 139897172940544 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Starting crash recovery from checkpoint LSN=59870026276 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Trx id counter is 5165568 2018-01-02 15:27:18 139897975548032 [Note] InnoDB: Starting final batch to recover 46 pages from redo log. 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:27:19 139897164547840 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 15:27:19 139897164547840 [Note] InnoDB: Rolling back trx with id 5165061, 86 rows to undo 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: Waiting for purge to start 2018-01-02 15:27:19 139897164547840 [Note] InnoDB: Rollback of trx with id 5165061 completed 2018-01-02 15:27:19 139897164547840 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 15:27:19 139897975548032 [Note] InnoDB: 5.7.20 started; log sequence number 59870071871 2018-01-02 15:27:19 139897164547840 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:27:19 139897975548032 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:27:19 139897975548032 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:27:19 139897975548032 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:27:19 139897975548032 [Note] Recovering after a crash using tc.log 2018-01-02 15:27:19 139897975548032 [Note] Starting crash recovery... 2018-01-02 15:27:19 139897975548032 [Note] Crash recovery finished. 2018-01-02 15:27:19 139897975548032 [Note] Server socket created on IP: '::'. 2018-01-02 15:27:19 139897890871040 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:27:19 139897975548032 [Note] Reading of all Master_info entries succeded 2018-01-02 15:27:19 139897975548032 [Note] Added new Master_info '' to hash table 2018-01-02 15:27:19 139897975548032 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:27:19 139897164547840 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:27:19 2018-01-02 15:28:02 139897890264832 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 15:28:02 139897890264832 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 15:28:02 139897890264832 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 15:28:02 139897890264832 [Note] Event Scheduler: Stopped 2018-01-02 15:28:02 139897890264832 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 15:28:02 139896773650176 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 15:28:02 139897890264832 [Note] InnoDB: Starting shutdown... 2018-01-02 15:28:02 139897164547840 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 15:28:02 139897164547840 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 15:28:02 139897164547840 [Note] InnoDB: Buffer pool(s) dump completed at 180102 15:28:02 2018-01-02 15:28:03 139897890264832 [Note] InnoDB: Shutdown completed; log sequence number 59870080505 2018-01-02 15:28:03 139897890264832 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:28:03 139897890264832 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-02 15:28:03 140627550496896 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Uses event mutexes 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Number of pools: 1 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:28:03 140626755352320 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:28:03 140627550496896 [Note] InnoDB: 5.7.20 started; log sequence number 59870080505 2018-01-02 15:28:03 140626465113856 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:28:03 140627550496896 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:28:03 140627550496896 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:28:03 140627550496896 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:28:03 140627550496896 [Note] Server socket created on IP: '::'. 2018-01-02 15:28:03 140626696300288 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:28:03 140627550496896 [Note] Reading of all Master_info entries succeded 2018-01-02 15:28:03 140627550496896 [Note] Added new Master_info '' to hash table 2018-01-02 15:28:03 140627550496896 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:28:03 140626465113856 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:28:03 2018-01-02 15:28:56 140626695694080 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 2018-01-02 15:31:10 140626695694080 [Warning] Aborted connection 10 to db: 'ipswichdb' user: 'ipswichdba' host: '192.168.163.130' (Got an error reading communication packets) 180102 15:31:29 [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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=999 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fe5e80009a8 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 = 0x7fe6343e1d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x559157118d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x559156b9c60d] /lib64/libpthread.so.0(+0xf5e0)[0x7fe666f285e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x559156af9df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x559156af9ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x559156a5db17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x559156a624dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x559156a04df8] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1cfb)[0x559156a615bb] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x3f)[0x559156a6245f] mysys/stacktrace.c:268(my_print_stacktrace)[0x559156a63b64] sql/signal_handler.cc:168(handle_fatal_signal)[0x559156a64744] /usr/sbin/mysqld(+0x4162ac)[0x55915694a2ac] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x559156a101fb] sql/sql_select.cc:373(sql/sql_select.cc:3695)[0x559156cddb37] sql/sql_parse.cc:6447(execute_sqlcom_select(THD*, TABLE_LIST*))[0x559156ccf8be] sql/sp_rcontext.cc:458(sp_cursor::open(THD*))[0x559156cc4f47] sql/sp_head.cc:3862(sp_instr_copen::exec_core(THD*, unsigned int*))[0x559156ccb059] sql/sp_head.cc:3848(sp_instr_copen::execute(THD*, unsigned int*))[0x559156ccb3e8] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559156cc7e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559156cc960f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559156a06e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559156a0fc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559156cc4db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559156ccb059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x559156ccb625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559156cc7e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559156cc960f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559156a06e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559156a0fc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559156cc4db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559156ccb059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x559156ccb625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559156cc7e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559156cc960f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559156a06e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559156a0fc0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559156cc4db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559156ccb059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x559156ccb625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x559156cc7e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x559156cc960f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x559156a06e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x559156a0fc0a] sql/sql_prepare.cc:4736(Prepared_statement::execute(String*, bool))[0x559156a29ade] sql/sql_prepare.cc:4165(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x559156a29d20] sql/sql_prepare.cc:3185(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x559156a2aa87] sql/sql_prepare.cc:3085(mysqld_stmt_execute(THD*, char*, unsigned int))[0x559156a2ab17] sql/sql_parse.cc:1748(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x559156a187b2] sql/sql_parse.cc:1362(do_command(THD*))[0x559156a1a6a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x559156ade05a] sql/sql_connect.cc:1262(handle_one_connection)[0x559156ade17d] /lib64/libpthread.so.0(+0x7e25)[0x7fe666f20e25] /lib64/libc.so.6(clone+0x6d)[0x7fe6654f834d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fe5e932d7c8): CALL SP_COPY_ROLES ( NAME_CONST('V_COPY_INSTANCE_UID',59852), NAME_CONST('V_SOURCE_ORG_NAME',_utf8'cysure' COLLATE 'utf8_bin'), NAME_CONST('V_TARGET_ORG_NAME',_utf8'democustorg' COLLATE 'utf8_bin'), NAME_CONST('V_STATUS',0) ) Connection ID (thread ID): 11 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-02 15:31:35 140576271046784 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Uses event mutexes 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Number of pools: 1 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:31:35 140575475787520 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Starting crash recovery from checkpoint LSN=59965243291 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 86 row operations to undo 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Trx id counter is 5173248 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:31:35 140575465277184 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 15:31:35 140575465277184 [Note] InnoDB: Rolling back trx with id 5172928, 86 rows to undo 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:31:35 140576271046784 [Note] InnoDB: 5.7.20 started; log sequence number 59965243509 2018-01-02 15:31:35 140575302981376 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:31:35 140576271046784 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:31:35 140576271046784 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:31:35 140576271046784 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:31:35 140576271046784 [Note] Recovering after a crash using tc.log 2018-01-02 15:31:35 140576271046784 [Note] Starting crash recovery... 2018-01-02 15:31:35 140576271046784 [Note] Crash recovery finished. 2018-01-02 15:31:35 140575302981376 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:31:35 2018-01-02 15:31:35 140576271046784 [Note] Server socket created on IP: '::'. 2018-01-02 15:31:35 140575465277184 [Note] InnoDB: Rollback of trx with id 5172928 completed 2018-01-02 15:31:35 140575465277184 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 15:31:35 140576159770368 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:31:35 140576271046784 [Note] Reading of all Master_info entries succeded 2018-01-02 15:31:35 140576271046784 [Note] Added new Master_info '' to hash table 2018-01-02 15:31:35 140576271046784 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:31:59 140575757063936 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-01-02 15:31:59 140575757063936 [Note] Event Scheduler: Killing the scheduler thread, thread id 6 2018-01-02 15:31:59 140575757063936 [Note] Event Scheduler: Waiting for the scheduler thread to reply 2018-01-02 15:31:59 140575757063936 [Note] Event Scheduler: Stopped 2018-01-02 15:31:59 140575757063936 [Note] Event Scheduler: Purging the queue. 21 events 2018-01-02 15:31:59 140575344944896 [Note] InnoDB: FTS optimize thread exiting. 2018-01-02 15:31:59 140575757063936 [Note] InnoDB: Starting shutdown... 2018-01-02 15:31:59 140575302981376 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-01-02 15:31:59 140575302981376 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25 2018-01-02 15:31:59 140575302981376 [Note] InnoDB: Buffer pool(s) dump completed at 180102 15:31:59 2018-01-02 15:32:01 140575757063936 [Note] InnoDB: Shutdown completed; log sequence number 60059992594 2018-01-02 15:32:01 140575757063936 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:32:01 140575757063936 [Note] /usr/sbin/mysqld: Shutdown complete 2018-01-02 15:32:01 140363128150144 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Uses event mutexes 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Number of pools: 1 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:32:01 140362329642752 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: Waiting for purge to start 2018-01-02 15:32:01 140363128150144 [Note] InnoDB: 5.7.20 started; log sequence number 60059992594 2018-01-02 15:32:01 140362165229312 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:32:01 140363128150144 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:32:01 140363128150144 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:32:01 140363128150144 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:32:01 140363128150144 [Note] Server socket created on IP: '::'. 2018-01-02 15:32:01 140362621474560 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:32:01 140363128150144 [Note] Reading of all Master_info entries succeded 2018-01-02 15:32:01 140363128150144 [Note] Added new Master_info '' to hash table 2018-01-02 15:32:01 140363128150144 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 15:32:01 140362165229312 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:32:01 2018-01-02 15:32:14 140362620868352 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 15:36:41 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.2.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=999 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fa8600009a8 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 = 0x7fa8b8280d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5560895a9d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55608902d60d] /lib64/libpthread.so.0(+0xf5e0)[0x7fa8d625b5e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x556088f8adf0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x556088f8aed3] mysys/stacktrace.c:268(my_print_stacktrace)[0x556088eeeb17] sql/signal_handler.cc:168(handle_fatal_signal)[0x556088ef34dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x556088e95df8] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x556088ef25bb] sql/sql_select.cc:1086(JOIN::optimize())[0x556088ef345f] sql/sql_select.cc:3695(mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556088ef4b64] sql/sql_select.cc:373(handle_select(THD*, LEX*, select_result*, unsigned long))[0x556088ef5744] sql/sql_parse.cc:4522(mysql_execute_command(THD*))[0x556088ea6918] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556089155db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55608915c059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55608915c625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556089158e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55608915a60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556088e97e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556088ea0c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556089155db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55608915c059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55608915c625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556089158e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55608915a60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556088e97e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556088ea0c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556089155db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55608915c059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55608915c625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556089158e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55608915a60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556088e97e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556088ea0c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x556089155db6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55608915c059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55608915c625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x556089158e0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55608915a60f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x556088e97e66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x556088ea0c0a] sql/sql_parse.cc:7888(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556088ea7b0e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556088eaaaad] sql/sql_parse.cc:1362(do_command(THD*))[0x556088eab6a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x556088f6f05a] sql/sql_connect.cc:1262(handle_one_connection)[0x556088f6f17d] /lib64/libpthread.so.0(+0x7e25)[0x7fa8d6253e25] /lib64/libc.so.6(clone+0x6d)[0x7fa8d482b34d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fa8612af528): INSERT INTO ENTITIES_TO_COPY ( ENTITY_UID, ENTITY_TYPE, ENTITY_SUB_TYPE, COPY_INSTANCE_UID ) SELECT ECD.DOCUMENT_VERSION_UID, 'document', 'event', NAME_CONST('V_COPY_INSTANCE_UID',59831) FROM EVENT_COLLECTION_DOCUMENTS ECD JOIN EVENT_DETAILS ED ON ED.EVENT_COLLECTION_UID = ECD.EVENT_COLLECTION_UID WHERE ED.EVENT_UID = NAME_CONST('V_EVENT_UID',34116) AND ED.ORGANISATION_UID = NAME_CONST('V_SOURCE_ORG_UID',26) AND NOT EXISTS ( SELECT * FROM ENTITIES_TO_COPY ETC WHERE ETC.ENTITY_UID = ECD.DOCUMENT_VERSION_UID AND ETC.COPY_INSTANCE_UID = NAME_CONST('V_COPY_INSTANCE_UID',59831) ) Connection ID (thread ID): 13 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-02 15:36:47 140417103505536 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Uses event mutexes 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Using Linux native AIO 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Number of pools: 1 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 15:36:47 140416310347520 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Starting crash recovery from checkpoint LSN=60155018189 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 11 row operations to undo 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Trx id counter is 5188352 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Starting final batch to recover 16 pages from redo log. 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 15:36:47 140416299837184 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 15:36:47 140416299837184 [Note] InnoDB: Rolling back trx with id 5187977, 11 rows to undo 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 15:36:47 140417103505536 [Note] InnoDB: 5.7.20 started; log sequence number 60155018526 2018-01-02 15:36:47 140415609063168 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 15:36:47 140417103505536 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 15:36:47 140417103505536 [Note] Plugin 'gssapi' is disabled. 2018-01-02 15:36:47 140417103505536 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 15:36:47 140417103505536 [Note] Recovering after a crash using tc.log 2018-01-02 15:36:47 140416299837184 [Note] InnoDB: Rollback of trx with id 5187977 completed 2018-01-02 15:36:47 140416299837184 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 15:36:47 140417103505536 [Note] Starting crash recovery... 2018-01-02 15:36:47 140417103505536 [Note] Crash recovery finished. 2018-01-02 15:36:47 140415609063168 [Note] InnoDB: Buffer pool(s) load completed at 180102 15:36:47 2018-01-02 15:36:47 140417103505536 [Note] Server socket created on IP: '::'. 2018-01-02 15:36:47 140416601253632 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 15:36:47 140417103505536 [Note] Reading of all Master_info entries succeded 2018-01-02 15:36:47 140417103505536 [Note] Added new Master_info '' to hash table 2018-01-02 15:36:47 140417103505536 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 16:23:30 140416600647424 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known 180102 16:24: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.11-MariaDB-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=1 max_threads=999 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2326197 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fb4dc0009a8 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 = 0x7fb5499a1d70 thread_stack 0x49000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55c05b560d6e] /usr/sbin/mysqld(handle_fatal_signal+0x30d)[0x55c05afe460d] /lib64/libpthread.so.0(+0xf5e0)[0x7fb5675445e0] /usr/sbin/mysqld(_ZN13Explain_query10get_selectEj+0x10)[0x55c05af41df0] /usr/sbin/mysqld(_ZN13Explain_query8add_nodeEP12Explain_node+0xa3)[0x55c05af41ed3] /usr/sbin/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xb37)[0x55c05aea5b17] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xbc)[0x55c05aeaa4dc] /usr/sbin/mysqld(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xd8)[0x55c05ae4cdf8] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1cfb)[0x55c05aea95bb] mysys/stacktrace.c:268(my_print_stacktrace)[0x55c05aeaa45f] sql/signal_handler.cc:168(handle_fatal_signal)[0x55c05aeabb64] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x55c05aeac744] sql/sql_select.cc:24874(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x55c05ae5d918] sql/sql_lex.cc:3850(st_select_lex::optimize_unflattened_subqueries(bool))[0x55c05b10cdb6] sql/sql_parse.cc:4522(mysql_execute_command(THD*))[0x55c05b113059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c05b113625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55c05b10fe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55c05b11160f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55c05ae4ee66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55c05ae57c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c05b10cdb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c05b113059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c05b113625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55c05b10fe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55c05b11160f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55c05ae4ee66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55c05ae57c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c05b10cdb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c05b113059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c05b113625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55c05b10fe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55c05b11160f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55c05ae4ee66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55c05ae57c0a] sql/sp_head.cc:3265(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c05b10cdb6] sql/sp_head.cc:3027(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c05b113059] sql/sp_head.cc:3181(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c05b113625] sql/sp_head.cc:1338(sp_head::execute(THD*, bool))[0x55c05b10fe0e] sql/sp_head.cc:2135(sp_head::execute_procedure(THD*, List*))[0x55c05b11160f] sql/sql_parse.cc:2887(do_execute_sp(THD*, sp_head*))[0x55c05ae4ee66] sql/sql_parse.cc:5807(mysql_execute_command(THD*))[0x55c05ae57c0a] sql/sql_parse.cc:7888(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c05ae5eb0e] sql/sql_parse.cc:1805(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c05ae61aad] sql/sql_parse.cc:1362(do_command(THD*))[0x55c05ae626a9] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55c05af2605a] sql/sql_connect.cc:1262(handle_one_connection)[0x55c05af2617d] /lib64/libpthread.so.0(+0x7e25)[0x7fb56753ce25] /lib64/libc.so.6(clone+0x6d)[0x7fb565b1434d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fb4dd031528): INSERT INTO ENTITIES_TO_COPY ( ENTITY_UID, ENTITY_TYPE, ENTITY_SUB_TYPE, COPY_INSTANCE_UID ) SELECT ECD.DOCUMENT_VERSION_UID, 'document', 'event', NAME_CONST('V_COPY_INSTANCE_UID',59831) FROM EVENT_COLLECTION_DOCUMENTS ECD JOIN EVENT_DETAILS ED ON ED.EVENT_COLLECTION_UID = ECD.EVENT_COLLECTION_UID WHERE ED.EVENT_UID = NAME_CONST('V_EVENT_UID',34116) AND ED.ORGANISATION_UID = NAME_CONST('V_SOURCE_ORG_UID',26) AND NOT EXISTS ( SELECT * FROM ENTITIES_TO_COPY ETC WHERE ETC.ENTITY_UID = ECD.DOCUMENT_VERSION_UID AND ETC.COPY_INSTANCE_UID = NAME_CONST('V_COPY_INSTANCE_UID',59831) ) Connection ID (thread ID): 11 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-02 16:25:05 140217913432192 [Note] CONNECT: Version 1.06.0005 October 14, 2017 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Uses event mutexes 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Using Linux native AIO 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Number of pools: 1 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Using SSE2 crc32 instructions 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Completed initialization of buffer pool 2018-01-02 16:25:05 140217114453760 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Starting crash recovery from checkpoint LSN=60250605099 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 11 row operations to undo 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Trx id counter is 5195520 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Starting final batch to recover 16 pages from redo log. 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-01-02 16:25:05 140217106061056 [Note] InnoDB: Starting in background the rollback of recovered transactions 2018-01-02 16:25:05 140217106061056 [Note] InnoDB: Rolling back trx with id 5195176, 11 rows to undo 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-01-02 16:25:05 140217913432192 [Note] InnoDB: 5.7.20 started; log sequence number 60250606865 2018-01-02 16:25:05 140217106061056 [Note] InnoDB: Rollback of trx with id 5195176 completed 2018-01-02 16:25:05 140217106061056 [Note] InnoDB: Rollback of non-prepared transactions completed 2018-01-02 16:25:05 140216941647616 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-01-02 16:25:05 140217913432192 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-02 16:25:05 140217913432192 [Note] Plugin 'gssapi' is disabled. 2018-01-02 16:25:05 140217913432192 [Note] Plugin 'cracklib_password_check' is disabled. 2018-01-02 16:25:05 140217913432192 [Note] Recovering after a crash using tc.log 2018-01-02 16:25:05 140217913432192 [Note] Starting crash recovery... 2018-01-02 16:25:05 140217913432192 [Note] Crash recovery finished. 2018-01-02 16:25:05 140216941647616 [Note] InnoDB: Buffer pool(s) load completed at 180102 16:25:05 2018-01-02 16:25:05 140217913432192 [Note] Server socket created on IP: '::'. 2018-01-02 16:25:05 140217913432192 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired 2018-01-02 16:25:05 140217913432192 [ERROR] mysqld: Table 'event' is marked as crashed and should be repaired 2018-01-02 16:25:05 140217913432192 [Warning] Checking table: './mysql/event' 2018-01-02 16:25:05 140217913432192 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly 2018-01-02 16:25:05 140217798379264 [Note] Event Scheduler: scheduler thread started with id 6 2018-01-02 16:25:05 140217913432192 [Note] Reading of all Master_info entries succeded 2018-01-02 16:25:05 140217913432192 [Note] Added new Master_info '' to hash table 2018-01-02 16:25:05 140217913432192 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.11-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-01-02 16:26:24 140217797773056 [Warning] IP address '192.168.163.130' could not be resolved: Name or service not known