Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
--source include/have_rocksdb.inc
|
|
|
CREATE TABLE t (i INT, UNIQUE ind (i)) ENGINE=RocksDB; |
|
|
--error ER_ILLEGAL_HA_CREATE_OPTION
|
CREATE OR REPLACE INDEX ind ON t (i DESC); |
|
|
SHOW CREATE TABLE t; |
On a non-debug build, SHOW CREATE returns an error:
CREATE OR REPLACE INDEX ind ON t (i DESC); |
ERROR HY000: Table storage engine 'ROCKSDB' does not support the create option 'DESC' |
SHOW CREATE TABLE t; |
bug.14230 [ fail ]
|
Test ended at 2022-07-06 21:10:40 |
|
|
CURRENT_TEST: bug.14230
|
mysqltest: At line 8: query 'SHOW CREATE TABLE t' failed: ER_ILLEGAL_HA_CREATE_OPTION (1478): Table storage engine 'ROCKSDB' does not support the create option 'DESC' |
On a debug build, it becomes an assertion failure:
|
10.8 155019b9 |
mariadbd: /data/src/10.8/sql/sql_error.cc:375: void Diagnostics_area::set_eof_status(THD*): Assertion `!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())' failed.
|
220706 21:12:16 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f9702abb662 in __GI___assert_fail (assertion=0x5616b7ec87e8 "!is_set() || (m_status == DA_EOF_BULK && is_bulk_op())", file=0x5616b7ec85e0 "/data/src/10.8/sql/sql_error.cc", line=375, function=0x5616b7ec8820 "void Diagnostics_area::set_eof_status(THD*)") at assert.c:101
|
No locals.
|
#8 0x00005616b71121c1 in Diagnostics_area::set_eof_status (this=0x7f96b8006d20, thd=0x7f96b8000db8) at /data/src/10.8/sql/sql_error.cc:375
|
_db_stack_frame_ = {func = 0x5616b7ef56a0 "mysqld_show_create", file = 0x5616b7ef4a00 "/data/src/10.8/sql/sql_show.cc", level = 2147483654, line = -1, prev = 0x7f96fc0f6d80}
|
__PRETTY_FUNCTION__ = "void Diagnostics_area::set_eof_status(THD*)"
|
#9 0x00005616b703b1b5 in my_eof (thd=0x7f96b8000db8) at /data/src/10.8/sql/sql_class.h:5597
|
No locals.
|
#10 0x00005616b7231ed6 in mysqld_show_create (thd=0x7f96b8000db8, table_list=0x7f96b80154e0) at /data/src/10.8/sql/sql_show.cc:1364
|
protocol = 0x7f96b80013c0
|
buff = "CREATE TABLE `t` (\n `i` int(11) DEFAULT NULL,\n KEY `ind` (`i` DESC)\n) ENGINE=ROCKSDB DEFAULT CHARSET=latin1\000\000\000\020u\017\374\226\177\000\000=\027\332\267\000\000\001\000\060u\017\374\226\177\000\000\061\024\335\267\026V\000\000\060u\017\374\226\177\000\000\340\f\000\270\226\177\000\000\340\f\000\270\226\177\000\000\270\f\000\270\001\000\000\000pw\017\374\226\177\000\000\243\006\335\267\026V\000\000`u\017\374\226\177\000\000"...
|
buffer = {<Charset> = {m_charset = 0x5616b8a9a860 <my_charset_utf8mb3_general_ci>}, <Binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f96fc0f7480 "CREATE TABLE `t` (\n `i` int(11) DEFAULT NULL,\n KEY `ind` (`i` DESC)\n) ENGINE=ROCKSDB DEFAULT CHARSET=latin1", str_length = 109, Alloced_length = 2048, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}
|
field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7f96b8015c48, last = 0x7f96b8015cf0, elements = 2}, <No data fields>}
|
error = false
|
_db_stack_frame_ = {func = 0x5616b7ed7a60 "mysql_execute_command", file = 0x5616b7ed6d38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f96fc0f7e30}
|
mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}
|
archive = {next_local = 0x7f96b8105a60, next_global = 0x0, prev_global = 0x5616b89917c0 <my_charset_latin1>, db = {str = 0x0, length = 140285309901728}, table_name = {str = 0x7f96b8105ba0 '\217' <repeats 200 times>..., length = 8589934590}, schema_table_name = {str = 0x7f96b8015bf0 "`\250\251\270\026V", length = 0}, alias = {str = 0x7f96b8015bf0 "`\250\251\270\026V", length = 4}, option = 0x7f96b80154d8 "t", on_expr = 0x1, on_context = 0x7f96fc0f7a4f, table_function = 0x19, sj_on_expr = 0x7f96fc0f7a4f, sj_inner_tables = 25, sj_in_exprs = 3088079200, sj_subq_pred = 0x0, original_subq_pred_used_tables = 1, jtbm_subselect = 0x0, jtbm_table_no = 1, sj_mat_info = 0x0, prep_on_expr = 0x0, cond_equal = 0x0, natural_join = 0x189c4, is_natural_join = 5, join_using_fields = 0x5, join_columns = 0x0, is_join_columns_complete = false, next_name_resolution_table = 0x3, index_hints = 0x0, table = 0x0, table_id = 8589934593, derived_result = 0x100000001, map = 1, correspondent_table = 0x100000000, derived = 0x0, with = 0x100000000, with_internal_reference_map = 0, next_with_rec_ref = 0x800000000, is_derived_with_recursive_reference = true, block_handle_derived = false, dt_handler = 0x600000001, derived_spec = {str = 0x0, length = 34359738376}, pushdown_derived = 0x1, schema_table = 0x40, schema_select_lex = 0x0, schema_table_reformed = false, schema_table_param = 0xa00000004, select_lex = 0x100010000000001, view = 0x100000000, field_translation = 0x0, field_translation_end = 0x18, field_translation_updated = false, merge_underlying_list = 0x0, view_tables = 0x0, belong_to_view = 0x0, belong_to_derived = 0x0, referencing_view = 0x0, view_used_tables = 0, map_exec = 0, tablenr_exec = 0, maybe_null_exec = 0, parent_l = 0x5616b7f0da1a, security_ctx = 0xb, view_sctx = 0x0, allowed_show = false, where = 0x0, check_option = 0x0, select_stmt = {str = 0x0, length = 0}, md5 = {str = 0x0, length = 0}, source = {str = 0x0, length = 0}, view_db = {str = 0x0, length = 0}, view_name = {str = 0x0, length = 0}, timestamp = {str = 0x1b7da1700 <error: Cannot access memory at address 0x1b7da1700>, length = 140285308918768}, definer = {<AUTHID> = {user = {str = 0x4 <error: Cannot access memory at address 0x4>, length = 140285308916952}, host = {str = 0x1 <error: Cannot access memory at address 0x1>, length = 140286450692400}}, auth = 0x7}, file_version = 140285308916952, mariadb_version = 1, updatable_view = 140285308918768, algorithm = 4, view_suid = 140285308916952, with_check = 1, effective_with_check = 216 '\330', derived_type = 84 'T', grant = {grant_table_user = 0x1, grant_table_role = 0x7f96fc0f758c, version = 18, privilege = NO_ACL, want_privilege = NO_ACL, orig_want_privilege = NO_ACL, m_internal = {m_schema_lookup_done = 16, m_schema_access = 0x7f96fc0f7120, m_table_lookup_done = 16, m_table_access = 0x7f96fc0f70f0}}, engine_data = 94655573792573, callback_func = 0x7f96b8000ce0, lock_type = -1207956640, mdl_type = 32662, table_options = 140286450692368, outer_join = 3084705855, shared = 22038, updatable = 224, straight = 12, updating = false, force_index = 184, ignore_leaves = 150, crashed = 127, skip_locked = false, dep_tables = 140285308832952, on_expr_dep_tables = 140286450692416, nested_join = 0xb7dd0860, embedding = 0xec1157fd29e0d62a, join_list = 0x304eaad, lifted = 82, cacheable_table = 79, table_in_first_from_clause = 67, open_type = (OT_TEMPORARY_ONLY | OT_BASE_ONLY | unknown: 0x424450), contain_auto_increment = 61, compact_view_format = 23, where_processed = 218, check_option_processed = 183, required_type = TABLE_TYPE_UNKNOWN, db_type = 0x5616b831dedd, timestamp_buffer = "\000\000\000\000\000\000\000\000pq\017\374\226\177\000\000=\027\332\267", prelocking_placeholder = (unknown: 0x10000), open_strategy = (unknown: 0xfc0f7190), is_alias = 150, is_fqtn = 127, fill_me = false, merged = false, merged_for_insert = 49, sequence = 20, used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5616b8ab20c0 <end_of_list>, last = 0x7f96fc0f7170, elements = 0}, <No data fields>}, persistent_used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5616b8ab20c0 <end_of_list>, last = 0x7f96fc0f7188, elements = 0}, <No data fields>}, view_creation_ctx = 0x15180, view_client_cs_name = {str = 0x7f96fc0f7410 "d\360\357\267\026V", length = 140282221821959}, view_connection_cl_name = {str = 0x7f96b8000ce0 "\325n\365\357\377\177", length = 140286450692576}, view_body_utf8 = {str = 0xfc0f75d0 <error: Cannot access memory at address 0xfc0f75d0>, length = 94655577299685}, trg_event_map = 0 '\000', slave_fk_event_map = 0 '\000', optimized_away = false, materialized = false, i_s_requested_object = 0, prohibit_cond_pushdown = false, table_open_method = 32662, schema_table_state = (PROCESSED_BY_CREATE_SORT_INDEX | unknown: 0xb7da173c), is_table_read_plan = 0x4244534b434f52, mdl_request = {type = MDL_NOT_INITIALIZED, duration = MDL_STATEMENT, next_in_list = 0x5616b7ec2702, prev_in_list = 0x0, ticket = 0x0, key = {m_length = 5949, m_db_name_length = 47066, m_hash_value = 65536, m_ptr = "Pr\017\374\226\177\000\000\061\024\335\267\026V\000\000Pr\017\374\226\177\000\000\340\f\000\270\000\000\000\000\063\342\061\270\026V\000\000\000\000\000\000\000\000\000\000pr\017\374\226\177\000\000=\027\332\267\000\000\001\000\220r\017\374\226\177\000\000\061\024\335\267\026V\000\000\220r\017\374\226\177\000\000\340\f\000\270\000\000\000\000\017\347\061\270\026V\000\000\000\000\000\000\000\000\000\000\260r\017\374\226\177\000\000=\027\332\267\000\000\001\000\320r\017\374\226\177\000\000\061\024\335\267\026V\000\000\000\000\000\374\226\177", '\000' <repeats 20 times>, "./test/t.frm\000\000\243\006\335\267\026V\000\000 u\017\374\226\177\000\000"...}, m_src_file = 0x7f96fc0f7600 "0v\017\374\226\177", m_src_line = 6}, partition_names = 0x7f96b8000ce0, vers_conditions = {type = 4228871136, orig_type = 32662, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_TIMESTAMP, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_TIMESTAMP, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x7f9600000008, field_end = 0x7f96b8000ce0, period = 0x5616b7eff064}, period_conditions = {type = 4228871760, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_TIMESTAMP, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_TIMESTAMP, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x7f96b8000ce0, field_end = 0x7f96b8000ce0, period = 0xb8000cb8}, for_insert_data = 100 'd', m_table_ref_type = 22038, m_table_ref_version = 0}
|
#11 0x00005616b716ead8 in mysql_execute_command (thd=0x7f96b8000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:4367
|
res = 0
|
up_result = 0
|
lex = 0x7f96b80050f0
|
select_lex = 0x7f96b80059c0
|
first_table = 0x7f96b80154e0
|
all_tables = 0x7f96b80154e0
|
unit = 0x7f96b80051c8
|
have_table_map_for_update = false
|
rpl_filter = 0x0
|
_db_stack_frame_ = {func = 0x5616b7ed8def "mysql_parse", file = 0x5616b7ed6d38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f96fc0f8240}
|
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
|
ots = {ctx = 0x7f96b8004d88, traceable = false}
|
orig_binlog_format = BINLOG_FORMAT_MIXED
|
orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
|
#12 0x00005616b717b0d1 in mysql_parse (thd=0x7f96b8000db8, rawbuf=0x7f96b8015410 "SHOW CREATE TABLE t", length=19, parser_state=0x7f96fc0f83c0) at /data/src/10.8/sql/sql_parse.cc:8027
|
found_semicolon = 0x0
|
error = 32662
|
lex = 0x7f96b80050f0
|
err = false
|
_db_stack_frame_ = {func = 0x5616b7ed72b1 "dispatch_command", file = 0x5616b7ed6d38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f96fc0f83a0}
|
__PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)"
|
#13 0x00005616b716775a in dispatch_command (command=COM_QUERY, thd=0x7f96b8000db8, packet=0x7f96b800b999 "", packet_length=19, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
|
packet_end = 0x7f96b8015423 ""
|
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f96b8000db8, m_ptr = 0x7f96b8015424 "\004", m_tok_start = 0x7f96b8015424 "\004", m_tok_end = 0x7f96b8015424 "\004", m_end_of_query = 0x7f96b8015423 "", m_tok_start_prev = 0x7f96b8015423 "", m_buf = 0x7f96b8015410 "SHOW CREATE TABLE t", m_buf_length = 19, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f96b8015480 "SHOW CREATE TABLE t", m_cpp_ptr = 0x7f96b8015493 "", m_cpp_tok_start = 0x7f96b8015493 "", m_cpp_tok_start_prev = 0x7f96b8015493 "", m_cpp_tok_end = 0x7f96b8015493 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x1b8000cb8 <error: Cannot access memory at address 0x1b8000cb8>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (unknown: 0x10000), m_cpp_text_start = 0x7f96b8015492 "t", m_cpp_text_end = 0x7f96b8015493 "", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f96b8004b18}
|
net = 0x7f96b80010f0
|
error = false
|
do_end_of_statement = true
|
_db_stack_frame_ = {func = 0x5616b7ed6f35 "do_command", file = 0x5616b7ed6d38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f96fc0f8c80}
|
drop_more_results = false
|
__PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD*, char*, uint, bool)"
|
__FUNCTION__ = "dispatch_command"
|
res = <optimized out>
|
#14 0x00005616b7166155 in do_command (thd=0x7f96b8000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
|
return_value = DISPATCH_COMMAND_SUCCESS
|
packet = 0x7f96b800b998 "\002"
|
packet_length = 20
|
net = 0x7f96b80010f0
|
command = COM_QUERY
|
_db_stack_frame_ = {func = 0x5616b8324380 "?func", file = 0x5616b8324386 "?file", level = 2147483649, line = -1, prev = 0x0}
|
__PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
|
__FUNCTION__ = "do_command"
|
#15 0x00005616b7339be4 in do_handle_one_connection (connect=0x5616bbadffa8, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418
|
create_user = true
|
thr_create_utime = 3553248504580
|
thd = 0x7f96b8000db8
|
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
|
#16 0x00005616b7339883 in handle_one_connection (arg=0x5616bbb46968) at /data/src/10.8/sql/sql_connect.cc:1312
|
connect = 0x5616bbb46968
|
#17 0x00005616b7830f2e in pfs_spawn_thread (arg=0x5616bbadfb08) at /data/src/10.8/storage/perfschema/pfs.cc:2201
|
typed_arg = 0x5616bbadfb08
|
user_arg = 0x5616bbb46968
|
user_start_routine = 0x5616b7339828 <handle_one_connection(void*)>
|
pfs = 0x7f97023b3880
|
klass = 0x5616bb3a8e80
|
#18 0x00007f9702f85ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
ret = <optimized out>
|
pd = <optimized out>
|
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140286450702080, 8328576879236925700, 140737219216014, 140737219216015, 140286450699840, 311296, -8306620593634883324, -8306034662796900092}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
|
not_first_call = 0
|
#19 0x00007f9702b84def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Replacing SHOW CREATE with something else may lead to fancier crashes:
--source include/have_rocksdb.inc
|
|
|
CREATE TABLE t (i INT, UNIQUE ind (i)) ENGINE=RocksDB; |
|
|
--error ER_ILLEGAL_HA_CREATE_OPTION
|
CREATE OR REPLACE INDEX ind ON t (i DESC); |
|
|
--error ER_ILLEGAL_HA_CREATE_OPTION
|
ALTER TABLE t FORCE; |
|
|
SELECT * FROM t WHERE i = 107; |
|
|
# Cleanup
|
DROP TABLE t; |
220706 21:14:00 [ERROR] mysqld got signal 11 ;
|
|
|
#3 <signal handler called>
|
No locals.
|
#4 myrocks::Rdb_field_packing::get_field_in_table (this=0x7fc5f4013ad8, tbl=0x7fc5f40fa7a8) at /data/src/10.8/storage/rocksdb/rdb_datadic.cc:3500
|
No locals.
|
#5 0x00007fc63724efbb in myrocks::Rdb_key_def::pack_record (this=0x7fc5f410a650, tbl=0x7fc5f40fa7a8, pack_buffer=0x7fc5f40fb0f8 '\245' <repeats 16 times>, "h4z\025", '\217' <repeats 12 times>, "\265", record=0x7fc5f4222aa8 "\245k", packed_tuple=0x7fc5f4226e78 "", unpack_info=0x0, should_store_row_debug_checksums=false, hidden_pk_id=0, n_key_parts=1, n_null_fields=0x0, ttl_bytes=0x0) at /data/src/10.8/storage/rocksdb/rdb_datadic.cc:1378
|
field = 0x55b5886a0760 <key_restore(unsigned char*, unsigned char const*, st_key*, unsigned int)+879>
|
field_offset = 0
|
null_offset = 0
|
maybe_null = false
|
i = 0
|
__PRETTY_FUNCTION__ = "uint myrocks::Rdb_key_def::pack_record(const TABLE*, uchar*, const uchar*, uchar*, myrocks::Rdb_string_writer*, bool, longlong, uint, uint*, const char*) const"
|
tuple = 0x7fc5f4226e7c '\245' <repeats 12 times>, "h4z\025\217\217\217\217\217\217\217\217"
|
unpack_start_pos = 18446744073709551615
|
unpack_len_pos = 18446744073709551615
|
covered_bitmap_pos = 18446744073709551615
|
hidden_pk_exists = true
|
use_all_columns = false
|
store_covered_bitmap = false
|
tag = 2 '\002'
|
covered_bitmap = {bitmap = 0x7fc6343e8ba8, last_word_ptr = 0x7fc6343e8ba8, last_word_mask = 0, n_bits = 32}
|
covered_bits = 0
|
curr_bitmap_pos = 0
|
#6 0x00007fc63724df6a in myrocks::Rdb_key_def::pack_index_tuple (this=0x7fc5f410a650, tbl=0x7fc5f40fa7a8, pack_buffer=0x7fc5f40fb0f8 '\245' <repeats 16 times>, "h4z\025", '\217' <repeats 12 times>, "\265", packed_tuple=0x7fc5f4226e78 "", record_buffer=0x7fc5f4222aa8 "\245k", key_tuple=0x7fc5f4b0a068 "", keypart_map=@0x7fc6343e8f20: 1) at /data/src/10.8/storage/rocksdb/rdb_datadic.cc:1024
|
__PRETTY_FUNCTION__ = "uint myrocks::Rdb_key_def::pack_index_tuple(TABLE*, uchar*, uchar*, uchar*, const uchar*, const key_part_map&) const"
|
key_len = 5
|
n_used_parts = 1
|
#7 0x00007fc6371c55dd in myrocks::ha_rocksdb::records_in_range (this=0x7fc5f40f96a0, inx=0, min_key=0x7fc6343e8f10, max_key=0x7fc6343e8f30, pages=0x7fc6343e8ee0) at /data/src/10.8/storage/rocksdb/ha_rocksdb.cc:11996
|
_db_stack_frame_ = {func = 0x55b588f8276f "multi_range_read_info_const", file = 0x55b588f82748 "/data/src/10.8/sql/multi_range_read.cc", level = 2147483662, line = -1, prev = 0x7fc6343e8ef0}
|
__PRETTY_FUNCTION__ = "virtual ha_rows myrocks::ha_rocksdb::records_in_range(uint, const key_range*, const key_range*, page_range*)"
|
ret = 0
|
kd = @0x7fc5f410a650: {m_index_number = 256, m_index_number_storage_form = "\000\000\001", m_cf_handle = 0x55b58bf39f40, m_index_dict_version = 6, m_index_type = 2 '\002', m_kv_format_version = 13, m_is_reverse_cf = false, m_is_per_partition_cf = false, m_name = "ind", m_stats = {m_gl_index_id = {cf_id = 0, index_id = 0}, m_data_size = 0, m_rows = 0, m_actual_disk_size = 0, m_entry_deletes = 0, m_entry_single_deletes = 0, m_entry_merges = 0, m_entry_others = 0, m_distinct_keys_per_prefix = std::vector of length 0, capacity 0, m_name = ""}, m_index_flags_bitmap = 0, m_total_index_flags_length = 0, m_ttl_rec_offset = 4294967295, m_ttl_duration = 0, m_ttl_column = "", m_pk_key_parts = 1, m_pk_part_no = 0x7fc5f416b4a8, m_pack_info = 0x7fc5f4013ad8, m_keyno = 0, m_key_parts = 2, m_ttl_pk_key_part_offset = 4294967295, m_ttl_field_index = 4294967295, m_prefix_extractor = std::shared_ptr<const rocksdb::SliceTransform> (empty) = {get() = 0x0}, m_maxlength = 0, m_mutex = {m_mutex = {global = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 2, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 16 times>, "\002", '\000' <repeats 22 times>, __align = 0}, mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 3, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 16 times>, "\003", '\000' <repeats 22 times>, __align = 0}, file = 0x7fc6376ec988 "/data/src/10.8/storage/rocksdb/rdb_datadic.cc", name = 0x7fc6376ec4b0 "m_mutex", line = 406, count = 0, create_flags = 0, active_flags = 0, id = 268, thread = 0, locked_mutex = 0x7fc5f410a8b8, used_mutex = 0x7fc5f410a938, prev = 0x0, next = 0x0}, m_psi = 0x0}}
|
size1 = 0
|
size2 = 0
|
slice1 = {data_ = 0x7fc5f40f9410 "\001", size_ = 140488179024032}
|
slice2 = {data_ = 0x7fc6343e8dd0 "p\217>4\306\177", size_ = 94238159315424}
|
r = {start = {data_ = 0x7fc5f4b0a100 "", size_ = 140488179946288}, limit = {data_ = 0x7fc6343e9030 "", size_ = 2297964399}}
|
sz = 140489256769840
|
disk_size = 140488179946512
|
rows = 140488179946512
|
include_flags = 0 '\000'
|
memTableCount = 140488190501120
|
#8 0x000055b5883ce3de in handler::multi_range_read_info_const (this=0x7fc5f40f96a0, keyno=0, seq=0x7fc6343e9000, seq_init_param=0x7fc6343e9030, n_ranges_arg=0, bufsz=0x7fc6343e95c8, flags=0x7fc6343e95c4, cost=0x7fc6343e96b0) at /data/src/10.8/sql/multi_range_read.cc:177
|
pages = {first_page = 18446744073709551615, last_page = 18446744073709551615}
|
rows = 281477272917821
|
min_endp = 0x7fc6343e8f10
|
max_endp = 0x7fc6343e8f30
|
keyparts_used = 1
|
range = {start_key = {key = 0x7fc5f4b0a068 "", length = 5, keypart_map = 1, flag = HA_READ_KEY_EXACT}, end_key = {key = 0x7fc5f4b0a070 "", length = 5, keypart_map = 1, flag = HA_READ_AFTER_KEY}, ptr = 0x0, range_flag = 32}
|
seq_it = 0x7fc6343e9030
|
total_rows = 0
|
n_ranges = 1
|
max_rows = 1
|
thd = 0x7fc5f4000db8
|
io_blocks = 0
|
edge_blocks_cnt = 0
|
range_blocks_cnt = 0
|
prev_range_last_block = 18446744073709551615
|
prev_range_last_block_records = 0
|
single_point_ranges = 0
|
assigned_single_point_ranges = 0
|
unassigned_single_point_ranges = 0
|
len = 17
|
avg_block_records = 181
|
limit = 200
|
use_statistics_for_eq_range = false
|
_db_stack_frame_ = {func = 0x55b588ecd1d8 "check_quick_select", file = 0x55b588ecb090 "/data/src/10.8/sql/opt_range.cc", level = 2147483661, line = -1, prev = 0x7fc6343e8fe0}
|
__PRETTY_FUNCTION__ = "virtual ha_rows handler::multi_range_read_info_const(uint, RANGE_SEQ_IF*, void*, uint, uint*, uint*, Cost_estimate*)"
|
#9 0x000055b588045a48 in check_quick_select (param=0x7fc6343e9930, idx=0, index_only=true, tree=0x7fc5f4b0a100, update_tbl_stats=true, mrr_flags=0x7fc6343e95c4, bufsize=0x7fc6343e95c8, cost=0x7fc6343e96b0, is_ror_scan=0x7fc6343e95c2) at /data/src/10.8/sql/opt_range.cc:11603
|
seq = {keyno = 0, real_keyno = 0, param = 0x7fc6343e9930, key_parts = 0x7fc5f4b0a040, start = 0x7fc5f4b0a100, stack = {{min_key = 0x7fc5f4b0a068 "", max_key = 0x7fc5f4b0a070 "", min_key_flag = 0, max_key_flag = 0, min_key_parts = 0, max_key_parts = 0, key_tree = 0x0}, {min_key = 0x7fc5f4b0a06d "\245\217\217", max_key = 0x7fc5f4b0a075 "\245\217\217\003", min_key_flag = 0, max_key_flag = 0, min_key_parts = 1, max_key_parts = 1, key_tree = 0x7fc5f4b0a100}, {min_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", max_key = 0xf4000cb8 <error: Cannot access memory at address 0xf4000cb8>, min_key_flag = 2301951510, max_key_flag = 21941, min_key_parts = 0, max_key_parts = 0, key_tree = 0x7fc6343e90e0}, {min_key = 0x1000088dd573d <error: Cannot access memory at address 0x1000088dd573d>, max_key = 0x7fc6343e9100 "@\223>4\306\177", min_key_flag = 2296402993, max_key_flag = 21941, min_key_parts = 876515584, max_key_parts = 32710, key_tree = 0x7fc5f4000ce0}, {min_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", max_key = 0x1f4000cb8 <error: Cannot access memory at address 0x1f4000cb8>, min_key_flag = 876516160, max_key_flag = 32710, min_key_parts = -1998567773, max_key_parts = 21941, key_tree = 0x7fc6343e9140}, {min_key = 0x7fc6343e93a0 "@\316\354\210\265U", max_key = 0x7fc600000010 "", min_key_flag = 4093644000, max_key_flag = 32709, min_key_parts = -201323296, max_key_parts = 32709, key_tree = 0x1f4000cb8}, {min_key = 0x7fc6343e9380 "\360\223>4\306\177", max_key = 0x55b588e046a3 <_db_return_+209> "\203\340\001\205\300\017\204\n\001", min_key_flag = 876516240, max_key_flag = 32710, min_key_parts = 876516288, max_key_parts = 0, key_tree = 0x55b588ecce40}, {min_key = 0x0, max_key = 0x7fc6343e9190 "\260\221>4\306\177", min_key_flag = 2296207165, max_key_flag = 65536, min_key_parts = 876515760, max_key_parts = 32710, key_tree = 0x55b588e05431 <DoTrace+150>}, {min_key = 0x7fc6343e91b0 "\360\223>4\306\177", max_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", min_key_flag = 4093644000, max_key_flag = 32709, min_key_parts = -201323336, max_key_parts = 1, key_tree = 0x7fc6343e93f0}, {min_key = 0x55b588e046a3 <_db_return_+209> "\203\340\001\205\300\017\204\n\001", max_key = 0x7fc6343e91f0 "\020\222>4\306\177", min_key_flag = 876516416, max_key_flag = 32710, min_key_parts = 15, max_key_parts = 0, key_tree = 0xf4000ce0}, {min_key = 0x55b588eccd4e "Field::get_mm_leaf_int", max_key = 0x0, min_key_flag = 876515856, max_key_flag = 32710, min_key_parts = -1998760131, max_key_parts = 65536, key_tree = 0x7fc6343e9230}, {min_key = 0x55b588e05431 <DoTrace+150> "\203\370\005\177\063\205\300\017\210\255", max_key = 0x7fc6343e9230 "p\224>4\306\177", min_key_flag = 4093644000, max_key_flag = 32709, min_key_parts = -201323296, max_key_parts = 32709, key_tree = 0x1f4000cb8}, {min_key = 0x7fc6343e9470 "\220\224>4\306\177", max_key = 0x55b588e046a3 <_db_return_+209> "\203\340\001\205\300\017\204\n\001", min_key_flag = 876516240, max_key_flag = 32710, min_key_parts = 876516544, max_key_parts = 32710, key_tree = 0x55b50000000e}, {min_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", max_key = 0x7fc6343e9280 "\240\222>4\306\177", min_key_flag = 2296206865, max_key_flag = 0, min_key_parts = -1993015786, max_key_parts = 21941, key_tree = 0x0}, {min_key = 0x7fc6343e92a0 "\300\222>4\306\177", max_key = 0x1000088dd573d <error: Cannot access memory at address 0x1000088dd573d>, min_key_flag = 876516032, max_key_flag = 32710, min_key_parts = -1998564303, max_key_parts = 21941, key_tree = 0x7fc6343e92c0}, {min_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", max_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", min_key_flag = 4093643960, max_key_flag = 1, min_key_parts = 876516608, max_key_parts = 32710, key_tree = 0x55b588e046a3 <_db_return_+209>}, {min_key = 0x7fc6343e9300 "@\225>4\306\177", max_key = 0x7fc6343e9560 "\220\225>4\306\177", min_key_flag = 12, max_key_flag = 32710, min_key_parts = -201323296, max_key_parts = 32709, key_tree = 0x7fc5f4000ce0}, {min_key = 0x1f4000cb8 <error: Cannot access memory at address 0x1f4000cb8>, max_key = 0x7fc6343e9540 "", min_key_flag = 2296399523, max_key_flag = 21941, min_key_parts = 876516160, max_key_parts = 32710, key_tree = 0x343e9580}, {min_key = 0x55b588eccac2 "get_mm_parts", max_key = 0x0, min_key_flag = 876516176, max_key_flag = 32710, min_key_parts = -1998760131, max_key_parts = 65536, key_tree = 0x7fc6343e9370}, {min_key = 0x55b588e05431 <DoTrace+150> "\203\370\005\177\063\205\300\017\210\255", max_key = 0x7fc6343e9370 "\260\225>4\306\177", min_key_flag = 4093644000, max_key_flag = 32709, min_key_parts = -201323296, max_key_parts = 32709, key_tree = 0x1f4000cb8}, {min_key = 0x7fc6343e95b0 "x\240\260\364\305\177", max_key = 0x55b588e046a3 <_db_return_+209> "\203\340\001\205\300\017\204\n\001", min_key_flag = 876516336, max_key_flag = 32710, min_key_parts = 876516896, max_key_parts = 32710, key_tree = 0x7fc50000000c}, {min_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", max_key = 0x55b588ecce40 "Field::stored_field_make_mm_leaf_exact", min_key_flag = 2297213072, max_key_flag = 21941, min_key_parts = -2147483632, max_key_parts = 359, key_tree = 0xf40f9260}, {min_key = 0x55b588ecca91 "Item_equal::get_mm_tree", max_key = 0x0, min_key_flag = 876516336, max_key_flag = 32710, min_key_parts = -1998760131, max_key_parts = 65536, key_tree = 0x7fc6343e9410}, {min_key = 0x55b588e05431 <DoTrace+150> "\203\370\005\177\063\205\300\017\210\255", max_key = 0x7fc6343e9410 "P\226>4\306\177", min_key_flag = 4093644000, max_key_flag = 32709, min_key_parts = -201323296, max_key_parts = 32709, key_tree = 0x1f4000cb8}, {min_key = 0x7fc6343e9650 "0\022x\211\265U", max_key = 0x55b588e046a3 <_db_return_+209> "\203\340\001\205\300\017\204\n\001", min_key_flag = 876517680, max_key_flag = 32710, min_key_parts = 876517040, max_key_parts = 32710, key_tree = 0x7fc60000000b}, {min_key = 0x7fc5f4000ce0 "\325\256\226\003\375\177", max_key = 0x55b588eccd4e "Field::get_mm_leaf_int", min_key_flag = 2297213072, max_key_flag = 21941, min_key_parts = -2147483633, max_key_parts = 9081, key_tree = 0x343e94c0}, {min_key = 0x55b58934fe16 "alloc_root", max_key = 0x0, min_key_flag = 876516496, max_key_flag = 32710, min_key_parts = -1998760431, max_key_parts = 21941, key_tree = 0x7fc6343e94a0}, {min_key = 0x55b588dd5611 <_my_thread_var+20> "]\303UH\211\345H\203\354\020H\211}\370H\215\005Zf^\001\213", max_key = 0x7fc6343e94b0 "\320\224>4\306\177", min_key_flag = 2296207165, max_key_flag = 21941, min_key_parts = 876516544, max_key_parts = 32710, key_tree = 0x7fc5f4000b60}, {min_key = 0x7fc6343e94d0 "", max_key = 0x55b588e0203f <code_state+167> "H\211E\370H\203}\370", min_key_flag = 4093644000, max_key_flag = 32709, min_key_parts = -201323336, max_key_parts = 32709, key_tree = 0x7fc6343e9500}, {min_key = 0x55b588e04860 <_db_pargs_+20> "H\211E\370H\203}\370", max_key = 0x55b58934fe5b "exit", min_key_flag = 4093644000, max_key_flag = 358, min_key_parts = 0, max_key_parts = 0, key_tree = 0x7fc6343e9680}, {min_key = 0x7fc6343e9520 "`\225>4\306\177", max_key = 0x55b588059dff <Json_writer_struct::Json_writer_struct(Json_writer*)+73> "H\213E\370\306@\030", min_key_flag = 0, max_key_flag = 0, min_key_parts = 876516976, max_key_parts = 32710, key_tree = 0x7fc6343e9560}, {min_key = 0x55b588059eb8 <Json_writer_object::Json_writer_object(Json_writer*, char const*)+40> "H\215\005\201sr\001H\215P\020H\213E\350H\211\020H\213E\350H\213@\bH\205\300\017\225\300\017\266\300H\205\300tJH\203}\330", max_key = 0x8 <error: Cannot access memory at address 0x8>, min_key_flag = 0, max_key_flag = 0, min_key_parts = 0, max_key_parts = 0, key_tree = 0x7fc6343e9670}}, i = 1, at_start = false, is_ror_scan = true}
|
seq_if = {get_key_info = 0x0, init = 0x55b58802970f <sel_arg_range_seq_init(void*, unsigned int, unsigned int)>, next = 0x55b588029998 <sel_arg_range_seq_next(void*, st_key_multi_range*)>, skip_record = 0x0, skip_index_tuple = 0x0}
|
file = 0x7fc5f40f96a0
|
rows = 18446744073709551615
|
keynr = 0
|
_db_stack_frame_ = {func = 0x55b588ecc76c "get_key_scans_params", file = 0x55b588ecb090 "/data/src/10.8/sql/opt_range.cc", level = 2147483660, line = -1, prev = 0x7fc6343e9630}
|
key_alg = HA_KEY_ALG_UNDEF
|
#10 0x000055b58803b449 in get_key_scans_params (param=0x7fc6343e9930, tree=0x7fc5f4b0a078, index_read_must_be_used=false, for_range_access=true, read_time=1.2008298755186722) at /data/src/10.8/sql/opt_range.cc:7489
|
found_read_time = 4.6559850895077059e-310
|
is_ror_scan = false
|
index_scan = 0x7fc6343e9620
|
keynr = 0
|
read_index_only = true
|
trace_idx = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
found_records = 140489256769232
|
cost = {io_count = 0, avg_io_cost = 1, idx_io_count = 0, idx_avg_io_cost = 1, cpu_cost = 0, idx_cpu_cost = 0, import_cost = 0, mem_cost = 0}
|
mrr_flags = 28
|
buf_size = 0
|
key = 0x7fc5f4b0a100
|
idx = 0
|
best_idx = 4093737168
|
key_to_read = 0x0
|
best_records = 140489256769232
|
best_mrr_flags = 1
|
best_buf_size = 4094661216
|
read_plan = 0x0
|
_db_stack_frame_ = {func = 0x55b588ecb7a2 "SQL_SELECT::test_quick_select", file = 0x55b588ecb090 "/data/src/10.8/sql/opt_range.cc", level = 2147483659, line = -1, prev = 0x7fc6343e9810}
|
thd = 0x7fc5f4000db8
|
range_scan_alt = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781230 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
#11 0x000055b58802fbf1 in SQL_SELECT::test_quick_select (this=0x7fc5f4018c40, thd=0x7fc5f4000db8, keys_to_use={buffer = {1}}, 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 /data/src/10.8/sql/opt_range.cc:2936
|
range_trp = 0x0
|
rori_trp = 0x0
|
intersect_trp = 0x0
|
can_build_covering = false
|
trace_range = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
notnull_cond_tree = 0x0
|
max_key_len = 6
|
buff = "\340\f\000\364\305\177\000\000\270\f\000\364\001\000\000\000`\241>4\306\177\000\000\243F\340\210\265U\000\000`\237>4\306\177\000\000\300\241>4\306\177\000\000\n\000\000\000\306\177\000\000\340\f\000\364\305\177\000\000\340\f\000\364\305\177\000\000\270\f\000\364\001\000\000\000\240\241>4\306\177\000\000\243F\340\210\265U\000\000\t\000\000\000\306\177\000\000\020\242>4\000\000\000\000\260\260\354\210\265U\000\000\000\000\000\000\000\000\000\000\260\237>4\306\177\000\000=W\335\210\000\000\001\000\320\237>4\306\177\000\000\061T\340\210\265U\000\000\320\237>4\306\177\000\000\340\f\000\364\305\177\000\000\340\f\000\364\305\177\000\000\270\f\000\364\001\000\000\000\020\242>4\306\177\000\000"...
|
alloc = {free = 0x7fc5f4b0a028, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 4088, block_num = 5, first_block_usage = 0, flags = 0, error_handler = 0x55b588324d83 <sql_alloc_error_handler()>, psi_key = 18}
|
tree = 0x7fc5f4b0a078
|
key_parts = 0x7fc5f4b0a060
|
param = {<RANGE_OPT_PARAM> = {thd = 0x7fc5f4000db8, table = 0x7fc5f40fa7a8, prev_tables = 0, read_tables = 0, current_table = 1, key_parts = 0x7fc5f4b0a040, key_parts_end = 0x7fc5f4b0a060, mem_root = 0x7fc6343e98f0, old_root = 0x7fc5f4006ce0, keys = 1, using_real_indexes = true, remove_jump_scans = true, remove_false_where_parts = true, real_keynr = {0, 0, 4093644000, 32709, 0 <repeats 32 times>, 2297355631, 21941, 0, 0, 876517952, 32710, 2296207165, 65536, 876517984, 32710, 2296402993, 21941, 876517984, 32710, 4093644000, 32709, 4093644000, 32709, 4093643960, 1, 876518064, 0, 4094666968, 32709, 876518112, 16875462, 4094661648, 32709}, min_key = 0x7fc5f4b0a068 "", max_key = 0x7fc5f4b0a070 "", alloced_sel_args = 0, force_default_mrr = false, key = {0x7fc5f4b0a040, 0x69, 0x82d54d19607c500, 0x7fc6343e9b10, 0x55b5880f6279 <update_field_dependencies(THD*, Field*, TABLE*)+344>, 0x7fc6343e9ae0, 0x7fc5f40fa7a8, 0x7fc5f40f9260, 0x7fc5f4000db8, 0x55b588eedfee, 0x55b588eebee8, 0x168b8000000c, 0x7fc6343e9b70, 0x7fc5f40f9228, 0x82d54d19607c500, 0x7fc6343e9ba0, 0x55b5880f706c <find_field_in_table(THD*, TABLE*, char const*, unsigned long, bool, unsigned short*)+707>, 0x7fc5f4016268, 0x550188dd5611, 0x1, 0x7fc5f4016178, 0xf40fa7a8, 0x7fc5f40fa8d8, 0x1, 0x7fc5f40f9410, 0x7fc6343e9ba0, 0x55b58853cea2 <Field::register_field_in_read_map()+144>, 0x7fc5f40faaa8, 0x7fc5f40f9260, 0x7fc5f4045245, 0x7fc5f4002de8, 0x7fc5f40fa7a8, 0x82d54d19607c500, 0x7fc6343e9c90, 0x7fc6371d6319 <rocksdb::Slice::compare(rocksdb::Slice const&) const+143>, 0x7fc6343e9c90, 0x7fc6343e9c80, 0xffffffff00000000, 0x4, 0x7fc6343e9c00, 0x7fc637280ffd <myrocks::Rdb_pk_comparator::Compare(rocksdb::Slice const&, rocksdb::Slice const&) const+39>, 0x7fc6343ea060, 0x7fc6343e9c90, 0x7fc6343e9c80, 0x7fc637a66ef0 <myrocks::Rdb_cf_options::s_pk_comparator>, 0x7fc6343e9c30, 0x7fc6343e9f70, 0x7fc6343e9c30, 0x7fc63742deda <std::allocator<rocksdb::FdWithKeyRange*>::~allocator()+24>, 0x7fc6343e9c40, 0x7fc6343e9f70, 0x7fc6343e9c50, 0x7fc637426cf6 <std::_Vector_base<rocksdb::FdWithKeyRange*, std::allocator<rocksdb::FdWithKeyRange*> >::_Vector_impl::~_Vector_impl()+24>, 0x0, 0x7fc6343e9f70, 0x7fc6343e9c70, 0x7fc63742df28 <std::_Vector_base<rocksdb::FdWithKeyRange*, std::allocator<rocksdb::FdWithKeyRange*> >::~_Vector_base()+74>, 0x0, 0x7fc6343e9f70, 0x7fc6343e9c90, 0x7fc63742df6d <std::vector<rocksdb::FdWithKeyRange*, std::allocator<rocksdb::FdWithKeyRange*> >::~vector()+65>, 0x7fc6343e9da0, 0x7fc6343e9f70, 0x7fc6343e9cb0}}, quick_rows = {18446744073709551615, 94238161339880, 88, 1, 140488179025248, 4, 140489256771648, 140489256771632, 94238225620608, 140489256771920, 94238225375680, 140488179016592, 0, 0, 140488179014272, 0, 140488178929080, 0, 94238225435936, 94238225620672, 0, 140489256770912, 140489256771168, 140489256770992, 13830554455654793216, 140489256771168, 140489256770992, 140488178928864, 4093643960, 94238174657448, 0, 140489256770992, 0, 140489256770992, 0, 0, 140488178928864, 140488178928864, 8388611256, 140489256771600, 94238173841059, 140489256771072, 140489256771712, 140489256771088, 94238174403977, 94238179393046, 140489256771712, 140489256771120, 94238174403291, 140489256771136, 140489256771712, 140489256771152, 140489256771000, 0, 0, 94238179393046, 0, 140489256771200, 281477272917821, 140489256771232, 2296402993, 94238179371757, 0, 140489256771248}, possible_keys = {buffer = {0}}, baseflag = 562967133389966, max_key_parts = 1, range_count = 1, quick = 208, fields_bitmap_size = 4, needed_fields = {bitmap = 0x7fc5f4b0a060, last_word_ptr = 0x7fc5f4b0a060, last_word_mask = 4294967294, n_bits = 1}, tmp_covered_fields = {bitmap = 0x0, last_word_ptr = 0x0, last_word_mask = 876519168, n_bits = 32710}, needed_reg = 0x7fc5f4018de8, imerge_cost_buff = 0x7fc6343e9f20, imerge_cost_buff_size = 0, n_ranges = 21941, first_null_comp = 32 ' '}
|
force_group_by = false
|
trace_idx = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781230 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = true}, <No data fields>}
|
best_read_time = 1.2008298755186722
|
key_info = 0x7fc5f40f93f0
|
idx = 1
|
scan_time = 0.20000000000000001
|
notnull_cond = 0x0
|
best_trp = 0x0
|
backup_keys = 0x7fc6343e9710
|
_db_stack_frame_ = {func = 0x55b588f205ac "get_quick_record_count", file = 0x55b588f1f388 "/data/src/10.8/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7fc6343ea100}
|
__PRETTY_FUNCTION__ = "int SQL_SELECT::test_quick_select(THD*, key_map, table_map, ha_rows, bool, bool, bool, bool)"
|
table_records = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
trace_range = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
#12 0x000055b588212596 in get_quick_record_count (thd=0x7fc5f4000db8, select=0x7fc5f4018c40, table=0x7fc5f40fa7a8, keys=0x7fc5f4017b30, limit=18446744073709551615) at /data/src/10.8/sql/sql_select.cc:5062
|
error = 21941
|
_db_stack_frame_ = {func = 0x55b588f2061b "make_join_statistics", file = 0x55b588f1f388 "/data/src/10.8/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7fc6343ea470}
|
buff = "\340\f\000\364\305\177\000\000\270\f\000\364\305\177\000\000`\241>4\306\177\000\000`H\340\210\265U\000\000[\376\064\211\265U\000\000\340\f\000\364f\001\000\000\240\241>4\306\177\000\000\000\305\a\226\321T-\b\360\241>4\306\177\000\000^=\334\210\265U\000\000\320\001\000\000\000\000\000\000\340l\000\364\305\177\000\000\240\241>4\306\177\000\000=W\335\210\000\000\001\000\320\001\000\000\000\000\000\000\061T\340\210\265U\000\000\300\241>4\306\177\000\000\340\f\000\364\305\177\000\000@\214\001\364\305\177\000\000\320\001\000\000\000\000\000\000\260\260\354\210\265U\000\000\220\260\354\210\265U\000\000\n\000\000\200g\001\000\000`\242>4\306\177\000\000\240\200\001\364\305\177\000\000"...
|
#13 0x000055b588214e96 in make_join_statistics (join=0x7fc5f4016eb8, tables_list=@0x7fc5f40156c0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fc5f4017470, last = 0x7fc5f4017470, elements = 1}, <No data fields>}, keyuse_array=0x7fc5f40171d8) at /data/src/10.8/sql/sql_select.cc:5789
|
is_sargable_cond_of_where = true
|
impossible_range = false
|
records = 18446744073709551615
|
select = 0x7fc5f4018c40
|
sargable_cond = 0x7fc5f4017308
|
rows_estimation_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
rows_estimation = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781230 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
error = 0
|
table = 0x7fc5f40fa7a8
|
i = 1
|
table_count = 1
|
const_count = 0
|
key = 0
|
found_const_table_map = 0
|
all_table_map = 1
|
const_ref = {buffer = {1}}
|
eq_part = {buffer = {1}}
|
has_expensive_keyparts = false
|
table_vector = 0x7fc5f4017f58
|
stat = 0x7fc5f40179b0
|
stat_end = 0x7fc5f4017d60
|
s = 0x7fc5f40179b0
|
stat_ref = 0x7fc5f4017d60
|
stat_vector = 0x7fc5f4017f48
|
keyuse = 0x7fc5f40185b8
|
start_keyuse = 0x7fc5f4018560
|
outer_join = 0
|
no_rows_const_tables = 0
|
sargables = 0x7fc5f4018550
|
ti = {<base_list_iterator> = {list = 0x7fc5f40156c0, el = 0x55b589ae60c0 <end_of_list>, prev = 0x7fc5f4017470, current = 0x55b589ae60c0 <end_of_list>}, <No data fields>}
|
tables = 0x0
|
thd = 0x7fc5f4000db8
|
_db_stack_frame_ = {func = 0x55b588f1fafd "JOIN::optimize_inner", file = 0x55b588f1f388 "/data/src/10.8/sql/sql_select.cc", level = 2147483656, line = -1, prev = 0x7fc6343ea5c0}
|
ref_changed = 0
|
__PRETTY_FUNCTION__ = "bool make_join_statistics(JOIN*, List<TABLE_LIST>&, DYNAMIC_ARRAY*)"
|
#14 0x000055b588209035 in JOIN::optimize_inner (this=0x7fc5f4016eb8) at /data/src/10.8/sql/sql_select.cc:2477
|
_db_stack_frame_ = {func = 0x55b588f2059f "mysql_select", file = 0x55b588f1f388 "/data/src/10.8/sql/sql_select.cc", level = 2147483655, line = -1, prev = 0x7fc6343ea720}
|
trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781250 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b589781230 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
sel = 0x7fc5f40154a8
|
eq_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b589ae60c0 <end_of_list>, last = 0x7fc6343ea5a0, elements = 0}, <No data fields>}
|
ignore_on_expr = false
|
__PRETTY_FUNCTION__ = "int JOIN::optimize_inner()"
|
#15 0x000055b5882068ff in JOIN::optimize (this=0x7fc5f4016eb8) at /data/src/10.8/sql/sql_select.cc:1819
|
res = 0
|
init_state = JOIN::NOT_OPTIMIZED
|
#16 0x000055b588212281 in mysql_select (thd=0x7fc5f4000db8, tables=0x7fc5f4015a80, fields=@0x7fc5f4015748: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fc5f4015a38, last = 0x7fc5f4015a38, elements = 1}, <No data fields>}, conds=0x7fc5f4016318, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fc5f4016e90, unit=0x7fc5f40051c8, select_lex=0x7fc5f40154a8) at /data/src/10.8/sql/sql_select.cc:5004
|
err = 0
|
free_join = true
|
_db_stack_frame_ = {func = 0x55b588f1f470 "handle_select", file = 0x55b588f1f388 "/data/src/10.8/sql/sql_select.cc", level = 2147483654, line = -1, prev = 0x7fc6343ea7e0}
|
join = 0x7fc5f4016eb8
|
#17 0x000055b588201631 in handle_select (thd=0x7fc5f4000db8, lex=0x7fc5f40050f0, result=0x7fc5f4016e90, setup_tables_done_option=0) at /data/src/10.8/sql/sql_select.cc:552
|
unit = 0x7fc5f40051c8
|
res = false
|
select_lex = 0x7fc5f40154a8
|
_db_stack_frame_ = {func = 0x55b588f0ba60 "mysql_execute_command", file = 0x55b588f0ad38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7fc6343eae30}
|
#18 0x000055b5881aa35f in execute_sqlcom_select (thd=0x7fc5f4000db8, all_tables=0x7fc5f4015a80) at /data/src/10.8/sql/sql_parse.cc:6252
|
save_protocol = 0x0
|
lex = 0x7fc5f40050f0
|
result = 0x7fc5f4016e90
|
res = false
|
__PRETTY_FUNCTION__ = "bool execute_sqlcom_select(THD*, TABLE_LIST*)"
|
#19 0x000055b5881a1684 in mysql_execute_command (thd=0x7fc5f4000db8, is_called_from_prepared_stmt=false) at /data/src/10.8/sql/sql_parse.cc:3943
|
privileges_requested = SELECT_ACL
|
res = 0
|
up_result = 0
|
lex = 0x7fc5f40050f0
|
select_lex = 0x7fc5f40154a8
|
first_table = 0x7fc5f4015a80
|
all_tables = 0x7fc5f4015a80
|
unit = 0x7fc5f40051c8
|
have_table_map_for_update = false
|
rpl_filter = 0x0
|
_db_stack_frame_ = {func = 0x55b588f0cdef "mysql_parse", file = 0x55b588f0ad38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7fc6343eb240}
|
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
|
ots = {ctx = 0x7fc5f4004d88, traceable = false}
|
orig_binlog_format = BINLOG_FORMAT_MIXED
|
orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
|
#20 0x000055b5881af0d1 in mysql_parse (thd=0x7fc5f4000db8, rawbuf=0x7fc5f4015410 "SELECT * FROM t WHERE i = 107", length=29, parser_state=0x7fc6343eb3c0) at /data/src/10.8/sql/sql_parse.cc:8027
|
found_semicolon = 0x0
|
error = 32709
|
lex = 0x7fc5f40050f0
|
err = false
|
_db_stack_frame_ = {func = 0x55b588f0b2b1 "dispatch_command", file = 0x55b588f0ad38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7fc6343eb3a0}
|
__PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)"
|
#21 0x000055b58819b75a in dispatch_command (command=COM_QUERY, thd=0x7fc5f4000db8, packet=0x7fc5f400b999 "SELECT * FROM t WHERE i = 107", packet_length=29, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1894
|
packet_end = 0x7fc5f401542d ""
|
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7fc5f4000db8, m_ptr = 0x7fc5f401542e "\004", m_tok_start = 0x7fc5f401542e "\004", m_tok_end = 0x7fc5f401542e "\004", m_end_of_query = 0x7fc5f401542d "", m_tok_start_prev = 0x7fc5f401542d "", m_buf = 0x7fc5f4015410 "SELECT * FROM t WHERE i = 107", m_buf_length = 29, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7fc5f4015488 "SELECT * FROM t WHERE i = 107", m_cpp_ptr = 0x7fc5f40154a5 "", m_cpp_tok_start = 0x7fc5f40154a5 "", m_cpp_tok_start_prev = 0x7fc5f40154a5 "", m_cpp_tok_end = 0x7fc5f40154a5 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x1f4000cb8 <error: Cannot access memory at address 0x1f4000cb8>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (unknown: 0x10000), m_cpp_text_start = 0x7fc5f40154a2 "107", m_cpp_text_end = 0x7fc5f40154a5 "", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7fc5f4004b18}
|
net = 0x7fc5f40010f0
|
error = false
|
do_end_of_statement = true
|
_db_stack_frame_ = {func = 0x55b588f0af35 "do_command", file = 0x55b588f0ad38 "/data/src/10.8/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7fc6343ebc80}
|
drop_more_results = false
|
__PRETTY_FUNCTION__ = "dispatch_command_return dispatch_command(enum_server_command, THD*, char*, uint, bool)"
|
__FUNCTION__ = "dispatch_command"
|
res = <optimized out>
|
#22 0x000055b58819a155 in do_command (thd=0x7fc5f4000db8, blocking=true) at /data/src/10.8/sql/sql_parse.cc:1407
|
return_value = DISPATCH_COMMAND_SUCCESS
|
packet = 0x7fc5f400b998 "\003SELECT * FROM t WHERE i = 107"
|
packet_length = 30
|
net = 0x7fc5f40010f0
|
command = COM_QUERY
|
_db_stack_frame_ = {func = 0x55b589358380 "?func", file = 0x55b589358386 "?file", level = 2147483649, line = -1, prev = 0x0}
|
__PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
|
__FUNCTION__ = "do_command"
|
#23 0x000055b58836dbe4 in do_handle_one_connection (connect=0x55b58c4d9fc8, put_in_cache=true) at /data/src/10.8/sql/sql_connect.cc:1418
|
create_user = true
|
thr_create_utime = 3553352767181
|
thd = 0x7fc5f4000db8
|
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
|
#24 0x000055b58836d883 in handle_one_connection (arg=0x55b58c4c79e8) at /data/src/10.8/sql/sql_connect.cc:1312
|
connect = 0x55b58c4c79e8
|
#25 0x000055b588864f2e in pfs_spawn_thread (arg=0x55b58c4d9b28) at /data/src/10.8/storage/perfschema/pfs.cc:2201
|
typed_arg = 0x55b58c4d9b28
|
user_arg = 0x55b58c4c79e8
|
user_start_routine = 0x55b58836d828 <handle_one_connection(void*)>
|
pfs = 0x7fc63b6a8880
|
klass = 0x55b58bda2e80
|
#26 0x00007fc63c27aea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
ret = <optimized out>
|
pd = <optimized out>
|
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140489256781568, -8583741291031081972, 140724663656398, 140724663656399, 140489256779328, 311296, 8605258190197443596, 8605275567121976332}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
|
not_first_call = 0
|
#27 0x00007fc63be79def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
|
Attachments
Issue Links
- is caused by
-
MDEV-13756 Implement descending index: KEY (a DESC, b ASC)
-
- Closed
-