Is there a repair/rebuild option without loosing data?

[marneu]

After updating to 1.1.3 (bookworm) an error is shown and can be reproduced using:

sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db "pragma integrity_check"

results in:

row 64934 missing from index idx_url
row 64943 missing from index idx_url

I do not want to delete it as there are some really nice playlists and other stuff maintained over the years.

btw: This might be an option/feature request in tools "repair db"

[trincowski]

@marneu You don't use Timeshift?
Is the "strawberry.db.bak" also corrupt?

[jonas]

@marneu said in Is there a repair/rebuild option without loosing data?:

sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db "

Try:

sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db "REINDEX idx_url"

[marneu]

@jonas said in Is there a repair/rebuild option without loosing data?:

sqlite3 ~/.local/share/strawberry/strawberry/strawberry.db "REINDEX idx_url"

Great, that did the trick. Error message is gone. Thanks.

[marneu]

@trincowski Yes I do (now )