[Note] InnoDB: Starting crash recovery from checkpoint LSN=21642

 [Note] InnoDB: Starting final batch to recover 143 pages from redo log.

 [Warning] InnoDB: A transaction id in a record of table `SYS_TABLES` is newer than the system-wide maximum.

mysqld: /10.4/storage/innobase/trx/trx0sys.cc:62: static void ReadView::check_trx_id_sanity(trx_id_t, const table_name_t&): Assertion `0' failed.

[ERROR] mysqld got signal 6 ;

linux/raise.c:54(__GI_raise)[0x7fb0375bb428]

stdlib/abort.c:91(__GI_abort)[0x7fb0375bd02a]

assert/assert.c:92(__assert_fail_base)[0x7fb0375b3bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb0375b3c82]

trx/trx0sys.cc:62(ReadView::check_trx_id_sanity(unsigned long, table_name_t const&))[0x55c2f1b9d006]

include/read0types.h:222(ReadView::changes_visible(unsigned long, table_name_t const&) const)[0x55c2f1a26ae2]

lock/lock0lock.cc:404(lock_clust_rec_cons_read_sees(unsigned char const*, dict_index_t*, unsigned long const*, ReadView*))[0x55c2f1a11705]

row/row0sel.cc:1899(row_sel(sel_node_t*, que_thr_t*))[0x55c2f1b27cf2]

row/row0sel.cc:2343(row_sel_step(que_thr_t*))[0x55c2f1b28c8d]

que/que0que.cc:1018(que_thr_step(que_thr_t*))[0x55c2f1a9548b]

que/que0que.cc:1104(que_run_threads_low(que_thr_t*))[0x55c2f1a9586b]

que/que0que.cc:1146(que_run_threads(que_thr_t*))[0x55c2f1a95a5c]

fts/fts0sql.cc:240(fts_eval_sql(trx_t*, que_fork_t*))[0x55c2f1d07495]

fts/fts0fts.cc:7134(fts_drop_orphaned_tables())[0x55c2f1cf1e3f]

log/log0recv.cc:3605(recv_recovery_rollback_active())[0x55c2f1a444e8]

srv/srv0start.cc:2149(srv_start(bool))[0x55c2f1b5c514]

handler/ha_innodb.cc:4244(innodb_init(void*))[0x55c2f1980862]

sql/handler.cc:530(ha_initialize_handlerton(st_plugin_int*))[0x55c2f161e027]

sql/sql_plugin.cc:1437(plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool))[0x55c2f1306f5a]

sql/sql_plugin.cc:1719(plugin_init(int*, char**, int))[0x55c2f1307c0e]

sql/mysqld.cc:5151(init_server_components())[0x55c2f11becf6]

sql/mysqld.cc:5680(mysqld_main(int, char**))[0x55c2f11bfeda]

sql/main.cc:26(main)[0x55c2f11b48d0]

csu/libc-start.c:325(__libc_start_main)[0x7fb0375a6830]

/10.4/sql/mysqld(_start+0x29)[0x55c2f11b47a9]

=================================================================

==28051==ERROR: AddressSanitizer: heap-use-after-free on address 0x611000350408 at pc 0x558b53692117 bp 0x7ff7c920ad40 sp 0x7ff7c920ad30

READ of size 8 at 0x611000350408 thread T38

    #0 0x558b53692116 in user_var_entry::val_int(bool*) const /10.4/sql/item_func.cc:4599

    #1 0x558b53696180 in Item_func_get_user_var::val_int() /10.4/sql/item_func.cc:5102

    #2 0x558b535a7846 in Item::save_int_in_field(Field*, bool) /10.4/sql/item.cc:6496

    #3 0x558b5327b603 in Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const /10.4/sql/sql_type.cc:3587

    #4 0x558b535a7a22 in Item::save_in_field(Field*, bool) /10.4/sql/item.cc:6506

    #5 0x558b530b2370 in TABLE::update_default_fields(bool, bool) /10.4/sql/table.cc:8027

    #6 0x558b52caba9d in fill_record(THD*, TABLE*, List<Item>&, List<Item>&, bool, bool) /10.4/sql/sql_base.cc:8436

    #7 0x558b52cac70e in fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type) /10.4/sql/sql_base.cc:8570

    #8 0x558b52dcb6be in read_sep_field /10.4/sql/sql_load.cc:1136

    #9 0x558b52dc854b in mysql_load(THD*, sql_exchange const*, TABLE_LIST*, List<Item>&, List<Item>&, List<Item>&, enum_duplicates, bool, bool) /10.4/sql/sql_load.cc:661

    #10 0x558b52df4142 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:5169

    #11 0x558b52e0727e in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8141

    #12 0x558b52ddfe04 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1820

    #13 0x558b52ddce26 in do_command(THD*) /10.4/sql/sql_parse.cc:1358

    #14 0x558b531463fd in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1399

    #15 0x558b53145dc7 in handle_one_connection /10.4/sql/sql_connect.cc:1302

    #16 0x7ff882f926b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #17 0x7ff88222341c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

perl ./runall-new.pl --no-mask --queries=100M --duration=800 --threads=1 --seed=1550500635 --views --vcols --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/event.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/analyze-tables-at-start.yy --mysqld=--log_output=FILE --mysqld=--log-bin --mysqld=--log_bin_trust_function_creators=1 --mysqld=--loose-max-statement-time=20 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--lock-wait-timeout=10 --mysqld=--innodb-lock-wait-timeout=5 --engine=InnoDB --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/runtime/connect_kill_sql.yy --gendata=conf/runtime/connect_kill_data.zz --basedir=/git/10.4 --vardir=/1

2019-02-19 15:43:39 0 [ERROR] Fatal error: Can't open and lock privilege tables: Got error 24 "Too many open files" from storage engine Aria

2019-02-19 15:43:39 0 [ERROR] Can't open and lock privilege tables: Got error 24 "Too many open files" from storage engine Aria

2019-02-19 15:43:39 0 [ERROR] mysqld: Out of resources when opening file './mysql-bin.000002' (Errcode: 24 "Too many open files")

2019-02-19 15:43:39 0 [ERROR] Could not use mysql-bin for logging (error 24). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.

2019-02-19 15:43:39 0 [ERROR] mysqld: Can't open file: './mysql-bin.000002' (errno: 1 "Operation not permitted")

2019-02-19 15:43:39 0 [ERROR] Could not use ./mysql-bin.000002 for logging (error 24). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.

190219 15:43:39 [ERROR] mysqld got signal 11 ;

#4  0x000055b2276dbb96 in Log_event::Log_event (this=0x7f9795204660, thd_arg=0x0, flags_arg=0, using_trans=false) at/git/10.4/sql/log_event.cc:1282

#5  0x000055b2273ada46 in Incident_log_event::Incident_log_event (this=0x7f9795204660, thd_arg=0x0, incident=INCIDENT_LOST_EVENTS, msg=0x55b228816c70 <write_error_msg>) at/git/10.4/sql/log_event.h:5063

#6  0x000055b2276ca73f in MYSQL_BIN_LOG::write_incident_already_locked (this=0x55b228b5dae0 <mysql_bin_log>, thd=0x0) at/git/10.4/sql/log.cc:7195

#7  0x000055b2276c9473 in MYSQL_BIN_LOG::rotate (this=0x55b228b5dae0 <mysql_bin_log>, force_rotate=true, check_purge=0x7f9795204baf) at/git/10.4/sql/log.cc:6741

#8  0x000055b2276c9c7b in MYSQL_BIN_LOG::rotate_and_purge (this=0x55b228b5dae0 <mysql_bin_log>, force_rotate=true, domain_drop_lex=0x0) at/git/10.4/sql/log.cc:6926

#9  0x000055b22740214c in reload_acl_and_cache (thd=0x0, options=2147499823, tables=0x0, write_to_binlog=0x7f9795204cd0) at/git/10.4/sql/sql_reload.cc:160

#10 0x000055b22711c949 in signal_hand (arg=0x0) at/git/10.4/sql/mysqld.cc:3278

#11 0x00007f97b31bb6ba in start_thread (arg=0x7f9795205700) at pthread_create.c:333

#12 0x00007f97b244c41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

perl ./runall-new.pl  --no-mask --queries=10M --duration=600 --threads=2 --seed=1550579327 --views --vcols --reporters=Backtrace,ErrorLog,Deadlock --validator=TransformerNoComparator --transformer=ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice,ExecuteAsWhereSubquery,LimitDecrease,LimitIncrease,NullIf,ExecuteAsCTE --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/event.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/analyze-tables-at-start.yy --mysqld=--log-bin --mysqld=--log_bin_trust_function_creators=1 --mysqld=--loose-max-statement-time=20 --mysqld=--innodb-lock-wait-timeout=5  --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --grammar=conf/optimizer/optimizer_access_exp.yy --views=MERGE --basedir=/git/10.4 --vardir=/1

190220 11:01:26 [ERROR] mysqld got signal 11 ;

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fce7c963390]

/git/10.4/sql/mysqld(_ZN19Item_equal_iteratorI18List_iterator_fast4ItemEC1ER10Item_equal+0x46)[0x5642afaa9b40]

sql/item_cmpfunc.h:3273(Item_equal_iterator<List_iterator_fast, Item>::Item_equal_iterator(Item_equal&))[0x5642afaa4ed1]

sql/item_cmpfunc.h:3307(Item_equal_fields_iterator::Item_equal_fields_iterator(Item_equal&))[0x5642afe63cae]

sql/item_cmpfunc.cc:6614(Item_equal::contains(Field*))[0x5642afe376cf]

sql/item.cc:5992(Item_field::find_item_equal(COND_EQUAL*))[0x5642afb2dee8]

sql/sql_select.cc:15184(eliminate_item_equal(THD*, Item*, COND_EQUAL*, Item_equal*))[0x5642afb2eb09]

sql/sql_select.cc:15487(substitute_for_best_equal_field(THD*, st_join_table*, Item*, COND_EQUAL*, void*))[0x5642afb0977a]

sql/sql_select.cc:2308(JOIN::optimize_stage2())[0x5642afb08ca8]

sql/sql_select.cc:2147(JOIN::optimize_inner())[0x5642afb066fe]

sql/sql_select.cc:1508(JOIN::optimize())[0x5642afb116c6]

sql/sql_select.cc:4518(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5642afb02072]

sql/sql_select.cc:423(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5642afaca990]

sql/sql_parse.cc:6588(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5642afabf841]

sql/sql_parse.cc:3825(mysql_execute_command(THD*))[0x5642aface8f7]

sql/sql_parse.cc:8141(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5642afab9b98]

sql/sql_parse.cc:1822(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5642afab83e8]

sql/sql_parse.cc:1358(do_command(THD*))[0x5642afc33bc5]

sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x5642afc33903]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fce7c9596ba]

x86_64/clone.S:111(clone)[0x7fce7bbea41d]

Query (0x7fce0425d220): SELECT DISTINCT alias2.`pk` AS field1, alias2.`pk` AS field2, alias1.`pk` AS field3, alias1.`col_int` AS field4, alias1.`col_int` AS field5, alias2.`pk` AS field6 FROM view_C AS alias1 LEFT OUTER JOIN G AS alias2 ON alias1.`col_varchar_10_latin1_key` = alias2.`col_varchar_10_latin1_key` WHERE alias1.`pk` = 1 GROUP BY field1, field2, field3, field4, field5, field6 HAVING field2 < 69 ORDER BY field1, field2, field3, field4, field5, field6  

    ==14001==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x55c9eccf702f bp 0x7f5c24adbd00 sp 0x7f5c24adbcd0 T40)

    #0 0x55c9eccf702e in Explain_node::print_explain_for_children(Explain_query*, select_result_sink*, unsigned char, bool) /10.4/sql/sql_explain.cc:661

    #1 0x55c9eccf8455 in Explain_select::print_explain(Explain_query*, select_result_sink*, unsigned char, bool) /10.4/sql/sql_explain.cc:853

    #2 0x55c9eccf60cc in Explain_union::print_explain(Explain_query*, select_result_sink*, unsigned char, bool) /10.4/sql/sql_explain.cc:501

    #3 0x55c9eccf3d16 in Explain_query::print_explain(select_result_sink*, unsigned char, bool) /10.4/sql/sql_explain.cc:211

    #4 0x55c9eccf46b6 in Explain_query::print_explain_str(THD*, String*, bool) /10.4/sql/sql_explain.cc:265

    #5 0x55c9eccf4430 in print_explain_for_slow_log(LEX*, THD*, String*) /10.4/sql/sql_explain.cc:249

    #6 0x55c9ed31b934 in MYSQL_QUERY_LOG::write(THD*, long, char const*, unsigned long, unsigned long long, unsigned long long, bool, char const*, unsigned long) /10.4/sql/log.cc:3091

    #7 0x55c9ed310074 in Log_to_file_event_handler::log_slow(THD*, my_hrtime_t, char const*, unsigned long, unsigned long long, unsigned long long, bool, char const*, unsigned long) /10.4/sql/log.cc:1088

    #8 0x55c9ed311bf1 in LOGGER::slow_log_print(THD*, char const*, unsigned long, unsigned long long) /10.4/sql/log.cc:1362

    #9 0x55c9ed32e953 in slow_log_print(THD*, char const*, unsigned int, unsigned long long) /10.4/sql/log.cc:6557

    #10 0x55c9ec91b7fb in log_slow_statement(THD*) /10.4/sql/sql_parse.cc:2532

    #11 0x55c9ec91acff in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:2440

    #12 0x55c9ec9146e2 in do_command(THD*) /10.4/sql/sql_parse.cc:1358

    #13 0x55c9ecc88abd in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1399

    #14 0x55c9ecc88487 in handle_one_connection /10.4/sql/sql_connect.cc:1302

    #15 0x7f5c522986b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #16 0x7f5c5152941c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

/10.4/storage/maria/ma_bitmap.c:528: _ma_bitmap_flush_all: Assertion `bitmap->flush_all_requested == 1' failed.

190228 16:56:17 [ERROR] mysqld got signal 6 ;

stdlib/abort.c:91(__GI_abort)[0x7f5413d2002a]

assert/assert.c:92(__assert_fail_base)[0x7f5413d16bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f5413d16c82]

/10.4/sql/mysqld(+0x1f3ddd8)[0x56319e615dd8]

maria/ma_bitmap.c:535(_ma_bitmap_flush_all)[0x56319e56623c]

maria/ma_checkpoint.c:1082(collect_tables)[0x56319e5632bd]

maria/ma_checkpoint.c:198(really_execute_checkpoint)[0x56319e562f20]

maria/ma_checkpoint.c:132(ma_checkpoint_execute)[0x56319e56469c]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f5414b5f6ba]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5413df041d]

==14863==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x5582f8565181 bp 0x7f095cb393f0 sp 0x7f095cb393c0 T33)

    #0 0x5582f8565180 in Item_field::update_vcol_processor(void*) /10.4/sql/item.cc:877

    #1 0x5582f7b56b0b in Item::walk(bool (Item::*)(void*), bool, void*) /10.4/sql/item.h:1782

    #2 0x5582f7c7ddba in Item_args::walk_args(bool (Item::*)(void*), bool, void*) /10.4/sql/item.h:2477

    #3 0x5582f7c7eebe in Item_func_or_sum::walk(bool (Item::*)(void*), bool, void*) /10.4/sql/item.h:5056

    #4 0x5582f7c7ddba in Item_args::walk_args(bool (Item::*)(void*), bool, void*) /10.4/sql/item.h:2477

    #5 0x5582f7c7eebe in Item_func_or_sum::walk(bool (Item::*)(void*), bool, void*) /10.4/sql/item.h:5056

    #6 0x5582f808be35 in TABLE::update_virtual_field(Field*) /10.4/sql/table.cc:8226

    #7 0x5582f8c2f955 in compute_vcols /10.4/storage/myisam/ha_myisam.cc:707

    #8 0x5582f8c60948 in sort_get_next_record /10.4/storage/myisam/mi_check.c:3663

    #9 0x5582f8c5c407 in sort_key_read /10.4/storage/myisam/mi_check.c:3127

    #10 0x5582f8d273ef in find_all_keys /10.4/storage/myisam/sort.c:310

    #11 0x5582f8d2696e in _create_index_by_sort /10.4/storage/myisam/sort.c:226

    #12 0x5582f8c56877 in mi_repair_by_sort /10.4/storage/myisam/mi_check.c:2406

    #13 0x5582f8c35ed9 in ha_myisam::repair(THD*, st_handler_check_param&, bool) /10.4/storage/myisam/ha_myisam.cc:1306

    #14 0x5582f8c38900 in ha_myisam::enable_indexes(unsigned int) /10.4/storage/myisam/ha_myisam.cc:1644

    #15 0x5582f8c397c9 in ha_myisam::end_bulk_insert() /10.4/storage/myisam/ha_myisam.cc:1805

    #16 0x5582f7d36f90 in handler::ha_end_bulk_insert() /10.4/sql/handler.h:3281

    #17 0x5582f7d2dfb7 in select_insert::prepare_eof() /10.4/sql/sql_insert.cc:3936

    #18 0x5582f7d2f64d in select_insert::send_eof() /10.4/sql/sql_insert.cc:4029

    #19 0x5582f7ed896f in do_select /10.4/sql/sql_select.cc:19611

    #20 0x5582f7e73d27 in JOIN::exec_inner() /10.4/sql/sql_select.cc:4371

    #21 0x5582f7e716a1 in JOIN::exec() /10.4/sql/sql_select.cc:4153

    #22 0x5582f7e750df in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.4/sql/sql_select.cc:4585

    #23 0x5582f7e4bf7d in handle_select(THD*, LEX*, select_result*, unsigned long) /10.4/sql/sql_select.cc:424

    #24 0x5582f7dc36df in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:4944

    #25 0x5582f7dd8eb2 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8205

    #26 0x5582f7db1672 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1829

    #27 0x5582f7dae5bd in do_command(THD*) /10.4/sql/sql_parse.cc:1358

    #28 0x5582f8122d78 in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1399

    #29 0x5582f8122742 in handle_one_connection /10.4/sql/sql_connect.cc:1302

    #30 0x7f098be176b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #31 0x7f098b0a841c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

