[MDEV-24174] Server crashes on partitioned tables with dynamically changed myisam_data_pointer_size - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Fix Version/s: 10.5
Component/s: Partitioning, Storage Engine - MyISAM
Labels:
None

Description

I'm setting it to Minor, because the dynamic change of MYISAM_DATA_POINTER_SIZE makes it unlikely to affect real users.

Variation 1 (10.3+)

--source include/have_partition.inc

SET @myisam_data_pointer_size.save= @@myisam_data_pointer_size;

CREATE TABLE t1 (a INT, b INT, KEY (b)) ENGINE=MyISAM PARTITION BY KEY(b) PARTITIONS 2;

INSERT INTO t1 VALUES (8,0),(6,8),(1,6),(2,1);

SET GLOBAL MYISAM_DATA_POINTER_SIZE= 5;

ALTER TABLE t1 REBUILD PARTITION p0;

SELECT * FROM t1 PARTITION (p0);

ALTER TABLE t1 ORDER BY a;

# Cleanup

DROP TABLE t1;

SET GLOBAL myisam_data_pointer_size= @myisam_data_pointer_size.save;

10.3 59eda73e debug
#3 <signal handler called>
#4 __memset_avx2_unaligned_erms () at ../sysdeps/x86_64/multiarch/memset-vec-unaligned-erms.S:202
#5 0x0000555cbd190262 in ha_partition::position (this=0x7ff958099738, record=0x7ff95809d208 "\371\b") at /data/src/10.3/sql/ha_partition.cc:5165
#6 0x0000555cbc9475ee in find_all_keys (thd=0x7ff958000d90, param=0x7ff96f00a130, select=0x0, fs_info=0x7ff958128b00, buffpek_pointers=0x7ff96f00a330, tempfile=0x7ff96f00a1c0, pq=0x0, found_rows=0x7ff958128ce0) at /data/src/10.3/sql/filesort.cc:785
#7 0x0000555cbc945988 in filesort (thd=0x7ff958000d90, table=0x7ff958098af0, filesort=0x7ff96f00a670, tracker=0x7ff96f00a6a0, join=0x0, first_table_bit=0) at /data/src/10.3/sql/filesort.cc:269
#8 0x0000555cbc714bbb in copy_data_between_tables (thd=0x7ff958000d90, from=0x7ff958098af0, to=0x7ff9580a7d40, create=..., ignore=false, order_num=1, order=0x7ff958013308, copied=0x7ff96f00b0d0, deleted=0x7ff96f00b0d8, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7ff96f00b8e0) at /data/src/10.3/sql/sql_table.cc:10550
#9 0x0000555cbc7130b8 in mysql_alter_table (thd=0x7ff958000d90, new_db=0x7ff958005478, new_name=0x7ff958005840, create_info=0x7ff96f00c4d0, table_list=0x7ff958012b90, alter_info=0x7ff96f00c410, order_num=1, order=0x7ff958013308, ignore=false) at /data/src/10.3/sql/sql_table.cc:10083
#10 0x0000555cbc7a33fe in Sql_cmd_alter_table::execute (this=0x7ff958013360, thd=0x7ff958000d90) at /data/src/10.3/sql/sql_alter.cc:512
#11 0x0000555cbc62e321 in mysql_execute_command (thd=0x7ff958000d90) at /data/src/10.3/sql/sql_parse.cc:6052
#12 0x0000555cbc633b88 in mysql_parse (thd=0x7ff958000d90, rawbuf=0x7ff958012ab8 "ALTER TABLE t1 ORDER BY a", length=25, parser_state=0x7ff96f00d5c0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7840
#13 0x0000555cbc6202ec in dispatch_command (command=COM_QUERY, thd=0x7ff958000d90, packet=0x7ff958008f11 "ALTER TABLE t1 ORDER BY a", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
#14 0x0000555cbc61ec8c in do_command (thd=0x7ff958000d90) at /data/src/10.3/sql/sql_parse.cc:1398
#15 0x0000555cbc79d295 in do_handle_one_connection (connect=0x555cbf4e9340) at /data/src/10.3/sql/sql_connect.cc:1403
#16 0x0000555cbc79cff1 in handle_one_connection (arg=0x555cbf4e9340) at /data/src/10.3/sql/sql_connect.cc:1308
#17 0x0000555cbd169049 in pfs_spawn_thread (arg=0x555cbf4cc480) at /data/src/10.3/storage/perfschema/pfs.cc:1869
#18 0x00007ff979542609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#19 0x00007ff97911e293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.3 59eda73e non-debug
#3 <signal handler called>
#4 __memset_avx2_unaligned_erms () at ../sysdeps/x86_64/multiarch/memset-vec-unaligned-erms.S:202
#5 0x000056123bb5bffe in find_all_keys (found_rows=0x7f6a181168c0, pq=0x0, tempfile=0x7f6a35b75170, buffpek_pointers=0x7f6a35b75260, fs_info=0x7f6a18116760, select=0x0, param=0x7f6a35b750e0, thd=0x7f6a18000c48) at /data/src/10.3/sql/filesort.cc:785
#6 filesort (thd=thd@entry=0x7f6a18000c48, table=table@entry=0x7f6a18170738, filesort=filesort@entry=0x7f6a35b754a0, tracker=tracker@entry=0x7f6a35b754d0, join=join@entry=0x0, first_table_bit=first_table_bit@entry=0) at /data/src/10.3/sql/filesort.cc:269
#7 0x000056123b9ff07f in copy_data_between_tables (thd=0x7f6a18000c48, from=0x7f6a18170738, to=0x7f6a18064578, create=..., ignore=false, order_num=1, order=0x7f6a1800ff60, copied=0x7f6a35b75f80, deleted=0x7f6a35b75f88, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7f6a35b769c0) at /data/src/10.3/sql/sql_table.cc:10550
#8 0x000056123ba06416 in mysql_alter_table (thd=thd@entry=0x7f6a18000c48, new_db=new_db@entry=0x7f6a18005170, new_name=new_name@entry=0x7f6a18005538, create_info=create_info@entry=0x7f6a35b77580, table_list=<optimized out>, table_list@entry=0x7f6a1800f7e8, alter_info=alter_info@entry=0x7f6a35b774c0, order_num=1, order=0x7f6a1800ff60, ignore=false) at /data/src/10.3/sql/sql_table.cc:10083
#9 0x000056123ba5984f in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7f6a18000c48) at /data/src/10.3/sql/sql_alter.cc:512
#10 0x000056123b963978 in mysql_execute_command (thd=0x7f6a18000c48) at /data/src/10.3/sql/sql_parse.cc:6052
#11 0x000056123b96b013 in mysql_parse (thd=0x7f6a18000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7840
#12 0x000056123b96d3dd in dispatch_command (command=COM_QUERY, thd=0x7f6a18000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_class.h:1139
#13 0x000056123b96f3bd in do_command (thd=0x7f6a18000c48) at /data/src/10.3/sql/sql_parse.cc:1398
#14 0x000056123ba56bb6 in do_handle_one_connection (connect=connect@entry=0x56123d50fcc8) at /data/src/10.3/sql/sql_connect.cc:1403
#15 0x000056123ba56d8f in handle_one_connection (arg=arg@entry=0x56123d50fcc8) at /data/src/10.3/sql/sql_connect.cc:1308
#16 0x000056123c031236 in pfs_spawn_thread (arg=0x56123d5efd28) at /data/src/10.3/storage/perfschema/pfs.cc:1869
#17 0x00007f6a3bf96609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#18 0x00007f6a3bb8b293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.3 59eda73e ASAN
==754735==ERROR: AddressSanitizer: use-after-poison on address 0x61d0001c9c98 at pc 0x7fbe2dc68f2d bp 0x7fbe228f1140 sp 0x7fbe228f08e8
WRITE of size 4294967295 at 0x61d0001c9c98 thread T5
#0 0x7fbe2dc68f2c (/lib/x86_64-linux-gnu/libasan.so.5+0x67f2c)
#1 0x565047414b7d in ha_partition::position(unsigned char const*) /data/src/10.3/sql/ha_partition.cc:5165
#2 0x56504614282d in find_all_keys /data/src/10.3/sql/filesort.cc:785
#3 0x56504613e7f9 in filesort(THD, TABLE, Filesort, Filesort_tracker, JOIN*, unsigned long long) /data/src/10.3/sql/filesort.cc:269
#4 0x565045c46fd0 in copy_data_between_tables /data/src/10.3/sql/sql_table.cc:10550
#5 0x565045c43003 in mysql_alter_table(THD, st_mysql_const_lex_string const, st_mysql_const_lex_string const, HA_CREATE_INFO, TABLE_LIST, Alter_info, unsigned int, st_order*, bool) /data/src/10.3/sql/sql_table.cc:10083
#6 0x565045dae62c in Sql_cmd_alter_table::execute(THD*) /data/src/10.3/sql/sql_alter.cc:512
#7 0x5650459f3361 in mysql_execute_command(THD*) /data/src/10.3/sql/sql_parse.cc:6052
#8 0x5650459ff991 in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.3/sql/sql_parse.cc:7840
#9 0x5650459d67d5 in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.3/sql/sql_parse.cc:1852
#10 0x5650459d330c in do_command(THD*) /data/src/10.3/sql/sql_parse.cc:1398
#11 0x565045d9da9f in do_handle_one_connection(CONNECT*) /data/src/10.3/sql/sql_connect.cc:1403
#12 0x565045d9d359 in handle_one_connection /data/src/10.3/sql/sql_connect.cc:1308
#13 0x5650473b69f2 in pfs_spawn_thread /data/src/10.3/storage/perfschema/pfs.cc:1869
#14 0x7fbe2d7a7608 in start_thread /build/glibc-ZN95T4/glibc-2.31/nptl/pthread_create.c:477
#15 0x7fbe2d381292 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x122292)

