2021-01-19 08:03:10 db01 postgres[36790]: [754-1] 2021-01-19 08:03:10.972 EST [36790] evergreen@evergreen ERROR:  invalid input syntax for integer: "2237848;modifier=metabib;fi:item_lang=eng;metarecord=2237848;detail_record_view=1;detail_record_view=1;pane=advanced;copy_offset=10;copy_limit=10;qtype=subject;query=Dog Man Fictitious character Juvenile fiction;detail_record_view=1" at character 4045
2021-01-19 08:03:10 db01 postgres[36790]: [754-2] 2021-01-19 08:03:10.972 EST [36790] evergreen@evergreen STATEMENT:          -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) badge_orgs(1) estimation_strategy(inclusion) skip_check(0) check_limit(1000) from_metarecord(2237848;modifier=metabib;fi:item_lang=eng;metarecord=2237848;detail_record_view=1;detail_record_view=1;pane=advanced;copy_offset=10;copy_limit=10;qtype=subject;query=Dog Man Fictitious character Juvenile fiction;detail_record_view=1) depth(0)
2021-01-19 08:03:10 db01 postgres[36790]: [754-3] #011        WITH w AS (
2021-01-19 08:03:10 db01 postgres[36790]: [754-4]
2021-01-19 08:03:10 db01 postgres[36790]: [754-5]
2021-01-19 08:03:10 db01 postgres[36790]: [754-6] #011WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_52633$eng$_52633$),        pop_with AS (
2021-01-19 08:03:10 db01 postgres[36790]: [754-7] #011            SELECT  record,
2021-01-19 08:03:10 db01 postgres[36790]: [754-8] #011                    ARRAY_AGG(badge) AS badges,
2021-01-19 08:03:10 db01 postgres[36790]: [754-9] #011                    SUM(s.score::NUMERIC*b.weight::NUMERIC)/SUM(b.weight::NUMERIC) AS total_score
2021-01-19 08:03:10 db01 postgres[36790]: [754-10] #011              FROM  rating.record_badge_score s
2021-01-19 08:03:10 db01 postgres[36790]: [754-11] #011                    JOIN rating.badge b ON (
2021-01-19 08:03:10 db01 postgres[36790]: [754-12] #011                        b.id = s.badge
2021-01-19 08:03:10 db01 postgres[36790]: [754-13] #011 AND b.scope = ANY ('{1}')) GROUP BY 1)
2021-01-19 08:03:10 db01 postgres[36790]: [754-14] #011,c_attr AS (SELECT
2021-01-19 08:03:10 db01 postgres[36790]: [754-15]  (ARRAY_TO_STRING(ARRAY[c_attrs,search.calculate_visibility_attribute_test('circ_lib','{1,221,163,46,87,321,365,252,25,267,106,152,33,140,102,376,353,216,328,156,213,65,211,21,145,115,203,226,124,301,96,122,2,80,182,260,292,85,233,131,346,39,58,275,184,68,344,177,231,197,362,55,311,6,239,240,241,242,246,107,99,352,269,77,142,112,258,3,247,117,110,38,194,259,273,272,356,293,297,298,123,86,244,243,120,248,251,103,308,288,191,79,82,366,234,263,126,166,34,111,11,129,300,357,81,88,262,36,201,60,63,294,32,375,52,101,227,303,49,118,342,402,372,355,270,94,24,250,306,53,125,37,23,51,28,193,254,175,331,74,50,59,26,404,164,9,73,144,56,202,132,135,155,139,29,42,148,40,268,271,57,92,95,91,90,153,235,178,134,4,137,138,192,127,336,35,245,104,284,354,199,181,5,217,219,109,255,256,228,335,93,174,374,224,45,41,218,405,161,89,116,136,229,212,48,313,210,345,261,225,223,167,157,187,176,222,180,18,169,188,27,
2021-01-19 08:03:10 db01 postgres[36790]: [754-16] 343,128,349,285,236,165,172,206,204,208,207,333,147,149,108,186,220,307,183,170,209,162,360,200,305,286,160,230,326,322,323,351,196,205,317,350,171,98,72,78,320,287,314,290,282,43,67,71,61,330,30,291,15,257,150,319,66,369,358,312,113,121,151,114,100,198,179,295,296,237,276,278,281,279,329,315,154,190,83,75,318,70,265,215,54,401,304,168,361,141,173,316,280,44,340,69,22,264,76,214,130,189,379,373,7,232,381,146,383,385,377,13,10,20,8,378,386,384,380,382,143,47,289,387,389,19,390,14,394,12,391,388,392}',FALSE)],'&'))::query_int AS vis_test FROM asset.patron_default_visibility_mask() x)
2021-01-19 08:03:10 db01 postgres[36790]: [754-17] #011,b_attr AS (SELECT (b_attrs||search.calculate_visibility_attribute_test('luri_org','{1}',FALSE))::query_int AS vis_test FROM asset.patron_default_visibility_mask() x)
2021-01-19 08:03:10 db01 postgres[36790]: [754-18] #011SELECT  id,
2021-01-19 08:03:10 db01 postgres[36790]: [754-19] #011        rel,
2021-01-19 08:03:10 db01 postgres[36790]: [754-20] #011        CASE WHEN cardinality(records) = 1 THEN records[1] ELSE NULL END AS record,
2021-01-19 08:03:10 db01 postgres[36790]: [754-21] #011        NULL::INT AS total,
2021-01-19 08:03:10 db01 postgres[36790]: [754-22] #011        NULL::INT AS checked,
2021-01-19 08:03:10 db01 postgres[36790]: [754-23] #011        NULL::INT AS visible,
2021-01-19 08:03:10 db01 postgres[36790]: [754-24] #011        NULL::INT AS deleted,
2021-01-19 08:03:10 db01 postgres[36790]: [754-25] #011        NULL::INT AS excluded,
2021-01-19 08:03:10 db01 postgres[36790]: [754-26] #011        badges,
2021-01-19 08:03:10 db01 postgres[36790]: [754-27] #011        popularity
2021-01-19 08:03:10 db01 postgres[36790]: [754-28] #011  FROM  (SELECT m.source AS id,
2021-01-19 08:03:10 db01 postgres[36790]: [754-29] #011                ARRAY[m.source] AS records,
2021-01-19 08:03:10 db01 postgres[36790]: [754-30] #011                (1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1))::NUMERIC AS rel,
2021-01-19 08:03:10 db01 postgres[36790]: [754-31] #011                1.0/((1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1)))::NUMERIC AS rank,
2021-01-19 08:03:10 db01 postgres[36790]: [754-32] #011                FIRST(pubdate_t.value) AS tie_break,
2021-01-19 08:03:10 db01 postgres[36790]: [754-33] #011                STRING_AGG(ARRAY_TO_STRING(pop_with.badges,','),',') AS badges,
2021-01-19 08:03:10 db01 postgres[36790]: [754-34] #011                AVG(COALESCE(pop_with.total_score::NUMERIC,0.0::NUMERIC))::NUMERIC(2,1) AS popularity
2021-01-19 08:03:10 db01 postgres[36790]: [754-35] #011          FROM  metabib.metarecord_source_map m
2021-01-19 08:03:10 db01 postgres[36790]: [754-36]
2021-01-19 08:03:10 db01 postgres[36790]: [754-37]
2021-01-19 08:03:10 db01 postgres[36790]: [754-38] #011                INNER JOIN metabib.record_attr_vector_list mrv ON m.source = mrv.source
2021-01-19 08:03:10 db01 postgres[36790]: [754-39] #011                INNER JOIN biblio.record_entry bre ON m.source = bre.id AND NOT bre.deleted
2021-01-19 08:03:10 db01 postgres[36790]: [754-40] #011                LEFT JOIN pop_with ON ( m.source = pop_with.record )
2021-01-19 08:03:10 db01 postgres[36790]: [754-41] #011                LEFT JOIN metabib.record_sorter pubdate_t ON m.source = pubdate_t.source AND attr = 'pubdate'
2021-01-19 08:03:10 db01 postgres[36790]: [754-42] #011                ,lang_with
2021-01-19 08:03:10 db01 postgres[36790]: [754-43] #011                ,c_attr
2021-01-19 08:03:10 db01 postgres[36790]: [754-44] #011                ,b_attr
2021-01-19 08:03:10 db01 postgres[36790]: [754-45] #011          WHERE 1=1
2021-01-19 08:03:10 db01 postgres[36790]: [754-46] #011                AND (
2021-01-19 08:03:10 db01 postgres[36790]: [754-47] #011          m.metarecord IN (E'2237848;modifier=metabib;fi:item_lang=eng;metarecord=2237848;detail_record_view=1;detail_record_view=1;pane=advanced;copy_offset=10;copy_limit=10;qtype=subject;query=Dog Man Fictitious character Juvenile fiction;detail_record_view=1')
2021-01-19 08:03:10 db01 postgres[36790]: [754-48] #011        )
2021-01-19 08:03:10 db01 postgres[36790]: [754-49] #011        AND (
2021-01-19 08:03:10 db01 postgres[36790]: [754-50] #011          (EXISTS (SELECT 1 FROM asset.copy_vis_attr_cache WHERE record = m.source AND vis_attr_vector @@ c_attr.vis_test)) OR ((b_attr.vis_test IS NULL OR bre.vis_attr_vector @@ b_attr.vis_test))
2021-01-19 08:03:10 db01 postgres[36790]: [754-51] #011        )
2021-01-19 08:03:10 db01 postgres[36790]: [754-52] #011          GROUP BY 1
2021-01-19 08:03:10 db01 postgres[36790]: [754-53] #011          ORDER BY 4 ASC NULLS LAST,  5 DESC NULLS LAST, 3 DESC
2021-01-19 08:03:10 db01 postgres[36790]: [754-54] #011          LIMIT 10000
2021-01-19 08:03:10 db01 postgres[36790]: [754-55] #011        ) AS core_query
2021-01-19 08:03:10 db01 postgres[36790]: [754-56] #011) (SELECT * FROM w LIMIT 1000 OFFSET 0)
2021-01-19 08:03:10 db01 postgres[36790]: [754-57] #011        UNION ALL
2021-01-19 08:03:10 db01 postgres[36790]: [754-58] #011  SELECT NULL,NULL,NULL,COUNT(*),COUNT(*),COUNT(*),0,0,NULL,NULL FROM w;
2021-01-19 08:03:10 db01 postgres[36790]: [754-59]
2021-01-19 08:03:10 db01 postgres[36790]: [754-60]