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

Unexpected error 3 "No such process" from storage engine upon DELETE ... FOR PORTION

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.4(EOL)
    • 10.5
    • Versioned Tables
    • None

    Description

      CREATE TABLE t1 (a DATE DEFAULT '2000-01-01', b DATE DEFAULT '2020-01-01', PERIOD FOR app(a,b));
      		 
      INSERT INTO t1 VALUES ('2000-01-01','2010-01-01'),('2011-01-01','2020-01-01');
      		 
      DELETE FROM t1 FOR PORTION OF app FROM '2004-01-01 12:00:00' TO '2020-02-19 19:50:10';
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;

      10.4 6a634576

      		 
      mysqltest: At line 3: query 'DELETE FROM t1 FOR PORTION OF app FROM '2004-01-01 12:00:00' TO '2020-02-19 19:50:10'' failed: 1030: Got error 3 "No such process" from storage engine MyISAM

      Reproducible on 10.4, 10.5, debug and non-debug alike, with at least InnoDB and MyISAM.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21987 Assertion failure in file lock0lock.cc line 6901 / DeadlockChecker::check_and_resolve

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19130 Assertion `next_insert_id >= auto_inc_interval_for_cur_row.minimum()' failed in handler::update_auto_increment after error 167

          • Major - Major loss of function.
          • Closed

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              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.