Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.7(EOL)
Description
# mysqld options required for replay: --log_bin --innodb-force-recovery=2 |
CREATE TABLE t (FTS_DOC_ID BIGINT UNSIGNED KEY,c CHAR(200),d TEXT) ENGINE=InnoDB; |
ALTER TABLE t ADD FULLTEXT INDEX i(c); |
Leads to:
|
10.7.0 71ed8c136fa203b9b3a678a6d5cc72235ef73ef7 (Debug) |
Core was generated by `/test/MD200721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 inline_mysql_mutex_lock (src_line=3008,
|
src_file=0x55d4e66fcfd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc",
|
that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745
|
[Current thread is 1 (Thread 0x1460004fd700 (LWP 1698933))]
|
(gdb) bt
|
#0 inline_mysql_mutex_lock (src_line=3008, src_file=0x55d4e66fcfd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc", that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745
|
#1 fts_sync_during_ddl (table=0x145fd801fb98) at /test/10.7_dbg/storage/innobase/fts/fts0opt.cc:3008
|
#2 0x000055d4e5e79880 in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x1460004f8f50, altered_table=altered_table@entry=0x1460004f9010, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.7_dbg/storage/innobase/handler/handler0alter.cc:7121
|
#3 0x000055d4e5e7e447 in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /test/10.7_dbg/storage/innobase/handler/ha_innodb.h:699
|
#4 0x000055d4e5ab28a1 in handler::ha_prepare_inplace_alter_table (this=0x145fd802a4d0, altered_table=altered_table@entry=0x1460004f9010, ha_alter_info=ha_alter_info@entry=0x1460004f8f50) at /test/10.7_dbg/sql/handler.cc:5157
|
#5 0x000055d4e5887b37 in mysql_inplace_alter_table (thd=thd@entry=0x145fd8000db8, table_list=0x145fd8013ea0, table=table@entry=0x145fd801b948, altered_table=altered_table@entry=0x1460004f9010, ha_alter_info=ha_alter_info@entry=0x1460004f8f50, target_mdl_request=target_mdl_request@entry=0x1460004f9810, ddl_log_state=0x1460004f8ea0, trigger_param=0x1460004f93e0, alter_ctx=0x1460004fa6b0) at /test/10.7_dbg/sql/sql_table.cc:7328
|
#6 0x000055d4e589ad45 in mysql_alter_table (thd=thd@entry=0x145fd8000db8, new_db=new_db@entry=0x145fd80059c8, new_name=new_name@entry=0x145fd8005de0, create_info=create_info@entry=0x1460004fb4d0, table_list=<optimized out>, table_list@entry=0x145fd8013ea0, alter_info=alter_info@entry=0x1460004fb3e0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.7_dbg/sql/sql_table.cc:10207
|
#7 0x000055d4e5929f3b in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x145fd8000db8) at /test/10.7_dbg/sql/structs.h:568
|
#8 0x000055d4e57b31c2 in mysql_execute_command (thd=thd@entry=0x145fd8000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_parse.cc:5993
|
#9 0x000055d4e5799ead in mysql_parse (thd=thd@entry=0x145fd8000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1460004fc400) at /test/10.7_dbg/sql/sql_parse.cc:8026
|
#10 0x000055d4e57a89f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145fd8000db8, packet=packet@entry=0x145fd800b869 "ALTER TABLE t ADD FULLTEXT INDEX i(c)", packet_length=packet_length@entry=37, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1340
|
#11 0x000055d4e57abe05 in do_command (thd=0x145fd8000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404
|
#12 0x000055d4e5921f48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d4e856d868, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1410
|
#13 0x000055d4e592254d in handle_one_connection (arg=arg@entry=0x55d4e856d868) at /test/10.7_dbg/sql/sql_connect.cc:1312
|
#14 0x000055d4e5d8a5b2 in pfs_spawn_thread (arg=0x55d4e80c4be8) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201
|
#15 0x0000146017310609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#16 0x0000146016efe293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Different stacks on 10.5:
|
10.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Debug) |
Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040,
|
name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc",
|
state=0x1486d86c7400, this=0x0)
|
at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700
|
[Current thread is 1 (Thread 0x1486d86cc700 (LWP 1732873))]
|
(gdb) bt
|
#0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", state=0x1486d86c7400, this=0x0) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700
|
#1 PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x0, n_spins=30, n_delay=4, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", line=3040) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:585
|
#2 0x000055aee8f444f7 in fts_sync_during_ddl (table=0x1486a401f568) at /test/10.5_dbg/storage/innobase/fts/fts0opt.cc:3040
|
#3 0x000055aee8b9c2fc in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x1486d86c8770, altered_table=altered_table@entry=0x1486d86c8810, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.5_dbg/storage/innobase/handler/handler0alter.cc:7131
|
#4 0x000055aee8ba049b in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=0x1486d86c8770) at /test/10.5_dbg/storage/innobase/handler/ha_innodb.h:709
|
#5 0x000055aee8769b65 in handler::ha_prepare_inplace_alter_table (this=0x1486a4028d70, altered_table=altered_table@entry=0x1486d86c8810, ha_alter_info=ha_alter_info@entry=0x1486d86c8770) at /test/10.5_dbg/sql/handler.cc:4837
|
#6 0x000055aee855c62d in mysql_inplace_alter_table (thd=thd@entry=0x1486a4000db8, table_list=0x1486a4013f10, table=table@entry=0x1486a401d638, altered_table=altered_table@entry=0x1486d86c8810, ha_alter_info=ha_alter_info@entry=0x1486d86c8770, target_mdl_request=target_mdl_request@entry=0x1486d86c8d60, alter_ctx=0x1486d86c98b0) at /test/10.5_dbg/sql/sql_table.cc:8079
|
#7 0x000055aee8570971 in mysql_alter_table (thd=thd@entry=0x1486a4000db8, new_db=new_db@entry=0x1486a4005828, new_name=new_name@entry=0x1486a4005c48, create_info=create_info@entry=0x1486d86ca4c0, table_list=<optimized out>, table_list@entry=0x1486a4013f10, alter_info=alter_info@entry=0x1486d86ca3f0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_dbg/sql/sql_table.cc:10727
|
#8 0x000055aee85f66c3 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1486a4000db8) at /test/10.5_dbg/sql/structs.h:559
|
#9 0x000055aee8499999 in mysql_execute_command (thd=thd@entry=0x1486a4000db8) at /test/10.5_dbg/sql/sql_parse.cc:6052
|
#10 0x000055aee847f59d in mysql_parse (thd=thd@entry=0x1486a4000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1486d86cb3d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8096
|
#11 0x000055aee848e80e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1486a4000db8, packet=packet@entry=0x1486a400b5d9 "ALTER TABLE t ADD FULLTEXT INDEX i(c)", packet_length=packet_length@entry=37, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1271
|
#12 0x000055aee8492097 in do_command (thd=0x1486a4000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370
|
#13 0x000055aee85ee8d7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55aeeb8c8ed8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410
|
#14 0x000055aee85eefdb in handle_one_connection (arg=arg@entry=0x55aeeb8c8ed8) at /test/10.5_dbg/sql/sql_connect.cc:1312
|
#15 0x000055aee8aa8955 in pfs_spawn_thread (arg=0x55aeeb7e3b88) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
|
#16 0x00001486e208b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#17 0x00001486e1c79293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
10.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Optimized) |
Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x0000564d526cbccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (
|
line=<optimized out>, name=<optimized out>, n_delay=<optimized out>,
|
n_spins=<optimized out>, this=<optimized out>)
|
at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040
|
[Current thread is 1 (Thread 0x14f864637700 (LWP 1732144))]
|
(gdb) bt
|
#0 0x0000564d526cbccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (line=<optimized out>, name=<optimized out>, n_delay=<optimized out>, n_spins=<optimized out>, this=<optimized out>) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040
|
#1 fts_sync_during_ddl (table=0x14f838007630) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040
|
#2 0x0000564d524e75a6 in prepare_inplace_alter_table_dict (ha_alter_info=<optimized out>, altered_table=<optimized out>, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.5_opt/storage/innobase/handler/handler0alter.cc:7131
|
#3 0x0000564d524ecfdd in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /test/10.5_opt/storage/innobase/handler/ha_innodb.h:709
|
#4 0x0000564d52026cab in mysql_inplace_alter_table (thd=0x14f838000c58, table_list=0x14f838010590, table=0x14f838017568, altered_table=0x14f8646339e0, ha_alter_info=0x14f864633940, alter_ctx=0x14f864634980, target_mdl_request=<optimized out>) at /test/10.5_opt/sql/sql_table.cc:8079
|
#5 0x0000564d52033d8f in mysql_alter_table (thd=thd@entry=0x14f838000c58, new_db=new_db@entry=0x14f838005508, new_name=new_name@entry=0x14f838005928, create_info=create_info@entry=0x14f864635590, table_list=<optimized out>, table_list@entry=0x14f838010590, alter_info=alter_info@entry=0x14f8646354c0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_opt/sql/sql_table.cc:10727
|
#6 0x0000564d52094667 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x14f838000c58) at /test/10.5_opt/sql/structs.h:559
|
#7 0x0000564d51f8bbde in mysql_execute_command (thd=0x14f838000c58) at /test/10.5_opt/sql/sql_parse.cc:6052
|
#8 0x0000564d51f7b163 in mysql_parse (thd=0x14f838000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_parse.cc:8096
|
#9 0x0000564d51f87945 in dispatch_command (command=COM_QUERY, thd=0x14f838000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_class.h:1271
|
#10 0x0000564d51f89ed2 in do_command (thd=0x14f838000c58) at /test/10.5_opt/sql/sql_parse.cc:1370
|
#11 0x0000564d5208f9a1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564d553a26b8, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1410
|
#12 0x0000564d5208fe1d in handle_one_connection (arg=arg@entry=0x564d553a26b8) at /test/10.5_opt/sql/sql_connect.cc:1312
|
#13 0x0000564d5241ea99 in pfs_spawn_thread (arg=0x564d55336fd8) at /test/10.5_opt/storage/perfschema/pfs.cc:2201
|
#14 0x000014f87aa25609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#15 0x000014f87a613293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.11 (dbg), 10.5.11 (opt), 10.6.4 (dbg), 10.6.4 (opt), 10.7.0 (dbg), 10.7.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.39 (dbg), 10.2.39 (opt), 10.3.30 (dbg), 10.3.30 (opt), 10.4.20 (dbg), 10.4.20 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt)
MyISAM does not crash.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
{code:sql}
# mysqld options required for replay: --log_bin --innodb-force-recovery=2 CREATE TABLE t (FTS_DOC_ID BIGINT UNSIGNED KEY,c CHAR(200),d TEXT) ENGINE=InnoDB; ALTER TABLE t ADD FULLTEXT INDEX i(c); {code} Leads to: {noformat:title=10.7.0 71ed8c136fa203b9b3a678a6d5cc72235ef73ef7 (Debug)} Core was generated by `/test/MD200721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'. Program terminated with signal SIGSEGV, Segmentation fault. #0 inline_mysql_mutex_lock (src_line=3008, src_file=0x55d4e66fcfd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc", that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745 [Current thread is 1 (Thread 0x1460004fd700 (LWP 1698933))] (gdb) bt #0 inline_mysql_mutex_lock (src_line=3008, src_file=0x55d4e66fcfd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc", that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745 #1 fts_sync_during_ddl (table=0x145fd801fb98) at /test/10.7_dbg/storage/innobase/fts/fts0opt.cc:3008 #2 0x000055d4e5e79880 in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x1460004f8f50, altered_table=altered_table@entry=0x1460004f9010, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.7_dbg/storage/innobase/handler/handler0alter.cc:7121 #3 0x000055d4e5e7e447 in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /test/10.7_dbg/storage/innobase/handler/ha_innodb.h:699 #4 0x000055d4e5ab28a1 in handler::ha_prepare_inplace_alter_table (this=0x145fd802a4d0, altered_table=altered_table@entry=0x1460004f9010, ha_alter_info=ha_alter_info@entry=0x1460004f8f50) at /test/10.7_dbg/sql/handler.cc:5157 #5 0x000055d4e5887b37 in mysql_inplace_alter_table (thd=thd@entry=0x145fd8000db8, table_list=0x145fd8013ea0, table=table@entry=0x145fd801b948, altered_table=altered_table@entry=0x1460004f9010, ha_alter_info=ha_alter_info@entry=0x1460004f8f50, target_mdl_request=target_mdl_request@entry=0x1460004f9810, ddl_log_state=0x1460004f8ea0, trigger_param=0x1460004f93e0, alter_ctx=0x1460004fa6b0) at /test/10.7_dbg/sql/sql_table.cc:7328 #6 0x000055d4e589ad45 in mysql_alter_table (thd=thd@entry=0x145fd8000db8, new_db=new_db@entry=0x145fd80059c8, new_name=new_name@entry=0x145fd8005de0, create_info=create_info@entry=0x1460004fb4d0, table_list=<optimized out>, table_list@entry=0x145fd8013ea0, alter_info=alter_info@entry=0x1460004fb3e0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.7_dbg/sql/sql_table.cc:10207 #7 0x000055d4e5929f3b in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x145fd8000db8) at /test/10.7_dbg/sql/structs.h:568 #8 0x000055d4e57b31c2 in mysql_execute_command (thd=thd@entry=0x145fd8000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_parse.cc:5993 #9 0x000055d4e5799ead in mysql_parse (thd=thd@entry=0x145fd8000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1460004fc400) at /test/10.7_dbg/sql/sql_parse.cc:8026 #10 0x000055d4e57a89f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145fd8000db8, packet=packet@entry=0x145fd800b869 "ALTER TABLE t ADD FULLTEXT INDEX i(c)", packet_length=packet_length@entry=37, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1340 #11 0x000055d4e57abe05 in do_command (thd=0x145fd8000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404 #12 0x000055d4e5921f48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d4e856d868, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1410 #13 0x000055d4e592254d in handle_one_connection (arg=arg@entry=0x55d4e856d868) at /test/10.7_dbg/sql/sql_connect.cc:1312 #14 0x000055d4e5d8a5b2 in pfs_spawn_thread (arg=0x55d4e80c4be8) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201 #15 0x0000146017310609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #16 0x0000146016efe293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 {noformat} Different stacks on 10.5: {noformat:title=10.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Debug)} Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-dbg/bin/mysqld --no-defaults --core'. Program terminated with signal SIGSEGV, Segmentation fault. #0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", state=0x1486d86c7400, this=0x0) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700 [Current thread is 1 (Thread 0x1486d86cc700 (LWP 1732873))] (gdb) bt #0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", state=0x1486d86c7400, this=0x0) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700 #1 PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x0, n_spins=30, n_delay=4, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", line=3040) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:585 #2 0x000055aee8f444f7 in fts_sync_during_ddl (table=0x1486a401f568) at /test/10.5_dbg/storage/innobase/fts/fts0opt.cc:3040 #3 0x000055aee8b9c2fc in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x1486d86c8770, altered_table=altered_table@entry=0x1486d86c8810, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.5_dbg/storage/innobase/handler/handler0alter.cc:7131 #4 0x000055aee8ba049b in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=0x1486d86c8770) at /test/10.5_dbg/storage/innobase/handler/ha_innodb.h:709 #5 0x000055aee8769b65 in handler::ha_prepare_inplace_alter_table (this=0x1486a4028d70, altered_table=altered_table@entry=0x1486d86c8810, ha_alter_info=ha_alter_info@entry=0x1486d86c8770) at /test/10.5_dbg/sql/handler.cc:4837 #6 0x000055aee855c62d in mysql_inplace_alter_table (thd=thd@entry=0x1486a4000db8, table_list=0x1486a4013f10, table=table@entry=0x1486a401d638, altered_table=altered_table@entry=0x1486d86c8810, ha_alter_info=ha_alter_info@entry=0x1486d86c8770, target_mdl_request=target_mdl_request@entry=0x1486d86c8d60, alter_ctx=0x1486d86c98b0) at /test/10.5_dbg/sql/sql_table.cc:8079 #7 0x000055aee8570971 in mysql_alter_table (thd=thd@entry=0x1486a4000db8, new_db=new_db@entry=0x1486a4005828, new_name=new_name@entry=0x1486a4005c48, create_info=create_info@entry=0x1486d86ca4c0, table_list=<optimized out>, table_list@entry=0x1486a4013f10, alter_info=alter_info@entry=0x1486d86ca3f0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_dbg/sql/sql_table.cc:10727 #8 0x000055aee85f66c3 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1486a4000db8) at /test/10.5_dbg/sql/structs.h:559 #9 0x000055aee8499999 in mysql_execute_command (thd=thd@entry=0x1486a4000db8) at /test/10.5_dbg/sql/sql_parse.cc:6052 #10 0x000055aee847f59d in mysql_parse (thd=thd@entry=0x1486a4000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1486d86cb3d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8096 #11 0x000055aee848e80e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1486a4000db8, packet=packet@entry=0x1486a400b5d9 "ALTER TABLE t ADD FULLTEXT INDEX i(c)", packet_length=packet_length@entry=37, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1271 #12 0x000055aee8492097 in do_command (thd=0x1486a4000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370 #13 0x000055aee85ee8d7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55aeeb8c8ed8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410 #14 0x000055aee85eefdb in handle_one_connection (arg=arg@entry=0x55aeeb8c8ed8) at /test/10.5_dbg/sql/sql_connect.cc:1312 #15 0x000055aee8aa8955 in pfs_spawn_thread (arg=0x55aeeb7e3b88) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201 #16 0x00001486e208b609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #17 0x00001486e1c79293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 {noformat} {noformat:title=10.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Optimized)} Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-opt/bin/mysqld --no-defaults --core'. Program terminated with signal SIGSEGV, Segmentation fault. #0 0x0000564d526cbccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter ( line=<optimized out>, name=<optimized out>, n_delay=<optimized out>, n_spins=<optimized out>, this=<optimized out>) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040 [Current thread is 1 (Thread 0x14f864637700 (LWP 1732144))] (gdb) bt #0 0x0000564d526cbccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (line=<optimized out>, name=<optimized out>, n_delay=<optimized out>, n_spins=<optimized out>, this=<optimized out>) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040 #1 fts_sync_during_ddl (table=0x14f838007630) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040 #2 0x0000564d524e75a6 in prepare_inplace_alter_table_dict (ha_alter_info=<optimized out>, altered_table=<optimized out>, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.5_opt/storage/innobase/handler/handler0alter.cc:7131 #3 0x0000564d524ecfdd in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /test/10.5_opt/storage/innobase/handler/ha_innodb.h:709 #4 0x0000564d52026cab in mysql_inplace_alter_table (thd=0x14f838000c58, table_list=0x14f838010590, table=0x14f838017568, altered_table=0x14f8646339e0, ha_alter_info=0x14f864633940, alter_ctx=0x14f864634980, target_mdl_request=<optimized out>) at /test/10.5_opt/sql/sql_table.cc:8079 #5 0x0000564d52033d8f in mysql_alter_table (thd=thd@entry=0x14f838000c58, new_db=new_db@entry=0x14f838005508, new_name=new_name@entry=0x14f838005928, create_info=create_info@entry=0x14f864635590, table_list=<optimized out>, table_list@entry=0x14f838010590, alter_info=alter_info@entry=0x14f8646354c0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_opt/sql/sql_table.cc:10727 #6 0x0000564d52094667 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x14f838000c58) at /test/10.5_opt/sql/structs.h:559 #7 0x0000564d51f8bbde in mysql_execute_command (thd=0x14f838000c58) at /test/10.5_opt/sql/sql_parse.cc:6052 #8 0x0000564d51f7b163 in mysql_parse (thd=0x14f838000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_parse.cc:8096 #9 0x0000564d51f87945 in dispatch_command (command=COM_QUERY, thd=0x14f838000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_class.h:1271 #10 0x0000564d51f89ed2 in do_command (thd=0x14f838000c58) at /test/10.5_opt/sql/sql_parse.cc:1370 #11 0x0000564d5208f9a1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564d553a26b8, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1410 #12 0x0000564d5208fe1d in handle_one_connection (arg=arg@entry=0x564d553a26b8) at /test/10.5_opt/sql/sql_connect.cc:1312 #13 0x0000564d5241ea99 in pfs_spawn_thread (arg=0x564d55336fd8) at /test/10.5_opt/storage/perfschema/pfs.cc:2201 #14 0x000014f87aa25609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #15 0x000014f87a613293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 {noformat} Bug confirmed present in: MariaDB: 10.5.11 (dbg), 10.5.11 (opt), 10.6.4 (dbg), 10.6.4 (opt), 10.7.0 (dbg), 10.7.0 (opt) Bug (or feature/syntax) confirmed not present in: MariaDB: 10.2.39 (dbg), 10.2.39 (opt), 10.3.30 (dbg), 10.3.30 (opt), 10.4.20 (dbg), 10.4.20 (opt) MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt) |
{code:sql}
# mysqld options required for replay: --log_bin --innodb-force-recovery=2 CREATE TABLE t (FTS_DOC_ID BIGINT UNSIGNED KEY,c CHAR(200),d TEXT) ENGINE=InnoDB; ALTER TABLE t ADD FULLTEXT INDEX i(c); {code} Leads to: {noformat:title=10.7.0 71ed8c136fa203b9b3a678a6d5cc72235ef73ef7 (Debug)} Core was generated by `/test/MD200721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'. Program terminated with signal SIGSEGV, Segmentation fault. #0 inline_mysql_mutex_lock (src_line=3008, src_file=0x55d4e66fcfd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc", that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745 [Current thread is 1 (Thread 0x1460004fd700 (LWP 1698933))] (gdb) bt #0 inline_mysql_mutex_lock (src_line=3008, src_file=0x55d4e66fcfd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc", that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745 #1 fts_sync_during_ddl (table=0x145fd801fb98) at /test/10.7_dbg/storage/innobase/fts/fts0opt.cc:3008 #2 0x000055d4e5e79880 in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x1460004f8f50, altered_table=altered_table@entry=0x1460004f9010, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.7_dbg/storage/innobase/handler/handler0alter.cc:7121 #3 0x000055d4e5e7e447 in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /test/10.7_dbg/storage/innobase/handler/ha_innodb.h:699 #4 0x000055d4e5ab28a1 in handler::ha_prepare_inplace_alter_table (this=0x145fd802a4d0, altered_table=altered_table@entry=0x1460004f9010, ha_alter_info=ha_alter_info@entry=0x1460004f8f50) at /test/10.7_dbg/sql/handler.cc:5157 #5 0x000055d4e5887b37 in mysql_inplace_alter_table (thd=thd@entry=0x145fd8000db8, table_list=0x145fd8013ea0, table=table@entry=0x145fd801b948, altered_table=altered_table@entry=0x1460004f9010, ha_alter_info=ha_alter_info@entry=0x1460004f8f50, target_mdl_request=target_mdl_request@entry=0x1460004f9810, ddl_log_state=0x1460004f8ea0, trigger_param=0x1460004f93e0, alter_ctx=0x1460004fa6b0) at /test/10.7_dbg/sql/sql_table.cc:7328 #6 0x000055d4e589ad45 in mysql_alter_table (thd=thd@entry=0x145fd8000db8, new_db=new_db@entry=0x145fd80059c8, new_name=new_name@entry=0x145fd8005de0, create_info=create_info@entry=0x1460004fb4d0, table_list=<optimized out>, table_list@entry=0x145fd8013ea0, alter_info=alter_info@entry=0x1460004fb3e0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.7_dbg/sql/sql_table.cc:10207 #7 0x000055d4e5929f3b in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x145fd8000db8) at /test/10.7_dbg/sql/structs.h:568 #8 0x000055d4e57b31c2 in mysql_execute_command (thd=thd@entry=0x145fd8000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_parse.cc:5993 #9 0x000055d4e5799ead in mysql_parse (thd=thd@entry=0x145fd8000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1460004fc400) at /test/10.7_dbg/sql/sql_parse.cc:8026 #10 0x000055d4e57a89f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145fd8000db8, packet=packet@entry=0x145fd800b869 "ALTER TABLE t ADD FULLTEXT INDEX i(c)", packet_length=packet_length@entry=37, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1340 #11 0x000055d4e57abe05 in do_command (thd=0x145fd8000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404 #12 0x000055d4e5921f48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d4e856d868, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1410 #13 0x000055d4e592254d in handle_one_connection (arg=arg@entry=0x55d4e856d868) at /test/10.7_dbg/sql/sql_connect.cc:1312 #14 0x000055d4e5d8a5b2 in pfs_spawn_thread (arg=0x55d4e80c4be8) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201 #15 0x0000146017310609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #16 0x0000146016efe293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 {noformat} Different stacks on 10.5: {noformat:title=10.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Debug)} Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-dbg/bin/mysqld --no-defaults --core'. Program terminated with signal SIGSEGV, Segmentation fault. #0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", state=0x1486d86c7400, this=0x0) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700 [Current thread is 1 (Thread 0x1486d86cc700 (LWP 1732873))] (gdb) bt #0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", state=0x1486d86c7400, this=0x0) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700 #1 PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x0, n_spins=30, n_delay=4, name=0x55aee9455210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", line=3040) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:585 #2 0x000055aee8f444f7 in fts_sync_during_ddl (table=0x1486a401f568) at /test/10.5_dbg/storage/innobase/fts/fts0opt.cc:3040 #3 0x000055aee8b9c2fc in prepare_inplace_alter_table_dict (ha_alter_info=ha_alter_info@entry=0x1486d86c8770, altered_table=altered_table@entry=0x1486d86c8810, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.5_dbg/storage/innobase/handler/handler0alter.cc:7131 #4 0x000055aee8ba049b in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=0x1486d86c8770) at /test/10.5_dbg/storage/innobase/handler/ha_innodb.h:709 #5 0x000055aee8769b65 in handler::ha_prepare_inplace_alter_table (this=0x1486a4028d70, altered_table=altered_table@entry=0x1486d86c8810, ha_alter_info=ha_alter_info@entry=0x1486d86c8770) at /test/10.5_dbg/sql/handler.cc:4837 #6 0x000055aee855c62d in mysql_inplace_alter_table (thd=thd@entry=0x1486a4000db8, table_list=0x1486a4013f10, table=table@entry=0x1486a401d638, altered_table=altered_table@entry=0x1486d86c8810, ha_alter_info=ha_alter_info@entry=0x1486d86c8770, target_mdl_request=target_mdl_request@entry=0x1486d86c8d60, alter_ctx=0x1486d86c98b0) at /test/10.5_dbg/sql/sql_table.cc:8079 #7 0x000055aee8570971 in mysql_alter_table (thd=thd@entry=0x1486a4000db8, new_db=new_db@entry=0x1486a4005828, new_name=new_name@entry=0x1486a4005c48, create_info=create_info@entry=0x1486d86ca4c0, table_list=<optimized out>, table_list@entry=0x1486a4013f10, alter_info=alter_info@entry=0x1486d86ca3f0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_dbg/sql/sql_table.cc:10727 #8 0x000055aee85f66c3 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1486a4000db8) at /test/10.5_dbg/sql/structs.h:559 #9 0x000055aee8499999 in mysql_execute_command (thd=thd@entry=0x1486a4000db8) at /test/10.5_dbg/sql/sql_parse.cc:6052 #10 0x000055aee847f59d in mysql_parse (thd=thd@entry=0x1486a4000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1486d86cb3d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8096 #11 0x000055aee848e80e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1486a4000db8, packet=packet@entry=0x1486a400b5d9 "ALTER TABLE t ADD FULLTEXT INDEX i(c)", packet_length=packet_length@entry=37, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1271 #12 0x000055aee8492097 in do_command (thd=0x1486a4000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370 #13 0x000055aee85ee8d7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55aeeb8c8ed8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410 #14 0x000055aee85eefdb in handle_one_connection (arg=arg@entry=0x55aeeb8c8ed8) at /test/10.5_dbg/sql/sql_connect.cc:1312 #15 0x000055aee8aa8955 in pfs_spawn_thread (arg=0x55aeeb7e3b88) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201 #16 0x00001486e208b609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #17 0x00001486e1c79293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 {noformat} {noformat:title=10.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Optimized)} Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-opt/bin/mysqld --no-defaults --core'. Program terminated with signal SIGSEGV, Segmentation fault. #0 0x0000564d526cbccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter ( line=<optimized out>, name=<optimized out>, n_delay=<optimized out>, n_spins=<optimized out>, this=<optimized out>) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040 [Current thread is 1 (Thread 0x14f864637700 (LWP 1732144))] (gdb) bt #0 0x0000564d526cbccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (line=<optimized out>, name=<optimized out>, n_delay=<optimized out>, n_spins=<optimized out>, this=<optimized out>) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040 #1 fts_sync_during_ddl (table=0x14f838007630) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040 #2 0x0000564d524e75a6 in prepare_inplace_alter_table_dict (ha_alter_info=<optimized out>, altered_table=<optimized out>, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>, add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /test/10.5_opt/storage/innobase/handler/handler0alter.cc:7131 #3 0x0000564d524ecfdd in ha_innobase::prepare_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /test/10.5_opt/storage/innobase/handler/ha_innodb.h:709 #4 0x0000564d52026cab in mysql_inplace_alter_table (thd=0x14f838000c58, table_list=0x14f838010590, table=0x14f838017568, altered_table=0x14f8646339e0, ha_alter_info=0x14f864633940, alter_ctx=0x14f864634980, target_mdl_request=<optimized out>) at /test/10.5_opt/sql/sql_table.cc:8079 #5 0x0000564d52033d8f in mysql_alter_table (thd=thd@entry=0x14f838000c58, new_db=new_db@entry=0x14f838005508, new_name=new_name@entry=0x14f838005928, create_info=create_info@entry=0x14f864635590, table_list=<optimized out>, table_list@entry=0x14f838010590, alter_info=alter_info@entry=0x14f8646354c0, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_opt/sql/sql_table.cc:10727 #6 0x0000564d52094667 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x14f838000c58) at /test/10.5_opt/sql/structs.h:559 #7 0x0000564d51f8bbde in mysql_execute_command (thd=0x14f838000c58) at /test/10.5_opt/sql/sql_parse.cc:6052 #8 0x0000564d51f7b163 in mysql_parse (thd=0x14f838000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_parse.cc:8096 #9 0x0000564d51f87945 in dispatch_command (command=COM_QUERY, thd=0x14f838000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_class.h:1271 #10 0x0000564d51f89ed2 in do_command (thd=0x14f838000c58) at /test/10.5_opt/sql/sql_parse.cc:1370 #11 0x0000564d5208f9a1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564d553a26b8, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1410 #12 0x0000564d5208fe1d in handle_one_connection (arg=arg@entry=0x564d553a26b8) at /test/10.5_opt/sql/sql_connect.cc:1312 #13 0x0000564d5241ea99 in pfs_spawn_thread (arg=0x564d55336fd8) at /test/10.5_opt/storage/perfschema/pfs.cc:2201 #14 0x000014f87aa25609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #15 0x000014f87a613293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 {noformat} Bug confirmed present in: MariaDB: 10.5.11 (dbg), 10.5.11 (opt), 10.6.4 (dbg), 10.6.4 (opt), 10.7.0 (dbg), 10.7.0 (opt) Bug (or feature/syntax) confirmed not present in: MariaDB: 10.2.39 (dbg), 10.2.39 (opt), 10.3.30 (dbg), 10.3.30 (opt), 10.4.20 (dbg), 10.4.20 (opt) MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt) MyISAM does not crash. |
| Labels | not-10.2 not-10.3 not-10.4 regression | affects-tests not-10.2 not-10.3 not-10.4 regression |
UniqueID's thus far:
SIGSEGV|PolicyMutex<TTASEventMutex<GenericPolicy> >::enter|fts_sync_during_ddl|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
SIGSEGV|PolicyMutex<TTASEventMutex<GenericPolicy> >::enter|fts_sync_during_ddl|ha_innobase::commit_inplace_alter_table|mysql_inplace_alter_table
|
SIGSEGV|PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock|PolicyMutex<TTASEventMutex<GenericPolicy> >::enter|fts_sync_during_ddl|prepare_inplace_alter_table_dict
|
SIGSEGV|PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock|PolicyMutex<TTASEventMutex<GenericPolicy> >::enter|fts_sync_during_ddl|ha_innobase::commit_inplace_alter_table
|
SIGSEGV|inline_mysql_mutex_lock|fts_sync_during_ddl|prepare_inplace_alter_table_dict|ha_innobase::prepare_inplace_alter_table
|
SIGSEGV|inline_mysql_mutex_lock|fts_sync_during_ddl|ha_innobase::commit_inplace_alter_table|mysql_inplace_alter_table
|
SIGSEGV|inline_mysql_mutex_lock|fts_sync_during_ddl|ha_innobase::commit_inplace_alter_table|handler::ha_commit_inplace_alter_table
|
| Fix Version/s | 10.5.13 [ 26026 ] | |
| Fix Version/s | 10.6.5 [ 26034 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 123979 ] | MariaDB v4 [ 159552 ] |
| Zendesk Related Tickets | 203783 | |
| Zendesk active tickets | 203783 |
| Zendesk active tickets | 203783 |
Another variety of stacks with this testcase:
Leads to:
10.7.0 71ed8c136fa203b9b3a678a6d5cc72235ef73ef7 (Debug)
Core was generated by `/test/MD200721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.Program terminated with signal SIGSEGV, Segmentation fault.#0 inline_mysql_mutex_lock (src_line=3008,src_file=0x55adee23ffd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc",that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745[Current thread is 1 (Thread 0x14bd3d6e5700 (LWP 3060443))](gdb) bt#0 inline_mysql_mutex_lock (src_line=3008, src_file=0x55adee23ffd0 "/test/10.7_dbg/storage/innobase/fts/fts0opt.cc", that=0x0) at /test/10.7_dbg/include/mysql/psi/mysql_thread.h:745#1 fts_sync_during_ddl (table=0x14bd1c035ac8) at /test/10.7_dbg/storage/innobase/fts/fts0opt.cc:3008#2 0x000055aded9c34e3 in ha_innobase::commit_inplace_alter_table (this=0x14bd1c026d40, altered_table=0x14bd3d6e1ad0, ha_alter_info=0x14bd3d6e1a10, commit=true) at /test/10.7_dbg/storage/innobase/handler/handler0alter.cc:10875#3 0x000055aded5f5979 in handler::ha_commit_inplace_alter_table (this=0x14bd1c026d40, altered_table=altered_table@entry=0x14bd3d6e1ad0, ha_alter_info=ha_alter_info@entry=0x14bd3d6e1a10, commit=commit@entry=true) at /test/10.7_dbg/sql/handler.cc:5177#4 0x000055aded3cb003 in mysql_inplace_alter_table (thd=thd@entry=0x14bd1c000db8, table_list=0x14bd1c013da8, table=table@entry=0x14bd1c026428, altered_table=altered_table@entry=0x14bd3d6e1ad0, ha_alter_info=ha_alter_info@entry=0x14bd3d6e1a10, target_mdl_request=target_mdl_request@entry=0x14bd3d6e22d0, ddl_log_state=0x14bd3d6e1960, trigger_param=0x14bd3d6e1ea0, alter_ctx=0x14bd3d6e3170) at /test/10.7_dbg/sql/sql_table.cc:7439#5 0x000055aded3ddd45 in mysql_alter_table (thd=thd@entry=0x14bd1c000db8, new_db=new_db@entry=0x14bd1c013dc0, new_name=new_name@entry=0x14bd1c013dd0, create_info=create_info@entry=0x14bd3d6e3fc0, table_list=<optimized out>, table_list@entry=0x14bd1c013da8, alter_info=alter_info@entry=0x14bd3d6e3ed0, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /test/10.7_dbg/sql/sql_table.cc:10207#6 0x000055aded2f1416 in mysql_execute_command (thd=thd@entry=0x14bd1c000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/structs.h:568#7 0x000055aded2dcead in mysql_parse (thd=thd@entry=0x14bd1c000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14bd3d6e4400) at /test/10.7_dbg/sql/sql_parse.cc:8026#8 0x000055aded2eb9f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14bd1c000db8, packet=packet@entry=0x14bd1c00b749 "CREATE FULLTEXT INDEX idx ON articles (body)", packet_length=packet_length@entry=44, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1340#9 0x000055aded2eee05 in do_command (thd=0x14bd1c000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404#10 0x000055aded464f48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55adf124a938, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1410#11 0x000055aded46554d in handle_one_connection (arg=arg@entry=0x55adf124a938) at /test/10.7_dbg/sql/sql_connect.cc:1312#12 0x000055aded8cd5b2 in pfs_spawn_thread (arg=0x55adf0dba4e8) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201#13 0x000014bd54a77609 in start_thread (arg=<optimized out>) at pthread_create.c:477#14 0x000014bd54665293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:9510.6.5 78c7d50e4f2d80ad93aea9ead15b013c16366d15 (Optimized)
Core was generated by `/test/MD100821-mariadb-10.6.5-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.Program terminated with signal SIGSEGV, Segmentation fault.#0 inline_mysql_mutex_lock (src_file=0x559304a936f8 "/test/10.6_opt/storage/innobase/fts/fts0opt.cc",src_line=3008, that=0x0)at /test/10.6_opt/include/mysql/psi/mysql_thread.h:745745 if (psi_likely(that->m_psi != NULL))[Current thread is 1 (Thread 0x1519c4a78700 (LWP 3086910))](gdb) bt#0 inline_mysql_mutex_lock (src_file=0x559304a936f8 "/test/10.6_opt/storage/innobase/fts/fts0opt.cc", src_line=3008, that=0x0) at /test/10.6_opt/include/mysql/psi/mysql_thread.h:745#1 fts_sync_during_ddl (table=0x151988021c00) at /test/10.6_opt/storage/innobase/fts/fts0opt.cc:3008#2 0x0000559304504281 in ha_innobase::commit_inplace_alter_table (this=0x15198801def0, altered_table=0x1519c4a74e80, ha_alter_info=0x1519c4a74dc0, commit=true) at /test/10.6_opt/storage/innobase/handler/handler0alter.cc:10875#3 0x0000559304040eee in mysql_inplace_alter_table (thd=0x151988000c58, table_list=0x151988010958, table=0x15198801b528, altered_table=0x1519c4a74e80, ha_alter_info=0x1519c4a74dc0, ddl_log_state=0x1519c4a74da0, trigger_param=0x1519c4a75250, alter_ctx=0x1519c4a76260, target_mdl_request=<optimized out>) at /test/10.6_opt/sql/sql_table.cc:7437#4 0x000055930405007c in mysql_alter_table (thd=thd@entry=0x151988000c58, new_db=new_db@entry=0x151988010970, new_name=new_name@entry=0x151988010980, create_info=create_info@entry=0x1519c4a77080, table_list=<optimized out>, table_list@entry=0x151988010958, alter_info=alter_info@entry=0x1519c4a76f90, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.6_opt/sql/sql_table.cc:10205#5 0x0000559303fa6e35 in mysql_execute_command (thd=0x151988000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.6_opt/sql/structs.h:568#6 0x0000559303f965c6 in mysql_parse (thd=0x151988000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.6_opt/sql/sql_parse.cc:8030#7 0x0000559303fa24c5 in dispatch_command (command=COM_QUERY, thd=0x151988000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.6_opt/sql/sql_class.h:1357#8 0x0000559303fa43e7 in do_command (thd=0x151988000c58, blocking=blocking@entry=true) at /test/10.6_opt/sql/sql_parse.cc:1404#9 0x00005593040b2ef7 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /test/10.6_opt/sql/sql_connect.cc:1418#10 0x00005593040b323d in handle_one_connection (arg=arg@entry=0x5593061aa8f8) at /test/10.6_opt/sql/sql_connect.cc:1312#11 0x000055930443d778 in pfs_spawn_thread (arg=0x559306120e28) at /test/10.6_opt/storage/perfschema/pfs.cc:2201#12 0x00001519cf3b2609 in start_thread (arg=<optimized out>) at pthread_create.c:477#13 0x00001519cefa0293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:9510.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Debug)
Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.Program terminated with signal SIGSEGV, Segmentation fault.#0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040,name=0x5599f06af210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc",state=0x145c2894eeb0, this=0x0)at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700[Current thread is 1 (Thread 0x145c28953700 (LWP 3085835))](gdb) bt#0 PolicyMutex<TTASEventMutex<GenericPolicy> >::pfs_begin_lock (line=3040, name=0x5599f06af210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", state=0x145c2894eeb0, this=0x0) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:700#1 PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x0, n_spins=30, n_delay=4, name=0x5599f06af210 "/test/10.5_dbg/storage/innobase/fts/fts0opt.cc", line=3040) at /test/10.5_dbg/storage/innobase/include/ib0mutex.h:585#2 0x00005599f019e4f7 in fts_sync_during_ddl (table=0x145bfc033c48) at /test/10.5_dbg/storage/innobase/fts/fts0opt.cc:3040#3 0x00005599efdfd232 in ha_innobase::commit_inplace_alter_table (this=0x145bfc024b30, altered_table=0x145c28950270, ha_alter_info=0x145c289501d0, commit=true) at /test/10.5_dbg/storage/innobase/handler/handler0alter.cc:11042#4 0x00005599ef9c3c3d in handler::ha_commit_inplace_alter_table (this=0x145bfc024b30, altered_table=altered_table@entry=0x145c28950270, ha_alter_info=ha_alter_info@entry=0x145c289501d0, commit=commit@entry=true) at /test/10.5_dbg/sql/handler.cc:4857#5 0x00005599ef7b6a93 in mysql_inplace_alter_table (thd=thd@entry=0x145bfc000db8, table_list=0x145bfc013e18, table=table@entry=0x145bfc022228, altered_table=altered_table@entry=0x145c28950270, ha_alter_info=ha_alter_info@entry=0x145c289501d0, target_mdl_request=target_mdl_request@entry=0x145c289507c0, alter_ctx=0x145c28951310) at /test/10.5_dbg/sql/sql_table.cc:8165#6 0x00005599ef7ca971 in mysql_alter_table (thd=thd@entry=0x145bfc000db8, new_db=new_db@entry=0x145bfc013e30, new_name=new_name@entry=0x145bfc013e40, create_info=create_info@entry=0x145c28951f60, table_list=<optimized out>, table_list@entry=0x145bfc013e18, alter_info=alter_info@entry=0x145c28951e90, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_dbg/sql/sql_table.cc:10727#7 0x00005599ef6ee850 in mysql_execute_command (thd=thd@entry=0x145bfc000db8) at /test/10.5_dbg/sql/structs.h:559#8 0x00005599ef6d959d in mysql_parse (thd=thd@entry=0x145bfc000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x145c289523d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8096#9 0x00005599ef6e880e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145bfc000db8, packet=packet@entry=0x145bfc00b4b9 "CREATE FULLTEXT INDEX idx ON articles (body)", packet_length=packet_length@entry=44, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1271#10 0x00005599ef6ec097 in do_command (thd=0x145bfc000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370#11 0x00005599ef8488d7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5599f35879c8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410#12 0x00005599ef848fdb in handle_one_connection (arg=arg@entry=0x5599f35879c8) at /test/10.5_dbg/sql/sql_connect.cc:1312#13 0x00005599efd02955 in pfs_spawn_thread (arg=0x5599f34b3bb8) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201#14 0x0000145c3ed06609 in start_thread (arg=<optimized out>) at pthread_create.c:477#15 0x0000145c3e8f4293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:9510.5.11 2c6d5c92c7e0e8b38dcb9fad94c7bf11ef4ba4b6 (Optimized)
Core was generated by `/test/MD140621-mariadb-10.5.11-linux-x86_64-opt/bin/mysqld --no-defaults --core'.Program terminated with signal SIGSEGV, Segmentation fault.#0 0x0000561ef8bbcccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (line=<optimized out>, name=<optimized out>, n_delay=<optimized out>,n_spins=<optimized out>, this=<optimized out>)at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040[Current thread is 1 (Thread 0x1479201be700 (LWP 3084565))](gdb) bt#0 0x0000561ef8bbcccd in PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (line=<optimized out>, name=<optimized out>, n_delay=<optimized out>, n_spins=<optimized out>, this=<optimized out>) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040#1 fts_sync_during_ddl (table=0x1478f4022c90) at /test/10.5_opt/storage/innobase/fts/fts0opt.cc:3040#2 0x0000561ef89da089 in ha_innobase::commit_inplace_alter_table (this=0x1478f401dbc0, altered_table=0x1479201bb440, ha_alter_info=0x1479201bb3a0, commit=true) at /test/10.5_opt/storage/innobase/handler/handler0alter.cc:11042#3 0x0000561ef8517fe7 in mysql_inplace_alter_table (thd=0x1478f4000c58, table_list=0x1478f4010518, table=0x1478f401d7b8, altered_table=0x1479201bb440, ha_alter_info=0x1479201bb3a0, alter_ctx=0x1479201bc3e0, target_mdl_request=<optimized out>) at /test/10.5_opt/sql/sql_table.cc:8165#4 0x0000561ef8524d8f in mysql_alter_table (thd=thd@entry=0x1478f4000c58, new_db=new_db@entry=0x1478f4010530, new_name=new_name@entry=0x1478f4010540, create_info=create_info@entry=0x1479201bd010, table_list=<optimized out>, table_list@entry=0x1478f4010518, alter_info=alter_info@entry=0x1479201bcf40, order_num=0, order=0x0, ignore=false, if_exists=false) at /test/10.5_opt/sql/sql_table.cc:10727#5 0x0000561ef847d836 in mysql_execute_command (thd=0x1478f4000c58) at /test/10.5_opt/sql/structs.h:559#6 0x0000561ef846c163 in mysql_parse (thd=0x1478f4000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_parse.cc:8096#7 0x0000561ef8478945 in dispatch_command (command=COM_QUERY, thd=0x1478f4000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.5_opt/sql/sql_class.h:1271#8 0x0000561ef847aed2 in do_command (thd=0x1478f4000c58) at /test/10.5_opt/sql/sql_parse.cc:1370#9 0x0000561ef85809a1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x561efbb40478, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1410#10 0x0000561ef8580e1d in handle_one_connection (arg=arg@entry=0x561efbb40478) at /test/10.5_opt/sql/sql_connect.cc:1312#11 0x0000561ef890fa99 in pfs_spawn_thread (arg=0x561efbaaede8) at /test/10.5_opt/storage/perfschema/pfs.cc:2201#12 0x0000147935765609 in start_thread (arg=<optimized out>) at pthread_create.c:477#13 0x0000147935353293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95Bug confirmed present in:
MariaDB: 10.5.11 (dbg), 10.5.11 (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.39 (dbg), 10.2.39 (opt), 10.3.30 (dbg), 10.3.30 (opt), 10.4.20 (dbg), 10.4.20 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt)