PDA

View Full Version : SC Hangs Trying to List a Folder



thread
2008-08-21, 15:16
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
2008-08-21, 15:54
lol do I have too much music for SqueezeCenter? I just found this in my server.log... (Of course, I'm still wondering why it is that this is preventing me from doing a simple file browse.)

[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: 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: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.

radish
2008-08-21, 17:08
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.

hickinbottoms
2008-08-21, 23:40
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:



cd /var/lib/mysql
df -h .
du -hs squeezecenter
ls -lh .
ls -lh squeezecenter


Stuart

thread
2008-08-22, 05:11
Did a full rescan last night. I still have the same problem this morning. Here's the output hickinbottoms requested:

therver mysql # df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/hda3 12G 6.0G 4.5G 57% /
therver mysql # du -hs squeezecenter/
224K squeezecenter/
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.000001
-rw-rw---- 1 mysql mysql 104M Aug 21 23:30 mysqld-bin.000002
-rw-rw---- 1 mysql mysql 2.3K Aug 12 21:29 mysqld-bin.000003
-rw-rw---- 1 mysql mysql 607K Aug 12 21:29 mysqld-bin.000004
-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
2008-08-22, 15:41
Also, to answer radish's question, it appears that I have 47078 tracks.



thread@therver /storage/music $ find ./ | egrep -i '(mp3|ogg|flac)$' | wc
47078 334415 4453774

thread
2008-08-23, 08:22
I'd love a tip on this one... I'm basically not using my Squeezebox since I upgraded the SqueezeCenter/firmware . . .

radish
2008-08-24, 17:39
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.

thread
2008-08-24, 17:43
It's 7.1.0 ... and I'd really rather find the source of the issue and possibly lead hickinsbottoms to a fix.

hickinbottoms
2008-08-25, 04:58
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

thread
2008-08-25, 05:10
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.





# /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 = 10000

# 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 shouldn't need to tweak it
set-variable = innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
# uncomment the next directive if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

hickinbottoms
2008-08-25, 06:44
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 = 10000
>
> # 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 shouldn't need to tweak it
> set-variable = innodb_log_files_in_group=2
> # see the innodb config docs, the other options are not always safe
> innodb_flush_log_at_trx_commit = 1
> innodb_lock_wait_timeout = 50
>
> [mysqldump]
> quick
> max_allowed_packet = 16M
>
> [mysql]
> # uncomment the next directive if you are not familiar with SQL
> #safe-updates
>
> [isamchk]
> key_buffer = 20M
> sort_buffer_size = 20M
> read_buffer = 2M
> write_buffer = 2M
>
> [myisamchk]
> key_buffer = 20M
> sort_buffer_size = 20M
> read_buffer = 2M
> write_buffer = 2M
>
> [mysqlhotcopy]
> interactive-timeout
>
> --------------------
>
>
>

thread
2008-08-25, 14:45
$ 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...


[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.

hickinbottoms
2008-08-25, 23:45
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....

thread
2008-08-26, 04:46
Brilliant! That did it for me!

Thank you so very much, hickinbottoms.

hickinbottoms
2008-08-26, 05:19
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.
>
>
>