Hi all. I'm having a problem with my installation of SlimServer 6.5.2
(plus 'change 12074' (http://svn.slimdevices.com/?rev=12074&view=rev)
to fix an earlier searching problem) on a Debian install on a
LinkStation Pro.
When I use "Advanced Search" (searching for an artist containing the
word "Kings" in this example) I get no results, and the following
backtrace is logged:
Code:
--------------------
2007-07-06 16:59:52.9516 Backtrace:
frame 0: Slim::Schema::Storage::throw_exception
(/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 775)
frame 1: DBIx::Class::Storage::DBI::_execute
(/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 828)
frame 2: DBIx::Class::Storage::DBI::_select
(/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next
(/usr/share/perl5/DBIx/Class/ResultSet.pm line 731)
frame 4: DBIx::Class::ResultSet::next
(/usr/share/perl5/Slim/Web/Pages/Search.pm line 346)
frame 5: Slim::Web::Pages::Search::fillInSearchResults
(/usr/share/perl5/Slim/Web/Pages/Search.pm line 265)
frame 6: Slim::Web::Pages::Search::advancedSearch
(/usr/share/perl5/Slim/Web/HTTP.pm line 828)
frame 7: Slim::Web::HTTP::generateHTTPResponse
(/usr/share/perl5/Slim/Web/HTTP.pm line 694)
frame 8: Slim::Web::HTTP::processURL (/usr/share/perl5/Slim/Web/HTTP.pm line
540)
frame 9: Slim::Web::HTTP::processHTTP
(/usr/share/perl5/Slim/Networking/Select.pm line 238)
frame 10: (eval) (/usr/share/perl5/Slim/Networking/Select.pm line 238)
frame 11: Slim::Networking::Select::select (/usr/sbin/slimserver line 493)
frame 12: main::idle (/usr/sbin/slimserver line 446)
frame 13: main::main (/usr/sbin/slimserver line 1072)
2007-07-06 16:59:52.9928 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.thumb, 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.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable,
me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics,
me.rating, me.replay_gain, me.replay_peak FROM tracks me LEFT JOIN
contributor_track contributorTracks ON ( contributorTracks.track = me.id )
JOIN contributors contributor ON ( contributor.id =
contributorTracks.contributor ) WHERE ( ( ( contributor.namesearch LIKE ? ) )
AND ( ( contributorTracks.role = ? ) OR ( contributorTracks.role = ? ) ) )
ORDER BY me.disc, me.titlesort': DBD::mysql::st execute failed: Error writing
file '/tmp/MY5pGgvS' (Errcode: 28) at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 773.
--------------------
(In case anyone's browser or mail client doesn't like that very long
line at the end, it ends with this error: *DBD::mysql::st execute
failed: Error writing file '/tmp/MY5pGgvS' (Errcode: 28) at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 773*.)
The "Search Music" search works fine. Searching from the SqueezeBox
itself (either with the basic search or with the LazySearch plugin)
gives no results, although I haven't enabled debug output for that yet
-- I thought I'd start with this one.
I note that I've seen a similar error message when trying to re-index
the music library. The nightly scheduled rescan never seems to pick
anything up. I've tried running slimserver-scanner at the command
line, but if I'm not root when I do so I get that error message
(although the backtrace may differ; I'm currently trying to reproduce
that!).
I therefore wonder if I have a permissions problem. I'm quite familiar
with linux but I'm weak on permissions, so would appreciate any advice.
The slimserver process runs as the user 'slimserver'; if I change to
that user in a shell, I can write to the /tmp directory. The /tmp
directory is in its own partitition with about 10M of space free; could
these searches be generating so much data that the temporary file is
that large? (My library has ~16000 tracks in it, but only 4 artists
would match my "kings" search.)
Thanks in advance for any ideas.
--
smst
------------------------------------------------------------------------
smst's Profile: http://forums.slimdevices.com/member.php?userid=752
View this thread: http://forums.slimdevices.com/showthread.php?t=36623
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