MariaDB [test]> select sum(i) over (partition  by t1.i) from (select * from t1 )dt group by i;

+----------------------------------+

| sum(i) over (partition  by t1.i) |

+----------------------------------+

|                                1 |

|                                2 |

|                                3 |

|                                4 |

|                                5 |

+----------------------------------+

5 rows in set (0.002 sec)

MariaDB [test]> select sum(i) over (partition  by (t1.i+1)) from (select * from t1 )dt group by i;

ERROR 1054 (42S22): Unknown column 't1.i' in 'group statement'

==27997==ERROR: AddressSanitizer: unknown-crash on address 0x62b0001020d6 at pc 0x5634d6970b10 bp 0x7f20e49e1b80 sp 0x7f20e49e1b70

READ of size 1 at 0x62b0001020d6 thread T34

    #0 0x5634d6970b0f in my_mb_wc_latin1 /10.4/strings/ctype-latin1.c:372

    #1 0x5634d69cf52e in my_convert_using_func /10.4/strings/ctype.c:1019

    #2 0x5634d69cfadc in my_convert /10.4/strings/ctype.c:1127

    #3 0x5634d4e43ee7 in copy_and_convert(char*, unsigned long, charset_info_st const*, char const*, unsigned long, charset_info_st const*, unsigned int*) /10.4/sql/sql_string.h:44

    #4 0x5634d4ffd289 in err_conv(char*, unsigned int, char const*, unsigned int, charset_info_st const*) /10.4/sql/sql_error.cc:897

    #5 0x5634d4e652ba in ErrBuff::set_str(char const*, unsigned long, charset_info_st const*) const /10.4/sql/sql_error.h:846

    #6 0x5634d4e65656 in ErrConvString::ptr() const /10.4/sql/sql_error.h:878

    #7 0x5634d5770215 in Value_source::Converter_string_to_number::check_edom_and_truncation(THD*, Value_source::Warn_filter, char const*, charset_info_st const*, char const*, unsigned long) const /10.4/sql/field.cc:1478

    #8 0x5634d4e65b6b in Value_source::Converter_strntod_with_warn::Converter_strntod_with_warn(THD*, Value_source::Warn_filter, charset_info_st const*, char const*, unsigned long) /10.4/sql/field.h:241

    #9 0x5634d57bf32a in Field_varstring::val_real() /10.4/sql/field.cc:7575

    #10 0x5634d586d2c0 in Item_field::val_result() /10.4/sql/item.cc:3218

    #11 0x5634d5892af0 in Item_ref::val_real() /10.4/sql/item.cc:8150

    #12 0x5634d5a4664b in Aggregator_simple::arg_val_real() /10.4/sql/item_sum.cc:1756

    #13 0x5634d5a45343 in Item_sum_sum::add_helper(bool) /10.4/sql/item_sum.cc:1618

    #14 0x5634d5a4464d in Item_sum_sum::add() /10.4/sql/item_sum.cc:1545

    #15 0x5634d5a49305 in Item_sum_avg::add() /10.4/sql/item_sum.cc:1969

    #16 0x5634d558fb26 in Frame_cursor::add_value_to_items() (/10.4/sql/mysqld+0x167ab26)

    #17 0x5634d5591fd4 in Frame_range_current_row_bottom::pre_next_partition(unsigned long long) (/10.4/sql/mysqld+0x167cfd4)

    #18 0x5634d5590184 in Cursor_manager::notify_cursors_partition_changed(unsigned long long) (/10.4/sql/mysqld+0x167b184)

    #19 0x5634d558b72d in compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*) /10.4/sql/sql_window.cc:2806

    #20 0x5634d558bee4 in Window_func_runner::exec(THD*, TABLE*, SORT_INFO*) /10.4/sql/sql_window.cc:2932

    #21 0x5634d558c133 in Window_funcs_sort::exec(JOIN*, bool) /10.4/sql/sql_window.cc:2957

    #22 0x5634d558ce80 in Window_funcs_computation::exec(JOIN*, bool) /10.4/sql/sql_window.cc:3083

    #23 0x5634d5207b23 in AGGR_OP::end_send() /10.4/sql/sql_select.cc:28201

    #24 0x5634d51cd8ae in sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) /10.4/sql/sql_select.cc:19732

    #25 0x5634d51ce00a in sub_select(JOIN*, st_join_table*, bool) /10.4/sql/sql_select.cc:19967

    #26 0x5634d51ccc7e in do_select /10.4/sql/sql_select.cc:19558

    #27 0x5634d51685ff in JOIN::exec_inner() /10.4/sql/sql_select.cc:4371

    #28 0x5634d5165f79 in JOIN::exec() /10.4/sql/sql_select.cc:4153

    #29 0x5634d51699b7 in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.4/sql/sql_select.cc:4585

    #30 0x5634d5140855 in handle_select(THD*, LEX*, select_result*, unsigned long) /10.4/sql/sql_select.cc:424

    #31 0x5634d50c5959 in execute_sqlcom_select /10.4/sql/sql_parse.cc:6602

    #32 0x5634d50b2a95 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:3891

    #33 0x5634d50cdd9b in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8154

    #34 0x5634d50a67c7 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1832

    #35 0x5634d50a3706 in do_command(THD*) /10.4/sql/sql_parse.cc:1365

    #36 0x5634d541841a in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1398

    #37 0x5634d5417de4 in handle_one_connection /10.4/sql/sql_connect.cc:1301

    #38 0x7f211428b6b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #39 0x7f211351c41c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

    ==9379==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000070 (pc 0x55f495be1c8b bp 0x7f3bb984a6d0 sp 0x7f3bb984a6c0 T32)

    #0 0x55f495be1c8a in Bitmap<64u>::is_clear_all() const /10.4/sql/sql_bitmap.h:199

    #1 0x55f49619a3c9 in Field_varstring::is_equal(Create_field*) /10.4/sql/field.cc:7933

    #2 0x55f495ca1482 in compare_keys_but_name(st_key const*, st_key const*, Alter_info*, TABLE const*, st_key const*, st_key const*) /10.4/sql/sql_table.cc:6564

    #3 0x55f495ca449d in fill_alter_inplace_info /10.4/sql/sql_table.cc:7051

    #4 0x55f495cb50bd in mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool) /10.4/sql/sql_table.cc:9872

    #5 0x55f495e05150 in Sql_cmd_alter_table::execute(THD*) /10.4/sql/sql_alter.cc:496

    #6 0x55f495a9c627 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:6344

    #7 0x55f495aa6c81 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8154

    #8 0x55f495a7f931 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1832

    #9 0x55f495a7c870 in do_command(THD*) /10.4/sql/sql_parse.cc:1365

    #10 0x55f495df0304 in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1398

    #11 0x55f495defcce in handle_one_connection /10.4/sql/sql_connect.cc:1301

    #12 0x7f3bef63e6b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #13 0x7f3bee8cf41c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

  AddressSanitizer: use-after-poison on address 0x62d000ee46e0 at pc 0x55a7b789ff12 bp 0x7f724cb89830 sp 0x7f724cb89820

WRITE of size 4 at 0x62d000ee46e0 thread T35

    #0 0x55a7b789ff11 in Field::fill_cache_field(st_cache_field*) /10.4/sql/field.cc:2232

    #1 0x55a7b75c8e68 in add_table_data_fields_to_join_cache /10.4/sql/sql_join_cache.cc:125

    #2 0x55a7b75cb88f in JOIN_CACHE::create_remaining_fields() /10.4/sql/sql_join_cache.cc:605

    #3 0x55a7b75ce44f in JOIN_CACHE::init(bool) /10.4/sql/sql_join_cache.cc:1068

    #4 0x55a7b75dda7e in JOIN_CACHE_BKA::init(bool) /10.4/sql/sql_join_cache.cc:4243

    #5 0x55a7b7279327 in JOIN::init_join_caches() /10.4/sql/sql_select.cc:1722

    #6 0x55a7b7284cea in JOIN::optimize_stage2() /10.4/sql/sql_select.cc:2922

    #7 0x55a7b727de37 in JOIN::optimize_inner() /10.4/sql/sql_select.cc:2217

    #8 0x55a7b7277df8 in JOIN::optimize() /10.4/sql/sql_select.cc:1561

    #9 0x55a7b7294dd8 in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.4/sql/sql_select.cc:4588

    #10 0x55a7b726be8b in handle_select(THD*, LEX*, select_result*, unsigned long) /10.4/sql/sql_select.cc:424

    #11 0x55a7b71f1438 in execute_sqlcom_select /10.4/sql/sql_parse.cc:6602

    #12 0x55a7b71de655 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:3891

    #13 0x55a7b71f96f9 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8154

    #14 0x55a7b71d23a9 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1832

    #15 0x55a7b71cf2e8 in do_command(THD*) /10.4/sql/sql_parse.cc:1365

    #16 0x55a7b7542c7a in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1398

    #17 0x55a7b7542644 in handle_one_connection /10.4/sql/sql_connect.cc:1301

    #18 0x7f72807286b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #19 0x7f727f9b941c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

MariaDB [test]> (select * from ((values ('a'),('b') ) dt  join (values ('a'),('b'),('6')) de on dt.`a`=de.`a`)   limit 100) ;

+---+---+

| a | a |

+---+---+

| a | a |

| b | b |

+---+---+

2 rows in set (0.002 sec)

MariaDB [test]> (select * from ((values ('a'),('b') ) dt  join (values ('a'),('b'),('6')) de on dt.`a`=de.`a`)   limit 100) limit 4;

ERROR 1060 (42S21): Duplicate column name 'a'

 /bb-10.2-compatibility/src/sql/sql_error.cc:445: void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*): Assertion `! is_set() || m_can_overwrite_status' failed.

 }

190424 15:13:31 [ERROR] mysqld got signal 6 ;

linux/raise.c:54(__GI_raise)[0x7f7f9acbc428]

stdlib/abort.c:91(__GI_abort)[0x7f7f9acbe02a]

assert/assert.c:92(__assert_fail_base)[0x7f7f9acb4bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f7f9acb4c82]

sql/sql_error.cc:448(Diagnostics_area::set_error_status(unsigned int, char const*, char const*, Sql_user_condition_identity const&, Sql_condition const*))[0x560bfa51f0dd]

sql/sql_class.cc:1074(THD::raise_condition(unsigned int, char const*, Sql_state_errno_level::enum_warning_level, Sql_user_condition_identity const&, char const*))[0x560bfa505ab8]

sql/sql_class.h:4161(THD::raise_condition(unsigned int, char const*, Sql_state_errno_level::enum_warning_level, char const*))[0x560bfa4776a9]

mysys/my_error.c:126(my_error)[0x560bfadee02a]

mysys/my_delete.c:49(my_delete)[0x560bfadede38]

mysys/my_symlink2.c:188(my_handler_delete_with_symlink)[0x560bfadf7168]

psi/mysql_file.h:1368(inline_mysql_file_delete_with_symlink)[0x560bfa995576]

maria/ma_delete_table.c:89(maria_delete_table_files)[0x560bfa9955f9]

maria/ha_maria.cc:2678(ha_maria::drop_table(char const*))[0x560bfa92f17f]

sql/handler.cc:4493(handler::ha_drop_table(char const*))[0x560bfa7834c5]

sql/sql_select.cc:18379(free_tmp_table(THD*, TABLE*))[0x560bfa59bf4f]

sql/sql_base.cc:767(close_thread_tables(THD*))[0x560bfa4e9c4f]

sql/sql_parse.cc:6337(mysql_execute_command(THD*))[0x560bfa558bb2]

sql/sql_parse.cc:7982(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x560bfa559ee9]

sql/sql_parse.cc:1862(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x560bfa55c7c7]

sql/sql_parse.cc:1386(do_command(THD*))[0x560bfa55f6bf]

sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x560bfa6592fd]

sql/sql_connect.cc:1243(handle_one_connection)[0x560bfa6594af]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f7f9b6e36ba]

x86_64/clone.S:111(clone)[0x7f7f9ad8e41d]

mysqld: /10.4/storage/maria/ha_maria.cc:2088: virtual int ha_maria::enable_indexes(uint): Assertion `thd->killed != 0' failed.

190507 23:12:41 [ERROR] mysqld got signal 6 ;

linux/raise.c:54(__GI_raise)[0x7fc0419fa428]

stdlib/abort.c:91(__GI_abort)[0x7fc0419fc02a]

assert/assert.c:92(__assert_fail_base)[0x7fc0419f2bd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fc0419f2c82]

maria/ha_maria.cc:2090(ha_maria::enable_indexes(unsigned int))[0x561c5c0a8303]

sql/handler.cc:4502(handler::ha_enable_indexes(unsigned int))[0x561c5bb6d6d0]

sql/sql_table.cc:7362(alter_table_manage_keys(TABLE*, int, Alter_info::enum_enable_or_disable))[0x561c5bb77ef2]

sql/sql_table.cc:9022(simple_tmp_rename_or_index_change(THD*, TABLE_LIST*, Alter_info::enum_enable_or_disable, Alter_table_ctx*))[0x561c5bb7b1ba]

sql/sql_table.cc:9639(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x561c5bccc3a3]

sql/sql_alter.cc:496(Sql_cmd_alter_table::execute(THD*))[0x561c5b9631b4]

sql/sql_parse.cc:6340(mysql_execute_command(THD*))[0x561c5b96d7fe]

sql/sql_parse.cc:8150(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561c5b9464bf]

sql/sql_parse.cc:1831(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561c5b9433fe]

sql/sql_parse.cc:1362(do_command(THD*))[0x561c5bcb755d]

sql/sql_connect.cc:1398(do_handle_one_connection(CONNECT*))[0x561c5bcb6f27]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fc04283b6ba]

x86_64/clone.S:111(clone)[0x7fc041acc41d]

AddressSanitizer: use-after-poison on address 0x62100028b5b0 at pc 0x55a66586b57f bp 0x7f5a9ec59760 sp 0x7f5a9ec59750

WRITE of size 2 at 0x62100028b5b0 thread T38

    #0 0x55a66586b57e in create_key_parts_for_pseudo_indexes /10.4/sql/opt_range.cc:3084

    #1 0x55a66586d033 in calculate_cond_selectivity_for_table(THD*, TABLE*, Item**) /10.4/sql/opt_range.cc:3396

    #2 0x55a664e89dc9 in make_join_statistics /10.4/sql/sql_select.cc:5392

    #3 0x55a664e6be77 in JOIN::optimize_inner() /10.4/sql/sql_select.cc:2192

    #4 0x55a664e66040 in JOIN::optimize() /10.4/sql/sql_select.cc:1562

    #5 0x55a66502ae25 in st_select_lex_unit::optimize() /10.4/sql/sql_union.cc:1402

    #6 0x55a664d0e539 in mysql_derived_optimize /10.4/sql/sql_derived.cc:962

    #7 0x55a664d09cea in mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int) /10.4/sql/sql_derived.cc:206

    #8 0x55a664e6a58c in JOIN::optimize_inner() /10.4/sql/sql_select.cc:2028

    #9 0x55a664e66040 in JOIN::optimize() /10.4/sql/sql_select.cc:1562

    #10 0x55a664e830a8 in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.4/sql/sql_select.cc:4590

    #11 0x55a664e5a090 in handle_select(THD*, LEX*, select_result*, unsigned long) /10.4/sql/sql_select.cc:424

    #12 0x55a664ddf7b4 in execute_sqlcom_select /10.4/sql/sql_parse.cc:6612

    #13 0x55a664dcc913 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:3884

    #14 0x55a664de7a75 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:8164

    #15 0x55a664dc070d in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1829

    #16 0x55a664dbd64a in do_command(THD*) /10.4/sql/sql_parse.cc:1362

    #17 0x55a665132cc8 in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1403

    #18 0x55a665132692 in handle_one_connection /10.4/sql/sql_connect.cc:1306

    #19 0x7f5ad670c6b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #20 0x7f5ad599d41c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

2019-06-13 14:24:43 18530 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open register  file.

2019-06-13 14:24:43 18530 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the index file.

2019-06-13 14:24:43 18530 [ERROR] Could not use ./mysql-bin.002944 for logging (error 24). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.

safe_mutex: Trying to unlock mutex LOCK_log that wasn't locked at /10.3/sql/log.cc, line 6930

Last used at /10.3/sql/log.cc, line: 6915

190613 14:24:43 [ERROR] mysqld got signal 6 ;

/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fbfe5c3002a]

/10.3/sql/mysqld(safe_mutex_unlock+0x21b)[0x561ed5a4553f]

/10.3/sql/mysqld(+0x192a942)[0x561ed4b6b942]

/10.3/sql/mysqld(_ZN13MYSQL_BIN_LOG16rotate_and_purgeEbP16st_dynamic_array+0x1d5)[0x561ed4b942eb]

/10.3/sql/mysqld(_Z20reload_acl_and_cacheP3THDyP10TABLE_LISTPi+0x701)[0x561ed45b576d]

/10.3/sql/mysqld(_Z21mysql_execute_commandP3THD+0xea6a)[0x561ed421233e]

/10.3/sql/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x20)[0x561ed402735c]

/10.3/sql/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x6bf)[0x561ed4025c9d]

/10.3/sql/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x448)[0x561ed4026b44]

/10.3/sql/mysqld(_ZN7sp_head7executeEP3THDb+0x1275)[0x561ed4019f23]

/10.3/sql/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x1346)[0x561ed401f0da]

/10.3/sql/mysqld(_ZN14Event_job_data7executeEP3THDb+0x924)[0x561ed44f6638]

/10.3/sql/mysqld(_ZN19Event_worker_thread3runEP3THDP28Event_queue_element_for_exec+0x40b)[0x561ed4d31ce1]

