[MDEV-31122] Server crash in get_lock_data / mysql_lock_abort_for_thread - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.5.29, 10.6.22, 10.11.12, 11.4.6, 11.8.2
Component/s: Locking, Partitioning
Labels:
- non-deterministic
- pushing

Description

Note: The test case is non-deterministic, run with --repeat=N. It usually fails for me within ~10 attempts, but it can vary on different machines and builds.

--source include/have_partition.inc

CREATE TABLE t1 (a INT);

CREATE TABLE t2 (b INT, c varchar(5))

  PARTITION BY RANGE COLUMNS(c)

  SUBPARTITION by key(b) SUBPARTITIONS 2 (

    PARTITION p0 VALUES LESS THAN ('m'),

    PARTITION p1 VALUES LESS THAN ('z')

);

--connect (con1,localhost,root,,)

HANDLER t1 OPEN;

--send

  SELECT b FROM t2 PARTITION (p0);

--connection default

SET lock_wait_timeout= 1;

--error ER_STATEMENT_TIMEOUT,ER_LOCK_WAIT_TIMEOUT

ALTER TABLE t1 FORCE;

--connection con1

--reap

--disconnect con1

--connection default

DROP TABLE t2, t1;

10.4 956d6c4a
#3 <signal handler called>
#4 0x000055b0a4241324 in get_lock_data (thd=0x62b00005b208, table_ptr=0x7f6fec14d860, count=1, flags=2) at /data/src/10.4/sql/lock.cc:808
#5 0x000055b0a423f6c8 in mysql_lock_abort_for_thread (thd=0x62b00005b208, table=0x62000007d088) at /data/src/10.4/sql/lock.cc:617
#6 0x000055b0a365d3e2 in THD::notify_shared_lock (this=0x62b00005b208, ctx_in_use=0x62b00008c2e0, needs_thr_lock_abort=true) at /data/src/10.4/sql/sql_class.cc:2039
#7 0x000055b0a3b97fbc in MDL_lock::notify_conflicting_locks (this=0x6160000447a8, ctx=0x62b00005b350) at /data/src/10.4/sql/mdl.cc:612
#8 0x000055b0a3b91c7b in MDL_context::acquire_lock (this=0x62b00005b350, mdl_request=0x7f6fec14dcc0, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2343
#9 0x000055b0a3b93553 in MDL_context::upgrade_shared_lock (this=0x62b00005b350, mdl_ticket=0x60600007e5c0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2579
#10 0x000055b0a35e936a in wait_while_table_is_used (thd=0x62b00005b208, table=0x620000080088, function=HA_EXTRA_PREPARE_FOR_RENAME) at /data/src/10.4/sql/sql_base.cc:1424
#11 0x000055b0a39ffc5e in mysql_alter_table (thd=0x62b00005b208, new_db=0x62b00005fa10, new_name=0x62b00005fe68, create_info=0x7f6fec151250, table_list=0x62b000062328, recreate_info=0x7f6fec1510b0, alter_info=0x7f6fec151150, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10643
#12 0x000055b0a3b8550e in Sql_cmd_alter_table::execute (this=0x62b000062a30, thd=0x62b00005b208) at /data/src/10.4/sql/sql_alter.cc:531
#13 0x000055b0a378f235 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:6216
#14 0x000055b0a379aa37 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "ALTER TABLE t1 FORCE", length=20, parser_state=0x7f6fec153860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008
#15 0x000055b0a3770d7a in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629001766209 "", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#16 0x000055b0a376d8f3 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#17 0x000055b0a3b6c89a in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#18 0x000055b0a3b6c1b1 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#19 0x000055b0a47d8b84 in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#20 0x00007f6ff3ea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#21 0x00007f6ff3f285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Reproducible with at least MyISAM, Aria and InnoDB. With InnoDB the stack trace is a bit different (see below), and reproducing may take longer, I don't have sufficient statistical data for that.

