kibana console returns match all result when search times out.

[iamgd67]

Kibana version:
7.17.8
Elasticsearch version:
7.17.8
Server OS version:
linux centos
Browser version:
chrome
Browser OS version:
windows
Original install method (e.g. download page, yum, from source, etc.):
docker
Describe the bug:
Complex search may take a lot of time. When configuring multiple ELASTICSEARCH_HOSTS, Kibana tries them one by one. However, since the body is a stream and cannot be re-read, the retry drops the body. This can cause the search results to be confusing and show a match for all.
Steps to reproduce:

1. Configure Docker Kibana with multiple Elasticsearch hosts (using environment variable ELASTICSEARCH_HOSTS) like ELASTICSEARCH_HOSTS=["host1:9200", "host2:9200"].
2. Open the console and create a complex search with a request body, such as using scripts that should time out.
3. After the first Elasticsearch node times out, Kibana tries the next node without sending the request body. The console will show search results that match all.

Expected behavior:
see timeout error
Screenshots (if relevant):

Errors in browser console (if relevant):
none
Provide logs and/or server output (if relevant):

{"type":"log","@timestamp":"2024-05-16T08:20:40+00:00","tags":["error","plugins","console"],"pid":7,"message":"Error: Client request timeout\n    at Timeout._onTimeout (/usr/share/kibana/src/plugins/console/server/lib/proxy_request.js:101:37)\n    at listOnTimeout (node:internal/timers:559:17)\n    at processTimers (node:internal/timers:502:7) {\n  data: null,\n  isBoom: true,\n  isServer: true,\n  output: {\n    statusCode: 504,\n    payload: {\n      statusCode: 504,\n      error: 'Gateway Time-out',\n      message: 'Client request timeout'\n    },\n    headers: {}\n  }\n}"}

Any additional context:

[elasticmachine]

Pinging @elastic/kibana-management (Team:Kibana Management)

[alisonelizabeth]

Hi @iamgd67 - this looks related to #160380

[iamgd67]

@alisonelizabeth yes it is. can't believe it's still not resolved after almost a year

[iamgd67]

close for dumplicated to #160380. thanks @alisonelizabeth for pointing this out.