Re: [slim] SC Hangs Trying to List a Folder
Brilliant! That did it for me! Thank you so very much, hickinbottoms. -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
1. ext3 2. no, I don't believe I've made any mods to my my.conf. See below... 3. x86 4. It seems that I can browse by genre, artist, etc just fine. I'm betting that I don't have all my music in the db, but what is there is findable in this way. Code: # /etc/mysql/my.cnf: The global mysql configuration file. # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1,v 1.3 2006/05/05 19:51:40 chtekk Exp $ # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket= /var/run/mysqld/mysqld.sock [mysql] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqladmin] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlcheck] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqldump] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlimport] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlshow] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [myisamchk] character-sets-dir=/usr/share/mysql/charsets [myisampack] character-sets-dir=/usr/share/mysql/charsets # use [safe_mysqld] with mysql-3 [mysqld_safe] err-log = /var/log/mysql/mysql.err # add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations [mysqld] character-set-server = utf8 default-character-set = utf8 user = mysql port = 3306 socket= /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid log-error = /var/log/mysql/mysqld.err basedir = /usr datadir = /var/lib/mysql skip-locking key_buffer= 16M max_allowed_packet= 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M language = /usr/share/mysql/english # security: # using localhost in connects uses sockets by default # skip-networking #bind-address = 127.0.0.1 log-bin server-id = 1 # point the following paths to different dedicated disks tmpdir= /tmp/ #log-update = /path-to-dedicated-directory/hostname # you need the debug USE flag enabled to use the following directives, # if needed, uncomment them, start the server and issue # #tail -f /tmp/mysqld.sql /tmp/mysqld.trace # this will show you *exactly* what's happening in your server ;) #log = /tmp/mysqld.sql #gdb #debug= d:t:i:o,/tmp/mysqld.trace #one-thread # uncomment the following directives if you are using BDB tables #bdb_cache_size = 4M #bdb_max_lock = 1 # the following is the InnoDB configuration # if you wish to disable innodb instead # uncomment just the next line #skip-innodb # # the rest of the innodb config follows: # don't eat too much memory, we're trying to be safe on 64Mb boxes # you might want to bump this up a bit on boxes with more RAM innodb_buffer_pool_size = 16M # this is the default, increase it if you have lots of tables innodb_additional_mem_pool_size = 2M # # i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-( # and upstream wants things to be under /var/lib/mysql/, so that's the route # we have to take for the moment #innodb_data_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ #innodb_log_group_home_dir= /var/lib/mysql/ # you may wish to change this size to be more suitable for your system # the max is there to avoid run-away growth on your machine innodb_data_file_path = ibdata1:10M:autoextend:max:128M # we keep this at around 25% of of innodb_buffer_pool_size # sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) innodb_log_file_size = 5M # this is the default, increase it if you have very large transactions going on innodb_log_buffer_size = 8M # this is the default and won't hurt you # you
Re: [slim] SC Hangs Trying to List a Folder
Code: $ mysql --version mysql Ver 14.12 Distrib 5.0.60, for pc-linux-gnu (i686) using readline 5.2 I commented out the line log-bin and restarted mysql/squeezecenter, but it doesn't seem to have helped... Code: [08-08-25 17:42:25.3111] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'INSERT INTO tracks (content_typ e, filesize, remote, timestamp, title, titlesearch, titlesort, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::s t execute failed: The table 'tracks' is full at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-08-25 17:42:25.3451] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 788) frame 3: DBIx::Class::Storage::DBI::insert (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 75) frame 4: DBIx::Class::Row::insert (/usr/share/squeezecenter/CPAN/DBIx/Class/PK/Auto.pm line 43) frame 5: DBIx::Class::PK::Auto::insert (/usr/share/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 1335) frame 6: DBIx::Class::ResultSet::create (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 931) frame 7: Slim::Schema::newTrack (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 1147) frame 8: Slim::Schema::updateOrCreate (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema.pm line 770) frame 9: Slim::Schema::objectForUrl (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Schema/ResultSet/Track.pm line 100) frame 10: Slim::Schema::ResultSet::Track::objectForUrl (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Web/Pages/BrowseTree.pm lin e 115) frame 11: Slim::Web::Pages::BrowseTree::browsetree (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Web/HTTP.pm line 1073) frame 12: Slim::Web::HTTP::generateHTTPResponse (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Web/HTTP.pm line 941) frame 13: Slim::Web::HTTP::processURL (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Web/HTTP.pm line 752) frame 14: Slim::Web::HTTP::processHTTP (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Networking/IO/Select.pm line 248) frame 15: (eval) (/usr/lib/perl5/vendor_perl/5.8.8/Slim/Networking/IO/Select.pm line 248) frame 16: Slim::Networking::IO::Select::select (/usr/sbin/squeezecenter-server line 514) frame 17: main::idle (/usr/sbin/squeezecenter-server line 464) frame 18: main::main (/usr/sbin/squeezecenter-server line 1026) [08-08-25 17:42:25.3462] Slim::Networking::IO::Select::select (250) Error: Select task failed: Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (content_type, filesize, remote, timestamp, title, titlesearch, titlesort, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: The table 'tracks' is full at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
It's 7.1.0 ... and I'd really rather find the source of the issue and possibly lead hickinsbottoms to a fix. -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
I'd love a tip on this one... I'm basically not using my Squeezebox since I upgraded the SqueezeCenter/firmware . . . -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
Did a full rescan last night. I still have the same problem this morning. Here's the output hickinbottoms requested: therver mysql # df -h . FilesystemSize Used Avail Use% Mounted on /dev/hda3 12G 6.0G 4.5G 57% / therver mysql # du -hs squeezecenter/ 224Ksqueezecenter/ therver mysql # ls -lh . total 242M drwx-- 2 mysql mysql 4.0K Sep 17 2007 ampache drwx-- 2 mysql mysql 4.0K Jun 20 2007 aoss_development -rw-rw 1 mysql mysql 5.0M Aug 22 08:07 ib_logfile0 -rw-rw 1 mysql mysql 5.0M Aug 21 23:29 ib_logfile1 -rw-rw 1 mysql mysql 128M Aug 22 08:07 ibdata1 drwx-- 2 mysql root 4.0K Apr 22 2007 mysql -rw-rw 1 mysql mysql 2.0K Aug 10 20:05 mysqld-bin.01 -rw-rw 1 mysql mysql 104M Aug 21 23:30 mysqld-bin.02 -rw-rw 1 mysql mysql 2.3K Aug 12 21:29 mysqld-bin.03 -rw-rw 1 mysql mysql 607K Aug 12 21:29 mysqld-bin.04 -rw-rw 1 mysql mysql 80 Aug 12 21:29 mysqld-bin.index drwx-- 2 mysql mysql 12K Aug 12 21:41 mythconverg drwx-- 2 mysql mysql 12K Jun 14 2007 rose3 drwx-- 2 mysql mysql 4.0K Aug 21 23:16 squeezecenter drwx-- 2 mysql root 4.0K Aug 12 21:29 test drwx-- 2 mysql mysql 4.0K May 25 14:14 threadbox drwx-- 2 mysql mysql 4.0K May 6 2007 torrentflux therver mysql # ls -lh squeezecenter/ total 220K -rw-rw 1 mysql mysql 9.0K Aug 11 19:09 albums.frm -rw-rw 1 mysql mysql 8.5K Aug 11 19:09 comments.frm -rw-rw 1 mysql mysql 8.5K Aug 11 19:09 contributor_album.frm -rw-rw 1 mysql mysql 8.5K Aug 11 19:09 contributor_track.frm -rw-rw 1 mysql mysql 8.7K Aug 11 19:09 contributors.frm -rw-rw 1 mysql mysql 61 Aug 11 19:03 db.opt -rw-rw 1 mysql mysql 385 Aug 11 19:04 dbix_migration.MYD -rw-rw 1 mysql mysql 2.0K Aug 12 21:04 dbix_migration.MYI -rw-rw 1 mysql mysql 8.4K Aug 11 19:04 dbix_migration.frm -rw-rw 1 mysql mysql 8.4K Aug 11 19:09 genre_track.frm -rw-rw 1 mysql mysql 8.6K Aug 11 19:09 genres.frm -rw-rw 1 mysql mysql 8.4K Aug 11 19:04 metainformation.frm -rw-rw 1 mysql mysql 8.5K Aug 11 19:09 playlist_track.frm -rw-rw 1 mysql mysql 8.5K Aug 11 19:09 pluginversion.frm -rw-rw 1 mysql mysql 8.7K Aug 11 19:04 progress.frm -rw-rw 1 mysql mysql 8.6K Aug 11 19:04 rescans.frm -rw-rw 1 mysql mysql 14K Aug 11 19:09 tracks.frm -rw-rw 1 mysql mysql 8.7K Aug 11 19:04 tracks_persistent.frm -rw-rw 1 mysql mysql 8.5K Aug 11 19:09 unreadable_tracks.frm -rw-rw 1 mysql mysql 8.4K Aug 11 19:09 years.frm therver mysql # -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
Also, to answer radish's question, it appears that I have 47078 tracks. Code: [EMAIL PROTECTED] /storage/music $ find ./ | egrep -i '(mp3|ogg|flac)$' | wc 47078 334415 4453774 -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
[slim] SC Hangs Trying to List a Folder
I'm just trying to browse the bare files/dirs in my collection with the Music Folder feature. My main folder has a bunch of folders - genre names. That main one and some of the folders within it load up fine, but many of them do not! My browser just hangs, waiting for the server to respond. I've waited several minutes, and I get no response. I have this problem on a folder with only one album in it as well... so it's not like it's trying to stat a zillion files or anything. (Although my collection as a whole is quite large.) Anyone have any suggestions? Thanks in advance! Adam -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
::Select::select (/usr/sbin/squeezecenter-server line 514) frame 17: main::idle (/usr/sbin/squeezecenter-server line 464) frame 18: main::main (/usr/sbin/squeezecenter-server line 1026) [08-08-21 18:53:09.1257] Slim::Networking::IO::Select::select (250) Error: Select task failed: Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (content_type, filesize, remote, timestamp, title, titlesearch, titlesort, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: The table 'tracks' is full at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. -- thread thread's Profile: http://forums.slimdevices.com/member.php?userid=19498 View this thread: http://forums.slimdevices.com/showthread.php?t=51351 ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
