| Paste number 58047: | uh-oh, dang fancy staged search doesn't like limit by org_unit? |
| Pasted by: | dbs |
| 8 months, 6 days ago | |
| #openils-evergreen | Context in IRC logs | |
| 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.