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

Server crashes in spider_mysql_handler::append_match_against on SELECT .. MATCH .. AGAINST .. BOOLEAN MODE

    XMLWordPrintable

Details

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

    Description

      #3  <signal handler called>
      #4  0x00007fa0aababc9c in spider_mysql_handler::append_match_against (this=0x7fa09c06d890, str=0x7fa09c06d8d0, ft_info=0x7fa09c0765d8, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6595
      #5  0x00007fa0aabac2fe in spider_mysql_handler::append_match_select (this=0x7fa09c06d890, str=0x7fa09c06d8d0, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6693
      #6  0x00007fa0aabac225 in spider_mysql_handler::append_match_select_part (this=0x7fa09c06d890, sql_type=1, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6676
      #7  0x00007fa0aab8f720 in ha_spider::append_match_select_sql_part (this=0x7fa09c068c00, sql_type=1, alias=0x0, alias_length=0) at 10.0/storage/spider/ha_spider.cc:12532
      #8  0x00007fa0aab06a41 in spider_db_append_select_columns (spider=0x7fa09c068c00) at 10.0/storage/spider/spd_db_conn.cc:1334
      #9  0x00007fa0aab80206 in ha_spider::rnd_next_internal (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/storage/spider/ha_spider.cc:6833
      #10 0x00007fa0aab8128a in ha_spider::rnd_next (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/storage/spider/ha_spider.cc:7104
      #11 0x000000000080859f in handler::ha_rnd_next (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/sql/handler.cc:2441
      #12 0x0000000000935b35 in rr_sequential (info=0x7fa09c075bd0) at 10.0/sql/records.cc:458
      #13 0x0000000000683b16 in join_init_read_record (tab=0x7fa09c075b20) at 10.0/sql/sql_select.cc:17661
      #14 0x0000000000681b7e in sub_select (join=0x7fa09c0743d0, join_tab=0x7fa09c075b20, end_of_records=false) at 10.0/sql/sql_select.cc:16773
      #15 0x0000000000681499 in do_select (join=0x7fa09c0743d0, fields=0x240a5c0, table=0x0, procedure=0x0) at 10.0/sql/sql_select.cc:16446
      #16 0x00000000006601f4 in JOIN::exec_inner (this=0x7fa09c0743d0) at 10.0/sql/sql_select.cc:2993
      #17 0x000000000065d4a1 in JOIN::exec (this=0x7fa09c0743d0) at 10.0/sql/sql_select.cc:2291
      #18 0x0000000000660a98 in mysql_select (thd=0x24063a8, rref_pointer_array=0x240a758, tables=0x7fa09c06eda0, wild_num=1, fields=..., conds=0x7fa09c06f4d0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa09c04f390, unit=0x2409db0, select_lex=0x240a4a8) at 10.0/sql/sql_select.cc:3221
      #19 0x00000000006571fb in handle_select (thd=0x24063a8, lex=0x2409cf8, result=0x7fa09c04f390, setup_tables_done_option=0) at 10.0/sql/sql_select.cc:371
      #20 0x000000000062adc1 in execute_sqlcom_select (thd=0x24063a8, all_tables=0x7fa09c06eda0) at 10.0/sql/sql_parse.cc:5043
      #21 0x0000000000623381 in mysql_execute_command (thd=0x24063a8) at 10.0/sql/sql_parse.cc:2483
      #22 0x000000000062d680 in mysql_parse (thd=0x24063a8, rawbuf=0x7fa09c027cc0 "SELECT * FROM t1 WHERE MATCH(v2) AGAINST ('abc' IN BOOLEAN MODE)", length=64, parser_state=0x7fa0b80ec500) at 10.0/sql/sql_parse.cc:6176
      #23 0x0000000000620556 in dispatch_command (command=COM_QUERY, thd=0x24063a8, packet=0x240b5a9 "", packet_length=64) at 10.0/sql/sql_parse.cc:1274
      #24 0x000000000061f9cc in do_command (thd=0x24063a8) at 10.0/sql/sql_parse.cc:983
      #25 0x000000000073d820 in do_handle_one_connection (thd_arg=0x24063a8) at 10.0/sql/sql_connect.cc:1267
      #26 0x000000000073d573 in handle_one_connection (arg=0x24063a8) at 10.0/sql/sql_connect.cc:1181
      #27 0x00000000009d32b4 in pfs_spawn_thread (arg=0x227aeb8) at 10.0/storage/perfschema/pfs.cc:1800
      #28 0x00007fa0bd220e9a in start_thread (arg=0x7fa0b80ed700) at pthread_create.c:308
      #29 0x00007fa0bc2fecbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      bzr version-info

      revision-id: svoj@mariadb.org-20130627111848-b8kc0z60ywwpqavz
      revno: 3762
      branch-nick: 10.0

      Test case:

      	CREATE TABLE mysql.spider_tables(
       db_name char(64) not null default '',
       table_name char(64) not null default '',
       link_id int not null default 0,
       priority bigint not null default 0,
       server char(64) default null,
       scheme char(64) default null,
       host char(64) default null,
       port char(5) default null,
       socket text default null,
       username char(64) default null,
       password char(64) default null,
       ssl_ca text default null,
       ssl_capath text default null,
       ssl_cert text default null,
       ssl_cipher char(64) default null,
       ssl_key text default null,
       ssl_verify_server_cert tinyint not null default 0,
       default_file text default null,
       default_group char(64) default null,
       tgt_db_name char(64) default null,
       tgt_table_name char(64) default null,
       link_status tinyint not null default 1,
       PRIMARY KEY (db_name, table_name, link_id),
       KEY idx1 (priority)
       ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
       
      install soname 'ha_spider.so';
      create database remote;
       
      CREATE TABLE remote.t1 (
       v2 TEXT
      ) ENGINE=MyISAM;
       
      eval CREATE TABLE t1 (
       v2 TEXT
      ) ENGINE=SPIDER CONNECTION='host "localhost", socket "$MASTER_MYSOCK", user "root", password "", prt "2000000"' COMMENT='database "remote", table "t1"';
      INSERT INTO t1 VALUES ('foo'),('bar');
       
      SELECT * FROM t1 WHERE MATCH(v2) AGAINST ('abc' IN BOOLEAN MODE);

      Attachments

        Issue Links

          Activity

            People

              svoj Sergey Vojtovich
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.