/10.3/sql/mysqld(event_worker_thread+0x12d)[0x561ed4d3187a]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fbfe686b6ba]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fbfe5d0041d]

 [ERROR] Could not use ./mysql-bin.001720 for logging (error 24). Turning logging off for the whole duration of the MariaDB server process. To turn it on again: fix the cause, shutdown the MariaDB server and restart it.

mysqld: /home/alice/git/10.3/sql/log.cc:7880: void MYSQL_BIN_LOG::trx_group_commit_leader(MYSQL_BIN_LOG::group_commit_entry*): Assertion `is_open()' failed.

    #8 0x7f8dc7c6cc81 in __assert_fail (/lib/x86_64-linux-gnu/libc.so.6+0x2dc81)

    #9 0x560e5b965547 in MYSQL_BIN_LOG::trx_group_commit_leader(MYSQL_BIN_LOG::group_commit_entry*) /10.3/sql/log.cc:7880

    #10 0x560e5b964562 in MYSQL_BIN_LOG::write_transaction_to_binlog_events(MYSQL_BIN_LOG::group_commit_entry*) /10.3/sql/log.cc:7711

    #11 0x560e5b962e62 in MYSQL_BIN_LOG::write_transaction_to_binlog(THD*, binlog_cache_mngr*, Log_event*, bool, bool, bool) /10.3/sql/log.cc:7385

    #12 0x560e5b9455c4 in binlog_flush_cache /10.3/sql/log.cc:1777

    #13 0x560e5b94614b in binlog_commit_flush_xid_caches /10.3/sql/log.cc:1885

    #14 0x560e5b970bfe in MYSQL_BIN_LOG::log_and_order(THD*, unsigned long long, bool, bool, bool) /10.3/sql/log.cc:9672

    #15 0x560e5b6c0b1f in ha_commit_trans(THD*, bool) /10.3/sql/handler.cc:1504

    #16 0x560e5b349f17 in trans_commit_implicit(THD*) /10.3/sql/transaction.cc:361

    #17 0x560e5afd32e8 in mysql_execute_command(THD*) /10.3/sql/sql_parse.cc:3666

    #18 0x560e5afee115 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.3/sql/sql_parse.cc:8105

    #19 0x560e5afc8c1d in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.3/sql/sql_parse.cc:1858

    #20 0x560e5afc5d81 in do_command(THD*) /10.3/sql/sql_parse.cc:1404

    #21 0x560e5b31cccf in do_handle_one_connection(CONNECT*) /10.3/sql/sql_connect.cc:1402

    #22 0x560e5b31c6ac in handle_one_connection /10.3/sql/sql_connect.cc:1308

    #23 0x7f8dc88b16b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #24 0x7f8dc7d4641c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

Address 0x7f8d99868260 is located in stack of thread T33 at offset 352 in frame

    #0 0x560e5c7b104a in my_addr_resolve /10.3/mysys/my_addr_resolve.c:195

  This frame has 4 object(s):

    [32, 48) 'timeout'

    [96, 128) 'info'

    [160, 288) 'set'

    [320, 352) 'input' <== Memory access at offset 352 overflows this variable

HINT: this may be a false positive if your program uses some custom stack unwind mechanism or swapcontext

      (longjmp and C++ exceptions *are* supported)

Thread T33 created by T0 here:

    #0 0x7f8dc9985253 in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x36253)

    #1 0x560e5c7ae3cc in spawn_thread_noop /10.3/mysys/psi_noop.c:187

    #2 0x560e5ad47244 in inline_mysql_thread_create /10.3/include/mysql/psi/mysql_thread.h:1268

    #3 0x560e5ad5bdeb in create_thread_to_handle_connection(CONNECT*) /10.3/sql/mysqld.cc:6605

    #4 0x560e5ad5c4eb in create_new_thread /10.3/sql/mysqld.cc:6675

    #5 0x560e5ad5d52e in handle_connections_sockets() /10.3/sql/mysqld.cc:6950

    #6 0x560e5ad5b2b5 in mysqld_main(int, char**) /10.3/sql/mysqld.cc:6227

    #7 0x560e5ad4596f in main /10.3/sql/main.cc:25

    #8 0x7f8dc7c5f82f in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x2082f)

SUMMARY: AddressSanitizer: stack-buffer-overflow /10.3/mysys/my_addr_resolve.c:234 my_addr_resolve

Shadow bytes around the buggy address:

  0x0ff233304ff0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0ff233305000: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0ff233305010: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0ff233305020: f1 f1 f1 f1 00 00 f4 f4 f2 f2 f2 f2 00 00 00 00

  0x0ff233305030: f2 f2 f2 f2 00 00 00 00 00 00 00 00 00 00 00 00

=>0x0ff233305040: 00 00 00 00 f2 f2 f2 f2 00 00 00 00[f3]f3 f3 f3

  0x0ff233305050: f3 f3 f3 f3 00 00 00 00 00 00 00 00 00 00 f1 f1

  0x0ff233305060: f1 f1 00 00 00 f4 f3 f3 f3 f3 00 00 00 00 00 00

  0x0ff233305070: 00 00 00 00 00 00 f1 f1 f1 f1 00 00 00 00 00 00

  0x0ff233305080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0ff233305090: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

Shadow byte legend (one shadow byte represents 8 application bytes):

  Addressable:           00

  Partially addressable: 01 02 03 04 05 06 07 

  Heap left redzone:       fa

  Heap right redzone:      fb

  Freed heap region:       fd

  Stack left redzone:      f1

  Stack mid redzone:       f2

  Stack right redzone:     f3

  Stack partial redzone:   f4

  Stack after return:      f5

  Stack use after scope:   f8

  Global redzone:          f9

  Global init order:       f6

  Poisoned by user:        f7

  Container overflow:      fc

  Array cookie:            ac

  Intra object redzone:    bb

  ASan internal:           fe

==8483==ABORTING

 --grammar=conf/mariadb/optimizer.yy --gendata-advanced --redefine=conf/mariadb/audit.yy --mysqld=--plugin_dir=/home/alice/git/mariadb-enterprise/mysql-test/var/plugins

==11103==ERROR: LeakSanitizer: detected memory leaks

Direct leak of 89400 byte(s) in 2235 object(s) allocated from:

    #0 0x7fcd17302602 in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x98602)

    #1 0x7fcce65b039c  (<unknown module>)

    #2 0x7fcce65b0de9  (<unknown module>)

    #3 0x7fcce65b96de  (<unknown module>)

    #4 0x9ed070 in sys_var_pluginvar::global_update(THD*, set_var*) /hf/sql/sql_plugin.cc:3543

    #5 0x74b8d1 in sys_var::update(THD*, set_var*) /hf/sql/set_var.cc:208

    #6 0x74fbb9 in set_var::update(THD*) /hf/sql/set_var.cc:837

    #7 0x74f398 in sql_set_variables(THD*, List<set_var_base>*, bool) /hf/sql/set_var.cc:740

    #8 0x9b1fd2 in mysql_execute_command(THD*) /hf/sql/sql_parse.cc:4927

    #9 0x9c5021 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /hf/sql/sql_parse.cc:7889

    #10 0x99eeaa in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /hf/sql/sql_parse.cc:1829

    #11 0x99bd56 in do_command(THD*) /hf/sql/sql_parse.cc:1362

    #12 0xd23e79 in do_handle_one_connection(CONNECT*) /hf/sql/sql_connect.cc:1403

    #13 0xd23834 in handle_one_connection /hf/sql/sql_connect.cc:1306

    #14 0x7fcd15d226b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

Indirect leak of 117840 byte(s) in 2946 object(s) allocated from:

    #0 0x7fcd17302602 in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x98602)

    #1 0x7fcce65b039c  (<unknown module>)

    #2 0x7fcce65b069f  (<unknown module>)

    #3 0x7fcce65b0de9  (<unknown module>)

    #4 0x7fcce65b96de  (<unknown module>)

    #5 0x9ed070 in sys_var_pluginvar::global_update(THD*, set_var*) /hf/sql/sql_plugin.cc:3543

    #6 0x74b8d1 in sys_var::update(THD*, set_var*) /hf/sql/set_var.cc:208

    #7 0x74fbb9 in set_var::update(THD*) /hf/sql/set_var.cc:837

    #8 0x74f398 in sql_set_variables(THD*, List<set_var_base>*, bool) /hf/sql/set_var.cc:740

    #9 0x9b1fd2 in mysql_execute_command(THD*) /hf/sql/sql_parse.cc:4927

    #10 0x9c5021 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /hf/sql/sql_parse.cc:7889

    #11 0x99eeaa in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /hf/sql/sql_parse.cc:1829

    #12 0x99bd56 in do_command(THD*) /hf/sql/sql_parse.cc:1362

    #13 0xd23e79 in do_handle_one_connection(CONNECT*) /hf/sql/sql_connect.cc:1403

    #14 0xd23834 in handle_one_connection /hf/sql/sql_connect.cc:1306

    #15 0x7fcd15d226b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

SUMMARY: AddressSanitizer: 207240 byte(s) leaked in 5181 allocation(s).

    #0 0x13e77ab in Log_event::Log_event(THD*, unsigned short, bool) /10.4/sql/log_event.cc:1283

    #1 0xce6f81 in Incident_log_event::Incident_log_event(THD*, Incident, st_mysql_const_lex_string const*) /10.4/sql/log_event.h:5064

    #2 0x13c1065 in MYSQL_BIN_LOG::write_incident_already_locked(THD*) /10.4/sql/log.cc:7252

    #3 0x13bee37 in MYSQL_BIN_LOG::rotate(bool, bool*) /10.4/sql/log.cc:6798

    #4 0x13bfddc in MYSQL_BIN_LOG::rotate_and_purge(bool, st_dynamic_array*) /10.4/sql/log.cc:6983

    #5 0xd8d371 in reload_acl_and_cache(THD*, unsigned long long, TABLE_LIST*, int*) /10.4/sql/sql_reload.cc:153

    #6 0x7000dc in signal_hand /10.4/sql/mysqld.cc:3297

    #7 0x7fb6d3a686b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #8 0x7fb6d2cf941c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

==1162==ERROR: AddressSanitizer: heap-use-after-free on address 0x61a000270718 at pc 0x000001fb22f8 bp 0x7ff1d18bcb70 sp 0x7ff1d18bcb60

READ of size 8 at 0x61a000270718 thread T39

    #0 0x1fb22f7 in ib_vector_size /10.4/storage/innobase/include/ut0vec.ic:118

    #1 0x1fce4d9 in fts_cache_append_deleted_doc_ids(fts_cache_t const*, ib_vector_t*) /10.4/storage/innobase/fts/fts0fts.cc:5245

    #2 0x1ffebfa in fts_query(trx_t*, dict_index_t*, unsigned int, unsigned char const*, unsigned long, fts_result_t**) /10.4/storage/innobase/fts/fts0que.cc:4015

    #3 0x198f099 in ha_innobase::ft_init_ext(unsigned int, unsigned int, String*) /10.4/storage/innobase/handler/ha_innodb.cc:9972

    #4 0x126d576 in Item_func_match::init_search(THD*, bool) /10.4/sql/item_func.cc:5837

    #5 0x861063 in init_ftfuncs(THD*, st_select_lex*, bool) /10.4/sql/sql_base.cc:8962

    #6 0xa4fcb5 in JOIN::optimize_stage2() /10.4/sql/sql_select.cc:2726

    #7 0xa4a926 in JOIN::optimize_inner() /10.4/sql/sql_select.cc:2219

    #8 0xa44806 in JOIN::optimize() /10.4/sql/sql_select.cc:1563

    #9 0xa61d11 in mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.4/sql/sql_select.cc:4591

    #10 0xa38567 in handle_select(THD*, LEX*, select_result*, unsigned long) /10.4/sql/sql_select.cc:425

    #11 0x9bbaf6 in execute_sqlcom_select /10.4/sql/sql_parse.cc:6356

    #12 0x9aa08b in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:3898

    #13 0xa0ba9d in Prepared_statement::execute(String*, bool) /10.4/sql/sql_prepare.cc:4760

    #14 0xa077e3 in Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) /10.4/sql/sql_prepare.cc:4246

    #15 0xa020f0 in mysql_sql_stmt_execute(THD*) /10.4/sql/sql_prepare.cc:3363

    #16 0x9aa0d0 in mysql_execute_command(THD*) /10.4/sql/sql_parse.cc:3914

    #17 0x9c3f83 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/sql/sql_parse.cc:7908

    #18 0x99ddbd in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/sql/sql_parse.cc:1843

    #19 0x99abfb in do_command(THD*) /10.4/sql/sql_parse.cc:1360

    #20 0xd1d666 in do_handle_one_connection(CONNECT*) /10.4/sql/sql_connect.cc:1404

    #21 0xd1d00c in handle_one_connection /10.4/sql/sql_connect.cc:1306

    #22 0x7ff2024906b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #23 0x7ff20172141c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

2019-10-14 15:17:31 0 [ERROR] mysqld: File './multi-master.info' not found (Errcode: 13 "Permission denied")

2019-10-14 15:17:31 0 [ERROR] Creation of Master_info index file './multi-master.info' failed

2019-10-14 15:17:31 0 [ERROR] Failed to initialize multi master structures

2019-10-14 15:17:31 0 [ERROR] Aborting

191014 15:17:31 [ERROR] mysqld got signal 11 ;

Server version: 10.4.8-MariaDB

stack_bottom = 0x0 thread_stack 0x49000

mysys/stacktrace.c:270(my_print_stacktrace)[0x55eafc0d309b]

sql/signal_handler.cc:209(handle_fatal_signal)[0x55eafbb315f7]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f576afbe390]

mysys/hash.c:129(my_hash_free_elements)[0x55eafc0b3b65]

sql/rpl_mi.cc:1059(Master_info_index::~Master_info_index())[0x55eafba18188]

sql/slave.cc:1469(end_slave())[0x55eafb8a4f50]

sql/mysqld.cc:1967(clean_up(bool) [clone .part.213])[0x55eafb8882f5]

sql/mysqld.cc:1907(unireg_abort)[0x55eafb88af54]

sql/mysqld.cc:5838(mysqld_main(int, char**))[0x55eafb88f936]

csu/libc-start.c:325(__libc_start_main)[0x7f576a374830]

2019-02-08  7:21:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=21639

2019-02-08  7:21:43 0 [Note] InnoDB: Starting final batch to recover 143 pages from redo log.

2019-02-08  7:21:44 0 [Warning] InnoDB: A transaction id in a record of table `SYS_TABLES` is newer than the system-wide maximum.

mysqld: /git/10.4/storage/innobase/trx/trx0sys.cc:62: static void ReadView::check_trx_id_sanity(trx_id_t, const table_name_t&): Assertion `0' failed.

190208  7:21:44 [ERROR] mysqld got signal 6 ;

assert/assert.c:92(__assert_fail_base)[0x7f2289e4abd7]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f2289e4ac82]

trx/trx0sys.cc:62(ReadView::check_trx_id_sanity(unsigned long, table_name_t const&))[0x559b986d48a9]

include/read0types.h:222(ReadView::changes_visible(unsigned long, table_name_t const&) const)[0x559b98434fe0]

lock/lock0lock.cc:404(lock_clust_rec_cons_read_sees(unsigned char const*, dict_index_t*, unsigned long const*, ReadView*))[0x559b9840f49b]

row/row0sel.cc:1900(row_sel(sel_node_t*, que_thr_t*))[0x559b98603ab3]

row/row0sel.cc:2344(row_sel_step(que_thr_t*))[0x559b986055aa]

que/que0que.cc:1018(que_thr_step(que_thr_t*))[0x559b984f41c3]

que/que0que.cc:1104(que_run_threads_low(que_thr_t*))[0x559b984f482a]

que/que0que.cc:1146(que_run_threads(que_thr_t*))[0x559b984f4b71]

fts/fts0sql.cc:240(fts_eval_sql(trx_t*, que_fork_t*))[0x559b9896994a]

fts/fts0fts.cc:7134(fts_drop_orphaned_tables())[0x559b9893a566]

log/log0recv.cc:3596(recv_recovery_rollback_active())[0x559b9846b886]

srv/srv0start.cc:2150(srv_start(bool))[0x559b98661a74]

handler/ha_innodb.cc:4249(innodb_init(void*))[0x559b982e0511]

sql/handler.cc:530(ha_initialize_handlerton(st_plugin_int*))[0x559b97aa2367]

sql/sql_plugin.cc:1437(plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool))[0x559b9739e476]

sql/sql_plugin.cc:1719(plugin_init(int*, char**, int))[0x559b9739fce3]

sql/mysqld.cc:5151(init_server_components())[0x559b970d81fb]

sql/mysqld.cc:5680(mysqld_main(int, char**))[0x559b970da0fe]

sql/main.cc:26(main)[0x559b970c4650]

csu/libc-start.c:325(__libc_start_main)[0x7f2289e3d830]

rpl.rpl_gtid_crash 'innodb,stmt'         w24 [ 2 fail ]

        Test ended at 2020-01-14 15:15:37

CURRENT_TEST: rpl.rpl_gtid_crash

Server [mysqld.1 - pid: 47347, winpid: 47347, exit: 256] failed during test run

Server log from this test:

----------SERVER LOG START-----------

2020-01-14 15:13:39 16 [Note] Deleted Master_info file '/10.3/mysql-test/var/24/mysqld.1/data/master.info'.

2020-01-14 15:13:39 16 [Note] Deleted Master_info file '/10.3/mysql-test/var/24/mysqld.1/data/relay-log.info'.

2020-01-14 15:13:39 18 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 4)

2020-01-14 15:13:55 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)

2020-01-14 15:13:55 19 [Note] Start binlog_dump to slave_server(2), pos(, 4)

dispatch_command: crash_dispatch_command_before: now

SIGKILL myself

2020-01-14 15:14:53 0 [Note] /10.3/sql/mysqld (mysqld 10.3.22-MariaDB-debug-log) starting as process 39163 ...

2020-01-14 15:14:53 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4246)

2020-01-14 15:14:53 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2020-01-14 15:14:53 0 [Note] Plugin 'partition' is disabled.

2020-01-14 15:14:53 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2020-01-14 15:14:53 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-14 15:14:53 0 [Note] InnoDB: Uses event mutexes

2020-01-14 15:14:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-14 15:14:53 0 [Note] InnoDB: Number of pools: 1

2020-01-14 15:14:53 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-01-14 15:14:53 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2020-01-14 15:14:53 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-14 15:14:53 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-14 15:14:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1939167

2020-01-14 15:14:54 0 [Note] InnoDB: Transaction 960 was in the XA prepared state.

2020-01-14 15:14:54 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo

2020-01-14 15:14:54 0 [Note] InnoDB: Trx id counter is 961

2020-01-14 15:14:54 0 [Note] InnoDB: Last binlog file './master-bin.000001', position 36977

2020-01-14 15:14:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-01-14 15:14:54 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2020-01-14 15:14:54 0 [Note] InnoDB: Rollback of non-prepared transactions completed

2020-01-14 15:14:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2020-01-14 15:14:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-01-14 15:14:54 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-01-14 15:14:54 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2020-01-14 15:14:54 0 [Note] InnoDB: 10.3.22 started; log sequence number 1939592; transaction id 963

2020-01-14 15:14:54 0 [Note] InnoDB: Loading buffer pool(s) from /10.3/mysql-test/var/24/mysqld.1/data/ib_buffer_pool

2020-01-14 15:14:54 0 [Note] Plugin 'SEQUENCE' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2020-01-14 15:14:54 0 [Note] InnoDB: Buffer pool(s) load completed at 200114 15:14:54

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_CMP' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'user_variables' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2020-01-14 15:14:54 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.

2020-01-14 15:14:54 0 [Warning] /10.3/sql/mysqld: unknown option '--loose-pam-debug'

2020-01-14 15:14:54 0 [Note] Recovering after a crash using master-bin

2020-01-14 15:14:54 0 [Note] Starting crash recovery...

2020-01-14 15:14:54 0 [Note] InnoDB: Starting recovery for XA transactions...

2020-01-14 15:14:54 0 [Note] InnoDB: Transaction 960 in prepared state after recovery

2020-01-14 15:14:54 0 [Note] InnoDB: Transaction contains changes to 1 rows

2020-01-14 15:14:54 0 [Note] InnoDB: 1 transactions in prepared state after recovery

2020-01-14 15:14:54 0 [Note] Found 1 prepared transaction(s) in InnoDB

2020-01-14 15:14:54 0 [Note] Crash recovery finished.

2020-01-14 15:14:54 0 [Note] Server socket created on IP: '127.0.0.1'.

2020-01-14 15:14:54 0 [Note] Reading of all Master_info entries succeeded

2020-01-14 15:14:54 0 [Note] Added new Master_info '' to hash table

2020-01-14 15:14:54 0 [Note] /10.3/sql/mysqld: ready for connections.

Version: '10.3.22-MariaDB-debug-log'  socket: '/10.3/mysql-test/var/tmp/24/mysqld.1.sock'  port: 16440  Source distribution

2020-01-14 15:14:55 10 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000001, 37150)

2020-01-14 15:14:57 11 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000002, 664)

dispatch_command: crash_dispatch_command_before: now

SIGKILL myself

2020-01-14 15:14:58 0 [Note] /10.3/sql/mysqld (mysqld 10.3.22-MariaDB-debug-log) starting as process 40625 ...

2020-01-14 15:14:58 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4246)

2020-01-14 15:14:58 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2020-01-14 15:14:58 0 [Note] Plugin 'partition' is disabled.

2020-01-14 15:14:58 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2020-01-14 15:14:58 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-14 15:14:58 0 [Note] InnoDB: Uses event mutexes

2020-01-14 15:14:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-14 15:14:58 0 [Note] InnoDB: Number of pools: 1

2020-01-14 15:14:58 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-01-14 15:14:58 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2020-01-14 15:14:58 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-14 15:14:58 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-14 15:14:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1940892

2020-01-14 15:14:58 0 [Note] InnoDB: Starting final batch to recover 11 pages from redo log.

2020-01-14 15:14:58 0 [Note] InnoDB: Last binlog file './master-bin.000002', position 568

2020-01-14 15:14:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-01-14 15:14:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2020-01-14 15:14:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-01-14 15:14:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-01-14 15:14:58 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2020-01-14 15:14:58 0 [Note] InnoDB: 10.3.22 started; log sequence number 1944549; transaction id 980

2020-01-14 15:14:58 0 [Note] InnoDB: Loading buffer pool(s) from /10.3/mysql-test/var/24/mysqld.1/data/ib_buffer_pool

2020-01-14 15:14:58 0 [Note] Plugin 'SEQUENCE' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_CMP' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'user_variables' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2020-01-14 15:14:58 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.

2020-01-14 15:14:58 0 [Warning] /10.3/sql/mysqld: unknown option '--loose-pam-debug'

2020-01-14 15:14:58 0 [Note] Recovering after a crash using master-bin

2020-01-14 15:14:58 0 [Note] Starting crash recovery...

2020-01-14 15:14:58 0 [Note] InnoDB: Buffer pool(s) load completed at 200114 15:14:58

2020-01-14 15:14:58 0 [Note] Crash recovery finished.

2020-01-14 15:14:58 0 [Note] Server socket created on IP: '127.0.0.1'.

2020-01-14 15:14:58 0 [Note] Reading of all Master_info entries succeeded

2020-01-14 15:14:58 0 [Note] Added new Master_info '' to hash table

2020-01-14 15:14:58 0 [Note] /10.3/sql/mysqld: ready for connections.

Version: '10.3.22-MariaDB-debug-log'  socket: '/10.3/mysql-test/var/tmp/24/mysqld.1.sock'  port: 16440  Source distribution

2020-01-14 15:14:58 10 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000003, 419)

2020-01-14 15:14:58 11 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 375)

2020-01-14 15:15:01 12 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 4)

2020-01-14 15:15:02 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)

2020-01-14 15:15:04 14 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 540)

2020-01-14 15:15:04 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'root' host: 'localhost' (A slave with the same server_uuid/server_id as this slave has co)

2020-01-14 15:15:04 15 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 705)

2020-01-14 15:15:06 16 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 705)

2020-01-14 15:15:06 17 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 870)

2020-01-14 15:15:09 18 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 4)

2020-01-14 15:15:09 17 [Warning] Aborted connection 17 to db: 'unconnected' user: 'root' host: 'localhost' (A slave with the same server_uuid/server_id as this slave has co)

2020-01-14 15:15:09 19 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 1035)

2020-01-14 15:15:11 20 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 4)

2020-01-14 15:15:11 19 [Warning] Aborted connection 19 to db: 'unconnected' user: 'root' host: 'localhost' (A slave with the same server_uuid/server_id as this slave has co)

2020-01-14 15:15:14 21 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 4)

2020-01-14 15:15:14 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

dispatch_command: crash_dispatch_command_before: now

SIGKILL myself

2020-01-14 15:15:15 0 [Note] /10.3/sql/mysqld (mysqld 10.3.22-MariaDB-debug-log) starting as process 44708 ...

2020-01-14 15:15:15 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4246)

2020-01-14 15:15:15 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2020-01-14 15:15:15 0 [Note] Plugin 'partition' is disabled.

2020-01-14 15:15:15 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2020-01-14 15:15:15 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-14 15:15:15 0 [Note] InnoDB: Uses event mutexes

2020-01-14 15:15:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-14 15:15:15 0 [Note] InnoDB: Number of pools: 1

2020-01-14 15:15:15 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-01-14 15:15:15 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2020-01-14 15:15:15 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-14 15:15:15 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-14 15:15:15 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1947409

2020-01-14 15:15:15 0 [Note] InnoDB: Starting final batch to recover 1 pages from redo log.

2020-01-14 15:15:16 0 [Note] InnoDB: Last binlog file './master-bin.000004', position 1371

2020-01-14 15:15:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-01-14 15:15:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2020-01-14 15:15:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-01-14 15:15:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-01-14 15:15:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2020-01-14 15:15:16 0 [Note] InnoDB: 10.3.22 started; log sequence number 1947842; transaction id 996

2020-01-14 15:15:16 0 [Note] InnoDB: Loading buffer pool(s) from /10.3/mysql-test/var/24/mysqld.1/data/ib_buffer_pool

2020-01-14 15:15:16 0 [Note] Plugin 'SEQUENCE' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_CMP' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'user_variables' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2020-01-14 15:15:16 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.

2020-01-14 15:15:16 0 [Warning] /10.3/sql/mysqld: unknown option '--loose-pam-debug'

2020-01-14 15:15:16 0 [Note] Recovering after a crash using master-bin

2020-01-14 15:15:16 0 [Note] Starting crash recovery...

2020-01-14 15:15:16 0 [Note] InnoDB: Buffer pool(s) load completed at 200114 15:15:16

2020-01-14 15:15:16 0 [Note] Crash recovery finished.

2020-01-14 15:15:16 0 [Note] Server socket created on IP: '127.0.0.1'.

2020-01-14 15:15:16 0 [Note] Reading of all Master_info entries succeeded

2020-01-14 15:15:16 0 [Note] Added new Master_info '' to hash table

2020-01-14 15:15:16 0 [Note] /10.3/sql/mysqld: ready for connections.

Version: '10.3.22-MariaDB-debug-log'  socket: '/10.3/mysql-test/var/tmp/24/mysqld.1.sock'  port: 16440  Source distribution

2020-01-14 15:15:17 10 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000004, 1506)

2020-01-14 15:15:18 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

dispatch_command: crash_dispatch_command_before: now

SIGKILL myself

2020-01-14 15:15:22 0 [Note] /10.3/sql/mysqld (mysqld 10.3.22-MariaDB-debug-log) starting as process 45981 ...

2020-01-14 15:15:22 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4246)

2020-01-14 15:15:22 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2020-01-14 15:15:22 0 [Note] Plugin 'partition' is disabled.

2020-01-14 15:15:22 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2020-01-14 15:15:22 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-14 15:15:22 0 [Note] InnoDB: Uses event mutexes

2020-01-14 15:15:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-14 15:15:22 0 [Note] InnoDB: Number of pools: 1

2020-01-14 15:15:22 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-01-14 15:15:22 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2020-01-14 15:15:22 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-14 15:15:22 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-14 15:15:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1948120

2020-01-14 15:15:23 0 [Note] InnoDB: Starting final batch to recover 1 pages from redo log.

2020-01-14 15:15:23 0 [Note] InnoDB: Last binlog file './master-bin.000004', position 1371

2020-01-14 15:15:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-01-14 15:15:23 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2020-01-14 15:15:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-01-14 15:15:23 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-01-14 15:15:23 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2020-01-14 15:15:23 0 [Note] InnoDB: 10.3.22 started; log sequence number 1948283; transaction id 1000

2020-01-14 15:15:23 0 [Note] InnoDB: Loading buffer pool(s) from /10.3/mysql-test/var/24/mysqld.1/data/ib_buffer_pool

2020-01-14 15:15:23 0 [Note] Plugin 'SEQUENCE' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_CMP' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'user_variables' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2020-01-14 15:15:23 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.

2020-01-14 15:15:23 0 [Warning] /10.3/sql/mysqld: unknown option '--loose-pam-debug'

2020-01-14 15:15:23 0 [Note] Recovering after a crash using master-bin

2020-01-14 15:15:23 0 [Note] Starting crash recovery...

2020-01-14 15:15:23 0 [Note] InnoDB: Buffer pool(s) load completed at 200114 15:15:23

2020-01-14 15:15:23 0 [Note] Crash recovery finished.

2020-01-14 15:15:23 0 [Note] Server socket created on IP: '127.0.0.1'.

2020-01-14 15:15:23 0 [Note] Reading of all Master_info entries succeeded

2020-01-14 15:15:23 0 [Note] Added new Master_info '' to hash table

2020-01-14 15:15:23 0 [Note] /10.3/sql/mysqld: ready for connections.

Version: '10.3.22-MariaDB-debug-log'  socket: '/10.3/mysql-test/var/tmp/24/mysqld.1.sock'  port: 16440  Source distribution

2020-01-14 15:15:23 10 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000005, 510)

2020-01-14 15:15:30 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

dispatch_command: crash_dispatch_command_before: now

SIGKILL myself

2020-01-14 15:15:33 0 [Note] /10.3/sql/mysqld (mysqld 10.3.22-MariaDB-debug-log) starting as process 46934 ...

2020-01-14 15:15:33 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4246)

2020-01-14 15:15:33 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2020-01-14 15:15:33 0 [Note] Plugin 'partition' is disabled.

2020-01-14 15:15:33 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2020-01-14 15:15:33 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-14 15:15:33 0 [Note] InnoDB: Uses event mutexes

2020-01-14 15:15:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-14 15:15:33 0 [Note] InnoDB: Number of pools: 1

2020-01-14 15:15:33 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-01-14 15:15:34 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2020-01-14 15:15:34 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-14 15:15:34 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-14 15:15:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1949413

2020-01-14 15:15:34 0 [Note] InnoDB: Starting final batch to recover 1 pages from redo log.

2020-01-14 15:15:35 0 [Note] InnoDB: Last binlog file './master-bin.000006', position 707

2020-01-14 15:15:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2020-01-14 15:15:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2020-01-14 15:15:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-01-14 15:15:35 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-01-14 15:15:35 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2020-01-14 15:15:35 0 [Note] InnoDB: Waiting for purge to start

2020-01-14 15:15:35 0 [Note] InnoDB: 10.3.22 started; log sequence number 1949588; transaction id 1008

2020-01-14 15:15:35 0 [Note] InnoDB: Loading buffer pool(s) from /10.3/mysql-test/var/24/mysqld.1/data/ib_buffer_pool

2020-01-14 15:15:35 0 [Note] Plugin 'SEQUENCE' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_CMP' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'user_variables' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2020-01-14 15:15:35 0 [Note] InnoDB: Buffer pool(s) load completed at 200114 15:15:35

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2020-01-14 15:15:35 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.

2020-01-14 15:15:35 0 [Warning] /10.3/sql/mysqld: unknown option '--loose-pam-debug'

2020-01-14 15:15:35 0 [Note] Recovering after a crash using master-bin

2020-01-14 15:15:35 0 [Note] Starting crash recovery...

2020-01-14 15:15:35 0 [Note] Crash recovery finished.

2020-01-14 15:15:35 0 [Note] Server socket created on IP: '127.0.0.1'.

2020-01-14 15:15:35 0 [Note] Reading of all Master_info entries succeeded

2020-01-14 15:15:35 0 [Note] Added new Master_info '' to hash table

2020-01-14 15:15:35 0 [Note] /10.3/sql/mysqld: ready for connections.

Version: '10.3.22-MariaDB-debug-log'  socket: '/10.3/mysql-test/var/tmp/24/mysqld.1.sock'  port: 16440  Source distribution

2020-01-14 15:15:35 10 [Note] Start binlog_dump to slave_server(2), pos(master-bin.000006, 842)

2020-01-14 15:15:36 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

dispatch_command: crash_dispatch_command_before: now

SIGKILL myself

2020-01-14 15:15:37 0 [Note] /10.3/sql/mysqld (mysqld 10.3.22-MariaDB-debug-log) starting as process 47348 ...

2020-01-14 15:15:37 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4246)

2020-01-14 15:15:37 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2020-01-14 15:15:37 0 [Note] Plugin 'partition' is disabled.

2020-01-14 15:15:37 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2020-01-14 15:15:37 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-14 15:15:37 0 [Note] InnoDB: Uses event mutexes

2020-01-14 15:15:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-14 15:15:37 0 [Note] InnoDB: Number of pools: 1

2020-01-14 15:15:37 0 [Note] InnoDB: Using SSE2 crc32 instructions

2020-01-14 15:15:37 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M

2020-01-14 15:15:37 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-14 15:15:37 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-14 15:15:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1949882

mysqld: /10.3/storage/innobase/log/log0recv.cc:2866: bool recv_parse_log_recs(lsn_t, store_t*, ulint, bool): Assertion `recv_sys->mlog_checkpoint_lsn <= recv_sys->recovered_lsn' failed.

----------SERVER LOG END-------------

mysqltest failed but provided no output

The result from queries just before the failure was:

< snip >

SELECT * from t1 WHERE a > 10 ORDER BY a;

a

13

14

gtid_check

Binlog pos ok

gtid_check

Slave pos ok

gtid_check

Current pos ok

# Repeat this with additional transactions on the master

connection server_1;

SET GLOBAL debug_dbug="+d,inject_error_writing_xid";

BEGIN;

INSERT INTO t1 VALUES (22);

COMMIT;

ERROR HY000: Error writing file 'master-bin' (errno: 28 "No space left on device")

SET GLOBAL debug_dbug="+d,crash_dispatch_command_before";

COMMIT;

Got one of the listed errors

 - saving '/10.3/mysql-test/var/24/log/rpl.rpl_gtid_crash-innodb,stmt/' to '/10.3/mysql-test/var/log/rpl.rpl_gtid_crash-innodb,stmt/'

***Warnings generated in error logs during shutdown after running tests: rpl.rpl_gtid_crash

2020-01-14 15:15:14 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

2020-01-14 15:15:18 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

2020-01-14 15:15:30 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

2020-01-14 15:15:36 9 [ERROR] mysqld: Error writing file 'master-bin' (errno: 28 "No space left on device")

mysqld: /10.3/storage/innobase/log/log0recv.cc:2866: bool recv_parse_log_recs(lsn_t, store_t*, ulint, bool): Assertion `recv_sys->mlog_checkpoint_lsn <= recv_sys->recovered_lsn' failed.

