Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4657

Concurrent DML test sometimes failed with a 'Blocks are missing' error



    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5.2
    • Icebox
    • DMLProc, ExeMgr
    • None


      Build tested: 5.5.2-1

      Test environment: single server Centos 8 VM

      This error does not happen all the time or infrequent. I encountered it one out of few test runs.

      The test is part of the Autopilot concurrency.concurDML test.

      The following is essentially what the tests does

      1. Load a 1g dbt3 database using LDI using cpimport
      2. Run queries on all table continuously in the back ground until the update test (next step) is done. The following example is for the supplier table:

      select count(*) from supplier where s_suppkey < 0;
      select count(*) from supplier where s_comment > 'zzzz';

      3. Run update and roll back test concurrently

      set autocommit=0;
      update supplier set s_suppkey=-1;
      update supplier set s_comment='zzzz-1';
      update supplier set s_suppkey=-2;
      update supplier set s_comment='zzzz-2';
      update supplier set s_suppkey=-100;
      update supplier set s_comment='zzzz-100';

      The idea is that the queries in step 2 should always return 0 rows since auto commit is off and updates always got rolled back. There seem to be some type of timing issue in this concurrency scenario. This test was done on a single VM. I don't know if this issue would occur more frequent in a high speed environment.

      The query in step 2 returned the follow error:

      ERROR 1815 (HY000) at line 2: Internal error: IDB-2031: Blocks are missing. Alter or drop table in progress?


        Issue Links



              leonid.fedorov Leonid Fedorov
              dleeyh Daniel Lee (Inactive)
              0 Vote for this issue
              2 Start watching this issue



                Git Integration

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