2022-05-08 16:57:34 0 [Note] InnoDB: Using Linux native AIO 2022-05-08 16:57:34 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2022-05-08 16:57:34 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-05-08 16:57:34 0 [Note] InnoDB: Uses event mutexes 2022-05-08 16:57:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-05-08 16:57:34 0 [Note] InnoDB: Number of pools: 1 2022-05-08 16:57:34 0 [Note] InnoDB: Using SSE2 crc32 instructions 2022-05-08 16:57:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-05-08 16:57:34 0 [Note] InnoDB: Completed initialization of buffer pool 2022-05-08 16:57:34 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2022-05-08 16:57:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=8136601043 2022-05-08 16:57:34 0 [Note] InnoDB: Starting final batch to recover 11 pages from redo log. 2022-05-08 16:57:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2022-05-08 16:57:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-05-08 16:57:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-05-08 16:57:35 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-05-08 16:57:35 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-05-08 16:57:35 0 [Note] InnoDB: 10.3.35 started; log sequence number 8136608446; transaction id 23602734 2022-05-08 16:57:35 0 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool 2022-05-08 16:57:35 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-05-08 16:57:35 0 [Note] Recovering after a crash using tc.log 2022-05-08 16:57:35 0 [Note] Starting crash recovery... 2022-05-08 16:57:35 0 [Note] InnoDB: Buffer pool(s) load completed at 220508 16:57:35 2022-05-08 16:57:35 0 [Note] Crash recovery finished. 2022-05-08 16:57:35 0 [Note] Server socket created on IP: '::'. 2022-05-08 16:57:35 0 [Note] Reading of all Master_info entries succeeded 2022-05-08 16:57:35 0 [Note] Added new Master_info '' to hash table 2022-05-08 16:57:35 0 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '10.3.35-MariaDB-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution ASAN:DEADLYSIGNAL ================================================================= ==18801==ERROR: AddressSanitizer: SEGV on unknown address 0x0000000000f8 (pc 0x5555567b6372 bp 0x7fffffff9f80 sp 0x7fffffff9e60 T0) ==18801==The signal is caused by a READ memory access. ==18801==Hint: address points to the zero page. #0 0x5555567b6371 in get_sort_by_table /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:24173 #1 0x555556726c55 in make_join_statistics /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:4944 #2 0x555556708a22 in JOIN::optimize_inner() /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:1977 #3 0x555556703e02 in JOIN::optimize() /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:1519 #4 0x5555565eda69 in st_select_lex::optimize_unflattened_subqueries(bool) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_lex.cc:4124 #5 0x555556b2b9f7 in JOIN::optimize_constant_subqueries() /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/opt_subselect.cc:5377 #6 0x555556705ad7 in JOIN::optimize_inner() /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:1718 #7 0x555556703e02 in JOIN::optimize() /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:1519 #8 0x555556721499 in mysql_select(THD*, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:4340 #9 0x5555569248ab in mysql_multi_update(THD*, TABLE_LIST*, List*, List*, Item*, unsigned long long, enum_duplicates, bool, st_select_lex_unit*, st_select_lex*, multi_update**) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_update.cc:1824 #10 0x55555665352a in mysql_execute_command(THD*) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_parse.cc:4419 #11 0x55555666c414 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_parse.cc:7870 #12 0x555556643319 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_parse.cc:1941 #13 0x55555663f168 in do_command(THD*) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_parse.cc:1398 #14 0x555556a3c56a in do_handle_one_connection(CONNECT*) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_connect.cc:1403 #15 0x55555636771e in handle_connection_in_main_thread(CONNECT*) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/mysqld.cc:6631 #16 0x5555563681de in create_new_thread /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/mysqld.cc:6738 #17 0x5555563693a1 in handle_connections_sockets() /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/mysqld.cc:6996 #18 0x555556366d45 in mysqld_main(int, char**) /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/mysqld.cc:6290 #19 0x55555634ca79 in main /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/main.cc:25 #20 0x7ffff3d35c86 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x21c86) #21 0x55555634c979 in _start (/usr/local/mysql/bin/mysqld+0xdf8979) AddressSanitizer can not provide additional info. SUMMARY: AddressSanitizer: SEGV /home/wsh/test/database_fuzz/test_MariaDB/server_10.3/sql/sql_select.cc:24173 in get_sort_by_table ==18801==ABORTING