Bug 18031 - Rescan failed with disk i/o error, sqlite: 'delete from scanned_files..'
: Rescan failed with disk i/o error, sqlite: 'delete from scanned_files..'
Status: RESOLVED DUPLICATE of bug 17834
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.7.2
: Other Debian Linux
: -- blocker (vote)
: ---
Assigned To: Unassigned bug - please assign me!
: database, SQLite
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-01-21 20:14 UTC by Christoph
Modified: 2013-02-07 14:18 UTC (History)
1 user (show)

See Also:
Category: Bug


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Christoph 2013-01-21 20:14:48 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 1 Michael Herger 2013-02-07 14:18:30 UTC

*** This bug has been marked as a duplicate of bug 17834 ***