10.4 956d6c4a with InnoDB
#3 <signal handler called>
#4 0x0000556e14d9ebbb in ha_innobase::store_lock (this=0x61d0004416a8, thd=0x62b00009a208, to=0x62b0000a2618, lock_type=TL_IGNORE) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:16523
#5 0x0000556e14ba4eab in ha_partition::store_lock (this=0x61d00043f8a8, thd=0x62b00009a208, to=0x62b0000a2618, lock_type=TL_IGNORE) at /data/src/10.4/sql/ha_partition.cc:4129
#6 0x0000556e146d5152 in get_lock_data (thd=0x62b00009a208, table_ptr=0x7f468b187010, count=1, flags=2) at /data/src/10.4/sql/lock.cc:794
#7 0x0000556e146d36c8 in mysql_lock_abort_for_thread (thd=0x62b00009a208, table=0x62000005b088) at /data/src/10.4/sql/lock.cc:617
#8 0x0000556e13af13e2 in THD::notify_shared_lock (this=0x62b00009a208, ctx_in_use=0x62b0000d92e0, needs_thr_lock_abort=true) at /data/src/10.4/sql/sql_class.cc:2039
#9 0x0000556e1402bfbc in MDL_lock::notify_conflicting_locks (this=0x6160000744a8, ctx=0x62b00009a350) at /data/src/10.4/sql/mdl.cc:612
#10 0x0000556e14025c7b in MDL_context::acquire_lock (this=0x62b00009a350, mdl_request=0x7f468b187470, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2343
#11 0x0000556e14027553 in MDL_context::upgrade_shared_lock (this=0x62b00009a350, mdl_ticket=0x6060001af000, new_type=MDL_EXCLUSIVE, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2579
#12 0x0000556e13e7fa09 in mysql_inplace_alter_table (thd=0x62b00009a208, table_list=0x62b0000a1328, table=0x620000062088, altered_table=0x7f468b18a150, ha_alter_info=0x7f468b1883e0, target_mdl_request=0x7f468b188600, alter_ctx=0x7f468b189660) at /data/src/10.4/sql/sql_table.cc:7827
#13 0x0000556e13e92a99 in mysql_alter_table (thd=0x62b00009a208, new_db=0x62b00009ea10, new_name=0x62b00009ee68, create_info=0x7f468b18b250, table_list=0x62b0000a1328, recreate_info=0x7f468b18b0b0, alter_info=0x7f468b18b150, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10451
#14 0x0000556e1401950e in Sql_cmd_alter_table::execute (this=0x62b0000a1a30, thd=0x62b00009a208) at /data/src/10.4/sql/sql_alter.cc:531
#15 0x0000556e13c23235 in mysql_execute_command (thd=0x62b00009a208) at /data/src/10.4/sql/sql_parse.cc:6216
#16 0x0000556e13c2ea37 in mysql_parse (thd=0x62b00009a208, rawbuf=0x62b0000a1228 "ALTER TABLE t1 FORCE", length=20, parser_state=0x7f468b18d860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008
#17 0x0000556e13c04d7a in dispatch_command (command=COM_QUERY, thd=0x62b00009a208, packet=0x62900087a209 "ALTER TABLE t1 FORCE", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#18 0x0000556e13c018f3 in do_command (thd=0x62b00009a208) at /data/src/10.4/sql/sql_parse.cc:1378
#19 0x0000556e1400089a in do_handle_one_connection (connect=0x608000000ba8) at /data/src/10.4/sql/sql_connect.cc:1420
#20 0x0000556e140001b1 in handle_one_connection (arg=0x608000000ba8) at /data/src/10.4/sql/sql_connect.cc:1324
#21 0x0000556e14c6cb84 in pfs_spawn_thread (arg=0x615000006208) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#22 0x00007f469fea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#23 0x00007f469ff285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

31122.combinations
0.2 kB
2025-01-15 14:57
31122.test
0.6 kB
2025-01-15 14:57
oa60b.test
2 kB
2023-04-24 18:20

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2023-04-24 18:20

Elena Stepanova made changes - 2023-06-06 23:46

