PDA

View Full Version : Library keeps disappearing



decksnfx
2008-04-28, 16:56
Every few days, I turn on my squeezebox and find that it's lost track of all of the songs that it recognized the day before. Sometimes all the files disappear, sometimes just most of them. Right now, the only artist I have is Various, and there's a random five songs in that category.

I rescanned the library, both changes and full rescan - no help. I tried turning on and off iTunes library management, nothing. I'm quite sure that all these files are still playable, in the same place they were the other day, and otherwise playable.

I'm running SqueezeCenter Version: 7.0 - 17793 - Windows XP - EN - cp1252.

EDIT: I was just playing around with SC, and I discovered that all of the songs are still in the library, under every heading except artist. Genre is full, album is full, random mix plays a bunch of different stuff. So basically, the artist field is broken. Yes, I have well-tagged mp3s, so it's not that simple.

jrichardson
2008-04-28, 19:07
Decksnfx:

Please turn on Debug Logging for the following
1) scan.import
2) scan.scanner

Look for any errors in there.

To turn on logging, go to Settings > Advanced > Logging (from drop down menu)

Feel free to post bits of the log here and the community can help you.

decksnfx
2008-08-07, 17:21
sorry for the incredibly long delay. i reinstalled and thought i was golden, but then it re-broke. it looks like there's probably a pretty good explanation in the log:

]
[08-08-07 17:27:26.3935] main::main (212) Error: Skipping post-process & Not updating lastRescanTime!
[08-08-07 18:27:13.5138] main::main (211) Error: Failed when running main scan: [Can't call method "title" on an undefined value at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1976.
]
[08-08-07 18:27:13.5145] main::main (212) Error: Skipping post-process & Not updating lastRescanTime!
[08-08-07 19:27:17.1662] main::main (211) Error: Failed when running main scan: [Can't call method "title" on an undefined value at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1976.
]
[08-08-07 19:27:17.1669] main::main (212) Error: Skipping post-process & Not updating lastRescanTime!
[08-08-07 20:02:46.8750] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( me.contributor = ? AND me.discc = ? AND me.title = ? ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_434_0.MYD' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-08-07 20:02:46.9178] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 4: DBIx::Class::Storage::DBI::select_single (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/ResultSet.pm line 509)
frame 5: DBIx::Class::ResultSet::single (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2138)
frame 6: Slim::Schema::_postCheckAttributes (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 884)
frame 7: Slim::Schema::newTrack (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1032)
frame 8: Slim::Schema::updateOrCreate (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 332)
frame 9: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79)
frame 10: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 463)
frame 11: Slim::Music::Import::runImporter (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 307)
frame 12: Slim::Music::Import::runScan (scanner.pl line 205)
frame 13: (eval) (scanner.pl line 199)
frame 14: main::main (scanner.pl line 345)

[08-08-07 20:02:46.9193] main::main (211) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( me.contributor = ? AND me.discc = ? AND me.title = ? ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_434_0.MYD' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
]
[08-08-07 20:02:46.9203] main::main (212) Error: Skipping post-process & Not updating lastRescanTime!
[08-08-07 20:07:58.2343] main::main (211) Error: Failed when running main scan: [Can't call method "title" on an undefined value at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1976.
]
[08-08-07 20:07:58.2576] main::main (212) Error: Skipping post-process & Not updating lastRescanTime!
[08-08-07 20:17:25.2500] Slim::Music::Import::addImporter (443) Adding Slim::Music::PlaylistFolderScan Scan
[08-08-07 20:17:25.2740] Slim::Music::Import::addImporter (443) Adding Slim::Music::MusicFolderScan Scan
[08-08-07 20:17:25.3448] Slim::Music::Import::addImporter (443) Adding Slim::Plugin::iTunes::Importer Scan
[08-08-07 20:17:25.3579] Slim::Music::Import::runImporter (461) Starting Slim::Music::MusicFolderScan scan
[08-08-07 20:17:25.3594] Slim::Music::MusicFolderScan::startScan (77) Starting music folder scan in C:\Documents and Settings\Root\My Documents\My Music
[08-08-07 20:17:25.3604] Slim::Utils::Scanner::scanDirectory (282) About to look for files in C:\Documents and Settings\Root\My Documents\My Music
[08-08-07 20:17:25.3619] Slim::Utils::Scanner::scanDirectory (283) For files with extensions in: (?i-xsm:\.(?:ape|wma|wv|wav|wave|mp3|mp2|flc|flac|fla| m4a|mov|m4b|mp4|mp+|mpc|ogg|aif|aiff|lnk|cue)$)
[08-08-07 20:17:25.4061] Slim::Utils::Scanner::findFilesForRescan (217) Generating file list from disk & database...
[08-08-07 20:17:46.3437] Slim::Utils::Scanner::findFilesMatching (162) Following Windows Shortcut to: file:///C:/Documents%20and%20Settings/All%20Users/Documents/My%20Music/Sample%20Music
[08-08-07 20:18:19.0312] Slim::Utils::Scanner::findNewAndChangedFiles (236) Comparing file list between disk & database to generate rescan list...
[08-08-07 20:18:22.5625] Slim::Utils::Scanner::scanDirectory (312) Found 129 files in C:\Documents and Settings\Root\My Documents\My Music
[08-08-07 20:18:22.5731] Slim::Utils::Scanner::scanDirectory (330) Adding file:///C:/Documents%20and%20Settings/Root/My%20Documents/My%20Music/iTunes/iTunes%20Music/Pink%20Floyd/Ummagumma%20(Disc%201)/1-03%20Set%20The%20Controls%20For%20The%20Heart.mp3 to database.
[08-08-07 20:18:22.5877] Slim::Utils::Scanner::scanDirectory (330) Adding file:///C:/Documents%20and%20Settings/Root/My%20Documents/My%20Music/iTunes/iTunes%20Music/A%20Tribe%20Called%20Quest/The%20Low%20End%20Theory/09%20Check%20The%20Rhyme.mp3 to database.
[08-08-07 20:18:23.1718] main::main (211) Error: Failed when running main scan: [Can't call method "title" on an undefined value at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1976.
]
[08-08-07 20:18:23.1728] main::main (212) Error: Skipping post-process & Not updating lastRescanTime!


let me know if there's anything i can do...

Siduhe
2008-08-07, 17:28
Tell your antivirus program to ignore *.myi and *.myd files - do you have McAfee or Norton installed by any chance? It looks as if it's causing the scan to fail and not updating the RescanTime as a result.

decksnfx
2008-08-07, 17:33
i'm running Avast - i actually had the full-time protection turned off during the above errors. I'll go ahead and try to ignore those extensions, though.

Siduhe
2008-08-07, 17:43
I don't know Avast at all, but the scanning of temp files (i.e. *.myd) is normally an on-access function which operates even if you have the program disabled.