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

[Draft] Server crashes in PlugCleanup / PopUser / ha_connect::~ha_connect

    XMLWordPrintable

Details

    Description

      3bb32e8682f849413ce994277e9029ba5732baae

      # 2017-04-22T00:25:13 [9479] #3  <signal handler called>
      # 2017-04-22T00:25:13 [9479] #4  0x00007ff1e152643b in PlugCleanup (g=0x0, dofree=true) at /data/src/10.1/storage/connect/plgdbutl.cpp:966
      # 2017-04-22T00:25:13 [9479] #5  0x00007ff1e14d13a3 in PopUser (xp=0x7ff1a2c140e0) at /data/src/10.1/storage/connect/ha_connect.cc:865
      # 2017-04-22T00:25:13 [9479] #6  0x00007ff1e14d122e in ha_connect::~ha_connect (this=0x7ff1a2880688, __in_chrg=<optimized out>) at /data/src/10.1/storage/connect/ha_connect.cc:835
      # 2017-04-22T00:25:13 [9479] #7  0x00007ff1e14d12b8 in ha_connect::~ha_connect (this=0x7ff1a2880688, __in_chrg=<optimized out>) at /data/src/10.1/storage/connect/ha_connect.cc:836
      # 2017-04-22T00:25:13 [9479] #8  0x00007ff1e54893ec in open_table_from_share (thd=0x7ff1bef48070, share=0x7ff1a709b488, alias=0x7ff1b5c4f238 "t4", db_stat=39, prgflag=44, ha_open_flags=18, outparam=0x7ff1a70abe70, is_create_table=false) at /data/src/10.1/sql/table.cc:2984
      # 2017-04-22T00:25:13 [9479] #9  0x00007ff1e5330af6 in open_table (thd=0x7ff1bef48070, table_list=0x7ff1b5c4f240, ot_ctx=0x7ff1e623c680) at /data/src/10.1/sql/sql_base.cc:2552
      # 2017-04-22T00:25:13 [9479] #10 0x00007ff1e537f112 in create_table_from_items (thd=0x7ff1bef48070, create_info=0x7ff1e623ddb0, create_table=0x7ff1b5c4f240, alter_info=0x7ff1e623dd20, items=0x7ff1bef4c2d0, lock=0x7ff1e623d7a8, hooks=0x7ff1e623d7e0) at /data/src/10.1/sql/sql_insert.cc:4104
      # 2017-04-22T00:25:13 [9479] #11 0x00007ff1e537f6d7 in select_create::prepare (this=0x7ff1b5c4fe60, values=..., u=0x7ff1bef4bab8) at /data/src/10.1/sql/sql_insert.cc:4255
      # 2017-04-22T00:25:13 [9479] #12 0x00007ff1e53d411e in JOIN::prepare (this=0x7ff1b5c4ff48, rref_pointer_array=0x7ff1bef4c430, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7ff1bef4c1b8, unit_arg=0x7ff1bef4bab8) at /data/src/10.1/sql/sql_select.cc:984
      # 2017-04-22T00:25:13 [9479] #13 0x00007ff1e53dc987 in mysql_select (thd=0x7ff1bef48070, rref_pointer_array=0x7ff1bef4c430, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416216832, result=0x7ff1b5c4fe60, unit=0x7ff1bef4bab8, select_lex=0x7ff1bef4c1b8) at /data/src/10.1/sql/sql_select.cc:3423
      # 2017-04-22T00:25:13 [9479] #14 0x00007ff1e53d2496 in handle_select (thd=0x7ff1bef48070, lex=0x7ff1bef4b9f0, result=0x7ff1b5c4fe60, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
      # 2017-04-22T00:25:13 [9479] #15 0x00007ff1e5399b27 in mysql_execute_command (thd=0x7ff1bef48070) at /data/src/10.1/sql/sql_parse.cc:3442
      # 2017-04-22T00:25:13 [9479] #16 0x00007ff1e53a5b19 in mysql_parse (thd=0x7ff1bef48070, rawbuf=0x7ff1b5c4f088 "CREATE OR REPLACE TABLE `t4` ( n INT ) ENGINE=CONNECT `table_type`=CSV `file_name`='qq' AS SELECT SLEEP(5) /* QNO 21 CON_ID 6 */", length=128, parser_state=0x7ff1e623e630) at /data/src/10.1/sql/sql_parse.cc:7343
      # 2017-04-22T00:25:13 [9479] #17 0x00007ff1e5394b06 in dispatch_command (command=COM_QUERY, thd=0x7ff1bef48070, packet=0x7ff1bef5e071 "CREATE OR REPLACE TABLE `t4` ( n INT ) ENGINE=CONNECT `table_type`=CSV `file_name`='qq' AS SELECT SLEEP(5) /* QNO 21 CON_ID 6 */ ", packet_length=129) at /data/src/10.1/sql/sql_parse.cc:1490
      # 2017-04-22T00:25:13 [9479] #18 0x00007ff1e5393865 in do_command (thd=0x7ff1bef48070) at /data/src/10.1/sql/sql_parse.cc:1109
      # 2017-04-22T00:25:13 [9479] #19 0x00007ff1e54ca6aa in do_handle_one_connection (thd_arg=0x7ff1bef48070) at /data/src/10.1/sql/sql_connect.cc:1349
      # 2017-04-22T00:25:13 [9479] #20 0x00007ff1e54ca40e in handle_one_connection (arg=0x7ff1bef48070) at /data/src/10.1/sql/sql_connect.cc:1261
      # 2017-04-22T00:25:13 [9479] #21 0x00007ff1e4a90064 in start_thread (arg=0x7ff1e623fb00) at pthread_create.c:309
      # 2017-04-22T00:25:13 [9479] #22 0x00007ff1e2c4862d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      perl ./runall-new.pl --skip-gendata --grammar=/data/bug/connect.yy --threads=8 --duration=300 --mysqld=--plugin-load-add='ha_connect'  --basedir=/data/bld/10.1 --vardir=/data/logs/analyze
      

      connect.yy

      query:
          CREATE OR REPLACE TABLE my_table ( n INT ) ENGINE=CONNECT `table_type`=CSV `file_name`='qq' AS SELECT SLEEP(5)
      ;
       
      my_table:
          `t1` | `t2` | `t3` | `t4` | `t5`
      ;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.