SQLitePCL.pretty.SQLiteException Error

[EuG0000 3]

Hi, I'm running Windows EMBY server: Version 3.1.5.0

 

I've been getting Refresh Guide, Clean DB failures etc.

It looks like SQLitePCL.pretty.SQLiteException Error is the cause.

 

I'm attaching the log extract that shows this error.

Any advise on how to fix this?

 

Thank you,

 

LogExtract.txt

[Luke 39988]

Hi there @@EuG0000, unfortunately your library database file has become corrupt, so you will need to shut down the server and delete this file

C:\Users\EuG\AppData\Roaming\MediaBrowser-Server\data\library.db

This file also contains your watch data, so you might want to back that up before doing so. We have documentation on that here:

 

https://emby.media/community/index.php?/topic/10427-how-to-migrate-emby-server

 

Let us know if you have any issues. Thanks.

[EuG0000 3]

Thank you.

That worked.

 

What's interesting is that looking at my files I've actually done this before (I have an older .BACK version of my library.db file)

This time I've also noticed there's another very large DB file called refreshinfo.db - I've decided to "delete" (rename to .BACK) that one as well.

 

I've back up my server using the config back up plug in, deleted those files and then restored the configuration.

So far things seem to be running w/o errors - so thank you for the tip!

 

Just curious, what's refreshinfo.db file for?   

New library.db was re-created, however I still don't see new refreshinfo.db.

[Luke 39988]

refreshinfo is no longer used.

[EuG0000 3]

Thank you.