2020-01-14 15:15:17 10 [Warning] The server_id of master server changed in the middle of GTID 0-1-8. Assuming a change of master server, so rolling back the previously received partial transaction. Expected: 1, received: 3

2020-01-14 15:15:23 10 [Warning] The server_id of master server changed in the middle of GTID 0-3-8. Assuming a change of master server, so rolling back the previously received partial transaction. Expected: 3, received: 1

2020-01-14 15:15:35 10 [Warning] Unexpected change of master binlog file name in the middle of GTID 0-1-10, assuming that master has crashed and rolling back the transaction. Expected: 'master-bin.000006', received: 'master-bin.000007'

/10.5/sql/mysqld(+0x17903f0)[0x560714bc23f0]

/10.5/sql/mysqld(_ZN31Multiupdate_prelocking_strategy10handle_endEP3THD+0x774)[0x560714bc3ea2]

/10.5/sql/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xf58)[0x5607147532b5]

/10.5/sql/mysqld(+0x1783e1c)[0x560714bb5e1c]

/10.5/sql/mysqld(_Z26mysql_multi_update_prepareP3THD+0x30c)[0x560714bc4d82]

/10.5/sql/mysqld(_Z21mysql_execute_commandP3THD+0x7c0f)[0x5607148de734]

/10.5/sql/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x20)[0x56071469d316]

/10.5/sql/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x864)[0x56071469bb2a]

/10.5/sql/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x4af)[0x56071469cac5]

/10.5/sql/mysqld(_ZN7sp_head7executeEP3THDb+0x161a)[0x56071468e642]

/10.5/sql/mysqld(_ZN7sp_head15execute_triggerEP3THDPK25st_mysql_const_lex_stringS4_P13st_grant_info+0x6be)[0x5607146913fa]

/10.5/sql/mysqld(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x6c2)[0x560714b8fe92]

/10.5/sql/mysqld(_Z36fill_record_n_invoke_before_triggersP3THDP5TABLEPP5FieldR4ListI4ItemEb14trg_event_type+0xdd)[0x56071476f246]

/10.5/sql/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesbP13select_result+0x2424)[0x56071481dbd5]

/10.5/sql/mysqld(_Z21mysql_execute_commandP3THD+0x8937)[0x5607148df45c]

/10.5/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x6b0)[0x5607148f7790]

/10.5/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x221d)[0x5607148ce014]

/10.5/sql/mysqld(_Z10do_commandP3THD+0x10f5)[0x5607148caa62]

/10.5/sql/mysqld(_Z24do_handle_one_connectionP7CONNECTb+0x590)[0x560714ce2bda]

/10.5/sql/mysqld(handle_one_connection+0x80)[0x560714ce2470]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7fdcbce9efa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fdcbc4cf4cf]

Query (0x625000b74990): UPDATE view4 SET field1 = 'ass', field3 = 'r', field2 = 'x', field4 = 2 ORDER BY field1, field2, field3, field4 LIMIT 3

mysqld: /10.5/storage/innobase/log/log0log.cc:1557: bool log_checkpoint(): Assertion `oldest_lsn >= log_sys.last_checkpoint_lsn' failed.

/10.5/sql/mysqld(handle_fatal_signal+0x9df)[0x557b51107fc5]

/10.5/sql/mysqld(+0x28796cb)[0x557b51d356cb]

/10.5/sql/mysqld(+0x2af0c55)[0x557b51facc55]

/10.5/sql/mysqld(+0x2af1202)[0x557b51fad202]

/10.5/sql/mysqld(_ZN5tpool19thread_pool_generic13timer_generic3runEv+0x184)[0x557b523d1d1e]

/10.5/sql/mysqld(_ZN5tpool19thread_pool_generic13timer_generic7executeEPv+0x20)[0x557b523d1f61]

/10.5/sql/mysqld(_ZN5tpool4task7executeEv+0xb9)[0x557b523def33]

/10.5/sql/mysqld(_ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE+0x1d7)[0x557b523cdcbb]

/10.5/sql/mysqld(_ZSt13__invoke_implIvMN5tpool19thread_pool_genericEFvPNS0_11worker_dataEEPS1_JS3_EET_St21__invoke_memfun_derefOT0_OT1_DpOT2_+0x167)[0x557b523d6c2a]

/10.5/sql/mysqld(_ZSt8__invokeIMN5tpool19thread_pool_genericEFvPNS0_11worker_dataEEJPS1_S3_EENSt15__invoke_resultIT_JDpT0_EE4typeEOS8_DpOS9_+0xd7)[0x557b523d49ba]

/10.5/sql/mysqld(_ZNSt6thread8_InvokerISt5tupleIJMN5tpool19thread_pool_genericEFvPNS2_11worker_dataEEPS3_S5_EEE9_M_invokeIJLm0ELm1ELm2EEEEDTcl8__invokespcl10_S_declvalIXT_EEEEESt12_Index_tupleIJXspT_EEE+0x5f)[0x557b523ddf83]

/10.5/sql/mysqld(_ZNSt6thread8_InvokerISt5tupleIJMN5tpool19thread_pool_genericEFvPNS2_11worker_dataEEPS3_S5_EEEclEv+0x8d)[0x557b523dded9]

/10.5/sql/mysqld(_ZNSt6thread11_State_implINS_8_InvokerISt5tupleIJMN5tpool19thread_pool_genericEFvPNS3_11worker_dataEEPS4_S6_EEEEE6_M_runEv+0x1c)[0x557b523dde48]

/usr/lib/x86_64-linux-gnu/libstdc++.so.6(+0xbbb2f)[0x7fc12913eb2f]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7fc1297edfa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc128e1e4cf]

2020-03-12 12:08:05 9 [ERROR] Slave I/O: The slave I/O thread stops because a fatal error is encountered when it try to get the value of SERVER_ID variable from master. Error: Commands out of sync; you can't run this command now, Internal MariaDB error code: 2014

2020-03-12 12:08:05 9 [Note] Slave I/O thread exiting, read up to log 'dell-desktop-bin.000001', position 155

ASAN:SIGSEGV

=================================================================

==18943==ERROR: AddressSanitizer: SEGV on unknown address 0x000000000000 (pc 0x0000010c98f2 bp 0x7f48f8647340 sp 0x7f48f8647280 T18)

2020-03-12 12:08:05 11 [Note] Start binlog_dump to slave_server(8), pos(, 4)

    #0 0x10c98f1 in mysql_ssl_free /bb-10.5-mdev_742/src/sql-common/client.c:1508

    #1 0x10d3823 in mysql_close_free_options /bb-10.5-mdev_742/src/sql-common/client.c:3348

    #2 0x10d41c7 in mysql_close /bb-10.5-mdev_742/src/sql-common/client.c:3493

    #3 0x7c3629 in handle_slave_io /bb-10.5-mdev_742/src/sql/slave.cc:5124

    #4 0x19d854d in pfs_spawn_thread /bb-10.5-mdev_742/src/storage/perfschema/pfs.cc:2201

    #5 0x7f491f42f6b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

    #6 0x7f491e6c041c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)

AddressSanitizer can not provide additional info.

SUMMARY: AddressSanitizer: SEGV /bb-10.5-mdev_742/src/sql-common/client.c:1508 mysql_ssl_free

Thread T18 created by T17 here:

    #0 0x7f49209ad253 in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x36253)

    #1 0x19d3470 in my_thread_create /bb-10.5-mdev_742/src/storage/perfschema/my_thread.h:34

    #2 0x19d893c in pfs_spawn_thread_v1 /bb-10.5-mdev_742/src/storage/perfschema/pfs.cc:2252

    #3 0x7a6667 in inline_mysql_thread_create /bb-10.5-mdev_742/src/include/mysql/psi/mysql_thread.h:1321

    #4 0x7ae371 in start_slave_thread(unsigned int, void* (*)(void*), st_mysql_mutex*, st_mysql_mutex*, st_mysql_cond*, unsigned int volatile*, unsigned long volatile*, Master_info*) /bb-10.5-mdev_742/src/sql/slave.cc:1299

    #5 0x7aecd3 in start_slave_threads(THD*, bool, bool, Master_info*, char const*, char const*, int) /bb-10.5-mdev_742/src/sql/slave.cc:1422

    #6 0xa9a035 in start_slave(THD*, Master_info*, bool) /bb-10.5-mdev_742/src/sql/sql_repl.cc:3238

    #7 0xa14cc1 in mysql_execute_command(THD*) /bb-10.5-mdev_742/src/sql/sql_parse.cc:4197

    #8 0xa2dc5c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /bb-10.5-mdev_742/src/sql/sql_parse.cc:7926

    #9 0xa06f1c in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /bb-10.5-mdev_742/src/sql/sql_parse.cc:1840

    #10 0xa03de2 in do_command(THD*) /bb-10.5-mdev_742/src/sql/sql_parse.cc:1359

    #11 0xdc8819 in do_handle_one_connection(CONNECT*, bool) /bb-10.5-mdev_742/src/sql/sql_connect.cc:1422

    #12 0xdc81fc in handle_one_connection /bb-10.5-mdev_742/src/sql/sql_connect.cc:1319

    #13 0x19d854d in pfs_spawn_thread /bb-10.5-mdev_742/src/storage/perfschema/pfs.cc:2201

    #14 0x7f491f42f6b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)

Thread T17 created by T0 here:

    #0 0x7f49209ad253 in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x36253)

    #1 0x19d3470 in my_thread_create /bb-10.5-mdev_742/src/storage/perfschema/my_thread.h:34

    #2 0x19d893c in pfs_spawn_thread_v1 /bb-10.5-mdev_742/src/storage/perfschema/pfs.cc:2252

    #3 0x7406f5 in inline_mysql_thread_create /bb-10.5-mdev_742/src/include/mysql/psi/mysql_thread.h:1321

    #4 0x754af6 in create_thread_to_handle_connection(CONNECT*) /bb-10.5-mdev_742/src/sql/mysqld.cc:6095

    #5 0x7550a6 in create_new_thread(CONNECT*) /bb-10.5-mdev_742/src/sql/mysqld.cc:6154

    #6 0x75528c in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /bb-10.5-mdev_742/src/sql/mysqld.cc:6219

    #7 0x755cae in handle_connections_sockets() /bb-10.5-mdev_742/src/sql/mysqld.cc:6346

    #8 0x754331 in mysqld_main(int, char**) /bb-10.5-mdev_742/src/sql/mysqld.cc:5754

    #9 0x73ede5 in main /bb-10.5-mdev_742/src/sql/main.cc:25

    #10 0x7f491e5d982f in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x2082f)

==18943==ABORTING

mysqld:/10.5/storage/innobase/row/row0sel.cc:3376: dberr_t Row_sel_get_clust_rec_for_mysql::operator()(row_prebuilt_t*, dict_index_t*, const rec_t*, que_thr_t*, const rec_t**, offset_t**, mem_heap_t**, dtuple_t**, mtr_t*): Assertion `0' failed.

200319 15:40:26 [ERROR] mysqld got signal 6 ;

Server version: 10.5.2-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7ffb1f3ee535]

stdlib/abort.c:81(__GI_abort)[0x7ffb1f3ee40f]

row/row0sel.cc:3379(Row_sel_get_clust_rec_for_mysql::operator()(row_prebuilt_t*, dict_index_t*, unsigned char const*, que_thr_t*, unsigned char const**, unsigned short**, mem_block_info_t**, dtuple_t**, mtr_t*))[0x560214baa5a6]

row/row0sel.cc:5251(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5602141067eb]

handler/ha_innodb.cc:8996(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5602140da2ec]

sql/handler.h:3689(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5602140f3764]

sql/handler.cc:3013(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x560213de85ea]

sql/handler.cc:5961(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x560213de89be]

sql/multi_range_read.cc:353(handler::multi_range_read_next(void**))[0x560213df2461]

sql/multi_range_read.cc:390(Mrr_simple_index_reader::get_next(void**))[0x560214bdbf5a]

sql/multi_range_read.cc:1491(DsMrr_impl::dsmrr_next(void**))[0x5602144d2817]

sql/opt_range.cc:12168(QUICK_RANGE_SELECT::get_next())[0x560214505bcf]

sql/records.cc:395(rr_quick(READ_RECORD*))[0x560213760232]

/d1/git/10.5/sql/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP10SQL_I_ListI8st_orderEyyP13select_result+0x4128)[0x56021454f2b6]

sql/records.h:79(READ_RECORD::read_record())[0x56021391687d]

sql/sql_delete.cc:755(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*))[0x56021392c94e]

sql/sql_parse.cc:4741(mysql_execute_command(THD*))[0x560213902c5b]

sql/sql_parse.cc:7926(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5602138ff68c]

sql/sql_parse.cc:1842(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x560213d19b7d]

sql/sql_parse.cc:1358(do_command(THD*))[0x560213d19418]

sql/sql_connect.cc:1422(do_handle_one_connection(CONNECT*, bool))[0x5602149b06e4]

nptl/pthread_create.c:487(start_thread)[0x7ffb1fe94fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7ffb1f4c54cf]

Query (0x62b0000d22a8): DELETE  FROM `table10_innodb` WHERE `col_int_key` < 0

