I don't know what's happening. It seems that the chosen database does
not affect the scanner. Although mySQL files are created, they appear to
be empty (also with MySQLTools). This is supposed to be a mySQL scan:
Code:
--------------------
[09-12-03 13:13:58.5380] main::main (202) Starting Squeezebox Server scanner
(v7.5.0, r29525, Wed Dec 2 22:42:55 PST 2009) perl 5.010000
[09-12-03 13:13:59.0036] Slim::Utils::SQLiteHelper::checkDataSource (214)
Warning: Scanner database found, checking for a newer scan...
[09-12-03 13:13:59.0077] Slim::Utils::SQLiteHelper::checkDataSource (240)
Warning: Scanner database is older, removing it
[09-12-03 13:14:01.8630] main::main (312) Removing artwork cache...
[09-12-03 13:14:01.8722] Slim::Music::Import::runImporter (496) Starting
Slim::Music::MusicFolderScan scan
[09-12-03 13:14:01.8728] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in D:\storage\music\flac
[09-12-03 13:14:21.3580] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-03 13:14:21.3584] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (16125)
[09-12-03 13:21:57.1973] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-03 13:21:57.1980] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in D:\storage\music\ThemeTime
[09-12-03 13:22:00.6440] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-03 13:22:00.6444] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (1289)
[09-12-03 13:22:42.9015] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-03 13:22:42.9021] Slim::Music::Import::endImporter (630) Completed
Slim::Music::MusicFolderScan Scan in 521 seconds.
[09-12-03 13:22:43.5871] Slim::Music::Import::runImporter (496) Starting
Slim::Music::PlaylistFolderScan scan
[09-12-03 13:22:43.5882] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in D:\storage\music\playlists
[09-12-03 13:22:44.3500] Slim::Utils::Scanner::Local::__ANON__ (177) Removing
deleted files (0)
[09-12-03 13:22:44.3504] Slim::Utils::Scanner::Local::__ANON__ (229) Scanning
new files (1)
[09-12-03 13:22:44.4764] Carp::carp (46) Warning: prepare_cached(SELECT id
FROM progress WHERE type = ? AND name = ?) statement handle
DBI::st=HASH(0x46b704c) still Active at
/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Utils/Progress.pm line 103
[09-12-03 13:22:44.4919] Slim::Utils::Scanner::Local::new (580) Handling new
playlist file:///D:/storage/music/playlists/Zapped%20Songs.m3u
[09-12-03 13:22:44.5167] Slim::Utils::Scanner::Local::__ANON__ (281)
Rescanning changed files (0)
[09-12-03 13:22:44.5172] Slim::Music::Import::runScanPostProcessing (366)
Starting merge of various artists albums
[09-12-03 13:22:44.5631] Slim::Music::Import::endImporter (630) Completed
mergeVariousAlbums Scan in 0 seconds.
[09-12-03 13:22:45.2460] Slim::Music::Artwork::precacheAllArtwork (491)
Starting precacheArtwork for 975 albums
[09-12-03 13:25:29.9134] Slim::Music::Artwork::__ANON__ (575) precacheArtwork
finished in 164.652506113052
[09-12-03 13:25:29.9139] Slim::Music::Import::endImporter (630) Completed
precacheArtwork Scan in 165 seconds.
[09-12-03 13:25:29.9174] Slim::Music::Import::runScanPostProcessing (413)
Starting Database optimization.
[09-12-03 13:25:32.8761] Slim::Music::Import::endImporter (630) Completed
dbOptimize Scan in 2 seconds.
--------------------
Nothing is reported and the database is empty. See also the lines at
the top referring to mySQL.
BUT,when I restart SC with SQLite as database, there suddenly are files
in the database (without renewed scanning) and on the information page
is the info about the mySQL scan.
I turn to mySQL again, restart and order to scan for new and changed
music. The following is in scanner.log.
Code:
--------------------
[09-12-03 13:44:41.4955] Slim::Utils::Scanner::Local::rescan (112)
Discovering files in D:\storage\music\flac
[09-12-03 13:45:01.0080] Slim::Schema::Storage::throw_exception (82) Error:
DBI Exception: DBD::SQLite::db selectrow_array failed: database disk image is
malformed [for Statement "
SELECT COUNT(*) FROM (
SELECT scanned_files.url
FROM scanned_files
JOIN tracks ON (
scanned_files.url = tracks.url
AND (
scanned_files.timestamp !=
tracks.timestamp
OR
scanned_files.filesize !=
tracks.filesize
)
)
WHERE scanned_files.url LIKE
'file:///D:/storage/music/flac%'
) AS t1
"]
[09-12-03 13:45:01.0086] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Utils/Scanner/Local.pm line 173)
frame 3: Slim::Utils::Scanner::Local::__ANON__
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Utils/Scanner/Local/Async.pm
line 70)
frame 4: Slim::Utils::Scanner::Local::Async::__ANON__
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Utils/Scanner/Local/Async.pm
line 141)
frame 5: Slim::Utils::Scanner::Local::Async::find
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Utils/Scanner/Local.pm line 54)
frame 6: Slim::Utils::Scanner::Local::find
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Utils/Scanner/Local.pm line 350)
frame 7: Slim::Utils::Scanner::Local::rescan
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Music/MusicFolderScan.pm line
79)
frame 8: Slim::Music::MusicFolderScan::startScan
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Music/Import.pm line 498)
frame 9: Slim::Music::Import::runImporter
(/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Music/Import.pm line 310)
frame 10: Slim::Music::Import::runScan (scanner.pl line 346)
frame 11: (eval) (scanner.pl line 340)
frame 12: main::main (scanner.pl line 545)
[09-12-03 13:45:01.0095] main::main (352) Error: Failed when running main
scan: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectrow_array
failed: database disk image is malformed [for Statement "
SELECT COUNT(*) FROM (
SELECT scanned_files.url
FROM scanned_files
JOIN tracks ON (
scanned_files.url = tracks.url
AND (
scanned_files.timestamp !=
tracks.timestamp
OR
scanned_files.filesize !=
tracks.filesize
)
)
WHERE scanned_files.url LIKE
'file:///D:/storage/music/flac%'
) AS t1
"] at
/<C:\PROGRA~1\SQUEEZ~3\server\scanner.exe>Slim/Schema/Storage.pm line 86
]
[09-12-03 13:45:01.0102] main::main (353) Error: Skipping post-process & Not
updating lastRescanTime!
--------------------
As you can see, this also seems related to SQLite, not mySQL. And SC
sees the database as empty.
Could it be that the scanner always creates/updates the SQLite database
(although some intialization is done for mySQL)? Then when SC looks for
data in the mySQL database that is always empty?
Teus
--
Teus de Jong
------------------------------------------------------------------------
Teus de Jong's Profile: http://forums.slimdevices.com/member.php?userid=15415
View this thread: http://forums.slimdevices.com/showthread.php?t=71768
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
