https://prefect.io logo
Title
p

Pierre Monico

08/20/2021, 2:39 PM
After being able to install Prefect Server on a Ubuntu20.04 machine, I get errors when running
prefect server start
. It seems like there is a problem with the Postgres instance. First I get errors from the hasura and graphql containers (can’t connect to Postgres), and then some postgres debugging messages; but still the other services can’t connect after that. Did anyone run into that before?
Postgres logs:
postgres_1  | The files belonging to this database system will be owned by user "postgres".
postgres_1  | This user must also own the server process.
postgres_1  |
postgres_1  | The database cluster will be initialized with locale "en_US.utf8".
postgres_1  | The default database encoding has accordingly been set to "UTF8".
postgres_1  | The default text search configuration will be set to "english".
postgres_1  |
postgres_1  | Data page checksums are disabled.
postgres_1  |
postgres_1  | fixing permissions on existing directory /var/lib/postgresql/data ... ok
postgres_1  | creating subdirectories ... ok
postgres_1  | selecting default max_connections ... 100
postgres_1  | selecting default shared_buffers ... 128MB
postgres_1  | selecting default timezone ... Etc/UTC
postgres_1  | selecting dynamic shared memory implementation ... posix
postgres_1  | creating configuration files ... ok
postgres_1  | running bootstrap script ... ok
postgres_1  | performing post-bootstrap initialization ... ok
postgres_1  | syncing data to disk ...
postgres_1  | WARNING: enabling "trust" authentication for local connections
postgres_1  | You can change this by editing pg_hba.conf or using the option -A, or
postgres_1  | --auth-local and --auth-host, the next time you run initdb.
postgres_1  | ok
postgres_1  |
postgres_1  | Success. You can now start the database server using:
postgres_1  |
postgres_1  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
postgres_1  |
postgres_1  | waiting for server to start....2021-08-20 14:33:51.028 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1  | 2021-08-20 14:33:51.084 UTC [49] LOG:  database system was shut down at 2021-08-20 14:33:47 UTC
postgres_1  | 2021-08-20 14:33:51.104 UTC [48] LOG:  database system is ready to accept connections
postgres_1  |  done
postgres_1  | server started
postgres_1  | CREATE DATABASE
postgres_1  |
postgres_1  |
postgres_1  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgres_1  |
postgres_1  | waiting for server to shut down...2021-08-20 14:33:53.758 UTC [48] LOG:  received fast shutdown request
postgres_1  | .2021-08-20 14:33:53.783 UTC [48] LOG:  aborting any active transactions
postgres_1  | 2021-08-20 14:33:53.786 UTC [48] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
postgres_1  | 2021-08-20 14:33:53.787 UTC [50] LOG:  shutting down
postgres_1  | 2021-08-20 14:33:54.064 UTC [48] LOG:  database system is shut down
postgres_1  |  done
postgres_1  | server stopped
postgres_1  |
postgres_1  | PostgreSQL init process complete; ready for start up.
postgres_1  |
postgres_1  | 2021-08-20 14:33:54.205 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres_1  | 2021-08-20 14:33:54.205 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres_1  | 2021-08-20 14:33:54.249 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1  | 2021-08-20 14:33:54.330 UTC [76] LOG:  database system was shut down at 2021-08-20 14:33:53 UTC
postgres_1  | 2021-08-20 14:33:54.352 UTC [1] LOG:  database system is ready to accept connections
k

Kevin Kho

08/20/2021, 3:03 PM
Yeah looks like the main problem here is postgres. Maybe it’s worth to try older Prefect versions?
z

Zanie

08/20/2021, 3:13 PM
I think some of those logs are from the last shutdown which can be confusing
It looks like in the end, the database is ready to accept connections
p

Pierre Monico

08/20/2021, 3:43 PM
No no, just after it graphql still can’t connect
z

Zanie

08/20/2021, 4:07 PM
You'll have to provide more of the logs because postgres looks fine here
p

Pierre Monico

08/23/2021, 10:01 AM
Sure, hope this helps (sorry for late reply, didn’t have my work laptop this weekend)
Nevermind, seems like it’s working now!
:magic_wand: