Bug 4346 - Browse Folder -> crash
: Browse Folder -> crash
Status: CLOSED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 6.5.0
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-10-11 12:47 UTC by Brad Kent
Modified: 2008-12-18 11:12 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments
scanner appears to crash with this mp3 (3.81 MB, audio/mpeg)
2006-10-11 14:33 UTC, Brad Kent
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Brad Kent 2006-10-11 12:47:38 UTC
Selecting browse folder crashes slimserver
Win XP

The following information is part of the event: Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, disc, drm, filesize, lossless, rating, remote, replay_gain, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 at C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
Comment 1 Brad Kent 2006-10-11 13:16:42 UTC
running scanner.exe:

2006-10-11 15:04:23.8209 mp3 file type for file:///C:/Documents%20and%20Settings/BKENT/My%20Documents/My%20Music/Beastie_Boys_-_Son_Of_Neckbone.mp3
2006-10-11 15:04:23.8211 
2006-10-11 15:04:23.8211 newTrack(): New Track: [file:///C:/Documents%20and%20Settings/BKENT/My%20Documents/My%20Music/Beastie_Boys_-_Son_Of_Neckbone.mp3]
2006-10-11 15:04:23.8211 newTrack(): readTags is 1
2006-10-11 15:04:23.8218 mp3 file type for C:\Documents and Settings\BKENT\My Documents\My Music\Beastie_Boys_-_Son_Of_Neckbone.mp3
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 83.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 83.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 84.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 84.
Use of uninitialized value in division (/) at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 77.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 89.
2006-10-11 15:04:23.8501 ERROR: Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, disc, drm, filesize, lossless, rating, remote, replay_gain, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2006-10-11 15:04:23.8502 ERROR: Backtrace follows:

2006-10-11 15:04:23.8504 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (/PerlApp/Slim/Schema.pm line 794)
   frame 6: Slim::Schema::newTrack (/PerlApp/Slim/Utils/Scanner.pm line 322)
   frame 7: Slim::Utils::Scanner::scanDirectory (/PerlApp/Slim/Utils/Scanner.pm line 90)
   frame 8: Slim::Utils::Scanner::scanPathOrURL (scanner.pl line 168)
   frame 9: (eval) (scanner.pl line 168)
   frame 10: main::main (scanner.pl line 312)

2006-10-11 15:04:23.8517 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, disc, drm, filesize, lossless, rating, remote, replay_gain, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
]
Comment 2 KDF 2006-10-11 14:19:50 UTC
Please try the soon-to-be official release, 6.5.1 nightly builds.  If that still fails, please attach the file last scanned when this problem happens (d_scan will help flag that)
Comment 3 Brad Kent 2006-10-11 14:33:09 UTC
Created attachment 1639 [details]
scanner appears to crash with this mp3

(no luck with latest nightly..)
Comment 4 Chris Owens 2006-10-13 13:21:48 UTC
Neither the scanner nor slim crashes for me in 6.5.1, but it does show some activity in the log that makes me think it could easily crash sometimes.

.2006-10-13 12:49:56.2170 ScanDirectory: Adding file:///C:/Documents%20and%20Settings/Administrator/My%20Documents/My%20Music/Testcd/bug4346/Beastie_Boys_-_Son_Of_Neckbone.mp3 to database.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 83.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 83.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 84.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 84.
Use of uninitialized value in division (/) at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 77.
Use of uninitialized value in subroutine entry at C:\Program Files\SlimServer\server/Slim/Utils/SoundCheck.pm line 89.
.2006-10-13 12:49:56.3384 ScanDirectory: Adding file:///C:/Documents%20and%20Settings/Administrator/My%20Documents/My%20Music/Testcd/swp-10hz-22050hz.wav to database.

What program did you use to rip that MP3, Brad?
Comment 5 Brad Kent 2006-10-13 13:39:44 UTC
"Ripped by a 3rd party."

Perhaps the hard-crash is related to using pre-existing MySQL install?
exact same schema on both...

Even using integrated DB, I get flaky/incomplete scans.
This is on a "test" computer with a very small music library
Comment 6 Dan Sully 2006-10-13 13:40:01 UTC
Change 10330 should fix the warnings, and possibly the crash.

Will be in the 10-14-2006 nightly.
Comment 7 Brad Kent 2006-10-16 10:18:19 UTC
Indeed, It appears to be resolved (10-16 nightly).
Thanks much!
Only problem I'm having now is a couple
...Can't create/write to file 'C:\WINDOWS\TEMP\#sql_de4_0.MYI type errors.. perhaps related to enterprise virus scanner?
I'll give 6.5.1 a shot on my home server.   Was just testing here at work.
Comment 8 Chris Owens 2008-03-07 09:04:05 UTC
This bug is being closed since it was resolved for a version which is now released!  Please download the new version of SqueezeCenter (formerly SlimServer) at http://www.slimdevices.com/su_downloads.html

If you are still seeing this bug, please re-open it and we will consider it for a future release.