vagskal;564409 Wrote: > Sorry, Erland, to disturb you again. > > After a clear library and rescan I started a CustomTag scan again and > this time there are a lot of error messages in the information level > log (attached). Maybe they can tell you something. This is on the new > PC (where the last CustomTag scan took 36 hrs compared to the 2 hrs it > took on the old PC; a standard scan is considerably faster on the new > PC than on the old PC). The CustomTag scan is still in progress after > some 7 hrs. >
There was a lots of errors in that log, so I'm not really sure where to start. If the logs looks like this log file, my experience is that the system isn't working very well. 1. >From all the "Illegal mix of collations" error you have in the log, I suspect you have hit the following bug: http://bugs.slimdevices.com/show_bug.cgi?id=15116 If you keep getting this after SBS restart I'd try changing to English as user interface language in SBS Settings to see if the server starts without these errors. If you continue to get the illegal mix of collations error at startup nothing is going to work with my plugins when you are browsing or generating playlists. The Custom Scan data might possibly work in some cases because it's mostly joined using integer keys, but if you get this with TrackStat none of the queries using TrackStat data is going to work. 2. The "Converting customscan_track_attributes to correct charset=utf8 collate=utf8_swedish_ci" message indicates that it's converting the character set in the database, basically it tries to fix the "illegal mix of collations" problem. Normally it should only need to do this when the tables are empty and then it should be really fast. However, if I remember correctly, due to the above mentioned bug the database can actually change collate when used if you change the language setting. So if you change the language when the tables are filled with data, it's probably going to take some time to do the conversion, still an hour for converting some characters still sounds a bit much. The good news is that as long as you haven't hit the bug in 1, it's only going to happen once, after it has been converted it shouldn't need to convert them at the next startup. 3. There was some "Can't connect to MySQL server on '127.0.0.1' " errors in the log, this indicates that something is wrong with the MySQL database. Either it's very busy or it hasn't started successfully. I've no idea why unless it's caused by the conversion in point 2 above. 4. Errors like this: "Can't create table '.\slimserver\#sql-4f0_2.frm' (errno: 121)" Typically means that the disk is full or there are some antivirus software which isn't configured to ignore the MySQL files. 5. Errors like this: "Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /<C:\Program\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Track.pm line 248" Is generally bad since it means that there are duplicate rows in the database, I suspect it's caused if you run parallel works that's supposed to be serialized. I think there are checks to avoid this in most places but I know some users have reported there problems with TrackStat so it might be possible to run duplicate restore operations or something similar in TrackStat. For the TrackStat tables you can usually, take a backup of the TrackStat data, in the TrackStat interface select to delete all data and finally restore the backup to get rid of this problem. If the problem is related to the Custom Scan data, it will probably disappear after you have done the next rescan. -- erland Erland Isaksson ('My homepage' (http://erland.isaksson.info)) (Developer of 'many plugins/applets' (http://wiki.slimdevices.com/index.php/User:Erland). If my answer helped you and you like to encourage future presence on this forum and/or third party plugin/applet development, 'donations are always appreciated' (http://erland.isaksson.info/donate)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
