Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-308

LP:1008516 - Failing assertion: templ->mysql_col_len == len

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5.24, 5.3.7
    • Fix Version/s: 5.5.25, 5.3.8
    • Component/s: None
    • Labels:
      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

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: