$ (cd mysql-test/; ./mtr --mem --force --max-test-fail=40 --big-test --port-base 15000 --parallel 7 rpl.rpl_non_direct_row_mixing_engines rpl.rpl_non_direct_stm_mixing_engines rpl.rpl_row_mixing_engines rpl.rpl_mixed_mixing_engines rpl.rpl_stm_mixing_engines rpl.rpl_non_direct_mixed_mixing_engines ) Logging: /home/danielgb/mariadb-server-10.2/mysql-test/mysql-test-run.pl --mem --force --max-test-fail=40 --big-test --port-base 15000 --parallel 7 rpl.rpl_non_direct_row_mixing_engines rpl.rpl_non_direct_stm_mixing_engines rpl.rpl_row_mixing_engines rpl.rpl_mixed_mixing_engines rpl.rpl_stm_mixing_engines rpl.rpl_non_direct_mixed_mixing_engines vardir: /home/danielgb/build-mariadb-server-10.2/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/home/danielgb/build-mariadb-server-10.2/mysql-test/var'... - symlinking 'var' to '/dev/shm/var_500_5XoB' Checking supported features... MariaDB Version 10.2.8-MariaDB - SSL connections supported Collecting tests... Installing system database... worker[1] Using MTR_BUILD_THREAD 500, with reserved ports 20000..20019 ============================================================================== TEST WORKER RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[2] Using MTR_BUILD_THREAD 501, with reserved ports 20020..20039 worker[4] Using MTR_BUILD_THREAD 503, with reserved ports 20060..20079 worker[3] Using MTR_BUILD_THREAD 502, with reserved ports 20040..20059 worker[6] Using MTR_BUILD_THREAD 505, with reserved ports 20100..20119 worker[5] Using MTR_BUILD_THREAD 504, with reserved ports 20080..20099 worker[7] Using MTR_BUILD_THREAD 506, with reserved ports 20120..20139 rpl.rpl_non_direct_mixed_mixing_engines 'innodb,mix' w3 [ fail ] Test ended at 2017-08-03 16:38:47 CURRENT_TEST: rpl.rpl_non_direct_mixed_mixing_engines mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc": included from ./extra/rpl_tests/rpl_mixing_engines.test at line 399: included from /home/danielgb/mariadb-server-10.2/mysql-test/suite/rpl/t/rpl_non_direct_mixed_mixing_engines.test at line 15: At line 381: query 'INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1062... The result from queries just before the failure was: < snip > -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1; Got one of the listed errors include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=nTe] -b-b-b-b-b-b-b-b-b-b-b- >> nTe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1; More results from queries before failure can be found in /home/danielgb/build-mariadb-server-10.2/mysql-test/var/3/log/rpl_non_direct_mixed_mixing_engines.log Server [mysqld.1 - pid: 23092, winpid: 23092, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-08-03 16:38:45 140341389772992 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 23096 ... 2017-08-03 16:38:45 140341389772992 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'partition' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Uses event mutexes 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Using Linux native AIO 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Number of pools: 1 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Using SSE2 crc32 instructions 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Completed initialization of buffer pool 2017-08-03 16:38:45 140341101438720 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-03 16:38:45 140341389772992 [Note] InnoDB: 5.7.18 started; log sequence number 1633893 2017-08-03 16:38:45 140340589745920 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_500_5XoB/3/mysqld.1/data/ib_buffer_pool 2017-08-03 16:38:45 140340589745920 [Note] InnoDB: Buffer pool(s) load completed at 170803 16:38:45 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'SEQUENCE' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_CMP' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'FEEDBACK' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'user_variables' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-08-03 16:38:45 140341389772992 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-08-03 16:38:45 140341389772992 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-08-03 16:38:45 140341389772992 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-08-03 16:38:45 140341389772992 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-08-03 16:38:45 140341389772992 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown option '--loose-pam-debug' 2017-08-03 16:38:45 140341389772992 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-08-03 16:38:45 140341389772992 [Note] Server socket created on IP: '127.0.0.1'. 2017-08-03 16:38:45 140341389772992 [Note] Reading of all Master_info entries succeded 2017-08-03 16:38:45 140341389772992 [Note] Added new Master_info '' to hash table 2017-08-03 16:38:45 140341389772992 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/tmp/3/mysqld.1.sock' port: 20040 Source distribution 2017-08-03 16:38:45 140341214340864 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/3/mysqld.1/data/master.info'. 2017-08-03 16:38:45 140341214340864 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/3/mysqld.1/data/relay-log.info'. 2017-08-03 16:38:45 140341213734656 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4) 170803 16:38:46 [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.8-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=14 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fa35c0009a8 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 = 0x7fa3bc2c7cf8 thread_stack 0x49000 /home/danielgb/build-mariadb-server-10.2/sql/mysqld(my_print_stacktrace+0x29)[0x5562933884c9] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(handle_fatal_signal+0x305)[0x556292e82e85] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fa3c4daf390] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_Z16first_linear_tabP4JOIN20enum_with_bush_roots22enum_with_const_tables+0x1d)[0x556292d31d7d] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN13st_select_lex16set_explain_typeEb+0x18f)[0x556292cfa00f] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0x131)[0x556292d4d321] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN8optimizeEv+0xa7)[0x556292d52cb7] mysys/stacktrace.c:268(my_print_stacktrace)[0x556292d8ef11] sql/sql_select.cc:8659(first_linear_tab(JOIN*, enum_with_bush_roots, enum_with_const_tables))[0x556292d8f175] sql/sql_lex.cc:4398(st_select_lex::set_explain_type(bool))[0x556292d92a6c] sql/sql_select.cc:351(handle_select(THD*, LEX*, select_result*, unsigned long))[0x556292d54cd4] sql/sql_parse.cc:4530(mysql_execute_command(THD*))[0x556292d0b30f] sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556292d0bb7d] sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556292d0e6a1] sql/sql_parse.cc:1364(do_command(THD*))[0x556292d0eed1] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x556292dc9244] sql/sql_connect.cc:1262(handle_one_connection)[0x556292dc93b4] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x5562932956c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fa3c4da56ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fa3c42313dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fa35c00efe0): INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1 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. Writing a core file ----------SERVER LOG END------------- - saving '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/3/log/rpl.rpl_non_direct_mixed_mixing_engines-innodb,mix/' to '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_non_direct_mixed_mixing_engines-innodb,mix/' ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_non_direct_mixed_mixing_engines 170803 16:38:46 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out rpl.rpl_stm_mixing_engines 'innodb,stmt' w5 [ fail ] Test ended at 2017-08-03 16:38:47 CURRENT_TEST: rpl.rpl_stm_mixing_engines mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc": included from ./extra/rpl_tests/rpl_mixing_engines.test at line 399: included from /home/danielgb/mariadb-server-10.2/mysql-test/suite/rpl/t/rpl_stm_mixing_engines.test at line 12: At line 381: query 'INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1062... The result from queries just before the failure was: < snip > -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1; Got one of the listed errors include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=nTe] -b-b-b-b-b-b-b-b-b-b-b- >> nTe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1; More results from queries before failure can be found in /home/danielgb/build-mariadb-server-10.2/mysql-test/var/5/log/rpl_stm_mixing_engines.log Server [mysqld.1 - pid: 23098, winpid: 23098, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-08-03 16:38:45 139668058413248 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 23099 ... 2017-08-03 16:38:45 139668058413248 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'partition' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Uses event mutexes 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Using Linux native AIO 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Number of pools: 1 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Using SSE2 crc32 instructions 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Completed initialization of buffer pool 2017-08-03 16:38:45 139667705952000 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: Waiting for purge to start 2017-08-03 16:38:45 139668058413248 [Note] InnoDB: 5.7.18 started; log sequence number 1633893 2017-08-03 16:38:45 139667403945728 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_500_5XoB/5/mysqld.1/data/ib_buffer_pool 2017-08-03 16:38:45 139667403945728 [Note] InnoDB: Buffer pool(s) load completed at 170803 16:38:45 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'SEQUENCE' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_CMP' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'FEEDBACK' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'user_variables' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-08-03 16:38:45 139668058413248 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-08-03 16:38:45 139668058413248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-08-03 16:38:45 139668058413248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-08-03 16:38:45 139668058413248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-08-03 16:38:45 139668058413248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown option '--loose-pam-debug' 2017-08-03 16:38:45 139668058413248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-08-03 16:38:45 139668058413248 [Note] Server socket created on IP: '127.0.0.1'. 2017-08-03 16:38:45 139668058413248 [Note] Reading of all Master_info entries succeded 2017-08-03 16:38:45 139668058413248 [Note] Added new Master_info '' to hash table 2017-08-03 16:38:45 139668058413248 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/tmp/5/mysqld.1.sock' port: 20080 Source distribution 2017-08-03 16:38:45 139667773683456 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/5/mysqld.1/data/master.info'. 2017-08-03 16:38:45 139667773683456 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/5/mysqld.1/data/relay-log.info'. 2017-08-03 16:38:45 139667647203072 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4) 170803 16:38:46 [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.8-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=14 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f068c0009a8 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 = 0x7f06e87adcf8 thread_stack 0x49000 /home/danielgb/build-mariadb-server-10.2/sql/mysqld(my_print_stacktrace+0x29)[0x55674fd154c9] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(handle_fatal_signal+0x305)[0x55674f80fe85] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f06ff2dc390] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_Z16first_linear_tabP4JOIN20enum_with_bush_roots22enum_with_const_tables+0x1d)[0x55674f6bed7d] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN13st_select_lex16set_explain_typeEb+0x18f)[0x55674f68700f] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0x131)[0x55674f6da321] mysys/stacktrace.c:268(my_print_stacktrace)[0x55674f6dfcb7] sql/sql_select.cc:8659(first_linear_tab(JOIN*, enum_with_bush_roots, enum_with_const_tables))[0x55674f71bf11] sql/sql_union.cc:940(st_select_lex_unit::exec())[0x55674f71c175] sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x55674f71fa6c] sql/sql_select.cc:351(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55674f6e1cd4] sql/sql_parse.cc:4530(mysql_execute_command(THD*))[0x55674f69830f] sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55674f698b7d] sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55674f69b6a1] sql/sql_parse.cc:1364(do_command(THD*))[0x55674f69bed1] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55674f756244] sql/sql_connect.cc:1262(handle_one_connection)[0x55674f7563b4] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55674fc226c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f06ff2d26ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f06fe75e3dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f068c00efe0): INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1 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. Writing a core file ----------SERVER LOG END------------- - saving '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/5/log/rpl.rpl_stm_mixing_engines-innodb,stmt/' to '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_stm_mixing_engines-innodb,stmt/' rpl.rpl_non_direct_stm_mixing_engines 'innodb,stmt' w6 [ fail ] Test ended at 2017-08-03 16:38:47 CURRENT_TEST: rpl.rpl_non_direct_stm_mixing_engines mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc": included from ./extra/rpl_tests/rpl_mixing_engines.test at line 399: included from /home/danielgb/mariadb-server-10.2/mysql-test/suite/rpl/t/rpl_non_direct_stm_mixing_engines.test at line 15: At line 381: query 'INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1062... The result from queries just before the failure was: < snip > -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1; Got one of the listed errors include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=nTe] -b-b-b-b-b-b-b-b-b-b-b- >> nTe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1; More results from queries before failure can be found in /home/danielgb/build-mariadb-server-10.2/mysql-test/var/6/log/rpl_non_direct_stm_mixing_engines.log Server [mysqld.1 - pid: 23091, winpid: 23091, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-08-03 16:38:45 139674146605248 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 23097 ... 2017-08-03 16:38:45 139674146605248 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'partition' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Uses event mutexes 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Using Linux native AIO 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Number of pools: 1 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Using SSE2 crc32 instructions 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Completed initialization of buffer pool 2017-08-03 16:38:45 139673796073216 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-03 16:38:45 139674146605248 [Note] InnoDB: 5.7.18 started; log sequence number 1633893 2017-08-03 16:38:45 139673628284672 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_500_5XoB/6/mysqld.1/data/ib_buffer_pool 2017-08-03 16:38:45 139673628284672 [Note] InnoDB: Buffer pool(s) load completed at 170803 16:38:45 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'SEQUENCE' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_CMP' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'FEEDBACK' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'user_variables' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-08-03 16:38:45 139674146605248 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-08-03 16:38:45 139674146605248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-08-03 16:38:45 139674146605248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-08-03 16:38:45 139674146605248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-08-03 16:38:45 139674146605248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown option '--loose-pam-debug' 2017-08-03 16:38:45 139674146605248 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-08-03 16:38:45 139674146605248 [Note] Server socket created on IP: '127.0.0.1'. 2017-08-03 16:38:45 139674146605248 [Note] Reading of all Master_info entries succeded 2017-08-03 16:38:45 139674146605248 [Note] Added new Master_info '' to hash table 2017-08-03 16:38:45 139674146605248 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/tmp/6/mysqld.1.sock' port: 20100 Source distribution 2017-08-03 16:38:45 139673880839936 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/6/mysqld.1/data/master.info'. 2017-08-03 16:38:45 139673880839936 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/6/mysqld.1/data/relay-log.info'. 2017-08-03 16:38:45 139673751992064 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4) 170803 16:38:46 [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.8-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=14 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f07f80009a8 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 = 0x7f08545a8cf8 thread_stack 0x49000 /home/danielgb/build-mariadb-server-10.2/sql/mysqld(my_print_stacktrace+0x29)[0x55eb7e27f4c9] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(handle_fatal_signal+0x305)[0x55eb7dd79e85] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f086a103390] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_Z16first_linear_tabP4JOIN20enum_with_bush_roots22enum_with_const_tables+0x1d)[0x55eb7dc28d7d] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN13st_select_lex16set_explain_typeEb+0x18f)[0x55eb7dbf100f] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0x131)[0x55eb7dc44321] mysys/stacktrace.c:268(my_print_stacktrace)[0x55eb7dc49cb7] sql/sql_select.cc:8659(first_linear_tab(JOIN*, enum_with_bush_roots, enum_with_const_tables))[0x55eb7dc85f11] sql/sql_union.cc:940(st_select_lex_unit::exec())[0x55eb7dc86175] sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x55eb7dc89a6c] sql/sql_select.cc:351(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55eb7dc4bcd4] sql/sql_parse.cc:4530(mysql_execute_command(THD*))[0x55eb7dc0230f] sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55eb7dc02b7d] sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55eb7dc056a1] sql/sql_parse.cc:1364(do_command(THD*))[0x55eb7dc05ed1] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55eb7dcc0244] sql/sql_connect.cc:1262(handle_one_connection)[0x55eb7dcc03b4] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55eb7e18c6c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f086a0f96ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f08695853dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f07f800efe0): INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1 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. Writing a core file ----------SERVER LOG END------------- - saving '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/6/log/rpl.rpl_non_direct_stm_mixing_engines-innodb,stmt/' to '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_non_direct_stm_mixing_engines-innodb,stmt/' ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_stm_mixing_engines 170803 16:38:46 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 24, 1, COUNT(*) FROM nt_1 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: UPDATE nt_3, tt_3 SET nt_3.info= "new text 25 --> 1", tt_3.info= "new text 25 --> 1" where nt_3.trans_id = tt_3.trans_id and tt_3.trans_id = 1 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO nt_4(trans_id, stmt_id) VALUES (26, 1) 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO nt_5(trans_id, stmt_id, info) VALUES (27, 1, fc_i_tt_5_suc(27, 1)) 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: UPDATE tt_4, nt_4 SET tt_4.info= "new text 28 --> 1", nt_4.info= "new text 28 --> 1" where nt_4.trans_id = tt_4.trans_id and tt_4.trans_id = 1 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO tt_3(trans_id, stmt_id) VALUES (29, 1) 2017-08-03 16:38:46 140337120823040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO tt_5(trans_id, stmt_id, info) VALUES (30, 1, fc_i_nt_5_suc(30, 1)) ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_non_direct_stm_mixing_engines 170803 16:38:46 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 24, 1, COUNT(*) FROM nt_1 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: UPDATE nt_3, tt_3 SET nt_3.info= "new text 25 --> 1", tt_3.info= "new text 25 --> 1" where nt_3.trans_id = tt_3.trans_id and tt_3.trans_id = 1 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO nt_4(trans_id, stmt_id) VALUES (26, 1) 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO nt_5(trans_id, stmt_id, info) VALUES (27, 1, fc_i_tt_5_suc(27, 1)) 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: UPDATE tt_4, nt_4 SET tt_4.info= "new text 28 --> 1", nt_4.info= "new text 28 --> 1" where nt_4.trans_id = tt_4.trans_id and tt_4.trans_id = 1 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO tt_3(trans_id, stmt_id) VALUES (29, 1) 2017-08-03 16:38:46 140471872411392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them Statement: INSERT INTO tt_5(trans_id, stmt_id, info) VALUES (30, 1, fc_i_nt_5_suc(30, 1)) rpl.rpl_row_mixing_engines 'innodb,row' w4 [ fail ] Test ended at 2017-08-03 16:38:47 CURRENT_TEST: rpl.rpl_row_mixing_engines mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc": included from ./extra/rpl_tests/rpl_mixing_engines.test at line 399: included from /home/danielgb/mariadb-server-10.2/mysql-test/suite/rpl/t/rpl_row_mixing_engines.test at line 12: At line 381: query 'INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1062... The result from queries just before the failure was: < snip > Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Annotate_rows # # INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Table_map # # table_id: # (test.nt_1) master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Annotate_rows # # INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Table_map # # table_id: # (test.nt_1) master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=nTe] -b-b-b-b-b-b-b-b-b-b-b- >> nTe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1; More results from queries before failure can be found in /home/danielgb/build-mariadb-server-10.2/mysql-test/var/4/log/rpl_row_mixing_engines.log Server [mysqld.1 - pid: 23090, winpid: 23090, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-08-03 16:38:45 139631881156800 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 23095 ... 2017-08-03 16:38:45 139631881156800 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'partition' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Uses event mutexes 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Using Linux native AIO 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Number of pools: 1 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Using SSE2 crc32 instructions 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Completed initialization of buffer pool 2017-08-03 16:38:45 139631525881600 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-03 16:38:45 139631881156800 [Note] InnoDB: 5.7.18 started; log sequence number 1633893 2017-08-03 16:38:45 139631223875328 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_500_5XoB/4/mysqld.1/data/ib_buffer_pool 2017-08-03 16:38:45 139631223875328 [Note] InnoDB: Buffer pool(s) load completed at 170803 16:38:45 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'SEQUENCE' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_CMP' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'FEEDBACK' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'user_variables' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-08-03 16:38:45 139631881156800 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-08-03 16:38:45 139631881156800 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-08-03 16:38:45 139631881156800 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-08-03 16:38:45 139631881156800 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-08-03 16:38:45 139631881156800 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown option '--loose-pam-debug' 2017-08-03 16:38:45 139631881156800 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-08-03 16:38:45 139631881156800 [Note] Server socket created on IP: '127.0.0.1'. 2017-08-03 16:38:45 139631881156800 [Note] Reading of all Master_info entries succeded 2017-08-03 16:38:45 139631881156800 [Note] Added new Master_info '' to hash table 2017-08-03 16:38:45 139631881156800 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/tmp/4/mysqld.1.sock' port: 20060 Source distribution 2017-08-03 16:38:45 139631605032704 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/4/mysqld.1/data/master.info'. 2017-08-03 16:38:45 139631605032704 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/4/mysqld.1/data/relay-log.info'. 2017-08-03 16:38:45 139631604426496 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4) 170803 16:38:46 [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.8-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=14 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7efe200009a8 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 = 0x7efe8429bcf8 thread_stack 0x49000 /home/danielgb/build-mariadb-server-10.2/sql/mysqld(my_print_stacktrace+0x29)[0x5618516c84c9] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(handle_fatal_signal+0x305)[0x5618511c2e85] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7efe92d8a390] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_Z16first_linear_tabP4JOIN20enum_with_bush_roots22enum_with_const_tables+0x1d)[0x561851071d7d] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN13st_select_lex16set_explain_typeEb+0x18f)[0x56185103a00f] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0x131)[0x56185108d321] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN8optimizeEv+0xa7)[0x561851092cb7] mysys/stacktrace.c:268(my_print_stacktrace)[0x5618510cef11] sql/sql_select.cc:8659(first_linear_tab(JOIN*, enum_with_bush_roots, enum_with_const_tables))[0x5618510cf175] sql/sql_lex.cc:4398(st_select_lex::set_explain_type(bool))[0x5618510d2a6c] sql/sql_select.cc:351(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561851094cd4] sql/sql_parse.cc:4530(mysql_execute_command(THD*))[0x56185104b30f] sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56185104bb7d] sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56185104e6a1] sql/sql_parse.cc:1364(do_command(THD*))[0x56185104eed1] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x561851109244] sql/sql_connect.cc:1262(handle_one_connection)[0x5618511093b4] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x5618515d56c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7efe92d806ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7efe9220c3dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7efe2000efe0): INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1 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. Writing a core file ----------SERVER LOG END------------- - saving '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/4/log/rpl.rpl_row_mixing_engines-innodb,row/' to '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_row_mixing_engines-innodb,row/' ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_row_mixing_engines 170803 16:38:46 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out rpl.rpl_non_direct_row_mixing_engines 'innodb,row' w1 [ fail ] Test ended at 2017-08-03 16:38:47 CURRENT_TEST: rpl.rpl_non_direct_row_mixing_engines mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc": included from ./extra/rpl_tests/rpl_mixing_engines.test at line 399: included from /home/danielgb/mariadb-server-10.2/mysql-test/suite/rpl/t/rpl_non_direct_row_mixing_engines.test at line 15: At line 381: query 'INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1062... The result from queries just before the failure was: < snip > Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Annotate_rows # # INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Table_map # # table_id: # (test.nt_1) master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Annotate_rows # # INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Table_map # # table_id: # (test.nt_1) master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=nTe] -b-b-b-b-b-b-b-b-b-b-b- >> nTe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1; More results from queries before failure can be found in /home/danielgb/build-mariadb-server-10.2/mysql-test/var/1/log/rpl_non_direct_row_mixing_engines.log Server [mysqld.1 - pid: 23088, winpid: 23088, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-08-03 16:38:45 140283159926976 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 23094 ... 2017-08-03 16:38:45 140283159926976 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'partition' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Uses event mutexes 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Using Linux native AIO 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Number of pools: 1 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Using SSE2 crc32 instructions 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Completed initialization of buffer pool 2017-08-03 16:38:45 140282809014016 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-03 16:38:45 140283159926976 [Note] InnoDB: 5.7.18 started; log sequence number 1633893 2017-08-03 16:38:45 140282641225472 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_500_5XoB/1/mysqld.1/data/ib_buffer_pool 2017-08-03 16:38:45 140282641225472 [Note] InnoDB: Buffer pool(s) load completed at 170803 16:38:45 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'SEQUENCE' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_CMP' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'FEEDBACK' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'user_variables' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-08-03 16:38:45 140283159926976 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-08-03 16:38:45 140283159926976 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-08-03 16:38:45 140283159926976 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-08-03 16:38:45 140283159926976 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-08-03 16:38:45 140283159926976 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown option '--loose-pam-debug' 2017-08-03 16:38:45 140283159926976 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-08-03 16:38:45 140283159926976 [Note] Server socket created on IP: '127.0.0.1'. 2017-08-03 16:38:45 140283159926976 [Note] Reading of all Master_info entries succeded 2017-08-03 16:38:45 140283159926976 [Note] Added new Master_info '' to hash table 2017-08-03 16:38:45 140283159926976 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/tmp/1/mysqld.1.sock' port: 20000 Source distribution 2017-08-03 16:38:45 140282766141184 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/1/mysqld.1/data/master.info'. 2017-08-03 16:38:45 140282766141184 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/1/mysqld.1/data/relay-log.info'. 2017-08-03 16:38:45 140282765534976 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4) 170803 16:38:46 [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.8-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=14 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f95c40009a8 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 = 0x7f962063bcf8 thread_stack 0x49000 /home/danielgb/build-mariadb-server-10.2/sql/mysqld(my_print_stacktrace+0x29)[0x55ee9f2ba4c9] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(handle_fatal_signal+0x305)[0x55ee9edb4e85] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f9636160390] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_Z16first_linear_tabP4JOIN20enum_with_bush_roots22enum_with_const_tables+0x1d)[0x55ee9ec63d7d] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN13st_select_lex16set_explain_typeEb+0x18f)[0x55ee9ec2c00f] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0x131)[0x55ee9ec7f321] mysys/stacktrace.c:268(my_print_stacktrace)[0x55ee9ec84cb7] sql/sql_select.cc:8659(first_linear_tab(JOIN*, enum_with_bush_roots, enum_with_const_tables))[0x55ee9ecc0f11] sql/sql_union.cc:940(st_select_lex_unit::exec())[0x55ee9ecc1175] sql/sql_union.cc:41(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x55ee9ecc4a6c] sql/sql_select.cc:351(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55ee9ec86cd4] sql/sql_parse.cc:4530(mysql_execute_command(THD*))[0x55ee9ec3d30f] sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55ee9ec3db7d] sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55ee9ec406a1] sql/sql_parse.cc:1364(do_command(THD*))[0x55ee9ec40ed1] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55ee9ecfb244] sql/sql_connect.cc:1262(handle_one_connection)[0x55ee9ecfb3b4] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55ee9f1c76c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f96361566ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f96355e23dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f95c400efe0): INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1 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. Writing a core file ----------SERVER LOG END------------- - saving '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/1/log/rpl.rpl_non_direct_row_mixing_engines-innodb,row/' to '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_non_direct_row_mixing_engines-innodb,row/' ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_non_direct_row_mixing_engines 170803 16:38:46 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out rpl.rpl_mixed_mixing_engines 'innodb,mix' w2 [ fail ] Test ended at 2017-08-03 16:38:47 CURRENT_TEST: rpl.rpl_mixed_mixing_engines mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc": included from ./extra/rpl_tests/rpl_mixing_engines.test at line 399: included from /home/danielgb/mariadb-server-10.2/mysql-test/suite/rpl/t/rpl_mixed_mixing_engines.test at line 12: At line 381: query 'INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1062... The result from queries just before the failure was: < snip > -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1; Got one of the listed errors include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> tNe << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# master-bin.000001 # Query # # use `test`; INSERT INTO nt_1(trans_id, stmt_id, info) SELECT 31, 1, COUNT(*) FROM tt_1 UNION SELECT 23, 1, COUNT(*) FROM tt_1 master-bin.000001 # Query # # COMMIT -e-e-e-e-e-e-e-e-e-e-e- >> tNe << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=nTe] -b-b-b-b-b-b-b-b-b-b-b- >> nTe << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1; More results from queries before failure can be found in /home/danielgb/build-mariadb-server-10.2/mysql-test/var/2/log/rpl_mixed_mixing_engines.log Server [mysqld.1 - pid: 23089, winpid: 23089, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-08-03 16:38:45 139639683492032 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 23093 ... 2017-08-03 16:38:45 139639683492032 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162) 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'partition' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Uses event mutexes 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Using Linux native AIO 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Number of pools: 1 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Using SSE2 crc32 instructions 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Completed initialization of buffer pool 2017-08-03 16:38:45 139639318902528 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: 128 out of 128 rollback segments are active. 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-08-03 16:38:45 139639683492032 [Note] InnoDB: 5.7.18 started; log sequence number 1633893 2017-08-03 16:38:45 139639025288960 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_500_5XoB/2/mysqld.1/data/ib_buffer_pool 2017-08-03 16:38:45 139639025288960 [Note] InnoDB: Buffer pool(s) load completed at 170803 16:38:45 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'SEQUENCE' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_CMP' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'FEEDBACK' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'user_variables' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2017-08-03 16:38:45 139639683492032 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2017-08-03 16:38:45 139639683492032 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2017-08-03 16:38:45 139639683492032 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2017-08-03 16:38:45 139639683492032 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2017-08-03 16:38:45 139639683492032 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown option '--loose-pam-debug' 2017-08-03 16:38:45 139639683492032 [Warning] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2017-08-03 16:38:45 139639683492032 [Note] Server socket created on IP: '127.0.0.1'. 2017-08-03 16:38:45 139639683492032 [Note] Reading of all Master_info entries succeded 2017-08-03 16:38:45 139639683492032 [Note] Added new Master_info '' to hash table 2017-08-03 16:38:45 139639683492032 [Note] /home/danielgb/build-mariadb-server-10.2/sql/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/tmp/2/mysqld.1.sock' port: 20020 Source distribution 2017-08-03 16:38:45 139639525054208 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/2/mysqld.1/data/master.info'. 2017-08-03 16:38:45 139639525054208 [Note] Deleted Master_info file '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/2/mysqld.1/data/relay-log.info'. 2017-08-03 16:38:45 139639524448000 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4) 170803 16:38:46 [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.8-MariaDB-log key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=7 max_threads=153 thread_count=14 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7efff00009a8 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 = 0x7f005c3bacf8 thread_stack 0x49000 /home/danielgb/build-mariadb-server-10.2/sql/mysqld(my_print_stacktrace+0x29)[0x55dcb65064c9] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(handle_fatal_signal+0x305)[0x55dcb6000e85] /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f0063e6d390] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_Z16first_linear_tabP4JOIN20enum_with_bush_roots22enum_with_const_tables+0x1d)[0x55dcb5eafd7d] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN13st_select_lex16set_explain_typeEb+0x18f)[0x55dcb5e7800f] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0x131)[0x55dcb5ecb321] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN4JOIN8optimizeEv+0xa7)[0x55dcb5ed0cb7] /home/danielgb/build-mariadb-server-10.2/sql/mysqld(_ZN18st_select_lex_unit8optimizeEv+0x171)[0x55dcb5f0cf11] mysys/stacktrace.c:268(my_print_stacktrace)[0x55dcb5f0d175] sql/signal_handler.cc:168(handle_fatal_signal)[0x55dcb5f10a6c] sql/sql_lex.cc:4398(st_select_lex::set_explain_type(bool))[0x55dcb5ed2cd4] sql/sql_parse.cc:4530(mysql_execute_command(THD*))[0x55dcb5e8930f] sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55dcb5e89b7d] sql/sql_parse.cc:1817(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55dcb5e8c6a1] sql/sql_parse.cc:1364(do_command(THD*))[0x55dcb5e8ced1] sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55dcb5f47244] sql/sql_connect.cc:1262(handle_one_connection)[0x55dcb5f473b4] perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55dcb64136c4] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f0063e636ba] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f00632ef3dd] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7efff000efe0): INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1 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. Writing a core file ----------SERVER LOG END------------- - saving '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/2/log/rpl.rpl_mixed_mixing_engines-innodb,mix/' to '/home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_mixed_mixing_engines-innodb,mix/' - found 'core' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace from coredump /home/danielgb/build-mariadb-server-10.2/mysql-test/var/log/rpl.rpl_mixed_mixing_engines-innodb,mix/mysqld.1/data/core Core generated by '/home/danielgb/build-mariadb-server-10.2/sql/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 23592] [New LWP 23141] [New LWP 23143] [New LWP 23130] [New LWP 23193] [New LWP 23142] [New LWP 23114] [New LWP 23228] [New LWP 23144] [New LWP 23145] [New LWP 23146] [New LWP 23147] [New LWP 23163] [New LWP 23164] [New LWP 23165] [New LWP 23181] [New LWP 23182] [New LWP 23184] [New LWP 23203] [New LWP 23215] [New LWP 23229] [New LWP 23230] [New LWP 23233] [New LWP 23341] [New LWP 23352] [New LWP 23457] [New LWP 23528] [New LWP 23534] [New LWP 23594] [New LWP 23206] [New LWP 23093] [New LWP 23212] [New LWP 23642] [New LWP 23524] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/home/danielgb/build-mariadb-server-10.2/sql/mysqld --defaults-group-suffix=.1'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __pthread_kill (threadid=, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 62 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory. [Current thread is 1 (Thread 0x7f005c3bb700 (LWP 23592))] #0 __pthread_kill (threadid=, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x000055dcb65060ea in my_write_core (sig=sig@entry=11) at /home/danielgb/mariadb-server-10.2/mysys/stacktrace.c:477 #2 0x000055dcb6000f24 in handle_fatal_signal (sig=11) at /home/danielgb/mariadb-server-10.2/sql/signal_handler.cc:299 #3 #4 first_linear_tab (join=0x7efff00120f8, include_bush_roots=include_bush_roots@entry=WITHOUT_BUSH_ROOTS, const_tbls=const_tbls@entry=WITH_CONST_TABLES) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:8659 #5 0x000055dcb5e7800f in st_select_lex::set_explain_type (this=0x7efff0010460, on_the_fly=on_the_fly@entry=true) at /home/danielgb/mariadb-server-10.2/sql/sql_lex.cc:4399 #6 0x000055dcb5ecb321 in JOIN::save_explain_data_intern (this=this@entry=0x7efff00120f8, output=0x7efff0012c80, need_tmp_table_arg=, need_order_arg=, distinct_arg=, message=0x55dcb6559074 "Select tables optimized away") at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:24674 #7 0x000055dcb5ecbd32 in JOIN::save_explain_data (this=this@entry=0x7efff00120f8, output=, can_overwrite=can_overwrite@entry=false, need_tmp_table=, need_order=, distinct=) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:3240 #8 0x000055dcb5ed0cb7 in JOIN::optimize (this=0x7efff00120f8) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:1093 #9 0x000055dcb5f0cf11 in st_select_lex_unit::optimize (this=this@entry=0x7efff0004350) at /home/danielgb/mariadb-server-10.2/sql/sql_union.cc:906 #10 0x000055dcb5f0d175 in st_select_lex_unit::exec (this=this@entry=0x7efff0004350) at /home/danielgb/mariadb-server-10.2/sql/sql_union.cc:940 #11 0x000055dcb5f10a6c in mysql_union (thd=thd@entry=0x7efff00009a8, lex=lex@entry=0x7efff0004288, result=result@entry=0x7efff0011648, unit=unit@entry=0x7efff0004350, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /home/danielgb/mariadb-server-10.2/sql/sql_union.cc:41 #12 0x000055dcb5ed2cd4 in handle_select (thd=thd@entry=0x7efff00009a8, lex=lex@entry=0x7efff0004288, result=result@entry=0x7efff0011648, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:351 #13 0x000055dcb5e8930f in mysql_execute_command (thd=thd@entry=0x7efff00009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:4523 #14 0x000055dcb5e89b7d in mysql_parse (thd=0x7efff00009a8, rawbuf=, length=113, parser_state=0x7f005c3ba0d0, is_com_multi=, is_next_command=) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:7879 #15 0x000055dcb5e8c6a1 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7efff00009a8, packet=packet@entry=0x7efff0006ca9 "INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1", packet_length=packet_length@entry=113, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1817 #16 0x000055dcb5e8ced1 in do_command (thd=0x7efff00009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1362 #17 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #18 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #19 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81c2678) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #20 0x00007f0063e636ba in start_thread (arg=0x7f005c3bb700) at pthread_create.c:333 #21 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 34 (Thread 0x7f005c499700 (LWP 23524)): #0 0x00007f00632e370d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055dcb65435c0 in poll (__timeout=28800000, __nfds=1, __fds=0x7f005c498660) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46 #2 vio_io_wait (vio=vio@entry=0x55dcb86e9878, event=event@entry=VIO_IO_EVENT_READ, timeout=28800000) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:945 #3 0x000055dcb6543648 in vio_socket_io_wait (vio=vio@entry=0x55dcb86e9878, event=event@entry=VIO_IO_EVENT_READ) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:108 #4 0x000055dcb6543741 in vio_read (vio=0x55dcb86e9878, buf=0x7f0004006ca8 "\001", size=4) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:184 #5 0x000055dcb5e04bfe in my_real_read (net=0x7f0004000be8, complen=complen@entry=0x7f005c498838, header=header@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:888 #6 0x000055dcb5e05979 in my_net_read_packet_reallen (net=net@entry=0x7f0004000be8, read_from_server=read_from_server@entry=1 '\001', reallen=reallen@entry=0x7f005c498888) at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1158 #7 0x000055dcb5e05aab in my_net_read_packet (net=net@entry=0x7f0004000be8, read_from_server=read_from_server@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1142 #8 0x000055dcb5e8ce3c in do_command (thd=0x7f00040009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1244 #9 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #10 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #11 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb86e9bd8) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #12 0x00007f0063e636ba in start_thread (arg=0x7f005c499700) at pthread_create.c:333 #13 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 33 (Thread 0x7f005c327700 (LWP 23642)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb5dfb36c in inline_mysql_cond_timedwait (src_file=0x55dcb6545cc8 "/home/danielgb/mariadb-server-10.2/sql/mysqld.cc", src_line=2957, abstime=0x7f005c326c60, mutex=0x55dcb6d8f1a0 , that=0x55dcb6d917a0 ) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1175 #2 cache_thread (thd=0x7effe80009a8) at /home/danielgb/mariadb-server-10.2/sql/mysqld.cc:2956 #3 one_thread_per_connection_end (thd=0x7effe80009a8, put_in_cache=) at /home/danielgb/mariadb-server-10.2/sql/mysqld.cc:3045 #4 0x000055dcb5f471c3 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1373 #5 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #6 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb8184c38) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #7 0x00007f0063e636ba in start_thread (arg=0x7f005c327700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 32 (Thread 0x7f003effd700 (LWP 23212)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb61d7396 in os_event::wait (this=0x55dcb82db5c0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (this=0x55dcb82db5c0, reset_sig_count=56, reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:336 #3 0x000055dcb61d7835 in os_event_wait_low (event=, reset_sig_count=reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:535 #4 0x000055dcb626a353 in srv_resume_thread (slot=slot@entry=0x55dcb6d0e5a8 , sig_count=sig_count@entry=0, wait=wait@entry=true, timeout_usec=timeout_usec@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:946 #5 0x000055dcb626fd8d in srv_worker_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2649 #6 0x00007f0063e636ba in start_thread (arg=0x7f003effd700) at pthread_create.c:333 #7 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 31 (Thread 0x7f0065bb28c0 (LWP 23093)): #0 0x00007f00632e370d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x00007f006330107e in __poll_chk (fds=, nfds=, timeout=, fdslen=) at poll_chk.c:27 #2 0x000055dcb5dfc279 in poll (__timeout=-1, __nfds=2, __fds=0x7ffc2c88cd50) at /usr/include/x86_64-linux-gnu/bits/poll2.h:41 #3 handle_connections_sockets () at /home/danielgb/mariadb-server-10.2/sql/mysqld.cc:6574 #4 0x000055dcb5e03a07 in mysqld_main (argc=147, argv=0x55dcb80875c8) at /home/danielgb/mariadb-server-10.2/sql/mysqld.cc:6040 #5 0x00007f0063208830 in __libc_start_main (main=0x55dcb5de2e50 , argc=25, argv=0x7ffc2c88d468, init=, fini=, rtld_fini=, stack_end=0x7ffc2c88d458) at ../csu/libc-start.c:291 #6 0x000055dcb5df7429 in _start () Thread 30 (Thread 0x7f003f7fe700 (LWP 23206)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb61d7396 in os_event::wait (this=0x55dcb82db4c0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (this=0x55dcb82db4c0, reset_sig_count=89, reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:336 #3 0x000055dcb61d7835 in os_event_wait_low (event=, reset_sig_count=reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:535 #4 0x000055dcb626a353 in srv_resume_thread (slot=slot@entry=0x55dcb6d0e538 , sig_count=sig_count@entry=0, wait=wait@entry=true, timeout_usec=timeout_usec@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:946 #5 0x000055dcb626fd8d in srv_worker_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2649 #6 0x00007f0063e636ba in start_thread (arg=0x7f003f7fe700) at pthread_create.c:333 #7 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 29 (Thread 0x7f005c371700 (LWP 23594)): #0 0x00007f00632e370d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055dcb65435c0 in poll (__timeout=28800000, __nfds=1, __fds=0x7f005c370660) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46 #2 vio_io_wait (vio=vio@entry=0x55dcb81c2678, event=event@entry=VIO_IO_EVENT_READ, timeout=28800000) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:945 #3 0x000055dcb6543648 in vio_socket_io_wait (vio=vio@entry=0x55dcb81c2678, event=event@entry=VIO_IO_EVENT_READ) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:108 #4 0x000055dcb6543741 in vio_read (vio=0x55dcb81c2678, buf=0x7efff4006ca8 "\001", size=4) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:184 #5 0x000055dcb5e04bfe in my_real_read (net=0x7efff4000be8, complen=complen@entry=0x7f005c370838, header=header@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:888 #6 0x000055dcb5e05979 in my_net_read_packet_reallen (net=net@entry=0x7efff4000be8, read_from_server=read_from_server@entry=1 '\001', reallen=reallen@entry=0x7f005c370888) at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1158 #7 0x000055dcb5e05aab in my_net_read_packet (net=net@entry=0x7efff4000be8, read_from_server=read_from_server@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1142 #8 0x000055dcb5e8ce3c in do_command (thd=0x7efff40009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1244 #9 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #10 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #11 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81c29d8) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #12 0x00007f0063e636ba in start_thread (arg=0x7f005c371700) at pthread_create.c:333 #13 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 28 (Thread 0x7f005c405700 (LWP 23534)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb60bb74d in inline_mysql_cond_timedwait (src_file=0x55dcb65d49e0 "/home/danielgb/mariadb-server-10.2/sql/log.cc", src_line=8111, abstime=0x7f005c400b50, mutex=0x55dcb6db78c8 , that=0x55dcb6db7960 ) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1175 #2 MYSQL_BIN_LOG::wait_for_update_binlog_end_pos (this=this@entry=0x55dcb6db7460 , thd=0x7efffc0009a8, timeout=timeout@entry=0x7f005c400b50) at /home/danielgb/mariadb-server-10.2/sql/log.cc:8111 #3 0x000055dcb5e9db7d in wait_new_events (end_pos_ptr=, binlog_end_pos_filename=0x7f005c400be0 "./master-bin.000001", linfo=0x7f005c402530, info=0x7f005c402780) at /home/danielgb/mariadb-server-10.2/sql/sql_repl.cc:2466 #4 get_binlog_end_pos (info=info@entry=0x7f005c402780, log=log@entry=0x7f005c401350, linfo=linfo@entry=0x7f005c402530) at /home/danielgb/mariadb-server-10.2/sql/sql_repl.cc:2586 #5 0x000055dcb5e9fe0e in send_one_binlog_file (start_pos=, linfo=0x7f005c402530, log=0x7f005c401350, info=0x7f005c402780) at /home/danielgb/mariadb-server-10.2/sql/sql_repl.cc:2745 #6 mysql_binlog_send (thd=thd@entry=0x7efffc0009a8, log_ident=, pos=, flags=flags@entry=2) at /home/danielgb/mariadb-server-10.2/sql/sql_repl.cc:2878 #7 0x000055dcb5e8bcd9 in dispatch_command (command=command@entry=COM_BINLOG_DUMP, thd=thd@entry=0x7efffc0009a8, packet=packet@entry=0x7efffc006ca9 "", packet_length=packet_length@entry=27, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:2065 #8 0x000055dcb5e8ced1 in do_command (thd=0x7efffc0009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1362 #9 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #10 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #11 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81c2318) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #12 0x00007f0063e636ba in start_thread (arg=0x7f005c405700) at pthread_create.c:333 #13 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 27 (Thread 0x7f005c44f700 (LWP 23528)): #0 0x00007f00632e370d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055dcb65435c0 in poll (__timeout=28800000, __nfds=1, __fds=0x7f005c44e660) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46 #2 vio_io_wait (vio=vio@entry=0x55dcb86e9bd8, event=event@entry=VIO_IO_EVENT_READ, timeout=28800000) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:945 #3 0x000055dcb6543648 in vio_socket_io_wait (vio=vio@entry=0x55dcb86e9bd8, event=event@entry=VIO_IO_EVENT_READ) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:108 #4 0x000055dcb6543741 in vio_read (vio=0x55dcb86e9bd8, buf=0x7efff8006ca8 "\001", size=4) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:184 #5 0x000055dcb5e04bfe in my_real_read (net=0x7efff8000be8, complen=complen@entry=0x7f005c44e838, header=header@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:888 #6 0x000055dcb5e05979 in my_net_read_packet_reallen (net=net@entry=0x7efff8000be8, read_from_server=read_from_server@entry=1 '\001', reallen=reallen@entry=0x7f005c44e888) at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1158 #7 0x000055dcb5e05aab in my_net_read_packet (net=net@entry=0x7efff8000be8, read_from_server=read_from_server@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1142 #8 0x000055dcb5e8ce3c in do_command (thd=0x7efff80009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1244 #9 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #10 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #11 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb86e9f38) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #12 0x00007f0063e636ba in start_thread (arg=0x7f005c44f700) at pthread_create.c:333 #13 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 26 (Thread 0x7f005c4e3700 (LWP 23457)): #0 0x00007f00632e370d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055dcb65435c0 in poll (__timeout=28800000, __nfds=1, __fds=0x7f005c4e2660) at /usr/include/x86_64-linux-gnu/bits/poll2.h:46 #2 vio_io_wait (vio=vio@entry=0x55dcb86e9678, event=event@entry=VIO_IO_EVENT_READ, timeout=28800000) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:945 #3 0x000055dcb6543648 in vio_socket_io_wait (vio=vio@entry=0x55dcb86e9678, event=event@entry=VIO_IO_EVENT_READ) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:108 #4 0x000055dcb6543741 in vio_read (vio=0x55dcb86e9678, buf=0x7f0000006ca8 "\001", size=4) at /home/danielgb/mariadb-server-10.2/vio/viosocket.c:184 #5 0x000055dcb5e04bfe in my_real_read (net=0x7f0000000be8, complen=complen@entry=0x7f005c4e2838, header=header@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:888 #6 0x000055dcb5e05979 in my_net_read_packet_reallen (net=net@entry=0x7f0000000be8, read_from_server=read_from_server@entry=1 '\001', reallen=reallen@entry=0x7f005c4e2888) at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1158 #7 0x000055dcb5e05aab in my_net_read_packet (net=net@entry=0x7f0000000be8, read_from_server=read_from_server@entry=1 '\001') at /home/danielgb/mariadb-server-10.2/sql/net_serv.cc:1142 #8 0x000055dcb5e8ce3c in do_command (thd=0x7f00000009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1244 #9 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #10 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #11 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb86e9878) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #12 0x00007f0063e636ba in start_thread (arg=0x7f005c4e3700) at pthread_create.c:333 #13 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 25 (Thread 0x7f005c52d700 (LWP 23352)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb5e1567f in inline_mysql_cond_wait (src_file=0x55dcb654f718 "/home/danielgb/mariadb-server-10.2/sql/slave.cc", src_line=334, mutex=, that=) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1138 #2 handle_slave_background (arg=arg@entry=0x0) at /home/danielgb/mariadb-server-10.2/sql/slave.cc:334 #3 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb873c798) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #4 0x00007f0063e636ba in start_thread (arg=0x7f005c52d700) at pthread_create.c:333 #5 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 24 (Thread 0x7f005c577700 (LWP 23341)): #0 do_sigwait (sig=0x7f005c576c48, set=) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 __sigwait (set=set@entry=0x7f005c576ca0, sig=sig@entry=0x7f005c576c48) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x000055dcb5dfa163 in signal_hand (arg=arg@entry=0x0) at /home/danielgb/mariadb-server-10.2/sql/mysqld.cc:3494 #3 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb86e2688) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #4 0x00007f0063e636ba in start_thread (arg=0x7f005c577700) at pthread_create.c:333 #5 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 23 (Thread 0x7f005c5c1700 (LWP 23233)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb60be70d in inline_mysql_cond_wait (src_file=0x55dcb65d49e0 "/home/danielgb/mariadb-server-10.2/sql/log.cc", src_line=9619, mutex=0x55dcb6db8078 , that=0x55dcb6db80a8 ) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1138 #2 binlog_background_thread (arg=arg@entry=0x0) at /home/danielgb/mariadb-server-10.2/sql/log.cc:9619 #3 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81cdd78) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #4 0x00007f0063e636ba in start_thread (arg=0x7f005c5c1700) at pthread_create.c:333 #5 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 22 (Thread 0x7f003cff9700 (LWP 23230)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb6155102 in inline_mysql_cond_wait (src_file=0x55dcb65db720 "/home/danielgb/mariadb-server-10.2/storage/innobase/handler/ha_innodb.cc", src_line=350, mutex=0x7f003cff8cd0, that=0x7f003cff8d00) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1149 #2 thd_destructor_proxy () at /home/danielgb/mariadb-server-10.2/storage/innobase/handler/ha_innodb.cc:350 #3 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb86bea48) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #4 0x00007f0063e636ba in start_thread (arg=0x7f003cff9700) at pthread_create.c:333 #5 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 21 (Thread 0x7f003d7fa700 (LWP 23229)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb61d7396 in os_event::wait (this=0x55dcb82db840) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (this=0x55dcb82db840, reset_sig_count=1, reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:336 #3 0x000055dcb61d7835 in os_event_wait_low (event=, reset_sig_count=reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:535 #4 0x000055dcb6307a2f in buf_resize_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/buf/buf0buf.cc:3085 #5 0x00007f0063e636ba in start_thread (arg=0x7f003d7fa700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 20 (Thread 0x7f003e7fc700 (LWP 23215)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb61d7396 in os_event::wait (this=0x55dcb82db740) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (this=0x55dcb82db740, reset_sig_count=1, reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:336 #3 0x000055dcb61d7835 in os_event_wait_low (event=, reset_sig_count=reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:535 #4 0x000055dcb6310fa6 in buf_dump_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/buf/buf0dump.cc:815 #5 0x00007f0063e636ba in start_thread (arg=0x7f003e7fc700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 19 (Thread 0x7f0037fff700 (LWP 23203)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb61d7396 in os_event::wait (this=0x55dcb82db540) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (this=0x55dcb82db540, reset_sig_count=58, reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:336 #3 0x000055dcb61d7835 in os_event_wait_low (event=, reset_sig_count=reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:535 #4 0x000055dcb626a353 in srv_resume_thread (slot=slot@entry=0x55dcb6d0e570 , sig_count=sig_count@entry=0, wait=wait@entry=true, timeout_usec=timeout_usec@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:946 #5 0x000055dcb626fd8d in srv_worker_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2649 #6 0x00007f0063e636ba in start_thread (arg=0x7f0037fff700) at pthread_create.c:333 #7 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 18 (Thread 0x7f004cff9700 (LWP 23184)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb61d7251 in os_event::timed_wait (this=this@entry=0x55dcb86bda30, abstime=abstime@entry=0x7f004cff8aa0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:286 #2 0x000055dcb61d74c1 in os_event::wait_time_low (this=0x55dcb86bda30, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=reset_sig_count@entry=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:413 #3 0x000055dcb61d7825 in os_event_wait_time_low (event=, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=reset_sig_count@entry=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:518 #4 0x000055dcb62c7dd7 in ib_wqueue_timedwait (wq=wq@entry=0x55dcb86a9c30, wait_in_usecs=wait_in_usecs@entry=5000000) at /home/danielgb/mariadb-server-10.2/storage/innobase/ut/ut0wqueue.cc:163 #5 0x000055dcb63b81da in fts_optimize_thread (arg=0x55dcb86a9c30) at /home/danielgb/mariadb-server-10.2/storage/innobase/fts/fts0opt.cc:3041 #6 0x00007f0063e636ba in start_thread (arg=0x7f004cff9700) at pthread_create.c:333 #7 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 17 (Thread 0x7f004d7fa700 (LWP 23182)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb61d7251 in os_event::timed_wait (this=this@entry=0x55dcb8913650, abstime=abstime@entry=0x7f004d7f9c20) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:286 #2 0x000055dcb61d74c1 in os_event::wait_time_low (this=0x55dcb8913650, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=1, reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:413 #3 0x000055dcb61d7825 in os_event_wait_time_low (event=, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=reset_sig_count@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:518 #4 0x000055dcb6367047 in dict_stats_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/dict/dict0stats_bg.cc:451 #5 0x00007f0063e636ba in start_thread (arg=0x7f004d7fa700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 16 (Thread 0x7f004f7fe700 (LWP 23181)): #0 0x00007f0063e6cc1d in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055dcb61d79fc in os_thread_sleep (tm=tm@entry=1000000) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0thread.cc:230 #2 0x000055dcb626f61c in srv_master_sleep () at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2460 #3 srv_master_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2505 #4 0x00007f0063e636ba in start_thread (arg=0x7f004f7fe700) at pthread_create.c:333 #5 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 15 (Thread 0x7f004dffb700 (LWP 23165)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb61d7251 in os_event::timed_wait (this=this@entry=0x55dcb82db6c0, abstime=abstime@entry=0x7f004dffad10) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:286 #2 0x000055dcb61d74c1 in os_event::wait_time_low (this=0x55dcb82db6c0, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:413 #3 0x000055dcb61d7825 in os_event_wait_time_low (event=, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:518 #4 0x000055dcb626f164 in srv_monitor_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:1746 #5 0x00007f0063e636ba in start_thread (arg=0x7f004dffb700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 14 (Thread 0x7f004e7fc700 (LWP 23164)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb61d7251 in os_event::timed_wait (this=this@entry=0x55dcb82db640, abstime=abstime@entry=0x7f004e7fbae0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:286 #2 0x000055dcb61d74c1 in os_event::wait_time_low (this=0x55dcb82db640, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:413 #3 0x000055dcb61d7825 in os_event_wait_time_low (event=, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:518 #4 0x000055dcb626e312 in srv_error_monitor_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:1971 #5 0x00007f0063e636ba in start_thread (arg=0x7f004e7fc700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 13 (Thread 0x7f004effd700 (LWP 23163)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb61d7251 in os_event::timed_wait (this=this@entry=0x55dcb88e03d0, abstime=abstime@entry=0x7f004effcbf0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:286 #2 0x000055dcb61d74c1 in os_event::wait_time_low (this=this@entry=0x55dcb88e03d0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:413 #3 0x000055dcb61d7825 in os_event_wait_time_low (event=event@entry=0x55dcb88e03d0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:518 #4 0x000055dcb61a7d22 in lock_wait_timeout_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/lock/lock0wait.cc:530 #5 0x00007f0063e636ba in start_thread (arg=0x7f004effd700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 12 (Thread 0x7f004ffff700 (LWP 23147)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb61d7251 in os_event::timed_wait (this=this@entry=0x55dcb82db7c0, abstime=abstime@entry=0x7f004fffe990) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:286 #2 0x000055dcb61d74c1 in os_event::wait_time_low (this=0x55dcb82db7c0, time_in_usec=, reset_sig_count=reset_sig_count@entry=2) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:413 #3 0x000055dcb61d7825 in os_event_wait_time_low (event=, time_in_usec=, reset_sig_count=reset_sig_count@entry=2) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:518 #4 0x000055dcb631a814 in pc_sleep_if_needed (sig_count=2, next_loop_time=1501742327177) at /home/danielgb/mariadb-server-10.2/storage/innobase/buf/buf0flu.cc:2722 #5 buf_flush_page_cleaner_coordinator () at /home/danielgb/mariadb-server-10.2/storage/innobase/buf/buf0flu.cc:3217 #6 0x00007f0063e636ba in start_thread (arg=0x7f004ffff700) at pthread_create.c:333 #7 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 11 (Thread 0x7f0054fc6700 (LWP 23146)): #0 0x00007f00651f764a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055dcb61ccca9 in LinuxAIOHandler::collect (this=this@entry=0x7f0054fc5b00) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:1883 #2 0x000055dcb61d2b2c in LinuxAIOHandler::poll (this=this@entry=0x7f0054fc5b00, m1=m1@entry=0x7f0054fc5ba0, m2=m2@entry=0x7f0054fc5ba8, request=request@entry=0x7f0054fc5bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2028 #3 0x000055dcb61d6673 in os_aio_linux_handler (request=0x7f0054fc5bb0, m2=0x7f0054fc5ba8, m1=0x7f0054fc5ba0, global_segment=5) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2082 #4 os_aio_handler (segment=segment@entry=5, m1=m1@entry=0x7f0054fc5ba0, m2=m2@entry=0x7f0054fc5ba8, request=request@entry=0x7f0054fc5bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:5652 #5 0x000055dcb6370e86 in fil_aio_wait (segment=segment@entry=5) at /home/danielgb/mariadb-server-10.2/storage/innobase/fil/fil0fil.cc:5435 #6 0x000055dcb6271328 in io_handler_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:343 #7 0x00007f0063e636ba in start_thread (arg=0x7f0054fc6700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 10 (Thread 0x7f00557c7700 (LWP 23145)): #0 0x00007f00651f764a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055dcb61ccca9 in LinuxAIOHandler::collect (this=this@entry=0x7f00557c6b00) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:1883 #2 0x000055dcb61d2b2c in LinuxAIOHandler::poll (this=this@entry=0x7f00557c6b00, m1=m1@entry=0x7f00557c6ba0, m2=m2@entry=0x7f00557c6ba8, request=request@entry=0x7f00557c6bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2028 #3 0x000055dcb61d6673 in os_aio_linux_handler (request=0x7f00557c6bb0, m2=0x7f00557c6ba8, m1=0x7f00557c6ba0, global_segment=4) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2082 #4 os_aio_handler (segment=segment@entry=4, m1=m1@entry=0x7f00557c6ba0, m2=m2@entry=0x7f00557c6ba8, request=request@entry=0x7f00557c6bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:5652 #5 0x000055dcb6370e86 in fil_aio_wait (segment=segment@entry=4) at /home/danielgb/mariadb-server-10.2/storage/innobase/fil/fil0fil.cc:5435 #6 0x000055dcb6271328 in io_handler_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:343 #7 0x00007f0063e636ba in start_thread (arg=0x7f00557c7700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 9 (Thread 0x7f0055fc8700 (LWP 23144)): #0 0x00007f00651f764a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055dcb61ccca9 in LinuxAIOHandler::collect (this=this@entry=0x7f0055fc7b00) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:1883 #2 0x000055dcb61d2b2c in LinuxAIOHandler::poll (this=this@entry=0x7f0055fc7b00, m1=m1@entry=0x7f0055fc7ba0, m2=m2@entry=0x7f0055fc7ba8, request=request@entry=0x7f0055fc7bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2028 #3 0x000055dcb61d6673 in os_aio_linux_handler (request=0x7f0055fc7bb0, m2=0x7f0055fc7ba8, m1=0x7f0055fc7ba0, global_segment=3) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2082 #4 os_aio_handler (segment=segment@entry=3, m1=m1@entry=0x7f0055fc7ba0, m2=m2@entry=0x7f0055fc7ba8, request=request@entry=0x7f0055fc7bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:5652 #5 0x000055dcb6370e86 in fil_aio_wait (segment=segment@entry=3) at /home/danielgb/mariadb-server-10.2/storage/innobase/fil/fil0fil.cc:5435 #6 0x000055dcb6271328 in io_handler_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:343 #7 0x00007f0063e636ba in start_thread (arg=0x7f0055fc8700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 8 (Thread 0x7f003dffb700 (LWP 23228)): #0 0x00007f0063e6cc1d in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x000055dcb61d79fc in os_thread_sleep (tm=tm@entry=1000000) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0thread.cc:230 #2 0x000055dcb62f96a2 in btr_defragment_thread () at /home/danielgb/mariadb-server-10.2/storage/innobase/btr/btr0defragment.cc:771 #3 0x00007f0063e636ba in start_thread (arg=0x7f003dffb700) at pthread_create.c:333 #4 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 7 (Thread 0x7f005e734700 (LWP 23114)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb650a39e in inline_mysql_cond_timedwait (that=0x55dcb7615860 , mutex=0x55dcb76158a0 , src_file=0x55dcb6631cc0 "/home/danielgb/mariadb-server-10.2/mysys/thr_timer.c", src_line=292, abstime=0x7f005e733cf0) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1175 #2 timer_handler (arg=arg@entry=0x0) at /home/danielgb/mariadb-server-10.2/mysys/thr_timer.c:292 #3 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81c00e8) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #4 0x00007f0063e636ba in start_thread (arg=0x7f005e734700) at pthread_create.c:333 #5 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 6 (Thread 0x7f0056fca700 (LWP 23142)): #0 0x00007f00651f764a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055dcb61ccca9 in LinuxAIOHandler::collect (this=this@entry=0x7f0056fc9b00) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:1883 #2 0x000055dcb61d2b2c in LinuxAIOHandler::poll (this=this@entry=0x7f0056fc9b00, m1=m1@entry=0x7f0056fc9ba0, m2=m2@entry=0x7f0056fc9ba8, request=request@entry=0x7f0056fc9bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2028 #3 0x000055dcb61d6673 in os_aio_linux_handler (request=0x7f0056fc9bb0, m2=0x7f0056fc9ba8, m1=0x7f0056fc9ba0, global_segment=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2082 #4 os_aio_handler (segment=segment@entry=1, m1=m1@entry=0x7f0056fc9ba0, m2=m2@entry=0x7f0056fc9ba8, request=request@entry=0x7f0056fc9bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:5652 #5 0x000055dcb6370e86 in fil_aio_wait (segment=segment@entry=1) at /home/danielgb/mariadb-server-10.2/storage/innobase/fil/fil0fil.cc:5435 #6 0x000055dcb6271328 in io_handler_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:343 #7 0x00007f0063e636ba in start_thread (arg=0x7f0056fca700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 5 (Thread 0x7f003ffff700 (LWP 23193)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x000055dcb61d7396 in os_event::wait (this=0x55dcb82db440) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (this=0x55dcb82db440, reset_sig_count=41) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:336 #3 0x000055dcb61d7835 in os_event_wait_low (event=, reset_sig_count=) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0event.cc:535 #4 0x000055dcb626a353 in srv_resume_thread (slot=slot@entry=0x55dcb6d0e500 , sig_count=, wait=, timeout_usec=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:946 #5 0x000055dcb62705ef in srv_purge_coordinator_suspend (rseg_history_len=, slot=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2802 #6 srv_purge_coordinator_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0srv.cc:2889 #7 0x00007f0063e636ba in start_thread (arg=0x7f003ffff700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 4 (Thread 0x7f005d3c8700 (LWP 23130)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x000055dcb644e234 in inline_mysql_cond_timedwait (src_file=0x55dcb6628f48 "/home/danielgb/mariadb-server-10.2/storage/maria/ma_servicethread.c", src_line=116, abstime=0x7f005d3c7c70, mutex=0x55dcb760c520 , that=0x55dcb760c4e0 ) at /home/danielgb/mariadb-server-10.2/include/mysql/psi/mysql_thread.h:1175 #2 my_service_thread_sleep (control=control@entry=0x55dcb6d12840 , sleep_time=) at /home/danielgb/mariadb-server-10.2/storage/maria/ma_servicethread.c:115 #3 0x000055dcb6447b47 in ma_checkpoint_background (arg=arg@entry=0x1e) at /home/danielgb/mariadb-server-10.2/storage/maria/ma_checkpoint.c:708 #4 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81d0228) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #5 0x00007f0063e636ba in start_thread (arg=0x7f005d3c8700) at pthread_create.c:333 #6 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 3 (Thread 0x7f00567c9700 (LWP 23143)): #0 0x00007f00651f764a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055dcb61ccca9 in LinuxAIOHandler::collect (this=this@entry=0x7f00567c8b00) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:1883 #2 0x000055dcb61d2b2c in LinuxAIOHandler::poll (this=this@entry=0x7f00567c8b00, m1=m1@entry=0x7f00567c8ba0, m2=m2@entry=0x7f00567c8ba8, request=request@entry=0x7f00567c8bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2028 #3 0x000055dcb61d6673 in os_aio_linux_handler (request=0x7f00567c8bb0, m2=0x7f00567c8ba8, m1=0x7f00567c8ba0, global_segment=2) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2082 #4 os_aio_handler (segment=segment@entry=2, m1=m1@entry=0x7f00567c8ba0, m2=m2@entry=0x7f00567c8ba8, request=request@entry=0x7f00567c8bb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:5652 #5 0x000055dcb6370e86 in fil_aio_wait (segment=segment@entry=2) at /home/danielgb/mariadb-server-10.2/storage/innobase/fil/fil0fil.cc:5435 #6 0x000055dcb6271328 in io_handler_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:343 #7 0x00007f0063e636ba in start_thread (arg=0x7f00567c9700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 2 (Thread 0x7f00577cb700 (LWP 23141)): #0 0x00007f00651f764a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055dcb61ccca9 in LinuxAIOHandler::collect (this=this@entry=0x7f00577cab00) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:1883 #2 0x000055dcb61d2b2c in LinuxAIOHandler::poll (this=this@entry=0x7f00577cab00, m1=m1@entry=0x7f00577caba0, m2=m2@entry=0x7f00577caba8, request=request@entry=0x7f00577cabb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2028 #3 0x000055dcb61d6673 in os_aio_linux_handler (request=0x7f00577cabb0, m2=0x7f00577caba8, m1=0x7f00577caba0, global_segment=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:2082 #4 os_aio_handler (segment=segment@entry=0, m1=m1@entry=0x7f00577caba0, m2=m2@entry=0x7f00577caba8, request=request@entry=0x7f00577cabb0) at /home/danielgb/mariadb-server-10.2/storage/innobase/os/os0file.cc:5652 #5 0x000055dcb6370e86 in fil_aio_wait (segment=segment@entry=0) at /home/danielgb/mariadb-server-10.2/storage/innobase/fil/fil0fil.cc:5435 #6 0x000055dcb6271328 in io_handler_thread (arg=) at /home/danielgb/mariadb-server-10.2/storage/innobase/srv/srv0start.cc:343 #7 0x00007f0063e636ba in start_thread (arg=0x7f00577cb700) at pthread_create.c:333 #8 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 Thread 1 (Thread 0x7f005c3bb700 (LWP 23592)): #0 __pthread_kill (threadid=, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x000055dcb65060ea in my_write_core (sig=sig@entry=11) at /home/danielgb/mariadb-server-10.2/mysys/stacktrace.c:477 #2 0x000055dcb6000f24 in handle_fatal_signal (sig=11) at /home/danielgb/mariadb-server-10.2/sql/signal_handler.cc:299 #3 #4 first_linear_tab (join=0x7efff00120f8, include_bush_roots=include_bush_roots@entry=WITHOUT_BUSH_ROOTS, const_tbls=const_tbls@entry=WITH_CONST_TABLES) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:8659 #5 0x000055dcb5e7800f in st_select_lex::set_explain_type (this=0x7efff0010460, on_the_fly=on_the_fly@entry=true) at /home/danielgb/mariadb-server-10.2/sql/sql_lex.cc:4399 #6 0x000055dcb5ecb321 in JOIN::save_explain_data_intern (this=this@entry=0x7efff00120f8, output=0x7efff0012c80, need_tmp_table_arg=, need_order_arg=, distinct_arg=, message=0x55dcb6559074 "Select tables optimized away") at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:24674 #7 0x000055dcb5ecbd32 in JOIN::save_explain_data (this=this@entry=0x7efff00120f8, output=, can_overwrite=can_overwrite@entry=false, need_tmp_table=, need_order=, distinct=) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:3240 #8 0x000055dcb5ed0cb7 in JOIN::optimize (this=0x7efff00120f8) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:1093 #9 0x000055dcb5f0cf11 in st_select_lex_unit::optimize (this=this@entry=0x7efff0004350) at /home/danielgb/mariadb-server-10.2/sql/sql_union.cc:906 #10 0x000055dcb5f0d175 in st_select_lex_unit::exec (this=this@entry=0x7efff0004350) at /home/danielgb/mariadb-server-10.2/sql/sql_union.cc:940 #11 0x000055dcb5f10a6c in mysql_union (thd=thd@entry=0x7efff00009a8, lex=lex@entry=0x7efff0004288, result=result@entry=0x7efff0011648, unit=unit@entry=0x7efff0004350, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /home/danielgb/mariadb-server-10.2/sql/sql_union.cc:41 #12 0x000055dcb5ed2cd4 in handle_select (thd=thd@entry=0x7efff00009a8, lex=lex@entry=0x7efff0004288, result=result@entry=0x7efff0011648, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /home/danielgb/mariadb-server-10.2/sql/sql_select.cc:351 #13 0x000055dcb5e8930f in mysql_execute_command (thd=thd@entry=0x7efff00009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:4523 #14 0x000055dcb5e89b7d in mysql_parse (thd=0x7efff00009a8, rawbuf=, length=113, parser_state=0x7f005c3ba0d0, is_com_multi=, is_next_command=) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:7879 #15 0x000055dcb5e8c6a1 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7efff00009a8, packet=packet@entry=0x7efff0006ca9 "INSERT INTO tt_1(trans_id, stmt_id, info) SELECT 32, 1, COUNT(*) FROM nt_1 UNION SELECT 24, 1, COUNT(*) FROM nt_1", packet_length=packet_length@entry=113, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1817 #16 0x000055dcb5e8ced1 in do_command (thd=0x7efff00009a8) at /home/danielgb/mariadb-server-10.2/sql/sql_parse.cc:1362 #17 0x000055dcb5f47244 in do_handle_one_connection (connect=connect@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1354 #18 0x000055dcb5f473b4 in handle_one_connection (arg=arg@entry=0x55dcb8734db8) at /home/danielgb/mariadb-server-10.2/sql/sql_connect.cc:1260 #19 0x000055dcb64136c4 in pfs_spawn_thread (arg=0x55dcb81c2678) at /home/danielgb/mariadb-server-10.2/storage/perfschema/pfs.cc:1862 #20 0x00007f0063e636ba in start_thread (arg=0x7f005c3bb700) at pthread_create.c:333 #21 0x00007f00632ef3dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_mixed_mixing_engines 170803 16:38:46 [ERROR] mysqld got signal 11 ; Attempting backtrace. You can use the following information to find out -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 10 seconds executing testcases Completed: Failed 6/6 tests, 0.00% were successful. Failing test(s): rpl.rpl_non_direct_mixed_mixing_engines rpl.rpl_stm_mixing_engines rpl.rpl_non_direct_stm_mixing_engines rpl.rpl_row_mixing_engines rpl.rpl_non_direct_row_mixing_engines rpl.rpl_mixed_mixing_engines The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html Errors/warnings were found in logfiles during server shutdown after running the following sequence(s) of tests: rpl.rpl_non_direct_mixed_mixing_engines rpl.rpl_stm_mixing_engines rpl.rpl_non_direct_stm_mixing_engines rpl.rpl_row_mixing_engines rpl.rpl_non_direct_row_mixing_engines rpl.rpl_mixed_mixing_engines mysql-test-run: *** ERROR: there were failing test cases