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

FILE001.cdf:No such file or directory - occurred when query, truncate and cpimport collided

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.2.2
    • 1.2.6, 1.4.4, 1.5.1
    • None
    • None
    • 2um 2pm with local query
    • 2020-3, 2020-4, 2020-5

    Description

      Customer report errors on both PMs

      Apr 11 19:11:05 usfit-scdb6 PrimProc[144321]: 05.309773 |0|0|0| C 28 CAL0053: PrimProc could not open file for OID 73844; /000.dir/001.dir/032.dir/116.dir/000.dir/FILE001.cdf:No such file or directory

      No ExeMgr restarted, which has caused this issue in the past. Customer reported this is might have caused the problem via the Issue

      There was a long running query.. and at the end of the query this uses table X. This query was running.. when at the same time a process ran that TRUNCATES and cpimports table X. It appears the data files were updated, leaving the long query to look in the previous place for the data that was not there. This is when our error returned and still presents a problem for this type of thing to be able to happen.

      It is understandable that it can happen.. however the errors given seem to indicate a l detrimental loss of data

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Julien Fritsch made transition -
          Open Needs Feedback
          59d 14h 9m 1
          David Hill (Inactive) made transition -
          Needs Feedback Open
          5h 55m 1
          Patrick LeBlanc (Inactive) made transition -
          Open In Progress
          265d 3h 57m 1
          Patrick LeBlanc (Inactive) made transition -
          In Progress Stalled
          22h 14m 1
          Patrick LeBlanc (Inactive) made transition -
          Stalled In Progress
          10d 18m 1
          Patrick LeBlanc (Inactive) made transition -
          In Progress In Review
          2h 13m 1
          Patrick LeBlanc (Inactive) made transition -
          In Testing Stalled
          14s 1
          Patrick LeBlanc (Inactive) made transition -
          Stalled Confirmed
          4s 1
          Patrick LeBlanc (Inactive) made transition -
          Confirmed In Review
          18s 1
          Gagan Goel (Inactive) made transition -
          In Review In Testing
          4d 2h 2
          Daniel Lee (Inactive) made transition -
          In Testing Closed
          6d 21h 16m 1

          People

            dleeyh Daniel Lee (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.