search

torrust / torrust-demo

CI and configuration for the Torrust live demo.
https://index.torrust-demo.com
0 stars 0 forks source link

Error in tracker SQLite DB: `Runtime error: database disk image is malformed (11)` #11

Closed josecelano closed 2 months ago

josecelano commented 2 months ago

On the 12th of August 2024, I downloaded a backup of the tracker SQLite database. I could not open it. I was getting that error:

Runtime error: database disk image is malformed (11)

I solved by doing this.

sqlite3
.open 2024-08-12-tracker.db
.clone tracker.db

Anyway, after doing that, I was able to open the original DB file, 2024-08-12-tracker.db, again.

The torrents table has 56.448.666 infohashes.

cc @da2ce7

josecelano commented 2 months ago

I can open the original one, but I get the same error:

sqlite> SELECT COUNT(*) FROM torrents WHERE info_hash LIKE '00%';
Runtime error: database disk image is malformed (11)

I think I was wrong; the problem was not opening the DB but running queries.