Bugzilla – Bug 10177
Problems with A LOT of data (I have more that 200 000 mp3 files; jingels etc.)
Last modified: 2009-07-15 12:45:35 UTC
This problem occured after I uploaded all my Jingels and music-files to the QNAP NAS. This is Turbo NAS 409 Pro. I do not know if the software has some limit on numbers of artist and tracks? I do not get the coverart to work; but this is not important. I also think to change to a ordinary Linux PC with 2GB RAM to increase the performance. But I want to know that this will work; even if it is slow for now. I do need good performance in my job since I use this as a library for jingels and other comercial tunes. Thanks for your time and effort :) Best regards Audun [08-11-28 20:04:32 ] ssctrl Stopping SqueezeCenter 7.2.1-23630. mDNSResponderPosix: Error reading service file /volume1/SqueezeCenter/Cache/mDNS.conf mDNSResponderPosix: Error reading service file /volume1/SqueezeCenter/Cache/mDNS.conf mDNSResponderPosix: Error reading service file /volume1/SqueezeCenter/Cache/mDNS.conf mDNSResponderPosix: Error reading service file /volume1/SqueezeCenter/Cache/mDNS.conf mDNSResponderPosix: Error reading service file /volume1/SqueezeCenter/Cache/mDNS.conf [08-11-28 20:05:03 ] ssctrl Error while stopping SqueezeCenter. [08-11-30 11:33:04 ] ssctrl Starting SqueezeCenter 7.2.1-23630. [08-11-30 11:33:08 ] ssctrl Command line = /volume1/SSODS/sbin/start-stop-daemon --start --chuid ssods --nicelevel -5 --exec /volume1/SSODS/bin/perl -- /volume1/SqueezeCenter/slimserver.pl --daemon --pidfile /volume1/SqueezeCenter/Cache/squeezecenter.pid --cachedir /volume1/SqueezeCenter/Cache --logdir /volume1/SqueezeCenter/Logs --prefsdir /volume1/SqueezeCenter/prefs --noupnp --httpport 9001 [08-11-30 11:33:33 ] ssctrl SqueezeCenter started. [08-11-30 11:34:03.7261] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable FROM albums me JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable ORDER BY concat('0', contributor.namesort),concat('0', me.titlesort),me.disc LIMIT 14988': DBD::mysql::st execute failed: Error writing file '/tmp/MYswhZbh' (Errcode: 28) at /share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-11-30 11:34:03.7352] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/share/MD0_DATA/SqueezeCenter/Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 3: DBIx::Class::Storage::DBI::_select (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 4: DBIx::Class::Storage::DBI::Cursor::next (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Cursor.pm line 69) frame 5: DBIx::Class::Cursor::all (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 115) frame 6: DBIx::Class::Storage::DBI::Cursor::all (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/ResultSet.pm line 945) frame 7: DBIx::Class::ResultSet::all (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/ResultSet.pm line 143) frame 8: DBIx::Class::ResultSet::search (/share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/ResultSet.pm line 659) frame 9: DBIx::Class::ResultSet::slice (/share/MD0_DATA/SqueezeCenter/Slim/Control/Queries.pm line 388) frame 10: Slim::Control::Queries::albumsQuery (/share/MD0_DATA/SqueezeCenter/Slim/Control/Request.pm line 1884) frame 11: (eval) (/share/MD0_DATA/SqueezeCenter/Slim/Control/Request.pm line 1884) frame 12: Slim::Control::Request::execute (/share/MD0_DATA/SqueezeCenter/Slim/Control/Request.pm line 867) frame 13: Slim::Control::Request::executeRequest (/share/MD0_DATA/SqueezeCenter/Slim/Control/Jive.pm line 191) frame 14: Slim::Control::Jive::buildCaches (/share/MD0_DATA/SqueezeCenter/Slim/Control/Jive.pm line 176) frame 15: Slim::Control::Jive::init (/volume1/SqueezeCenter/slimserver.pl line 433) frame 16: main::init (/volume1/SqueezeCenter/slimserver.pl line 479) frame 17: main::main (/volume1/SqueezeCenter/slimserver.pl line 1043) [08-11-30 11:34:03.7425] Slim::Control::Request::execute (1888) Error: While trying to run function coderef [Slim::Control::Queries::albumsQuery]: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable FROM albums me JOIN contributors contributor ON ( contributor.id = me.contributor ) GROUP BY me.id, me.artwork, me.title, contributor.name, contributor.namesort, me.titlesort, me.musicmagic_mixable ORDER BY concat('0', contributor.namesort),concat('0', me.titlesort),me.disc LIMIT 14988': DBD::mysql::st execute failed: Error writing file '/tmp/MYswhZbh' (Errcode: 28) at /share/MD0_DATA/SqueezeCenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. ] mDNSResponder: Note: DNS Server 192.168.0.1 for domain . registered more than once mDNSResponder: Note: DNS Server 192.168.0.1 for domain . registered more than once mDNSResponder: Note: DNS Server 192.168.0.1 for domain . registered more than once mDNSResponderPosix: Error reading service file /volume1/SqueezeCenter/Cache/mDNS.conf
Are you running out of disk space on the partition hosting /tmp?
I have at least 3 terra left on my raid, so that should not be the problem. I am trying to check if /tmp is mounted on a RAM disk with some kind of size restrictions. (I am not too familiar with this Linux, but I have submitted question about this to QNAP.) Or if there is some permissions that is wrong; but since it have been working fine 1000 tracks; I was wondering if the tmp file is VERY large or it might be as you suggest; too little space on the /tmp area. Some system/log info: System Hard-/Firmware : QNAP TurboStation TS-409 / 2.1.2 build 1031T Load / Uptime : 2.54 1.90 1.54 / 0d 02.44:32 (39% idle) Memory -- Swap : 247/250 MB (shr: 0, buf: 12, cache: 47, rss: 188) -- 8/518 MB SqueezeCenter Version : 7.2.1-23630 Process status : PID 3116, state D (disk sleep) Memory usage : 59 MB total, 51 MB (87%) RSS Uptime : 00:49, 00:10 (20.4%) CPU time Extra args : --httpport 9001 SSODS/SC flags : autostart noupnp nice(-5) MySQL Version : 5.0.27-log Database size : 478M Process status : PID 3139, state S (sleeping) Memory usage : 43 MB total, 21 MB (49%) RSS
I'm not sure if /tmp is a ram disk. But it is probably a rather small partition. You can try to use the mysqld that comes with SSODS instead of the one that is comes with the TS firmware (which I guess is the one SSOTS is using). See the following excerpt from the SSODS FAQ at http://oinkzwurgl.org/ssods_faq. «The MySQL server binary on the DS is in an unusual location. The link $SSODSDIR/bin/mysqld points to this location and SC finds it in the $PATH. SSODS comes with a (unsupported) mysqld binary in $SSODSDIR/libexec/mysql that can be used instead. Users wishing to do so can adjust the link in $SSODSDIR/bin accordingly.»
Edit: the mysqld binary in SSODS would probably use the /volume1/SSODS/var/tmp directory instead of /tmp. Maybe this is configurable in my.cnf and the my.tt template for this that comes with SC, respectively.
Please try the suggestions above