Skip to content

[gemini-3-flash-on-alloydb-sustainability-app] #1846

@rusi-din

Description

@rusi-din

https://codelabs.developers.google.com/gemini-3-flash-on-alloydb-sustainability-app?hl=en#9

I get this error on the Demo... (https://neighbor-loop-uxu5wi2jpa-uc.a.run.app

{"details":"(pg8000.exceptions.InterfaceError) Can't create a connection to host 10.13.0.52 and port 5432 (timeout is None and source_address is None).\n(Background on this error at: https://sqlalche.me/e/20/rvf5)","error":"Failed to fetch items","traceback":"Traceback (most recent call last):\n File "/usr/local/lib/python3.12/site-packages/pg8000/core.py", line 204, in _make_socket\n sock = socket.create_connection((host, port), timeout, source_address)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/socket.py", line 865, in create_connection\n raise exceptions[0]\n File "/usr/local/lib/python3.12/socket.py", line 850, in create_connection\n sock.connect(sa)\nTimeoutError: [Errno 110] Operation timed out\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 143, in init\n self._dbapi_connection = engine.raw_connection()\n ^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3317, in raw_connection\n return self.pool.connect()\n ^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 448, in connect\n return _ConnectionFairy._checkout(self)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 1272, in _checkout\n fairy = _ConnectionRecord.checkout(pool)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 712, in checkout\n rec = pool._do_get()\n ^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get\n with util.safe_reraise():\n ^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 121, in exit\n raise exc_value.with_traceback(exc_tb)\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 175, in _do_get\n return self._create_connection()\n ^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 389, in _create_connection\n return _ConnectionRecord(self)\n ^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 674, in init\n self.__connect()\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 900, in __connect\n with util.safe_reraise():\n ^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 121, in exit\n raise exc_value.with_traceback(exc_tb)\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 896, in __connect\n self.dbapi_connection = connection = pool._invoke_creator(self)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/create.py", line 667, in connect\n return dialect.connect(*cargs_tup, **cparams)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 630, in connect\n return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/pg8000/init.py", line 112, in connect\n return Connection(\n ^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/pg8000/legacy.py", line 445, in init\n super().init(*args, **kwargs)\n File "/usr/local/lib/python3.12/site-packages/pg8000/core.py", line 328, in init\n self.channel_binding, self._usock = _make_socket(\n ^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/pg8000/core.py", line 206, in _make_socket\n raise InterfaceError(\npg8000.exceptions.InterfaceError: Can't create a connection to host 10.13.0.52 and port 5432 (timeout is None and source_address is None).\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n File "/app/app.py", line 73, in home\n with engine.connect() as conn:\n ^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3293, in connect\n return self._connection_cls(self)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 145, in init\n Connection._handle_dbapi_exception_noconnection(\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 2448, in _handle_dbapi_exception_noconnection\n raise sqlalchemy_exception.with_traceback(exc_info[2]) from e\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 143, in init\n self._dbapi_connection = engine.raw_connection()\n ^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 3317, in raw_connection\n return self.pool.connect()\n ^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 448, in connect\n return _ConnectionFairy._checkout(self)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 1272, in _checkout\n fairy = _ConnectionRecord.checkout(pool)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 712, in checkout\n rec = pool._do_get()\n ^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 177, in _do_get\n with util.safe_reraise():\n ^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 121, in exit\n raise exc_value.with_traceback(exc_tb)\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/impl.py", line 175, in _do_get\n return self._create_connection()\n ^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 389, in _create_connection\n return _ConnectionRecord(self)\n ^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 674, in init\n self.__connect()\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 900, in __connect\n with util.safe_reraise():\n ^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/util/langhelpers.py", line 121, in exit\n raise exc_value.with_traceback(exc_tb)\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/pool/base.py", line 896, in __connect\n self.dbapi_connection = connection = pool._invoke_creator(self)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/create.py", line 667, in connect\n return dialect.connect(*cargs_tup, **cparams)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 630, in connect\n return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/pg8000/init.py", line 112, in connect\n return Connection(\n ^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/pg8000/legacy.py", line 445, in init\n super().init(*args, **kwargs)\n File "/usr/local/lib/python3.12/site-packages/pg8000/core.py", line 328, in init\n self.channel_binding, self._usock = _make_socket(\n ^^^^^^^^^^^^^\n File "/usr/local/lib/python3.12/site-packages/pg8000/core.py", line 206, in _make_socket\n raise InterfaceError(\nsqlalchemy.exc.InterfaceError: (pg8000.exceptions.InterfaceError) Can't create a connection to host 10.13.0.52 and port 5432 (timeout is None and source_address is None).\n(Background on this error at: https://sqlalche.me/e/20/rvf5)\n"}

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions