[Solved] SQLiteException during library scan

[UU3 0]

If you update to "FreeNAS-Corral-MASTER-201704112014" or any update after 04/11/2017 it should be fixed!

 

OS: FreeNAS-Corral-RELEASE

Running Boot2Docker 1.12.3 - 4 CPU - 12GB Ram /w alot of free disk space running docker container "emby/embyserver" Created At 2017-03-18 15:07:12

mnt on /media type 9p (rw,relatime,dirsync,version=9p2000.L,trans=virtio,cache=mmap,msize=512000)

 

I've tried both the freenas/emby and emby/embyserver docker containers, and they both run into the same sql issue. I created a VM and passed through the same configs and media it works just fine.

 

Once the error is thrown at around like 900 the media libraries will no longer be listed on the sidebar, and the home page is blank until emby has been restarted. It processed about 404 shows out of 2k and the "Scan media library Failed after" has ranged from 4min to 46 minutes and was never fully scanned in 1 go, and If you re-scan it will throw a "Scan media library Failed" after a few seconds and it will fail until you restart.

 

Edit:

 

Here is a freenas thread with the same error "Protocol: locking protocol" https://forums.freenas.org/index.php?threads/emby-container-keeps-crashing.49593/ (unlike the thread my container/host is not crashing)

 

server-63625739986.txt

Edited April 20, 2017 by UU3

[Happy2Play 9780]

First time seeing this "Protocol: locking protocol" error.  What is your folder structure?

[UU3 0]

First time seeing this "Protocol: locking protocol" error.  What is your folder structure?

 

what kind of folder structure are we talking about?

[Happy2Play 9780]

You show you mount as folder called /media, how is the media structured in that folder?

 

example

/media/movie x/movie x.ext

/media/show/season/episode s01e01.ext

[UU3 0]

You show you mount as folder called /media, how is the media structured in that folder?

 

example

/media/movie x/movie x.ext

/media/show/season/episode s01e01.ext

 

 

/media/Series Name/Season #/series_name - S##E## - Title.ext

/media/Series Name/Season #/series_name - S##E##.ext

/media/Series Name/Season #/series_name - S##E## - Title [release group][hash].ext

(With or without S##)

Edited March 22, 2017 by UU3

[Luke 42077]

I haven't seen that error before either. Here is the what the Sqlite documentation says about it:

SQLITE_PROTOCOL

This value is returned if some other process is messing with file locks and has violated the file locking protocol that SQLite uses on its rollback journal files.

[UU3 0]

 

I haven't seen that error before either. Here is the what the Sqlite documentation says about it:

SQLITE_PROTOCOL

This value is returned if some other process is messing with file locks and has violated the file locking protocol that SQLite uses on its rollback journal files.

 

Understood, I will make a bug report with FreeNAS.

 

Do you know what is the problem file? library.db?

Edited March 22, 2017 by UU3

[UU3 0]

Luke here was one fix implemented Issue fix in one software. Could this be used to fix the issue, by checking for SQLITE_BUSY or SQLITE_PROTOCOL ?

Edited March 22, 2017 by UU3

[UU3 0]

Update: Working on the issue on FreeNAS 10 Volumes with Chris Torek Updating to 10.0.2 partially fixed the issue (It would run longer I believe) but it is a SQLite or file locking issue via 9p volumes. I will mark this as solved and update main post when fixed.

You can find the progress "Bug #22601: Emby VM & Docker SQLite error when using volumes" there.

Edited March 24, 2017 by UU3

[Luke 42077]

Thanks for the info !

[UU3 0]

If you update to "FreeNAS-Corral-MASTER-201704112014" or any update after 04/11/2017 it should be fixed!

[Luke 42077]

Thanks for the info !