Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Description
Slightly sporadic. Repeat testcase when needed.
INSTALL PLUGIN spider SONAME 'ha_spider.so'; |
CREATE TABLE m1 (c1 INT) ENGINE=SPIDER PARTITION BY LIST COLUMNS (c1) (PARTITION p1 DEFAULT ENGINE=SPIDER); |
SHOW TABLE STATUS; |
CREATE TEMPORARY TABLE m2 ENGINE=SPIDER PARTITION BY LIST COLUMNS (c1) (PARTITION p1 DEFAULT ENGINE=SPIDER); |
SHOW TABLE STATUS; |
SELECT SLEEP(10); |
SHOW TABLE STATUS; |
Leads to:
10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug) |
Core was generated by `/test/MD040921-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x000014baaa0a6546 in spider_db_connect (share=0x14ba8802e708,
|
conn=conn@entry=0x14ba880a99c8, link_idx=0)
|
at /test/10.7_dbg/storage/spider/spd_db_conn.cc:121
|
[Current thread is 1 (Thread 0x14bab811f700 (LWP 500187))]
|
(gdb) bt
|
#0 0x000014baaa0a6546 in spider_db_connect (share=0x14ba8802e708, conn=conn@entry=0x14ba880a99c8, link_idx=0) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:121
|
#1 0x000014baaa0a70b1 in spider_db_conn_queue_action (conn=conn@entry=0x14ba880a99c8) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:293
|
#2 0x000014baaa0b1d74 in spider_db_before_query (conn=conn@entry=0x14ba880a99c8, need_mon=need_mon@entry=0x14ba880a2418) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:629
|
#3 0x000014baaa0b2527 in spider_db_set_names_internal (trx=0x14ba880545e8, share=0x14ba880997f8, conn=conn@entry=0x14ba880a99c8, all_link_idx=0, need_mon=0x14ba880a2418) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:930
|
#4 0x000014baaa0b28db in spider_db_set_names (spider=0x14ba88096730, conn=conn@entry=0x14ba880a99c8, link_idx=link_idx@entry=0) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:977
|
#5 0x000014baaa16aba4 in spider_mbase_handler::show_table_status (this=0x14ba880a6ea0, link_idx=0, sts_mode=<optimized out>, flag=<optimized out>) at /test/10.7_dbg/storage/spider/spd_db_mysql.cc:14561
|
#6 0x000014baaa0b9bbb in spider_db_show_table_status (spider=spider@entry=0x14ba88096730, link_idx=link_idx@entry=0, sts_mode=<optimized out>, sts_mode@entry=1, flag=flag@entry=80) at /test/10.7_dbg/storage/spider/spd_db_conn.cc:6375
|
#7 0x000014baaa0f52c1 in spider_get_sts (share=0x14ba880997f8, link_idx=0, tmp_time=tmp_time@entry=1630903526, spider=spider@entry=0x14ba88096730, sts_interval=sts_interval@entry=0, sts_mode=sts_mode@entry=1, sts_sync=sts_sync@entry=0, sts_sync_level=1, flag=80) at /test/10.7_dbg/storage/spider/spd_table.cc:8201
|
#8 0x000014baaa14721f in ha_spider::info (this=0x14ba88096730, flag=16) at /test/10.7_dbg/storage/spider/ha_spider.cc:8678
|
#9 0x0000560cf1fb3ea0 in ha_partition::info (this=this@entry=0x14ba88095e70, flag=flag@entry=272) at /test/10.7_dbg/sql/ha_partition.cc:8506
|
#10 0x0000560cf1fb435c in ha_partition::update_create_info (this=0x14ba88095e70, create_info=0x14bab8119ca0) at /test/10.7_dbg/sql/ha_partition.cc:2259
|
#11 0x0000560cf1aa68eb in get_schema_tables_record (thd=0x14ba88000db8, tables=0x14ba880e4980, table=0x14ba8807ec10, res=<optimized out>, db_name=<optimized out>, table_name=<optimized out>) at /test/10.7_dbg/sql/sql_show.cc:5628
|
#12 0x0000560cf1a8cb0d in fill_schema_table_by_open (thd=thd@entry=0x14ba88000db8, mem_root=mem_root@entry=0x14bab811bf70, is_show_fields_or_keys=is_show_fields_or_keys@entry=false, table=table@entry=0x14ba8807ec10, schema_table=schema_table@entry=0x560cf2f0de80 <schema_tables+2176>, orig_db_name=orig_db_name@entry=0x14ba88017a28, orig_table_name=0x14ba88017bd8, open_tables_state_backup=0x14bab811bfb0, can_deadlock=false) at /test/10.7_dbg/sql/sql_show.cc:4705
|
#13 0x0000560cf1ab16a2 in get_all_tables (thd=0x14ba88000db8, tables=0x14ba88015a10, cond=<optimized out>) at /test/10.7_dbg/sql/sql_show.cc:5315
|
#14 0x0000560cf1ab2d28 in get_schema_tables_result (join=join@entry=0x14ba88016f08, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /test/10.7_dbg/sql/sql_show.cc:8836
|
#15 0x0000560cf1a84db3 in JOIN::exec_inner (this=this@entry=0x14ba88016f08) at /test/10.7_dbg/sql/sql_string.h:682
|
#16 0x0000560cf1a85a54 in JOIN::exec (this=this@entry=0x14ba88016f08) at /test/10.7_dbg/sql/sql_select.cc:4513
|
#17 0x0000560cf1a83a32 in mysql_select (thd=thd@entry=0x14ba88000db8, tables=0x14ba88015a10, fields=@0x14ba88005bb8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14ba880142c0, last = 0x14ba880159d0, elements = 20}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x14ba88016ee0, unit=0x14ba88005120, select_lex=0x14ba88005918) at /test/10.7_dbg/sql/sql_select.cc:4991
|
#18 0x0000560cf1a83ce7 in handle_select (thd=thd@entry=0x14ba88000db8, lex=lex@entry=0x14ba88005058, result=result@entry=0x14ba88016ee0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.7_dbg/sql/sql_select.cc:545
|
#19 0x0000560cf19e5936 in execute_sqlcom_select (thd=thd@entry=0x14ba88000db8, all_tables=0x14ba88015a10) at /test/10.7_dbg/sql/sql_parse.cc:6261
|
#20 0x0000560cf19f27be in mysql_execute_command (thd=thd@entry=0x14ba88000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_parse.cc:3946
|
#21 0x0000560cf19deccb in mysql_parse (thd=thd@entry=0x14ba88000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14bab811e400) at /test/10.7_dbg/sql/sql_parse.cc:8036
|
#22 0x0000560cf19ed8d0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14ba88000db8, packet=packet@entry=0x14ba8800b739 "SHOW TABLE STATUS", packet_length=packet_length@entry=17, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1358
|
#23 0x0000560cf19f0cd6 in do_command (thd=0x14ba88000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404
|
#24 0x0000560cf1b670c8 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x560cf5749408, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1418
|
#25 0x0000560cf1b676cd in handle_one_connection (arg=arg@entry=0x560cf5749408) at /test/10.7_dbg/sql/sql_connect.cc:1312
|
#26 0x0000560cf1fd0ade in pfs_spawn_thread (arg=0x560cf56482d8) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201
|
#27 0x000014bace6c5609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#28 0x000014bace2b3293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.4.22 (dbg), 10.4.22 (opt), 10.5.13 (dbg), 10.5.13 (opt), 10.6.5 (dbg), 10.6.5 (opt), 10.7.0 (dbg), 10.7.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.41 (dbg), 10.2.41 (opt), 10.3.32 (dbg), 10.3.32 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.35 (dbg), 5.7.35 (opt), 8.0.26 (dbg), 8.0.26 (opt)
Attachments
Issue Links
- relates to
-
MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states
- Closed