@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.

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 Yes I do (now )

@JMinE-K Das sieht nach einem Berechtigungs Problem aus bzw. zeige mal den vollen Dateinamen

@trincowski Yes I do (now )

@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.

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"