0x61d0001ca0a4 is located 0 bytes to the right of 2084-byte region [0x61d0001c9880,0x61d0001ca0a4)
allocated by thread T5 here:
#0 0x7fbe2dd0ebc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x565047501025 in sf_malloc /data/src/10.3/mysys/safemalloc.c:118
#2 0x5650474cee8d in my_malloc /data/src/10.3/mysys/my_malloc.c:101
#3 0x5650474aaefa in alloc_root /data/src/10.3/mysys/my_alloc.c:251
#4 0x5650457263b9 in Query_arena::alloc(unsigned long) /data/src/10.3/sql/sql_class.h:1020
#5 0x5650458d36e6 in thd_alloc /data/src/10.3/sql/sql_class.cc:1084
#6 0x5650457aa105 in Sql_alloc::operator new(unsigned long) /data/src/10.3/sql/sql_alloc.h:30
#7 0x5650465d5942 in mysql_unpack_partition(THD, char, unsigned int, TABLE, bool, handlerton, bool*) /data/src/10.3/sql/sql_partition.cc:4504
#8 0x565045cd2750 in open_table_from_share(THD, TABLE_SHARE, st_mysql_const_lex_string const, unsigned int, unsigned int, unsigned int, TABLE, bool, List<String>*) /data/src/10.3/sql/table.cc:3458
#9 0x56504586b324 in open_table(THD, TABLE_LIST, Open_table_context*) /data/src/10.3/sql/sql_base.cc:1992
#10 0x5650458746ec in open_and_process_table /data/src/10.3/sql/sql_base.cc:3730
#11 0x565045876d0f in open_tables(THD, DDL_options_st const&, TABLE_LIST, unsigned int, unsigned int, Prelocking_strategy*) /data/src/10.3/sql/sql_base.cc:4199
#12 0x56504587be07 in open_and_lock_tables(THD, DDL_options_st const&, TABLE_LIST, bool, unsigned int, Prelocking_strategy*) /data/src/10.3/sql/sql_base.cc:5128
#13 0x5650457e022f in open_and_lock_tables(THD, TABLE_LIST, bool, unsigned int) /data/src/10.3/sql/sql_base.h:503
#14 0x5650459f51bb in execute_sqlcom_select /data/src/10.3/sql/sql_parse.cc:6237
#15 0x5650459e3728 in mysql_execute_command(THD*) /data/src/10.3/sql/sql_parse.cc:3847
#16 0x5650459ff991 in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.3/sql/sql_parse.cc:7840
#17 0x5650459d67d5 in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.3/sql/sql_parse.cc:1852
#18 0x5650459d330c in do_command(THD*) /data/src/10.3/sql/sql_parse.cc:1398
#19 0x565045d9da9f in do_handle_one_connection(CONNECT*) /data/src/10.3/sql/sql_connect.cc:1403
#20 0x565045d9d359 in handle_one_connection /data/src/10.3/sql/sql_connect.cc:1308
#21 0x5650473b69f2 in pfs_spawn_thread /data/src/10.3/storage/perfschema/pfs.cc:1869
#22 0x7fbe2d7a7608 in start_thread /build/glibc-ZN95T4/glibc-2.31/nptl/pthread_create.c:477

