httpx.ReadTimeout: The read operation timed out

[ishaqmahsud]

Describe the bug
to call vector search on 73k records supabase (python) failed due timeout error. please put option developer can increase or decrease timeout according situation. otherwise python library not worthful.

To Reproduce
the error can be produce to make embedding to search in huge records about 73k.

Expected behavior
i need to increate the timeout for the rpc method so it can easily with failed.
in JavaScript its working where it can takes 25 to 30 secs in python it failed.

Screenshots
Traceback (most recent call last):
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_transports\default.py", line 60, in map_httpcore_exceptions
yield
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_transports\default.py", line 218, in handle_request
resp = self._pool.handle_request(req)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\connection_pool.py", line 253, in handle_request
raise exc
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\connection_pool.py", line 237, in handle_request
response = connection.handle_request(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\connection.py", line 90, in handle_request
return self._connection.handle_request(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\http11.py", line 112, in handle_request
raise exc
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\http11.py", line 91, in handle_request
) = self._receive_response_headers(**kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\http11.py", line 155, in _receive_response_headers
event = self._receive_event(timeout=timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_sync\http11.py", line 191, in _receive_event
data = self._network_stream.read(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore\backends\sync.py", line 26, in read
with map_exceptions(exc_map):
File "C:\Users\ishaq\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 155, in exit
self.gen.throw(typ, value, traceback)
File "F:\fielder\textkernelfunc\Lib\site-packages\httpcore_exceptions.py", line 14, in map_exceptions
raise to_exc(exc)
httpcore.ReadTimeout: The read operation timed out

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "F:\fielder\textkernelfunc\dbhelper.py", line 249, in
rs = asyncio.run(job.getTopJobsByCV(tk_res['documentText']))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\ishaq\AppData\Local\Programs\Python\Python311\Lib\asyncio\runners.py", line 190, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "C:\Users\ishaq\AppData\Local\Programs\Python\Python311\Lib\asyncio\runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\ishaq\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 653, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\dbhelper.py", line 239, in getTopJobsByCV
response = self.connection.rpc('match_jobs', rpc_params).execute()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\postgrest_sync\request_builder.py", line 55, in execute
r = self.session.request(
^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_client.py", line 821, in request
return self.send(request, auth=auth, follow_redirects=follow_redirects)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_client.py", line 908, in send
response = self._send_handling_auth(
^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_client.py", line 936, in _send_handling_auth
response = self._send_handling_redirects(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_client.py", line 973, in _send_handling_redirects
response = self._send_single_request(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_client.py", line 1009, in _send_single_request
response = transport.handle_request(request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_transports\default.py", line 217, in handle_request
with map_httpcore_exceptions():
File "C:\Users\ishaq\AppData\Local\Programs\Python\Python311\Lib\contextlib.py", line 155, in exit
self.gen.throw(typ, value, traceback)
File "F:\fielder\textkernelfunc\Lib\site-packages\httpx_transports\default.py", line 77, in map_httpcore_exceptions
raise mapped_exc(message) from exc
httpx.ReadTimeout: The read operation timed out

Desktop (please complete the following information):

• windows 10
  -vs code
• python 3.11

[macrochel]

from supabase import create_client, Client
from supabase.lib.client_options import ClientOptions

client_options = ClientOptions(postgrest_client_timeout=None)
supabase: Client = create_client(url, key, options=client_options)

[m3hari]

+1
Supabse starts throwing this error out of nowhere; we don't have any change. Maybe the size of the table is affecting

[git-shogg]

from supabase import create_client, Client
from supabase.lib.client_options import ClientOptions

client_options = ClientOptions(postgrest_client_timeout=None)
supabase: Client = create_client(url, key, options=client_options)

For the above workaround I am receiving the error below:
TypeError: ClientOptions.__init__() got an unexpected keyword argument 'DEFAULT_POSTGREST_CLIENT_TIMEOUT'

Any ideas on this one?