Issue with ibis-server local development

[ongdisheng]

Problem

In the latest version, I get the following error as shown below when I pass the host value host.docker.internal from wren-ui frontend

2025-01-12 00:12:24.467 | [40cf2697-6721-4559-9b23-4cca5afb9a99] | INFO     | __init__.dispatch:29 - Request ended
2025-01-12 00:22:38.575 | [32a07901-22a5-4bbf-afe1-68a82e340048] | INFO     | __init__.dispatch:14 - POST /v2/connector/mysql/metadata/tables
2025-01-12 00:22:38.576 | [32a07901-22a5-4bbf-afe1-68a82e340048] | INFO     | __init__.dispatch:15 - Request params: {}
2025-01-12 00:22:38.576 | [32a07901-22a5-4bbf-afe1-68a82e340048] | INFO     | __init__.dispatch:22 - Request body: {"connectionInfo":"REDACTED"}
2025-01-12 00:22:48.619 | [32a07901-22a5-4bbf-afe1-68a82e340048] | ERROR    | __init__.dispatch:26 - Request failed
Traceback (most recent call last):
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\streams\memory.py", line 111, in receive
    return self.receive_nowait()
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\streams\memory.py", line 106, in receive_nowait
    raise WouldBlock
anyio.WouldBlock

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\streams\memory.py", line 124, in receive
    return receiver.item
AttributeError: 'MemoryObjectItemReceiver' object has no attribute 'item'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\middleware\base.py", line 157, in call_next
    message = await recv_stream.receive()
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\streams\memory.py", line 126, in receive
    raise EndOfStream
anyio.EndOfStream

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\multiprocessing\spawn.py", line 122, in spawn_main   
    exitcode = _main(fd, parent_sentinel)
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\multiprocessing\spawn.py", line 135, in _main        
    return self._bootstrap(parent_sentinel)
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\multiprocessing\process.py", line 314, in _bootstrap 
    self.run()
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\multiprocessing\process.py", line 108, in run        
    self._target(*self._args, **self._kwargs)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\uvicorn\_subprocess.py", line 80, in subprocess_started
    target(sockets=sockets)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\uvicorn\server.py", line 66, in run
    return asyncio.run(self.serve(sockets=sockets))
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\asyncio\runners.py", line 190, in run
    return runner.run(main)
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\asyncio\runners.py", line 118, in run
    return self._loop.run_until_complete(task)
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 641, in run_until_complete
    self.run_forever()
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 608, in run_forever    
    self._run_once()
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 1936, in _run_once     
    handle._run()
  File "C:\Users\DI SHENG\AppData\Local\Programs\Python\Python311\Lib\asyncio\events.py", line 84, in _run
    self._context.run(self._callback, *self._args)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\middleware\base.py", line 149, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\middleware\base.py", line 187, in __call__
    response = await self.dispatch_func(request, call_next)
> File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\middleware\__init__.py", line 24, in dispatch
    return await call_next(request)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\middleware\base.py", line 163, in call_next
    raise app_exc
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\middleware\base.py", line 149, in coro
    await self.app(scope, receive_or_disconnect, send_no_error)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\middleware\exceptions.py", line 62, in __call__
    await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\_exception_handler.py", line 53, in wrapped_app
    raise exc
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\_exception_handler.py", line 42, in wrapped_app
    await app(scope, receive, sender)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\routing.py", line 715, in __call__
    await self.middleware_stack(scope, receive, send)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\routing.py", line 735, in app
    await route.handle(scope, receive, send)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\routing.py", line 288, in handle
    await self.app(scope, receive, send)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\routing.py", line 76, in app
    await wrap_app_handling_exceptions(app, request)(scope, receive, send)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\_exception_handler.py", line 53, in wrapped_app
    raise exc
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\_exception_handler.py", line 42, in wrapped_app
    await app(scope, receive, sender)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\routing.py", line 73, in app
    response = await f(request)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\fastapi\routing.py", line 301, in app
    raw_response = await run_endpoint_function(
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\fastapi\routing.py", line 214, in run_endpoint_function
    return await run_in_threadpool(dependant.call, **values)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\starlette\concurrency.py", line 39, in run_in_threadpool
    return await anyio.to_thread.run_sync(func, *args)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\to_thread.py", line 56, in run_sync
    return await get_async_backend().run_sync_in_worker_thread(
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\_backends\_asyncio.py", line 2461, in run_sync_in_worker_thread
    return await future
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\anyio\_backends\_asyncio.py", line 962, in run
    result = context.run(func, *args)
  File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\routers\v2\connector.py", line 71, in get_table_list
    return MetadataFactory.get_metadata(
  File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\model\metadata\factory.py", line 30, in get_metadata
    return mapping[data_source](connection_info)
  File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\model\metadata\mysql.py", line 17, in __init__
    self.connection = DataSource.mysql.get_connection(connection_info)
  File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\model\data_source.py", line 50, in get_connection
    return DataSourceExtension[self].get_connection(info)
  File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\model\data_source.py", line 83, in get_connection
    return getattr(self, f"get_{self.name}_connection")(info)
  File "C:\Users\DI SHENG\Desktop\wren-engine\ibis-server\app\model\data_source.py", line 142, in get_mysql_connection     
    return ibis.mysql.connect(
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\ibis\__init__.py", line 110, in connect
    return backend.connect(*args, **kwargs)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\ibis\backends\__init__.py", line 936, in connect
    new_backend.reconnect()
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\ibis\backends\__init__.py", line 951, in reconnect
    self.do_connect(*self._con_args, **self._con_kwargs)
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\ibis\backends\mysql\__init__.py", line 151, in do_connect
    self.con = pymysql.connect(
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\pymysql\connections.py", line 361, in __init__
    self.connect()
  File "C:\Users\DI SHENG\AppData\Local\pypoetry\Cache\virtualenvs\wren-engine-DWg1NlVO-py3.11\Lib\site-packages\pymysql\connections.py", line 716, in connect
    raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'host.docker.internal' (timed out)")
      INFO   127.0.0.1:60628 - "POST /v2/connector/mysql/metadata/tables HTTP/1.1" 500

Additional Context

This only happens when I start the ibis-server locally, but not in ibis-server container started from here. This is not encountered in previous versions.

[ongdisheng]

BTW, I'm able to connect to mysql if I modify the host value to be localhost manually as shown below:

        return ibis.mysql.connect(
            host="localhost", # previously is info.host.get_secret_value()               
            port=int(info.port.get_secret_value()),
            database=info.database.get_secret_value(),
            user=info.user.get_secret_value(),
            password=info.password.get_secret_value()
        )