I download the 7.3.3 release and indeed, I did get a better error. This
time it reported that GD 2.35 was required and I was running GD 2.41.
So, I installed the older version and now the scan is working fine.
I am getting some SQL errors and Out Of Memory errors in the logs.
Does anyone have an idea how to resolve this? Do I just need to give
the perl process more memory somehow?
Code:
--------------------
[09-02-23 09:48:25.1203] Slim::Networking::IO::Select::select (271) Error:
Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT me.id,
me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album,
me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio,
me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale,
me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment,
me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable,
me.musicbrainz_id, me.lossless, me.lyrics, me.replay_gain, me.replay_peak,
me.extid FROM tracks me WHERE ( me.audio = ? AND ( ( ( ( me.titlesearch LIKE ?
) OR ( me.titlesearch LIKE ? ) ) ) ) ) GROUP BY me.id, me.url, me.content_type,
me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp,
me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset,
me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate,
me.samplesize, me.chann!
els, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm,
me.musicmagic_mixable, me.musicbrainz_id, me.lossless, me.lyrics,
me.replay_gain, me.replay_peak, me.extid ORDER BY me.disc, me.titlesort LIMIT
50':
DBD::MYSQL::ST EXECUTE FAILED: OUT OF MEMORY; RESTART SERVER AND TRY AGAIN
(NEEDED 65528 BYTES) AT /USR/LOCAL/SQUEEZECENTER/CPAN/DBIX/CLASS/STORAGE/DBI.PM
LINE 771.
[09-02-23 09:50:55.2713] Slim::Schema::Storage::throw_exception (81) Error:
Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES
(?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a
foreign key constraint fails (`slimserver7/playlist_track`, CONSTRAINT
`playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON
DELETE CASCADE) at /usr/local/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line
771.
[09-02-23 09:50:55.2722] Slim::Schema::Storage::throw_exception (81)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/local/squeezecenter/Slim/Schema/Storage.pm line 81)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/local/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute
(/usr/local/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 788)
frame 3: DBIx::Class::Storage::DBI::insert
(/usr/local/squeezecenter/CPAN/DBIx/Class/Row.pm line 75)
frame 4: DBIx::Class::Row::insert
(/usr/local/squeezecenter/CPAN/DBIx/Class/PK/Auto.pm line 43)
frame 5: DBIx::Class::PK::Auto::insert
(/usr/local/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 1335)
frame 6: DBIx::Class::ResultSet::create
(/usr/local/squeezecenter/Slim/Schema/Playlist.pm line 108)
frame 7: Slim::Schema::Playlist::_addTracksToPlaylist
(/usr/local/squeezecenter/Slim/Schema/Playlist.pm line 45)
frame 8: Slim::Schema::Playlist::__ANON__
(/usr/local/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584)
frame 9: (eval) (/usr/local/squeezecenter/CPAN/DBIx/Class/Schema.pm line 572)
frame 10: DBIx::Class::Schema::txn_do
(/usr/local/squeezecenter/Slim/Schema/Playlist.pm line 46)
frame 11: (eval) (/usr/local/squeezecenter/Slim/Schema/Playlist.pm line 39)
frame 12: Slim::Schema::Playlist::setTracks
(/usr/local/squeezecenter/Slim/Utils/Scanner/Remote.pm line 835)
frame 13: Slim::Utils::Scanner::Remote::__ANON__
(/usr/local/squeezecenter/Slim/Utils/Scanner/Remote.pm line 480)
frame 14: Slim::Utils::Scanner::Remote::readRemoteHeaders
(/usr/local/squeezecenter/Slim/Networking/Async/HTTP.pm line 389)
frame 15: Slim::Networking::Async::HTTP::_http_read
(/usr/local/squeezecenter/Slim/Networking/Async.pm line 274)
frame 16: Slim::Networking::Async::_async_read
(/usr/local/squeezecenter/Slim/Networking/IO/Select.pm line 268)
frame 17: (eval) (/usr/local/squeezecenter/Slim/Networking/IO/Select.pm line
268)
frame 18: Slim::Networking::IO::Select::select
(/usr/local/squeezecenter/slimserver.pl line 536)
frame 19: main::idle (/usr/local/squeezecenter/slimserver.pl line 481)
frame 20: main::main (/usr/local/squeezecenter/slimserver.pl line 1048)
--------------------
--
golferx12
------------------------------------------------------------------------
golferx12's Profile: http://forums.slimdevices.com/member.php?userid=9637
View this thread: http://forums.slimdevices.com/showthread.php?t=60530
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/unix