10.5/sql/sql_string.cc:106: bool Binary_string::realloc_raw(size_t): Assertion `str_length < len' failed.

200319 15:06:12 [ERROR] mysqld got signal 6 ;

linux/raise.c:51(__GI_raise)[0x7fd4db8aa535]

stdlib/abort.c:81(__GI_abort)[0x7fd4db8aa40f]

sql/sql_string.cc:107(Binary_string::realloc_raw(unsigned long))[0x55bc0c772a7d]

sql/sql_string.h:645(Binary_string::realloc(unsigned long))[0x55bc0d51f47a]

sql/sql_string.h:608(Binary_string::c_ptr())[0x55bc0c92cc66]

sql/lock.cc:804(get_lock_data(THD*, TABLE**, unsigned int, unsigned int))[0x55bc0ce86f1f]

sql/lock.cc:613(mysql_lock_abort_for_thread(THD*, TABLE*))[0x55bc0ce80dd3]

sql/mdl.cc:579(MDL_lock::notify_conflicting_locks(MDL_context*))[0x55bc0ce825e2]

sql/mdl.cc:2350(MDL_context::acquire_lock(MDL_request*, double))[0x55bc0c8ba2c2]

sql/mdl.cc:2583(MDL_context::upgrade_shared_lock(MDL_ticket*, enum_mdl_type, double))[0x55bc0ccdeecc]

sql/sql_table.cc:9303(simple_rename_or_index_change(THD*, TABLE_LIST*, Alter_info::enum_enable_or_disable, Alter_table_ctx*))[0x55bc0cce2ce7]

sql/sql_table.cc:9867(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool))[0x55bc0ce75394]

sql/sql_alter.cc:519(Sql_cmd_alter_table::execute(THD*))[0x55bc0ca60312]

sql/sql_parse.cc:5887(mysql_execute_command(THD*))[0x55bc0ca6d94e]

sql/sql_parse.cc:7926(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55bc0ca4470f]

sql/sql_parse.cc:1842(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bc0ca4068c]

sql/sql_parse.cc:1358(do_command(THD*))[0x55bc0ce5ab7d]

sql/sql_connect.cc:1422(do_handle_one_connection(CONNECT*, bool))[0x55bc0ce5a418]

sql/sql_connect.cc:1321(handle_one_connection)[0x55bc0daf16e4]

nptl/pthread_create.c:487(start_thread)[0x7fd4dc350fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fd4db9814cf]

Query (0x62b0000d2336): ALTER TABLE table10_int_autoinc ENABLE KEYS

mysqld: /10.5/sql/sql_parse.cc:7444: void THD::reset_for_next_command(bool): Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed.

200325 15:36:40 [ERROR] mysqld got signal 6 ;

Server version: 10.5.2-MariaDB-debug-log

stack_bottom = 0x7f59d5f5d618 thread_stack 0x5fc00

/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7f5a040c7077]

/10.5/sql/mysqld(my_print_stacktrace+0xce)[0x1d21de8]

/10.5/sql/mysqld(handle_fatal_signal+0x87a)[0x117c92a]

??:0(__restore_rt)[0x7f5a02b3f390]

/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f5a01cf4428]

/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f5a01cf602a]

/lib/x86_64-linux-gnu/libc.so.6(+0x2dbd7)[0x7f5a01cecbd7]

linux/raise.c:54(__GI_raise)[0x7f5a01cecc82]

/10.5/sql/mysqld(_ZN3THD22reset_for_next_commandEb+0x428)[0xa392e6]

/10.5/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x156)[0xa3c06c]

/10.5/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x20a3)[0xa152f7]

/10.5/sql/mysqld(_Z10do_commandP3THD+0x1108)[0xa121c1]

/10.5/sql/mysqld[0x10d2746]

/10.5/sql/mysqld(_Z11tp_callbackP13TP_connection+0x371)[0x10d1d91]

/10.5/sql/mysqld[0x169ebaf]

/10.5/sql/mysqld[0x19eef1c]

??:0(start_thread)[0x7f5a02b356ba]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5a01dc641d]

Query (0x62b0001ce2a8): XA START " xa 6 "

==29441==ERROR: AddressSanitizer: dynamic-stack-buffer-overflow on address 0x7fd0ae6b0b86 at pc 0x559668eccf64 bp 0x7fd0ae6b0ad0 sp 0x7fd0ae6b0ac8

READ of size 1 at 0x7fd0ae6b0b86 thread T61

    #0 0x559668eccf63 in key_restore(unsigned char*, unsigned char const*, st_key*, unsigned int) /10.5/sql/key.cc:199

    #1 0x559669028d84 in QUICK_GROUP_MIN_MAX_SELECT::next_min() /10.5/sql/opt_range.cc:14998

    #2 0x559669027e10 in QUICK_GROUP_MIN_MAX_SELECT::get_next() /10.5/sql/opt_range.cc:14888

    #3 0x5596690488f7 in rr_quick /10.5/sql/records.cc:395

    #4 0x55966829a49d in READ_RECORD::read_record() /10.5/sql/records.h:79

    #5 0x55966858b767 in sub_select(JOIN*, st_join_table*, bool) /10.5/sql/sql_select.cc:20622

    #6 0x55966858956c in do_select /10.5/sql/sql_select.cc:20137

    #7 0x559668517765 in JOIN::exec_inner() /10.5/sql/sql_select.cc:4463

    #8 0x559668514db7 in JOIN::exec() /10.5/sql/sql_select.cc:4244

    #9 0x559668518ccc in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.5/sql/sql_select.cc:4668

    #10 0x5596684eb00f in handle_select(THD*, LEX*, select_result*, unsigned long) /10.5/sql/sql_select.cc:417

    #11 0x55966845d35c in execute_sqlcom_select /10.5/sql/sql_parse.cc:6168

    #12 0x55966844b77e in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:3901

    #13 0x5596684683aa in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7953

    #14 0x55966843e198 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1839

    #15 0x55966843abcd in do_command(THD*) /10.5/sql/sql_parse.cc:1358

    #16 0x559668858a98 in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1422

    #17 0x559668858333 in handle_one_connection /10.5/sql/sql_connect.cc:1319

    #18 0x5596694f6779 in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201

    #19 0x7fd0eb956fa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

    #20 0x7fd0eaf874ce in clone (/lib/x86_64-linux-gnu/libc.so.6+0xf94ce)

   ==13592==ERROR: AddressSanitizer: heap-use-after-free on address 0x619000033f08 at pc 0x7f9fe17e931e bp 0x7f9fa9b48c10 sp 0x7f9fa9b483c0

READ of size 801 at 0x619000033f08 thread T19

    #0 0x7f9fe17e931d  (/usr/lib/x86_64-linux-gnu/libasan.so.5+0x3f31d)

    #1 0x55a7c7e3557b in Binary_string::copy(char const*, unsigned long) /10.5/sql/sql_string.cc:250

    #2 0x55a7c790fcf5 in String::copy(char const*, unsigned long, charset_info_st const*) /10.5/sql/sql_string.h:832

    #3 0x55a7c8522bf7 in user_var_entry::val_str(bool*, String*, unsigned int) const /10.5/sql/item_func.cc:4805

    #4 0x55a7c8b37f54 in User_variables::materialize(PFS_thread*, THD*) /10.5/storage/perfschema/table_uvar_by_thread.cc:116

    #5 0x55a7c8b3884f in table_uvar_by_thread::materialize(PFS_thread*) /10.5/storage/perfschema/table_uvar_by_thread.cc:251

    #6 0x55a7c8b38454 in table_uvar_by_thread::rnd_next() /10.5/storage/perfschema/table_uvar_by_thread.cc:194

    #7 0x55a7c8a2f84d in ha_perfschema::rnd_next(unsigned char*) /10.5/storage/perfschema/ha_perfschema.cc:378

    #8 0x55a7c83bdca9 in handler::ha_rnd_next(unsigned char*) /10.5/sql/handler.cc:2976

    #9 0x55a7c8391ad5 in find_all_keys /10.5/sql/filesort.cc:892

    #10 0x55a7c838da13 in filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long) /10.5/sql/filesort.cc:356

    #11 0x55a7c7d47b29 in create_sort_index(THD*, JOIN*, st_join_table*, Filesort*) /10.5/sql/sql_select.cc:23858

    #12 0x55a7c7d365cc in st_join_table::sort_table() /10.5/sql/sql_select.cc:21587

    #13 0x55a7c7d35ad5 in join_init_read_record(st_join_table*) /10.5/sql/sql_select.cc:21526

    #14 0x55a7c7d2f34b in sub_select(JOIN*, st_join_table*, bool) /10.5/sql/sql_select.cc:20600

    #15 0x55a7c7d2d594 in do_select /10.5/sql/sql_select.cc:20137

    #16 0x55a7c7cbb78d in JOIN::exec_inner() /10.5/sql/sql_select.cc:4463

    #17 0x55a7c7cb8ddf in JOIN::exec() /10.5/sql/sql_select.cc:4244

    #18 0x55a7c7cbccf4 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /10.5/sql/sql_select.cc:4668

    #19 0x55a7c7c8f037 in handle_select(THD*, LEX*, select_result*, unsigned long) /10.5/sql/sql_select.cc:417

    #20 0x55a7c7c01384 in execute_sqlcom_select /10.5/sql/sql_parse.cc:6168

    #21 0x55a7c7bef7a6 in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:3901

    #22 0x55a7c7c0c3d2 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7953

    #23 0x55a7c7be21c0 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1839

    #24 0x55a7c7bdebf5 in do_command(THD*) /10.5/sql/sql_parse.cc:1358

    #25 0x55a7c7ffdd3e in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1422

    #26 0x55a7c7ffd5d9 in handle_one_connection /10.5/sql/sql_connect.cc:1319

    #27 0x55a7c8a36a3d in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201

    #28 0x7f9fe1790fa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

    #29 0x7f9fe0b854ce in clone (/lib/x86_64-linux-gnu/libc.so.6+0xf94ce)

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x00007f8bae7c5535 in __GI_abort () at abort.c:79

#6  0x00007f8bae7c540f in __assert_fail_base (fmt=0x7f8bae927ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55ed1342e2c8 "!current_stmt_is_commit || !rgi->tables_to_lock", file=0x55ed1342c150 "/10.2/sql/log_event.cc", line=5144, function=<optimized out>) at assert.c:92

#7  0x00007f8bae7d3102 in __GI___assert_fail (assertion=0x55ed1342e2c8 "!current_stmt_is_commit || !rgi->tables_to_lock", file=0x55ed1342c150 "/10.2/sql/log_event.cc", line=5144, function=0x55ed13431760 <Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int)::__PRETTY_FUNCTION__> "int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32)") at assert.c:101

#8  0x000055ed12c03282 in Query_log_event::do_apply_event (this=0x7f8b1409eae0, rgi=0x7f8b140e30c0, query_arg=0x7f8b140ab23b "COMMIT", q_len_arg=6) at /10.2/sql/log_event.cc:5144

#9  0x000055ed12c02eb9 in Query_log_event::do_apply_event (this=0x7f8b1409eae0, rgi=0x7f8b140e30c0) at /10.2/sql/log_event.cc:5039

#10 0x000055ed127bb71d in Log_event::apply_event (this=0x7f8b1409eae0, rgi=0x7f8b140e30c0) at /10.2/sql/log_event.h:1452

#11 0x000055ed127b061f in apply_event_and_update_pos_apply (ev=0x7f8b1409eae0, thd=0x7f8b08000d50, rgi=0x7f8b140e30c0, reason=0) at /10.2/sql/slave.cc:3567

#12 0x000055ed127b0c37 in apply_event_and_update_pos_for_parallel (ev=0x7f8b1409eae0, thd=0x7f8b08000d50, rgi=0x7f8b140e30c0) at /10.2/sql/slave.cc:3762

#13 0x000055ed12a2bb6c in rpt_handle_event (qev=0x7f8b140e3de0, rpt=0x7f8b14009548) at /10.2/sql/rpl_parallel.cc:50

#14 0x000055ed12a2ec17 in handle_rpl_parallel_thread (arg=0x7f8b14009548) at /10.2/sql/rpl_parallel.cc:1316

#15 0x00007f8baef18fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

#16 0x00007f8bae89c4cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#5  0x00007f1361a63535 in __GI_abort () at abort.c:79

#6  0x00007f1361a6340f in __assert_fail_base (fmt=0x7f1361bc5ee0 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x558e58623120 "anc_page->org_size == anc_page->size", file=0x558e58622f50 "/10.2/storage/maria/ma_delete.c", line=496, function=<optimized out>) at assert.c:92

#7  0x00007f1361a71102 in __GI___assert_fail (assertion=0x558e58623120 "anc_page->org_size == anc_page->size", file=0x558e58622f50 "/10.2/storage/maria/ma_delete.c", line=496, function=0x558e58623528 <__PRETTY_FUNCTION__.18166> "d_search") at assert.c:101

#8  0x0000558e58147c12 in d_search (info=0x7f12c007b960, key=0x7f136073b0d0, comp_flag=4, anc_page=0x7f1360737b00) at /10.2/storage/maria/ma_delete.c:496

#9  0x0000558e581477a1 in d_search (info=0x7f12c007b960, key=0x7f136073b0d0, comp_flag=4, anc_page=0x7f136073aa70) at /10.2/storage/maria/ma_delete.c:414

#10 0x0000558e58146e06 in _ma_ck_real_delete (info=0x7f12c007b960, key=0x7f136073b0d0, root=0x7f136073aaf8) at /10.2/storage/maria/ma_delete.c:228

#11 0x0000558e58146b00 in _ma_ck_delete (info=0x7f12c007b960, key=0x7f136073b0d0) at /10.2/storage/maria/ma_delete.c:178

#12 0x0000558e581464ef in maria_delete (info=0x7f12c007b960, record=0x7f12c006f588 "") at /10.2/storage/maria/ma_delete.c:88

#13 0x0000558e580cbf4a in ha_maria::delete_row (this=0x7f12c0147c38, buf=0x7f12c006f588 "") at /10.2/storage/maria/ha_maria.cc:2348

#14 0x0000558e57b59eaa in handler::ha_delete_row (this=0x7f12c0147c38, buf=0x7f12c006f588 "") at /10.2/sql/handler.cc:6155

#15 0x0000558e57cd2ddf in mysql_delete (thd=0x7f12c0000d50, table_list=0x7f12c0011668, conds=0x0, order_list=0x7f12c00052e8, limit=2, options=549755813888, result=0x0) at /10.2/sql/sql_delete.cc:583

#16 0x0000558e578d8884 in mysql_execute_command (thd=0x7f12c0000d50) at /10.2/sql/sql_parse.cc:4370

#17 0x0000558e578e337b in mysql_parse (thd=0x7f12c0000d50, rawbuf=0x7f12c0011378 "DELETE FROM `table1000_aria_varchar_378_not_null_key_pk_parts_2` LIMIT 4", length=164, parser_state=0x7f136073c640, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7740

#18 0x0000558e578d17bc in dispatch_command (command=COM_QUERY, thd=0x7f12c0000d50, packet=0x7f12c0008b01 "DELETE FROM `table1000_aria_varchar_378_not_null_key_pk_parts_2` LIMIT 4 ", packet_length=164, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831

#19 0x0000558e578d0241 in do_command (thd=0x7f12c0000d50) at /10.2/sql/sql_parse.cc:1385

#20 0x0000558e57a23bf0 in do_handle_one_connection (connect=0x558e5a565800) at /10.2/sql/sql_connect.cc:1336

#21 0x0000558e57a2395b in handle_one_connection (arg=0x558e5a565800) at /10.2/sql/sql_connect.cc:1241

#22 0x00007f13621b6fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

#23 0x00007f1361b3a4cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

2020-05-14 13:07:33 139815303378688 [Warning] Sort aborted, host: localhost, user: rqg, thread: 19, query: DELETE /* QNO 984 CON_ID 19 */ FROM `view_table10000_varchar_378_not_null_key_pk_parts_2` WHERE `col_varchar_1024_utf8_key` IS NULL OR `col_varchar_1024_latin1_key` IS NOT NULL ORDER BY pk LIMIT 1

mysqld: /10.2/sql/handler.cc:5994: int handler::ha_external_lock(THD*, int): Assertion `inited == NONE || table->open_by_handler' failed.

200514 13:07:33 [ERROR] mysqld got signal 6 ;

Server version: 10.2.32-MariaDB-debug-log

stdlib/abort.c:81(__GI_abort)[0x7f294c25f535]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f294c25f40f]

/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f294c26d102]

sql/handler.cc:6021(handler::ha_external_lock(THD*, int))[0x563ebf71dc51]

sql/lock.cc:703(unlock_external(THD*, TABLE**, unsigned int))[0x563ebf71d1f9]

sql/lock.cc:430(mysql_unlock_tables(THD*, st_mysql_lock*, bool))[0x563ebf71d163]

sql/lock.cc:419(mysql_unlock_tables(THD*, st_mysql_lock*))[0x563ebf320dd0]

sql/sql_base.cc:852(close_thread_tables(THD*))[0x563ebf39ca23]

sql/sql_parse.cc:6053(mysql_execute_command(THD*))[0x563ebf3a137b]

sql/sql_parse.cc:7740(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563ebf38f7bc]

sql/sql_parse.cc:1834(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563ebf38e241]

sql/sql_parse.cc:1385(do_command(THD*))[0x563ebf4e1bf0]

sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x563ebf4e195b]

nptl/pthread_create.c:487(start_thread)[0x7f294c9b2fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f294c3364cf]

Query (0x7f28ac011378): DELETE FROM `view_table10000_varchar_378_not_null_key_pk_parts_2` WHERE `col_varchar_1024_utf8_key` IS NULL OR `col_varchar_1024_latin1_key` IS NOT NULL ORDER BY pk LIMIT 1

on slave

200514 11:19:50 [ERROR] mysqld got signal 11 ;

Server version: 10.2.32-MariaDB-debug-log

mysys/stacktrace.c:267(my_print_stacktrace)[0x558ea6d4efe2]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7fc2a9549730]

sql/sp_head.cc:552(sp_head::destroy(sp_head*))[0x558ea6a29c71]

sql/sql_trigger.cc:338(Trigger::~Trigger())[0x558ea6bba46c]

sql/sql_trigger.cc:1185(Table_triggers_list::~Table_triggers_list())[0x558ea6bbc366]

sql/table_cache.cc:220(intern_close_table(TABLE*))[0x558ea6cc80db]

sql/table_cache.cc:261(tc_remove_table(TABLE*))[0x558ea6cc82c0]

sql/table_cache.cc:470(tc_release_table(TABLE*))[0x558ea6cc8b0c]

sql/sql_base.cc:912(close_thread_table(THD*, TABLE**))[0x558ea6a680a7]

sql/sql_base.cc:858(close_thread_tables(THD*))[0x558ea6a67e09]

sql/sql_parse.cc:6053(mysql_execute_command(THD*))[0x558ea6ae3a23]

sql/sql_parse.cc:7740(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558ea6ae837b]

sql/log_event.cc:5361(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x558ea6e6fec5]

sql/log_event.cc:5040(Query_log_event::do_apply_event(rpl_group_info*))[0x558ea6e6eeb9]

sql/log_event.h:1452(Log_event::apply_event(rpl_group_info*))[0x558ea6a2771d]

sql/slave.cc:3567(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x558ea6a1c61f]

sql/slave.cc:3763(apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*))[0x558ea6a1cc37]

sql/rpl_parallel.cc:50(rpt_handle_event(rpl_parallel_thread::queued_event*, rpl_parallel_thread*))[0x558ea6c97b6c]

sql/rpl_parallel.cc:1316(handle_rpl_parallel_thread)[0x558ea6c9ac17]

nptl/pthread_create.c:487(start_thread)[0x7fc2a953efa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fc2a8ec24cf]

=================================================================

==14023==ERROR: AddressSanitizer: heap-use-after-free on address 0x6110000776a0 at pc 0x556d3bef6b02 bp 0x7f32e4faf5c0 sp 0x7f32e4faf5b8

READ of size 8 at 0x6110000776a0 thread T21

    #0 0x556d3bef6b01 in sortcmp_lex_string(st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, charset_info_st const*) /10.5/sql/events.cc:108

    #1 0x556d3bef5783 in event_basic_identifier_equal(st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Event_basic*) /10.5/sql/event_data_objects.cc:1613

    #2 0x556d3c81933f in Event_queue::find_n_remove_event(st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /10.5/sql/event_queue.cc:427

    #3 0x556d3c81890f in Event_queue::drop_event(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /10.5/sql/event_queue.cc:301

    #4 0x556d3bef9810 in Events::drop_event(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, bool) /10.5/sql/events.cc:620

    #5 0x556d3bb5e571 in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:5249

    #6 0x556d3bb70801 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7993

    #7 0x556d3bb477b5 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1874

    #8 0x556d3bb440cd in do_command(THD*) /10.5/sql/sql_parse.cc:1355

    #9 0x556d3bf67a42 in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1411

    #10 0x556d3bf6739f in handle_one_connection /10.5/sql/sql_connect.cc:1313

    #11 0x556d3cc12d0b in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201

    #12 0x7f330b53cfa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

    #13 0x7f330ab434ce in clone (/lib/x86_64-linux-gnu/libc.so.6+0xf94ce)

0x6110000776a0 is located 96 bytes inside of 208-byte region [0x611000077640,0x611000077710)

freed by thread T20 here:

    #0 0x7f330b641aa0 in operator delete(void*) (/usr/lib/x86_64-linux-gnu/libasan.so.5+0xebaa0)

    #1 0x556d3beebd73 in Event_queue_element::~Event_queue_element() /10.5/sql/event_data_objects.cc:331

    #2 0x556d3c8193d0 in Event_queue::find_n_remove_event(st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /10.5/sql/event_queue.cc:430

    #3 0x556d3c81890f in Event_queue::drop_event(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*) /10.5/sql/event_queue.cc:301

    #4 0x556d3bef9810 in Events::drop_event(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, bool) /10.5/sql/events.cc:620

    #5 0x556d3bb5e571 in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:5249

    #6 0x556d3bb70801 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7993

    #7 0x556d3bb477b5 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1874

    #8 0x556d3bb440cd in do_command(THD*) /10.5/sql/sql_parse.cc:1355

    #9 0x556d3bf67a42 in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1411

    #10 0x556d3bf6739f in handle_one_connection /10.5/sql/sql_connect.cc:1313

    #11 0x556d3cc12d0b in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201

    #12 0x7f330b53cfa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

previously allocated by thread T20 here:

    #0 0x7f330b640d30 in operator new(unsigned long) (/usr/lib/x86_64-linux-gnu/libasan.so.5+0xead30)

    #1 0x556d3bef8066 in Events::create_event(THD*, Event_parse_data*) /10.5/sql/events.cc:372

    #2 0x556d3bb5e0f9 in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:5219

    #3 0x556d3bb70801 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7993

    #4 0x556d3bb477b5 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1874

    #5 0x556d3bb440cd in do_command(THD*) /10.5/sql/sql_parse.cc:1355

    #6 0x556d3bf67a42 in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1411

    #7 0x556d3bf6739f in handle_one_connection /10.5/sql/sql_connect.cc:1313

    #8 0x556d3cc12d0b in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201

    #9 0x7f330b53cfa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

Thread T21 created by T0 here:

    #0 0x7f330b5a6db0 in __interceptor_pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.5+0x50db0)

    #1 0x556d3cc0dc02 in my_thread_create /10.5/storage/perfschema/my_thread.h:34

    #2 0x556d3cc130fa in pfs_spawn_thread_v1 /10.5/storage/perfschema/pfs.cc:2252

    #3 0x556d3b84ff84 in inline_mysql_thread_create /10.5/include/mysql/psi/mysql_thread.h:1321

    #4 0x556d3b8655c8 in create_thread_to_handle_connection(CONNECT*) /10.5/sql/mysqld.cc:5951

    #5 0x556d3b865c36 in create_new_thread(CONNECT*) /10.5/sql/mysqld.cc:6010

    #6 0x556d3b865f9a in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /10.5/sql/mysqld.cc:6075

    #7 0x556d3b866bd9 in handle_connections_sockets() /10.5/sql/mysqld.cc:6202

    #8 0x556d3b864e2f in mysqld_main(int, char**) /10.5/sql/mysqld.cc:5620

    #9 0x556d3b84e764 in main /10.5/sql/main.cc:25

    #10 0x7f330aa6e09a in __libc_start_main ../csu/libc-start.c:308

Thread T20 created by T0 here:

    #0 0x7f330b5a6db0 in __interceptor_pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.5+0x50db0)

    #1 0x556d3cc0dc02 in my_thread_create /10.5/storage/perfschema/my_thread.h:34

    #2 0x556d3cc130fa in pfs_spawn_thread_v1 /10.5/storage/perfschema/pfs.cc:2252

    #3 0x556d3b84ff84 in inline_mysql_thread_create /10.5/include/mysql/psi/mysql_thread.h:1321

    #4 0x556d3b8655c8 in create_thread_to_handle_connection(CONNECT*) /10.5/sql/mysqld.cc:5951

    #5 0x556d3b865c36 in create_new_thread(CONNECT*) /10.5/sql/mysqld.cc:6010

    #6 0x556d3b865f9a in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /10.5/sql/mysqld.cc:6075

    #7 0x556d3b866bd9 in handle_connections_sockets() /10.5/sql/mysqld.cc:6202

    #8 0x556d3b864e2f in mysqld_main(int, char**) /10.5/sql/mysqld.cc:5620

    #9 0x556d3b84e764 in main /10.5/sql/main.cc:25

    #10 0x7f330aa6e09a in __libc_start_main ../csu/libc-start.c:308

SUMMARY: AddressSanitizer: heap-use-after-free /10.5/sql/events.cc:108 in sortcmp_lex_string(st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, charset_info_st const*)

Shadow bytes around the buggy address:

  0x0c2280006e80: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd

  0x0c2280006e90: fd fd fd fd fd fd fd fd fa fa fa fa fa fa fa fa

  0x0c2280006ea0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd

  0x0c2280006eb0: fd fd fd fd fd fd fd fd fd fd fa fa fa fa fa fa

  0x0c2280006ec0: fa fa fa fa fa fa fa fa fd fd fd fd fd fd fd fd

=>0x0c2280006ed0: fd fd fd fd[fd]fd fd fd fd fd fd fd fd fd fd fd

  0x0c2280006ee0: fd fd fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c2280006ef0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd

  0x0c2280006f00: fd fd fd fd fd fd fd fd fd fd fa fa fa fa fa fa

  0x0c2280006f10: fa fa fa fa fa fa fa fa 00 00 00 00 00 00 00 00

  0x0c2280006f20: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

Shadow byte legend (one shadow byte represents 8 application bytes):

  Addressable:           00

  Partially addressable: 01 02 03 04 05 06 07 

  Heap left redzone:       fa

  Freed heap region:       fd

  Stack left redzone:      f1

  Stack mid redzone:       f2

  Stack right redzone:     f3

  Stack after return:      f5

  Stack use after scope:   f8

  Global redzone:          f9

  Global init order:       f6

  Poisoned by user:        f7

  Container overflow:      fc

  Array cookie:            ac

  Intra object redzone:    bb

  ASan internal:           fe

  Left alloca redzone:     ca

  Right alloca redzone:    cb

==14023==ABORTING

==47085==ERROR: AddressSanitizer: heap-use-after-free on address 0x6110000fe1d8 at pc 0x5615e50d60a1 bp 0x7f4aae068580 sp 0x7f4aae068578

READ of size 8 at 0x6110000fe1d8 thread T16

    #0 0x5615e50d60a0 in event_queue_element_compare_q  /10.5/sql/event_queue.cc:75

    #1 0x5615e6109930 in insert_at  /10.5/mysys/queues.c:191

    #2 0x5615e6109bed in queue_insert  /10.5/mysys/queues.c:219

    #3 0x5615e6109d79 in queue_insert_safe  /10.5/mysys/queues.c:248

    #4 0x5615e50d7188 in Event_queue::update_event(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Event_queue_element*)  /10.5/sql/event_queue.cc:271

    #5 0x5615e47b73ed in Events::update_event(THD*, Event_parse_data*, st_mysql_const_lex_string*, st_mysql_const_lex_string*)  /10.5/sql/events.cc:550

    #6 0x5615e441c3c9 in mysql_execute_command(THD*)  /10.5/sql/sql_parse.cc:5223

    #7 0x5615e442e9bd in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)  /10.5/sql/sql_parse.cc:7993

    #8 0x5615e440597f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)  /10.5/sql/sql_parse.cc:1874

    #9 0x5615e4402297 in do_command(THD*)  /10.5/sql/sql_parse.cc:1355

    #10 0x5615e4825cee in do_handle_one_connection(CONNECT*, bool)  /10.5/sql/sql_connect.cc:1411

    #11 0x5615e482564b in handle_one_connection  /10.5/sql/sql_connect.cc:1313

    #12 0x5615e54d162b in pfs_spawn_thread  /10.5/storage/perfschema/pfs.cc:2201

    #13 0x7f4b4c4cffa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

    #14 0x7f4b4bad64ce in clone (/lib/x86_64-linux-gnu/libc.so.6+0xf94ce)

0x6110000fe1d8 is located 152 bytes inside of 208-byte region [0x6110000fe140,0x6110000fe210)

freed by thread T16 here:

    #0 0x7f4b4c5d4aa0 in operator delete(void*) (/usr/lib/x86_64-linux-gnu/libasan.so.5+0xebaa0)

    #1 0x5615e47aa031 in Event_queue_element::~Event_queue_element()  /10.5/sql/event_data_objects.cc:331

    #2 0x5615e50d7ede in Event_queue::find_n_remove_event(st_mysql_const_lex_string const*, st_mysql_const_lex_string const*)  /10.5/sql/event_queue.cc:430

    #3 0x5615e50d7129 in Event_queue::update_event(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Event_queue_element*)  /10.5/sql/event_queue.cc:265

    #4 0x5615e47b73ed in Events::update_event(THD*, Event_parse_data*, st_mysql_const_lex_string*, st_mysql_const_lex_string*)  /10.5/sql/events.cc:550

    #5 0x5615e441c3c9 in mysql_execute_command(THD*)  /10.5/sql/sql_parse.cc:5223

    #6 0x5615e442e9bd in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)  /10.5/sql/sql_parse.cc:7993

    #7 0x5615e440597f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)  /10.5/sql/sql_parse.cc:1874

    #8 0x5615e4402297 in do_command(THD*)  /10.5/sql/sql_parse.cc:1355

    #9 0x5615e4825cee in do_handle_one_connection(CONNECT*, bool)  /10.5/sql/sql_connect.cc:1411

    #10 0x5615e482564b in handle_one_connection  /10.5/sql/sql_connect.cc:1313

    #11 0x5615e54d162b in pfs_spawn_thread  /10.5/storage/perfschema/pfs.cc:2201

    #12 0x7f4b4c4cffa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

previously allocated by thread T16 here:

    #0 0x7f4b4c5d3d30 in operator new(unsigned long) (/usr/lib/x86_64-linux-gnu/libasan.so.5+0xead30)

    #1 0x5615e47b6324 in Events::create_event(THD*, Event_parse_data*)  /10.5/sql/events.cc:372

    #2 0x5615e441c2c3 in mysql_execute_command(THD*)  /10.5/sql/sql_parse.cc:5219

    #3 0x5615e442e9bd in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)  /10.5/sql/sql_parse.cc:7993

    #4 0x5615e440597f in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)  /10.5/sql/sql_parse.cc:1874

    #5 0x5615e4402297 in do_command(THD*)  /10.5/sql/sql_parse.cc:1355

    #6 0x5615e4825cee in do_handle_one_connection(CONNECT*, bool)  /10.5/sql/sql_connect.cc:1411

    #7 0x5615e482564b in handle_one_connection  /10.5/sql/sql_connect.cc:1313

    #8 0x5615e54d162b in pfs_spawn_thread  /10.5/storage/perfschema/pfs.cc:2201

    #9 0x7f4b4c4cffa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486

Thread T16 created by T0 here:

    #0 0x7f4b4c539db0 in __interceptor_pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.5+0x50db0)

    #1 0x5615e54cc522 in my_thread_create  /10.5/storage/perfschema/my_thread.h:34

    #2 0x5615e54d1a1a in pfs_spawn_thread_v1  /10.5/storage/perfschema/pfs.cc:2252

    #3 0x5615e410df84 in inline_mysql_thread_create  /10.5/include/mysql/psi/mysql_thread.h:1321

    #4 0x5615e41235c8 in create_thread_to_handle_connection(CONNECT*)  /10.5/sql/mysqld.cc:5995

    #5 0x5615e4123c36 in create_new_thread(CONNECT*)  /10.5/sql/mysqld.cc:6054

    #6 0x5615e4123f9a in handle_accepted_socket(st_mysql_socket, st_mysql_socket)  /10.5/sql/mysqld.cc:6119

    #7 0x5615e4124bd9 in handle_connections_sockets()  /10.5/sql/mysqld.cc:6246

    #8 0x5615e4122e2f in mysqld_main(int, char**)  /10.5/sql/mysqld.cc:5664

    #9 0x5615e410c764 in main  /10.5/sql/main.cc:25

    #10 0x7f4b4ba0109a in __libc_start_main ../csu/libc-start.c:308

SUMMARY: AddressSanitizer: heap-use-after-free  /10.5/sql/event_queue.cc:75 in event_queue_element_compare_q

Shadow bytes around the buggy address:

  0x0c2280017be0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c2280017bf0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c2280017c00: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c2280017c10: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 04 fa

  0x0c2280017c20: fa fa fa fa fa fa fa fa fd fd fd fd fd fd fd fd

=>0x0c2280017c30: fd fd fd fd fd fd fd fd fd fd fd[fd]fd fd fd fd

  0x0c2280017c40: fd fd fa fa fa fa fa fa fa fa fa fa fa fa fa fa

  0x0c2280017c50: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

  0x0c2280017c60: 00 00 00 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7

  0x0c2280017c70: fa fa fa fa fa fa fa fa 00 00 00 00 00 00 00 00

  0x0c2280017c80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

Shadow byte legend (one shadow byte represents 8 application bytes):

  Addressable:           00

  Partially addressable: 01 02 03 04 05 06 07 

  Heap left redzone:       fa

  Freed heap region:       fd

  Stack left redzone:      f1

  Stack mid redzone:       f2

  Stack right redzone:     f3

  Stack after return:      f5

  Stack use after scope:   f8

  Global redzone:          f9

  Global init order:       f6

  Poisoned by user:        f7

  Container overflow:      fc

  Array cookie:            ac

  Intra object redzone:    bb

  ASan internal:           fe

  Left alloca redzone:     ca

  Right alloca redzone:    cb

==47085==ABORTING

mysqld: /10.4/sql/item_strfunc.cc:5250: virtual void Item_dyncol_get::print(String*, enum_query_type): Assertion `strncmp(str->ptr() + str->length() - 5, "cast(", 5) == 0' failed.

200630 15:10:39 [ERROR] mysqld got signal 6 ;

linux/raise.c:51(__GI_raise)[0x7f6e6a0d0535]

stdlib/abort.c:81(__GI_abort)[0x7f6e6a0d040f]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f6e6a0de102]

sql/item_strfunc.cc:5252(Item_dyncol_get::print(String*, enum_query_type))[0x55ceeac209f9]

sql/item_func.cc:960(Item_func_signed::print(String*, enum_query_type))[0x55ceeab20541]

sql/item.cc:488(Item::print_parenthesised(String*, enum_query_type, precedence))[0x55ceeabc28ab]

sql/item_cmpfunc.cc:5442(Item_func_isnotnull::print(String*, enum_query_type))[0x55ceeab20541]

sql/item.cc:488(Item::print_parenthesised(String*, enum_query_type, precedence))[0x55ceeabbfe54]

sql/item_cmpfunc.cc:5163(Item_cond::print(String*, enum_query_type))[0x55ceeab76e58]

sql/item.cc:10478(dbug_print_item(Item*))[0x55ceea3b809d]

sql/sql_select.cc:1140(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55ceea3de534]

sql/sql_select.cc:4647(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55ceea3b0b06]

sql/sql_select.cc:410(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55ceea3259db]

sql/sql_parse.cc:6360(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55ceea31338b]

sql/sql_parse.cc:3898(mysql_execute_command(THD*))[0x55ceea32eaa5]

sql/sql_parse.cc:7901(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55ceea3060f6]

sql/sql_parse.cc:1844(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55ceea302b75]

sql/sql_parse.cc:1359(do_command(THD*))[0x55ceea6dbe31]

sql/sql_connect.cc:1412(do_handle_one_connection(CONNECT*))[0x55ceea6db6d3]

nptl/pthread_create.c:487(start_thread)[0x7f6e6aba0fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f6e6a1a74cf]

[ERROR] mysqld got signal 11 ;

/10.5/storage/rocksdb/ha_rocksdb.so(_ZN7myrocks10ha_rocksdb11index_firstEPh+0x23)[0x7f46e8f8c773]

/10.5/storage/rocksdb/ha_rocksdb.so(_ZN7myrocks10ha_rocksdb19inplace_populate_skEP5TABLERKSt13unordered_setISt10shared_ptrINS_11Rdb_key_defEESt4hashIS6_ESt8equal_toIS6_ESaIS6_EE+0x375)[0x7f46e8f9a7a5]

/10.5/storage/rocksdb/ha_rocksdb.so(_ZN7myrocks10ha_rocksdb19inplace_alter_tableEP5TABLEP18Alter_inplace_info+0x8f)[0x7f46e8f9ac7f]

/10.5/sql/mysqld(+0xb422c2)[0x55a535b0e2c2]

/10.5/sql/mysqld(_Z17mysql_alter_tableP3THDPK25st_mysql_const_lex_stringS3_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderbb+0x3cb2)[0x55a53579fe82]

sql/ha_partition.cc:10311(ha_partition::inplace_alter_table(TABLE*, Alter_inplace_info*))[0x55a5357f72b6]

sql/sql_table.cc:7988(mysql_inplace_alter_table)[0x55a53570ea22]

sql/sql_alter.cc:532(Sql_cmd_alter_table::execute(THD*))[0x55a535701182]

sql/sql_parse.cc:5951(mysql_execute_command(THD*))[0x55a53570bce7]

sql/sql_parse.cc:8010(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55a53570cc3d]

sql/sql_parse.cc:1347(do_command(THD*))[0x55a5357f29e0]

sql/sql_connect.cc:1411(do_handle_one_connection(CONNECT*, bool))[0x55a5357f2dad]

sql/sql_connect.cc:1313(handle_one_connection)[0x55a535b1c3cb]

nptl/pthread_create.c:487(start_thread)[0x7f46ea001fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f46e960a4cf]

2020-07-13 16:55:24 14 [ERROR] InnoDB: Operating system error number 24 in a file operation.

2020-07-13 16:55:24 14 [ERROR] InnoDB: Error number 24 means 'Too many open files'

2020-07-13 16:55:24 14 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/

2020-07-13 16:55:24 14 [ERROR] InnoDB: File ./test/g#P#p24.ibd: 'open' returned OS error 224.

2020-07-13 16:55:24 0x7f145a15f300  InnoDB: Assertion failure in file /home/alice/git/10.5e/storage/innobase/fil/fil0fil.cc line 497

InnoDB: Failing assertion: success

200713 16:55:24 [ERROR] mysqld got signal 6 ;

Server version: 10.5.4-2-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7f148f514f47]

stdlib/abort.c:81(__GI_abort)[0x7f148f5168b1]

ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x557b31681e8c]

fil/fil0fil.cc:498(fil_node_open_file(fil_node_t*))[0x557b316831cb]

fil/fil0fil.cc:3730(fil_node_prepare_for_io(fil_node_t*, fil_space_t*))[0x557b315ad492]

fil/fil0fil.cc:3900(fil_io(IORequest const&, bool, page_id_t, unsigned long, unsigned long, unsigned long, void*, void*, bool, bool))[0x557b315ae3da]

buf/buf0rea.cc:346(buf_read_page_low(dberr_t*, bool, unsigned long, page_id_t, unsigned long, bool, bool))[0x557b31554015]

buf/buf0rea.cc:482(buf_read_page(page_id_t, unsigned long))[0x557b31555e73]

buf/buf0buf.cc:3153(buf_page_get_low(page_id_t, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*, bool))[0x557b3161e7e7]

buf/buf0buf.cc:3627(buf_page_get_gen(page_id_t, unsigned long, unsigned long, buf_block_t*, unsigned long, char const*, unsigned int, mtr_t*, dberr_t*, bool))[0x557b3161c364]

dict/dict0load.cc:2994(dict_load_table_one(table_name_t const&, dict_err_ignore_t, std::deque<char const*, ut_allocator<char const*, true> >&))[0x557b315e08b9]

dict/dict0load.cc:2745(dict_load_table(char const*, dict_err_ignore_t))[0x557b30f1ed58]

dict/dict0dict.cc:1097(dict_table_open_on_name(char const*, unsigned long, unsigned long, dict_err_ignore_t))[0x557b30f1c201]

handler/ha_innodb.cc:6077(ha_innobase::open_dict_table(char const*, char const*, bool, dict_err_ignore_t))[0x557b30422b90]

handler/ha_innodb.cc:5790(ha_innobase::open(char const*, int, unsigned int))[0x557b30d065da]

sql/handler.cc:2979(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x557b30cdc531]

sql/ha_partition.cc:8606(ha_partition::open_read_partitions(char*, unsigned long))[0x557b30422b90]

sql/ha_partition.cc:3672(ha_partition::open(char const*, int, unsigned int))[0x557b2ff7e31f]

sql/handler.cc:2979(handler::ha_open(TABLE*, char const*, int, unsigned int, st_mem_root*, List<String>*))[0x557b2fa97750]

sql/table.cc:4186(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x557b2faa1370]

sql/sql_base.cc:1984(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x557b2faa3f25]

sql/sql_base.cc:3784(open_and_process_table(THD*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x557b2faa94bc]

sql/sql_base.cc:4256(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x557b2fa02cbc]

sql/sql_base.cc:5160(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x557b2fb713ab]

sql/sql_base.h:509(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int))[0x557b2fc50c0a]

sql/sql_insert.cc:755(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x557b2fc26f5d]

sql/sql_parse.cc:4560(mysql_execute_command(THD*))[0x557b2fc23787]

sql/sql_parse.cc:8020(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557b3005cb15]

sql/sql_parse.cc:1877(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557b3005c46e]

sql/sql_parse.cc:1355(do_command(THD*))[0x557b30d2bf1d]

nptl/pthread_create.c:463(start_thread)[0x7f14904116db]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f148f5f7a3f]

Query (0x62b0000a82a8): INSERT INTO g ( `col_int_nokey`, `col_int_key` ) VALUES ( 5, 7 ), ( 0, 0 ), ( 4, 7 ), ( 8, 4 )

mysqld: /10.5/storage/maria/ma_pagecache.c:1671: unlink_hash: Assertion `!hash_link->block || hash_link->block->pins == 0' failed.

