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

redistributedata causes inflight queries to failed with "data file does not exist" error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.0.9
    • Icebox
    • N/A
    • None

    Description

      Build tested: 1.0.9-1

      Test environment
      1 UM and 4 PMs. Load line item with 20gb of data (loaded 10g source twice) to PM1 only, using the -P option in cpimport.

      As soon as redistributedata started, I executed the following query:

      MariaDB [tpch10c]> select min(l_orderkey), min(l_partkey), min(l_suppkey), min(l_linenumber), sum(l_quantity), sum(l_extendedprice), max(l_discount), max(l_tax), count(l_returnflag), count(l_linestatus), max(l_shipdate), max(l_receiptdate), max(l_shipinstruct), count(l_shipmode), count(l_comment) from lineitem;
      ERROR 1815 (HY000): Internal error: IDB-2039: Data file does not exist, please contact your system administrator for more information.

      The error does not happen every time. If redistributedata completes without triggering the error, you would need to truncate the table, load data to PM1 again before repeating the test.

      The query access all rows in all columns of the lineitem table.

      At this point, I do not know if the error occurred due to
      1) a file being read has been moved (Can a file opened for read be moved)
      2) a file about to be read has been moved
      3) something else

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (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.