Re: [slim] SC Hangs Trying to List a Folder
Could you try editing your my.cnf again? You can but the log-bin back in, but could you change the line: innodb_data_file_path = ibdata1:10M:autoextend:max:128M to: innodb_data_file_path = ibdata1:10M:autoextend:max:256M (ie increase the 'max' part). I think the problem may be that the InnoDB tablespace limit has been hit. Stuart thread wrote: 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... snip ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
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
No problem - sorry it took a few goes to narrow it down. You can remove the max:??? bit of that line altogether so the size is unlimited if you're worried about not remembering what the problem was next time. I'm not sure why Gentoo imposes that limit by default - I don't think that's commonly done. I personally also have innodb_file_per_table set so that you don't get that single whopping tablespace growing - it can be quite a problem as MySQL will happily grow it (if you configure it right!), but it'll never shrink it... Thanks for letting us know. You could prefix the thread title with [Solved] as a clue to others if you like. Stuart thread wrote: Brilliant! That did it for me! Thank you so very much, hickinbottoms. ___ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
Re: [slim] SC Hangs Trying to List a Folder
thread;332106 Wrote: It's 7.1.0 ... and I'd really rather find the source of the issue and possibly lead hickinsbottoms to a fix. I was rather hoping that the filesystem where the SqueezeCenter database was held was full, but that appears not to be the case. A couple of other questions: 1. What filesystem type is the /var/lib/mysql directory mounted on? I don't expect it's significant, but may be worth knowing. 2. Have you knowingly altered the configuration of MySQL on your installation? Could you post your /etc/mysql/my.cnf configuration? 3. What platform are you on? Is it x86 or something more exotic? Finally: 4. You originally reported the problem with browse music folder - is the music that is missing from that also missing from the other browse modes (by genre, for example)? I'm just interested in whether the problem is restricted to browse music folder or not. Stuart -- hickinbottoms -Never put off until tomorrow what you can put off until the day after - with 'Lazy Searching' (http://www.hickinbottom.com/lazysearch)!- hickinbottoms's Profile: http://forums.slimdevices.com/member.php?userid=255 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
What version of mysql are you using? Could you post the output of mysql --version? Could you try commenting out the log-bin line of your my.cnf? Then restart MySQL and SqueezeCenter and see if that has any effect. If that helps then it might point to problems with the binary logs filling up being the issue. Stuart thread wrote: 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
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
No idea, it's nothing I've seen before. 50k tracks is a decent number but there are people with more without issues. What version of SC are you using? If it's some Gentoo specific build I'd recommend trying with the straight 7.1 downloaded from this site. -- radish radish's Profile: http://forums.slimdevices.com/member.php?userid=77 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
I believe, from another thread, that you're using Gentoo's portage version. Can you see how much free space there is for the MySQL database files, the current size of your database files, and what files you currently have? As root: Code: cd /var/lib/mysql df -h . du -hs squeezecenter ls -l squeezecenter Stuart -- hickinbottoms -Never put off until tomorrow what you can put off until the day after - with 'Lazy Searching' (http://www.hickinbottom.com/lazysearch)!- hickinbottoms's Profile: http://forums.slimdevices.com/member.php?userid=255 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
lol do I have too much music for SqueezeCenter? I just found this in my server.log... [08-08-21 18:53:08.6153] Slim::Schema::Storage::throw_exception (70) Error: 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. [08-08-21 18:53:08.6160] 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 line 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-21 18:53:08.6170] 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. [08-08-21 18:53:09.1239] Slim::Schema::Storage::throw_exception (70) Error: 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. [08-08-21 18:53:09.1246] 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 line 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:
Re: [slim] SC Hangs Trying to List a Folder
Well, how many tracks do you have? From quickly googling I don't think it's very likely you hit a record limit, but you may possibly have hit an overall DB size limit if you're running on Windows with a FAT filesystem. That's still 2GB though, which is huge. As for why you can't use Browse Music Folder, that's because the act of browsing triggers the directory to be added to the db if it's not already there. I'd wipe out the db and do a full rescan. -- radish radish's Profile: http://forums.slimdevices.com/member.php?userid=77 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
