I get this error message very often, in several machines.
The server stops running and waits until a human being erases that file manually.
This is a disaster. Mission-critical machines needs to be converted back to INNODB, which is very inefficient in terms of storage.
The right design is that Rocksdb fixes itself, erases any corrupt file and continues.
[ERROR] RocksDB: The server will exit normally and stop restart attempts. Remove ./#rocksdb/ROCKSDB_CORRUPTED file from data directory and start mysqld manually.