Paste number 58047: uh-oh, dang fancy staged search doesn't like limit by org_unit?

Paste number 58047: uh-oh, dang fancy staged search doesn't like limit by org_unit?
Pasted by: dbs
When:1 year, 3 months ago
Share:Tweet this! | http://paste.lisp.org/+18SF
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As
[2008-03-26 15:54:39] open-ils.search [ERR :10576:EX.pm:66:12065609811051358] Exception: OpenSRF::EX::ERROR 2008-03-26T15:54:39 OpenSRF::Application /openils/lib/perl5/OpenSRF/Application.pm:553 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
 failed with exception: Exception: OpenSRF::EX::ERROR 2008-03-26T15:54:39 OpenILS::Application::AppUtils /openils/lib/perl5/OpenILS/Application/AppUtils.pm:177 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2008-03-26T15:54:39 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500>   *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1206561279.04741008.09829117043], thread trace [1]:
DBD::Pg::st execute failed: ERROR:  more than one row returned by a subquery used as an expression
CONTEXT:  SQL function "org_unit_descendants" statement 1
SQL statement "SELECT  array_accum(distinct id) FROM actor.org_unit_descendants(  $1 ,  $2  )"
PL/pgSQL function "staged_fts" line 260 at select into variables
 [for Statement "        SELECT  *
          FROM  search.staged_fts(
                    8,
                    1,
                    $${"keyword":{"fts_query":["to_tsquery('keyword','canada')"],"word":["canada"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','canada'))"],"phrase":[]}}$$,
                    $${}$$,
                    $${}$$,
                    $${}$$,
                    $${}$$,
                    $${}$$,
                    $${}$$,

This paste has no annotations.

Colorize as:
Show Line Numbers

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.