PDA

View Full Version : SC Not scanning all music - see ErrorLog please



Gazjam
2008-10-02, 12:31
Scanning my music library using latest SC 7.2.1 and it "gets stuck" after 3000-odd songs (I have LOTS more), and I cant figure out whats the matter.

Could an expert scan their eye over this log-file excerpt, shed some light on it?

Thanks.

[08-10-02 20:26:14.6066] main::main (219) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, musicbrainz_id, remote, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: MySQL server has gone away at C:\PROGRA~2\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
]
[08-10-02 20:26:14.6070] main::main (220) Error: Skipping post-process & Not updating lastRescanTime!
[08-10-02 20:26:14.8191] Slim::Schema::Storage::dbh (33) Warning: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at C:/PROGRA~2/SQUEEZ~1/server/Slim/Schema/Storage.pm line 33.

MrSinatra
2008-10-02, 12:38
what AV are you using?

Gazjam
2008-10-02, 13:28
I was using Avira Antivirus, but I read a couple of posts online about AV Software interfering with slimserver so I uninstalled it, thinking this would make a difference.

Didn't make a difference unfortunately, it still has the same problem.

Could it be a Firewall setting? I've (as far as I know) given Squeezecentre maximum permissions in my Firewall.

Could it be a Router configuration setting?
(I dont know much about networking....but I can get online!)*


Does DHCP Vs Static IP kind of thing come into this problem?

I see from other posts this problem seems to have came up in Ver. 7.2..would an earlier version of Squeezecentre not have this problem?

I am actually using the latest build 7.2.1..


Thanks.

MrSinatra
2008-10-02, 13:32
if it isn't your AV, i don't know what to suggest. it seems to be a problem where the scanner can no longer enter info into the mysql database, but beyond that i'm no help.

call the support number or email them.

Gazjam
2008-10-02, 13:42
Yeah, I'm going to drop them an email with the error log.
Thanks foir the reply.

Thanks for trying Mr Sinatra.

(At least you did it your way) :-)



...sorry.

radish
2008-10-02, 14:04
This isn't the usual AV problem (which results in an error about not being able to write to a file). In this case, the message is implying that MySQL is crashing during a transaction. Is this consistent and reproducable? Could be you're triggering some weird MySQL bug. What OS are you on, and are you using anything like a custom MySQL installation?

It won't be anything to do with firewalls/networking or anything like that.

Gazjam
2008-10-02, 14:22
Radish,

I'm on Vista x64 Ultimate.
Squeezecentre 7.2.1 (latest)

Running normal Vista installation, no funny installs or anything.
Just noticed I'm not on an Administrator account (Even though I'm in as a n Administrator in Vista...) *sigh*

I'm going to log back in a "proper" administrator, see if extra permissions frees up any functionality...


Thanks.

Gazjam
2008-10-02, 14:42
Rebooted and logged back in as Proper Admisistrator (i.e. no access restrictions to system)


Still the same, I have sent email with copy of error log to support.


Hopefully there is a solution to this (other than getting rid of vista!)

Gazjam
2008-10-03, 04:14
I wondered if it was a Vista x64 issue, so I went back and reinstalled XP Pro.

Still the same problem with THIS error log:


[08-10-03 11:13:11.9741] main::main (219) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, musicbrainz_id, remote, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: MySQL server has gone away at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
]
[08-10-03 11:13:11.9745] main::main (220) Error: Skipping post-process & Not updating lastRescanTime!
[08-10-03 11:13:11.9783] Slim::Schema::Storage::dbh (33) Warning: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 33.
[08-10-03 12:12:05.0927] Carp::carp (271) Warning: Size mismatch on APIC
at C:/PROGRA~1/SQUEEZ~1/server/Slim/Formats/MP3.pm line 163
[08-10-03 12:12:15.9843] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b24_0.MYI' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-10-03 12:12:15.9850] Slim::Schema::Storage::throw_exception (70) Backtrace:

???

I was hoping to avoid all this "Linux'ey" stuff and just enjoy my music..... getting more disheartened by the day here... :-(

radish
2008-10-03, 06:19
Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b24_0.MYI'
OK, this one is an antivirus. What do you have running?

Gazjam
2008-10-03, 06:24
Thanks Radish,

I'm running Avast 4.8.1229 Home Edition

MrSinatra
2008-10-03, 12:51
i have the same thing and mine works fine, but you can set exclusions for MYI files in the avast settings.

Gazjam
2008-10-04, 00:40
*UPDATE*

Problem now resolved, setting exceptions on Avast! for *.myi and *.myt files did the trick.

Also, there was 1 mp3 file that was throwing the scan off. Never did find out why, but converting it back to itself - i.e. 256kbs mp3 ro 256kbs mp3 in Media Monkey software (Sounds daft but it worked) made it play nice with squeezeserver.


Thanks for all the replies and help.
Great Forum.

dahlj
2008-10-26, 12:24
I've come across the same problem and need help. It stops without completing the scan, but got a bit further each time I restarted the scanning. Finally it just stopped. Any suggestion son what to do?

Scanner.log:
[08-10-26 12:37:21.9542] main::main (219) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, remote, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Lost connection to MySQL server during query at /mnt/HD_a2/squeezecenter-7.2-noCPAN/CPAN/DBIx/Class/Storage/DBI.pm line 771.
]
[08-10-26 12:37:21.9890] main::main (220) Error: Skipping post-process & Not updating lastRescanTime!
[08-10-26 12:37:30.0213] Slim::Schema::Storage::throw_exception (70) Error: DBI Connection failed: DBI connect('hostname=localhost;port=3306;database=squ eezecenter','root',...) failed: Can't connect to local MySQL server through socket '/ffp/var/run/mysql/mysql.sock' (2) at /mnt/HD_a2/squeezecenter-7.2-noCPAN/CPAN/DBIx/Class/Storage/DBI.pm line 652
[08-10-26 12:37:30.1565] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (/mnt/HD_a2/squeezecenter-7.2-noCPAN/CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 2: DBIx::Class::Storage::DBI::_connect (/mnt/HD_a2/squeezecenter-7.2-noCPAN/CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 3: DBIx::Class::Storage::DBI::_populate_dbh (/mnt/HD_a2/squeezecenter-7.2-noCPAN/CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 4: DBIx::Class::Storage::DBI::ensure_connected (/mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/Schema/Storage.pm line 29)
frame 5: (eval) (/mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/Schema/Storage.pm line 29)
frame 6: Slim::Schema::Storage::dbh (/mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/Music/Import.pm line 277)
frame 7: Slim::Music::Import::setIsScanning (/mnt/HD_a2/squeezecenter-7.2-noCPAN/scanner.pl line 339)
frame 8: main::cleanup (/mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/bootstrap.pm line 373)
frame 9: Slim::bootstrap::sigint (/mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/bootstrap.pm line 407)
frame 10: Slim::bootstrap::theEND (/mnt/HD_a2/squeezecenter-7.2-noCPAN/scanner.pl line 348)
frame 11: main::END (/mnt/HD_a2/squeezecenter-7.2-noCPAN/scanner.pl line 0)
frame 12: (eval) (/mnt/HD_a2/squeezecenter-7.2-noCPAN/scanner.pl line 0)

[08-10-26 12:37:33.5079] Slim::Schema::Storage::dbh (33) Warning: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at /mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/Schema/Storage.pm line 33.
[08-10-26 15:49:28.8864] main::main (219) Error: Failed when running main scan: [Can't call method "content_type" on an undefined value at /mnt/HD_a2/squeezecenter-7.2-noCPAN/Slim/Schema.pm line 1155