Re: [slim] SC Hangs Trying to List a Folder

2008-08-26 Thread Stuart Hickinbottom
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

2008-08-26 Thread thread

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

2008-08-25 Thread Stuart Hickinbottom
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

2008-08-25 Thread thread

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

2008-08-25 Thread Stuart Hickinbottom
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_

Re: [slim] SC Hangs Trying to List a Folder

2008-08-25 Thread thread

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

2008-08-25 Thread hickinbottoms

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

2008-08-24 Thread thread

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

2008-08-24 Thread radish

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

2008-08-23 Thread thread

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

2008-08-22 Thread thread

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


Re: [slim] SC Hangs Trying to List a Folder

2008-08-22 Thread thread

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

2008-08-21 Thread hickinbottoms

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

2008-08-21 Thread radish

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


Re: [slim] SC Hangs Trying to List a Folder

2008-08-21 Thread thread

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: Slim::Networking::IO::S