binlog file truncate error

[hereTac]

Is this a regression?

Yes

Description

pika_version:3.5.6
在持续运行 80+ 天之后出现如下报错。
申明：磁盘空间足够，确认过 SSD 无磁盘报错。
log.WARNING 如下

W20251231 00:22:20.650394 1308841 pika_stable_log.cc:109] /data/pika/log/log_db5/ Could not purge 139247, since it is already be used                                                                                           
W20251231 00:32:16.698227 1308841 pika_stable_log.cc:109] /data/pika/log/log_db5/ Could not purge 139268, since it is already be used                                                                                           
W20260101 06:09:44.631770 1308773 env.cc:344] ftruncate error
W20260101 06:09:44.642748 1308773 pika_command.cc:964] (db5) Writing binlog failed, maybe no space left on device IO error: /data/pika/log/log_db5/write2file143006: Success
W20260101 06:09:44.642776 1308781 env.cc:344] ftruncate error                                                   
W20260101 06:09:44.642804 1308781 pika_command.cc:964] (db5) Writing binlog failed, maybe no space left on device IO error: /data/pika/log/log_db5/write2file143006: Success                                                    
W20260101 06:09:44.642876 1308777 env.cc:344] ftruncate error

该错误影响数据的继续写入，不影响 pika 的正常连接，查询使用已经存在的数据。

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

NAME="Rocky Linux"
VERSION="9.6 (Blue Onyx)"