[MDEV-26546] SIGSEGV's in spider_db_connect on SHOW TABLE and spider_db_mbase::connect (and SIGSEGV's in check_vcol_forward_refs and inline_mysql_mutex_lock) - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Fix Version/s: 10.4.26, 10.5.17, 10.6.9, 10.7.5
Component/s: Data Manipulation - Insert, Server
Labels:
- affects-tests
- regression

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

Activity

Ascending order - Click to sort in descending order

View 6 older comments

Roel Van de Paar added a comment - 2022-05-28 04:08

Testcase from this comment replayed ~ 5-10 times, at the CLI (copy/paste) against 10.9 (dbg) gives yet another SIGSEGV:

SIGSEGV|ha_spider::index_read_map_internal|ha_spider::index_read_map|handler::ha_index_read_map|handler::check_duplicate_long_entry_key

Roel Van de Paar added a comment - 2022-05-28 04:08 Testcase from this comment replayed ~ 5-10 times, at the CLI (copy/paste) against 10.9 (dbg) gives yet another SIGSEGV: SIGSEGV|ha_spider::index_read_map_internal|ha_spider::index_read_map|handler::ha_index_read_map|handler::check_duplicate_long_entry_key

Roel Van de Paar added a comment - 2022-05-28 06:11

INSTALL PLUGIN spider SONAME 'ha_spider.so';

CREATE TABLE t1 (c0 INT,UNIQUE (c0) USING HASH) ENGINE=SPIDER;

INSERT DELAYED INTO t1 VALUES (0);

invalid;

SELECT SLEEP (1);

DROP TABLE t1;

Executed repeatedly at the CLI until the server crashes will give this stack, in 10.4 only (dbg+opt both affected):

