| Paste number 58363: | searching for fiction - non-happiness |
| Pasted by: | dbs |
| When: | 1 year, 3 months ago |
| Share: | Tweet this! | http://paste.lisp.org/+1917 |
| Channel: | #openils-evergreen |
| Paste contents: |
Sending authority request for author : Broberg, O.
Sending authority request for author : Carter, I. M.
Sending authority request for author : Cooper, Charles M.
Sending authority request for author : Davison, William.
Sending authority request for author : De Haan, Henk.
Sending authority request for author : Freedman, Paul L.
Sending authority request for author : Kirk, J. T. O.
Sending authority request for author : Pulles, W.
Use of uninitialized value in concatenation (.) or string at /openils/lib/perl5/OpenILS/Application/Search/Biblio.pm line 868.
Use of uninitialized value in concatenation (.) or string at /openils/lib/perl5/OpenILS/Application/Search/Biblio.pm line 821.
Use of uninitialized value in join or string at /openils/lib/perl5/OpenSRF/Application.pm line 102.
Use of uninitialized value in concatenation (.) or string at /openils/lib/perl5/OpenILS/Application/Search/Biblio.pm line 868.
Use of uninitialized value in concatenation (.) or string at /openils/lib/perl5/OpenILS/Application/Search/Biblio.pm line 821.
received error : service=open-ils.storage : method=open-ils.storage.biblio.multiclass.staged.search_fts.atomic : params=$VAR1 = ['skip_check',0,'depth',1,'searches',{'keyword' =>
{'term' => 'fiction'}},'org_unit',12,'limit',1000,'default_class','keyword','visibility_limit',3000,'check_limit',1000,'offset',0];
Exception: OpenSRF::EX::ERROR 2008-03-31T16:15:00 OpenILS::Application::AppUtils /openils/lib/perl5/OpenILS/Application/AppUtils.pm:176 System ERROR: Exception: OpenSRF::DomainOb
ject::oilsMethodException 2008-03-31T16:15:00 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.sear
ch_fts.atomic] failed for session [1206994500.2934418700.4050794569], 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 269 at select into variables
[for Statement " SELECT *
FROM search.staged_fts(
12,
1,
$${"keyword":{"fts_query":["to_tsquery('keyword','fiction')"],"word":["fiction"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','fiction'))"],"ph
rase":[]}}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$$$$,
NULL,
$$$$,
'f',
'f',
'f',
NULL,
1000,
NULL
);
"] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
Caught error from 'run' method: Exception: OpenSRF::EX::ERROR 2008-03-31T16:15:00 OpenSRF::Application /openils/lib/perl5/OpenSRF/Application.pm:184 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-31T16:15:00 OpenILS::Application::AppUtils /openils/lib/perl5/OpenILS/Application/AppUtils.pm:177 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2008-03-31T16:15:00 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1206994500.2934418700.4050794569], 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 269 at select into variables
[for Statement " SELECT *
FROM search.staged_fts(
12,
1,
$${"keyword":{"fts_query":["to_tsquery('keyword','fiction')"],"word":["fiction"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','fiction'))"],"phrase":[]}}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$${}$$,
$$$$,
NULL,
$$$$,
'f',
'f',
'f',
NULL,
1000,
NULL
);
"] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.
:
received error : service=open-ils.storage : method=open-ils.storage.biblio.multiclass.staged.search_fts.atomic : params=$VAR1 = ['skip_check',0,'depth',1,'searches',{'keyword' => {'term' => 'fiction'}},'org_unit',12,'limit',1000,'default_class','keyword','visibility_limit',3000,'check_limit',1000,'offset',0];
Exception: OpenSRF::EX::ERROR 2008-03-31T16:17:14 OpenILS::Application::AppUtils /openils/lib/perl5/OpenILS/Application/AppUtils.pm:176 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2008-03-31T16:17:14 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1206994634.1703730.8604504609588], 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 269 at select into variables
[for Statement " SELECT *
FROM search.staged_fts(
12,
1,
$${"keyword":{"fts_query":["to_tsquery('keyword','fiction')"],"word":["fiction"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','fiction'))"],"phrase":[]}}$$,
$${}$$,
$${}$$, $${}$$, $${}$$, $${}$$, $${}$$, $${}$$, $$$$, NULL, $$$$, 'f', 'f', 'f', NULL, 1000, NULL ); "] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52. Caught error from 'run' method: Exception: OpenSRF::EX::ERROR 2008-03-31T16:17:14 OpenSRF::Application /openils/lib/perl5/OpenSRF/Application.pm:184 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-31T16:17:14 OpenILS::Application::AppUtils /openils/lib/perl5/OpenILS/Application/AppUtils.pm:177 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2008-03-31T16:17:14 OpenSRF::AppRequest /openils/lib/perl5/OpenSRF/AppSession.pm:1002 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1206994634.1703730.8604504609588], 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 269 at select into variables [for Statement " SELECT * FROM search.staged_fts( 12, 1, $${"keyword":{"fts_query":["to_tsquery('keyword','fiction')"],"word":["fiction"],"fts_rank":["rank(keyword.index_vector, to_tsquery('keyword','fiction'))"],"phrase":[]}}$$, $${}$$, $${}$$, $${}$$, $${}$$, $${}$$, $${}$$, $${}$$, $$$$, NULL, $$$$, 'f', 'f', 'f', NULL, 1000, NULL ); "] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52. Annotations for this paste:
| Annotation number 1: | miker_'s direct sql wish granted |
| Pasted by: | dbs |
| When: | 1 year, 3 months ago |
| Share: | Tweet this! | http://paste.lisp.org/+1917#1 |
| Paste contents: |
evergreen=# SELECT array_accum(distinct id) FROM actor.org_unit_descendants( 12, 0 );
array_accum
------------------------------------------------------------------------
{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26}
(1 row)