| 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: |
[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.