Is this a regression?

Yes

Description

pika在正常导数期间突然异常，发现某个rocksdb日志报错后无法手动执行compact，但监控大盘显示一直在compact

2025/07/10-06:04:09.826135 139631358109440 [db/db_impl/db_impl_files.cc:387] [JOB 394] Tried to delete a non-existing file /app/pika/pika-9224/db/db0/0/001055.log type=0 #1055 -- IO error: No such file or directory: while unlink() file: /app/pika/pika-9224/db/db0/0/001055.log: No such file or directory

类似问题：#1523

手动执行compact后，显示ok，但是info查看仍显示is_compact:No

Please provide a link to a minimal reproduction of the bug

No response

Screenshots or videos

No response

Please provide the version you discovered this bug in (check about page for version information)

Version：4.0.2

Anything else?

No response