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

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11
    • 10.11
    • Tests

    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

        Activity

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.