# Update\_by\_query

**URL:** <https://discuss.elastic.co/t/update-by-query/323730>\
**Category:** Elasticsearch\
**Created:** [January 23, 2023, 1:06pm UTC](https://discuss.elastic.co/t/update-by-query/323730 "2023-01-23T13:06:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Srujan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srujan/32/116279_2.png) [@Srujan](https://discuss.elastic.co/u/Srujan)\
**Post date:** [January 23, 2023, 1:06pm UTC](https://discuss.elastic.co/t/update-by-query/323730/1 "2023-01-23T13:06:58Z")

</div>

I am new to Elasticsearch. I have a huge index with around 50k documents. I have to update all the document, when I run the update\_by\_query function it is throwing an error  
Traceback (most recent call last):  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\connectionpool.py", line 449, in \_make\_request  
six.raise\_from(e, None)  
File "", line 3, in raise\_from  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\connectionpool.py", line 444, in \_make\_request  
httplib\_response = conn.getresponse()  
^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\http\client.py", line 1374, in getresponse  
response.begin()  
File "E:\ApplicationsRunning\Lib\http\client.py", line 318, in begin  
version, status, reason = self.\_read\_status()  
^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\http\client.py", line 279, in \_read\_status  
line = str(self.fp.readline(\_MAXLINE + 1), "iso-8859-1")  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\socket.py", line 705, in readinto  
return self.\_sock.recv\_into(b)  
^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\ssl.py", line 1278, in recv\_into  
return self.read(nbytes, buffer)  
^^^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\ssl.py", line 1134, in read  
return self.\_sslobj.read(len, buffer)  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
TimeoutError: The read operation timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last):  
File "E:\ApplicationsRunning\Lib\site-packages\opensearchpy\connection\http\_urllib3.py", line 240, in perform\_request  
response = self.pool.urlopen(  
^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\connectionpool.py", line 787, in urlopen  
retries = retries.increment(  
^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\util\retry.py", line 525, in increment  
raise six.reraise(type(error), error, \_stacktrace)  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\packages\six.py", line 770, in reraise  
raise value  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\connectionpool.py", line 703, in urlopen  
httplib\_response = self.\_make\_request(  
^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\connectionpool.py", line 451, in \_make\_request  
self.\_raise\_timeout(err=e, url=url, timeout\_value=read\_timeout)  
File "E:\ApplicationsRunning\Lib\site-packages\urllib3\connectionpool.py", line 340, in \_raise\_timeout  
raise ReadTimeoutError(  
urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='localhost', port=9200): Read timed out. (read timeout=10)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):  
File "d:\RoxilerSystem\Assertion\DemoEnv\script.py", line 23, in   
response = client.update\_by\_query(  
^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\opensearchpy\client\utils.py", line 178, in _wrapped  
return func(\*args, params=params, headers=headers, \*\*kwargs)  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\opensearchpy\client\_init_.py", line 1897, in update\_by\_query  
return self.transport.perform\_request(  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\opensearchpy\transport.py", line 408, in perform\_request  
raise e  
File "E:\ApplicationsRunning\Lib\site-packages\opensearchpy\transport.py", line 369, in perform\_request  
status, headers\_response, data = connection.perform\_request(  
^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File "E:\ApplicationsRunning\Lib\site-packages\opensearchpy\connection\http\_urllib3.py", line 254, in perform\_request  
raise ConnectionTimeout("TIMEOUT", str(e), e)  
opensearchpy.exceptions.ConnectionTimeout: ConnectionTimeout caused by - ReadTimeoutError(HTTPSConnectionPool(host='localhost', port=9200): Read timed out. (read timeout=10)

can someone please help.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 20, 2023, 1:07pm UTC](https://discuss.elastic.co/t/update-by-query/323730/2 "2023-02-20T13:07:46Z")

</div>

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