[ISSUE #9832] Cleanup test directories in some RocksDB unit tests

[majialoong]

Which Issue(s) This PR Fixes

Fixes #9832

Brief Description

Clean up test directories in some RocksDB unit tests

How Did You Test This Change?

unit test and local test

[codecov-commenter]

Codecov Report

:white_check_mark: All modified and coverable lines are covered by tests. :white_check_mark: Project coverage is 48.28%. Comparing base (e4170f5) to head (afa11f0).

Additional details and impacted files

@@              Coverage Diff              @@
##             develop    #9833      +/-   ##
=============================================
- Coverage      48.35%   48.28%   -0.08%     
+ Complexity     12255    12239      -16     
=============================================
  Files           1314     1314              
  Lines          93777    93777              
  Branches       12034    12034              
=============================================
- Hits           45345    45279      -66     
- Misses         42834    42886      +52     
- Partials        5598     5612      +14     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:

• :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.