Bug 3861 - Search crashes slimserver
: Search crashes slimserver
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: PC Windows XP
: P2 major (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-08-02 01:24 UTC by Michael Herger
Modified: 2008-09-15 14:39 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Herger 2006-08-02 01:24:34 UTC
I just crashed slimserver using the advanced search's page bar: search for comment "live", returns seven pages. I hit the "next" button, slimserver crashes:

2006-08-02 10:20:03.3182 ERROR: rows attribute must be positive if present
2006-08-02 10:20:03.3183 ERROR: Backtrace follows:

2006-08-02 10:20:03.3190 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (D:\slimpy\CPAN/DBIx/Class/Storage/DBI.pm line 794)
   frame 1: DBIx::Class::Storage::DBI::_select (D:\slimpy\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79)
   frame 2: DBIx::Class::Storage::DBI::Cursor::next (D:\slimpy\CPAN/DBIx/Class/ResultSet.pm line 677)
   frame 3: DBIx::Class::ResultSet::next (D:\slimpy/Slim/Web/Pages/Search.pm line 342)
   frame 4: Slim::Web::Pages::Search::fillInSearchResults (D:\slimpy/Slim/Web/Pages/Search.pm line 265)
   frame 5: Slim::Web::Pages::Search::advancedSearch (D:\slimpy/Slim/Web/HTTP.pm line 793)
   frame 6: Slim::Web::HTTP::generateHTTPResponse (D:\slimpy/Slim/Web/HTTP.pm line 667)
   frame 7: Slim::Web::HTTP::processURL (D:\slimpy/Slim/Web/HTTP.pm line 517)
   frame 8: Slim::Web::HTTP::processHTTP (D:\slimpy/Slim/Networking/Select.pm line 170)
   frame 9: Slim::Networking::Select::select (slimserver.pl line 496)
   frame 10: main::idle (slimserver.pl line 449)
   frame 11: main::main (slimserver.pl line 1046)

LIMIT 0 Does Not Compute at D:\slimpy\CPAN/DBIx/Class/Storage/DBI.pm line 45.

This is trunk, revision 8764.
Comment 1 Michael Herger 2006-08-02 01:26:47 UTC
Some more information: I can hit page links 3-7, resulting in an empty page. Only page 2 will shut down the server immediately with the above message.
Comment 2 Jim McAtee 2006-08-02 15:18:32 UTC
I can reproduce this.  I thought Advanced Search was only supposed to return a single page of results, unless that's been intentionally changed recently.
Comment 3 Chris Owens 2006-08-02 15:27:44 UTC
I see the exact same symptoms.  I had to reduce the results-per-page to a small number since I don't have a huge number of tracks, then did an advanced search for 'a' and clicked on the 'next' or '2' link.
Comment 4 Dan Sully 2006-08-03 17:59:16 UTC
Fixed in change 8785
Comment 5 Jim McAtee 2006-08-03 19:26:14 UTC
After r8784/r8785 I'm now seeing all search results returned on a single page, ignoring itemsPerPage, with sometimes many hundreds of items returned.
Comment 6 Dan Sully 2006-08-03 19:28:35 UTC
Subject: Re:  Search crashes slimserver

When using Advanced Search? Yes, that's how it works now.