Thread T5 created by T0 here:
#0 0x7fbe2dc3b805 in pthread_create (/lib/x86_64-linux-gnu/libasan.so.5+0x3a805)
#1 0x5650473b6de3 in spawn_thread_v1 /data/src/10.3/storage/perfschema/pfs.cc:1919
#2 0x5650456fe15e in inline_mysql_thread_create /data/src/10.3/include/mysql/psi/mysql_thread.h:1275
#3 0x565045716b2d in create_thread_to_handle_connection(CONNECT*) /data/src/10.3/sql/mysqld.cc:6658
#4 0x5650457172c8 in create_new_thread /data/src/10.3/sql/mysqld.cc:6728
#5 0x56504571845a in handle_connections_sockets() /data/src/10.3/sql/mysqld.cc:6986
#6 0x565045715e1e in mysqld_main(int, char**) /data/src/10.3/sql/mysqld.cc:6280
#7 0x5650456fc95c in main /data/src/10.3/sql/main.cc:25
#8 0x7fbe2d2860b2 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x270b2)

SUMMARY: AddressSanitizer: use-after-poison (/lib/x86_64-linux-gnu/libasan.so.5+0x67f2c)
Shadow bytes around the buggy address:
0x0c3a80031340: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0x0c3a80031350: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0x0c3a80031360: 00 00 00 00 00 00 00 00 00 00 f7 00 00 00 00 00
0x0c3a80031370: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0x0c3a80031380: 00 f7 00 00 f7 04 f7 00 f7 00 00 00 04 f7 00 00
=>0x0c3a80031390: f7 00 00[f7]00 00 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
0x0c3a800313a0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
0x0c3a800313b0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
0x0c3a800313c0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
0x0c3a800313d0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
0x0c3a800313e0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
Shadow byte legend (one shadow byte represents 8 application bytes):
Addressable: 00
Partially addressable: 01 02 03 04 05 06 07
Heap left redzone: fa
Freed heap region: fd
Stack left redzone: f1
Stack mid redzone: f2
Stack right redzone: f3
Stack after return: f5
Stack use after scope: f8
Global redzone: f9
Global init order: f6
Poisoned by user: f7
Container overflow: fc
Array cookie: ac
Intra object redzone: bb
ASan internal: fe
Left alloca redzone: ca
Right alloca redzone: cb
Shadow gap: cc
==754735==ABORTING