Field	Original Value	New Value
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]
Assignee	Elena Stepanova [ elenst ]	Oleksandr Byelkin [ sanja ]
Description	{noformat} perl ./mtr bug2.oa60b --mysqld=--innodb --mysqld=--default-storage-engine=InnoDB --mysqld=--partition --mysqld=--loose-max-statement-time=10 --mysqld=--log_bin_trust_function_creators=OFF --testcase-timeout=120 --mysqld=--loose-innodb_trx --mysqld=--loose-innodb_locks --mysqld=--loose-innodb_cmpmem --mysqld=--loose-innodb_buffer_pool_stats --mysqld=--loose-innodb_ft_default_stopword --mysqld=--loose-innodb_ft_being_deleted --mysqld=--loose-innodb_ft_index_cache --mysqld=--loose-innodb_sys_tables --mysqld=--loose-innodb_sys_tablespaces --mysqld=--innodb-instant-alter-column-allowed=never --mysqld=--binlog-alter-two-phase=ON --mysqld=--character-set-server=macce --mysqld=--collation-server=macce_nopad_bin --mysqld=--innodb-lock-wait-timeout=1 --repeat=50 {noformat} {noformat:title=10.10 87e8463e} #3 <signal handler called> #4 0x000055fd6a6eac54 in get_lock_data (thd=0x7f6708000dc8, table_ptr=0x7f6734354a00, count=1, flags=2) at /data/src/10.10/sql/lock.cc:837 #5 0x000055fd6a6ea2a7 in mysql_lock_abort_for_thread (thd=0x7f6708000dc8, table=0x7f66fc9299c8) at /data/src/10.10/sql/lock.cc:631 #6 0x000055fd6a12cce3 in THD::notify_shared_lock (this=0x7f6708000dc8, ctx_in_use=0x7f66fc000ea8, needs_thr_lock_abort=true) at /data/src/10.10/sql/sql_class.cc:2047 #7 0x000055fd6a39a9b7 in MDL_lock::notify_conflicting_locks (this=0x7f670c12ad18, ctx=0x7f6708000f18) at /data/src/10.10/sql/mdl.cc:616 #8 0x000055fd6a39728d in MDL_context::acquire_lock (this=0x7f6708000f18, mdl_request=0x7f6734354cb0, lock_wait_timeout=86400) at /data/src/10.10/sql/mdl.cc:2357 #9 0x000055fd6a397fd3 in MDL_context::upgrade_shared_lock (this=0x7f6708000f18, mdl_ticket=0x7f67080083f0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=86400) at /data/src/10.10/sql/mdl.cc:2608 #10 0x000055fd6a0fde3f in wait_while_table_is_used (thd=0x7f6708000dc8, table=0x7f670801a108, function=HA_EXTRA_PREPARE_FOR_RENAME) at /data/src/10.10/sql/sql_base.cc:1352 #11 0x000055fd6a2dc17a in mysql_alter_table (thd=0x7f6708000dc8, new_db=0x7f6708005aa0, new_name=0x7f6708005eb0, create_info=0x7f67343572c0, table_list=0x7f6708014178, alter_info=0x7f67343571d0, order_num=0, order=0x0, ignore=true, if_exists=false) at /data/src/10.10/sql/sql_table.cc:11030 #12 0x000055fd6a391306 in Sql_cmd_alter_table::execute (this=0x7f6708014a40, thd=0x7f6708000dc8) at /data/src/10.10/sql/sql_alter.cc:547 #13 0x000055fd6a1bc185 in mysql_execute_command (thd=0x7f6708000dc8, is_called_from_prepared_stmt=false) at /data/src/10.10/sql/sql_parse.cc:5997 #14 0x000055fd6a1c2227 in mysql_parse (thd=0x7f6708000dc8, rawbuf=0x7f6708014000 "ALTER /* TID 1-22460 QNO 10706-2 */ IGNORE TABLE `oltp_aria_db`.`oltp19` CHANGE IF EXISTS `pad` pad BIGINT UNSIGNED NULL DEFAULT 0", length=130, parser_state=0x7f67343583a0) at /data/src/10.10/sql/sql_parse.cc:8035 #15 0x000055fd6a1ae807 in dispatch_command (command=COM_QUERY, thd=0x7f6708000dc8, packet=0x7f670800ba09 "", packet_length=130, blocking=true) at /data/src/10.10/sql/sql_parse.cc:1894 #16 0x000055fd6a1ad202 in do_command (thd=0x7f6708000dc8, blocking=true) at /data/src/10.10/sql/sql_parse.cc:1407 #17 0x000055fd6a38605a in do_handle_one_connection (connect=0x55fd6df94a18, put_in_cache=true) at /data/src/10.10/sql/sql_connect.cc:1418 #18 0x000055fd6a385cf9 in handle_one_connection (arg=0x55fd6df94a18) at /data/src/10.10/sql/sql_connect.cc:1312 #19 0x000055fd6a885972 in pfs_spawn_thread (arg=0x55fd6df94af8) at /data/src/10.10/storage/perfschema/pfs.cc:2201 #20 0x00007f67420a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #21 0x00007f67421285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat}	_Note: The test case is non-deterministic, run with {{--repeat=N}}. It usually fails for me within ~10 attempts, but it can vary on different machines and builds._ {code:sql} --source include/have_partition.inc CREATE TABLE t1 (a INT); CREATE TABLE t2 (b INT, c varchar(5)) PARTITION BY RANGE COLUMNS(c) SUBPARTITION by key(b) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN ('m'), PARTITION p1 VALUES LESS THAN ('z') ); --connect (con1,localhost,root,,) HANDLER t1 OPEN; --send SELECT b FROM t2 PARTITION (p0); --connection default SET lock_wait_timeout= 1; --error ER_STATEMENT_TIMEOUT,ER_LOCK_WAIT_TIMEOUT ALTER TABLE t1 FORCE; --connection con1 --reap --disconnect con1 --connection default DROP TABLE t2, t1; {code} {noformat:title=10.4 956d6c4a} #3 <signal handler called> #4 0x000055b0a4241324 in get_lock_data (thd=0x62b00005b208, table_ptr=0x7f6fec14d860, count=1, flags=2) at /data/src/10.4/sql/lock.cc:808 #5 0x000055b0a423f6c8 in mysql_lock_abort_for_thread (thd=0x62b00005b208, table=0x62000007d088) at /data/src/10.4/sql/lock.cc:617 #6 0x000055b0a365d3e2 in THD::notify_shared_lock (this=0x62b00005b208, ctx_in_use=0x62b00008c2e0, needs_thr_lock_abort=true) at /data/src/10.4/sql/sql_class.cc:2039 #7 0x000055b0a3b97fbc in MDL_lock::notify_conflicting_locks (this=0x6160000447a8, ctx=0x62b00005b350) at /data/src/10.4/sql/mdl.cc:612 #8 0x000055b0a3b91c7b in MDL_context::acquire_lock (this=0x62b00005b350, mdl_request=0x7f6fec14dcc0, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2343 #9 0x000055b0a3b93553 in MDL_context::upgrade_shared_lock (this=0x62b00005b350, mdl_ticket=0x60600007e5c0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2579 #10 0x000055b0a35e936a in wait_while_table_is_used (thd=0x62b00005b208, table=0x620000080088, function=HA_EXTRA_PREPARE_FOR_RENAME) at /data/src/10.4/sql/sql_base.cc:1424 #11 0x000055b0a39ffc5e in mysql_alter_table (thd=0x62b00005b208, new_db=0x62b00005fa10, new_name=0x62b00005fe68, create_info=0x7f6fec151250, table_list=0x62b000062328, recreate_info=0x7f6fec1510b0, alter_info=0x7f6fec151150, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10643 #12 0x000055b0a3b8550e in Sql_cmd_alter_table::execute (this=0x62b000062a30, thd=0x62b00005b208) at /data/src/10.4/sql/sql_alter.cc:531 #13 0x000055b0a378f235 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:6216 #14 0x000055b0a379aa37 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "ALTER TABLE t1 FORCE", length=20, parser_state=0x7f6fec153860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008 #15 0x000055b0a3770d7a in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629001766209 "", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857 #16 0x000055b0a376d8f3 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378 #17 0x000055b0a3b6c89a in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420 #18 0x000055b0a3b6c1b1 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324 #19 0x000055b0a47d8b84 in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869 #20 0x00007f6ff3ea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #21 0x00007f6ff3f285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat} Reproducible with at least MyISAM, Aria and InnoDB. With InnoDB the stack trace is a bit different (see below), and reproducing may take longer, I don't have sufficient statistical data for that. {noformat:title=10.4 956d6c4a with InnoDB} #3 <signal handler called> #4 0x0000556e14d9ebbb in ha_innobase::store_lock (this=0x61d0004416a8, thd=0x62b00009a208, to=0x62b0000a2618, lock_type=TL_IGNORE) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:16523 #5 0x0000556e14ba4eab in ha_partition::store_lock (this=0x61d00043f8a8, thd=0x62b00009a208, to=0x62b0000a2618, lock_type=TL_IGNORE) at /data/src/10.4/sql/ha_partition.cc:4129 #6 0x0000556e146d5152 in get_lock_data (thd=0x62b00009a208, table_ptr=0x7f468b187010, count=1, flags=2) at /data/src/10.4/sql/lock.cc:794 #7 0x0000556e146d36c8 in mysql_lock_abort_for_thread (thd=0x62b00009a208, table=0x62000005b088) at /data/src/10.4/sql/lock.cc:617 #8 0x0000556e13af13e2 in THD::notify_shared_lock (this=0x62b00009a208, ctx_in_use=0x62b0000d92e0, needs_thr_lock_abort=true) at /data/src/10.4/sql/sql_class.cc:2039 #9 0x0000556e1402bfbc in MDL_lock::notify_conflicting_locks (this=0x6160000744a8, ctx=0x62b00009a350) at /data/src/10.4/sql/mdl.cc:612 #10 0x0000556e14025c7b in MDL_context::acquire_lock (this=0x62b00009a350, mdl_request=0x7f468b187470, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2343 #11 0x0000556e14027553 in MDL_context::upgrade_shared_lock (this=0x62b00009a350, mdl_ticket=0x6060001af000, new_type=MDL_EXCLUSIVE, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2579 #12 0x0000556e13e7fa09 in mysql_inplace_alter_table (thd=0x62b00009a208, table_list=0x62b0000a1328, table=0x620000062088, altered_table=0x7f468b18a150, ha_alter_info=0x7f468b1883e0, target_mdl_request=0x7f468b188600, alter_ctx=0x7f468b189660) at /data/src/10.4/sql/sql_table.cc:7827 #13 0x0000556e13e92a99 in mysql_alter_table (thd=0x62b00009a208, new_db=0x62b00009ea10, new_name=0x62b00009ee68, create_info=0x7f468b18b250, table_list=0x62b0000a1328, recreate_info=0x7f468b18b0b0, alter_info=0x7f468b18b150, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:10451 #14 0x0000556e1401950e in Sql_cmd_alter_table::execute (this=0x62b0000a1a30, thd=0x62b00009a208) at /data/src/10.4/sql/sql_alter.cc:531 #15 0x0000556e13c23235 in mysql_execute_command (thd=0x62b00009a208) at /data/src/10.4/sql/sql_parse.cc:6216 #16 0x0000556e13c2ea37 in mysql_parse (thd=0x62b00009a208, rawbuf=0x62b0000a1228 "ALTER TABLE t1 FORCE", length=20, parser_state=0x7f468b18d860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008 #17 0x0000556e13c04d7a in dispatch_command (command=COM_QUERY, thd=0x62b00009a208, packet=0x62900087a209 "ALTER TABLE t1 FORCE", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857 #18 0x0000556e13c018f3 in do_command (thd=0x62b00009a208) at /data/src/10.4/sql/sql_parse.cc:1378 #19 0x0000556e1400089a in do_handle_one_connection (connect=0x608000000ba8) at /data/src/10.4/sql/sql_connect.cc:1420 #20 0x0000556e140001b1 in handle_one_connection (arg=0x608000000ba8) at /data/src/10.4/sql/sql_connect.cc:1324 #21 0x0000556e14c6cb84 in pfs_spawn_thread (arg=0x615000006208) at /data/src/10.4/storage/perfschema/pfs.cc:1869 #22 0x00007f469fea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #23 0x00007f469ff285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81 {noformat}
Summary	[Draft] Server crash in get_lock_data / mysql_lock_abort_for_thread	Server crash in get_lock_data / mysql_lock_abort_for_thread

