Bug 17834 - Scanner throws error on rescan
: Scanner throws error on rescan
Status: UNCONFIRMED
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.7.1
: Other Debian Linux
: -- normal (vote)
: ---
Assigned To: Unassigned bug - please assign me!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-12-21 11:56 UTC by juliozaffo
Modified: 2013-02-07 23:49 UTC (History)
3 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description juliozaffo 2011-12-21 11:56:25 UTC
Setup background: Recently installed from scratch 7.7.1 on two Western Digital Mybook Live NAS devices. Everything installed OK and I ran a successful scan. However, upon trying to rescan the database on either device I get the following error: 

[11-12-20 10:29:52.3824] Slim::Control::Request::execute (1889) Error: While trying to run function coderef [Slim::Control::Commands::rescanCommand]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: disk I/O error [for Statement "DELETE FROM scanned_files WHERE url = 'file:///shares/Kurt' OR url LIKE 'file:///shares/Kurt/%'"] at /usr/share/perl5/Slim/Schema/Storage.pm line 126]

If I go and change the media folder path temporarily (proper path = /shares/Kurt -> temp path = shares/Kurt) and then abort that scan immediately and change the path back to the proper path and scan again the scan will work. Any ideas on what is causing the error on the DELETE FROM command?

Thanks,
Kurt
Comment 1 Michael Herger 2011-12-22 00:16:22 UTC
"disk I/O error" doesn't sound good. Please check with the package maintainer about possible version conflicts or missing pieces.
Comment 2 juliozaffo 2011-12-27 07:20:38 UTC
Sorry, I'm not very well versed in Linux so I'm not sure what checking with the package maintainer means.  I did run aptitude update, aptitude upgrade and apt-get update.  Not sure if this is what you are referring to but it didn't help things.
Comment 3 Michael Herger 2012-01-29 23:16:17 UTC
Where is your cache folder stored (find its location in Settings/Information)? Can you make sure that disk has enough free space?
Comment 4 Michael Herger 2013-02-07 14:18:30 UTC
*** Bug 18031 has been marked as a duplicate of this bug. ***
Comment 5 Christoph 2013-02-07 23:48:36 UTC
I had exactly the same error like bug#17834. The initially scan was successfully completed, after adding files, a following rescan crashed. I assume missing deleting-rights for sqlite-db user. The scan in the first place could only performed succsessfully after deleting the library.* files in /Datavolume/cache/squeezeboxserver. Hdd space is ok (about 1TB free) space for /temp folder upgraded from 50 to 500M.. Hardware is NAS Western Digital MyBookLive Duo. Here the error message again.. [13-01-21 20:31:15.8517] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: disk I/O error [for Statement "DELETE FROM scanned_files WHERE url = 'file:///DataVolume/shares/Public/Shared%20Music' OR url LIKE 'file:///DataVolume/shares/Public/Shared%20Music/%'"] [13-01-21 20:31:15.8545] Slim::Schema::Storage::throw_exception (122) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Utils/Scanner/Local.pm line 60) frame 3: Slim::Utils::Scanner::Local::find (/usr/share/perl5/Slim/Utils/Scanner/Local.pm line 515) frame 4: Slim::Utils::Scanner::Local::rescan (/usr/share/perl5/Slim/Control/Commands.pm line 2559) frame 5: Slim::Control::Commands::__ANON__ (/usr/share/perl5/Slim/Control/Commands.pm line 2567) frame 6: Slim::Control::Commands::rescanCommand (/usr/share/perl5/Slim/Control/Request.pm line 1884) frame 7: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1884) frame 8: Slim::Control::Request::execute (/usr/share/perl5/Slim/Music/Import.pm line 707) frame 9: Slim::Music::Import::nextScanTask (/usr/share/perl5/Slim/Web/Settings/Server/Basic.pm line 156) ... Best regards, many thanks for any help.. Christoph
Comment 6 Christoph 2013-02-07 23:49:32 UTC
I had exactly the same error like bug#17834. The initially scan was successfully completed, after adding files, a following rescan crashed. I assume missing deleting-rights for sqlite-db user. The scan in the first place could only performed succsessfully after deleting the library.* files in /Datavolume/cache/squeezeboxserver. Hdd space is ok (about 1TB free) space for /temp folder upgraded from 50 to 500M.. Hardware is NAS Western Digital MyBookLive Duo. Here the error message again.. [13-01-21 20:31:15.8517] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: disk I/O error [for Statement "DELETE FROM scanned_files WHERE url = 'file:///DataVolume/shares/Public/Shared%20Music' OR url LIKE 'file:///DataVolume/shares/Public/Shared%20Music/%'"] [13-01-21 20:31:15.8545] Slim::Schema::Storage::throw_exception (122) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Utils/Scanner/Local.pm line 60) frame 3: Slim::Utils::Scanner::Local::find (/usr/share/perl5/Slim/Utils/Scanner/Local.pm line 515) frame 4: Slim::Utils::Scanner::Local::rescan (/usr/share/perl5/Slim/Control/Commands.pm line 2559) frame 5: Slim::Control::Commands::__ANON__ (/usr/share/perl5/Slim/Control/Commands.pm line 2567) frame 6: Slim::Control::Commands::rescanCommand (/usr/share/perl5/Slim/Control/Request.pm line 1884) frame 7: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1884) frame 8: Slim::Control::Request::execute (/usr/share/perl5/Slim/Music/Import.pm line 707) frame 9: Slim::Music::Import::nextScanTask (/usr/share/perl5/Slim/Web/Settings/Server/Basic.pm line 156) ... Best regards, many thanks for any help.. Christoph