Reproducible on 10.3-10.6, debug- and non-debug as described above.

Variation 2 (10.2)

_The same or very similar problem was fixed in 10.3+ in the scope of ~~MDEV-23248~~. The original test case in ~~MDEV-23248~~ didn't cause the failure on 10.2, so it was not fixed there.

--source include/have_partition.inc

--source include/have_sequence.inc

SET @myisam_data_pointer_size.save= @@myisam_data_pointer_size;

SET GLOBAL myisam_data_pointer_size= 2;

CREATE TABLE t (a INT) ENGINE=MyISAM PARTITION BY HASH (a) PARTITIONS 2;

INSERT INTO t SELECT seq FROM seq_1_to_65536;

--error ER_RECORD_FILE_FULL

ALTER TABLE t COALESCE PARTITION 1;

# Cleanup

DROP TABLE t;

SET GLOBAL myisam_data_pointer_size= @myisam_data_pointer_size.save;

10.2 c048053c
2020-11-09 15:43:26 140104635049728 [ERROR] mysqld: The table 't' is full
201109 15:43:26 [ERROR] mysqld got signal 11 ;

#3 <signal handler called>
#4 0x0000560224106ff0 in mi_extra (info=0x0, function=HA_EXTRA_FORCE_REOPEN, extra_arg=0x0) at /data/src/10.2/storage/myisam/mi_extra.c:45
#5 0x00005602240e5005 in ha_myisam::extra (this=0x7f6c90013258, operation=HA_EXTRA_FORCE_REOPEN) at /data/src/10.2/storage/myisam/ha_myisam.cc:2041
#6 0x00005602241a6e57 in ha_partition::loop_extra_alter (this=0x7f6c900a1f38, operation=HA_EXTRA_FORCE_REOPEN) at /data/src/10.2/sql/ha_partition.cc:7421
#7 0x00005602241a6747 in ha_partition::extra (this=0x7f6c900a1f38, operation=HA_EXTRA_FORCE_REOPEN) at /data/src/10.2/sql/ha_partition.cc:7162
#8 0x00005602237901a9 in wait_while_table_is_used (thd=0x7f6c90000d90, table=0x7f6c900a0ed0, function=HA_EXTRA_FORCE_REOPEN) at /data/src/10.2/sql/sql_base.cc:1236
#9 0x0000560223c36c4d in handle_alter_part_error (lpt=0x7f6ca700ae50, action_completed=false, drop_partition=false, frm_install=false, close_table=true) at /data/src/10.2/sql/sql_partition.cc:6456
#10 0x0000560223c387bb in fast_alter_partition_table (thd=0x7f6c90000d90, table=0x7f6c900a0ed0, alter_info=0x7f6ca700c1e0, create_info=0x7f6ca700c290, table_list=0x7f6c900127f0, db=0x7f6c90012e08 "test", table_name=0x7f6c900127b8 "t") at /data/src/10.2/sql/sql_partition.cc:7006
#11 0x00005602238df94a in mysql_alter_table (thd=0x7f6c90000d90, new_db=0x7f6c90012e08 "test", new_name=0x0, create_info=0x7f6ca700c290, table_list=0x7f6c900127f0, alter_info=0x7f6ca700c1e0, order_num=0, order=0x0, ignore=false) at /data/src/10.2/sql/sql_table.cc:9337
#12 0x000056022395e662 in Sql_cmd_alter_table::execute (this=0x7f6c90012e18, thd=0x7f6c90000d90) at /data/src/10.2/sql/sql_alter.cc:333
#13 0x000056022380d012 in mysql_execute_command (thd=0x7f6c90000d90) at /data/src/10.2/sql/sql_parse.cc:5995
#14 0x0000560223812027 in mysql_parse (thd=0x7f6c90000d90, rawbuf=0x7f6c900126f8 "ALTER TABLE t COALESCE PARTITION 1", length=34, parser_state=0x7f6ca700d5f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7761
#15 0x00005602238002bc in dispatch_command (command=COM_QUERY, thd=0x7f6c90000d90, packet=0x7f6c90008b51 "ALTER TABLE t COALESCE PARTITION 1", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
#16 0x00005602237fedb7 in do_command (thd=0x7f6c90000d90) at /data/src/10.2/sql/sql_parse.cc:1381
#17 0x0000560223959057 in do_handle_one_connection (connect=0x560227615b00) at /data/src/10.2/sql/sql_connect.cc:1336
#18 0x0000560223958dbc in handle_one_connection (arg=0x560227615b00) at /data/src/10.2/sql/sql_connect.cc:1241
#19 0x0000560224180ee2 in pfs_spawn_thread (arg=0x5602275f8e90) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#20 0x00007f6cb13f9609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#21 0x00007f6cb0fd5293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Reproducible the same way on debug-, release- and asan builds of 10.2.
The failure is scalable – it crashes the same way with at least myisam_data_pointer_size=3 and 16777216 rows. I didn't try higher values.

