Bugzilla – Bug 4346
Browse Folder -> crash
Last modified: 2008-12-18 11:12:53 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.
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. ]
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)
Created attachment 1639 [details] scanner appears to crash with this mp3 (no luck with latest nightly..)
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?
"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
Change 10330 should fix the warnings, and possibly the crash. Will be in the 10-14-2006 nightly.
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.
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.