博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
query_phase_execution_exception
阅读量:5301 次
发布时间:2019-06-14

本文共 2138 字,大约阅读时间需要 7 分钟。

ES报错信息:

{    "error": {        "root_cause": [            {                "type": "query_phase_execution_exception",                "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [200000000]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting."            }        ],        "type": "search_phase_execution_exception",        "reason": "all shards failed",        "phase": "query",        "grouped": true,        "failed_shards": [            {                "shard": 0,                "index": "view_log",                "node": "f7Mhj8hJTbCecKixd2ZFIQ",                "reason": {                    "type": "query_phase_execution_exception",                    "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [200000000]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting."                }            }        ],        "caused_by": {            "type": "query_phase_execution_exception",            "reason": "Result window is too large, from + size must be less than or equal to: [10000] but was [200000000]. See the scroll api for a more efficient way to request large data sets. This limit can be set by changing the [index.max_result_window] index level setting."        }    },    "status": 500}

执行语句:

POST:

http://127.0.0.1:9200/demo/_search

body:

{        "query": {        "bool": {            "filter": [                {                    "match": {                        "userid": "f8d3e9ad7ec3482a9f92318eb18f8173"                    }                }            ]                    }    },    "from": 0,    "size": 200000000}

原因:从上面的报错信息,可以看到ES提示我结果窗口太大了,目前最大值为10000,而我却要求给我10000000。并且在后面也提到了要求我修改index.max_result_window参数来增大结果窗口大小。

解决:

POST:

http://127.0.0.1:9200/demo/_settings

body:

{    "index": {        "max_result_window": 100000000    }}

 

转载于:https://www.cnblogs.com/excellencesy/p/10839075.html

你可能感兴趣的文章
URL中的#
查看>>
deepin配置Oracle JDK
查看>>
在XP IIS5.1手工安装PHP 5.2.11
查看>>
iOS中unicode 转汉字
查看>>
自动生成数据库字典(sql2008)
查看>>
runloop的mode作用是什么?
查看>>
java使用axis2调用.net webservice接口
查看>>
【转载】windows10开启移动热点无法连接
查看>>
Python + Selenium操作一:截图详解
查看>>
递归输出ASP.NET页面所有控件的类型和ID
查看>>
利用c#反射实现实体类生成以及数据获取与赋值
查看>>
在Java中怎样把数组转换为ArrayList?
查看>>
二进制与十进制互转
查看>>
windows安装scipy
查看>>
HTML5 3D旋转图片相册
查看>>
Python之路,Day7 - 面向对象编程进阶
查看>>
夺命雷公狗---微信开发34----公众平台营销咨询系统3
查看>>
lsof, fuser 命令杀进程。target is busy (In some cases useful info about processes that use the de...
查看>>
C# Collection 排序
查看>>
最简单的混合开发教程资料汇总
查看>>