Hello, I’m using Astro CLI to run airflow locally, everything was working fine until suddenly, without any changes in the docker-compose.override.yml file or in any other system related files, it stopped working.
Apparently webserver container is unhealthy due to the postgres database container. The log that I’m getting from webserver is the following:
Waiting for host: postgres 5432
Logs from the postgres container are:
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
syncing data to disk ... ok
Success. You can now start the database server using:
pg_ctl -D /var/lib/postgresql/data -l logfile start
waiting for server to start....2024-10-10 17:19:25.405 UTC [47] LOG: starting PostgreSQL 12.6 (Debian 12.6-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2024-10-10 17:19:25.406 UTC [47] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-10-10 17:19:25.414 UTC [48] LOG: database system was shut down at 2024-10-10 17:19:25 UTC
2024-10-10 17:19:25.417 UTC [47] LOG: database system is ready to accept connections
done
server started
/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
waiting for server to shut down...2024-10-10 17:19:25.532 UTC [47] LOG: received fast shutdown request
.2024-10-10 17:19:25.534 UTC [47] LOG: aborting any active transactions
2024-10-10 17:19:25.537 UTC [47] LOG: background worker "logical replication launcher" (PID 54) exited with exit code 1
2024-10-10 17:19:25.538 UTC [49] LOG: shutting down
2024-10-10 17:19:25.555 UTC [47] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2024-10-10 17:19:25.642 UTC [1] LOG: starting PostgreSQL 12.6 (Debian 12.6-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2024-10-10 17:19:25.643 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2024-10-10 17:19:25.643 UTC [1] LOG: listening on IPv6 address "::", port 5432
2024-10-10 17:19:25.644 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-10-10 17:19:25.658 UTC [66] LOG: database system was shut down at 2024-10-10 17:19:25 UTC
2024-10-10 17:19:25.662 UTC [1] LOG: database system is ready to accept connections
I’ve already entered the webserver container and checked the connection to the postgres container using netcat, and everything worked fine. The same is true when trying to connect outside docker using localhost. As far as I understand, everything is working fine on the postgres side.
In addition, I’ve already looked into some docs:
- Airflow stuck in scheduler (airflow is starting up!) postgres 5432 error
- Astro dev init / astro dev start not working
Can anyone give me a hand to understand what is happening and what could have been the cause of this problem?
Thanks in advance.
Astro CLI Version: 1.28.1
Docker Version: 23.0.1
Docker Compose Version: 2.16.0
OS: Ubuntu 22.04.1 LTS