API tools faq
paste
Advertisement
Guest User

Error when clicking browse entry

a guest
May 26th, 2016
56
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.34 KB | None | 0 0
raw download clone embed print report
  1. [2016-05-26 13:47:53] open-ils.storage [WARN:27910:Application.pm:595:14641971063223715] open-ils.storage.biblio.multiclass.staged.search_fts: DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  2. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  3. FROM search.query_parser_fts(
  4. 1::INT,
  5. 0::INT,
  6. $core_query_27910$
  7. WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_27910$eng$_27910$), pop_with AS (
  8. SELECT record,
  9. ARRAY_AGG(badge) AS badges,
  10. SUM(s.score::NUMERIC*b.weight::NUMERIC)/SUM(b.weight::NUMERIC) AS total_score
  11. FROM rating.record_badge_score s
  12. JOIN rating.badge b ON (
  13. b.id = s.badge
  14. AND b.scope = ANY ('{1}')) GROUP BY 1)
  15. SELECT m.source AS id,
  16. ARRAY[m.source] AS records,
  17. (AVG(
  18. (1)
  19. )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1)) AS rel,
  20. 1.0/((AVG(
  21. (1)
  22. )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_wi
  23. [2016-05-26 13:47:53] open-ils.storage [INFO:27910:Transport.pm:163:14641971063223715] Message processing duration: 0.154
  24. [2016-05-26 13:47:53] open-ils.search [ERR :30076:EX.pm:66:14641971063223715] Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  25. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  26. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  27. FROM search.query_parser_fts(
  28. 1::INT,
  29. 0::INT,
  30. $core_query_27910$
  31. WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_27910$eng$_27910$), pop_with AS (
  32. SELECT record,
  33. ARRAY_AGG(badge) AS badges,
  34. SUM(s.score::NUMERIC*b.weight::NUMERIC)/SUM(b.weight::NUMERIC) AS total_score
  35. FROM rating.record_badge_score s
  36. JOIN rating
  37. [2016-05-26 13:47:53] open-ils.search [WARN:30076:Application.pm:595:14641971063223715] open-ils.search.biblio.multiclass.staged: received error : service=open-ils.storage : method=open-ils.storage.biblio.multiclass.staged.search_fts.atomic : params=$VAR1 = ['limit',1000,'check_limit',1000,'core_limit',10000,'searches',{'keyword' => {'term' => ' has_browse_entry(1371,32) depth(0)'}},'skip_check',0,'offset',0,'estimation_strategy','inclusion'];
  38. Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:200 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  39. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  40. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  41. FROM search.query_parser_fts(
  42. 1::INT,
  43. 0::INT,
  44. $core_query_27910$
  45. [2016-05-26 13:47:53] open-ils.search [ERR :30076:EX.pm:66:14641971063223715] Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
  46. failed with exception: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  47. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  48. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  49. FROM search.query_parser_fts(
  50. 1::INT,
  51. 0::INT,
  52. $core_query_27910$
  53. WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND co
  54. [2016-05-26 13:47:53] open-ils.search [ERR :30076:EX.pm:66:14641971063223715] Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::Application /usr/local/share/perl/5.18.2/OpenSRF/Application.pm:612 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
  55. failed with exception: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  56. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  57. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  58. FROM search.query_parser_fts(
  59. 1::INT,
  60. 0::INT,
  61. $core_query_27910$
  62. WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND co
  63. [2016-05-26 13:47:53] open-ils.search [ERR :30076:EX.pm:66:14641971063223715] Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::Application /usr/local/share/perl/5.18.2/OpenSRF/Application.pm:612 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
  64. failed with exception: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  65. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  66. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  67. FROM search.query_parser_fts(
  68. 1::INT,
  69. 0::INT,
  70. $core_query_27910$
  71. WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_27910$eng$_2
  72. [2016-05-26 13:47:53] open-ils.search [ERR :30076:EX.pm:66:14641971063223715] Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::Application /usr/local/share/perl/5.18.2/OpenSRF/Application.pm:612 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
  73. failed with exception: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  74. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  75. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) badge_orgs(1) estimation_strategy(inclusion) keyword: has_browse_entry(1371,32) depth(0)
  76. FROM search.query_parser_fts(
  77. 1::INT,
  78. 0::INT,
  79. $core_query_27910$
  80. WITH lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_27910$eng$_2
  81. [2016-05-26 13:47:53] open-ils.search [INFO:30076:Transport.pm:163:14641971063223715] Message processing duration: 0.174
  82. [2016-05-26 13:47:53] /usr/sbin/apache2 [ERR :32237:EX.pm:66:14641971063223715] Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.search.biblio.multiclass.query] failed for session [1464284873.421698577.32522428591], thread trace [1]:
  83. Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::Application /usr/local/share/perl/5.18.2/OpenSRF/Application.pm:234 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
  84. failed with exception: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  85. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  86. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assignment [for Statement " SELECT * -- bib
  87. [2016-05-26 13:47:53] /usr/sbin/apache2 [ERR :32237:Search.pm:455:14641971063223715] multiclass search error: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::WWW::EGCatLoader /usr/local/share/perl/5.18.2/OpenILS/WWW/EGCatLoader/Search.pm:455 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.search.biblio.multiclass.query] failed for session [1464284873.421698577.32522428591], thread trace [1]:
  88. Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenSRF::Application /usr/local/share/perl/5.18.2/OpenSRF/Application.pm:234 System ERROR: Call to open-ils.storage for method open-ils.storage.biblio.multiclass.staged.search_fts.atomic
  89. failed with exception: Exception: OpenSRF::EX::ERROR 2016-05-26T13:47:53 OpenILS::Application::AppUtils /usr/local/share/perl/5.18.2/OpenILS/Application/AppUtils.pm:201 System ERROR: Exception: OpenSRF::DomainObject::oilsMethodException 2016-05-26T13:47:53 OpenSRF::AppRequest /usr/local/share/perl/5.18.2/OpenSRF/AppSession.pm:1086 <500> *** Call to [open-ils.storage.biblio.multiclass.staged.search_fts.atomic] failed for session [1464284873.430214848.64761893417], thread trace [1]:
  90. DBD::Pg::st execute failed: ERROR: type of parameter 56 (numeric) does not match that when preparing the plan (double precision)
  91. CONTEXT: PL/pgSQL function search.query_parser_fts(integer,integer,text,integer[],integer[],integer,integer,integer,boolean,boolean,boolean,integer) line 319 at assig
  92. [2016-05-26 13:47:53] /usr/sbin/apache2 [INFO:32237:CStoreEditor.pm:139:14641971063223715] editor[0|0] request en-US open-ils.cstore.direct.config.global_flag.search.atomic {"name":{"!=":null}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!