10.4.25 9c6135e81f29b3e3286d6b864c0fdafc2fea16ce (Optimized)
mysqld: ../nptl/pthread_mutex_lock.c:81: __pthread_mutex_lock: Assertion `mutex->__data.__owner == 0' failed.

10.4.25 9c6135e81f29b3e3286d6b864c0fdafc2fea16ce (Optimized)
Core was generated by `/test/MD160322-mariadb-10.4.25-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
Program terminated with signal SIGABRT, Aborted.
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
[Current thread is 1 (Thread 0x14a190191700 (LWP 3430199))]
(gdb) bt
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x000014a1b83bd859 in __GI_abort () at abort.c:79
#2 0x000014a1b83bd729 in __assert_fail_base (fmt=0x14a1b8553588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x14a1b88dd62d "mutex->__data.__owner == 0", file=0x14a1b88dd5fa "../nptl/pthread_mutex_lock.c", line=81, function=<optimized out>) at assert.c:92
#3 0x000014a1b83cefd6 in __GI___assert_fail (assertion=assertion@entry=0x14a1b88dd62d "mutex->__data.__owner == 0", file=file@entry=0x14a1b88dd5fa "../nptl/pthread_mutex_lock.c", line=line@entry=81, function=function@entry=0x14a1b88dd790 <__PRETTY_FUNCTION__.10174> "__pthread_mutex_lock") at assert.c:101
#4 0x000014a1b88d1164 in __GI___pthread_mutex_lock (mutex=mutex@entry=0x14a108060ca0) at ../nptl/pthread_mutex_lock.c:81
#5 0x000014a1a008626b in inline_mysql_mutex_lock (src_file=0x14a1a0118228 "/test/10.4_opt/storage/spider/spd_db_conn.cc", src_line=8300, that=0x14a108060ca0) at /test/10.4_opt/include/mysql/psi/mysql_thread.h:704
#6 spider_db_direct_delete (spider=spider@entry=0x14a108038e90, table=<optimized out>, delete_rows=delete_rows@entry=0x14a19018e2d8) at /test/10.4_opt/storage/spider/spd_db_conn.cc:8300
#7 0x000014a1a00d3317 in ha_spider::direct_delete_rows (this=0x14a108038e90, delete_rows=0x14a19018e2d8) at /test/10.4_opt/storage/spider/ha_spider.cc:11331
#8 0x000055b4dd049df3 in mysql_delete (thd=thd@entry=0x14a108000c48, table_list=0x14a1080100b0, conds=<optimized out>, order_list=order_list@entry=0x14a108005458, limit=18446744073709551615, options=0, result=0x0) at /test/10.4_opt/sql/sql_delete.cc:654
#9 0x000055b4dccdb0ea in mysql_execute_command (thd=0x14a108000c48) at /test/10.4_opt/sql/sql_parse.cc:4792
#10 0x000055b4dcce1257 in mysql_parse (thd=0x14a108000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_parse.cc:7995
#11 0x000055b4dcce38cd in dispatch_command (command=COM_QUERY, thd=0x14a108000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_class.h:1201
#12 0x000055b4dcce5f3e in do_command (thd=0x14a108000c48) at /test/10.4_opt/sql/sql_parse.cc:1373
#13 0x000055b4dcddbd3e in do_handle_one_connection (connect=connect@entry=0x55b4e0f6aad8) at /test/10.4_opt/sql/sql_connect.cc:1420
#14 0x000055b4dcddbe6f in handle_one_connection (arg=0x55b4e0f6aad8) at /test/10.4_opt/sql/sql_connect.cc:1316
#15 0x000014a1b88ce609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#16 0x000014a1b84ba133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.4.25 9c6135e81f29b3e3286d6b864c0fdafc2fea16ce (Debug)
Core was generated by `/test/MD160322-mariadb-10.4.25-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x00005567e7dc0e1b in check_vcol_forward_refs (field=field@entry=
0x153324015818, vcol=0x1533240158f0,
check_constraint=check_constraint@entry=false)
at /test/10.4_dbg/sql/table.cc:3506
[Current thread is 1 (Thread 0x153369fa0700 (LWP 2924855))]
(gdb) bt
#0 0x00005567e7dc0e1b in check_vcol_forward_refs (field=field@entry=0x153324015818, vcol=0x1533240158f0, check_constraint=check_constraint@entry=false) at /test/10.4_dbg/sql/table.cc:3506
#1 0x00005567e7dc5add in parse_vcol_defs (thd=thd@entry=0x153324000d90, mem_root=0x153324006768, table=table@entry=0x153324014928, error_reported=error_reported@entry=0x153369f9d540, mode=mode@entry=VCOL_INIT_DEPENDENCY_FAILURE_IS_WARNING) at /test/10.4_dbg/sql/table.cc:1304
#2 0x00005567e7c7f1d4 in Delayed_insert::get_local_table (this=this@entry=0x153324082740, client_thd=client_thd@entry=0x153324000d90) at /test/10.4_dbg/sql/sql_insert.cc:2673
#3 0x00005567e7c87f6e in delayed_get_table (table_list=0x153324013320, grl_protection_request=0x153369f9d690, thd=0x153324000d90) at /test/10.4_dbg/sql/sql_insert.cc:2502
#4 open_and_lock_for_insert_delayed (thd=thd@entry=0x153324000d90, table_list=table_list@entry=0x153324013320) at /test/10.4_dbg/sql/sql_insert.cc:573
#5 0x00005567e7c88655 in mysql_insert (thd=thd@entry=0x153324000d90, table_list=0x153324013320, fields=@0x153324005ba0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005ba0, elements = 0}, <No data fields>}, values_list=@0x153324005be8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153324013f38, last = 0x153324013f38, elements = 1}, <No data fields>}, update_fields=@0x153324005bd0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005bd0, elements = 0}, <No data fields>}, update_values=@0x153324005bb8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005bb8, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false) at /test/10.4_dbg/sql/sql_insert.cc:759
#6 0x00005567e7cc4f3f in mysql_execute_command (thd=thd@entry=0x153324000d90) at /test/10.4_dbg/sql/sql_parse.cc:4598
#7 0x00005567e7cccd01 in mysql_parse (thd=thd@entry=0x153324000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153369f9f490, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7995
#8 0x00005567e7ccf75d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153324000d90, packet=packet@entry=0x15332401a361 "INSERT DELAYED INTO t1 VALUES (0)", packet_length=packet_length@entry=33, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1201
#9 0x00005567e7cd3050 in do_command (thd=0x153324000d90) at /test/10.4_dbg/sql/sql_parse.cc:1373
#10 0x00005567e7e12457 in do_handle_one_connection (connect=connect@entry=0x5567eaa53150) at /test/10.4_dbg/sql/sql_connect.cc:1420
#11 0x00005567e7e12576 in handle_one_connection (arg=0x5567eaa53150) at /test/10.4_dbg/sql/sql_connect.cc:1316
#12 0x00001533907d4609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#13 0x00001533903c0133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

This is basically the same stack as MENT-1519 and ~~MDEV-22525~~ respectively.

Roel Van de Paar added a comment - 2022-05-28 06:11 INSTALL PLUGIN spider SONAME 'ha_spider.so' ; CREATE TABLE t1 (c0 INT , UNIQUE (c0) USING HASH) ENGINE=SPIDER; INSERT DELAYED INTO t1 VALUES (0); invalid; SELECT SLEEP (1); DROP TABLE t1; Executed repeatedly at the CLI until the server crashes will give this stack, in 10.4 only (dbg+opt both affected): 10.4.25 9c6135e81f29b3e3286d6b864c0fdafc2fea16ce (Optimized) mysqld: ../nptl/pthread_mutex_lock.c:81: __pthread_mutex_lock: Assertion `mutex->__data.__owner == 0' failed. 10.4.25 9c6135e81f29b3e3286d6b864c0fdafc2fea16ce (Optimized) Core was generated by `/test/MD160322-mariadb-10.4.25-linux-x86_64-opt/bin/mysqld --no-defaults --core'. Program terminated with signal SIGABRT, Aborted. #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 [Current thread is 1 (Thread 0x14a190191700 (LWP 3430199))] (gdb) bt #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x000014a1b83bd859 in __GI_abort () at abort.c:79 #2 0x000014a1b83bd729 in __assert_fail_base (fmt=0x14a1b8553588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x14a1b88dd62d "mutex->__data.__owner == 0", file=0x14a1b88dd5fa "../nptl/pthread_mutex_lock.c", line=81, function=<optimized out>) at assert.c:92 #3 0x000014a1b83cefd6 in __GI___assert_fail (assertion=assertion@entry=0x14a1b88dd62d "mutex->__data.__owner == 0", file=file@entry=0x14a1b88dd5fa "../nptl/pthread_mutex_lock.c", line=line@entry=81, function=function@entry=0x14a1b88dd790 <__PRETTY_FUNCTION__.10174> "__pthread_mutex_lock") at assert.c:101 #4 0x000014a1b88d1164 in __GI___pthread_mutex_lock (mutex=mutex@entry=0x14a108060ca0) at ../nptl/pthread_mutex_lock.c:81 #5 0x000014a1a008626b in inline_mysql_mutex_lock (src_file=0x14a1a0118228 "/test/10.4_opt/storage/spider/spd_db_conn.cc", src_line=8300, that=0x14a108060ca0) at /test/10.4_opt/include/mysql/psi/mysql_thread.h:704 #6 spider_db_direct_delete (spider=spider@entry=0x14a108038e90, table=<optimized out>, delete_rows=delete_rows@entry=0x14a19018e2d8) at /test/10.4_opt/storage/spider/spd_db_conn.cc:8300 #7 0x000014a1a00d3317 in ha_spider::direct_delete_rows (this=0x14a108038e90, delete_rows=0x14a19018e2d8) at /test/10.4_opt/storage/spider/ha_spider.cc:11331 #8 0x000055b4dd049df3 in mysql_delete (thd=thd@entry=0x14a108000c48, table_list=0x14a1080100b0, conds=<optimized out>, order_list=order_list@entry=0x14a108005458, limit=18446744073709551615, options=0, result=0x0) at /test/10.4_opt/sql/sql_delete.cc:654 #9 0x000055b4dccdb0ea in mysql_execute_command (thd=0x14a108000c48) at /test/10.4_opt/sql/sql_parse.cc:4792 #10 0x000055b4dcce1257 in mysql_parse (thd=0x14a108000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_parse.cc:7995 #11 0x000055b4dcce38cd in dispatch_command (command=COM_QUERY, thd=0x14a108000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_class.h:1201 #12 0x000055b4dcce5f3e in do_command (thd=0x14a108000c48) at /test/10.4_opt/sql/sql_parse.cc:1373 #13 0x000055b4dcddbd3e in do_handle_one_connection (connect=connect@entry=0x55b4e0f6aad8) at /test/10.4_opt/sql/sql_connect.cc:1420 #14 0x000055b4dcddbe6f in handle_one_connection (arg=0x55b4e0f6aad8) at /test/10.4_opt/sql/sql_connect.cc:1316 #15 0x000014a1b88ce609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #16 0x000014a1b84ba133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 10.4.25 9c6135e81f29b3e3286d6b864c0fdafc2fea16ce (Debug) Core was generated by `/test/MD160322-mariadb-10.4.25-linux-x86_64-dbg/bin/mysqld --no-defaults --core'. Program terminated with signal SIGSEGV, Segmentation fault. #0 0x00005567e7dc0e1b in check_vcol_forward_refs (field=field@entry= 0x153324015818, vcol=0x1533240158f0, check_constraint=check_constraint@entry=false) at /test/10.4_dbg/sql/table.cc:3506 [Current thread is 1 (Thread 0x153369fa0700 (LWP 2924855))] (gdb) bt #0 0x00005567e7dc0e1b in check_vcol_forward_refs (field=field@entry=0x153324015818, vcol=0x1533240158f0, check_constraint=check_constraint@entry=false) at /test/10.4_dbg/sql/table.cc:3506 #1 0x00005567e7dc5add in parse_vcol_defs (thd=thd@entry=0x153324000d90, mem_root=0x153324006768, table=table@entry=0x153324014928, error_reported=error_reported@entry=0x153369f9d540, mode=mode@entry=VCOL_INIT_DEPENDENCY_FAILURE_IS_WARNING) at /test/10.4_dbg/sql/table.cc:1304 #2 0x00005567e7c7f1d4 in Delayed_insert::get_local_table (this=this@entry=0x153324082740, client_thd=client_thd@entry=0x153324000d90) at /test/10.4_dbg/sql/sql_insert.cc:2673 #3 0x00005567e7c87f6e in delayed_get_table (table_list=0x153324013320, grl_protection_request=0x153369f9d690, thd=0x153324000d90) at /test/10.4_dbg/sql/sql_insert.cc:2502 #4 open_and_lock_for_insert_delayed (thd=thd@entry=0x153324000d90, table_list=table_list@entry=0x153324013320) at /test/10.4_dbg/sql/sql_insert.cc:573 #5 0x00005567e7c88655 in mysql_insert (thd=thd@entry=0x153324000d90, table_list=0x153324013320, fields=@0x153324005ba0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005ba0, elements = 0}, <No data fields>}, values_list=@0x153324005be8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153324013f38, last = 0x153324013f38, elements = 1}, <No data fields>}, update_fields=@0x153324005bd0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005bd0, elements = 0}, <No data fields>}, update_values=@0x153324005bb8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005bb8, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false) at /test/10.4_dbg/sql/sql_insert.cc:759 #6 0x00005567e7cc4f3f in mysql_execute_command (thd=thd@entry=0x153324000d90) at /test/10.4_dbg/sql/sql_parse.cc:4598 #7 0x00005567e7cccd01 in mysql_parse (thd=thd@entry=0x153324000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153369f9f490, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7995 #8 0x00005567e7ccf75d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153324000d90, packet=packet@entry=0x15332401a361 "INSERT DELAYED INTO t1 VALUES (0)", packet_length=packet_length@entry=33, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1201 #9 0x00005567e7cd3050 in do_command (thd=0x153324000d90) at /test/10.4_dbg/sql/sql_parse.cc:1373 #10 0x00005567e7e12457 in do_handle_one_connection (connect=connect@entry=0x5567eaa53150) at /test/10.4_dbg/sql/sql_connect.cc:1420 #11 0x00005567e7e12576 in handle_one_connection (arg=0x5567eaa53150) at /test/10.4_dbg/sql/sql_connect.cc:1316 #12 0x00001533907d4609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #13 0x00001533903c0133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 This is basically the same stack as MENT-1519 and MDEV-22525 respectively.

