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

Assisted discovery of table with application period fails, server crashes

    XMLWordPrintable

    Details

      Description

      Note: same crash as in MDEV-17227, but in a very different scenario.

      create table t1 (a int, s date, e date, period for se(s,e));
      install soname 'ha_federatedx';
      eval create table t2 engine=federated connection="mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1";
      

      10.4 503fd211

      #3  <signal handler called>
      #4  0x000056204cdeafd0 in TABLE_SHARE::init_from_sql_statement_string (this=0x7f58ec459dd0, thd=0x7f58dc000af0, write=true, sql=0x7f58ec4593e0 "CREATE TABLE `t1` (\n  `a` int(11) DEFAULT NULL,\n  `s` date NOT NULL,\n  `e` date NOT NULL,\n  PERIOD FOR `se` (`s`, `e`)\n) CONNECTION='mysql://root@127.0.0.1:16000/test/t1'", sql_length=170) at /data/src/10.4/sql/table.cc:3185
      #5  0x00007f58ec1ff930 in ha_federatedx::discover_assisted (hton=0x7f58dc12fee0, thd=0x7f58dc000af0, table_s=0x7f58ec459dd0, info=0x7f58ec45a9b0) at /data/src/10.4/storage/federatedx/ha_federatedx.cc:3668
      #6  0x000056204cda429c in create_table_impl (thd=0x7f58dc000af0, orig_db=..., orig_table_name=..., db=..., table_name=..., path=0x7f58ec45a570 "./test/t2", options=..., create_info=0x7f58ec45a9b0, alter_info=0x7f58ec45a8f0, create_table_mode=-3, is_trans=0x7f58ec45a7ce, key_info=0x7f58ec45a550, key_count=0x7f58ec45a544, frm=0x7f58ec45a560) at /data/src/10.4/sql/sql_table.cc:5030
      #7  0x000056204cda487f in mysql_create_table_no_lock (thd=0x7f58dc000af0, db=0x7f58dc013320, table_name=0x7f58dc013330, create_info=0x7f58ec45a9b0, alter_info=0x7f58ec45a8f0, is_trans=0x7f58ec45a7ce, create_table_mode=-3, table_list=0x7f58dc013308) at /data/src/10.4/sql/sql_table.cc:5157
      #8  0x000056204cda4c81 in mysql_create_table (thd=0x7f58dc000af0, create_table=0x7f58dc013308, create_info=0x7f58ec45a9b0, alter_info=0x7f58ec45a8f0) at /data/src/10.4/sql/sql_table.cc:5246
      #9  0x000056204cdb700c in Sql_cmd_create_table_like::execute (this=0x7f58dc0132a8, thd=0x7f58dc000af0) at /data/src/10.4/sql/sql_table.cc:11462
      #10 0x000056204ccc942e in mysql_execute_command (thd=0x7f58dc000af0) at /data/src/10.4/sql/sql_parse.cc:6101
      #11 0x000056204ccce8f3 in mysql_parse (thd=0x7f58dc000af0, rawbuf=0x7f58dc013198 "create table t2 engine=federated connection=\"mysql://root@127.0.0.1:16000/test/t1\"", length=82, parser_state=0x7f58ec45b570, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7900
      #12 0x000056204ccbaea3 in dispatch_command (command=COM_QUERY, thd=0x7f58dc000af0, packet=0x7f58dc136211 "create table t2 engine=federated connection=\"mysql://root@127.0.0.1:16000/test/t1\"", packet_length=82, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
      #13 0x000056204ccb9645 in do_command (thd=0x7f58dc000af0) at /data/src/10.4/sql/sql_parse.cc:1360
      #14 0x000056204ce410e0 in do_handle_one_connection (connect=0x56204fc86cc0) at /data/src/10.4/sql/sql_connect.cc:1412
      #15 0x000056204ce40e2f in handle_one_connection (arg=0x56204fc86cc0) at /data/src/10.4/sql/sql_connect.cc:1316
      #16 0x000056204d83f17f in pfs_spawn_thread (arg=0x56204fbf54f0) at /data/src/10.4/storage/perfschema/pfs.cc:1869
      #17 0x00007f58f423a4a4 in start_thread (arg=0x7f58ec45c700) at pthread_create.c:456
      #18 0x00007f58f236ed0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Reproducible on 10.4+, debug and non-debug alike.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              nikitamalyavin Nikita Malyavin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: