Amruth VVKP
03/06/2023, 8:21 PM2023-03-06 20:19:39 value = await result
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/connection.py", line 2092, in connect
2023-03-06 20:19:39 return await connect_utils._connect(
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 895, in _connect
2023-03-06 20:19:39 raise last_error
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 881, in _connect
2023-03-06 20:19:39 return await _connect_addr(
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 773, in _connect_addr
2023-03-06 20:19:39 return await __connect_addr(params, timeout, True, *args)
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 825, in __connect_addr
2023-03-06 20:19:39 tr, pr = await compat.wait_for(connector, timeout=timeout)
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/compat.py", line 56, in wait_for
2023-03-06 20:19:39 return await asyncio.wait_for(fut, timeout)
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/asyncio/tasks.py", line 445, in wait_for
2023-03-06 20:19:39 return fut.result()
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/site-packages/asyncpg/connect_utils.py", line 684, in _create_ssl_connection
2023-03-06 20:19:39 tr, pr = await loop.create_connection(
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/asyncio/base_events.py", line 1036, in create_connection
2023-03-06 20:19:39 infos = await self._ensure_resolved(
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/asyncio/base_events.py", line 1418, in _ensure_resolved
2023-03-06 20:19:39 return await loop.getaddrinfo(host, port, family=family, type=type,
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/asyncio/base_events.py", line 863, in getaddrinfo
2023-03-06 20:19:39 return await self.run_in_executor(
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/concurrent/futures/thread.py", line 58, in run
2023-03-06 20:19:39 result = self.fn(*self.args, **self.kwargs)
2023-03-06 20:19:39 File "/usr/local/lib/python3.10/socket.py", line 955, in getaddrinfo
2023-03-06 20:19:39 for res in _socket.getaddrinfo(host, port, family, type, proto, flags):
2023-03-06 20:19:39 socket.gaierror: [Errno -2] Name or service not known
2023-03-06 20:19:39
2023-03-06 20:19:39 Application startup failed. Exiting.
Here's my docker-compose -
version: '3.8'
networks:
prefect:
name: prefect
services:
# ------------------------------------------------------------- #
# PostgreSQL DB for Prefect DB #
# ------------------------------------------------------------- #
postgres:
image: postgres:latest
restart: always
command:
- postgres
- -c
- max_connections=150
environment:
- POSTGRES_USER=${POSTGRES_USER}
- POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
- POSTGRES_DB=${POSTGRES_DB}
healthcheck:
interval: 10s
retries: 60
start_period: 2s
test: pg_isready -q -d $${POSTGRES_DB} -U $${POSTGRES_USER} | grep "accepting connections" || exit 1
timeout: 2s
ports:
- 5432:5432
expose:
- 5432
# -------------------------------------- #
# Prefect Server #
# -------------------------------------- #
prefect-server:
image: prefecthq/prefect:2.8.4-python3.10
command:
- prefect
- server
- start
ports:
- 4200:4200
expose:
- 4200
environment:
PREFECT_API_DATABASE_CONNECTION_URL: postgresql+asyncpg://${POSTGRES_USER}:${POSTGRES_PASSWORD}@postgres:5432/${POSTGRES_DB}
networks:
- prefect
restart: always
depends_on:
postgres:
condition: service_started
Tyler Wanner
03/07/2023, 6:53 PMAmruth VVKP
03/07/2023, 6:53 PMTyler Wanner
03/07/2023, 6:54 PMAmruth VVKP
03/07/2023, 6:54 PMBob Samuels
05/17/2023, 3:38 PMAmruth VVKP
05/24/2023, 8:35 AM