PDA

View Full Version : Upgrade to 7.6.1, "database disk image is malformed"



jezbo
2011-08-27, 09:16
After upgrading to 7.6.1 and trying a rescan, it seems to hang after a while (stuck on the same folder in the scanner status) and I notice the error "database disk image is malformed" in the scanner log:

[11-08-27 17:29:49.4947] Slim::Utils::SQLHelper::executeSQLFile (85) Error: Couldn't execute SQL statement: [DELETE FROM tracks;] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database disk image is malformed [for Statement "DELETE FROM tracks;"] at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 123
]
[11-08-27 17:29:53.2685] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::db do failed: database disk image is malformed [for Statement "DELETE FROM albums;"]
[11-08-27 17:29:53.2690] Slim::Schema::Storage::throw_exception (119) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 119)
frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
frame 3: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83)
frame 4: Slim::Utils::SQLHelper::executeSQLFile (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 396)
frame 5: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 395)
frame 6: Slim::Schema::wipeDB (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2048)
frame 7: Slim::Schema::wipeAllData (scanner.pl line 292)
frame 8: (eval) (scanner.pl line 292)
frame 9: main::main (scanner.pl line 498)

What can be done?

jezbo
2011-08-27, 12:24
No solution. Had to de-install and re-install.

JJZolx
2011-08-27, 13:55
Next time it happens you can just shut down the server, delete everything in the cache folder, the restart the server. It should save you a few minutes.

jezbo
2011-08-28, 00:29
Next time it happens you can just shut down the server, delete everything in the cache folder, the restart the server. It should save you a few minutes.

I did try that, but though it didn't have the same errors there were still problems. So I resorted to a de-install.

mherger
2011-08-29, 03:02
> After upgrading to 7.6.1 and trying a rescan, it seems to hang after a
> while and I notice the error "database disk image is malformed" in the
> scanner log:
>
> [11-08-27 17:29:49.4947] Slim::Utils::SQLHelper::executeSQLFile (85)
> Error: Couldn't execute SQL statement: [DELETE FROM tracks;] :
> [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed:
> database disk image is malformed [for Statement "DELETE FROM tracks;"]
> at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm

Could you please post the full scanner.log file? This error should be
caught and give more log details.

--

Michael