Elena Stepanova made changes - 2023-06-06 23:49

Component/s

Partitioning [ 10802 ]

Oleksandr Byelkin made changes - 2023-09-26 12:13

Assignee

Oleksandr Byelkin [ sanja ]

Aleksey Midenkov [ midenok ]

Julien Fritsch made changes - 2023-11-28 10:21

Fix Version/s

10.9 [ 26905 ]

Julien Fritsch made changes - 2023-11-28 10:32

Fix Version/s

10.10 [ 27530 ]

Julien Fritsch made changes - 2024-05-03 14:40

Fix Version/s

11.0 [ 28320 ]

Julien Fritsch made changes - 2024-09-10 15:07

Fix Version/s

10.4 [ 22408 ]

Aleksey Midenkov made changes - 2024-10-01 13:04

Labels

non-deterministic

Aleksey Midenkov made changes - 2025-01-15 12:03

Status

Open [ 1 ]

In Progress [ 3 ]

Aleksey Midenkov added a comment - 2025-01-15 14:44 - edited

I reproduced 956d6c4a on 562 repeat in debug and 534 repeat in release. It seems release reproduces better as it failed several times in a row.

Reproduces in main:
```
18dbeae1b86 (HEAD -> main, mariadb/main) ~~MDEV-35849~~: index records in a wrong order
```

