Home of the Squeezebox™ & Transporter® network music players.
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Junior Member
    Join Date
    Aug 2011
    Posts
    6

    "database persistentdb is already in use" error with 7.6

    I'm trying to get server 7.6.0-32854 up and running on a Solaris 11 Express (snv_151a) server.

    I build my own perl and have installed all modules via CPAN, so I have the latest module versions available as of Aug 12, 2011. The only exception is Audio::Scan which is version 0.88 instead of 0.90, because SqueezeServer indicates that it requires exactly 0.88.

    I have tried Perl 5.8.9 and 5.14.1, and am experiencing the same problem.

    The problem I have is that I can start the server, answer the initial questions via the web site (music folder locations), but when I hit 'finish', I get the following error on the console:

    Code:
    [11-08-12 18:56:45.0365] Carp::Clan::__ANON__ (225) Warning: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: SQL logic error or missing database
    database persistentdb is already in use [for Statement "ATTACH '/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Cache/squeezebox-persistent.db' AS persistentdb"] at /opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 123
    The web page never finishes loading. If I quit the server (ctrl-C) and start it up again, I immediately get the same error on the console. No other instances of SqueezeServer are running.

    I have also tried the latest nightly build of 7.6.1-33068 and get the exact same error.

    Any ideas? Are there any CPAN modules where the newest version doesn't work and I need to downgrade?

    Thanks,
    Matthew

  2. #2
    Junior Member
    Join Date
    Aug 2011
    Posts
    6

    Full stack trace

    The full console output from server startup to the time I press ctrl-C is available here:
    http://pastebin.com/JVRL4ZmN

  3. #3
    Senior Member erland's Avatar
    Join Date
    Dec 2005
    Location
    Sweden
    Posts
    11,036
    Sounds like either another SQL client or another SBS is started and connected towards the database when you try to start SBS, can this be the problem ?

    Can you check if there is an SBS or SQL client running before you try to start SBS ?
    Erland Isaksson (My homepage)
    Developer of many plugins/applets

  4. #4
    Junior Member
    Join Date
    Aug 2011
    Posts
    6
    Nothing else running that would have a lock on the database.

    I confirmed that no other perl processes are running. I can delete the entire squeezeserver directory, extract the distribution in a new location, start the new server, go through the initial setup through the web browser, and still get the same error.

  5. #5
    Senior Member
    Join Date
    Oct 2005
    Location
    Ireland
    Posts
    17,823
    Quote Originally Posted by mrwilsox View Post
    I have also tried the latest nightly build of 7.6.1-33068 and get the exact same error.
    Just to confirm that with 33068 you used Audio::Scan 0.90 ?

    If somehow it was indicating 0.88 make sure you have the correct modules.conf file
    Last edited by bpa; 2011-08-12 at 23:59.

  6. #6
    Senior Member
    Join Date
    May 2009
    Location
    Denmark (Struer)
    Posts
    854
    with 7.6.1-33068 it is Audio::Scan 0.90 that is expected
    Main: Receiver (Audiocom) -> Beresford Caiman+ (Gatorized) -> Carver A-500x -> B&W 704
    Office: Receiver -> Luxman L-210 -> Stax SR84 Pro
    -> Beresford Bushmaster -> Superlux HD668B
    Server: A8-5500, 4 GB, SSD+ 2*1 TB, Win8 w. SBS 7.9.0 (SQLite w. High Mem)
    Tied together by D-Link DIR-655 + DGS-1008D

  7. #7
    Junior Member
    Join Date
    Aug 2011
    Posts
    6
    Yes, with 7.6.0 I used Audio::Scan 0.88. When I upgraded to 7.6.1 it required me to upgrade to Audio::Scan 0.90.

  8. #8
    Senior Member erland's Avatar
    Join Date
    Dec 2005
    Location
    Sweden
    Posts
    11,036
    Quote Originally Posted by mrwilsox View Post
    Nothing else running that would have a lock on the database.

    I confirmed that no other perl processes are running. I can delete the entire squeezeserver directory, extract the distribution in a new location, start the new server, go through the initial setup through the web browser, and still get the same error.
    Can you look in the SBS Cache directory and:
    1. Make sure SBS isn't running
    2. Look in SBS Cached directory and move the squeezebox-persistent.db file somewhere else (I think I saw something about it being renamed to persist.db, so if you have one named like that move it also)
    3. Delete all the contents in SBS Cache directory. The reason I said you can move the persistent database is because it contains ratings and statistics and possibly that might be something you might want to keep later on. But I'm not sure if it will be possible to restore them as it works in your setup now.
    4. Startup SBS and let it perform a full rescan

    Does that work better or do you still get the "already in use" message at step 4 ?
    Erland Isaksson (My homepage)
    Developer of many plugins/applets

  9. #9
    Junior Member
    Join Date
    Aug 2011
    Posts
    6
    Still getting the 'already in use' error after clearing the cache directory. slimserver.pl starts up, recreates all of the files in the cache directory (including the squeezebox-persistent.db file), and immediately quits.

    Code:
    mwilson@persephone:/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854$ ps -ef | grep perl
        root   706     1   0 19:22:32 ?           0:04 /usr/perl5/bin/perl /usr/lib/intrd
     mwilson  2330   757   0 13:57:43 pts/1       0:00 grep perl
    mwilson@persephone:/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854$ rm -rf ./Cache/*
    mwilson@persephone:/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854$ ls -a ./Cache
    .  ..
    mwilson@persephone:/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854$ /opt/MRWsqz/bin/perl ./slimserver.pl 
    [11-08-13 13:58:09.5952] main::init (349) Starting Squeezebox Server (v7.6.0, r32854, Mon Jul 25 11:17:37 MDT 2011) perl 5.008009
    [11-08-13 13:58:09.8365] Slim::Utils::Misc::msg (1236) Warning: [13:58:09.8363] Class::C3::Componentised::load_components(): Use of DBIx::Class::UTF8Columns is strongly discouraged. See documentation of DBIx::Class::UTF8Columns for more info
    [11-08-13 13:58:09.9515] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::db do failed: SQL logic error or missing database
    database persistentdb is already in use [for Statement "ATTACH '/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Cache/squeezebox-persistent.db' AS persistentdb"]
    [11-08-13 13:58:09.9518] Slim::Schema::Storage::throw_exception (119) Backtrace:
    
       frame 0: Slim::Utils::Log::logBacktrace (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 119)
       frame 1: Slim::Schema::Storage::throw_exception (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1288)
       frame 2: DBIx::Class::Storage::DBI::__ANON__ (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1222)
       frame 3: DBIx::Class::Storage::DBI::_do_query (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1193)
       frame 4: DBIx::Class::Storage::DBI::connect_call_do_sql (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1175)
       frame 5: DBIx::Class::Storage::DBI::_do_connection_actions (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1182)
       frame 6: DBIx::Class::Storage::DBI::_do_connection_actions (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1027)
       frame 7: DBIx::Class::Storage::DBI::_run_connection_actions (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 1017)
       frame 8: DBIx::Class::Storage::DBI::_populate_dbh (/opt/MRWsqz/lib/perl5/site_perl/5.8.9/DBIx/Class/Storage/DBI.pm line 906)
       frame 9: DBIx::Class::Storage::DBI::ensure_connected (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 43)
       frame 10: (eval) (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 43)
       frame 11: Slim::Schema::Storage::dbh (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema.pm line 295)
       frame 12: Slim::Schema::_connect (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema.pm line 129)
       frame 13: Slim::Schema::init (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Music/Import.pm line 637)
       frame 14: Slim::Music::Import::_checkLibraryStatus (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Music/Import.pm line 569)
       frame 15: Slim::Music::Import::useImporter (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Music/MusicFolderScan.pm line 51)
       frame 16: Slim::Music::MusicFolderScan::init (./slimserver.pl line 517)
       frame 17: main::init (./slimserver.pl line 641)
       frame 18: main::main (./slimserver.pl line 1138)
    
    [11-08-13 13:58:09.9524] Slim::Schema::Storage::throw_exception (119) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: SQL logic error or missing database
    database persistentdb is already in use [for Statement "ATTACH '/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Cache/squeezebox-persistent.db' AS persistentdb"] at /opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 123
    [11-08-13 13:58:09.9527] Slim::Schema::Storage::throw_exception (119) Backtrace:
    
       frame 0: Slim::Utils::Log::logBacktrace (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 119)
       frame 1: Slim::Schema::Storage::throw_exception (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 47)
       frame 2: Slim::Schema::Storage::dbh (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema.pm line 295)
       frame 3: Slim::Schema::_connect (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema.pm line 129)
       frame 4: Slim::Schema::init (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Music/Import.pm line 637)
       frame 5: Slim::Music::Import::_checkLibraryStatus (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Music/Import.pm line 569)
       frame 6: Slim::Music::Import::useImporter (/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Music/MusicFolderScan.pm line 51)
       frame 7: Slim::Music::MusicFolderScan::init (./slimserver.pl line 517)
       frame 8: main::init (./slimserver.pl line 641)
       frame 9: main::main (./slimserver.pl line 1138)
    
    [11-08-13 13:58:09.9530] Carp::Clan::__ANON__ (225) Warning: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: SQL logic error or missing database
    database persistentdb is already in use [for Statement "ATTACH '/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Cache/squeezebox-persistent.db' AS persistentdb"] at /opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854/Slim/Schema/Storage.pm line 123
    [11-08-13 13:58:09.9533] Slim::Schema::forceCommit (2056) Warning: Trying to commit transactions before DB is initialized!
    mwilson@persephone:/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854$ ls ./Cache
    cookies.dat	   FileCache	     plugin-data.yaml	       squeezebox.db		      updates
    DownloadedPlugins  InstalledPlugins  squeezebox-persistent.db  stringcache.i86pc-solaris.bin
    mwilson@persephone:/opt/MRWsqz/sqz/squeezeboxserver-7.6.0-32854$

  10. #10
    Former Squeezebox Guy andyg's Avatar
    Join Date
    Jan 2006
    Location
    Pittsburgh, PA
    Posts
    7,396

    "database persistentdb is alreadyin use" error with 7.6

    You are trying to use a newer system-wide version of DBIx::Class. You must use the one we supply in our CPAN directory.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •