Thread 1 "mariadbd" stopped. 0x00007ffff7744bbf in __GI___poll (fds=0x612000025ec8, nfds=3, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 29 ../sysdeps/unix/sysv/linux/poll.c: No such file or directory. (gdb) c Continuing. [New Thread 0x7fffd7221700 (LWP 517076)] [New Thread 0x7fffd824f700 (LWP 517090)] [New Thread 0x7fffd7a38700 (LWP 517091)] [New Thread 0x7fffd6a0a700 (LWP 517193)] Thread 7 "mariadbd" received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x7fffd6209700 (LWP 516158)] 0x00005555562c05a3 in optimize_keyuse (join=join@entry=0x62f000013360, keyuse_array=keyuse_array@entry=0x62f0000136c0) at /home/mariadb/sql/sql_select.cc:7769 7769 keyuse->ref_table_rows= MY_MAX(tmp_table->file->stats.records, 100); (gdb) bt #0 0x00005555562c05a3 in optimize_keyuse (join=join@entry=0x62f000013360, keyuse_array=keyuse_array@entry=0x62f0000136c0) at /home/mariadb/sql/sql_select.cc:7769 #1 0x0000555556658b3b in JOIN::add_keyuses_for_splitting (this=0x62f000013360) at /home/mariadb/sql/opt_split.cc:847 #2 0x0000555556291dbc in make_join_statistics (join=join@entry=0x62f0000186f8, tables_list=..., keyuse_array=keyuse_array@entry=0x62f000018a58) at /home/mariadb/sql/sql_select.cc:6102 #3 0x0000555556288a6e in JOIN::optimize_inner (this=this@entry=0x62f0000186f8) at /home/mariadb/sql/sql_select.cc:2657 #4 0x0000555556281a29 in JOIN::optimize (this=this@entry=0x62f0000186f8) at /home/mariadb/sql/sql_select.cc:1966 #5 0x000055555627527a in mysql_select (thd=thd@entry=0x62c0001d0288, tables=0x6290006a0dd0, fields=..., conds=0x0, og_num=4, order=, group=, having=, proc_param=, select_options=, result=, unit=, select_lex=) at /home/mariadb/sql/sql_select.cc:5290 #6 0x0000555556274a38 in handle_select (thd=thd@entry=0x62c0001d0288, lex=lex@entry=0x62c0001d4628, result=, result@entry=0x62f000018630, setup_tables_done_option=setup_tables_done_option@entry=35184372088832) at /home/mariadb/sql/sql_select.cc:630 #7 0x00005555561e6dc8 in mysql_execute_command (thd=thd@entry=0x62c0001d0288, is_called_from_prepared_stmt=) at /home/mariadb/sql/sql_parse.cc:4581 #8 0x00005555561d19e8 in mysql_parse (thd=thd@entry=0x62c0001d0288, rawbuf=0x6290000e62a8 "INSERT INTO v0 WITH v0 AS ( SELECT * FROM v2 AS v6 NATURAL JOIN v0 NATURAL JOIN v2 AS v7 NATURAL JOIN v2 AS v8 ) SELECT DISTINCT v1 * -128 = 30 FROM v0 NATURAL JOIN v0 AS v5 NATURAL JOIN v2 AS v3 NATU"..., length=, parser_state=parser_state@entry=0x7fffd6208400) at /home/mariadb/sql/sql_parse.cc:7798 #9 0x00005555561cd644 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0001d0288, packet=packet@entry=0x6290000dc289 "INSERT INTO v0 WITH v0 AS ( SELECT * FROM v2 AS v6 NATURAL JOIN v0 NATURAL JOIN v2 AS v7 NATURAL JOIN v2 AS v8 ) SELECT DISTINCT v1 * -128 = 30 FROM v0 NATURAL JOIN v0 AS v5 NATURAL JOIN v2 AS v3 NATU"..., packet_length=packet_length@entry=249, blocking=156) at /home/mariadb/sql/sql_parse.cc:1893 #10 0x00005555561d2812 in do_command (thd=0x62c0001d0288, blocking=100) at /home/mariadb/sql/sql_parse.cc:1406 #11 0x00005555564ad3f6 in do_handle_one_connection (connect=, connect@entry=0x611000026048, put_in_cache=4) at /home/mariadb/sql/sql_connect.cc:1417 --Type for more, q to quit, c to continue without paging-- #12 0x00005555564acfbc in handle_one_connection (arg=arg@entry=0x611000026048) at /home/mariadb/sql/sql_connect.cc:1319 #13 0x0000555556e345ff in pfs_spawn_thread (arg=0x618000006108) at /home/mariadb/storage/perfschema/pfs.cc:2201 #14 0x00007ffff7c1a609 in start_thread (arg=) at pthread_create.c:477 #15 0x00007ffff7751353 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95