# Query error appearance **URL:** \ **Category:** Elasticsearch\ **Created:** [March 20, 2015, 4:37am UTC](https://discuss.elastic.co/t/query-error-appearance/22772 "2015-03-20T04:37:39Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![trungmv](https://avatars.discourse-cdn.com/v4/letter/t/da6949/32.png) [@trungmv](https://discuss.elastic.co/u/trungmv)\ **Post date:** [March 20, 2015, 4:37am UTC](https://discuss.elastic.co/t/query-error-appearance/22772/1 "2015-03-20T04:37:39Z")
Hello experts, I have problem with red title on Kibana3: _Oops!_ SearchPhaseExecutionException[Failed to execute phase [query], all shards failed] I also check on elasticsearch and notification message: [Mentallo] All shards failed for phase: [query] Here is my configured: _{ "cluster\_name" : "elasticsearch", "nodes" : { "XzC8r3fqSRienP1K0MfXog" : { "name" : "Left Hand", "transport\_address" : "inet[localhost/127.0.0.1:9300]", "host" : "VMVNSYSEC01.global", "ip" : "10.126.122.28", "version" : "1.1.2", "build" : "e511f7b", "http\_address" : "inet[localhost/127.0.0.1:9200]", "settings" : { "path" : { "data" : "/var/lib/elasticsearch", "work" : "/tmp/elasticsearch", "home" : "/usr/share/elasticsearch", "conf" : "/etc/elasticsearch", "logs" : "/var/log/elasticsearch" }, "pidfile" : "/var/run/elasticsearch/elasticsearch.pid", "cluster" : { "name" : "elasticsearch" }, "script" : { "disable\_dynamic" : "true" }, "discovery" : { "zen" : { "ping" : { "multicast" : { "enabled" : "false" } } } }, "network" : { "host" : "localhost" }, "name" : "Left Hand" }, "os" : { "refresh\_interval" : 1000, "available\_processors" : 4, "cpu" : { "vendor" : "Intel", "model" : "Xeon", "mhz" : 2666, "total\_cores" : 4, "total\_sockets" : 2, "cores\_per\_socket" : 2, "cache\_size\_in\_bytes" : 8192 }, "mem" : { "total\_in\_bytes" : 3951484928 }, "swap" : { "total\_in\_bytes" : 4194299904 } }, "process" : { "refresh\_interval" : 1000, "id" : 16107, "max\_file\_descriptors" : 65535, "mlockall" : false }, "jvm" : { "pid" : 16107, "version" : "1.7.0\_75", "vm\_name" : "OpenJDK 64-Bit Server VM", "vm\_version" : "24.75-b04", "vm\_vendor" : "Oracle Corporation", "start\_time" : 1426820328788, "mem" : { "heap\_init\_in\_bytes" : 268435456, "heap\_max\_in\_bytes" : 1038876672, "non\_heap\_init\_in\_bytes" : 24313856, "non\_heap\_max\_in\_bytes" : 224395264, "direct\_max\_in\_bytes" : 1038876672 }, "gc\_collectors" : ["ParNew", "ConcurrentMarkSweep"], "memory\_pools" : [ "Code Cache", "Par Eden Space", "Par Survivor Space", "CMS Old Gen", "CMS Perm Gen" ] }, "thread\_pool" : { "generic" : { "type" : "cached", "keep\_alive" : "30s" }, "index" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "200" }, "get" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "1k" }, "snapshot" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "merge" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "suggest" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "1k" }, "bulk" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "50" }, "optimize" : { "type" : "fixed", "min" : 1, "max" : 1 }, "warmer" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "flush" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "search" : { "type" : "fixed", "min" : 12, "max" : 12, "queue\_size" : "1k" }, "percolate" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "1k" }, "management" : { "type" : "scaling", "min" : 1, "max" : 5, "keep\_alive" : "5m" }, "refresh" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" } }, "network" : { "refresh\_interval" : 5000, "primary\_interface" : { "address" : "10.126.122.28", "name" : "eth0", "mac\_address" : "00:50:56:AC:19:F5" } }, "transport" : { "bound\_address" : "inet[/127.0.0.1:9300]", "publish\_address" : "inet[localhost/127.0.0.1:9300]" }, "http" : { "bound\_address" : "inet[/127.0.0.1:9200]", "publish\_address" : "inet[localhost/127.0.0.1:9200]", "max\_content\_length\_in\_bytes" : 104857600 }, "plugins" : [] }, "GSOV018XTMKfVJgjAlynNw" : { "name" : "logstash-VMVNSYSEC01.global-16198-2016", "transport\_address" : "inet[/10.126.122.28:9301]", "host" : "VMVNSYSEC01.global", "ip" : "10.126.122.28", "version" : "1.1.1", "build" : "f1585f0", "attributes" : { "client" : "true", "data" : "false" }, "settings" : { "path" : { "logs" : "/var/lib/logstash/logs" }, "cluster" : { "name" : "elasticsearch" }, "node" : { "client" : "true", "name" : "logstash-VMVNSYSEC01.global-16198-2016" }, "discovery" : { "zen" : { "ping" : { "unicast" : { "hosts" : "localhost:9300,localhost:9301,localhost:9302,localhost:9303,localhost:9304,localhost:9305" }, "multicast" : { "enabled" : "false" } } } }, "http" : { "enabled" : "false" }, "name" : "logstash-VMVNSYSEC01.global-16198-2016" }, "os" : { "refresh\_interval" : 1000, "available\_processors" : 4 }, "process" : { "refresh\_interval" : 1000, "id" : 16198, "max\_file\_descriptors" : 16384, "mlockall" : false }, "jvm" : { "pid" : 16198, "version" : "1.7.0\_75", "vm\_name" : "OpenJDK 64-Bit Server VM", "vm\_version" : "24.75-b04", "vm\_vendor" : "Oracle Corporation", "start\_time" : 1426820340303, "mem" : { "heap\_init\_in\_bytes" : 61741952, "heap\_max\_in\_bytes" : 506855424, "non\_heap\_init\_in\_bytes" : 24313856, "non\_heap\_max\_in\_bytes" : 224395264, "direct\_max\_in\_bytes" : 506855424 }, "gc\_collectors" : ["ParNew", "ConcurrentMarkSweep"], "memory\_pools" : [ "Code Cache", "Par Eden Space", "Par Survivor Space", "CMS Old Gen", "CMS Perm Gen" ] }, "thread\_pool" : { "generic" : { "type" : "cached", "keep\_alive" : "30s" }, "index" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "200" }, "get" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "1k" }, "snapshot" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "merge" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "suggest" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "1k" }, "bulk" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "50" }, "optimize" : { "type" : "fixed", "min" : 1, "max" : 1 }, "warmer" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "flush" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" }, "search" : { "type" : "fixed", "min" : 12, "max" : 12, "queue\_size" : "1k" }, "percolate" : { "type" : "fixed", "min" : 4, "max" : 4, "queue\_size" : "1k" }, "management" : { "type" : "scaling", "min" : 1, "max" : 5, "keep\_alive" : "5m" }, "refresh" : { "type" : "scaling", "min" : 1, "max" : 2, "keep\_alive" : "5m" } }, "network" : { "refresh\_interval" : 5000, "primary\_interface" : { "address" : "", "name" : "", "mac\_address" : "" } }, "transport" : { "bound\_address" : "inet[/0:0:0:0:0:0:0:0%0:9301]", "publish\_address" : "inet[/10.126.122.28:9301]" }, "plugins" : [] } }}_ Any help is very very appreciated, Regards, -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/126c67b6-e866-431f-a18f-156dd3ae3136%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/126c67b6-e866-431f-a18f-156dd3ae3136%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![trungmv](https://avatars.discourse-cdn.com/v4/letter/t/da6949/32.png) [@trungmv](https://discuss.elastic.co/u/trungmv)\ **Post date:** [April 4, 2015, 3:40am UTC](https://discuss.elastic.co/t/query-error-appearance/22772/2 "2015-04-04T03:40:46Z")
Any one can help me this? Regards, On Friday, 20 March 2015 11:37:39 UTC+7, Minh Trung wrote: > Hello experts, > > I have problem with red title on Kibana3: _Oops!_ > SearchPhaseExecutionException[Failed to execute phase [query], all shards > failed] > I also check on elasticsearch and notification message: [Mentallo] All > shards failed for phase: [query] > Here is my configured: > > _{ "cluster\_name" : "elasticsearch", "nodes" : { > "XzC8r3fqSRienP1K0MfXog" : { "name" : "Left Hand", > "transport\_address" : "inet[localhost/127.0.0.1:9300 > [http://127.0.0.1:9300](http://127.0.0.1:9300)]", "host" : "VMVNSYSEC01.global", "ip" : > "10.126.122.28", "version" : "1.1.2", "build" : "e511f7b", > "http\_address" : "inet[localhost/127.0.0.1:9200 > [http://127.0.0.1:9200](http://127.0.0.1:9200)]", "settings" : { "path" : { > "data" : "/var/lib/elasticsearch", "work" : > "/tmp/elasticsearch", "home" : > "/usr/share/elasticsearch", "conf" : > "/etc/elasticsearch", "logs" : "/var/log/elasticsearch" > }, "pidfile" : "/var/run/elasticsearch/elasticsearch.pid", > "cluster" : { "name" : "elasticsearch" }, "script" : > { "disable\_dynamic" : "true" }, "discovery" : > { "zen" : { "ping" : { "multicast" : > { "enabled" : "false" } } > } }, "network" : { "host" : "localhost" > }, "name" : "Left Hand" }, "os" : { > "refresh\_interval" : 1000, "available\_processors" : 4, "cpu" > : { "vendor" : "Intel", "model" : "Xeon", "mhz" > : 2666, "total\_cores" : 4, "total\_sockets" : 2, > "cores\_per\_socket" : 2, "cache\_size\_in\_bytes" : 8192 > }, "mem" : { "total\_in\_bytes" : 3951484928 }, > "swap" : { "total\_in\_bytes" : 4194299904 } }, > "process" : { "refresh\_interval" : 1000, "id" : 16107, > "max\_file\_descriptors" : 65535, "mlockall" : false }, > "jvm" : { "pid" : 16107, "version" : "1.7.0\_75", > "vm\_name" : "OpenJDK 64-Bit Server VM", "vm\_version" : > "24.75-b04", "vm\_vendor" : "Oracle Corporation", "start\_time" > : 1426820328788, "mem" : { "heap\_init\_in\_bytes" : > 268435456, "heap\_max\_in\_bytes" : 1038876672, > "non\_heap\_init\_in\_bytes" : 24313856, "non\_heap\_max\_in\_bytes" : > 224395264, "direct\_max\_in\_bytes" : 1038876672 }, > "gc\_collectors" : ["ParNew", "ConcurrentMarkSweep"], > "memory\_pools" : [ "Code Cache", "Par Eden Space", "Par Survivor Space", > "CMS Old Gen", "CMS Perm Gen" ] }, "thread\_pool" : { > "generic" : { "type" : "cached", "keep\_alive" : > "30s" }, "index" : { "type" : "fixed", > "min" : 4, "max" : 4, "queue\_size" : "200" > }, "get" : { "type" : "fixed", "min" : 4, > "max" : 4, "queue\_size" : "1k" }, "snapshot" : > { "type" : "scaling", "min" : 1, "max" : > 2, "keep\_alive" : "5m" }, "merge" : { > "type" : "scaling", "min" : 1, "max" : 2, > "keep\_alive" : "5m" }, "suggest" : { "type" : > "fixed", "min" : 4, "max" : 4, "queue\_size" : > "1k" }, "bulk" : { "type" : "fixed", "min" > : 4, "max" : 4, "queue\_size" : "50" }, > "optimize" : { "type" : "fixed", "min" : 1, > "max" : 1 }, "warmer" : { "type" : > "scaling", "min" : 1, "max" : 2, "keep\_alive" : > "5m" }, "flush" : { "type" : "scaling", > "min" : 1, "max" : 2, "keep\_alive" : "5m" > }, "search" : { "type" : "fixed", "min" : > 12, "max" : 12, "queue\_size" : "1k" }, > "percolate" : { "type" : "fixed", "min" : 4, > "max" : 4, "queue\_size" : "1k" }, "management" : > { "type" : "scaling", "min" : 1, "max" : > 5, "keep\_alive" : "5m" }, "refresh" : { > "type" : "scaling", "min" : 1, "max" : 2, > "keep\_alive" : "5m" } }, "network" : { > "refresh\_interval" : 5000, "primary\_interface" : { > "address" : "10.126.122.28", "name" : "eth0", > "mac\_address" : "00:50:56:AC:19:F5" } }, "transport" : > { "bound\_address" : "inet[/127.0.0.1:9300 > [http://127.0.0.1:9300](http://127.0.0.1:9300)]", "publish\_address" : > "inet[localhost/127.0.0.1:9300 [http://127.0.0.1:9300](http://127.0.0.1:9300)]" }, > "http" : { "bound\_address" : "inet[/127.0.0.1:9200 > [http://127.0.0.1:9200](http://127.0.0.1:9200)]", "publish\_address" : > "inet[localhost/127.0.0.1:9200 [http://127.0.0.1:9200](http://127.0.0.1:9200)]", > "max\_content\_length\_in\_bytes" : 104857600 }, "plugins" : [] > }, "GSOV018XTMKfVJgjAlynNw" : { "name" : > "logstash-VMVNSYSEC01.global-16198-2016", "transport\_address" : > "inet[/10.126.122.28:9301 [http://10.126.122.28:9301](http://10.126.122.28:9301)]", "host" : > "VMVNSYSEC01.global", "ip" : "10.126.122.28", "version" : > "1.1.1", "build" : "f1585f0", "attributes" : { "client" : > "true", "data" : "false" }, "settings" : { "path" : > { "logs" : "/var/lib/logstash/logs" }, "cluster" : > { "name" : "elasticsearch" }, "node" : { > "client" : "true", "name" : > "logstash-VMVNSYSEC01.global-16198-2016" }, "discovery" : > { "zen" : { "ping" : { "unicast" : > { "hosts" : > "localhost:9300,localhost:9301,localhost:9302,localhost:9303,localhost:9304,localhost:9305" > }, "multicast" : { "enabled" : > "false" } } } }, "http" : > { "enabled" : "false" }, "name" : > "logstash-VMVNSYSEC01.global-16198-2016" }, "os" : { > "refresh\_interval" : 1000, "available\_processors" : 4 }, > "process" : { "refresh\_interval" : 1000, "id" : 16198, > "max\_file\_descriptors" : 16384, "mlockall" : false }, > "jvm" : { "pid" : 16198, "version" : "1.7.0\_75", > "vm\_name" : "OpenJDK 64-Bit Server VM", "vm\_version" : > "24.75-b04", "vm\_vendor" : "Oracle Corporation", "start\_time" > : 1426820340303, "mem" : { "heap\_init\_in\_bytes" : > 61741952, "heap\_max\_in\_bytes" : 506855424, > "non\_heap\_init\_in\_bytes" : 24313856, "non\_heap\_max\_in\_bytes" : > 224395264, "direct\_max\_in\_bytes" : 506855424 }, > "gc\_collectors" : ["ParNew", "ConcurrentMarkSweep"], > "memory\_pools" : [ "Code Cache", "Par Eden Space", "Par Survivor Space", > "CMS Old Gen", "CMS Perm Gen" ] }, "thread\_pool" : { > "generic" : { "type" : "cached", "keep\_alive" : > "30s" }, "index" : { "type" : "fixed", > "min" : 4, "max" : 4, "queue\_size" : "200" > }, "get" : { "type" : "fixed", "min" : 4, > "max" : 4, "queue\_size" : "1k" }, "snapshot" : > { "type" : "scaling", "min" : 1, "max" : > 2, "keep\_alive" : "5m" }, "merge" : { > "type" : "scaling", "min" : 1, "max" : 2, > "keep\_alive" : "5m" }, "suggest" : { "type" : > "fixed", "min" : 4, "max" : 4, "queue\_size" : > "1k" }, "bulk" : { "type" : "fixed", "min" > : 4, "max" : 4, "queue\_size" : "50" }, > "optimize" : { "type" : "fixed", "min" : 1, > "max" : 1 }, "warmer" : { "type" : > "scaling", "min" : 1, "max" : 2, "keep\_alive" : > "5m" }, "flush" : { "type" : "scaling", > "min" : 1, "max" : 2, "keep\_alive" : "5m" > }, "search" : { "type" : "fixed", "min" : > 12, "max" : 12, "queue\_size" : "1k" }, > "percolate" : { "type" : "fixed", "min" : 4, > "max" : 4, "queue\_size" : "1k" }, "management" : > { "type" : "scaling", "min" : 1, "max" : > 5, "keep\_alive" : "5m" }, "refresh" : { > "type" : "scaling", "min" : 1, "max" : 2, > "keep\_alive" : "5m" } }, "network" : { > "refresh\_interval" : 5000, "primary\_interface" : { > "address" : "", "name" : "", "mac\_address" : "" > } }, "transport" : { "bound\_address" : > "inet[/0:0:0:0:0:0:0:0%0:9301]", "publish\_address" : > "inet[/10.126.122.28:9301 [http://10.126.122.28:9301](http://10.126.122.28:9301)]" }, > "plugins" : [] } }}_ > Any help is very very appreciated, > > Regards, -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/fc9b199a-fa30-449c-b65e-c1becb95a169%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/fc9b199a-fa30-449c-b65e-c1becb95a169%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 12:21am UTC](https://discuss.elastic.co/t/query-error-appearance/22772/3 "2017-07-06T00:21:43Z")
Closed on July 6, 2017, 12:21am UTC