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

Interrupted SELECT fails with 1030: 'Got error 1 "Operation not permitted" from storage engine MyISAM'

    XMLWordPrintable

    Details

      Description

      Note: In the test case below, the event can be replaced by SET max_statement_time=1. I'm keeping the event because it allows to run the test on different versions of MariaDB and MySQL.

      CREATE TABLE t (i INT AUTO_INCREMENT, c VARCHAR(1), KEY(i), KEY(c,i)) ENGINE=MyISAM;
      INSERT INTO t (c) VALUES ('a'),('b'),('c'),('d');
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
      INSERT INTO t (c) SELECT c FROM t;
       
      --let $conid = `SELECT CONNECTION_ID()`
       
      eval CREATE EVENT ev ON SCHEDULE EVERY 1 SECOND DO KILL QUERY $conid;
      SET GLOBAL event_scheduler = ON;
       
      --let $run = 20
      --disable_result_log
      while ($run)
      {
        --error ER_QUERY_INTERRUPTED
        SELECT 1 FROM t AS alias1, t AS alias2, t AS alias3
        WHERE alias1.c = alias2.c OR alias1.i <= 1
        ;
        --dec $run
      }
       
      DROP TABLE t;
      SET GLOBAL event_scheduler = DEFAULT;
      DROP EVENT ev;
      

      mysqltest: At line 29: query 'SELECT 1 FROM t AS alias1, t AS alias2, t AS alias3
      WHERE alias1.c = alias2.c OR alias1.i <= 1
      ' failed with wrong errno 1030: 'Got error 1 "Operation not permitted" from storage engine MyISAM', instead of 1317...
      

      It looks like the problem appeared in 10.2 tree with this commit:

      commit 2cfc450bf78c2d951729d1a0e8f731c0d987b1d5
      Author: Igor Babaev <igor@askmonty.org>
      Date:   Tue Feb 9 12:35:59 2016 -0800
       
          This is the consolidated patch for mdev-8646:
          "Re-factor the code for post-join operations".
      

      Could not reproduce on 10.1, MySQL 5.6, MySQL 5.7.

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: