USE test;

CREATE TABLE t (c BLOB, UNIQUE(c)) ENGINE=MyISAM;

INSERT DELAYED INTO t VALUES (1);

Core was generated by `/test/MD110820-mariadb-10.4.15-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)

    at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

[Current thread is 1 (Thread 0x152df13ce700 (LWP 2077010))]

(gdb) bt

#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

#1  0x00005567b9c2f8a6 in my_write_core (sig=sig@entry=11) at /test/10.4_dbg/mysys/stacktrace.c:482

#2  0x00005567b93abcdc in handle_fatal_signal (sig=11) at /test/10.4_dbg/sql/signal_handler.cc:343

#3  <signal handler called>

#4  0x00005567b91e5890 in check_vcol_forward_refs (field=field@entry=0x152dc9c6f690, vcol=0x152dc9c6f768, check_constraint=check_constraint@entry=false) at /test/10.4_dbg/sql/table.cc:3500

#5  0x00005567b91eed21 in parse_vcol_defs (thd=thd@entry=0x152dc9c15070, mem_root=0x152dc9c1aa10, table=table@entry=0x152dc9c6e748, error_reported=error_reported@entry=0x152df13cad10, mode=mode@entry=VCOL_INIT_DEPENDENCY_FAILURE_IS_WARNING) at /test/10.4_dbg/sql/table.cc:1299

#6  0x00005567b90bb13a in Delayed_insert::get_local_table (this=this@entry=0x152dc9c9a070, client_thd=client_thd@entry=0x152dc9c15070) at /test/10.4_dbg/sql/sql_insert.cc:2655

#7  0x00005567b90c277d in delayed_get_table (table_list=0x152dc9c6d178, grl_protection_request=0x152df13cb040, thd=0x152dc9c15070) at /test/10.4_dbg/sql/sql_insert.cc:2485

#8  open_and_lock_for_insert_delayed (table_list=0x152dc9c6d178, thd=0x152dc9c15070) at /test/10.4_dbg/sql/sql_insert.cc:573

#9  mysql_insert (thd=thd@entry=0x152dc9c15070, table_list=0x152dc9c6d178, fields=@0x152dc9c19e48: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567ba878000 <end_of_list>, last = 0x152dc9c19e48, elements = 0}, <No data fields>}, values_list=@0x152dc9c19e90: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x152dc9c6dd68, last = 0x152dc9c6dd68, elements = 1}, <No data fields>}, update_fields=@0x152dc9c19e78: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567ba878000 <end_of_list>, last = 0x152dc9c19e78, elements = 0}, <No data fields>}, update_values=@0x152dc9c19e60: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567ba878000 <end_of_list>, last = 0x152dc9c19e60, elements = 0}, <No data fields>}, duplic=<optimized out>, ignore=<optimized out>) at /test/10.4_dbg/sql/sql_insert.cc:759

#10 0x00005567b90fba63 in mysql_execute_command (thd=thd@entry=0x152dc9c15070) at /test/10.4_dbg/sql/sql_parse.cc:4519

#11 0x00005567b9103090 in mysql_parse (thd=thd@entry=0x152dc9c15070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x152df13cd460, 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:7896

#12 0x00005567b9105920 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x152dc9c15070, packet=packet@entry=0x152dc9c57071 "INSERT DELAYED INTO t VALUES (1)", packet_length=packet_length@entry=32, 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:1834

#13 0x00005567b910935b in do_command (thd=0x152dc9c15070) at /test/10.4_dbg/sql/sql_parse.cc:1352

#14 0x00005567b92358b6 in do_handle_one_connection (connect=connect@entry=0x152dee035790) at /test/10.4_dbg/sql/sql_connect.cc:1412

#15 0x00005567b92359d6 in handle_one_connection (arg=0x152dee035790) at /test/10.4_dbg/sql/sql_connect.cc:1316

#16 0x0000152df05cc6db in start_thread (arg=0x152df13ce700) at pthread_create.c:463

#17 0x0000152def746a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

commit 4ef437558ae8a278f24726276bec57141db086da 736998cb75ba1d7bf8969329d649d9d1337353ff

Author:     Monty

AuthorDate: Mon Jan 13 18:30:13 2020 +0200

Commit:     Monty

CommitDate: Tue Mar 24 21:00:02 2020 +0200

    Improve update handler (long unique keys on blobs)

CREATE  TABLE t1 (a BLOB, UNIQUE(a)) ENGINE=MyISAM;

INSERT DELAYED t1 () VALUES ();

DROP TABLE t1;

bug/vv.h                                 [ pass ]      3

commit 8911823f65a6557ce66ea5f8aecd55b115a85606

Author: Alexey Botchkov

Date:   Sat Jul 16 16:54:03 2022 +0400

    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)

    Not the SPIDER issue - happens to INSERT DELAYED.