[BUG] Unable flush records into database

[yueisme]

版本号 - Version

6.2.8

操作系统平台和系统架构 - OS and CPU Arch

OS 名称: Microsoft Windows 11 专业版
OS 版本: 10.0.22631 暂缺 Build 22631

部署方式 - Deploy methods

• Windows .exe 安装程序 (Windows .exe Installer)
• Windows .zip 绿色部署包 (Windows .zip Portable)
• Docker
• JAR 包直接启动 (Start via .JAR directly)
• 群晖 DSM 套件 (Synology .spk package)
• Debian 软件包 (Debian .deb package)
• RedHat/Fedora 软件包 (RedHat/Fedora .rpm package)

添加的下载器 - Added Downloaders

• qBittorrent
• BiglyBT/Azureus/Vuze
• Deluge
• Transmission

问题描述 - Issue Description

查看日志发现有报错

复现步骤 - Reproduce steps

偶然出现的问题，不知道复现的办法

截图/日志文件 - Screenshot / Logs

[16:45:14] [/ERROR]: Unable flush records into database
org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (cannot start a transaction within a transaction)
	at org.sqlite.core.DB.newSQLException(DB.java:1179) ~[PeerBanHelper.jar:6.2.8]
	at org.sqlite.core.DB.newSQLException(DB.java:1190) ~[PeerBanHelper.jar:6.2.8]
	at org.sqlite.core.DB.throwex(DB.java:1150) ~[PeerBanHelper.jar:6.2.8]
	at org.sqlite.core.DB.exec(DB.java:198) ~[PeerBanHelper.jar:6.2.8]
	at org.sqlite.SQLiteConnection.setAutoCommit(SQLiteConnection.java:369) ~[PeerBanHelper.jar:6.2.8]
	at com.zaxxer.hikari.pool.ProxyConnection.setAutoCommit(ProxyConnection.java:402) ~[PeerBanHelper.jar:6.2.8]
	at com.zaxxer.hikari.pool.HikariProxyConnection.setAutoCommit(HikariProxyConnection.java) ~[PeerBanHelper.jar:6.2.8]
	at com.j256.ormlite.jdbc.JdbcDatabaseConnection.setAutoCommit(JdbcDatabaseConnection.java:61) ~[PeerBanHelper.jar:6.2.8]
	at com.j256.ormlite.stmt.StatementExecutor.doCallBatchTasks(StatementExecutor.java:646) ~[PeerBanHelper.jar:6.2.8]
	at com.j256.ormlite.stmt.StatementExecutor.doCallBatchTasks(StatementExecutor.java:623) ~[PeerBanHelper.jar:6.2.8]
	at com.j256.ormlite.stmt.StatementExecutor.callBatchTasks(StatementExecutor.java:603) ~[PeerBanHelper.jar:6.2.8]
	at com.j256.ormlite.dao.BaseDaoImpl.callBatchTasks(BaseDaoImpl.java:734) ~[PeerBanHelper.jar:6.2.8]
	at com.ghostchu.peerbanhelper.database.dao.impl.ProgressCheatBlockerPersistDao.flushDatabase(ProgressCheatBlockerPersistDao.java:56) ~[PeerBanHelper.jar:6.2.8]
	at com.ghostchu.peerbanhelper.module.impl.rule.ProgressCheatBlocker.flushDatabase(ProgressCheatBlocker.java:122) ~[PeerBanHelper.jar:6.2.8]
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[?:?]
	at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:358) ~[?:?]
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) ~[?:?]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
	at java.base/java.lang.VirtualThread.run(VirtualThread.java:329) ~[?:?]

额外信息 - Addition Information

No response

检查清单 - Check list

• PeerBanHelper 已更新到最新版本，非最新版本不接受任何错误反馈 (I'm running the latest version of PBH that can be found in Github Relases, non-latest release won't receive any support)
• 所添加的下载器已满足 README 中的前置要求（如版本号和插件）(The downloaders that I've added already satisfied the requirements (E.g install plugins/adapters))
• 我已检查过 PBH 文档（特别是常见问题），且即使使用了搜索也没有找到与此有关的内容 (This not a question/or the question that not listed in README's FAQ or PBH WIKI)
• 我没有检查这个检查清单，只是闭眼选中了所有的复选框，请关闭这个 Issue (I have not read these checkboxes and therefore I just ticked them all, Please close this issue)
• 这不是一个安全漏洞，它可以被安全的公开报告。若需要报告安全漏洞，请在此报告 (This not a security related issue, can be safe report in public. If you want report a security exploit, please report it here)

[Ghost-chu]

删除 persist/peerbanhelper.db 数据库文件，重建db

[yueisme]

这是旧版本的数据引发的问题吗

[Ghost-chu]

删除后封禁的数据被清空了，运行一段时间发现有解封的动作，但是封禁日志里看到最快的解封在10月

[17:48:35] [Ban Wave/INFO]: [解封] 解除了 1 个过期的对等体封禁
[17:51:00] [Ban Wave/INFO]: [解封] 解除了 1 个过期的对等体封禁
[17:54:40] [Ban Wave/INFO]: [解封] 解除了 1 个过期的对等体封禁

#459