Jump to content

Library scan failed - SQLitePCL.pretty.SQLiteException


Bernie V

Recommended Posts

Bernie V

Since 1 week my library scans failed with the "SQLitePCL.pretty.SQLiteException" error.

 

I deleted the /var/lib/emby/data/library.db when Emby was shutdown but the error is stil there.

Do I have other options?

 

Regards

Link to comment
Share on other sites

dcrdev

That's just the class where the exception is occurring, it's not the actual exception...

 

You'll need to upload a log.

Edited by dcrdev
Link to comment
Share on other sites

please shutdown the server and rename this file

 

/var/lib/emby-server/data/library.db

 

Additionally, please also be aware that your system has the mono runtime 5.8 installed. our highest supported version is 4.8.1 so i think you'll need to roll that back or this will be likely to happen again. thanks.

Link to comment
Share on other sites

Also mono 5.8 isn't even mentioned on their download page, so if you're running some kind of pre-release then that's especially bad. I would revert to 4.8.1. Thanks.

Link to comment
Share on other sites

Bernie V

Thx for advice.

There was a beta repo in the file /etc/apt/sources.list.d/mono-xamarin.list

I changed it to deb http://download.mono-project.com/repo/debian wheezy/snapshots/4.8.1.0 main

 

 

When I try sudo apt-get remove mono-complete

 

Then I get this:

Reading package lists... Error!
E: Encountered a section with no Package: header
E: Problem with MergeList /var/lib/dpkg/status
E: The package lists or status file could not be parsed or opened.

 

sudo apt-get update gives me this:

 

Hit http://archive.raspberrypi.org jessie InRelease
Hit http://mirror.ox.ac.uk jessie InRelease
Ign http://download.opensuse.org InRelease
Hit http://download.mono-project.com wheezy/snapshots/4.8.1.0 InRelease
Hit http://download.opensuse.org Release.gpg
Hit http://download.opensuse.org Release
Hit http://download.opensuse.org Packages
Hit http://archive.raspberrypi.org jessie/main armhf Packages
Hit http://archive.raspberrypi.org jessie/ui armhf Packages
Hit http://mirror.ox.ac.uk jessie/main armhf Packages
Hit http://mirror.ox.ac.uk jessie/contrib armhf Packages
Hit http://mirror.ox.ac.uk jessie/non-free armhf Packages
Hit http://mirror.ox.ac.uk jessie/rpi armhf Packages
Ign http://download.opensuse.org Translation-en_GB
Ign http://download.opensuse.org Translation-en
Get:1 http://download.mono-project.com wheezy/snapshots/4.8.1.0/main armhf Packages [58.6 kB]
Ign http://archive.raspberrypi.org jessie/main Translation-en_GB
Ign http://mirror.ox.ac.uk jessie/contrib Translation-en_GB
Ign http://mirror.ox.ac.uk jessie/contrib Translation-en
Ign http://archive.raspberrypi.org jessie/main Translation-en
Ign http://mirror.ox.ac.uk jessie/main Translation-en_GB
Ign http://mirror.ox.ac.uk jessie/main Translation-en
Ign http://archive.raspberrypi.org jessie/ui Translation-en_GB
Ign http://mirror.ox.ac.uk jessie/non-free Translation-en_GB
Ign http://mirror.ox.ac.uk jessie/non-free Translation-en
Ign http://mirror.ox.ac.uk jessie/rpi Translation-en_GB
Ign http://archive.raspberrypi.org jessie/ui Translation-en
Ign http://mirror.ox.ac.uk jessie/rpi Translation-en
Ign http://download.mono-project.com wheezy/snapshots/4.8.1.0/main Translation-en_GB
Ign http://download.mono-project.com wheezy/snapshots/4.8.1.0/main Translation-en
Fetched 58.6 kB in 6s (8,748 B/s)
Reading package lists... Error!
W: Conflicting distribution: http://download.mono-project.com wheezy/snapshots/4.8.1.0 InRelease (expected wheezy/snapshots but got wheezy)
E: Encountered a section with no Package: header
E: Problem with MergeList /var/lib/dpkg/status
E: The package lists or status file could not be parsed or opened.

 

Any ideas?

Regards,

 

Bernd

Link to comment
Share on other sites

It seems like there might be a formatting issue with the line for the mono snapshot. 

I found this information which is very likely to be related after reading some of the comments it looks like they had a very similar issue: 

https://stackoverflow.com/questions/33763177/install-older-version-of-mono

Just to clip some of their content so you dont have to chase it down:

   
I thought it was going to work there, but I keep getting... W: Conflicting distribution: download.mono-project.com wheezy/snapshots/4.0.5.1 InRelease (expected wheezy/snapshots but got wheezy) – Buford T. Justice Nov 17 '15 at 23:08
2  
'deb download.mono-project.com/repo/debian wheezy/snapshots/4.0.5.1 main' needs to be 'deb download.mono-project.com/repo/debian wheezy/snapshots/4.0.5.1/. main' to make it work. Adding '/.' makes it work for whatever reason. – Buford T. Justice Nov 18 '15 at 7:57
1  
Related bug: bugzilla.xamarin.com/show_bug.cgi?id=24902, sometimes the adding of /. doesn't seem to work so you should try wheezy/snapshots 4.0.5.1/main. – Gerhard Burger Apr 18 '16 at 14:50
Link to comment
Share on other sites

Bernie V

Thx, I will look at it, but I'm having also a strange issue: everything I changed is reverted after reboot. So it isn't possible to delete /var/lib/emby-server/data/library.db of downgrade mono :huh: . After reboot everything is reverted. The volume isn't in readonly status. Is formatting the sd card the only solution?

Link to comment
Share on other sites

Bernie V

Everything I want to change is reverted after reboot (files changes, file deletions, installed apps, ...) If I remove mono and reboot then mono is back for example. If I delete the library.db it's back in it's original state after reboot.

Link to comment
Share on other sites

Bernie V

Can you give an example?

Some examples:

 If I remove mono and reboot then mono is back

 If I delete the library.db file and reboot then  it's back in it's original state

Link to comment
Share on other sites

For me sounds like a problem with your microsd. Back to the times I used rpi2 I had the problem very often. Check your SD card and try again.

 

Gesendet von meinem MHA-L29 mit Tapatalk

Link to comment
Share on other sites

  • 3 weeks later...
Bernie V

Hi guys, problem solved with another sd card.

I made an image of the old one and writed to the new sd card.

Thx for advice!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...