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

LP:671361 - virtual int Mrr_ordered_index_reader::refill_buffer(): Assertion `!know_key_tuple_params || key_buffer->is_empty()' failed in maria-5.3-mwl128-dsmrr-cpk

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      The following query:

      SELECT table2.col_varchar_10_latin1_key
      FROM t1 AS table1 JOIN t2 AS table2 ON table1.col_varchar_1024_latin1_key = table2.col_varchar_10_latin1
      WHERE table2.col_varchar_10_utf8 OR table1.pk ;

      asserted as follows in maria-5.3-mwl128-dsmrr-cpk. maria-5.3-dsmrr-cpk is not affected

      mysqld: multi_range_read.cc:405: virtual int Mrr_ordered_index_reader::refill_buffer(): Assertion `!know_key_tuple_params || key_buffer->is_empty()' failed.

      #8 0x00133d98 in __assert_fail () from /lib/libc.so.6
      #9 0x084a2edd in Mrr_ordered_index_reader::refill_buffer (this=0xae6f29ac) at multi_range_read.cc:405
      #10 0x084a33f2 in Mrr_ordered_rndpos_reader::refill_buffer (this=0xae6f2984) at multi_range_read.cc:527
      #11 0x084a3da4 in DsMrr_impl::dsmrr_init (this=0xae6f2968, h_arg=0xae6f25e8, seq_funcs=0xae743c6c, seq_init_param=0xae743b80, n_ranges=1, mode=129,
      buf=0xae743c84) at multi_range_read.cc:789
      #12 0x08566aa3 in ha_maria::multi_range_read_init (this=0xae6f25e8, seq=0xae743c6c, seq_init_param=0xae743b80, n_ranges=1, mode=129, buf=0xae743c84)
      at ha_maria.cc:3615
      #13 0x082e1541 in JOIN_TAB_SCAN_MRR::open (this=0xae743c58) at sql_join_cache.cc:3500
      #14 0x082df994 in JOIN_CACHE::join_matching_records (this=0xae743b80, skip_last=false) at sql_join_cache.cc:2085
      #15 0x082df652 in JOIN_CACHE::join_records (this=0xae743b80, skip_last=false) at sql_join_cache.cc:1927
      #16 0x08327178 in sub_select_cache (join=0xae748f58, join_tab=0xae64f404, end_of_records=false) at sql_select.cc:13178
      #17 0x08327abb in evaluate_join_record (join=0xae748f58, join_tab=0xae64f230, error=0) at sql_select.cc:13565
      #18 0x08327447 in sub_select (join=0xae748f58, join_tab=0xae64f230, end_of_records=false) at sql_select.cc:13370
      #19 0x0832686c in do_select (join=0xae748f58, fields=0x9d82678, table=0x0, procedure=0x0) at sql_select.cc:12914
      #20 0x0830c405 in JOIN::exec (this=0xae748f58) at sql_select.cc:2382
      #21 0x0830cb6b in mysql_select (thd=0x9d80c48, rref_pointer_array=0x9d82700, tables=0xae743e88, wild_num=0, fields=..., conds=0xae744180, og_num=0,
      order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xae744d88, unit=0x9d82334, select_lex=0x9d825d8)
      at sql_select.cc:2592
      #22 0x083051a1 in handle_select (thd=0x9d80c48, lex=0x9d822d4, result=0xae744d88, setup_tables_done_option=0) at sql_select.cc:284
      #23 0x082a130f in execute_sqlcom_select (thd=0x9d80c48, all_tables=0xae743e88) at sql_parse.cc:5102
      #24 0x08297e0f in mysql_execute_command (thd=0x9d80c48) at sql_parse.cc:2281
      #25 0x082a3880 in mysql_parse (thd=0x9d80c48,
      rawbuf=0xae65f2d0 "SELECT table2.col_varchar_10_latin1_key\nFROM t1 AS table1 JOIN t2 AS table2 ON table1.col_varchar_1024_latin1_key = table2.col_varchar_10_latin1\nWHERE table2.col_varchar_10_utf8 OR table1.pk", length=190, found_semicolon=0xae9a0228) at sql_parse.cc:6109
      #26 0x0829597c in dispatch_command (command=COM_QUERY, thd=0x9d80c48, packet=0x9d82cb9 "", packet_length=191) at sql_parse.cc:1209
      #27 0x08294e2e in do_command (thd=0x9d80c48) at sql_parse.cc:902
      #28 0x08291de4 in handle_one_connection (arg=0x9d80c48) at sql_connect.cc:1154
      #29 0x00bea919 in start_thread () from /lib/libpthread.so.0
      #30 0x001edcbe in clone () from /lib/libc.so.6

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.