4.6.2 sqlite backend - missing added torrents after unclean shutdown #15289

Open
opened 2026-02-22 01:58:35 -05:00 by deekerman · 1 comment
Owner

Originally created by @thisisnotmyrealname on GitHub (Dec 16, 2023).

qBittorrent & operating system versions

Qbittorrent v4.6.2 appimage
OS: Ubuntu 22.04 6.5.0-14-generic

What is the problem?

sqlite database becomes partially corrupted after unclean shutdown, even with "save resume data interval" set.

Steps to reproduce

  1. Run QBT
  2. add a bunch of stuff
  3. wait 2 hours (or whatever your save interval is) plus one minute
  4. have an unclean shutdown
  5. missing torrents

Additional context

After the unclean shutdown I was missing a bunch of stuff that had been added after a certain date (literal days, dozens of files). I vacuumed and pragma_check'd the database file. File lost about 8% of its size. relaunched QBT and some of the missing content was restored.

Does QBT need better handling of the sqlite file, or for it to internally do periodic checks?

Log(s) & preferences file(s)

No response

Originally created by @thisisnotmyrealname on GitHub (Dec 16, 2023). ### qBittorrent & operating system versions Qbittorrent v4.6.2 appimage OS: Ubuntu 22.04 6.5.0-14-generic ### What is the problem? sqlite database becomes partially corrupted after unclean shutdown, even with "save resume data interval" set. ### Steps to reproduce 1) Run QBT 2) add a bunch of stuff 3) wait 2 hours (or whatever your save interval is) plus one minute 4) have an unclean shutdown 5) missing torrents ### Additional context After the unclean shutdown I was missing a bunch of stuff that had been added after a certain date (literal days, dozens of files). I vacuumed and pragma_check'd the database file. File lost about 8% of its size. relaunched QBT and some of the missing content was restored. Does QBT need better handling of the sqlite file, or for it to internally do periodic checks? ### Log(s) & preferences file(s) _No response_
Author
Owner

@xavier2k6 commented on GitHub (Dec 17, 2023):

@glassez FYI

@xavier2k6 commented on GitHub (Dec 17, 2023): @glassez FYI
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/qBittorrent#15289
No description provided.