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

show_analyze sporadically fails at line 226: query 'reap' succeeded - should have failed with error ER_QUERY_INTERRUPTED

    XMLWordPrintable

Details

    Description

      CURRENT_TEST: main.show_analyze
      mysqltest: At line 226: query 'reap' succeeded - should have failed with error ER_QUERY_INTERRUPTED (1317)...
       
      The result from queries just before the failure was:
      < snip >
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
      1	PRIMARY	a	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	20.00	Using where
      2	DEPENDENT SUBQUERY	b	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	95.00	Using where
      Warnings:
      Note	1003	analyze select a, (select max(a) from t0 b where b.a+a.a<10) from t0 a where a<2
      connection con1;
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	r_rows	filtered	r_filtered	Extra
      1	PRIMARY	a	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	20.00	Using where
      2	DEPENDENT SUBQUERY	b	ALL	NULL	NULL	NULL	NULL	10	10.00	100.00	95.00	Using where
      SET debug_dbug=@old_debug;
      # Try to do SHOW ANALYZE for a query that runs a  SET command:
      #
      set @show_explain_probe_select_id=2;
      SET debug_dbug='+d,show_explain_probe_join_exec_start';
      set @foo= (select max(a) from t0 where sin(a) >0);
      connection default;
      show analyze for $thr2;
      ERROR HY000: Target is not executing an operation with a query plan
      kill query $thr2;
      connection con1;
      

      The portion of the test that is failing:

      --echo # Try to do SHOW ANALYZE for a query that runs a  SET command:
      --echo #
      set @show_explain_probe_select_id=2; # <---
      SET debug_dbug='+d,show_explain_probe_join_exec_start';
      send set @foo= (select max(a) from t0 where sin(a) >0);
      connection default;
      --source include/wait_condition.inc
      --error ER_TARGET_NOT_EXPLAINABLE
      evalp show analyze for $thr2;
      evalp kill query $thr2;
      connection con1;
      --error ER_QUERY_INTERRUPTED
      reap;
      SET debug_dbug=@old_debug;
      

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              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.