200713 13:37:45 [ERROR] mysqld got signal 6 ;

Server version: 10.5.5-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7f3be2b02535]

stdlib/abort.c:81(__GI_abort)[0x7f3be2b0240f]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f3be2b10102]

maria/ma_pagecache.c:1673(unlink_hash)[0x556aa12725eb]

maria/ma_pagecache.c:4658(free_block)[0x556aa1272d7d]

maria/ma_pagecache.c:4112(pagecache_delete_by_link)[0x556aa13bd79d]

maria/ma_preload.c:100(maria_preload)[0x556aa11f7fcc]

maria/ha_maria.cc:1860(ha_maria::preload_keys(THD*, st_ha_check_opt*))[0x556aa080bffe]

sql/sql_admin.cc:781(mysql_admin_table(THD*, TABLE_LIST*, st_ha_check_opt*, char const*, thr_lock_type, bool, bool, unsigned int, int (*)(THD*, TABLE_LIST*, st_ha_check_opt*), int (handler::*)(THD*, st_ha_check_opt*), int (*)(THD*, TABLE_LIST*, st_ha_check_opt*)))[0x556aa0810c6b]

sql/sql_admin.cc:1296(mysql_preload_keys(THD*, TABLE_LIST*))[0x556aa03c1744]

sql/sql_parse.cc:4073(mysql_execute_command(THD*))[0x556aa03dc7a6]

sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556aa03b36bf]

sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556aa03affd7]

sql/sql_parse.cc:1347(do_command(THD*))[0x556aa07d475d]

sql/sql_connect.cc:1411(do_handle_one_connection(CONNECT*, bool))[0x556aa07d40ba]

sql/sql_connect.cc:1315(handle_one_connection)[0x556aa148afea]

nptl/pthread_create.c:487(start_thread)[0x7f3be35d2fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f3be2bd94cf]

Query (0x62b00011f2a8): LOAD INDEX INTO CACHE `table10000_aria_varchar_378_not_null` IGNORE LEAVES

/10.5/storage/maria/ma_pagecache.c:4095: pagecache_delete_by_link: Assertion `(block->status & (4 | 8)) == 0' failed.

200713 15:40:31 [ERROR] mysqld got signal 6 ;

Server version: 10.5.5-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7f6dcf04a535]

stdlib/abort.c:81(__GI_abort)[0x7f6dcf04a40f]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f6dcf058102]

maria/ma_pagecache.c:4098(pagecache_delete_by_link)[0x558ed4682fcc]

maria/ma_preload.c:100(maria_preload)[0x558ed48b6259]

maria/ha_maria.cc:1860(ha_maria::preload_keys(THD*, st_ha_check_opt*))[0x558ed48b7196]

sql/ha_partition.cc:1343(ha_partition::handle_opt_part(THD*, st_ha_check_opt*, unsigned int, unsigned int))[0x558ed48b5d80]

sql/ha_partition.cc:1496(ha_partition::handle_opt_partitions(THD*, st_ha_check_opt*, unsigned int))[0x558ed3c96ffe]

sql/sql_admin.cc:781(mysql_admin_table(THD*, TABLE_LIST*, st_ha_check_opt*, char const*, thr_lock_type, bool, bool, unsigned int, int (*)(THD*, TABLE_LIST*, st_ha_check_opt*), int (handler::*)(THD*, st_ha_check_opt*), int (*)(THD*, TABLE_LIST*, st_ha_check_opt*)))[0x558ed3c9bc6b]

sql/sql_admin.cc:1296(mysql_preload_keys(THD*, TABLE_LIST*))[0x558ed384c744]

sql/sql_parse.cc:4073(mysql_execute_command(THD*))[0x558ed38677a6]

sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558ed383e6bf]

sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558ed383afd7]

sql/sql_connect.cc:1411(do_handle_one_connection(CONNECT*, bool))[0x558ed3c5f75d]

sql/sql_connect.cc:1315(handle_one_connection)[0x558ed3c5f0ba]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x558ed4915fea]

nptl/pthread_create.c:487(start_thread)[0x7f6dcfb1afa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f6dcf1214cf]

Query (0x62b0001572a8): LOAD INDEX INTO CACHE `table100_aria_int_autoinc_key_pk_parts_2` PARTITION ( p0 ) IGNORE LEAVES

07-29 14:57:45 14 [ERROR] InnoDB: Operating system error number 24 in a file operation.

2020-07-29 14:57:45 14 [ERROR] InnoDB: Error number 24 means 'Too many open files'

2020-07-29 14:57:45 14 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/

2020-07-29 14:57:45 14 [ERROR] InnoDB: File ./test/t#P#p141#TMP#.ibd: 'open' returned OS error 224.

2020-07-29 14:57:45 0x7f2fd3118300  InnoDB: Assertion failure in file /home/alice/git/10.5/storage/innobase/fil/fil0fil.cc line 469

InnoDB: Failing assertion: success

200729 14:57:45 [ERROR] mysqld got signal 6 ;

Server version: 10.5.5-MariaDB-debug-log

ut/ut0dbg.cc:60(_GLOBAL__sub_D_00099_0_ut0dbg.cc)[0x55be0b09bb83]

fil/fil0fil.cc:470(fil_node_open_file(fil_node_t*))[0x55be0b09d35c]

fil/fil0fil.cc:3674(fil_node_prepare_for_io(fil_node_t*, fil_space_t*))[0x55be0b0d9e30]

fil/fil0fil.cc:701(fil_space_extend_must_retry(fil_space_t*, fil_node_t*, unsigned long, bool*))[0x55be0b0e3e7a]

fil/fil0fil.cc:895(fil_space_extend(fil_space_t*, unsigned long))[0x55be0b0e41e8]

fsp/fsp0fsp.cc:638(fsp_try_extend_data_file_with_pages(fil_space_t*, unsigned long, buf_block_t*, mtr_t*))[0x55be0b0dfc16]

fsp/fsp0fsp.cc:2298(fsp_reserve_free_pages(fil_space_t*, buf_block_t*, unsigned long, mtr_t*, unsigned long))[0x55be0aeced02]

fsp/fsp0fsp.cc:2372(fsp_reserve_free_extents(unsigned long*, fil_space_t*, unsigned long, fsp_reserve_t, mtr_t*, unsigned long))[0x55be0affbc1b]

fsp/fsp0fsp.cc:1702(fseg_create(fil_space_t*, unsigned long, unsigned long, mtr_t*, bool))[0x55be0afff0ab]

btr/btr0btr.cc:1068(btr_create(unsigned long, fil_space_t*, unsigned long, dict_index_t*, mtr_t*))[0x55be0ac1ed44]

dict/dict0crea.cc:845(dict_create_index_tree_step(ind_node_t*))[0x55be0ac1f12e]

dict/dict0crea.cc:1272(dict_create_index_step(que_thr_t*))[0x55be0ac1f571]

que/que0que.cc:957(que_thr_step(que_thr_t*))[0x55be0acf41c0]

que/que0que.cc:1009(que_run_threads_low(que_thr_t*))[0x55be0a982c69]

que/que0que.cc:1051(que_run_threads(que_thr_t*))[0x55be0a9bae22]

row/row0mysql.cc:2503(row_create_index_for_mysql(dict_index_t*, trx_t*, unsigned long const*))[0x55be0a9852a0]

handler/ha_innodb.cc:12612(create_table_info_t::create_table(bool))[0x55be09e844f2]

handler/ha_innodb.cc:13142(ha_innobase::create(char const*, TABLE*, HA_CREATE_INFO*, bool, trx_t*))[0x55be0a7158fd]

handler/ha_innodb.cc:13196(ha_innobase::create(char const*, TABLE*, HA_CREATE_INFO*))[0x55be0a717d22]

sql/handler.cc:5076(handler::ha_create(char const*, TABLE*, HA_CREATE_INFO*))[0x55be09e84a38]

sql/ha_partition.cc:1636(ha_partition::prepare_new_partition(TABLE*, HA_CREATE_INFO*, handler*, char const*, partition_element*, unsigned int))[0x55be0a338f1a]

sql/ha_partition.cc:2039(ha_partition::change_partitions(HA_CREATE_INFO*, char const*, unsigned long long*, unsigned long long*, unsigned char const*, unsigned long))[0x55be0a340d14]

sql/handler.cc:5133(handler::ha_change_partitions(HA_CREATE_INFO*, char const*, unsigned long long*, unsigned long long*, unsigned char const*, unsigned long))[0x55be09931f78]

sql/sql_partition.cc:6033(mysql_change_partitions(st_lock_param_type*))[0x55be09acc823]

sql/sql_partition.cc:7375(fast_alter_partition_table(THD*, TABLE*, Alter_info*, HA_CREATE_INFO*, TABLE_LIST*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*))[0x55be096a1b32]

sql/sql_table.cc:10324(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool, bool))[0x55be096af3af]

sql/sql_alter.cc:532(Sql_cmd_alter_table::execute(THD*))[0x55be09685e4a]

sql/sql_parse.cc:5951(mysql_execute_command(THD*))[0x55be096826c8]

sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55be09ab0aba]

sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55be09ab0413]

sql/sql_parse.cc:1347(do_command(THD*))[0x55be0a774ee7]

nptl/pthread_create.c:463(start_thread)[0x7f3007cd76db]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f3006ebda3f]

--source include/have_innodb.inc

CREATE TABLE t1 (c1 DATE , c2 TIMESTAMP) ENGINE=InnoDB;

INSERT INTO t1  VALUES ('2006-07-17','0000-00-00 00:00:00');

CREATE TABLE t2 (pk INT, a1 TIME) Engine=InnoDB;

INSERT INTO t2 VALUES (6,'00:00:00');

SET SESSION sql_mode= 'strict_all_tables,no_zero_date';

--error ER_TRUNCATED_WRONG_VALUE

CREATE TABLE tbl SELECT * FROM t1 

	WHERE t1.c1 = (SELECT c2 FROM t2 WHERE pk = 6);

# ^^^ there is no column c2 in table t2

DROP TABLE t1,t2;

SET sql_mode=DEFAULT;

MariaDB [test]> select 1 limit 1.1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.1' at line 1

MariaDB [test]> prepare stmt from "select 1 limit ?;";

Query OK, 0 rows affected (0.000 sec)

Statement prepared

MariaDB [test]> execute stmt using 1.1;

+---+

| 1 |

+---+

| 1 |

+---+

1 row in set (0.001 sec)

MariaDB [test]> prepare stmt from "explain extended select 1 limit ?;";

Query OK, 0 rows affected (0.001 sec)

Statement prepared

MariaDB [test]> execute stmt using now();

+------+-------------+-------+------+---------------+------+---------+------+------+----------+----------------+

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra          |

+------+-------------+-------+------+---------------+------+---------+------+------+----------+----------------+

|    1 | SIMPLE      | NULL  | NULL | NULL          | NULL | NULL    | NULL | NULL |     NULL | No tables used |

+------+-------------+-------+------+---------------+------+---------+------+------+----------+----------------+

1 row in set, 1 warning (0.001 sec)

Note (Code 1003): select 1 AS `1` limit 20200921194122

MariaDB [test]> execute stmt using null;

+------+-------------+-------+------+---------------+------+---------+------+------+----------+------------+

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra      |

+------+-------------+-------+------+---------------+------+---------+------+------+----------+------------+

|    1 | SIMPLE      | NULL  | NULL | NULL          | NULL | NULL    | NULL | NULL |     NULL | Zero limit |

+------+-------------+-------+------+---------------+------+---------+------+------+----------+------------+

1 row in set, 1 warning (0.001 sec)

Note (Code 1003): select 1 AS `1` limit NULL

mysqld: /10.5/storage/innobase/btr/btr0cur.cc:1321: dberr_t btr_cur_search_to_nth_level_func(dict_index_t*, ulint, const dtuple_t*, page_cur_mode_t, ulint, btr_cur_t*, rw_lock_t*, const char*, unsigned int, mtr_t*, ib_uint64_t): Assertion `index->page != 0xFFFFFFFFU' failed.

200929 14:33:31 [ERROR] mysqld got signal 6 ;

Server version: 10.5.6-MariaDB-debug-log

btr/btr0cur.cc:1328(btr_cur_search_to_nth_level_func(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_cur_t*, rw_lock_t*, char const*, unsigned int, mtr_t*, unsigned long))[0x559356ba1fdf]

include/btr0pcur.ic:441(btr_pcur_open_low(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_pcur_t*, char const*, unsigned int, unsigned long, mtr_t*))[0x559356ff8f08]

row/row0row.cc:1299(row_search_index_entry(dict_index_t*, dtuple_t const*, unsigned long, btr_pcur_t*, mtr_t*))[0x559356ff93d6]

row/row0uins.cc:257(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x559356ffa860]

row/row0uins.cc:315(row_undo_ins_remove_sec(dict_index_t*, dtuple_t*, que_thr_t*))[0x559356ffae1d]

row/row0uins.cc:495(row_undo_ins_remove_sec_rec(undo_node_t*, que_thr_t*))[0x559356bdb782]

row/row0uins.cc:550(row_undo_ins(undo_node_t*, que_thr_t*))[0x559356bdbcb4]

row/row0undo.cc:433(row_undo(undo_node_t*, que_thr_t*))[0x559356a6d2f3]

row/row0undo.cc:494(row_undo_step(que_thr_t*))[0x559356a6d778]

que/que0que.cc:945(que_thr_step(que_thr_t*))[0x559356a6dbbd]

que/que0que.cc:1009(que_run_threads_low(que_thr_t*))[0x559356cbb386]

trx/trx0roll.cc:122(trx_t::rollback_low(trx_savept_t*))[0x559356cb3da6]

trx/trx0roll.cc:189(trx_rollback_for_mysql_low(trx_t*))[0x559356cb50cf]

trx/trx0roll.cc:265(trx_rollback_for_mysql(trx_t*))[0x55935679e249]

handler/ha_innodb.cc:4317(innobase_rollback(handlerton*, THD*, bool))[0x559355cc665c]

sql/handler.cc:2051(ha_rollback_trans(THD*, bool))[0x559355b28e32]

sql/xa.cc:393(xa_trans_force_rollback(THD*))[0x559355b2c7d2]

sql/xa.cc:815(trans_xa_rollback(THD*))[0x5593554f7402]

sql/sql_parse.cc:5828(mysql_execute_command(THD*))[0x559355505630]

sql/sql_parse.cc:7994(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5593554dc549]

sql/sql_parse.cc:1870(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5593554d8e57]

sql/sql_parse.cc:1348(do_command(THD*))[0x559355903096]

sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5593559029f3]

sql/sql_connect.cc:1314(handle_one_connection)[0x5593565c07fe]

nptl/pthread_create.c:487(start_thread)[0x7f7eb9e73fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f7eb947a4cf]

Query (0x62b0001032a8): XA ROLLBACK " xnm 4 "

/10.5/storage/innobase/row/row0umod.cc:264: dberr_t row_undo_mod_clust(undo_node_t*, que_thr_t*): Assertion `!node->trx->dict_operation_lock_mode' failed

[ERROR] mysqld got signal 6 ;

Server version: 10.5.7-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7ff11db8b7bb]

stdlib/abort.c:81(__GI_abort)[0x7ff11db76535]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7ff11db7640f]