Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.24, 5.3.7
-
None
-
None
Description
https://bugs.launchpad.net/maria/+bug/1008516
Reproducible on maria-5.5 with XtraDB.
Could not reproduce on maria-5.3, percona-server, mysql-5.5, and on maria-5.5 with InnoDB plugin, but possibly only because in all these cases a different plan is chosen (5.5 with XtraDB says 'Using index condition', others don't).
Comments in http://bugs.mysql.com/bug.php?id=58015 say that the assertion is bogus, so it's just a debug nuisance.
Shane Bester wrote:
Reminds me of an old bug:
http://bugs.mysql.com/bug.php?id=58015
(Assert in row_sel_field_store_in_mysql_format when running innodb_mrr_icp test)
How to repeat:
-----------------
might have to use debug build
repeatable with 5.5.24-MariaDB-valgrind-max-debug on linux x64
drop table if exists `t1`;
|
create table `t1` (`a` int,`b` char(5),primary key (`a`), key (`b`(1))) engine=innodb ;
|
insert into `t1` values ('a','b');
|
select 1 from `t1` where `a` and `b` >= 'aa';
|
InnoDB: Assertion failure in thread X in file row0sel.c line 2681
|
InnoDB: Failing assertion: templ->mysql_col_len == len
|
 |
Program received signal SIGABRT, Aborted.
|
[Switching to Thread 0x7ffff42d3700 (LWP 30861)]
|
in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
|
64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
|
(gdb) bt
|
#0 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
|
#1 in abort () at abort.c:92
|
#2 in row_sel_field_store_in_mysql_format at ./maria-5.5/storage/xtradb/row/row0sel.c:2681
|
#3 in row_sel_store_mysql_field at ./maria-5.5/storage/xtradb/row/row0sel.c:2810
|
#4 in row_search_idx_cond_check at ./maria-5.5/storage/xtradb/row/row0sel.c:3436
|
#5 in row_search_for_mysql at ./maria-5.5/storage/xtradb/row/row0sel.c:4619
|
#6 in ha_innobase::index_read at ./maria-5.5/storage/xtradb/handler/ha_innodb.cc:6562
|
#7 in handler::index_read_map at ./maria-5.5/sql/handler.h:2105
|
#8 in handler::ha_index_read_map at ./maria-5.5/sql/sql_class.h:4146
|
#9 in handler::read_range_first at ./maria-5.5/sql/handler.cc:4544
|
#10 in handler::multi_range_read_next at ./maria-5.5/sql/multi_range_read.cc:296
|
#11 in Mrr_simple_index_reader::get_next at ./maria-5.5/sql/multi_range_read.cc:328
|
#12 in DsMrr_impl::dsmrr_next at ./maria-5.5/sql/multi_range_read.cc:1391
|
#13 in ha_innobase::multi_range_read_next at ./maria-5.5/storage/xtradb/handler/ha_innodb.cc:13084
|
#14 in QUICK_RANGE_SELECT::get_next at ./maria-5.5/sql/opt_range.cc:10966
|
#15 in rr_quick at ./maria-5.5/sql/records.cc:339
|
#16 in join_init_read_record at ./maria-5.5/sql/sql_select.cc:16854
|
#17 in sub_select at ./maria-5.5/sql/sql_select.cc:16000
|
#18 in do_select at ./maria-5.5/sql/sql_select.cc:15673
|
#19 in JOIN::exec at ./maria-5.5/sql/sql_select.cc:2794
|
#20 in mysql_select at ./maria-5.5/sql/sql_select.cc:3014
|
#21 in handle_select at ./maria-5.5/sql/sql_select.cc:311
|
#22 in execute_sqlcom_select at ./maria-5.5/sql/sql_parse.cc:4616
|
#23 in mysql_execute_command (thd=0x30749f0) at ./maria-5.5/sql/sql_parse.cc:2184
|
#24 in mysql_parse at ./maria-5.5/sql/sql_parse.cc:5731
|
#25 in dispatch_command at ./maria-5.5/sql/sql_parse.cc:1055
|
#26 in do_command at ./maria-5.5/sql/sql_parse.cc:794
|
#27 in do_handle_one_connection at ./maria-5.5/sql/sql_connect.cc:1253
|
#28 in handle_one_connection at ./maria-5.5/sql/sql_connect.cc:1168
|
#29 in start_thread at pthread_create.c:301
|
#30 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-