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

Assertion `!(start_key == __null && end_key == __null)' failed in ha_federatedx::read_range_first or ha_federated::read_range_first

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t1 (c CHAR(255) NOT NULL DEFAULT '', KEY(c(8)));
       
      INSTALL SONAME 'ha_federatedx';
      eval CREATE TABLE fed_t1 ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1';
      SELECT * FROM fed_t1 WHERE c NOT IN ('USA', 'CAN');
       
      # Cleanup
      DROP TABLE fed_t1, t1;
      UNINSTALL SONAME 'ha_federatedx';
      

      10.1 db3bdca7c2982a

      mysqld: /data/src/10.1/storage/federatedx/ha_federatedx.cc:2674: virtual int ha_federatedx::read_range_first(const key_range*, const key_range*, bool, bool): Assertion `!(start_key == __null && end_key == __null)' failed.
      180108 14:29:12 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8f5189cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00007f8f4b9eefe9 in ha_federatedx::read_range_first (this=0x7f8f48caf888, start_key=0x0, end_key=0x0, eq_range_arg=false, sorted=true) at /data/src/10.1/storage/federatedx/ha_federatedx.cc:2674
      #9  0x000055984f64eb4e in handler::multi_range_read_next (this=0x7f8f48caf888, range_info=0x7f8f5391f148) at /data/src/10.1/sql/multi_range_read.cc:290
      #10 0x000055984f8446da in QUICK_RANGE_SELECT::get_next (this=0x7f8f48d3f280) at /data/src/10.1/sql/opt_range.cc:11218
      #11 0x000055984f8548e1 in rr_quick (info=0x7f8f48c45900) at /data/src/10.1/sql/records.cc:350
      #12 0x000055984f53e09d in join_init_read_record (tab=0x7f8f48c45840) at /data/src/10.1/sql/sql_select.cc:19323
      #13 0x000055984f53bfa5 in sub_select (join=0x7f8f48c43d40, join_tab=0x7f8f48c45840, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18410
      #14 0x000055984f53b86a in do_select (join=0x7f8f48c43d40, fields=0x7f8f4a8d9388, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18068
      #15 0x000055984f51621e in JOIN::exec_inner (this=0x7f8f48c43d40) at /data/src/10.1/sql/sql_select.cc:3225
      #16 0x000055984f5134af in JOIN::exec (this=0x7f8f48c43d40) at /data/src/10.1/sql/sql_select.cc:2512
      #17 0x000055984f516a45 in mysql_select (thd=0x7f8f4a8d5070, rref_pointer_array=0x7f8f4a8d9518, tables=0x7f8f48c432a0, wild_num=1, fields=..., conds=0x7f8f48c43b18, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8f48c43d20, unit=0x7f8f4a8d8b70, select_lex=0x7f8f4a8d9270) at /data/src/10.1/sql/sql_select.cc:3449
      #18 0x000055984f50c44e in handle_select (thd=0x7f8f4a8d5070, lex=0x7f8f4a8d8aa8, result=0x7f8f48c43d20, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
      #19 0x000055984f4dc4e8 in execute_sqlcom_select (thd=0x7f8f4a8d5070, all_tables=0x7f8f48c432a0) at /data/src/10.1/sql/sql_parse.cc:5926
      #20 0x000055984f4d29be in mysql_execute_command (thd=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_parse.cc:2976
      #21 0x000055984f4dfbf5 in mysql_parse (thd=0x7f8f4a8d5070, rawbuf=0x7f8f48c43088 "SELECT * FROM fed_t1 WHERE c NOT IN ('USA', 'CAN')", length=50, parser_state=0x7f8f539205e0) at /data/src/10.1/sql/sql_parse.cc:7347
      #22 0x000055984f4ceaba in dispatch_command (command=COM_QUERY, thd=0x7f8f4a8d5070, packet=0x7f8f4d3f9071 "", packet_length=50) at /data/src/10.1/sql/sql_parse.cc:1477
      #23 0x000055984f4cd83f in do_command (thd=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_parse.cc:1106
      #24 0x000055984f606325 in do_handle_one_connection (thd_arg=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_connect.cc:1330
      #25 0x000055984f606089 in handle_one_connection (arg=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_connect.cc:1242
      #26 0x000055984f9c075a in pfs_spawn_thread (arg=0x7f8f51039ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1861
      #27 0x00007f8f535a0494 in start_thread (arg=0x7f8f53921b00) at pthread_create.c:333
      #28 0x00007f8f5195993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible with at least MyISAM and InnoDB for the "remote" table.

        Attachments

          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: