Bug 17207 - Artwork scanning fails when a clear & rescan has been initiated
: Artwork scanning fails when a clear & rescan has been initiated
Status: NEW
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.6.0
: PC Windows 7
: -- normal with 3 votes (vote)
: ---
Assigned To: Unassigned bug - please assign me!
http://forums.slimdevices.com/showthr...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-05-08 23:13 UTC by Dennis Mutsaers
Modified: 2011-11-06 23:24 UTC (History)
3 users (show)

See Also:
Category: ---


Attachments
scanning never ends... (28.82 KB, image/jpeg)
2011-05-09 08:55 UTC, Dennis Mutsaers
Details
No images in web ui after failed scanning (147.58 KB, image/jpeg)
2011-05-09 22:46 UTC, Dennis Mutsaers
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Mutsaers 2011-05-08 23:13:39 UTC
When running a clear & rescan all artwork is lost. A restart of Squeezebox Server does solve this problem.
The scanning statistics show scanning is running, but it says scanning has been finished.
The scanning log doesn't show an error when this happens, the server log does:

[11-05-09 06:25:17.9572] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: DBD::SQLite::st execute failed: database is locked at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/ArtworkCache.pm line 132.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0xa1c6ff4)

[11-05-09 06:25:18.2602] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: DBD::SQLite::st fetchrow_array failed: database is locked at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/ArtworkCache.pm line 134.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0x7a3f85c)
Comment 1 Dennis Mutsaers 2011-05-09 08:55:22 UTC
Created attachment 7267 [details]
scanning never ends...
Comment 2 Dennis Mutsaers 2011-05-09 22:37:23 UTC
Maybe a related error in scanner.log:

[11-05-10 06:13:26.9988] Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1305000513.37439-importer-precacheArtwork-3844-4027-",
]
[11-05-10 06:13:31.9989] Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Comment 3 Dennis Mutsaers 2011-05-09 22:46:17 UTC
Created attachment 7268 [details]
No images in web ui after failed scanning

No images in web ui after failed scanning (Or in squeezeplay, ipeng etc.)
Comment 4 Mickey Gee 2011-05-16 09:15:06 UTC
Please add comments if you are seeing this issue.
Comment 5 Dennis Mutsaers 2011-05-17 02:31:09 UTC
I'm experiencing this issue frequently... Is there something I can do to help?
Comment 6 Dennis Mutsaers 2011-05-30 11:21:05 UTC
I haven't seen this happening since the recent nightly builts, 23/05/2011, and later.
Comment 7 Dennis Mutsaers 2011-05-31 08:30:36 UTC
Spoke too soon, it happened again. Version: 7.6.0 - r32492
Comment 8 Dennis Mutsaers 2011-06-01 10:32:50 UTC
When the scanner is succesfull there are no 'failed' messages in the log...
Comment 9 Dennis Mutsaers 2011-06-02 22:45:19 UTC
Version: 7.6.0 - r32499: problems again.

scanner.log:
[11-06-03 06:10:27.3962] Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1307074085.16544-importer-precacheArtwork-1464-4095-",
]
[11-06-03 06:10:32.3994] Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout

server.log:
[11-06-03 06:10:22.3915] Slim::Utils::SQLiteHelper::_notifyFromScanner (579) Notify from scanner: progress:1307074085.16544-importer-precacheArtwork-1401-4095-
[11-06-03 06:10:22.8882] Slim::Web::Graphics::artworkRequest (83) Artwork request: html/images/Players/squeezebox3_250x250.png
[11-06-03 06:11:10.3056] Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: DBD::SQLite::st execute failed: database is locked at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/ArtworkCache.pm line 132.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0xe413434)
[11-06-03 06:11:10.3434] Slim::Utils::SQLiteHelper::_notifyFromScanner (579) Notify from scanner: progress:1307074085.16544-importer-precacheArtwork-1464-4095-
[11-06-03 06:11:10.3590] Slim::Utils::SQLiteHelper::_notifyFromScanner (579) Notify from scanner: progress:1307074085.16544-importer-precacheArtwork-1465-4095-

So if the problems occur there are failed messages in both scanner.log and server.log
Comment 10 Dennis Mutsaers 2011-06-11 09:09:56 UTC
A friend looked at my Squeezeboxserver the other day and noticed that all my album art showed red crosses. He immediately asked if by any chance I installed Squeezeboxserver 7.6...
Comment 11 Jim McAtee 2011-06-11 10:34:09 UTC
I think you're just seeing the results of the external scanner crashing before it gets to the point where it resizes and pre-caches artwork. Scanner crashes are being reported by the dozens in both 7.5.x and 7.6 beta.

If that's the case, then the bug here is that the server isn't able recover and serve images after the scanner crash. Pre-caching artwork isn't actually necessary, so you shouldn't have missing artwork when you browse the library.

Have you tried running any 'new & changed' scans after the 'clear & rescan' has failed? If not, try it.
Comment 12 Dennis Mutsaers 2011-06-11 23:13:14 UTC
Jim,

I think you're right, it's just the results of the external scanner crashing. However, on my computer (Windows 7, x64), this only happens in the 'Pre-Caching Artwork' stage.

I've tried running any 'new & changed' scan after the 'clear & rescan' has
failed, but this doesn't resolve the problems with the artwork. A simple reboot of the PC will resolve the problems with the artwork. (Without a rescan)
Comment 13 Dennis Mutsaers 2011-06-18 09:34:55 UTC
I think this bug is quite easy to reproduce: Just enable 'Rescan Music Library' and set the rescan type to "Clear library and rescan everything"
Comment 14 Dennis Mutsaers 2011-07-23 01:49:37 UTC
I hoped that with https://bugs-archive.lyrion.org/show_bug.cgi?id=17173 fixed, this problem would als be solved. I can confirm it hasn't been solved :-(
Comment 15 Dennis Mutsaers 2011-07-23 02:00:41 UTC
And still the same error messages:

