Bug 3406 - Change to "Group Disks" kills server
: Change to "Group Disks" kills server
Status: RESOLVED WORKSFORME
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.2.2
: PC Other
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-05-11 07:06 UTC by waf land
Modified: 2008-09-15 14:39 UTC (History)
4 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description waf land 2006-05-11 07:06:18 UTC
When I try to change the "Group Disks" setting to "Treat multi-disk sets as a single item",  I get a "error loading postback: 12031" message,  and the server quits.     I can restart the server, but still with the "Treat multi-disk sets as a multiple items"  default.   

My setup: using iTunes music library,  12GB,  about 100 albums.   About a dozen albums are multi-disk sets (mostly operas),  and it would really be nice to have just one entry in the albums list for these.   I've gone through the iTunes library to make sure the multi-disk album names and disk numbering are correct and consistent.   The problem is repeatable.
Comment 1 KDF 2006-05-11 08:57:41 UTC
Is this with Default2 or Exbrowse3 skins?  both of those skins are currently out of date.  You could temporarily override the skin choice: http://server:9000/default/  and change the pref there.
Comment 2 waf land 2006-05-11 12:49:17 UTC
(In reply to comment #1)
> Is this with Default2 or Exbrowse3 skins?  both of those skins are currently
> out of date.  You could temporarily override the skin choice:
> http://server:9000/default/  and change the pref there.


Thanks -- I was using Default2,  and switching to Default eliminated the "error loading postback 12031" message.   But the underlying problem is still there:  any attempt to change the "Group Disk" setting results in the server stopping and the local server web page "not available".   Same thing happens with both IE and Firefox -- it's not browser dependent.

I was able to get a work-around by temporarily setting "Do not use iTunes",  then setting Group Disks, then resetting "use iTunes" and doing a full library rescan.    So now I have single entries for my multi-disk albums.   
Comment 3 KDF 2006-05-11 13:05:56 UTC
can you check the log, or the windows event viewer for the message involved in stopping the server (slim.exe)

for your workaround, look for slimserver.pref, and edit the line "groupdiscs: 0" and change to "groupdiscs: 1"

Comment 4 waf land 2006-05-11 19:17:01 UTC
(In reply to comment #3)
> can you check the log, or the windows event viewer for the message involved in
> stopping the server (slim.exe)

When the server stops,  windows event viewer shows the following application error:  

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: DBD::SQLite::db prepare_cached failed: no such table: tracks(1) at dbdimp.c line 268 at /PerlApp/Ima/DBI.pm line 391.
.


I enabled d_server and d_sql logging,  but nothing shows up in the SlimServer log.   I'm willing to try other logging options if it would help.

Comment 5 KDF 2006-05-12 22:33:55 UTC
I can't explain the error exactly, but instinctively it seems that the "tracks" table should exist.  Perhaps try to find the slimserversql.db file and delete it.  This will force a rescan when you restart the server (so be aware of the time committment if you aren't up for it).  

I've cc'd dan, who usually has all the answers for a db crash such as this.  He will be away for the next 10 days, however.
Comment 6 Dan Sully 2006-06-08 13:18:44 UTC
Is this still an issue with the 6.2.2 release or the 6.3 nightlies?

As kdf suggested, try removing the slimserversql.db file and let the server rescan.

Thanks.
Comment 7 Blackketter Dean 2006-06-20 11:35:05 UTC
chris to reproduce
Comment 8 Ross Levine 2006-06-22 16:16:04 UTC
SlimServer Version: 6.3.0 - 8099 - Windows XP - EN - cp1252

I wasn't able to reproduce this with 6.3.0. Could this have anything to do with bug 3254?
Comment 9 Chris Owens 2006-06-22 16:20:12 UTC
wafland, are you willing to try the 6.3 nightly from http://www.slimdevices.com/dev_nightly.html to see if you continue to get the problem?  It's quite stable at this point, and it should be released in the very near future.
Comment 10 Chris Owens 2006-06-23 13:53:09 UTC
Changing the target to 6.5 so this doesn't hold up the 6.3 release.
Comment 11 Dan Sully 2006-07-23 18:46:31 UTC
Is this an issue with the latest 6.5 nightlies?

Thanks
Comment 12 Dan Sully 2006-07-25 23:00:39 UTC
This does not appear to be a problem in 6.5

Please reopen if you can reproduce.

Thanks