Aleksey Midenkov added a comment - 2025-01-15 14:44 - edited I reproduced 956d6c4a on 562 repeat in debug and 534 repeat in release. It seems release reproduces better as it failed several times in a row. Reproduces in main: ``` 18dbeae1b86 (HEAD -> main, mariadb/main) MDEV-35849 : index records in a wrong order ```

Aleksey Midenkov made changes - 2025-01-15 14:57

Attachment		31122.test [ 74469 ]
Attachment		31122.combinations [ 74470 ]

Aleksey Midenkov added a comment - 2025-01-20 11:20

Please review bb-10.5-midenok2

Aleksey Midenkov added a comment - 2025-01-20 11:20 Please review bb-10.5-midenok2

Aleksey Midenkov made changes - 2025-01-20 11:20

Assignee	Aleksey Midenkov [ midenok ]	Oleksandr Byelkin [ sanja ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Aleksey Midenkov made changes - 2025-03-17 08:39

Assignee

Oleksandr Byelkin [ sanja ]

Sergei Golubchik [ serg ]

Sergei Golubchik added a comment - 2025-03-26 10:50

https://github.com/MariaDB/server/commit/11e372c is ok to push

good commit comment, thanks

Sergei Golubchik added a comment - 2025-03-26 10:50 https://github.com/MariaDB/server/commit/11e372c is ok to push good commit comment, thanks

Sergei Golubchik made changes - 2025-03-26 10:50

Assignee	Sergei Golubchik [ serg ]	Aleksey Midenkov [ midenok ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Aleksey Midenkov made changes - 2025-03-30 15:48

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Aleksey Midenkov made changes - 2025-03-30 15:49

Labels

non-deterministic

non-deterministic pushing

Aleksey Midenkov made changes - 2025-04-01 11:49

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Aleksey Midenkov added a comment - 2025-04-01 11:49

Please decide which branch to push (bb-10.5-midenok2)

Aleksey Midenkov added a comment - 2025-04-01 11:49 Please decide which branch to push (bb-10.5-midenok2)

Aleksey Midenkov made changes - 2025-04-01 11:49

Assignee

Aleksey Midenkov [ midenok ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2025-04-01 18:11

Fix Version/s		10.5.29 [ 29996 ]
Fix Version/s		10.6.22 [ 29997 ]
Fix Version/s		10.11.12 [ 29998 ]
Fix Version/s		11.4.6 [ 29999 ]
Fix Version/s		11.8.2 [ 30001 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Assignee	Sergei Golubchik [ serg ]	Aleksey Midenkov [ midenok ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Aleksey Midenkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2023-04-24 18:20

Updated:: 2025-04-01 18:11

Resolved:: 2025-04-01 18:11

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration