[SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
Hi guys, This to report about a weird issue I am having with SBS 7.4 and Trackstat (2.9). Ill try to be as brief as I can (!). I upgraded from 7.3.3 to 7.4. SBS rescanned the library all fine. I checked my prefs all there. Then I noticed additional plugins were off (I use several by Erland plus other stuff). I installed them, rebooted the server and it wouldnt boot up and the PC would stop responding. Checked Resource Manager and noticed that mysqld.exe had spiked up to 100% usage and got stuck there (first time I left it hanging there for about 15 minutes so I guess it was just stuck in a loop). So I killed mysqld.exe and the server aborted. Then I started it safe mode, disabled trackstat and everything went back to normal. I tried many, many different things but to make this short lets just say I went radical on the problem. I uninstalled everything, erased all prefs, erased all folders (so yes, I had to reconfigure all my devices from scratch!). Re-installed 7.4. I launched it but aborted first scan of the library (as default library is not the right one). I configured all the parameters, re-installed all the additional plug-ins (including trackstat), rebooted and everything was fine. All the plugins were there, everything was working. So I launch the main scan. While its scanning (I have about 23k songs so it takes a bit), I check and reconfigure all the plugins and prefs... no problems. But then, as soon as the scan is over, everything goes south again: mysqld.exe kicks in (as, I guess it should, after a rescan?) but gets stuck again at 100%. Stays there indefinitely (lets say more than 20 minutes). So I kill it, but this time the server doesnt shut down. I check the plugin setting page and trackstat is installed. I try using and it works! (I restored my old stats as well as trying inputting new ones). At thats pretty much where I am now. Whenever I perform any kind of rescan on the library or reboot SBS while trackstat is installed, Mysqld gets stuck and freezes the machine but now killing it doesnt prevent SBS from starting up successfully (and trackstat from working). Does anyone have any idea how I can fix this? -- AladdinSane AladdinSane's Profile: http://forums.slimdevices.com/member.php?userid=30923 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
I think it's a bug in TrackStat but I haven't had the time to look at it yet. As a temporary solution you can disable the refresh operations in TrackStat after rescans and startup, this is controlled by the "Startup refresh" and "Rescan refresh" options in the TrackStat settings page. The effect of this is that if a file is moved or renamed, you will loose the TrackStat statistics for that particular track. As long as you don't move or rename tracks you should be fine. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
I'm running Trackstat, and I've seen that the server (7.4) takes quite some time become available to start up and uses up a lot of PC resources while doing so. This may be related to this? In my case if you leave it the server eventually starts up (after some minutes). -- lrossouw 'Last.fm' (http://www.last.fm/user/lrossouw) lrossouw's Profile: http://forums.slimdevices.com/member.php?userid=3416 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
lrossouw;464927 Wrote: > I'm running Trackstat, and I've seen that the server (7.4) takes quite > some time become available to start up and uses up a lot of PC resources > while doing so. This may be related to this? > Yes, it's the same problem, TrackStat runs a refresh operation at startup to synchronize it's table with the Squeezebox Server database tables. At the moment there is a SQL statement in that refresh operation that's not optimized for some setups. I think the major problem is if you have a larger library because it works pretty good in my own setup. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
Aha, this sounds like this is my issue on iTunes9 that I reported in another thread. Is that the conclusion you are working to erland or had you not made the connection? CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4.0 for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
Hi Erland. Done what you said, everything's peachy now. Thanks. If you need logs or anything about this issue, just let me know. -- AladdinSane AladdinSane's Profile: http://forums.slimdevices.com/member.php?userid=30923 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
erland;464924 Wrote: > I think it's a bug in TrackStat but I haven't had the time to look at it > yet. As a temporary solution you can disable the refresh operations in > TrackStat after rescans and startup, this is controlled by the "Startup > refresh" and "Rescan refresh" options in the TrackStat settings page. Is there a way to manually do this without having access to the web interface? I have a large library and I have waited an hour or more for SS to start. Or is there a way of preventing SS from reinstalling the plugin (simply removing the plugin from the user cache does not work)? -- vagskal 2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng on iPod Touch, muso on remote computer running Win XP | 7.4.1 on Win XP vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
Hi Erland FYI I'm now getting similar symptoms to AlladinSane. I'm running SB Server 7.4 with Trackstat 2.9 and a library of about 20,000 tracks (but no iTunes). A few minutes after my daily Squeezebox re-scan starts, the MySQL process goes to 100% CPU utilisation and my Duet Controller can no longer connect to the SB Server. It stays this way for about 14 minutes, then everything returns to normal. The only other plugin I have installed is DynamicPlayList. Thanks for the temporary workaround to disable the refresh operations in TrackStat, which I'll try now. Best regards Peter G -- pg pg's Profile: http://forums.slimdevices.com/member.php?userid=19272 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
vagskal;465006 Wrote: > Is there a way to manually do this without having access to the web > interface? I have a large library and I have waited an hour or more for > SS to start. Or is there a way of preventing SS from reinstalling the > plugin (simply removing the plugin from the user cache does not work)? There's a parameter in the trackstat.prefs file for 'refresh_startup:' - try changing it to a zero ?? -- bonze TranquilPC T2-WHS-A3 - SqueezeCenter Version: 7.4.0 - 28660 3 x wireless SB3 + a Duet bonze's Profile: http://forums.slimdevices.com/member.php?userid=6150 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
bonze;465841 Wrote: > There's a parameter in the trackstat.prefs file for 'refresh_startup:' - > try changing it to a zero ?? Thanks! I found the parameter in the plugin.pm file and I think that fix did the trick. -- vagskal 2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng on iPod Touch, muso on remote computer running Win XP | 7.4.1 on Win XP vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
vagskal;465889 Wrote: > Thanks! I found the parameter in the plugin.pm file and I think that fix > did the trick. Do you have a little more detail? I have found the parameter in that file and I think I changed the first 1 to 0 but SBS still fails to start correctly? -- Blisteringblue 'What am I listening to?' (http://www.last.fm/user/blisteringblue) or 'Twitter Ramblings' (http://www.twitter.com/blisteringblue) Blisteringblue's Profile: http://forums.slimdevices.com/member.php?userid=22946 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
Blisteringblue;466289 Wrote: > Many thanks both of you, I've found it (missed it at first), SBS still > fails on port 9000 but it passes on 9090 so it starts !! > > Hopefully the full fix will be about soon. > > Even better, checked again and Port 9000 working too !! Good that you have found it. Perhaps a restart of the computer will make it work OK. I just wanted to mention that I in that file also disabled the default option to refresh after rescans since I do automatic rescans. When I tried to restore my old TrackStat data from a backup file, SBS (mysql) froze like before. I will have to wait for a fix from Erland until I restore the data. -- vagskal 2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng on iPod Touch, muso on remote computer running Win XP | 7.4.1 on Win XP vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SBS 7.4/Trackstat 2.9
vagskal;466298 Wrote: > Good that you have found it. Perhaps a restart of the computer will make > it work OK. I just wanted to mention that I in that file also disabled > the default option to refresh after rescans since I do automatic > rescans. > > When I tried to restore my old TrackStat data from a backup file, SBS > (mysql) froze like before. I will have to wait for a fix from Erland > until I restore the data. Yes, now you can get into the plugin settings I have disabled both rescan options. I've not tried a restore so I'll wait, just happy it starts up without another full reload. -- Blisteringblue 'What am I listening to?' (http://www.last.fm/user/blisteringblue) or 'Twitter Ramblings' (http://www.twitter.com/blisteringblue) Blisteringblue's Profile: http://forums.slimdevices.com/member.php?userid=22946 View this thread: http://forums.slimdevices.com/showthread.php?t=68869 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins