[MDEV-21701] [draft] Created: 2020-02-10  Updated: 2020-02-10  Resolved: 2020-02-10

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alice Sherepa
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-21683 Server crashes in get_quick_keys with... Closed
Relates
relates to MDEV-8903 Buildbot valgrind failure: Invalid re... Closed

 Description   

10.5 77c6382312535991d2

#4  0x000055caa62d94e5 in get_quick_keys (param=0x7faf92032880, quick=0x7faf801d6510, key=0x7faf801d5538, key_tree=0x0, min_key=0x7faf801d5580 "\245\245\245\245\245\245\217\217\245\245\245\245\245\245\217\217\003", min_key_flag=0, max_key=0x7faf801d5588 "\245\245\245\245\245\245\217\217\003", max_key_flag=0) at /10.5/sql/opt_range.cc:11291
#5  0x000055caa62d9542 in get_quick_keys (param=0x7faf92032880, quick=0x7faf801d6510, key=0x7faf801d5538, key_tree=0x55caa78a1ae0 <null_element>, min_key=0x7faf801d5580 "\245\245\245\245\245\245\217\217\245\245\245\245\245\245\217\217\003", min_key_flag=0, max_key=0x7faf801d5588 "\245\245\245\245\245\245\217\217\003", max_key_flag=0) at /10.5/sql/opt_range.cc:11296
#6  0x000055caa62d9375 in get_quick_select (param=0x7faf92032880, idx=0, key_tree=0x55caa78a1ae0 <null_element>, mrr_flags=1, mrr_buf_size=2148818976, parent_alloc=0x0) at /10.5/sql/opt_range.cc:11259
#7  0x000055caa62e86a2 in TRP_RANGE::make_quick (this=0x7faf801d5800, param=0x7faf92032880, retrieve_full_rows=true, parent_alloc=0x0) at /10.5/sql/opt_range.cc:2246
#8  0x000055caa62c464a in SQL_SELECT::test_quick_select (this=0x7faf801d2b88, thd=0x7faf80000b00, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true, only_single_index_range_scan=false) at /10.5/sql/opt_range.cc:3007
#9  0x000055caa5e3ed9a in get_quick_record_count (thd=0x7faf80000b00, select=0x7faf801d2b88, table=0x7faf80145270, keys=0x7faf801d19f8, limit=18446744073709551615) at /10.5/sql/sql_select.cc:4706
#10 0x000055caa5e415b7 in make_join_statistics (join=0x7faf801c3ae0, tables_list=..., keyuse_array=0x7faf801c3dd0) at /10.5/sql/sql_select.cc:5431
#11 0x000055caa5e35c5b in JOIN::optimize_inner (this=0x7faf801c3ae0) at /10.5/sql/sql_select.cc:2258
#12 0x000055caa5e3352c in JOIN::optimize (this=0x7faf801c3ae0) at /10.5/sql/sql_select.cc:1604
#13 0x000055caa5e3ea63 in mysql_select (thd=0x7faf80000b00, tables=0x7faf80013ad0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7faf801c3ab8, unit=0x7faf80004a50, select_lex=0x7faf80013558) at /10.5/sql/sql_select.cc:4648
#14 0x000055caa5e2e5e5 in handle_select (thd=0x7faf80000b00, lex=0x7faf80004990, result=0x7faf801c3ab8, setup_tables_done_option=0) at /10.5/sql/sql_select.cc:428
#15 0x000055caa5df3dab in execute_sqlcom_select (thd=0x7faf80000b00, all_tables=0x7faf80013ad0) at /10.5/sql/sql_parse.cc:6114
#16 0x000055caa5dea789 in mysql_execute_command (thd=0x7faf80000b00) at /10.5/sql/sql_parse.cc:3904
#17 0x000055caa5df8aa0 in mysql_parse (thd=0x7faf80000b00, rawbuf=0x7faf800134a8 "SELECT 1 FROM table_partitioned, v3", length=35, parser_state=0x7faf920343f0, is_com_multi=false, is_next_command=false) at /10.5/sql/sql_parse.cc:7892
#18 0x000055caa5de4476 in dispatch_command (command=COM_QUERY, thd=0x7faf80000b00, packet=0x7faf80008441 "SELECT 1 FROM table_partitioned, v3", packet_length=35, is_com_multi=false, is_next_command=false) at /10.5/sql/sql_parse.cc:1846
#19 0x000055caa5de2ba4 in do_command (thd=0x7faf80000b00) at /10.5/sql/sql_parse.cc:1364
#20 0x000055caa5f83e14 in do_handle_one_connection (connect=0x55caaa2bcd30, put_in_cache=true) at /10.5/sql/sql_connect.cc:1422
#21 0x000055caa5f83b18 in handle_one_connection (arg=0x55caaa307ee0) at /10.5/sql/sql_connect.cc:1319
#22 0x000055caa64e7371 in pfs_spawn_thread (arg=0x55caaa21b730) at /10.5/storage/perfschema/pfs.cc:1869
#23 0x00007faf9931e6ba in start_thread (arg=0x7faf92035700) at pthread_create.c:333
#24 0x00007faf985af41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109



 Comments   
Comment by Elena Stepanova [ 2020-02-10 ]

Maybe MDEV-21683

Comment by Alice Sherepa [ 2020-02-10 ]

yes, thanks!

Generated at Thu Feb 08 09:09:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.