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

Server crashed in my_copy_8bit on querying I_S.PROCESSLIST

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL)
    • 10.1.8
    • Character Sets
    • None

    Description

      Stack trace from 10.1 commit 7cbecadf9b59d06f4d9a9e776f99418b273c2ebc

      #3  <signal handler called>
      #4  0x00007f6a3b644da0 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
      #5  0x00007f6a3e33fc1e in my_copy_8bit (cs=0x7f6a3eb776c0 <my_charset_bin>, dst=0x7f6a0f0d3270 "CREATE OR REPLACE TABLE `create_or_replace_tmp` AS SELECT * FROM `table1_myisam_int_autoinc` /* TRANSFORM_OUTCOME_UNORDERED_MATCH */\245\245\245\245h4z\025", dst_length=134, src=0x0, src_length=134, nchars=134, status=0x7f6a3d43ab70) at 10.1/strings/ctype-simple.c:1143
      #6  0x00007f6a3db37616 in String_copier::well_formed_copy (this=0x7f6a3d43ab70, to_cs=0x7f6a3eb776c0 <my_charset_bin>, to=0x7f6a0f0d3270 "CREATE OR REPLACE TABLE `create_or_replace_tmp` AS SELECT * FROM `table1_myisam_int_autoinc` /* TRANSFORM_OUTCOME_UNORDERED_MATCH */\245\245\245\245h4z\025", to_length=134, from_cs=0x7f6a3eb776c0 <my_charset_bin>, from=0x0, from_length=134, nchars=134) at 10.1/sql/sql_string.cc:918
      #7  0x00007f6a3da56fcf in String_copier::well_formed_copy (this=0x7f6a3d43ab70, to_cs=0x7f6a3eb776c0 <my_charset_bin>, to=0x7f6a0f0d3270 "CREATE OR REPLACE TABLE `create_or_replace_tmp` AS SELECT * FROM `table1_myisam_int_autoinc` /* TRANSFORM_OUTCOME_UNORDERED_MATCH */\245\245\245\245h4z\025", to_length=134, from_cs=0x7f6a3eb776c0 <my_charset_bin>, from=0x0, from_length=134) at 10.1/sql/sql_string.h:84
      #8  0x00007f6a3dca6ac0 in Field_blob::store (this=0x7f6a35a696c8, from=0x0, length=134, cs=0x7f6a3eb776c0 <my_charset_bin>) at 10.1/sql/field.cc:7831
      #9  0x00007f6a3db17b57 in fill_schema_processlist (thd=0x7f6a13f31070, tables=0x7f6a358533e0, cond=0x0) at 10.1/sql/sql_show.cc:2924
      #10 0x00007f6a3db2a9ee in get_schema_tables_result (join=0x7f6a35855168, executed_place=PROCESSED_BY_JOIN_EXEC) at 10.1/sql/sql_show.cc:8059
      #11 0x00007f6a3dacc0f0 in JOIN::exec_inner (this=0x7f6a35855168) at 10.1/sql/sql_select.cc:2560
      #12 0x00007f6a3dacb753 in JOIN::exec (this=0x7f6a35855168) at 10.1/sql/sql_select.cc:2409
      #13 0x00007f6a3dacee75 in mysql_select (thd=0x7f6a13f31070, rref_pointer_array=0x7f6a13f353d8, tables=0x7f6a358533e0, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7f6a35853aa0, group=0x0, having=0x0, proc_param=0x0, select_options=2684652288, result=0x7f6a35853300, unit=0x7f6a13f34a70, select_lex=0x7f6a13f35160) at 10.1/sql/sql_select.cc:3346
      #14 0x00007f6a3dac4cdf in handle_select (thd=0x7f6a13f31070, lex=0x7f6a13f349a8, result=0x7f6a35853300, setup_tables_done_option=0) at 10.1/sql/sql_select.cc:371
      #15 0x00007f6a3da95144 in execute_sqlcom_select (thd=0x7f6a13f31070, all_tables=0x7f6a358533e0) at 10.1/sql/sql_parse.cc:5849
      #16 0x00007f6a3da8b478 in mysql_execute_command (thd=0x7f6a13f31070) at 10.1/sql/sql_parse.cc:2962
      #17 0x00007f6a3da9866b in mysql_parse (thd=0x7f6a13f31070, rawbuf=0x7f6a35853088 "SELECT ID INTO @thread_id FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY RAND() LIMIT 1  /* TRANSFORM_OUTCOME_UNORDERED_MATCH */", length=126, parser_state=0x7f6a3d43c1d0) at 10.1/sql/sql_parse.cc:7227
      #18 0x00007f6a3da8767a in dispatch_command (command=COM_QUERY, thd=0x7f6a13f31070, packet=0x7f6a13f37071 "SELECT ID INTO @thread_id FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY RAND() LIMIT 1  /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ ;", packet_length=128) at 10.1/sql/sql_parse.cc:1488
      #19 0x00007f6a3da863ab in do_command (thd=0x7f6a13f31070) at 10.1/sql/sql_parse.cc:1110
      #20 0x00007f6a3dbba1d3 in do_handle_one_connection (thd_arg=0x7f6a13f31070) at 10.1/sql/sql_connect.cc:1350
      #21 0x00007f6a3dbb9f37 in handle_one_connection (arg=0x7f6a13f31070) at 10.1/sql/sql_connect.cc:1262
      #22 0x00007f6a3bebbe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #23 0x00007f6a3b5e8cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6

      All threads' bt and full bt are attached.

      RQG command line – adding as general information, I could not reproduce the problem so far.

      perl runall-new.pl --no-mask --seed=1442964353 --threads=8 --duration=600 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsDeleteReturning,ExecuteAsPreparedTwice,DisableOptimizations,EnableOptimizations,OrderBy --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/10.0-features-redefine.yy --redefine=analyze-redefine.yy --mysqld=--log_output=FILE --mysqld=--slow_query_log --mysqld=--long_query_time=0.000001 --mysqld=--log_bin_trust_function_creators=1 --mysqld=--query_cache_size=64M --views --grammar=conf/runtime/connect_kill_sql.yy --gendata=conf/runtime/connect_kill_data.zz --engine=MyISAM --use-gtid=current_pos --mysqld=--optimizer_switch=extended_keys=on,exists_to_in=on --mysqld=--use_stat_tables=PREFERABLY --mysqld=--optimizer_selectivity_sampling_limit=100 --mysqld=--optimizer_use_condition_selectivity=5 --mysqld=--histogram_size=100 --mysqld=--histogram_type=DOUBLE_PREC_HB --mysqld=--log_slow_verbosity=query_plan,explain --mysqld=--slave_parallel_threads=8 --mtr-build-thread=73 --basedir1=<your basedir> --vardir1=<your vardir>

      RQG version is lp:~elenst/randgen/mariadb-patches revno 1045
      analyze-redefine.yy is attached.

      Attachments

        1. analyze-redefine.yy
          0.2 kB
          Elena Stepanova
        2. threads
          49 kB
          Elena Stepanova
        3. threads_full
          161 kB
          Elena Stepanova

        Issue Links

          Activity

            People

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