Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]

when I searching this query using simpleQueryStringQuery,

GET books/_search
{
  "query":{
    "bool":{
      "must":[
        {"bool":{
          "should":[{
            "wildcard":{"vault-bpa-ui-url":{"wildcard":"http*","boost":1.0}}
          },{
            "wildcard":{"vault-cms-ui-url":{"wildcard":"http*","boost":1.0}}
            
          }],
          "adjust_pure_negative":true,
            "minimum_should_match":"1",
            "boost":1.0
        }},
    {"bool":{
      "should"
    :[{"wildcard":{"vault-bpa-ui-url":{"wildcard":"http*","boost":1.0}}},{"terms":{"withContent":[true],"boost":1.0}}],"adjust_pure_negative":true,"boost":1.0}}],"should":[{"simple_query_string":{"query":"9781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 9780471264989 9781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 97804712649899781118018354 9780470851166 9781405146012 9781405161688 9781405102544 9780471984269 9781119320869 9781119564089 9780470589410 9781118431986 9780471202752 9781119496489 9781118890943 9781119244912 9781119493549 9781119393986 9781119490203 9781119495185 9781119329350 9780470963197 9781119524496 9781119166771 9781119498377 9783433029268 9781118883822 9783527341498 9781405110440 9780471679516 9781118128541 9781118885680 9781119246008 9781119462576 9781119462552 9781118554401 9781405108577 9781405108201 9781405106306 9781405107853 9783527406616 9783527408153 9783527306565 9783527313600 9783527404506 9780471414827 9780471312888 9780471320715 9781118560686 9780471320142 9780471611752 9781118673034 9781118018354 9780470851166 9781405146012 9781405161688 9781118118870 9780471358688 9780471323006 9780471575368 9781841121420 9780471643425 9780471571032 9780471102151 9781118503218 9781118317105 9781118764237 9780471253877 9780471254072 9780471242116 0033122652ryn 9781119977186 9781119979500 9781119292128 9780471899730 9781119689584 9781119973195 9781119975908 9781119995081 9781405149907 9780471499558 9780471985495 9780471264989",
    "fields":["isbn^1.0","isbn10^1.0"],
    "flags":-1,
    "default_operator":"or",
    "lenient":true,
    "analyze_wildcard":false,
    "auto_generate_synonyms_phrase_query":true,
    "fuzzy_prefix_length":0,"fuzzy_max_expansions":0,
    "fuzzy_transpositions":false,"boost":1.0}}],
    "adjust_pure_negative":true,
    "minimum_should_match":"1","boost":1.0}},
    "track_total_hits":2147483647}

getting this error as follows,

"error" : {
    "root_cause" : [
      {
        "type" : "too_many_clauses",
        "reason" : "too_many_clauses: maxClauseCount is set to 1024"
      }
    ],
    "type" : "search_phase_execution_exception",
    "reason" : "all shards failed",
    "phase" : "query",
    "grouped" : true,

Elasticsearch version : 7.7

could you please help me to clarify this issue ?

Hi @Pamal_Jayawickrama

Look this post, similar problem.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.