Stoker;675417 Wrote:
> Hi
>
> I added a new CD to my collection a couple of days ago and when I tried
> to do a re-scan: "Settings:look for new and changed music" from the web
> interface the rescan failed. I have also tried a complete rescan with
> the same result.
>
> When I look at the scan log (/var/log/squeezeboxserver/scanner.log) I
> can see amongst other things, the following:
>
>
> [11-12-08 17:38:40.9790] Slim::Schema::Storage::throw_exception (82)
> Error: DBI Connection failed: DBI
> connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
> failed: Can't connect to MySQL server on '127.0.0.1' (111) at
> /usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 950
> [11-12-08 17:38:40.9802] Slim::Schema::Storage::throw_exception (82)
> Backtrace:
>
> [11-12-08 17:38:40.9813] main::main (299) Warning: Issuing rollback()
> for database handle being DESTROY'd without explicit disconnect() at
> /usr/sbin/squeezeboxserver-scanner line 299.
> [11-12-08 17:38:40.9823] main::main (311) Error: Failed when running
> main scan: [Carp::Clan::__ANON__(): DBI Connection failed: DBI
> connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
> failed: Can't connect to MySQL server on '127.0.0.1' (111) at
> /usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 950
> ]
> [11-12-08 17:38:40.9830] main::main (312) Error: Skipping post-process
> & Not updating lastRescanTime!
> [11-12-08 17:38:40.9867] Slim::Schema::Storage::throw_exception (82)
> Error: DBI Connection failed: DBI
> connect('hostname=127.0.0.1;port=9092;database=slimserver','slimserver',...)
> failed: Can't connect to MySQL server on '127.0.0.1' (111) at
> /usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 950
> [11-12-08 17:38:40.9877] Slim::Schema::Storage::throw_exception (82)
> Backtrace:
>
> [11-12-08 17:38:40.9890] Slim::Schema::Storage::dbh (53) Warning:
> Unable to connect to the database - trying to bring it up!
>
> It looks like squeezebox server can't connect to the database. Does
> anyone have any idea what might be wrong? I've not changed anything
> recently. I'm using version 7.5.1 on Ubuntu. I can still access my
> library from the squeezebox and the web interface to the server, but
> without the new music so it would seem that the file system is still
> OK. Maybe the database is corrupt?
>
> Is there anyway I can force squeezebox server to delete and then
> rebuild a new database?
stop SbS, then delete the cache files from the folder they are sitting
in (not sure which one for your install). Then start SbS and do a clear
and rescan of your . That should rebuild your database.
--
garym
Location 1: Vortexbox Appliance 6TB (1.10) > SbS 7.6.2 > Transporter,
Touch, Boom, Radio w/Battery (all ethernet except Radio)
Location 2: Win7(64) laptop > LMS 7.7.1 > Touch > Benchmark DAC I,
Boom, Radio w/Battery (all ethernet except Radio and laptop)
Office: Win7(64) > LMS 7.7.1 > SqueezePlay
Retired: SB3, Duet Receiver
Controllers: iPhone (iPeng), iPad (iPengHD & SqueezePad), CONTROLLER,
or SqueezePlay 7.7 on Win7(64) laptop
Ripping (FLAC) - dbpoweramp, Additional Tagging - mp3tag
------------------------------------------------------------------------
garym's Profile: http://forums.slimdevices.com/member.php?userid=17325
View this thread: http://forums.slimdevices.com/showthread.php?t=92147
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
