xbvr database corrupt

[henrydias19]

Hello
My macmini froze up and now I'm gettinng error messages
time="2024-11-11T09:45:59-03:00" level=fatal msg="Failed to connect to database All attempts fail:
#1: database disk image is malformed
#2: database disk image is malformed
#3: database disk image is malformed
#4: database disk image is malformed
#5: database disk image is malformed
#6: database disk image is malformed
#7: database disk image is malformed
#8: database disk image is malformed
#9: database disk image is malformed
#10: database disk image is malformed"

Any way to repair it? Thanks!

[henrydias19]

Just to leave documented, with the help of ChatGPT I´ve found the solution. In this case the main.db were corrupted. So those were the steps:

1. go to dabase directory: cd "/Users/(your user here)/Library/Application Support/xbvr"
2. do a backup os the database: mv main.db main_backup.db
3. Try repair using SQL Lite: sqlite3 main.db ".dump" | sqlite3 repaired_main.db
4. Rename "repaired" to main.db and see if worked

In my case it not worked so y can try sqllite recovery mode (SQLite 3.31+)

1. Check version: sqlite3 --version
2. if equal or more than 3.31: sqlite3 main.db ".recover" | sqlite3 recovered_main.db
3. Revame ".recover" to main.db

In my case the "recover" did the job, but you can try the external tool: "DB Browser for SQLite"

Hope this can help someone

[henrydias19]

Just as a note, this solution steps are for Mac. But for windows should work if you are in the right directory