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

query returned "block missing" error while concurrently update and rollback was running.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • None
    • 1.0.0
    • regression suite
    • None

    Description

      query returned "block missing" error while concurrently update and rollback was running.

      Tested with a 1gb tpch database. The is was identified by the concurDML test in autopilot. Reproduced it few times and suddenly not happening. It may happen if you keep repeating the test.

      "run a script to do:

      set autocommit=0;
      update nation set n_nationkey=-1;
      update nation set n_comment='zzzz-1';
      rollback;
      update nation set n_nationkey=-2;
      update nation set n_comment='zzzz-2';
      rollback;
      The script repeats the above statements all the way to -100 and zzzz-100
       
      While the script is running, continueously run these two statements:
      select count(*) from nation where n_nationkey < 0;
      select count(*) from nation where n_comment > 'zzzz';
      "
      

      The idea of the test is that the queries should return 0 or all rows in the table. We should not be getting partitially updated data

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            dshjoshi Dipti Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.