Roel Van de Paar added a comment - 2020-08-14 02:47 I am seeing this also, exact same. USE test; CREATE TABLE t (c BLOB, UNIQUE(c)) ENGINE=MyISAM; INSERT DELAYED INTO t VALUES (1); Leads to: 10.4.15 eae968f62d285de97ed607c87bc131cd863d5d03 (Debug) 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 Bug confirmed present in: MariaDB: 10.4.15 (dbg), 10.4.15 (opt) Bug confirmed not present in: MariaDB: 10.1.47 (dbg), 10.1.47 (opt), 10.2.34 (dbg), 10.2.34 (opt), 10.3.25 (dbg), 10.3.25 (opt), 10.5.6 (dbg), 10.5.6 (opt) MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-07 05:51 - edited elenst Do you know the exact commit that fixed MDEV-19848 ? I could not find any commit whose commit message includes the keyword " MDEV-19848 ". It will help me with fixing MDEV-27894 .

Elena Stepanova added a comment - 2022-03-07 10:43 This one would be my choice: 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)

Nayuta Yanagisawa (Inactive) added a comment - 2022-03-07 12:44 Thank you very much!

Aleksey Midenkov added a comment - 2023-09-24 13:14 Does not reproduce in 10.4.32 b1ab4ec4e25: CREATE TABLE t1 (a BLOB, UNIQUE(a)) ENGINE=MyISAM; INSERT DELAYED t1 () VALUES (); DROP TABLE t1; bug/vv.h [ pass ] 3

Elena Stepanova added a comment - 2023-09-24 15:37 It was fixed by this patch: 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. According to git log it seems to be the only commit for MDEV-26546 . Hopefully it was checked during the review that the fix had something to do with the original MDEV-26546 description, as by the look of it, it doesn't. Otherwise it wouldn't be surprising if MDEV-26546 remained unfixed, it happens when a bug contains an assortment of unrelated test scenarios.