Alexey Botchkov added a comment - 2022-07-05 08:16 - edited

https://github.com/MariaDB/server/commit/d7115c29d0f100325c1e71c3a4da43128f2a44ca

Alexey Botchkov added a comment - 2022-07-05 08:16 - edited https://github.com/MariaDB/server/commit/d7115c29d0f100325c1e71c3a4da43128f2a44ca

Aleksey Midenkov added a comment - 2022-07-16 20:07 - edited

The title in ticket and commit should reflect correct and concise summary of bug substance. The Component should reflect the correct components involved. After the title is changed OK to push.

Aleksey Midenkov added a comment - 2022-07-16 20:07 - edited The title in ticket and commit should reflect correct and concise summary of bug substance. The Component should reflect the correct components involved. After the title is changed OK to push.

Roel Van de Paar added a comment - 2023-09-26 00:25

All testcases pass 11.3 (and please note TEMPORARY table support was removed for Spider)

ERROR 1478 (HY000): Table storage engine 'SPIDER' does not support the create option 'TEMPORARY'

Roel Van de Paar added a comment - 2023-09-26 00:25 All testcases pass 11.3 (and please note TEMPORARY table support was removed for Spider) ERROR 1478 (HY000): Table storage engine 'SPIDER' does not support the create option 'TEMPORARY'

MariaDB Server

SIGSEGV's in spider_db_connect on SHOW TABLE and spider_db_mbase::connect (and SIGSEGV's in check_vcol_forward_refs and inline_mysql_mutex_lock)

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration