Bugzilla – Bug 1641
windows service crashes when browsing album then artists
Last modified: 2008-09-15 14:36:01 UTC
I have a consistent repro at home using my setup to crash the 6.0.2 slimserver windows service. The majority of my songs are WMA. I ripped them from my own CDs or purchased them from allofmp3.com. Repro steps (consistent): 1. startup slimserver 2. open web interface at http://localhost:9000/ 3. open mp3 stream at http://localhost:9000/stream.mp3 4. in the web interface left pane, click "New Music" from the home page 5. in left pane, click the play now arrow to the right of "The Emancipation of Mimi (2005)" 6. in right pane, click "Snoop Dogg" which is listed as one of the artists on track 5 Say Somethin' 7. in left pane, click "R&G - Rhythm and Gangster: The Masterpiece (2004)" Result: The windows server crashes. The event log has an event in the application log with the following description: The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Can't update www.allofmp3.com: DBD::SQLite::st execute failed: column url is not unique(1) at dbdimp.c line 401 at C:\Program Files\SlimServer\server\CPAN/DBIx/ContextualFetch.pm line 51. at /PerlApp/Slim/DataStores/DBI/DBIStore.pm line 1387 . As possible useful info... a) All the songs in both the albums "The Emancipation of Mimi (2005)" and "R&G - Rhythm and Gangster: The Masterpiece (2004)" are WMA files and have a property named "Comments" which all have the value "www.allofmp3.com"
can you attach one of those files from the album that causes the crash?
Created attachment 535 [details] possible file causing crash Here is one of the files which is from the "R&G - Rhythm and Gangster- The Masterpiece" directory containing all the album's songs.
I'm not able to reproduce the crash using 6.0.2 or 6.1. Are you running any third party plugins? Can you run the server from command line with the --diag --d_info options?
Created attachment 536 [details] debug logfile capturing crash No 3rd party plugins. Just what slimserver 6.0.2 installed. I made a logfile using the params you asked for and repro'd the crash.
I sitll can't reproduce this myself. however, the log looks like its scanning and adding the file information. A full wipe cache may help, and possibly isn't an issue with 6.1 builds.
Dan: did you see this log? There's some interesting DB stuff in there...
the crash error is one that I've seen a few times before. the 'column url' was one of the first crashes I found when I started using the 6.0 test versions. These were cleared up long ago, which is why I'm stumped on why it might still happen when it seems fine with my setup. I also don't understand why where is so much updating when simply playing tracks.
Moving this to post 6.1, as we've not been able to reproduce.
Dale - can you try one of the 6.2 nightlies and let us know if this is still happening for you? Thanks.
I d/d and installed SlimServer_v2005-08-16.exe. Server settings show: SlimServer Version: 6.2b1 - 3981 - Windows XP - EN - cp1252 I can no longer repro the problem using the repro steps described. In addition, the nightly rescans of the music folder also no longer crash the server. Wahoo!
It is reproing in 6.2.1 in the nightly rescans. In server settings/plugins, I have the rescan plugin set to run at 3am. When I look at the NT app event log, I am seeing the scan error message I originally reported. That exact dbdimp.c line 401 error.
the column url problem should be fixed in 6.2.2 nightlies fairly recently. Have you tried those?
I've been running 6.2.2 v2005-12-21 since 22 Dec. No repro of this problem. I'm able to uninstall and install 6.2.2 v2006-01-13.
Ok - I'm going to close this then. Thanks.