[MDEV-709] LP:1008516 - Failing assertion: templ->mysql_col_len == len Created: 2012-06-04  Updated: 2013-01-01  Resolved: 2013-01-01

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

Type: Bug Priority: Minor
Reporter: sbester Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1008516.xml    
Issue Links:
Duplicate
is duplicated by MDEV-308 LP:1008516 - Failing assertion: templ... Closed

 Description   

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

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';



 Comments   
Comment by Elena Stepanova [ 2012-06-04 ]

Re: Failing assertion: templ->mysql_col_len == len
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.

Comment by Elena Stepanova [ 2012-06-04 ]

Re: Failing assertion: templ->mysql_col_len == len
Also filed in JIRA as https://mariadb.atlassian.net/browse/MDEV-308

Comment by Rasmus Johansson (Inactive) [ 2012-06-04 ]

Launchpad bug id: 1008516

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