Slim::Control::Request::notify (2079) Error: Failed notify: Can't call method "get" on an undefined value at C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SugarCube/Plugin.pm line 894.
Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: DBD::SQLite::st execute failed: database is locked at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/ArtworkCache.pm line 132.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0xcc4a7b4)
Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: DBD::SQLite::st fetchrow_array failed: database is locked at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/ArtworkCache.pm line 134.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0xca3a49c)
Comment 16 Dennis Mutsaers 2011-07-24 01:28:32 UTC
I think when the pc has been rebooted, the lock also has been removed. The strange thing is that all artwork has been restored after the reboot of the pc, without a new rescan.
Comment 17 Michael Herger 2011-07-25 09:17:37 UTC
Dennis - could you please try to reproduce this issue without any 3rd party plugin? I see that one of the conflicting calls comes from SugarCube.
Comment 18 Dennis Mutsaers 2011-07-26 00:22:29 UTC
That's what I noticed too. Removed my 3rd party plugins (Sugarcube & Trackstat). Guess what? No images again...
Comment 19 Dennis Mutsaers 2011-07-26 00:29:09 UTC
scanner log:
Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1311650684.01855-importer-precacheArtwork-879-4126-",
]
Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Slim::Music::Artwork::__ANON__ (508) Pre-caching artwork for In het Teken van de Ram from D:\Music\Astrid Nijgh\In het Teken van de Ram\cover.jpg
Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1311650684.01855-importer-precacheArtwork-880-4126-",
]
Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Slim::Music::Artwork::__ANON__ (508) Pre-caching artwork for Mensen Zijn Je Beste Vrienden from D:\Music\Astrid Nijgh\Mensen Zijn Je Beste Vrienden\cover.jpg
Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1311650684.01855-importer-precacheArtwork-881-4126-",
]
Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Slim::Music::Artwork::__ANON__ (508) Pre-caching artwork for Tegen Het Lijf from D:\Music\Astrid Nijgh\Tegen Het Lijf\cover.jpg
Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1311650684.01855-importer-precacheArtwork-882-4126-",
]
Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Slim::Music::Artwork::__ANON__ (508) Pre-caching artwork for Waterfall from D:\Music\Atlantic Ocean\Waterfall\cover.jpg
Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1311650684.01855-importer-precacheArtwork-883-4126-",
]
Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Slim::Music::Artwork::__ANON__ (508) Pre-caching artwork for Exotic Robotics: Pleasure141x from D:\Music\Atmospherex\Exotic Robotics; Pleasure141x\cover.jpg
Slim::Utils::SQLiteHelper::updateProgress (500) Notify to server: [
  "progress:1311650684.01855-importer-precacheArtwork-884-4126-",
]
Slim::Utils::SQLiteHelper::updateProgress (516) Notify to server failed: 500 read timeout
Comment 20 Dennis Mutsaers 2011-07-26 00:38:03 UTC
server log:
Slim::Networking::IO::Select::__ANON__ (147) Error: Select task failed calling Slim::Web::HTTP::processHTTP: DBD::SQLite::st fetchrow_array failed: database is locked at /<C:\PROGRA~2\SQUEEZ~1\server\SqueezeSvr.exe>Slim/Utils/ArtworkCache.pm line 134.
; fh=Slim::Web::HTTP::ClientConn=GLOB(0xb275164)
Comment 21 Dennis Mutsaers 2011-07-26 00:46:00 UTC
I only need to stop & start the Squeezebox Server service to correct the problem. Not the PC, as I initionally thought.
Comment 22 Michael Herger 2011-07-26 05:44:20 UTC
When this happens, are you doing anything with SBS, eg. browse the collection? Or does it happen even if you don't touch it?
Comment 23 Dennis Mutsaers 2011-07-26 07:47:28 UTC
I've scheduled a daily clear & rescan at 05:00 am in the morning, so normally I'm not doing anything :-).

It doesn't happen each and every time. Sometimes it works for several days in a row. I think it fails ever 2 out of 3 times.
Comment 24 Dennis Mutsaers 2011-07-26 12:41:00 UTC
Other user with same problem?
http://forums.slimdevices.com/showthread.php?p=643261#post643261
Comment 25 Dennis Mutsaers 2011-07-27 07:12:48 UTC
and:
http://forums.slimdevices.com/showthread.php?t=89045
Comment 26 Erland Isaksson 2011-08-11 14:19:08 UTC
Has anyone with this problem tried if it works correctly in the 7.6.1 nightly beta build ?
Comment 27 Dennis Mutsaers 2011-08-12 01:56:14 UTC
I've seen it once last week, but it used to happen almost every day (during my daile clear & rescan schedule). I wouldn't call it fixed, but it happens not as often anymore.
Comment 28 Ronald D. Morley 2011-09-07 12:40:28 UTC
*** This bug has been confirmed by popular vote. ***
Comment 29 Michael Herger 2011-09-07 23:25:52 UTC
Ronald, Dennis - could you please re-test with the latest 7.6.2 nightly build? There have been more fixes which might be related to this issue.
Comment 30 Dennis Mutsaers 2011-09-08 10:16:08 UTC
This week I've switched from Squeezeboxserver 7.6.2 to Logitech Media Server 7.7. I haven't experienced this issue since the last time I replied here. I normally install nightlies when they're released.
Comment 31 Alan Young 2011-11-06 23:24:01 UTC
Unassigned bugs cannot have a priority.