· 5 years ago · Mar 31, 2020, 07:14 PM
1SELECT “custom_fields_fields”.* FROM “custom_fields_fields” WHERE “custom_fields_fields”.“class_slug” = $1 AND “custom_fields_fields”.“company_id” = $2 [[“class_slug”, “stakeholder_mgmt_stakeholder”], [“company_id”, “1"]]
2Completed 500 Internal Server Error in 65ms (ActiveRecord: 17.5ms)
3[400] {“error”:{“root_cause”:[{“type”:“query_shard_exception”,“reason”:“failed to create query: {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“company_id\” : {\n \“query\” : \“1\“,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n },\n {\n \“exists\” : {\n \“field\” : \“address\“,\n \“boost\” : 1.0\n }\n },\n {\n \“nested\” : {\n \“query\” : {\n \“bool\” : {\n \“should\” : [\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -75.9492647,\n 40.3297839\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -118.3819598,\n 34.1394314\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n \“path\” : \“addresses\“,\n \“ignore_unmapped\” : false,\n \“score_mode\” : \“avg\“,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n}“,”index_uuid”:“bleQKeynQS2b3rgdqzeaew”,“index”:“stakeholder_mgmt_stakeholders_v3”}],“type”:“search_phase_execution_exception”,“reason”:“all shards failed”,“phase”:“query”,“grouped”:true,“failed_shards”:[{“shard”:0,“index”:“stakeholder_mgmt_stakeholders_v3",“node”:“tPxjU32lRliZGoKhjg8d7w”,“reason”:{“type”:“query_shard_exception”,“reason”:“failed to create query: {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“company_id\” : {\n \“query\” : \“1\“,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n },\n {\n \“exists\” : {\n \“field\” : \“address\“,\n \“boost\” : 1.0\n }\n },\n {\n \“nested\” : {\n \“query\” : {\n \“bool\” : {\n \“should\” : [\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -75.9492647,\n 40.3297839\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -118.3819598,\n 34.1394314\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n \“path\” : \“addresses\“,\n \“ignore_unmapped\” : false,\n \“score_mode\” : \“avg\“,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n}“,”index_uuid”:“bleQKeynQS2b3rgdqzeaew”,“index”:“stakeholder_mgmt_stakeholders_v3”,“caused_by”:{“type”:“illegal_state_exception”,“reason”:“[nested] failed to find nested object under path [addresses]“}}}]},“status”:400} excluded from capture: No host specified, no public_key specified, no secret_key specified, no project_id specified
4
5Elasticsearch::Transport::Transport::Errors::BadRequest ([400] {“error”:{“root_cause”:[{“type”:“query_shard_exception”,“reason”:“failed to create query: {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“company_id\” : {\n \“query\” : \“1\“,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n },\n {\n \“exists\” : {\n \“field\” : \“address\“,\n \“boost\” : 1.0\n }\n },\n {\n \“nested\” : {\n \“query\” : {\n \“bool\” : {\n \“should\” : [\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -75.9492647,\n 40.3297839\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -118.3819598,\n 34.1394314\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n \“path\” : \“addresses\“,\n \“ignore_unmapped\” : false,\n \“score_mode\” : \“avg\“,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n}“,”index_uuid”:“bleQKeynQS2b3rgdqzeaew”,“index”:“stakeholder_mgmt_stakeholders_v3”}],“type”:“search_phase_execution_exception”,“reason”:“all shards failed”,“phase”:“query”,“grouped”:true,“failed_shards”:[{“shard”:0,“index”:“stakeholder_mgmt_stakeholders_v3",“node”:“tPxjU32lRliZGoKhjg8d7w”,“reason”:{“type”:“query_shard_exception”,“reason”:“failed to create query: {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“company_id\” : {\n \“query\” : \“1\“,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n },\n {\n \“exists\” : {\n \“field\” : \“address\“,\n \“boost\” : 1.0\n }\n },\n {\n \“nested\” : {\n \“query\” : {\n \“bool\” : {\n \“should\” : [\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -75.9492647,\n 40.3297839\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n {\n \“bool\” : {\n \“must\” : [\n {\n \“match\” : {\n \“addresses.primary\” : {\n \“query\” : true,\n \“operator\” : \“AND\“,\n \“prefix_length\” : 0,\n \“max_expansions\” : 50,\n \“fuzzy_transpositions\” : true,\n \“lenient\” : false,\n \“zero_terms_query\” : \“NONE\“,\n \“boost\” : 1.0\n }\n }\n }\n ],\n \“filter\” : [\n {\n \“geo_distance\” : {\n \“addresses.location\” : [\n -118.3819598,\n 34.1394314\n ],\n \“distance\” : 48280.32,\n \“distance_type\” : \“arc\“,\n \“validation_method\” : \“STRICT\“,\n \“ignore_unmapped\” : false,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n },\n \“path\” : \“addresses\“,\n \“ignore_unmapped\” : false,\n \“score_mode\” : \“avg\“,\n \“boost\” : 1.0\n }\n }\n ],\n \“disable_coord\” : false,\n \“adjust_pure_negative\” : true,\n \“boost\” : 1.0\n }\n}“,”index_uuid”:“bleQKeynQS2b3rgdqzeaew”,“index”:“stakeholder_mgmt_stakeholders_v3”,“caused_by”:{“type”:“illegal_state_exception”,“reason”:“[nested] failed to find nested object under path [addresses]“}}}]},“status”:400}):
6 lib/search/base/strategy.rb:70:in `perform_search’
7 lib/search/base/strategy.rb:56:in `search_results’
8 lib/search/base/strategy.rb:42:in `search’
9 app/controllers/api_web/stakeholder_mgmt/stakeholders_controller.rb:38:in `map’
10 app/controllers/application_controller.rb:71:in `set_time_zone’
11 lib/moneyball_service_proxy.rb:37:in `perform_request’
12
13
14 Rendered vendor/bundle/ruby/2.4.0/bundler/gems/rails-f01074ec3523/actionpack/lib/action_dispatch/middleware/templates/rescues/_source.erb (3.5ms)
15 Rendered vendor/bundle/ruby/2.4.0/bundler/gems/rails-f01074ec3523/actionpack/lib/action_dispatch/middleware/templates/rescues/_trace.text.erb (0.6ms)
16 Rendered vendor/bundle/ruby/2.4.0/bundler/gems/rails-f01074ec3523/actionpack/lib/action_dispatch/middleware/templates/rescues/_request_and_response.text.erb (0.5ms)
17 Rendered vendor/bundle/ruby/2.4.0/bundler/gems/rails-f01074ec3523/actionpack/lib/action_dispatch/middleware/templates/rescues/diagnostics.text.erb (80.1ms)