Environment

• Yubagyte DB
• YCQL or YSQL API

Issue

Warning level logs like:

 Failed to destroy regular DB at: /mnt/d0/yb-data/tserver/data/rocksdb/table-000033e6000030008000000000004319/tablet-4cb9cf59343f4591ab86a7084a978b7d: IO error (yb/rocksdb/util/env_posix.cc:317): /mnt/d0/yb-data/tserver/data/rocksdb/table-000033e6000030008000000000004319/tablet-4cb9cf59343f4591ab86a7084a978b7d/LOCK: No such file or directory

Resolution

Overview

This warning level log may be ignored. It is a race condition in background compactions

Root Cause

There are two conflicting tasks which may delete this intents file.

There is a background cleanup for intents, which cleans up {what}. 

At the same time, a schedule or triggered compaction may clean this file for the tablet after the list of files to be cleaned by background cleanup was provided to the intents cleanup.

When the intents clean looks for the file liketablet-4cb9cf59343f4591ab86a7084a978b7d/LOCK, it has already been cleaned by the compaction job, and throws this error.