Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 10 of 10
  1. #1
    Junior Member
    Join Date
    Aug 2006
    Posts
    14

    Help! Music Library empty, unable to rescan

    Hey guys,

    I started having a problem with rescanning a week or so ago, but lived with it as I didn't really have time to check it out. Basically none of the rescan options actually resulted in me seeing an updated library listing.

    Fast forward to today, and since a complete uninstall/reinstall (also deleting the installation directory manually) I now have NO music library and the inability to get rescan to work!

    I switched on d_mysql, d_sql and d_scan on the debugging page, and the following is what happened when I went to select a full rescan (sorry there's so much of it, but it all seemed relevant):

    Setup::rescan - initiating scan of type: [wipecache]
    SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
    SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:20:06:0d:23'
    SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:20:05:b5:18'
    SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:20:06:0d:23'
    INSERT INTO tracks (content_type, rating, remote, title, titlesearch, titlesort, url) VALUES (?, ?, ?, ?, ?, ?, ?): 'cpl', '0', '0', 'Now Playing - Front Room', 'NOW PLAYING FRONT ROOM', 'NOW PLAYING FRONT ROOM', 'clientplaylist://00:04:20:06:0d:23'
    DELETE FROM playlist_track WHERE ( playlist = ? ): '1'
    ERROR: Can't call method "print" on an undefined value at D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/Statistics.pm line 65.

    ERROR: Backtrace follows:

    Backtrace:

    frame 0: Slim::Schema::Storage::throw_exception (D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 748)
    frame 1: DBIx::Class::Storage:BI::txn_rollback (/PerlApp/DBIx/Class/Schema.pm line 507)
    frame 2: DBIx::Class::Schema::txn_rollback (/PerlApp/DBIx/Class/Schema.pm line 593)
    frame 3: (eval) (/PerlApp/DBIx/Class/Schema.pm line 592)
    frame 4: DBIx::Class::Schema::txn_do (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 46)
    frame 5: (eval) (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 39)
    frame 6: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
    frame 7: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1640)
    frame 8: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 753)
    frame 9: Slim::Control::Request::checkNotifications (slimserver.pl line 464)
    frame 10: main::idle (slimserver.pl line 35)
    frame 11: PerlSvc::Startup (perlsvc.pl line 1482)
    frame 12: PerlSvc::_startup (slimserver.pl line 0)
    frame 13: (eval) (slimserver.pl line 0)

    ERROR: Transaction aborted: Can't call method "print" on an undefined value at D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/Statistics.pm line 76.
    . Rollback failed: Carp::Clan::__ANON__(): Can't call method "print" on an undefined value at D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/Statistics.pm line 65.

    ERROR: Backtrace follows:

    Backtrace:

    frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 602)
    frame 1: DBIx::Class::Schema::txn_do (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 46)
    frame 2: (eval) (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 39)
    frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
    frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1640)
    frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 753)
    frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 464)
    frame 7: main::idle (slimserver.pl line 35)
    frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
    frame 9: PerlSvc::_startup (slimserver.pl line 0)
    frame 10: (eval) (slimserver.pl line 0)

    SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:20:05:b5:18'
    INSERT INTO tracks (content_type, rating, remote, title, titlesearch, titlesort, url) VALUES (?, ?, ?, ?, ?, ?, ?): 'cpl', '0', '0', 'Now Playing - Bedroom', 'NOW PLAYING BEDROOM', 'NOW PLAYING BEDROOM', 'clientplaylist://00:04:20:05:b5:18'
    DELETE FROM playlist_track WHERE ( playlist = ? ): '2'
    ERROR: Can't call method "print" on an undefined value at D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/Statistics.pm line 65.

    ERROR: Backtrace follows:

    Backtrace:

    frame 0: Slim::Schema::Storage::throw_exception (D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 748)
    frame 1: DBIx::Class::Storage:BI::txn_rollback (/PerlApp/DBIx/Class/Schema.pm line 507)
    frame 2: DBIx::Class::Schema::txn_rollback (/PerlApp/DBIx/Class/Schema.pm line 593)
    frame 3: (eval) (/PerlApp/DBIx/Class/Schema.pm line 592)
    frame 4: DBIx::Class::Schema::txn_do (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 46)
    frame 5: (eval) (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 39)
    frame 6: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
    frame 7: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1640)
    frame 8: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 753)
    frame 9: Slim::Control::Request::checkNotifications (slimserver.pl line 464)
    frame 10: main::idle (slimserver.pl line 35)
    frame 11: PerlSvc::Startup (perlsvc.pl line 1482)
    frame 12: PerlSvc::_startup (slimserver.pl line 0)
    frame 13: (eval) (slimserver.pl line 0)

    ERROR: Transaction aborted: Can't call method "print" on an undefined value at D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/Statistics.pm line 76.
    . Rollback failed: Carp::Clan::__ANON__(): Can't call method "print" on an undefined value at D:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/Statistics.pm line 65.

    ERROR: Backtrace follows:

  2. #2
    Junior Member
    Join Date
    Aug 2006
    Posts
    14
    Backtrace:

    frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 602)
    frame 1: DBIx::Class::Schema::txn_do (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 46)
    frame 2: (eval) (D:\Program Files\SlimServer\server/Slim/Schema/Playlist.pm line 39)
    frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
    frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1640)
    frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 753)
    frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 464)
    frame 7: main::idle (slimserver.pl line 35)
    frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
    frame 9: PerlSvc::_startup (slimserver.pl line 0)
    frame 10: (eval) (slimserver.pl line 0)

    SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
    SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me:
    levelMap:
    filters:
    find:
    $self->result_class: [Slim::Schema::Contributor]
    descend: working on level: [Contributor]
    $self->result_source->schema->source($level)->result_class: [Slim::Schema::Contributor]
    Calling method: [browse]
    SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ? ) ): '0', '1', '5'
    SELECT COUNT( DISTINCT( me.id ) ) FROM albums me WHERE ( me.compilation = ? ): '1'
    SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning'
    SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me WHERE ( me.audio = ? ): '1'
    SELECT COUNT( DISTINCT( me.id ) ) FROM albums me:
    SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) AND contributorAlbums.role IN ( ?, ? ) ): '0', '1', '5'
    ->addLibraryStats() found 0 songs, 0 albums & 0 artists


    I'd appreciate if anyone could point me in the right direction - I'm wondering whether it's a MySQL problem, but would like to be sure before I start messing around with that too!

    Cheers,
    LoZ


    (sorry it's over two posts but there's a 10000 word limit)

  3. #3
    Senior Member ceejay's Avatar
    Join Date
    Apr 2005
    Location
    Reading, UK
    Posts
    2,314
    Would that be 6.5.0 or 6.5.1 ? If the former, try a nightly...

    Ceejay

  4. #4
    Junior Member
    Join Date
    Aug 2006
    Posts
    14
    Upgraded to SlimServer Version: 6.5.1 - 10941 - Windows Server 2003 - EN - cp1252.

    Didn't fix the problem (i.e. the music library is still empty), but now the log doesn't have any errors.

  5. #5
    Senior Member ceejay's Avatar
    Join Date
    Apr 2005
    Location
    Reading, UK
    Posts
    2,314
    Umm - you are sure the Music Folder is correctly pointing at your library?

    Are you using iTunes or MusicIP/MMM ?

    Ceejay

  6. #6
    Junior Member
    Join Date
    Dec 2006
    Posts
    3
    If you have a fire wall or a virus scanner check that the file scanner.exe, in the Slimserver folder, isn't blocked somehow. I had about the same problem and tried to shut down the fire wall and virus scanner and the slimserver started scanning like crazy.

  7. #7
    Junior Member
    Join Date
    Aug 2006
    Posts
    14
    @ceejay - The music folder is definitely correct as if I choose Browse>Music Folder on the Squeezebox, everything is showing and playable. In fact since I played an album by that method, that one artist/album now shows in the library. Weird. I'm not using iTunes or any other external database tool and they're all switched off in Slimserver.

    @Vrålapan - Tried running with the firewall switched off completely but it didn't help. I never get a scanner.exe process starting up when I attempt a scan.

    Thanks both for your help so far. If no one has any more ideas I guess I'll have to rebuild the machine when I get time.

  8. #8
    Junior Member
    Join Date
    Dec 2006
    Posts
    3
    Try one last thing... uninstall the slimserver and install it again. Restart you computer and shut down you internet connection, virus scanner and fire wall. Then point to you music folder and run the scan.

  9. #9
    Senior Member ceejay's Avatar
    Join Date
    Apr 2005
    Location
    Reading, UK
    Posts
    2,314
    Interesting. Browse Music Folder causes the scanner to look at just those directories and add them to the database, which is working for you, which suggests that the files are readable and make sense to SS (though you knew this already!).

    But the scanner itself isn't finding them. OK, so try running the scanner separately from the command line - you will probably need to navigate to the slimserver/server directory. Type

    > scanner --help

    to see some options. Run it with some debug flags set and specify a logfile. You might spot something in there, or post it back here (preferably as an attachment rather than as inline text unless its small). If you get a huge logfile because you have a big library, it might be friendlier to setup a "test" library with just a couple of albums in while you see what's happening.

    HTH
    Ceejay

  10. #10
    Junior Member
    Join Date
    Aug 2006
    Posts
    14
    Thanks very much Ceejay, a manual scan did the trick with no errors. I'm going to end up rebuilding this box anyway so hopefully when I chuck Slimserver on here again the rescan from the console will work.

    Thanks all for the help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •