Deleted cache, copied across a fresh set of preferences from my working 7.5/trunk setup (changed file references to a different cache folder), and restarted.
The prefs was still configured to use MySQL, but at startup this was changed to reference SQLite. SBS said it couldn't find DB, so created a new SQLite DB. But when I tried to start a scan, it wasn't very happy. Database is locked by something else? I tried stopping, removing the dbusername and password prefs settings, cleared cache and restarting, but get exactly the same issue. [00:48:09.1419] main::main (223) Squeezebox Server SQL init... [00:48:09.4127] Slim::Utils::SQLiteHelper::updateProgress (401) Notify to server: ["unlock"] [00:48:10.6406] Slim::Utils::SQLiteHelper::updateProgress (416) Notify to server failed: 401 Unauthorized [00:48:10.6415] main::main (250) Cache init... [00:48:42.8750] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement "PRAGMA synchronous = OFF"] [00:48:42.8760] Slim::Schema::Storage::throw_exception (119) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 119) frame 1: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 974) frame 3: DBIx::Class::Storage::DBI::_do_query (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 945) frame 4: DBIx::Class::Storage::DBI::connect_call_do_sql (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 927) frame 5: DBIx::Class::Storage::DBI::_do_connection_actions (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 934) frame 6: DBIx::Class::Storage::DBI::_do_connection_actions (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 874) frame 7: DBIx::Class::Storage::DBI::_run_connection_actions (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 864) frame 8: DBIx::Class::Storage::DBI::_populate_dbh (P:\Music\SlimServer\Beta\server\CPAN/DBIx/Class/Storage/DBI.pm line 789) frame 9: DBIx::Class::Storage::DBI::ensure_connected (P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 43) frame 10: (eval) (P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 43) frame 11: Slim::Schema::Storage::dbh (P:/Music/SlimServer/Beta/server/Slim/Schema.pm line 301) frame 12: Slim::Schema::_connect (P:/Music/SlimServer/Beta/server/Slim/Schema.pm line 132) frame 13: Slim::Schema::init (P:/Music/SlimServer/Beta/server/Slim/Music/Import.pm line 642) frame 14: Slim::Music::Import::_checkLibraryStatus (P:/Music/SlimServer/Beta/server/Slim/Music/Import.pm line 580) frame 15: Slim::Music::Import::useImporter (P:/Music/SlimServer/Beta/server/Slim/Music/PlaylistFolderScan.pm line 53) frame 16: Slim::Music::PlaylistFolderScan::init (P:/Music/SlimServer/Beta/server/scanner.pl line 260) frame 17: main::main (P:/Music/SlimServer/Beta/server/scanner.pl line 530) [00:48:42.8783] Slim::Schema::Storage::throw_exception (119) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement "PRAGMA synchronous = OFF"] at P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 123 [00:48:42.8794] Slim::Schema::Storage::throw_exception (119) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 119) frame 1: Slim::Schema::Storage::throw_exception (P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 47) frame 2: Slim::Schema::Storage::dbh (P:/Music/SlimServer/Beta/server/Slim/Schema.pm line 301) frame 3: Slim::Schema::_connect (P:/Music/SlimServer/Beta/server/Slim/Schema.pm line 132) frame 4: Slim::Schema::init (P:/Music/SlimServer/Beta/server/Slim/Music/Import.pm line 642) frame 5: Slim::Music::Import::_checkLibraryStatus (P:/Music/SlimServer/Beta/server/Slim/Music/Import.pm line 580) frame 6: Slim::Music::Import::useImporter (P:/Music/SlimServer/Beta/server/Slim/Music/PlaylistFolderScan.pm line 53) frame 7: Slim::Music::PlaylistFolderScan::init (P:/Music/SlimServer/Beta/server/scanner.pl line 260) frame 8: main::main (P:/Music/SlimServer/Beta/server/scanner.pl line 530) [00:48:42.8811] Carp::Clan::__ANON__ (214) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement "PRAGMA synchronous = OFF"] at P:/Music/SlimServer/Beta/server/Slim/Schema/Storage.pm line 123 [00:48:42.8824] Slim::bootstrap::theEND (437) Got to the END [00:48:42.8839] Slim::bootstrap::sigint (401) Got sigint [00:48:42.8848] Slim::Schema::forceCommit (2070) Warning: Trying to commit transactions before DB is initialized! [00:48:42.8927] Slim::Utils::SQLiteHelper::updateProgress (401) Notify to server: ["exit"] [00:48:42.9819] Slim::Utils::SQLiteHelper::updateProgress (416) Notify to server failed: 401 Unauthorized _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