Possibly the test case could have become more real-life-like if it was using MAX_ROWS option instead of myisam_data_pointer_size, but I can't make it do so, maybe partitioning doesn't pay attention to the option?

Variation 2a – with a debug assertion failure, otherwise the same disclaimers apply: only 10.2 release line + non-practical use case.

--source include/have_partition.inc

CREATE TABLE t1 (a INT, b INT, KEY (b)) ENGINE = MYISAM PARTITION BY HASH (a) PARTITIONS 3;

INSERT INTO t1 VALUES (6,2),(4,8),(7,2),(8,5);

SET GLOBAL MYISAM_DATA_POINTER_SIZE= 3;

ALTER TABLE t1 REBUILD PARTITION p0;

SELECT 1 AS f FROM t1;

10.2 6ede84f4
mysqld: /data/src/10.2/sql/ha_partition.cc:6156: int ha_partition::handle_ordered_index_scan(uchar, bool): Assertion `i == (uint16) (((uint16 *) (part_rec_buf_ptr)))' failed.
210203 13:43:18 [ERROR] mysqld got signal 6 ;

tion=0x5557ece3b700 "int ha_partition::handle_ordered_index_scan(uchar*, bool)") at assert.c:101
#8 0x00005557ecac8932 in ha_partition::handle_ordered_index_scan (this=0x7fc36409f768, buf=0x7fc36403a280 "\377", reverse_order=false) at /data/src/10.2/sql/ha_partition.cc:6156
#9 0x00005557ecac7683 in ha_partition::common_first_last (this=0x7fc36409f768, buf=0x7fc36403a280 "\377") at /data/src/10.2/sql/ha_partition.cc:5615
#10 0x00005557ecac7518 in ha_partition::index_first (this=0x7fc36409f768, buf=0x7fc36403a280 "\377") at /data/src/10.2/sql/ha_partition.cc:5563
#11 0x00005557ec3b20c1 in handler::ha_index_first (this=0x7fc36409f768, buf=0x7fc36403a280 "\377") at /data/src/10.2/sql/handler.cc:2809
#12 0x00005557ec19b7c7 in join_read_first (tab=0x7fc3640140d8) at /data/src/10.2/sql/sql_select.cc:19848
#13 0x00005557ec199194 in sub_select (join=0x7fc364012fb8, join_tab=0x7fc3640140d8, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18856
#14 0x00005557ec198758 in do_select (join=0x7fc364012fb8, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18403
#15 0x00005557ec1723cf in JOIN::exec_inner (this=0x7fc364012fb8) at /data/src/10.2/sql/sql_select.cc:3642
#16 0x00005557ec171876 in JOIN::exec (this=0x7fc364012fb8) at /data/src/10.2/sql/sql_select.cc:3437
#17 0x00005557ec172a38 in mysql_select (thd=0x7fc364000d90, tables=0x7fc364012880, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fc364012f98, unit=0x7fc364004988, select_lex=0x7fc3640050c8) at /data/src/10.2/sql/sql_select.cc:3837
#18 0x00005557ec166bb2 in handle_select (thd=0x7fc364000d90, lex=0x7fc3640048c8, result=0x7fc364012f98, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:361
#19 0x00005557ec1312bc in execute_sqlcom_select (thd=0x7fc364000d90, all_tables=0x7fc364012880) at /data/src/10.2/sql/sql_parse.cc:6248
#20 0x00005557ec127c6b in mysql_execute_command (thd=0x7fc364000d90) at /data/src/10.2/sql/sql_parse.cc:3559
#21 0x00005557ec135065 in mysql_parse (thd=0x7fc364000d90, rawbuf=0x7fc3640126f8 "SELECT 1 AS f FROM t1", length=21, parser_state=0x7fc3751585f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7763
#22 0x00005557ec12333e in dispatch_command (command=COM_QUERY, thd=0x7fc364000d90, packet=0x7fc364008b51 "", packet_length=21, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
#23 0x00005557ec121e39 in do_command (thd=0x7fc364000d90) at /data/src/10.2/sql/sql_parse.cc:1381
#24 0x00005557ec27c88e in do_handle_one_connection (connect=0x5557efdf9970) at /data/src/10.2/sql/sql_connect.cc:1336
#25 0x00005557ec27c5f3 in handle_one_connection (arg=0x5557efdf9970) at /data/src/10.2/sql/sql_connect.cc:1241
#26 0x00005557ecaa4b82 in pfs_spawn_thread (arg=0x5557efddccd0) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#27 0x00007fc37b50e609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#28 0x00007fc37b0ea293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Attachments

Issue Links

relates to

MDEV-23248 Server crashes in mi_extra / ha_partition::loop_extra_alter upon REORGANIZE

Closed

Activity

People

Assignee:: Unassigned

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2020-11-09 13:51

Updated:: 2024-09-10 15:00

Git Integration

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